PREVIEW / futures_1hour / 2024-05-09
file: by_date/futures_1hour/2024/2024-05-09.parquet size: 67 KB rows: 2,082
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-09 00:00:00 | ES | Futures | 5526.91 | 5527.44 | 5524.78 | 5524.78 | 2358.0 |
| 2024-05-09 01:00:00 | ES | Futures | 5524.78 | 5525.84 | 5523.19 | 5523.99 | 3480.0 |
| 2024-05-09 02:00:00 | ES | Futures | 5524.25 | 5524.78 | 5520.27 | 5520.54 | 5515.0 |
| 2024-05-09 03:00:00 | ES | Futures | 5520.27 | 5525.05 | 5518.15 | 5519.48 | 10252.0 |
| 2024-05-09 04:00:00 | ES | Futures | 5520.01 | 5523.19 | 5517.89 | 5518.15 | 8263.0 |
| 2024-05-09 05:00:00 | ES | Futures | 5517.89 | 5519.48 | 5512.84 | 5517.89 | 10683.0 |
| 2024-05-09 06:00:00 | ES | Futures | 5517.89 | 5523.99 | 5517.35 | 5520.01 | 8320.0 |
| 2024-05-09 07:00:00 | ES | Futures | 5519.74 | 5526.37 | 5518.15 | 5523.99 | 13301.0 |
| 2024-05-09 08:00:00 | ES | Futures | 5523.72 | 5534.07 | 5519.74 | 5530.09 | 39033.0 |
| 2024-05-09 09:00:00 | ES | Futures | 5530.35 | 5535.39 | 5522.66 | 5532.21 | 131782.0 |
| 2024-05-09 10:00:00 | ES | Futures | 5532.21 | 5550.52 | 5531.15 | 5549.19 | 197403.0 |
| 2024-05-09 11:00:00 | ES | Futures | 5549.19 | 5552.9 | 5540.17 | 5542.03 | 131864.0 |
| 2024-05-09 12:00:00 | ES | Futures | 5541.76 | 5551.31 | 5540.44 | 5549.99 | 90984.0 |
| 2024-05-09 13:00:00 | ES | Futures | 5549.72 | 5554.23 | 5545.21 | 5549.46 | 91329.0 |
| 2024-05-09 14:00:00 | ES | Futures | 5549.46 | 5558.74 | 5546.54 | 5557.15 | 79433.0 |
| 2024-05-09 15:00:00 | ES | Futures | 5557.15 | 5560.6 | 5553.7 | 5559.8 | 159641.0 |
| 2024-05-09 16:00:00 | ES | Futures | 5559.8 | 5565.64 | 5559.27 | 5561.13 | 46724.0 |
| 2024-05-09 18:00:00 | ES | Futures | 5561.39 | 5565.9 | 5559.8 | 5564.58 | 6439.0 |
| 2024-05-09 19:00:00 | ES | Futures | 5564.31 | 5566.97 | 5564.05 | 5564.31 | 3987.0 |
| 2024-05-09 20:00:00 | ES | Futures | 5564.31 | 5565.9 | 5562.99 | 5565.64 | 5467.0 |
| 2024-05-09 21:00:00 | ES | Futures | 5565.64 | 5566.43 | 5561.92 | 5561.92 | 5375.0 |
| 2024-05-09 22:00:00 | ES | Futures | 5561.92 | 5562.99 | 5561.39 | 5562.46 | 3343.0 |
| 2024-05-09 23:00:00 | ES | Futures | 5562.19 | 5562.99 | 5561.13 | 5561.92 | 1960.0 |
| 2024-05-09 00:00:00 | NQ | Futures | 19430.69 | 19432.56 | 19419.45 | 19420.26 | 1351.0 |
| 2024-05-09 01:00:00 | NQ | Futures | 19420.52 | 19426.68 | 19414.91 | 19420.26 | 2105.0 |
| 2024-05-09 02:00:00 | NQ | Futures | 19419.72 | 19421.59 | 19408.22 | 19408.49 | 2784.0 |
| 2024-05-09 03:00:00 | NQ | Futures | 19408.22 | 19433.63 | 19388.69 | 19394.84 | 7834.0 |
| 2024-05-09 04:00:00 | NQ | Futures | 19395.65 | 19414.1 | 19391.1 | 19393.51 | 5483.0 |
| 2024-05-09 05:00:00 | NQ | Futures | 19393.24 | 19399.39 | 19371.3 | 19399.39 | 4900.0 |
| 2024-05-09 06:00:00 | NQ | Futures | 19399.39 | 19426.41 | 19397.25 | 19405.28 | 5558.0 |
| 2024-05-09 07:00:00 | NQ | Futures | 19404.74 | 19436.31 | 19394.84 | 19428.02 | 9080.0 |
| 2024-05-09 08:00:00 | NQ | Futures | 19427.75 | 19474.83 | 19410.89 | 19464.4 | 20206.0 |
| 2024-05-09 09:00:00 | NQ | Futures | 19464.4 | 19485.53 | 19376.65 | 19428.82 | 76276.0 |
| 2024-05-09 10:00:00 | NQ | Futures | 19428.55 | 19497.83 | 19398.32 | 19486.06 | 91083.0 |
| 2024-05-09 11:00:00 | NQ | Futures | 19485.8 | 19514.15 | 19443.26 | 19451.56 | 53675.0 |
| 2024-05-09 12:00:00 | NQ | Futures | 19451.82 | 19496.76 | 19442.19 | 19489.54 | 37021.0 |
| 2024-05-09 13:00:00 | NQ | Futures | 19489.01 | 19509.34 | 19461.45 | 19481.25 | 42142.0 |
| 2024-05-09 14:00:00 | NQ | Futures | 19481.25 | 19516.29 | 19464.13 | 19508.53 | 33995.0 |
| 2024-05-09 15:00:00 | NQ | Futures | 19508.27 | 19511.21 | 19469.48 | 19491.15 | 52673.0 |
| 2024-05-09 16:00:00 | NQ | Futures | 19490.88 | 19517.36 | 19486.06 | 19496.5 | 11548.0 |
| 2024-05-09 18:00:00 | NQ | Futures | 19502.11 | 19514.15 | 19491.68 | 19509.6 | 2351.0 |
| 2024-05-09 19:00:00 | NQ | Futures | 19509.34 | 19522.18 | 19506.39 | 19507.46 | 2466.0 |
| 2024-05-09 20:00:00 | NQ | Futures | 19507.73 | 19510.41 | 19499.17 | 19507.73 | 2074.0 |
| 2024-05-09 21:00:00 | NQ | Futures | 19508.0 | 19511.48 | 19493.55 | 19493.82 | 2449.0 |
| 2024-05-09 22:00:00 | NQ | Futures | 19493.82 | 19498.64 | 19490.08 | 19494.36 | 1796.0 |
| 2024-05-09 23:00:00 | NQ | Futures | 19494.09 | 19498.1 | 19488.74 | 19493.02 | 1331.0 |
| 2024-05-09 00:00:00 | YM | Futures | 41583.7 | 41586.9 | 41574.1 | 41577.3 | 391.0 |
| 2024-05-09 01:00:00 | YM | Futures | 41577.3 | 41583.7 | 41569.9 | 41575.2 | 498.0 |
| 2024-05-09 02:00:00 | YM | Futures | 41575.2 | 41581.6 | 41543.4 | 41544.4 | 995.0 |
| 2024-05-09 03:00:00 | YM | Futures | 41546.5 | 41574.1 | 41540.2 | 41554.0 | 1541.0 |
> showing 50 of 2,082 rows — these rows as CSV