PREVIEW / futures_1hour / 2021-01-22
file: by_date/futures_1hour/2021/2021-01-22.parquet size: 52 KB rows: 1,549
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2021-01-22 00:00:00 | ES | Futures | 4306.83 | 4309.07 | 4304.58 | 4305.7 | 4500.0 |
| 2021-01-22 01:00:00 | ES | Futures | 4305.98 | 4307.67 | 4302.05 | 4303.46 | 5406.0 |
| 2021-01-22 02:00:00 | ES | Futures | 4303.46 | 4305.42 | 4297.84 | 4300.09 | 11385.0 |
| 2021-01-22 03:00:00 | ES | Futures | 4300.09 | 4300.65 | 4289.14 | 4298.97 | 31702.0 |
| 2021-01-22 04:00:00 | ES | Futures | 4298.97 | 4301.21 | 4285.21 | 4289.14 | 28594.0 |
| 2021-01-22 05:00:00 | ES | Futures | 4289.42 | 4293.63 | 4285.5 | 4287.18 | 18632.0 |
| 2021-01-22 06:00:00 | ES | Futures | 4287.18 | 4289.99 | 4282.41 | 4287.46 | 24574.0 |
| 2021-01-22 07:00:00 | ES | Futures | 4287.74 | 4290.55 | 4281.0 | 4288.3 | 25127.0 |
| 2021-01-22 08:00:00 | ES | Futures | 4288.3 | 4292.23 | 4283.81 | 4289.42 | 30349.0 |
| 2021-01-22 09:00:00 | ES | Futures | 4289.14 | 4305.14 | 4288.3 | 4303.46 | 163032.0 |
| 2021-01-22 10:00:00 | ES | Futures | 4303.18 | 4307.95 | 4291.11 | 4301.49 | 167963.0 |
| 2021-01-22 11:00:00 | ES | Futures | 4301.21 | 4312.44 | 4299.81 | 4311.32 | 115350.0 |
| 2021-01-22 12:00:00 | ES | Futures | 4311.32 | 4313.84 | 4307.39 | 4309.91 | 76089.0 |
| 2021-01-22 13:00:00 | ES | Futures | 4309.91 | 4312.72 | 4303.74 | 4307.11 | 59938.0 |
| 2021-01-22 14:00:00 | ES | Futures | 4306.83 | 4313.0 | 4304.58 | 4312.72 | 78589.0 |
| 2021-01-22 15:00:00 | ES | Futures | 4312.72 | 4316.65 | 4301.77 | 4302.9 | 173610.0 |
| 2021-01-22 16:00:00 | ES | Futures | 4302.9 | 4305.98 | 4299.81 | 4299.81 | 65833.0 |
| 2021-01-22 00:00:00 | NQ | Futures | 15460.39 | 15467.34 | 15446.5 | 15453.74 | 2841.0 |
| 2021-01-22 01:00:00 | NQ | Futures | 15452.87 | 15466.76 | 15438.97 | 15456.92 | 2391.0 |
| 2021-01-22 02:00:00 | NQ | Futures | 15456.92 | 15463.0 | 15445.63 | 15452.0 | 3348.0 |
| 2021-01-22 03:00:00 | NQ | Futures | 15451.71 | 15459.52 | 15426.82 | 15450.84 | 9023.0 |
| 2021-01-22 04:00:00 | NQ | Futures | 15450.55 | 15452.87 | 15410.9 | 15429.71 | 7428.0 |
| 2021-01-22 05:00:00 | NQ | Futures | 15430.0 | 15440.71 | 15415.53 | 15420.16 | 5218.0 |
| 2021-01-22 06:00:00 | NQ | Futures | 15420.45 | 15430.58 | 15404.82 | 15425.66 | 6049.0 |
| 2021-01-22 07:00:00 | NQ | Futures | 15426.53 | 15438.68 | 15398.16 | 15421.03 | 8623.0 |
| 2021-01-22 08:00:00 | NQ | Futures | 15421.03 | 15428.84 | 15403.66 | 15423.63 | 8662.0 |
| 2021-01-22 09:00:00 | NQ | Futures | 15423.34 | 15502.07 | 15421.61 | 15494.26 | 67511.0 |
| 2021-01-22 10:00:00 | NQ | Futures | 15493.97 | 15504.1 | 15424.5 | 15456.92 | 78795.0 |
| 2021-01-22 11:00:00 | NQ | Futures | 15457.21 | 15486.73 | 15440.71 | 15477.18 | 46595.0 |
| 2021-01-22 12:00:00 | NQ | Futures | 15477.18 | 15488.18 | 15458.66 | 15464.73 | 28611.0 |
| 2021-01-22 13:00:00 | NQ | Futures | 15464.44 | 15487.6 | 15443.61 | 15464.44 | 28726.0 |
| 2021-01-22 14:00:00 | NQ | Futures | 15465.02 | 15502.65 | 15456.05 | 15500.04 | 26090.0 |
| 2021-01-22 15:00:00 | NQ | Futures | 15499.76 | 15510.18 | 15459.81 | 15461.84 | 41970.0 |
| 2021-01-22 16:00:00 | NQ | Futures | 15462.42 | 15473.71 | 15448.24 | 15461.84 | 11005.0 |
| 2021-01-22 00:00:00 | YM | Futures | 34369.5 | 34391.7 | 34354.0 | 34361.8 | 1095.0 |
| 2021-01-22 01:00:00 | YM | Futures | 34361.8 | 34378.4 | 34341.8 | 34341.8 | 1486.0 |
| 2021-01-22 02:00:00 | YM | Futures | 34341.8 | 34355.1 | 34289.7 | 34314.1 | 3831.0 |
| 2021-01-22 03:00:00 | YM | Futures | 34314.1 | 34316.3 | 34207.6 | 34287.4 | 7480.0 |
| 2021-01-22 04:00:00 | YM | Futures | 34288.5 | 34321.8 | 34176.5 | 34205.4 | 5790.0 |
| 2021-01-22 05:00:00 | YM | Futures | 34208.7 | 34244.2 | 34182.1 | 34194.3 | 3281.0 |
| 2021-01-22 06:00:00 | YM | Futures | 34195.4 | 34219.8 | 34153.2 | 34196.5 | 4740.0 |
| 2021-01-22 07:00:00 | YM | Futures | 34197.6 | 34223.1 | 34153.2 | 34213.1 | 4543.0 |
| 2021-01-22 08:00:00 | YM | Futures | 34213.1 | 34248.6 | 34190.9 | 34227.5 | 4080.0 |
| 2021-01-22 09:00:00 | YM | Futures | 34225.3 | 34288.5 | 34212.0 | 34267.5 | 18242.0 |
| 2021-01-22 10:00:00 | YM | Futures | 34268.6 | 34303.0 | 34167.6 | 34244.2 | 19527.0 |
| 2021-01-22 11:00:00 | YM | Futures | 34245.3 | 34368.4 | 34236.4 | 34361.8 | 14949.0 |
| 2021-01-22 12:00:00 | YM | Futures | 34361.8 | 34383.9 | 34334.0 | 34366.2 | 9088.0 |
| 2021-01-22 13:00:00 | YM | Futures | 34367.3 | 34382.8 | 34318.5 | 34336.2 | 6965.0 |
| 2021-01-22 14:00:00 | YM | Futures | 34337.4 | 34352.9 | 34317.4 | 34342.9 | 7249.0 |
| 2021-01-22 15:00:00 | YM | Futures | 34342.9 | 34371.7 | 34263.0 | 34268.6 | 12766.0 |
> showing 50 of 1,549 rows — these rows as CSV