PREVIEW / futures_1hour / 2023-03-19
file: by_date/futures_1hour/2023/2023-03-19.parquet size: 20 KB rows: 432
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-19 18:00:00 | ES | Futures | 4397.44 | 4411.86 | 4384.96 | 4401.88 | 39511.0 |
| 2023-03-19 19:00:00 | ES | Futures | 4401.88 | 4409.64 | 4395.22 | 4405.48 | 15845.0 |
| 2023-03-19 20:00:00 | ES | Futures | 4405.48 | 4413.52 | 4404.93 | 4410.2 | 20503.0 |
| 2023-03-19 21:00:00 | ES | Futures | 4409.92 | 4409.92 | 4389.67 | 4394.94 | 21475.0 |
| 2023-03-19 22:00:00 | ES | Futures | 4394.94 | 4399.1 | 4390.78 | 4396.33 | 10941.0 |
| 2023-03-19 23:00:00 | ES | Futures | 4396.33 | 4396.61 | 4382.18 | 4384.4 | 13401.0 |
| 2023-03-19 18:00:00 | NQ | Futures | 14291.63 | 14359.2 | 14260.94 | 14305.43 | 13636.0 |
| 2023-03-19 19:00:00 | NQ | Futures | 14305.15 | 14327.11 | 14286.0 | 14309.93 | 5752.0 |
| 2023-03-19 20:00:00 | NQ | Futures | 14309.93 | 14333.86 | 14308.52 | 14315.28 | 6340.0 |
| 2023-03-19 21:00:00 | NQ | Futures | 14315.0 | 14315.0 | 14253.34 | 14275.02 | 8583.0 |
| 2023-03-19 22:00:00 | NQ | Futures | 14273.61 | 14293.6 | 14268.26 | 14293.04 | 5048.0 |
| 2023-03-19 23:00:00 | NQ | Futures | 14293.6 | 14295.01 | 14259.25 | 14265.17 | 5765.0 |
| 2023-03-19 18:00:00 | YM | Futures | 35526.8 | 35670.5 | 35482.6 | 35605.3 | 4598.0 |
| 2023-03-19 19:00:00 | YM | Futures | 35605.3 | 35679.4 | 35557.8 | 35657.2 | 3366.0 |
| 2023-03-19 20:00:00 | YM | Futures | 35658.4 | 35711.4 | 35651.7 | 35692.6 | 2819.0 |
| 2023-03-19 21:00:00 | YM | Futures | 35691.5 | 35691.5 | 35547.8 | 35568.8 | 2905.0 |
| 2023-03-19 22:00:00 | YM | Futures | 35571.0 | 35596.5 | 35534.6 | 35553.3 | 1730.0 |
| 2023-03-19 23:00:00 | YM | Futures | 35553.3 | 35556.7 | 35438.4 | 35451.7 | 3289.0 |
| 2023-03-19 18:00:00 | CL | Futures | 54.26 | 54.83 | 53.95 | 54.61 | 4391.0 |
| 2023-03-19 19:00:00 | CL | Futures | 54.61 | 54.66 | 54.36 | 54.56 | 1651.0 |
| 2023-03-19 20:00:00 | CL | Futures | 54.55 | 54.68 | 54.46 | 54.55 | 2387.0 |
| 2023-03-19 21:00:00 | CL | Futures | 54.54 | 54.91 | 54.36 | 54.41 | 7534.0 |
| 2023-03-19 22:00:00 | CL | Futures | 54.41 | 54.58 | 54.25 | 54.28 | 3111.0 |
| 2023-03-19 23:00:00 | CL | Futures | 54.28 | 54.32 | 53.98 | 54.01 | 3877.0 |
| 2023-03-19 18:00:00 | GC | Futures | 2310.5 | 2316.1 | 2298.3 | 2300.8 | 11562.0 |
| 2023-03-19 19:00:00 | GC | Futures | 2300.9 | 2303.5 | 2299.2 | 2300.3 | 2860.0 |
| 2023-03-19 20:00:00 | GC | Futures | 2300.5 | 2302.1 | 2294.9 | 2295.1 | 5510.0 |
| 2023-03-19 21:00:00 | GC | Futures | 2295.2 | 2296.3 | 2290.9 | 2292.8 | 10404.0 |
| 2023-03-19 22:00:00 | GC | Futures | 2292.9 | 2299.9 | 2292.3 | 2299.1 | 5353.0 |
| 2023-03-19 23:00:00 | GC | Futures | 2299.0 | 2299.9 | 2296.2 | 2297.2 | 3743.0 |
| 2023-03-19 18:00:00 | ZN | Futures | 118.220287 | 118.620979 | 118.108093 | 118.156176 | 43602.0 |
| 2023-03-19 19:00:00 | ZN | Futures | 118.156176 | 118.204259 | 118.124121 | 118.156176 | 34485.0 |
| 2023-03-19 20:00:00 | ZN | Futures | 118.172204 | 118.284398 | 117.739456 | 117.85165 | 69526.0 |
| 2023-03-19 21:00:00 | ZN | Futures | 117.85165 | 118.140148 | 117.787539 | 118.043982 | 30270.0 |
| 2023-03-19 22:00:00 | ZN | Futures | 118.043982 | 118.252342 | 117.995899 | 118.188232 | 13646.0 |
| 2023-03-19 23:00:00 | ZN | Futures | 118.204259 | 118.556869 | 118.156176 | 118.396592 | 26463.0 |
> showing 36 of 432 rows — these rows as CSV