PREVIEW / futures_1hour / 2020-09-13
file: by_date/futures_1hour/2020/2020-09-13.parquet size: 17 KB rows: 355
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 |
|---|---|---|---|---|---|---|---|
| 2020-09-13 18:00:00 | ES | Futures | 3741.86 | 3752.2 | 3736.84 | 3749.4 | 5252.0 |
| 2020-09-13 19:00:00 | ES | Futures | 3749.4 | 3755.27 | 3743.82 | 3754.71 | 3947.0 |
| 2020-09-13 20:00:00 | ES | Futures | 3754.71 | 3755.27 | 3748.84 | 3753.59 | 2817.0 |
| 2020-09-13 21:00:00 | ES | Futures | 3753.03 | 3760.85 | 3752.2 | 3760.57 | 3471.0 |
| 2020-09-13 22:00:00 | ES | Futures | 3760.57 | 3768.11 | 3760.29 | 3766.44 | 4102.0 |
| 2020-09-13 23:00:00 | ES | Futures | 3766.72 | 3772.3 | 3766.16 | 3768.39 | 2956.0 |
| 2020-09-13 18:00:00 | NQ | Futures | 12844.15 | 12953.46 | 12844.15 | 12929.46 | 3569.0 |
| 2020-09-13 19:00:00 | NQ | Futures | 12931.2 | 12947.68 | 12903.15 | 12940.16 | 2296.0 |
| 2020-09-13 20:00:00 | NQ | Futures | 12938.72 | 12941.32 | 12912.4 | 12923.68 | 2498.0 |
| 2020-09-13 21:00:00 | NQ | Futures | 12923.39 | 12945.94 | 12915.58 | 12945.94 | 2190.0 |
| 2020-09-13 22:00:00 | NQ | Futures | 12945.94 | 12987.3 | 12943.34 | 12982.96 | 3051.0 |
| 2020-09-13 23:00:00 | NQ | Futures | 12982.38 | 13004.94 | 12976.6 | 12981.8 | 2094.0 |
| 2020-09-13 18:00:00 | YM | Futures | 30488.6 | 30616.8 | 30488.6 | 30594.7 | 1582.0 |
| 2020-09-13 19:00:00 | YM | Futures | 30593.6 | 30627.9 | 30547.2 | 30620.1 | 898.0 |
| 2020-09-13 20:00:00 | YM | Futures | 30622.3 | 30633.4 | 30580.3 | 30617.9 | 1013.0 |
| 2020-09-13 21:00:00 | YM | Futures | 30616.8 | 30680.9 | 30611.3 | 30679.8 | 1063.0 |
| 2020-09-13 22:00:00 | YM | Futures | 30680.9 | 30734.0 | 30676.5 | 30707.5 | 1369.0 |
| 2020-09-13 23:00:00 | YM | Futures | 30707.5 | 30753.9 | 30706.4 | 30719.6 | 1046.0 |
| 2020-09-13 18:00:00 | CL | Futures | 25.92 | 26.1 | 25.74 | 25.92 | 898.0 |
| 2020-09-13 19:00:00 | CL | Futures | 25.92 | 26.01 | 25.9 | 26.0 | 175.0 |
| 2020-09-13 20:00:00 | CL | Futures | 26.0 | 26.1 | 25.96 | 25.97 | 361.0 |
| 2020-09-13 21:00:00 | CL | Futures | 25.96 | 26.04 | 25.93 | 26.04 | 373.0 |
| 2020-09-13 22:00:00 | CL | Futures | 26.04 | 26.14 | 26.03 | 26.12 | 562.0 |
| 2020-09-13 23:00:00 | CL | Futures | 26.12 | 26.17 | 26.09 | 26.11 | 221.0 |
| 2020-09-13 18:00:00 | GC | Futures | 2370.2 | 2373.7 | 2365.7 | 2370.7 | 2644.0 |
| 2020-09-13 19:00:00 | GC | Futures | 2370.8 | 2372.2 | 2370.4 | 2371.6 | 1285.0 |
| 2020-09-13 20:00:00 | GC | Futures | 2371.6 | 2372.2 | 2368.1 | 2368.7 | 1803.0 |
| 2020-09-13 21:00:00 | GC | Futures | 2368.7 | 2379.9 | 2368.7 | 2379.9 | 8676.0 |
| 2020-09-13 22:00:00 | GC | Futures | 2379.9 | 2382.7 | 2379.2 | 2381.7 | 6097.0 |
| 2020-09-13 23:00:00 | GC | Futures | 2381.6 | 2384.3 | 2380.2 | 2380.8 | 3508.0 |
| 2020-09-13 18:00:00 | ZN | Futures | 139.413255 | 139.444465 | 139.382045 | 139.39765 | 6610.0 |
| 2020-09-13 19:00:00 | ZN | Futures | 139.39765 | 139.413255 | 139.382045 | 139.39765 | 3865.0 |
| 2020-09-13 20:00:00 | ZN | Futures | 139.39765 | 139.460069 | 139.382045 | 139.460069 | 10675.0 |
| 2020-09-13 21:00:00 | ZN | Futures | 139.460069 | 139.475674 | 139.42886 | 139.42886 | 9728.0 |
| 2020-09-13 22:00:00 | ZN | Futures | 139.42886 | 139.444465 | 139.413255 | 139.42886 | 8247.0 |
| 2020-09-13 23:00:00 | ZN | Futures | 139.42886 | 139.42886 | 139.382045 | 139.39765 | 5096.0 |
> showing 36 of 355 rows — these rows as CSV