PREVIEW / futures_30min / 2024-05-31
file: by_date/futures_30min/2024/2024-05-31.parquet size: 94 KB rows: 3,170
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-05-31 00:00:00 | ES | Futures | 5567.23 | 5567.23 | 5564.58 | 5565.37 | 1629.0 |
| 2024-05-31 00:30:00 | ES | Futures | 5565.11 | 5565.64 | 5563.25 | 5564.84 | 1539.0 |
| 2024-05-31 01:00:00 | ES | Futures | 5564.84 | 5568.56 | 5563.78 | 5564.84 | 3666.0 |
| 2024-05-31 01:30:00 | ES | Futures | 5565.11 | 5566.43 | 5561.66 | 5562.19 | 4416.0 |
| 2024-05-31 02:00:00 | ES | Futures | 5561.92 | 5566.43 | 5561.92 | 5564.31 | 5047.0 |
| 2024-05-31 02:30:00 | ES | Futures | 5564.31 | 5566.97 | 5563.52 | 5565.11 | 4222.0 |
| 2024-05-31 03:00:00 | ES | Futures | 5565.37 | 5567.76 | 5561.13 | 5562.46 | 9202.0 |
| 2024-05-31 03:30:00 | ES | Futures | 5562.19 | 5563.52 | 5560.07 | 5561.66 | 7951.0 |
| 2024-05-31 04:00:00 | ES | Futures | 5561.92 | 5570.68 | 5560.86 | 5570.41 | 10963.0 |
| 2024-05-31 04:30:00 | ES | Futures | 5570.41 | 5570.94 | 5564.05 | 5564.84 | 5487.0 |
| 2024-05-31 05:00:00 | ES | Futures | 5564.84 | 5564.84 | 5560.07 | 5563.78 | 8252.0 |
| 2024-05-31 05:30:00 | ES | Futures | 5563.78 | 5565.37 | 5560.6 | 5562.19 | 5402.0 |
| 2024-05-31 06:00:00 | ES | Futures | 5562.46 | 5564.84 | 5555.29 | 5557.15 | 8312.0 |
| 2024-05-31 06:30:00 | ES | Futures | 5557.41 | 5560.86 | 5550.78 | 5559.8 | 12291.0 |
| 2024-05-31 07:00:00 | ES | Futures | 5560.07 | 5563.52 | 5557.68 | 5562.72 | 10382.0 |
| 2024-05-31 07:30:00 | ES | Futures | 5562.99 | 5569.62 | 5562.46 | 5568.56 | 8589.0 |
| 2024-05-31 08:00:00 | ES | Futures | 5568.56 | 5573.6 | 5567.23 | 5571.48 | 15722.0 |
| 2024-05-31 08:30:00 | ES | Futures | 5571.21 | 5594.82 | 5571.21 | 5590.58 | 64003.0 |
| 2024-05-31 09:00:00 | ES | Futures | 5590.58 | 5592.17 | 5578.9 | 5579.43 | 44035.0 |
| 2024-05-31 09:30:00 | ES | Futures | 5579.43 | 5592.7 | 5572.54 | 5574.92 | 165773.0 |
| 2024-05-31 10:00:00 | ES | Futures | 5574.66 | 5575.45 | 5550.25 | 5552.9 | 193507.0 |
| 2024-05-31 10:30:00 | ES | Futures | 5553.17 | 5553.7 | 5543.62 | 5550.52 | 173379.0 |
| 2024-05-31 11:00:00 | ES | Futures | 5550.78 | 5551.58 | 5541.5 | 5542.82 | 107247.0 |
| 2024-05-31 11:30:00 | ES | Futures | 5542.82 | 5544.15 | 5537.25 | 5538.05 | 104745.0 |
| 2024-05-31 12:00:00 | ES | Futures | 5538.05 | 5539.37 | 5523.99 | 5528.76 | 118314.0 |
| 2024-05-31 12:30:00 | ES | Futures | 5528.5 | 5536.72 | 5527.97 | 5536.46 | 73486.0 |
| 2024-05-31 13:00:00 | ES | Futures | 5536.19 | 5551.58 | 5536.19 | 5550.25 | 83539.0 |
| 2024-05-31 13:30:00 | ES | Futures | 5550.25 | 5552.9 | 5546.27 | 5551.05 | 72766.0 |
| 2024-05-31 14:00:00 | ES | Futures | 5551.05 | 5555.56 | 5547.6 | 5550.25 | 66601.0 |
| 2024-05-31 14:30:00 | ES | Futures | 5550.25 | 5561.13 | 5547.86 | 5557.41 | 79309.0 |
| 2024-05-31 15:00:00 | ES | Futures | 5557.41 | 5571.21 | 5552.9 | 5565.9 | 101754.0 |
| 2024-05-31 15:30:00 | ES | Futures | 5565.64 | 5623.74 | 5562.99 | 5620.82 | 483162.0 |
| 2024-05-31 16:00:00 | ES | Futures | 5620.82 | 5631.7 | 5614.72 | 5624.53 | 158093.0 |
| 2024-05-31 16:30:00 | ES | Futures | 5624.27 | 5628.78 | 5621.35 | 5623.47 | 28677.0 |
| 2024-05-31 00:00:00 | NQ | Futures | 19861.64 | 19863.24 | 19851.47 | 19853.88 | 1011.0 |
| 2024-05-31 00:30:00 | NQ | Futures | 19854.95 | 19855.22 | 19845.86 | 19853.08 | 1106.0 |
| 2024-05-31 01:00:00 | NQ | Futures | 19852.54 | 19867.26 | 19847.73 | 19852.54 | 1787.0 |
| 2024-05-31 01:30:00 | NQ | Futures | 19853.35 | 19857.89 | 19834.09 | 19835.42 | 1972.0 |
| 2024-05-31 02:00:00 | NQ | Futures | 19835.16 | 19851.47 | 19833.28 | 19843.72 | 2290.0 |
| 2024-05-31 02:30:00 | NQ | Futures | 19843.18 | 19857.36 | 19839.7 | 19848.8 | 1902.0 |
| 2024-05-31 03:00:00 | NQ | Futures | 19848.8 | 19856.56 | 19824.19 | 19828.74 | 3695.0 |
| 2024-05-31 03:30:00 | NQ | Futures | 19828.2 | 19833.02 | 19809.74 | 19820.98 | 4246.0 |
| 2024-05-31 04:00:00 | NQ | Futures | 19821.51 | 19872.61 | 19814.56 | 19869.4 | 6675.0 |
| 2024-05-31 04:30:00 | NQ | Futures | 19869.66 | 19873.14 | 19838.37 | 19842.38 | 3322.0 |
| 2024-05-31 05:00:00 | NQ | Futures | 19842.91 | 19842.91 | 19822.85 | 19840.77 | 3676.0 |
| 2024-05-31 05:30:00 | NQ | Futures | 19840.24 | 19848.26 | 19830.07 | 19838.37 | 2565.0 |
| 2024-05-31 06:00:00 | NQ | Futures | 19839.44 | 19848.53 | 19806.8 | 19813.49 | 4056.0 |
| 2024-05-31 06:30:00 | NQ | Futures | 19814.29 | 19829.81 | 19779.25 | 19818.3 | 6489.0 |
| 2024-05-31 07:00:00 | NQ | Futures | 19818.3 | 19837.56 | 19810.81 | 19834.89 | 5037.0 |
| 2024-05-31 07:30:00 | NQ | Futures | 19835.42 | 19866.19 | 19833.55 | 19861.37 | 4636.0 |
> showing 50 of 3,170 rows — these rows as CSV