PREVIEW / futures_1hour / 2024-08-09
file: by_date/futures_1hour/2024/2024-08-09.parquet size: 56 KB rows: 1,670
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-08-09 00:00:00 | ES | Futures | 5615.81 | 5619.48 | 5587.76 | 5592.74 | 11215.0 |
| 2024-08-09 01:00:00 | ES | Futures | 5592.74 | 5609.78 | 5588.29 | 5606.38 | 10313.0 |
| 2024-08-09 02:00:00 | ES | Futures | 5606.38 | 5614.24 | 5599.82 | 5610.31 | 8314.0 |
| 2024-08-09 03:00:00 | ES | Futures | 5610.57 | 5614.77 | 5602.18 | 5613.19 | 16664.0 |
| 2024-08-09 04:00:00 | ES | Futures | 5613.19 | 5633.38 | 5612.67 | 5630.5 | 23463.0 |
| 2024-08-09 05:00:00 | ES | Futures | 5630.76 | 5632.33 | 5620.53 | 5626.3 | 16178.0 |
| 2024-08-09 06:00:00 | ES | Futures | 5626.3 | 5626.56 | 5612.67 | 5616.34 | 11693.0 |
| 2024-08-09 07:00:00 | ES | Futures | 5616.6 | 5625.51 | 5600.87 | 5608.47 | 21501.0 |
| 2024-08-09 08:00:00 | ES | Futures | 5608.74 | 5609.0 | 5578.32 | 5589.6 | 44193.0 |
| 2024-08-09 09:00:00 | ES | Futures | 5589.34 | 5611.36 | 5583.83 | 5591.43 | 173328.0 |
| 2024-08-09 10:00:00 | ES | Futures | 5591.17 | 5622.37 | 5586.71 | 5615.55 | 221384.0 |
| 2024-08-09 11:00:00 | ES | Futures | 5615.29 | 5627.61 | 5600.61 | 5602.71 | 143319.0 |
| 2024-08-09 12:00:00 | ES | Futures | 5602.97 | 5615.03 | 5597.46 | 5614.77 | 96791.0 |
| 2024-08-09 13:00:00 | ES | Futures | 5614.77 | 5647.27 | 5613.19 | 5627.09 | 136876.0 |
| 2024-08-09 14:00:00 | ES | Futures | 5627.35 | 5631.28 | 5614.77 | 5624.99 | 118875.0 |
| 2024-08-09 15:00:00 | ES | Futures | 5624.73 | 5635.48 | 5618.96 | 5629.71 | 192173.0 |
| 2024-08-09 16:00:00 | ES | Futures | 5629.97 | 5631.54 | 5622.63 | 5626.04 | 44326.0 |
| 2024-08-09 00:00:00 | NQ | Futures | 19603.34 | 19629.47 | 19461.05 | 19489.3 | 5438.0 |
| 2024-08-09 01:00:00 | NQ | Futures | 19488.77 | 19572.45 | 19466.33 | 19549.22 | 6195.0 |
| 2024-08-09 02:00:00 | NQ | Futures | 19549.22 | 19595.95 | 19525.73 | 19575.62 | 4397.0 |
| 2024-08-09 03:00:00 | NQ | Futures | 19576.68 | 19599.38 | 19527.31 | 19583.81 | 7930.0 |
| 2024-08-09 04:00:00 | NQ | Futures | 19585.13 | 19694.15 | 19585.13 | 19679.63 | 11648.0 |
| 2024-08-09 05:00:00 | NQ | Futures | 19680.42 | 19690.45 | 19624.2 | 19656.67 | 6955.0 |
| 2024-08-09 06:00:00 | NQ | Futures | 19657.46 | 19657.46 | 19586.45 | 19610.47 | 6902.0 |
| 2024-08-09 07:00:00 | NQ | Futures | 19611.0 | 19638.45 | 19522.3 | 19562.16 | 12033.0 |
| 2024-08-09 08:00:00 | NQ | Futures | 19562.16 | 19563.74 | 19411.16 | 19453.93 | 22540.0 |
| 2024-08-09 09:00:00 | NQ | Futures | 19453.93 | 19565.06 | 19433.34 | 19462.9 | 72289.0 |
| 2024-08-09 10:00:00 | NQ | Futures | 19462.64 | 19604.92 | 19433.86 | 19562.42 | 82821.0 |
| 2024-08-09 11:00:00 | NQ | Futures | 19562.16 | 19617.86 | 19503.03 | 19513.85 | 52266.0 |
| 2024-08-09 12:00:00 | NQ | Futures | 19514.11 | 19567.44 | 19487.72 | 19565.86 | 33703.0 |
| 2024-08-09 13:00:00 | NQ | Futures | 19566.12 | 19718.96 | 19557.41 | 19649.54 | 46109.0 |
| 2024-08-09 14:00:00 | NQ | Futures | 19651.65 | 19670.39 | 19601.49 | 19635.02 | 34425.0 |
| 2024-08-09 15:00:00 | NQ | Futures | 19634.49 | 19675.94 | 19605.19 | 19650.59 | 50995.0 |
| 2024-08-09 16:00:00 | NQ | Futures | 19650.59 | 19664.06 | 19631.06 | 19642.94 | 10073.0 |
| 2024-08-09 00:00:00 | YM | Futures | 41656.1 | 41667.7 | 41523.7 | 41538.4 | 1314.0 |
| 2024-08-09 01:00:00 | YM | Futures | 41539.5 | 41642.4 | 41515.3 | 41624.6 | 1521.0 |
| 2024-08-09 02:00:00 | YM | Futures | 41625.6 | 41651.9 | 41584.7 | 41621.4 | 1513.0 |
| 2024-08-09 03:00:00 | YM | Futures | 41620.4 | 41666.6 | 41591.0 | 41664.5 | 2188.0 |
| 2024-08-09 04:00:00 | YM | Futures | 41661.4 | 41731.8 | 41618.3 | 41716.0 | 3400.0 |
| 2024-08-09 05:00:00 | YM | Futures | 41721.2 | 41724.4 | 41655.1 | 41687.6 | 1898.0 |
| 2024-08-09 06:00:00 | YM | Futures | 41686.6 | 41686.6 | 41595.2 | 41603.6 | 1785.0 |
| 2024-08-09 07:00:00 | YM | Futures | 41608.8 | 41686.6 | 41578.4 | 41604.6 | 2892.0 |
| 2024-08-09 08:00:00 | YM | Futures | 41604.6 | 41607.8 | 41468.0 | 41521.6 | 3718.0 |
| 2024-08-09 09:00:00 | YM | Futures | 41520.6 | 41583.6 | 41351.4 | 41472.2 | 17927.0 |
| 2024-08-09 10:00:00 | YM | Futures | 41471.2 | 41619.3 | 41458.6 | 41595.2 | 18029.0 |
| 2024-08-09 11:00:00 | YM | Futures | 41593.1 | 41668.7 | 41502.7 | 41518.5 | 11063.0 |
| 2024-08-09 12:00:00 | YM | Futures | 41521.6 | 41616.2 | 41494.3 | 41614.1 | 6345.0 |
| 2024-08-09 13:00:00 | YM | Futures | 41614.1 | 41787.4 | 41592.0 | 41602.5 | 10465.0 |
| 2024-08-09 14:00:00 | YM | Futures | 41603.6 | 41629.8 | 41525.8 | 41601.5 | 8415.0 |
| 2024-08-09 15:00:00 | YM | Futures | 41601.5 | 41676.1 | 41572.0 | 41642.4 | 11947.0 |
> showing 50 of 1,670 rows — these rows as CSV