0101001010001010100110001000101010000110101010000100000011101 000110100101101101011001010111001101110100011000010110110101110000001011000010000001100010 011 // 0101001010001010100110001000101010000110101010000100000011101 000110100101101101011001010111001101110100011000010110110101110000001011000010000001100010 011 // 0101001010001010100110001000101010000110101010000100000011101 000110100101101101011001010111001101110100011000010110110101110000001011000010000001100010 011 // 0101001010001010100110001000101010000110101010000100000011101 000110100101101101011001010111001101110100011000010110110101110000001011000010000001100010 011
01100100 01010010100010101001100010001010100001 SELECT * FROM trades 00000011101 WHERE symbol in ('AAPL', 'NVDA') 010101000 LATEST ON timestamp PARTITION BY symbol 0010 01101001 01100100 // 01100100 01010010100010101001100010001010100001 SELECT * FROM trades 00000011101 WHERE symbol in ('AAPL', 'NVDA') 010101000 LATEST ON timestamp PARTITION BY symbol 0010 01101001 01100100 // 01100100 01010010100010101001100010001010100001 SELECT * FROM trades 00000011101 WHERE symbol in ('AAPL', 'NVDA') 010101000 LATEST ON timestamp PARTITION BY symbol 0010 01101001 01100100 // 01100100 01010010100010101001100010001010100001 SELECT * FROM trades 00000011101 WHERE symbol in ('AAPL', 'NVDA') 010101000 LATEST ON timestamp PARTITION BY symbol 0010 01101001 01100100
0101001010001010100110 0010001010100001101010100001000 first(price) AS open, 11001 010111001101110100011000010110110101110000001011000010000001100010 // 0101001010001010100110 0010001010100001101010100001000 first(price) AS open, 11001 010111001101110100011000010110110101110000001011000010000001100010 // 0101001010001010100110 0010001010100001101010100001000 first(price) AS open, 11001 010111001101110100011000010110110101110000001011000010000001100010 // 0101001010001010100110 0010001010100001101010100001000 first(price) AS open, 11001 010111001101110100011000010110110101110000001011000010000001100010
01101001 01100100 01010010100010101 last(price) AS close, 00110001000100 0001100010 01101001 01100100 01010010100010101001100010001010100001 // 01101001 01100100 01010010100010101 last(price) AS close, 00110001000100 0001100010 01101001 01100100 01010010100010101001100010001010100001 // 01101001 01100100 01010010100010101 last(price) AS close, 00110001000100 0001100010 01101001 01100100 01010010100010101001100010001010100001 // 01101001 01100100 01010010100010101 last(price) AS close, 00110001000100 0001100010 01101001 01100100 01010010100010101001100010001010100001
10101010000100000011101 000110100101101101011001010111001100110010010 min(price) AS low, 011001 010111001101110100011000010110110101110000001011000010000001100010 // 10101010000100000011101 000110100101101101011001010111001100110010010 min(price) AS low, 011001 010111001101110100011000010110110101110000001011000010000001100010 // 10101010000100000011101 000110100101101101011001010111001100110010010 min(price) AS low, 011001 010111001101110100011000010110110101110000001011000010000001100010 // 10101010000100000011101 000110100101101101011001010111001100110010010 min(price) AS low, 011001 010111001101110100011000010110110101110000001011000010000001100010
01101001 01100100 01100010001010100 max(price) AS high, 0011 010101000 0100000011101 01000000111010 011010010110110101100101011100110111010001100 // 01101001 01100100 01100010001010100 max(price) AS high, 0011 010101000 0100000011101 01000000111010 011010010110110101100101011100110111010001100 // 01101001 01100100 01100010001010100 max(price) AS high, 0011 010101000 0100000011101 01000000111010 011010010110110101100101011100110111010001100 // 01101001 01100100 01100010001010100 max(price) AS high, 0011 010101000 0100000011101 01000000111010 011010010110110101100101011100110111010001100
01101001 01100100 01010010100010101001100010001010100001101010100001000000111101 0011 sum(amount) AS volume // 01101001 01100100 01010010100010101001100010001010100001101010100001000000111101 0011 sum(amount) AS volume // 01101001 01100100 01010010100010101001100010001010100001101010100001000000111101 0011 sum(amount) AS volume // 01101001 01100100 01010010100010101001100010001010100001101010100001000000111101 0011 sum(amount) AS volume
01101 101011001010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades // 01101 101011001010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades // 01101 101011001010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades // 01101 101011001010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades
0000011101 0001100010 01101001 01100100 01010010100010101001100010001010100001 WHERE symbol = 'MSFT' AND timestamp IN today() 0000 1011000010000001100010 // 0000011101 0001100010 01101001 01100100 01010010100010101001100010001010100001 WHERE symbol = 'MSFT' AND timestamp IN today() 0000 1011000010000001100010 // 0000011101 0001100010 01101001 01100100 01010010100010101001100010001010100001 WHERE symbol = 'MSFT' AND timestamp IN today() 0000 1011000010000001100010 // 0000011101 0001100010 01101001 01100100 01010010100010101001100010001010100001 WHERE symbol = 'MSFT' AND timestamp IN today() 0000 1011000010000001100010
01101001 011001000101001010001010100110001000101010000110101010000100000011101 01 SAMPLE BY 15m 0110 001000101010000110101010000100000011101 000110100101101101011001 // 01101001 011001000101001010001010100110001000101010000110101010000100000011101 01 SAMPLE BY 15m 0110 001000101010000110101010000100000011101 000110100101101101011001 // 01101001 011001000101001010001010100110001000101010000110101010000100000011101 01 SAMPLE BY 15m 0110 001000101010000110101010000100000011101 000110100101101101011001 // 01101001 011001000101001010001010100110001000101010000110101010000100000011101 01 SAMPLE BY 15m 0110 001000101010000110101010000100000011101 000110100101101101011001
01000101010000110101 SELECT timestamp 00000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010 // 01000101010000110101 SELECT timestamp 00000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010 // 01000101010000110101 SELECT timestamp 00000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010 // 01000101010000110101 SELECT timestamp 00000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010
15m 0101001010001010100110 001000101010000110101010000100000011101 SELECT timestamp time, symbol, price as priceAAPL, avg(price) over (PARTITION BY symbol ORDER BY timestamp RANGE between 30 days PRECEDING AND CURRENT ROW) moving_avg_30_days // 15m 0101001010001010100110 001000101010000110101010000100000011101 SELECT timestamp time, symbol, price as priceAAPL, avg(price) over (PARTITION BY symbol ORDER BY timestamp RANGE between 30 days PRECEDING AND CURRENT ROW) moving_avg_30_days // 15m 0101001010001010100110 001000101010000110101010000100000011101 SELECT timestamp time, symbol, price as priceAAPL, avg(price) over (PARTITION BY symbol ORDER BY timestamp RANGE between 30 days PRECEDING AND CURRENT ROW) moving_avg_30_days // 15m 0101001010001010100110 001000101010000110101010000100000011101 SELECT timestamp time, symbol, price as priceAAPL, avg(price) over (PARTITION BY symbol ORDER BY timestamp RANGE between 30 days PRECEDING AND CURRENT ROW) moving_avg_30_days
010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades 00100000011101 // 010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades 00100000011101 // 010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades 00100000011101 // 010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades 00100000011101
01100100 01010010100010101001100010001010100001 10101010000100000011101 WHERE timestamp > dateadd('M', -1, now()) 100110111010001100 0101110000001011000010 000000101100 // 01100100 01010010100010101001100010001010100001 10101010000100000011101 WHERE timestamp > dateadd('M', -1, now()) 100110111010001100 0101110000001011000010 000000101100 // 01100100 01010010100010101001100010001010100001 10101010000100000011101 WHERE timestamp > dateadd('M', -1, now()) 100110111010001100 0101110000001011000010 000000101100 // 01100100 01010010100010101001100010001010100001 10101010000100000011101 WHERE timestamp > dateadd('M', -1, now()) 100110111010001100 0101110000001011000010 000000101100
000001100010 01101001 01100100 0101001010001010100110001000101010000110101010000100000011101 001100010 01101001 01100100 AND symbol = 'AMZN'; // 000001100010 01101001 01100100 0101001010001010100110001000101010000110101010000100000011101 001100010 01101001 01100100 AND symbol = 'AMZN'; // 000001100010 01101001 01100100 0101001010001010100110001000101010000110101010000100000011101 001100010 01101001 01100100 AND symbol = 'AMZN'; // 000001100010 01101001 01100100 0101001010001010100110001000101010000110101010000100000011101 001100010 01101001 01100100 AND symbol = 'AMZN';
0101001010001010100110 001000101010000110101010000100000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 // 0101001010001010100110 001000101010000110101010000100000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 // 0101001010001010100110 001000101010000110101010000100000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 // 0101001010001010100110 001000101010000110101010000100000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100
01101001 01100100 01010010100010101 last(price) AS close, 00110001000100 0001100010 01101001 01100100 01010010100010101001100010001010100001 // 01101001 01100100 01010010100010101 last(price) AS close, 00110001000100 0001100010 01101001 01100100 01010010100010101001100010001010100001 // 01101001 01100100 01010010100010101 last(price) AS close, 00110001000100 0001100010 01101001 01100100 01010010100010101001100010001010100001 // 01101001 01100100 01010010100010101 last(price) AS close, 00110001000100 0001100010 01101001 01100100 01010010100010101001100010001010100001
10101010000100000011101 000110100101101101011001010111001100110010010 min(price) AS low, 011001 010111001101110100011000010110110101110000001011000010000001100010 // 10101010000100000011101 000110100101101101011001010111001100110010010 min(price) AS low, 011001 010111001101110100011000010110110101110000001011000010000001100010 // 10101010000100000011101 000110100101101101011001010111001100110010010 min(price) AS low, 011001 010111001101110100011000010110110101110000001011000010000001100010 // 10101010000100000011101 000110100101101101011001010111001100110010010 min(price) AS low, 011001 010111001101110100011000010110110101110000001011000010000001100010
01101001 01100100 01100010001010100 max(price) AS high, 0011 010101000 0100000011101 01000000111010 011010010110110101100101011100110111010001100 // 01101001 01100100 01100010001010100 max(price) AS high, 0011 010101000 0100000011101 01000000111010 011010010110110101100101011100110111010001100 // 01101001 01100100 01100010001010100 max(price) AS high, 0011 010101000 0100000011101 01000000111010 011010010110110101100101011100110111010001100 // 01101001 01100100 01100010001010100 max(price) AS high, 0011 010101000 0100000011101 01000000111010 011010010110110101100101011100110111010001100
01101001 01100100 01010010100010101001100010001010100001101010100001000000111101 0011 sum(amount) AS volume // 01101001 01100100 01010010100010101001100010001010100001101010100001000000111101 0011 sum(amount) AS volume // 01101001 01100100 01010010100010101001100010001010100001101010100001000000111101 0011 sum(amount) AS volume // 01101001 01100100 01010010100010101001100010001010100001101010100001000000111101 0011 sum(amount) AS volume
01101 101011001010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades // 01101 101011001010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades // 01101 101011001010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades // 01101 101011001010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades
0000011101 0001100010 01101001 01100100 01010010100010101001100010001010100001 WHERE symbol = 'MSFT' AND timestamp IN today() 0000 1011000010000001100010 // 0000011101 0001100010 01101001 01100100 01010010100010101001100010001010100001 WHERE symbol = 'MSFT' AND timestamp IN today() 0000 1011000010000001100010 // 0000011101 0001100010 01101001 01100100 01010010100010101001100010001010100001 WHERE symbol = 'MSFT' AND timestamp IN today() 0000 1011000010000001100010 // 0000011101 0001100010 01101001 01100100 01010010100010101001100010001010100001 WHERE symbol = 'MSFT' AND timestamp IN today() 0000 1011000010000001100010
01101001 011001000101001010001010100110001000101010000110101010000100000011101 01 SAMPLE BY 15m 0110 001000101010000110101010000100000011101 000110100101101101011001 // 01101001 011001000101001010001010100110001000101010000110101010000100000011101 01 SAMPLE BY 15m 0110 001000101010000110101010000100000011101 000110100101101101011001 // 01101001 011001000101001010001010100110001000101010000110101010000100000011101 01 SAMPLE BY 15m 0110 001000101010000110101010000100000011101 000110100101101101011001 // 01101001 011001000101001010001010100110001000101010000110101010000100000011101 01 SAMPLE BY 15m 0110 001000101010000110101010000100000011101 000110100101101101011001
01000101010000110101 SELECT timestamp 00000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010 // 01000101010000110101 SELECT timestamp 00000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010 // 01000101010000110101 SELECT timestamp 00000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010 // 01000101010000110101 SELECT timestamp 00000011101 000110100101101101011001 010111001101110100011000010110110101110000001011000010000001100010
15m 0101001010001010100110 001000101010000110101010000100000011101 SELECT timestamp time, symbol, price as priceAAPL, avg(price) over (PARTITION BY symbol ORDER BY timestamp RANGE between 30 days PRECEDING AND CURRENT ROW) moving_avg_30_days // 15m 0101001010001010100110 001000101010000110101010000100000011101 SELECT timestamp time, symbol, price as priceAAPL, avg(price) over (PARTITION BY symbol ORDER BY timestamp RANGE between 30 days PRECEDING AND CURRENT ROW) moving_avg_30_days // 15m 0101001010001010100110 001000101010000110101010000100000011101 SELECT timestamp time, symbol, price as priceAAPL, avg(price) over (PARTITION BY symbol ORDER BY timestamp RANGE between 30 days PRECEDING AND CURRENT ROW) moving_avg_30_days // 15m 0101001010001010100110 001000101010000110101010000100000011101 SELECT timestamp time, symbol, price as priceAAPL, avg(price) over (PARTITION BY symbol ORDER BY timestamp RANGE between 30 days PRECEDING AND CURRENT ROW) moving_avg_30_days
010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades 00100000011101 // 010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades 00100000011101 // 010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades 00100000011101 // 010111001101110100011000010110110101110000001011000010000001100010 01101001 01100100 010100101000101010011000100010101000011010101000010 FROM trades 00100000011101
