PREVIEW / futures_1hour / 2024-03-20
file: by_date/futures_1hour/2024/2024-03-20.parquet size: 68 KB rows: 2,095
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-20 00:00:00 | ES | Futures | 5556.88 | 5558.21 | 5555.29 | 5555.29 | 1621.0 |
| 2024-03-20 01:00:00 | ES | Futures | 5555.03 | 5557.95 | 5554.5 | 5556.88 | 1957.0 |
| 2024-03-20 02:00:00 | ES | Futures | 5556.62 | 5558.48 | 5555.56 | 5557.15 | 3004.0 |
| 2024-03-20 03:00:00 | ES | Futures | 5557.41 | 5562.19 | 5556.88 | 5558.74 | 8534.0 |
| 2024-03-20 04:00:00 | ES | Futures | 5558.48 | 5560.6 | 5553.7 | 5556.62 | 12260.0 |
| 2024-03-20 05:00:00 | ES | Futures | 5556.62 | 5559.54 | 5554.23 | 5559.01 | 7043.0 |
| 2024-03-20 06:00:00 | ES | Futures | 5558.74 | 5561.66 | 5556.88 | 5561.13 | 7622.0 |
| 2024-03-20 07:00:00 | ES | Futures | 5561.13 | 5567.23 | 5560.6 | 5565.64 | 13598.0 |
| 2024-03-20 08:00:00 | ES | Futures | 5565.9 | 5566.17 | 5555.29 | 5558.21 | 24428.0 |
| 2024-03-20 09:00:00 | ES | Futures | 5558.21 | 5564.31 | 5555.56 | 5557.95 | 123324.0 |
| 2024-03-20 10:00:00 | ES | Futures | 5557.95 | 5568.82 | 5556.88 | 5562.72 | 111634.0 |
| 2024-03-20 11:00:00 | ES | Futures | 5562.72 | 5567.23 | 5559.01 | 5562.72 | 67182.0 |
| 2024-03-20 12:00:00 | ES | Futures | 5562.46 | 5565.37 | 5556.88 | 5564.84 | 59867.0 |
| 2024-03-20 13:00:00 | ES | Futures | 5564.84 | 5564.84 | 5553.17 | 5557.15 | 60221.0 |
| 2024-03-20 14:00:00 | ES | Futures | 5557.15 | 5601.45 | 5556.88 | 5594.82 | 388014.0 |
| 2024-03-20 15:00:00 | ES | Futures | 5595.09 | 5613.13 | 5593.76 | 5611.27 | 317325.0 |
| 2024-03-20 16:00:00 | ES | Futures | 5611.0 | 5621.88 | 5608.35 | 5620.29 | 91695.0 |
| 2024-03-20 18:00:00 | ES | Futures | 5618.7 | 5623.74 | 5617.37 | 5623.47 | 7931.0 |
| 2024-03-20 19:00:00 | ES | Futures | 5623.21 | 5629.31 | 5622.68 | 5627.19 | 9443.0 |
| 2024-03-20 20:00:00 | ES | Futures | 5626.92 | 5626.92 | 5623.74 | 5624.53 | 7823.0 |
| 2024-03-20 21:00:00 | ES | Futures | 5624.27 | 5627.19 | 5623.21 | 5625.06 | 5946.0 |
| 2024-03-20 22:00:00 | ES | Futures | 5625.33 | 5630.11 | 5624.8 | 5629.31 | 5708.0 |
| 2024-03-20 23:00:00 | ES | Futures | 5629.31 | 5631.7 | 5629.04 | 5631.43 | 4723.0 |
| 2024-03-20 00:00:00 | NQ | Futures | 19523.25 | 19531.27 | 19513.35 | 19513.62 | 1732.0 |
| 2024-03-20 01:00:00 | NQ | Futures | 19513.62 | 19529.67 | 19510.67 | 19524.85 | 1649.0 |
| 2024-03-20 02:00:00 | NQ | Futures | 19525.12 | 19539.3 | 19516.56 | 19532.34 | 2643.0 |
| 2024-03-20 03:00:00 | NQ | Futures | 19533.14 | 19558.82 | 19529.93 | 19540.1 | 5404.0 |
| 2024-03-20 04:00:00 | NQ | Futures | 19539.03 | 19558.56 | 19510.67 | 19521.91 | 8733.0 |
| 2024-03-20 05:00:00 | NQ | Futures | 19521.37 | 19552.14 | 19512.28 | 19551.33 | 6333.0 |
| 2024-03-20 06:00:00 | NQ | Futures | 19551.6 | 19574.34 | 19533.41 | 19568.45 | 7833.0 |
| 2024-03-20 07:00:00 | NQ | Futures | 19567.65 | 19614.73 | 19564.44 | 19605.91 | 9721.0 |
| 2024-03-20 08:00:00 | NQ | Futures | 19606.17 | 19610.45 | 19562.57 | 19579.96 | 15436.0 |
| 2024-03-20 09:00:00 | NQ | Futures | 19579.96 | 19618.21 | 19523.25 | 19536.89 | 72620.0 |
| 2024-03-20 10:00:00 | NQ | Futures | 19537.96 | 19586.38 | 19526.72 | 19540.37 | 60232.0 |
| 2024-03-20 11:00:00 | NQ | Futures | 19540.9 | 19577.01 | 19532.34 | 19558.56 | 40495.0 |
| 2024-03-20 12:00:00 | NQ | Futures | 19558.29 | 19571.13 | 19531.0 | 19570.33 | 32358.0 |
| 2024-03-20 13:00:00 | NQ | Futures | 19570.86 | 19572.2 | 19522.18 | 19553.21 | 26609.0 |
| 2024-03-20 14:00:00 | NQ | Futures | 19551.87 | 19746.61 | 19551.87 | 19708.89 | 169502.0 |
| 2024-03-20 15:00:00 | NQ | Futures | 19708.63 | 19792.89 | 19703.28 | 19778.71 | 105371.0 |
| 2024-03-20 16:00:00 | NQ | Futures | 19778.71 | 19843.45 | 19763.73 | 19840.24 | 26489.0 |
| 2024-03-20 18:00:00 | NQ | Futures | 19837.83 | 19862.71 | 19823.92 | 19858.16 | 7298.0 |
| 2024-03-20 19:00:00 | NQ | Futures | 19857.89 | 19890.53 | 19854.95 | 19879.29 | 6148.0 |
| 2024-03-20 20:00:00 | NQ | Futures | 19879.03 | 19879.56 | 19859.5 | 19860.57 | 3810.0 |
| 2024-03-20 21:00:00 | NQ | Futures | 19860.03 | 19874.48 | 19857.89 | 19870.2 | 3178.0 |
| 2024-03-20 22:00:00 | NQ | Futures | 19869.93 | 19896.41 | 19868.59 | 19889.99 | 3290.0 |
| 2024-03-20 23:00:00 | NQ | Futures | 19889.73 | 19898.55 | 19885.45 | 19894.01 | 2482.0 |
| 2024-03-20 00:00:00 | YM | Futures | 41963.8 | 41972.3 | 41957.4 | 41957.4 | 331.0 |
| 2024-03-20 01:00:00 | YM | Futures | 41956.4 | 41968.0 | 41954.2 | 41962.7 | 440.0 |
| 2024-03-20 02:00:00 | YM | Futures | 41962.7 | 41969.1 | 41957.4 | 41968.0 | 589.0 |
| 2024-03-20 03:00:00 | YM | Futures | 41969.1 | 42000.9 | 41965.9 | 41974.4 | 2051.0 |
> showing 50 of 2,095 rows — these rows as CSV