PREVIEW / futures_1hour / 2024-03-10
file: by_date/futures_1hour/2024/2024-03-10.parquet size: 18 KB rows: 389
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-03-10 18:00:00 | ES | Futures | 5514.17 | 5514.17 | 5498.86 | 5499.12 | 7243.0 |
| 2024-03-10 19:00:00 | ES | Futures | 5499.66 | 5510.94 | 5499.12 | 5510.94 | 12059.0 |
| 2024-03-10 20:00:00 | ES | Futures | 5510.67 | 5512.82 | 5504.5 | 5506.64 | 15614.0 |
| 2024-03-10 21:00:00 | ES | Futures | 5506.38 | 5514.97 | 5506.38 | 5507.72 | 5320.0 |
| 2024-03-10 22:00:00 | ES | Futures | 5507.72 | 5508.79 | 5503.96 | 5505.03 | 4867.0 |
| 2024-03-10 23:00:00 | ES | Futures | 5505.3 | 5507.45 | 5499.66 | 5500.2 | 2446.0 |
| 2024-03-10 18:00:00 | NQ | Futures | 19587.55 | 19600.84 | 19499.95 | 19501.85 | 6256.0 |
| 2024-03-10 19:00:00 | NQ | Futures | 19503.48 | 19574.81 | 19503.48 | 19572.91 | 4960.0 |
| 2024-03-10 20:00:00 | NQ | Futures | 19574.81 | 19577.52 | 19538.47 | 19545.79 | 4034.0 |
| 2024-03-10 21:00:00 | NQ | Futures | 19545.25 | 19586.47 | 19543.89 | 19556.37 | 3833.0 |
| 2024-03-10 22:00:00 | NQ | Futures | 19556.91 | 19563.42 | 19537.11 | 19538.19 | 3340.0 |
| 2024-03-10 23:00:00 | NQ | Futures | 19539.28 | 19552.3 | 19516.23 | 19519.21 | 2611.0 |
| 2024-03-10 18:00:00 | YM | Futures | 41650.6 | 41662.3 | 41567.8 | 41573.1 | 1373.0 |
| 2024-03-10 19:00:00 | YM | Futures | 41574.1 | 41621.9 | 41569.9 | 41621.9 | 1479.0 |
| 2024-03-10 20:00:00 | YM | Futures | 41619.8 | 41633.6 | 41587.9 | 41597.5 | 1280.0 |
| 2024-03-10 21:00:00 | YM | Futures | 41598.6 | 41642.1 | 41596.4 | 41599.6 | 866.0 |
| 2024-03-10 22:00:00 | YM | Futures | 41599.6 | 41602.8 | 41571.0 | 41579.4 | 754.0 |
| 2024-03-10 23:00:00 | YM | Futures | 41580.5 | 41591.1 | 41543.4 | 41545.5 | 605.0 |
| 2024-03-10 18:00:00 | CL | Futures | 65.12 | 65.27 | 65.06 | 65.11 | 1319.0 |
| 2024-03-10 19:00:00 | CL | Futures | 65.1 | 65.13 | 65.02 | 65.12 | 822.0 |
| 2024-03-10 20:00:00 | CL | Futures | 65.12 | 65.17 | 64.94 | 64.97 | 1296.0 |
| 2024-03-10 21:00:00 | CL | Futures | 64.97 | 64.97 | 64.66 | 64.78 | 5439.0 |
| 2024-03-10 22:00:00 | CL | Futures | 64.78 | 64.81 | 64.68 | 64.72 | 1180.0 |
| 2024-03-10 23:00:00 | CL | Futures | 64.72 | 64.89 | 64.72 | 64.81 | 969.0 |
| 2024-03-10 18:00:00 | GC | Futures | 2397.7 | 2398.8 | 2393.8 | 2393.8 | 2744.0 |
| 2024-03-10 19:00:00 | GC | Futures | 2393.9 | 2401.0 | 2393.8 | 2398.5 | 7156.0 |
| 2024-03-10 20:00:00 | GC | Futures | 2398.5 | 2406.4 | 2396.1 | 2403.8 | 7440.0 |
| 2024-03-10 21:00:00 | GC | Futures | 2403.9 | 2404.0 | 2395.6 | 2396.9 | 7727.0 |
| 2024-03-10 22:00:00 | GC | Futures | 2396.9 | 2397.1 | 2393.1 | 2393.8 | 3054.0 |
| 2024-03-10 23:00:00 | GC | Futures | 2393.8 | 2397.1 | 2393.3 | 2396.1 | 3015.0 |
| 2024-03-10 18:00:00 | ZN | Futures | 112.655146 | 112.670893 | 112.592157 | 112.639398 | 9243.0 |
| 2024-03-10 19:00:00 | ZN | Futures | 112.623651 | 112.670893 | 112.623651 | 112.639398 | 6036.0 |
| 2024-03-10 20:00:00 | ZN | Futures | 112.655146 | 112.718134 | 112.639398 | 112.718134 | 13543.0 |
| 2024-03-10 21:00:00 | ZN | Futures | 112.718134 | 112.812617 | 112.702387 | 112.749629 | 26031.0 |
| 2024-03-10 22:00:00 | ZN | Futures | 112.765376 | 112.765376 | 112.718134 | 112.718134 | 11514.0 |
| 2024-03-10 23:00:00 | ZN | Futures | 112.718134 | 112.749629 | 112.718134 | 112.733881 | 3761.0 |
> showing 36 of 389 rows — these rows as CSV