PREVIEW / futures_1hour / 2024-04-10
file: by_date/futures_1hour/2024/2024-04-10.parquet size: 69 KB rows: 2,075
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-04-10 00:00:00 | ES | Futures | 5586.6 | 5588.19 | 5586.33 | 5586.86 | 2282.0 |
| 2024-04-10 01:00:00 | ES | Futures | 5587.13 | 5589.52 | 5583.94 | 5584.21 | 3964.0 |
| 2024-04-10 02:00:00 | ES | Futures | 5584.21 | 5587.39 | 5583.94 | 5584.74 | 6342.0 |
| 2024-04-10 03:00:00 | ES | Futures | 5584.74 | 5589.78 | 5584.47 | 5587.39 | 10885.0 |
| 2024-04-10 04:00:00 | ES | Futures | 5587.39 | 5592.17 | 5585.01 | 5591.11 | 11384.0 |
| 2024-04-10 05:00:00 | ES | Futures | 5591.11 | 5592.7 | 5582.35 | 5582.62 | 12698.0 |
| 2024-04-10 06:00:00 | ES | Futures | 5582.88 | 5587.39 | 5579.43 | 5587.13 | 14449.0 |
| 2024-04-10 07:00:00 | ES | Futures | 5587.13 | 5590.31 | 5586.33 | 5590.05 | 13657.0 |
| 2024-04-10 08:00:00 | ES | Futures | 5590.05 | 5608.35 | 5493.21 | 5509.93 | 249839.0 |
| 2024-04-10 09:00:00 | ES | Futures | 5510.19 | 5528.23 | 5496.66 | 5522.93 | 381193.0 |
| 2024-04-10 10:00:00 | ES | Futures | 5522.93 | 5546.27 | 5516.56 | 5527.97 | 325662.0 |
| 2024-04-10 11:00:00 | ES | Futures | 5527.97 | 5528.5 | 5511.78 | 5515.5 | 171904.0 |
| 2024-04-10 12:00:00 | ES | Futures | 5515.5 | 5526.91 | 5511.52 | 5524.52 | 109006.0 |
| 2024-04-10 13:00:00 | ES | Futures | 5524.52 | 5535.13 | 5502.23 | 5520.27 | 363477.0 |
| 2024-04-10 14:00:00 | ES | Futures | 5520.54 | 5529.82 | 5507.01 | 5507.54 | 212442.0 |
| 2024-04-10 15:00:00 | ES | Futures | 5507.8 | 5534.07 | 5505.68 | 5523.72 | 308220.0 |
| 2024-04-10 16:00:00 | ES | Futures | 5523.99 | 5525.84 | 5513.38 | 5522.13 | 64858.0 |
| 2024-04-10 18:00:00 | ES | Futures | 5520.27 | 5520.27 | 5513.91 | 5517.09 | 5668.0 |
| 2024-04-10 19:00:00 | ES | Futures | 5517.09 | 5517.09 | 5509.66 | 5514.17 | 7018.0 |
| 2024-04-10 20:00:00 | ES | Futures | 5514.17 | 5520.27 | 5513.64 | 5516.29 | 9509.0 |
| 2024-04-10 21:00:00 | ES | Futures | 5516.03 | 5522.4 | 5514.44 | 5520.54 | 9824.0 |
| 2024-04-10 22:00:00 | ES | Futures | 5520.54 | 5523.46 | 5520.01 | 5521.6 | 4638.0 |
| 2024-04-10 23:00:00 | ES | Futures | 5521.33 | 5526.37 | 5520.54 | 5525.05 | 5169.0 |
| 2024-04-10 00:00:00 | NQ | Futures | 19665.83 | 19673.58 | 19665.29 | 19668.5 | 1038.0 |
| 2024-04-10 01:00:00 | NQ | Futures | 19668.77 | 19679.2 | 19655.66 | 19656.46 | 2780.0 |
| 2024-04-10 02:00:00 | NQ | Futures | 19657.0 | 19670.91 | 19656.46 | 19659.14 | 2661.0 |
| 2024-04-10 03:00:00 | NQ | Futures | 19658.34 | 19690.7 | 19657.8 | 19678.4 | 6140.0 |
| 2024-04-10 04:00:00 | NQ | Futures | 19678.67 | 19697.93 | 19667.43 | 19692.31 | 5139.0 |
| 2024-04-10 05:00:00 | NQ | Futures | 19692.58 | 19700.6 | 19639.88 | 19641.48 | 6985.0 |
| 2024-04-10 06:00:00 | NQ | Futures | 19641.48 | 19663.42 | 19625.43 | 19655.66 | 8501.0 |
| 2024-04-10 07:00:00 | NQ | Futures | 19655.13 | 19670.91 | 19652.72 | 19669.57 | 7457.0 |
| 2024-04-10 08:00:00 | NQ | Futures | 19669.3 | 19767.75 | 19317.54 | 19374.78 | 90509.0 |
| 2024-04-10 09:00:00 | NQ | Futures | 19375.32 | 19482.85 | 19325.56 | 19452.36 | 172166.0 |
| 2024-04-10 10:00:00 | NQ | Futures | 19452.36 | 19510.67 | 19405.54 | 19429.62 | 131958.0 |
| 2024-04-10 11:00:00 | NQ | Futures | 19429.35 | 19455.84 | 19394.31 | 19414.91 | 59541.0 |
| 2024-04-10 12:00:00 | NQ | Futures | 19415.17 | 19476.7 | 19395.91 | 19465.73 | 43878.0 |
| 2024-04-10 13:00:00 | NQ | Futures | 19465.47 | 19500.24 | 19382.27 | 19437.91 | 119189.0 |
| 2024-04-10 14:00:00 | NQ | Futures | 19436.58 | 19471.08 | 19394.04 | 19396.72 | 78047.0 |
| 2024-04-10 15:00:00 | NQ | Futures | 19397.52 | 19501.04 | 19386.55 | 19465.47 | 97999.0 |
| 2024-04-10 16:00:00 | NQ | Futures | 19464.93 | 19473.22 | 19422.13 | 19466.0 | 17789.0 |
| 2024-04-10 18:00:00 | NQ | Futures | 19457.17 | 19457.17 | 19431.49 | 19444.6 | 3310.0 |
| 2024-04-10 19:00:00 | NQ | Futures | 19444.6 | 19445.14 | 19412.5 | 19430.16 | 4979.0 |
| 2024-04-10 20:00:00 | NQ | Futures | 19430.69 | 19449.42 | 19421.59 | 19437.11 | 3867.0 |
| 2024-04-10 21:00:00 | NQ | Futures | 19435.77 | 19457.98 | 19426.14 | 19451.29 | 4314.0 |
| 2024-04-10 22:00:00 | NQ | Futures | 19451.56 | 19468.68 | 19450.22 | 19463.06 | 3052.0 |
| 2024-04-10 23:00:00 | NQ | Futures | 19463.06 | 19480.18 | 19458.24 | 19473.22 | 2931.0 |
| 2024-04-10 00:00:00 | YM | Futures | 41636.8 | 41650.6 | 41635.7 | 41646.3 | 277.0 |
| 2024-04-10 01:00:00 | YM | Futures | 41646.3 | 41658.0 | 41625.1 | 41631.5 | 512.0 |
| 2024-04-10 02:00:00 | YM | Futures | 41631.5 | 41660.1 | 41625.1 | 41640.0 | 1061.0 |
| 2024-04-10 03:00:00 | YM | Futures | 41638.9 | 41677.1 | 41638.9 | 41654.8 | 1860.0 |
> showing 50 of 2,075 rows — these rows as CSV