PREVIEW / futures_1hour / 2024-01-28
file: by_date/futures_1hour/2024/2024-01-28.parquet size: 19 KB rows: 443
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-28 18:00:00 | ES | Futures | 5273.78 | 5275.39 | 5266.26 | 5268.94 | 13884.0 |
| 2024-01-28 19:00:00 | ES | Futures | 5268.94 | 5271.63 | 5268.14 | 5271.09 | 5808.0 |
| 2024-01-28 20:00:00 | ES | Futures | 5271.36 | 5277.81 | 5271.09 | 5277.27 | 9819.0 |
| 2024-01-28 21:00:00 | ES | Futures | 5277.54 | 5277.81 | 5274.58 | 5276.19 | 4131.0 |
| 2024-01-28 22:00:00 | ES | Futures | 5276.46 | 5278.61 | 5274.58 | 5277.27 | 4860.0 |
| 2024-01-28 23:00:00 | ES | Futures | 5277.27 | 5277.54 | 5276.19 | 5276.73 | 2514.0 |
| 2024-01-28 18:00:00 | NQ | Futures | 18986.56 | 18986.56 | 18938.29 | 18962.43 | 7974.0 |
| 2024-01-28 19:00:00 | NQ | Futures | 18962.7 | 18982.77 | 18961.88 | 18980.32 | 4666.0 |
| 2024-01-28 20:00:00 | NQ | Futures | 18980.32 | 19025.62 | 18980.32 | 19024.26 | 7991.0 |
| 2024-01-28 21:00:00 | NQ | Futures | 19024.26 | 19028.6 | 19010.43 | 19021.82 | 4382.0 |
| 2024-01-28 22:00:00 | NQ | Futures | 19022.09 | 19035.65 | 19010.43 | 19027.24 | 5612.0 |
| 2024-01-28 23:00:00 | NQ | Futures | 19026.97 | 19028.6 | 19016.94 | 19017.75 | 2397.0 |
| 2024-01-28 18:00:00 | YM | Futures | 41039.4 | 41052.3 | 40983.6 | 40998.6 | 2093.0 |
| 2024-01-28 19:00:00 | YM | Futures | 40999.7 | 41002.9 | 40991.1 | 41000.8 | 866.0 |
| 2024-01-28 20:00:00 | YM | Futures | 40999.7 | 41030.8 | 40996.5 | 41025.5 | 1002.0 |
| 2024-01-28 21:00:00 | YM | Futures | 41025.5 | 41026.5 | 41009.4 | 41015.8 | 423.0 |
| 2024-01-28 22:00:00 | YM | Futures | 41018.0 | 41025.5 | 41010.4 | 41023.3 | 462.0 |
| 2024-01-28 23:00:00 | YM | Futures | 41022.2 | 41027.6 | 41019.0 | 41023.3 | 261.0 |
| 2024-01-28 18:00:00 | CL | Futures | 65.99 | 66.32 | 65.84 | 65.98 | 10149.0 |
| 2024-01-28 19:00:00 | CL | Futures | 65.98 | 66.01 | 65.53 | 65.57 | 4682.0 |
| 2024-01-28 20:00:00 | CL | Futures | 65.57 | 65.73 | 65.28 | 65.5 | 8479.0 |
| 2024-01-28 21:00:00 | CL | Futures | 65.51 | 65.61 | 65.4 | 65.53 | 2563.0 |
| 2024-01-28 22:00:00 | CL | Futures | 65.53 | 65.63 | 65.45 | 65.58 | 1423.0 |
| 2024-01-28 23:00:00 | CL | Futures | 65.58 | 65.68 | 65.57 | 65.66 | 775.0 |
| 2024-01-28 18:00:00 | GC | Futures | 2239.2 | 2244.5 | 2236.0 | 2236.4 | 4770.0 |
| 2024-01-28 19:00:00 | GC | Futures | 2236.4 | 2236.5 | 2233.4 | 2235.8 | 1655.0 |
| 2024-01-28 20:00:00 | GC | Futures | 2235.7 | 2240.0 | 2235.3 | 2237.4 | 2169.0 |
| 2024-01-28 21:00:00 | GC | Futures | 2237.5 | 2239.8 | 2235.4 | 2239.7 | 1782.0 |
| 2024-01-28 22:00:00 | GC | Futures | 2239.7 | 2240.7 | 2238.3 | 2240.0 | 1634.0 |
| 2024-01-28 23:00:00 | GC | Futures | 2240.0 | 2242.1 | 2239.7 | 2240.7 | 1442.0 |
| 2024-01-28 18:00:00 | ZN | Futures | 112.813916 | 112.861437 | 112.703034 | 112.718875 | 24398.0 |
| 2024-01-28 19:00:00 | ZN | Futures | 112.734715 | 112.798076 | 112.718875 | 112.782236 | 14385.0 |
| 2024-01-28 20:00:00 | ZN | Futures | 112.782236 | 112.813916 | 112.734715 | 112.734715 | 14071.0 |
| 2024-01-28 21:00:00 | ZN | Futures | 112.750555 | 112.798076 | 112.687194 | 112.798076 | 20190.0 |
| 2024-01-28 22:00:00 | ZN | Futures | 112.782236 | 112.782236 | 112.734715 | 112.734715 | 6687.0 |
| 2024-01-28 23:00:00 | ZN | Futures | 112.734715 | 112.813916 | 112.734715 | 112.798076 | 5946.0 |
> showing 36 of 443 rows — these rows as CSV