PREVIEW / futures_1hour / 2021-06-23
file: by_date/futures_1hour/2021/2021-06-23.parquet size: 61 KB rows: 1,916
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-06-23 00:00:00 | ES | Futures | 4778.73 | 4779.58 | 4777.32 | 4777.32 | 2251.0 |
| 2021-06-23 01:00:00 | ES | Futures | 4777.61 | 4784.36 | 4776.76 | 4782.11 | 6518.0 |
| 2021-06-23 02:00:00 | ES | Futures | 4782.39 | 4784.93 | 4778.73 | 4782.39 | 9679.0 |
| 2021-06-23 03:00:00 | ES | Futures | 4782.39 | 4783.24 | 4773.1 | 4775.07 | 17531.0 |
| 2021-06-23 04:00:00 | ES | Futures | 4775.07 | 4777.32 | 4773.1 | 4775.07 | 9197.0 |
| 2021-06-23 05:00:00 | ES | Futures | 4775.07 | 4775.35 | 4770.57 | 4773.1 | 10152.0 |
| 2021-06-23 06:00:00 | ES | Futures | 4773.38 | 4776.48 | 4770.85 | 4772.54 | 10079.0 |
| 2021-06-23 07:00:00 | ES | Futures | 4772.26 | 4773.1 | 4765.22 | 4771.41 | 18521.0 |
| 2021-06-23 08:00:00 | ES | Futures | 4771.41 | 4777.89 | 4770.57 | 4777.32 | 20641.0 |
| 2021-06-23 09:00:00 | ES | Futures | 4777.04 | 4779.58 | 4770.85 | 4777.61 | 145662.0 |
| 2021-06-23 10:00:00 | ES | Futures | 4777.32 | 4782.67 | 4773.1 | 4776.76 | 137172.0 |
| 2021-06-23 11:00:00 | ES | Futures | 4776.48 | 4778.73 | 4769.16 | 4773.66 | 105667.0 |
| 2021-06-23 12:00:00 | ES | Futures | 4773.66 | 4775.63 | 4766.91 | 4771.97 | 65755.0 |
| 2021-06-23 13:00:00 | ES | Futures | 4771.97 | 4777.04 | 4770.85 | 4776.76 | 56820.0 |
| 2021-06-23 14:00:00 | ES | Futures | 4776.76 | 4776.76 | 4772.26 | 4774.51 | 53603.0 |
| 2021-06-23 15:00:00 | ES | Futures | 4774.51 | 4779.86 | 4764.93 | 4766.34 | 166339.0 |
| 2021-06-23 16:00:00 | ES | Futures | 4766.06 | 4769.72 | 4765.78 | 4768.31 | 42489.0 |
| 2021-06-23 18:00:00 | ES | Futures | 4768.59 | 4771.97 | 4766.34 | 4770.85 | 4380.0 |
| 2021-06-23 19:00:00 | ES | Futures | 4770.85 | 4772.82 | 4769.44 | 4772.54 | 4908.0 |
| 2021-06-23 20:00:00 | ES | Futures | 4772.54 | 4775.63 | 4771.97 | 4774.79 | 9142.0 |
| 2021-06-23 21:00:00 | ES | Futures | 4774.51 | 4778.45 | 4774.23 | 4777.04 | 9772.0 |
| 2021-06-23 22:00:00 | ES | Futures | 4777.32 | 4778.73 | 4776.76 | 4777.61 | 4650.0 |
| 2021-06-23 23:00:00 | ES | Futures | 4777.89 | 4778.73 | 4776.2 | 4778.45 | 2895.0 |
| 2021-06-23 00:00:00 | NQ | Futures | 16561.37 | 16562.82 | 16553.84 | 16554.13 | 1690.0 |
| 2021-06-23 01:00:00 | NQ | Futures | 16554.13 | 16585.7 | 16550.07 | 16576.14 | 4018.0 |
| 2021-06-23 02:00:00 | NQ | Futures | 16576.43 | 16579.33 | 16558.18 | 16560.5 | 4916.0 |
| 2021-06-23 03:00:00 | NQ | Futures | 16561.08 | 16566.58 | 16523.71 | 16534.14 | 8456.0 |
| 2021-06-23 04:00:00 | NQ | Futures | 16533.27 | 16541.09 | 16520.23 | 16529.21 | 4888.0 |
| 2021-06-23 05:00:00 | NQ | Futures | 16529.5 | 16538.48 | 16513.86 | 16528.92 | 5299.0 |
| 2021-06-23 06:00:00 | NQ | Futures | 16529.21 | 16547.17 | 16521.68 | 16533.27 | 4076.0 |
| 2021-06-23 07:00:00 | NQ | Futures | 16533.27 | 16535.59 | 16499.09 | 16526.9 | 9561.0 |
| 2021-06-23 08:00:00 | NQ | Futures | 16526.61 | 16545.72 | 16520.23 | 16537.9 | 8480.0 |
| 2021-06-23 09:00:00 | NQ | Futures | 16537.61 | 16583.38 | 16514.44 | 16576.14 | 58791.0 |
| 2021-06-23 10:00:00 | NQ | Futures | 16575.85 | 16588.02 | 16529.21 | 16542.25 | 62564.0 |
| 2021-06-23 11:00:00 | NQ | Futures | 16542.54 | 16556.73 | 16512.12 | 16552.68 | 43975.0 |
| 2021-06-23 12:00:00 | NQ | Futures | 16552.97 | 16558.47 | 16490.69 | 16524.29 | 31275.0 |
| 2021-06-23 13:00:00 | NQ | Futures | 16524.58 | 16551.52 | 16515.31 | 16548.62 | 23249.0 |
| 2021-06-23 14:00:00 | NQ | Futures | 16548.04 | 16554.7 | 16526.32 | 16547.75 | 23175.0 |
| 2021-06-23 15:00:00 | NQ | Futures | 16547.46 | 16562.53 | 16515.89 | 16527.18 | 42952.0 |
| 2021-06-23 16:00:00 | NQ | Futures | 16527.18 | 16543.41 | 16525.74 | 16539.93 | 7027.0 |
| 2021-06-23 18:00:00 | NQ | Futures | 16541.09 | 16548.91 | 16535.01 | 16545.43 | 1438.0 |
| 2021-06-23 19:00:00 | NQ | Futures | 16546.01 | 16554.13 | 16538.77 | 16554.13 | 1718.0 |
| 2021-06-23 20:00:00 | NQ | Futures | 16553.84 | 16568.61 | 16552.39 | 16562.53 | 3379.0 |
| 2021-06-23 21:00:00 | NQ | Futures | 16561.95 | 16574.98 | 16558.47 | 16568.61 | 3283.0 |
| 2021-06-23 22:00:00 | NQ | Futures | 16569.48 | 16571.8 | 16562.82 | 16567.74 | 2331.0 |
| 2021-06-23 23:00:00 | NQ | Futures | 16568.03 | 16579.04 | 16562.82 | 16575.56 | 2057.0 |
| 2021-06-23 00:00:00 | YM | Futures | 37882.7 | 37899.4 | 37874.8 | 37881.5 | 921.0 |
| 2021-06-23 01:00:00 | YM | Futures | 37882.7 | 37925.1 | 37877.1 | 37913.9 | 1911.0 |
| 2021-06-23 02:00:00 | YM | Futures | 37913.9 | 37944.1 | 37891.6 | 37930.7 | 1976.0 |
| 2021-06-23 03:00:00 | YM | Futures | 37932.9 | 37943.0 | 37848.0 | 37864.8 | 3640.0 |
> showing 50 of 1,916 rows — these rows as CSV