PREVIEW / futures_1hour / 2024-03-18
file: by_date/futures_1hour/2024/2024-03-18.parquet size: 65 KB rows: 2,064
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-18 00:00:00 | ES | Futures | 5511.52 | 5514.44 | 5510.99 | 5513.38 | 3527.0 |
| 2024-03-18 01:00:00 | ES | Futures | 5513.64 | 5516.29 | 5513.11 | 5515.5 | 4096.0 |
| 2024-03-18 02:00:00 | ES | Futures | 5515.76 | 5517.35 | 5514.97 | 5515.23 | 4170.0 |
| 2024-03-18 03:00:00 | ES | Futures | 5515.23 | 5516.82 | 5511.52 | 5512.05 | 7919.0 |
| 2024-03-18 04:00:00 | ES | Futures | 5512.05 | 5520.54 | 5509.66 | 5520.27 | 16710.0 |
| 2024-03-18 05:00:00 | ES | Futures | 5520.01 | 5521.86 | 5515.23 | 5518.15 | 9995.0 |
| 2024-03-18 06:00:00 | ES | Futures | 5518.42 | 5522.4 | 5516.56 | 5520.8 | 10712.0 |
| 2024-03-18 07:00:00 | ES | Futures | 5520.54 | 5540.7 | 5519.21 | 5538.31 | 34791.0 |
| 2024-03-18 08:00:00 | ES | Futures | 5538.31 | 5545.48 | 5538.31 | 5540.17 | 34864.0 |
| 2024-03-18 09:00:00 | ES | Futures | 5540.17 | 5553.97 | 5540.17 | 5543.09 | 210346.0 |
| 2024-03-18 10:00:00 | ES | Futures | 5543.35 | 5560.86 | 5542.56 | 5557.15 | 192123.0 |
| 2024-03-18 11:00:00 | ES | Futures | 5557.15 | 5557.95 | 5543.62 | 5547.33 | 130598.0 |
| 2024-03-18 12:00:00 | ES | Futures | 5547.07 | 5550.25 | 5538.84 | 5539.64 | 106554.0 |
| 2024-03-18 13:00:00 | ES | Futures | 5539.64 | 5547.33 | 5536.99 | 5542.29 | 111461.0 |
| 2024-03-18 14:00:00 | ES | Futures | 5542.56 | 5548.93 | 5535.93 | 5542.29 | 103194.0 |
| 2024-03-18 15:00:00 | ES | Futures | 5542.29 | 5546.27 | 5529.03 | 5534.33 | 232934.0 |
| 2024-03-18 16:00:00 | ES | Futures | 5534.33 | 5536.19 | 5529.56 | 5533.54 | 58428.0 |
| 2024-03-18 18:00:00 | ES | Futures | 5534.33 | 5535.39 | 5525.31 | 5526.91 | 6659.0 |
| 2024-03-18 19:00:00 | ES | Futures | 5526.91 | 5529.29 | 5523.99 | 5528.76 | 5748.0 |
| 2024-03-18 20:00:00 | ES | Futures | 5529.03 | 5529.56 | 5522.93 | 5523.72 | 6592.0 |
| 2024-03-18 21:00:00 | ES | Futures | 5523.72 | 5525.05 | 5520.8 | 5524.25 | 6403.0 |
| 2024-03-18 22:00:00 | ES | Futures | 5524.25 | 5529.03 | 5524.25 | 5526.64 | 4754.0 |
| 2024-03-18 23:00:00 | ES | Futures | 5526.64 | 5532.74 | 5521.6 | 5526.37 | 10658.0 |
| 2024-03-18 00:00:00 | NQ | Futures | 19394.31 | 19411.7 | 19391.37 | 19407.15 | 2691.0 |
| 2024-03-18 01:00:00 | NQ | Futures | 19407.42 | 19430.42 | 19404.47 | 19426.68 | 3994.0 |
| 2024-03-18 02:00:00 | NQ | Futures | 19426.95 | 19437.91 | 19422.4 | 19425.07 | 3583.0 |
| 2024-03-18 03:00:00 | NQ | Futures | 19425.34 | 19441.12 | 19416.24 | 19418.12 | 6072.0 |
| 2024-03-18 04:00:00 | NQ | Futures | 19418.65 | 19462.26 | 19409.29 | 19460.92 | 12047.0 |
| 2024-03-18 05:00:00 | NQ | Futures | 19460.92 | 19469.48 | 19439.52 | 19447.28 | 7602.0 |
| 2024-03-18 06:00:00 | NQ | Futures | 19447.54 | 19481.25 | 19445.67 | 19471.62 | 8314.0 |
| 2024-03-18 07:00:00 | NQ | Futures | 19471.62 | 19547.32 | 19464.93 | 19541.7 | 19698.0 |
| 2024-03-18 08:00:00 | NQ | Futures | 19541.7 | 19569.79 | 19541.17 | 19556.15 | 19562.0 |
| 2024-03-18 09:00:00 | NQ | Futures | 19556.68 | 19647.37 | 19548.39 | 19569.79 | 118700.0 |
| 2024-03-18 10:00:00 | NQ | Futures | 19569.26 | 19667.97 | 19566.58 | 19642.29 | 100658.0 |
| 2024-03-18 11:00:00 | NQ | Futures | 19642.02 | 19650.85 | 19556.15 | 19575.94 | 75035.0 |
| 2024-03-18 12:00:00 | NQ | Futures | 19576.21 | 19596.28 | 19523.25 | 19526.72 | 53411.0 |
| 2024-03-18 13:00:00 | NQ | Futures | 19526.72 | 19572.47 | 19512.01 | 19551.87 | 50590.0 |
| 2024-03-18 14:00:00 | NQ | Futures | 19552.67 | 19593.87 | 19532.61 | 19556.95 | 45302.0 |
| 2024-03-18 15:00:00 | NQ | Futures | 19557.49 | 19578.08 | 19494.62 | 19505.86 | 69216.0 |
| 2024-03-18 16:00:00 | NQ | Futures | 19505.32 | 19526.72 | 19482.05 | 19503.99 | 23665.0 |
| 2024-03-18 18:00:00 | NQ | Futures | 19497.83 | 19502.92 | 19451.02 | 19459.85 | 5574.0 |
| 2024-03-18 19:00:00 | NQ | Futures | 19459.31 | 19472.15 | 19447.81 | 19465.73 | 3611.0 |
| 2024-03-18 20:00:00 | NQ | Futures | 19465.73 | 19468.41 | 19430.69 | 19435.77 | 4675.0 |
| 2024-03-18 21:00:00 | NQ | Futures | 19435.24 | 19444.87 | 19421.86 | 19443.53 | 4269.0 |
| 2024-03-18 22:00:00 | NQ | Futures | 19443.0 | 19470.01 | 19442.19 | 19460.65 | 4085.0 |
| 2024-03-18 23:00:00 | NQ | Futures | 19461.19 | 19485.53 | 19427.48 | 19452.36 | 7435.0 |
| 2024-03-18 00:00:00 | YM | Futures | 41581.6 | 41600.7 | 41580.5 | 41595.4 | 321.0 |
| 2024-03-18 01:00:00 | YM | Futures | 41596.4 | 41604.9 | 41590.1 | 41600.7 | 591.0 |
| 2024-03-18 02:00:00 | YM | Futures | 41601.7 | 41612.4 | 41592.2 | 41593.3 | 623.0 |
| 2024-03-18 03:00:00 | YM | Futures | 41593.3 | 41594.3 | 41552.9 | 41554.0 | 1534.0 |
> showing 50 of 2,064 rows — these rows as CSV