PREVIEW / futures_1hour / 2024-03-14
file: by_date/futures_1hour/2024/2024-03-14.parquet size: 66 KB rows: 2,061
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-14 00:00:00 | ES | Futures | 5557.95 | 5559.54 | 5556.09 | 5559.27 | 2798.0 |
| 2024-03-14 01:00:00 | ES | Futures | 5559.27 | 5560.6 | 5558.21 | 5560.07 | 3302.0 |
| 2024-03-14 02:00:00 | ES | Futures | 5560.33 | 5563.78 | 5559.27 | 5563.52 | 5230.0 |
| 2024-03-14 03:00:00 | ES | Futures | 5563.52 | 5565.9 | 5560.07 | 5565.11 | 8476.0 |
| 2024-03-14 04:00:00 | ES | Futures | 5565.11 | 5572.01 | 5564.84 | 5570.94 | 21635.0 |
| 2024-03-14 05:00:00 | ES | Futures | 5570.94 | 5572.54 | 5568.82 | 5571.48 | 11637.0 |
| 2024-03-14 06:00:00 | ES | Futures | 5571.74 | 5572.54 | 5568.29 | 5570.68 | 10448.0 |
| 2024-03-14 07:00:00 | ES | Futures | 5570.41 | 5574.92 | 5569.09 | 5570.15 | 15257.0 |
| 2024-03-14 08:00:00 | ES | Futures | 5570.41 | 5573.6 | 5559.54 | 5563.25 | 93000.0 |
| 2024-03-14 09:00:00 | ES | Futures | 5563.25 | 5567.5 | 5527.44 | 5528.23 | 334145.0 |
| 2024-03-14 10:00:00 | ES | Futures | 5527.97 | 5545.74 | 5521.33 | 5535.13 | 328497.0 |
| 2024-03-14 11:00:00 | ES | Futures | 5535.39 | 5543.62 | 5529.03 | 5539.37 | 185920.0 |
| 2024-03-14 12:00:00 | ES | Futures | 5539.37 | 5541.23 | 5526.91 | 5527.44 | 163465.0 |
| 2024-03-14 13:00:00 | ES | Futures | 5527.44 | 5534.86 | 5514.7 | 5534.33 | 149652.0 |
| 2024-03-14 14:00:00 | ES | Futures | 5534.33 | 5541.5 | 5526.91 | 5527.44 | 164442.0 |
| 2024-03-14 15:00:00 | ES | Futures | 5527.44 | 5539.9 | 5505.42 | 5539.64 | 367975.0 |
| 2024-03-14 16:00:00 | ES | Futures | 5539.64 | 5541.5 | 5535.66 | 5536.99 | 71911.0 |
| 2024-03-14 18:00:00 | ES | Futures | 5535.13 | 5537.52 | 5534.07 | 5534.86 | 5908.0 |
| 2024-03-14 19:00:00 | ES | Futures | 5534.86 | 5535.13 | 5528.76 | 5532.48 | 6349.0 |
| 2024-03-14 20:00:00 | ES | Futures | 5532.21 | 5538.31 | 5532.21 | 5536.99 | 7348.0 |
| 2024-03-14 21:00:00 | ES | Futures | 5536.99 | 5538.84 | 5534.33 | 5534.6 | 6758.0 |
| 2024-03-14 22:00:00 | ES | Futures | 5534.33 | 5534.6 | 5531.68 | 5533.01 | 5085.0 |
| 2024-03-14 23:00:00 | ES | Futures | 5533.01 | 5536.46 | 5532.74 | 5536.19 | 4614.0 |
| 2024-03-14 00:00:00 | NQ | Futures | 19658.07 | 19667.7 | 19651.65 | 19667.16 | 1483.0 |
| 2024-03-14 01:00:00 | NQ | Futures | 19666.9 | 19674.65 | 19661.28 | 19670.64 | 2065.0 |
| 2024-03-14 02:00:00 | NQ | Futures | 19670.91 | 19681.88 | 19664.76 | 19678.13 | 2803.0 |
| 2024-03-14 03:00:00 | NQ | Futures | 19678.4 | 19688.83 | 19661.55 | 19685.89 | 4318.0 |
| 2024-03-14 04:00:00 | NQ | Futures | 19685.89 | 19718.52 | 19682.41 | 19706.22 | 10283.0 |
| 2024-03-14 05:00:00 | NQ | Futures | 19706.49 | 19713.98 | 19695.25 | 19706.49 | 5106.0 |
| 2024-03-14 06:00:00 | NQ | Futures | 19706.75 | 19711.3 | 19689.37 | 19697.39 | 4411.0 |
| 2024-03-14 07:00:00 | NQ | Futures | 19697.12 | 19710.23 | 19675.99 | 19682.95 | 7788.0 |
| 2024-03-14 08:00:00 | NQ | Futures | 19683.21 | 19703.28 | 19636.13 | 19656.73 | 34080.0 |
| 2024-03-14 09:00:00 | NQ | Futures | 19657.0 | 19686.16 | 19505.86 | 19514.95 | 141851.0 |
| 2024-03-14 10:00:00 | NQ | Futures | 19514.69 | 19626.24 | 19477.77 | 19580.49 | 132180.0 |
| 2024-03-14 11:00:00 | NQ | Futures | 19581.03 | 19621.96 | 19541.17 | 19582.9 | 82885.0 |
| 2024-03-14 12:00:00 | NQ | Futures | 19583.43 | 19595.74 | 19519.77 | 19529.4 | 68268.0 |
| 2024-03-14 13:00:00 | NQ | Futures | 19530.74 | 19575.68 | 19484.99 | 19573.27 | 61421.0 |
| 2024-03-14 14:00:00 | NQ | Futures | 19573.27 | 19615.8 | 19528.06 | 19530.2 | 79595.0 |
| 2024-03-14 15:00:00 | NQ | Futures | 19530.2 | 19558.29 | 19432.83 | 19558.29 | 109745.0 |
| 2024-03-14 16:00:00 | NQ | Futures | 19558.29 | 19581.03 | 19533.41 | 19545.18 | 22897.0 |
| 2024-03-14 18:00:00 | NQ | Futures | 19528.86 | 19541.7 | 19522.98 | 19528.6 | 3397.0 |
| 2024-03-14 19:00:00 | NQ | Futures | 19529.13 | 19529.13 | 19500.24 | 19515.49 | 3156.0 |
| 2024-03-14 20:00:00 | NQ | Futures | 19515.22 | 19543.04 | 19513.88 | 19539.83 | 3704.0 |
| 2024-03-14 21:00:00 | NQ | Futures | 19540.1 | 19548.12 | 19522.71 | 19522.98 | 3735.0 |
| 2024-03-14 22:00:00 | NQ | Futures | 19522.71 | 19522.71 | 19501.85 | 19517.36 | 3721.0 |
| 2024-03-14 23:00:00 | NQ | Futures | 19517.9 | 19525.39 | 19509.07 | 19522.18 | 1969.0 |
| 2024-03-14 00:00:00 | YM | Futures | 41985.0 | 41993.5 | 41976.5 | 41991.4 | 364.0 |
| 2024-03-14 01:00:00 | YM | Futures | 41989.3 | 42003.1 | 41986.1 | 42002.0 | 413.0 |
| 2024-03-14 02:00:00 | YM | Futures | 42002.0 | 42032.8 | 41997.8 | 42032.8 | 1009.0 |
| 2024-03-14 03:00:00 | YM | Futures | 42032.8 | 42060.4 | 42017.9 | 42054.0 | 1601.0 |
> showing 50 of 2,061 rows — these rows as CSV