Untitled

a guest

Apr 12th, 2019

122

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

text 1.50 KB | None | 0 0

raw download clone embed print report

# std::sort + clang7
SELECT max(t1.price - t2.price)
FROM
(
SELECT *
FROM trades
WHERE (market = 'BINANCE') AND (base = 'BTC') AND (counter = 'USDT')
) AS t1
ASOF LEFT JOIN
(
SELECT *
FROM trades
WHERE (market != 'BINANCE') AND (base = 'BTC') AND (counter = 'USDT')
) AS t2 USING (type, datetime)
WHERE t2.datetime > 0
┌─max(minus(price, t2.price))─┐
│ 148.6574999999998 │
└─────────────────────────────┘
1 rows in set. Elapsed: 2.468 sec. Processed 20.15 million rows, 994.22 MB (8.17 million rows/s., 402.85 MB/s.)
1 rows in set. Elapsed: 2.468 sec. Processed 20.15 million rows, 994.22 MB (8.17 million rows/s., 402.85 MB/s.)
# radix + clang7
SELECT max(t1.price - t2.price)
FROM
(
SELECT *
FROM trades
WHERE (market = 'BINANCE') AND (base = 'BTC') AND (counter = 'USDT')
) AS t1
ASOF LEFT JOIN
(
SELECT *
FROM trades
WHERE (market != 'BINANCE') AND (base = 'BTC') AND (counter = 'USDT')
) AS t2 USING (type, datetime)
WHERE t2.datetime > 0
┌─max(minus(price, t2.price))─┐
│ 158.23770000000013 │
└─────────────────────────────┘
1 rows in set. Elapsed: 1.894 sec. Processed 20.15 million rows, 994.22 MB (10.64 million rows/s., 525.06 MB/s.)
1 rows in set. Elapsed: 1.968 sec. Processed 20.15 million rows, 994.22 MB (10.24 million rows/s., 505.31 MB/s.)

Add Comment

Please, Sign In to add comment