PREVIEW / futures_1hour / 2021-11-14
file: by_date/futures_1hour/2021/2021-11-14.parquet size: 19 KB rows: 411
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-11-14 18:00:00 | ES | Futures | 5288.38 | 5293.74 | 5285.56 | 5288.66 | 9521.0 |
| 2021-11-14 19:00:00 | ES | Futures | 5288.66 | 5291.76 | 5286.68 | 5289.51 | 6350.0 |
| 2021-11-14 20:00:00 | ES | Futures | 5289.51 | 5289.79 | 5286.68 | 5286.97 | 5792.0 |
| 2021-11-14 21:00:00 | ES | Futures | 5287.25 | 5288.66 | 5286.4 | 5286.4 | 3242.0 |
| 2021-11-14 22:00:00 | ES | Futures | 5286.12 | 5286.68 | 5282.17 | 5282.45 | 5103.0 |
| 2021-11-14 23:00:00 | ES | Futures | 5282.45 | 5283.3 | 5279.91 | 5283.3 | 4480.0 |
| 2021-11-14 18:00:00 | NQ | Futures | 18794.35 | 18827.68 | 18792.03 | 18810.58 | 5973.0 |
| 2021-11-14 19:00:00 | NQ | Futures | 18811.45 | 18827.68 | 18809.13 | 18817.54 | 3820.0 |
| 2021-11-14 20:00:00 | NQ | Futures | 18818.12 | 18821.6 | 18810.29 | 18816.96 | 2793.0 |
| 2021-11-14 21:00:00 | NQ | Futures | 18817.25 | 18821.31 | 18806.81 | 18807.97 | 2370.0 |
| 2021-11-14 22:00:00 | NQ | Futures | 18807.1 | 18807.97 | 18792.9 | 18800.44 | 2675.0 |
| 2021-11-14 23:00:00 | NQ | Futures | 18799.86 | 18806.81 | 18786.53 | 18797.54 | 2060.0 |
| 2021-11-14 18:00:00 | YM | Futures | 40418.8 | 40450.2 | 40397.5 | 40407.6 | 1595.0 |
| 2021-11-14 19:00:00 | YM | Futures | 40408.7 | 40430.0 | 40389.7 | 40413.2 | 1172.0 |
| 2021-11-14 20:00:00 | YM | Futures | 40409.8 | 40416.6 | 40380.7 | 40384.1 | 1226.0 |
| 2021-11-14 21:00:00 | YM | Futures | 40384.1 | 40402.0 | 40382.9 | 40391.9 | 494.0 |
| 2021-11-14 22:00:00 | YM | Futures | 40388.5 | 40390.8 | 40349.3 | 40351.5 | 936.0 |
| 2021-11-14 23:00:00 | YM | Futures | 40351.5 | 40362.8 | 40338.1 | 40362.8 | 724.0 |
| 2021-11-14 18:00:00 | CL | Futures | 56.39 | 56.71 | 56.34 | 56.59 | 1579.0 |
| 2021-11-14 19:00:00 | CL | Futures | 56.59 | 56.64 | 56.46 | 56.51 | 449.0 |
| 2021-11-14 20:00:00 | CL | Futures | 56.49 | 56.57 | 56.0 | 56.08 | 2967.0 |
| 2021-11-14 21:00:00 | CL | Futures | 56.06 | 56.15 | 55.98 | 55.98 | 995.0 |
| 2021-11-14 22:00:00 | CL | Futures | 55.98 | 56.02 | 55.87 | 55.93 | 1215.0 |
| 2021-11-14 23:00:00 | CL | Futures | 55.95 | 56.08 | 55.92 | 56.06 | 523.0 |
| 2021-11-14 18:00:00 | GC | Futures | 2254.2 | 2254.2 | 2247.4 | 2248.7 | 2666.0 |
| 2021-11-14 19:00:00 | GC | Futures | 2248.8 | 2249.4 | 2246.4 | 2246.6 | 1641.0 |
| 2021-11-14 20:00:00 | GC | Futures | 2246.8 | 2249.5 | 2238.7 | 2242.5 | 8874.0 |
| 2021-11-14 21:00:00 | GC | Futures | 2242.5 | 2244.8 | 2240.5 | 2241.7 | 3653.0 |
| 2021-11-14 22:00:00 | GC | Futures | 2241.6 | 2241.7 | 2237.6 | 2238.2 | 3294.0 |
| 2021-11-14 23:00:00 | GC | Futures | 2238.2 | 2241.0 | 2237.8 | 2240.5 | 2066.0 |
| 2021-11-14 18:00:00 | ZN | Futures | 133.451967 | 133.451967 | 133.372151 | 133.436004 | 10805.0 |
| 2021-11-14 19:00:00 | ZN | Futures | 133.436004 | 133.51582 | 133.420041 | 133.451967 | 13551.0 |
| 2021-11-14 20:00:00 | ZN | Futures | 133.46793 | 133.611599 | 133.46793 | 133.579672 | 19459.0 |
| 2021-11-14 21:00:00 | ZN | Futures | 133.579672 | 133.611599 | 133.547746 | 133.595635 | 11389.0 |
| 2021-11-14 22:00:00 | ZN | Futures | 133.579672 | 133.611599 | 133.547746 | 133.579672 | 7154.0 |
| 2021-11-14 23:00:00 | ZN | Futures | 133.579672 | 133.595635 | 133.51582 | 133.531783 | 6022.0 |
> showing 36 of 411 rows — these rows as CSV