PREVIEW / futures_1hour / 2024-10-30
file: by_date/futures_1hour/2024/2024-10-30.parquet size: 70 KB rows: 2,147
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-10-30 00:00:00 | ES | Futures | 6105.29 | 6105.29 | 6100.88 | 6101.14 | 5897.0 |
| 2024-10-30 01:00:00 | ES | Futures | 6100.88 | 6103.21 | 6098.28 | 6099.84 | 5985.0 |
| 2024-10-30 02:00:00 | ES | Futures | 6099.58 | 6108.4 | 6098.8 | 6108.14 | 7620.0 |
| 2024-10-30 03:00:00 | ES | Futures | 6108.14 | 6109.44 | 6105.03 | 6105.03 | 8859.0 |
| 2024-10-30 04:00:00 | ES | Futures | 6105.03 | 6110.22 | 6102.17 | 6104.25 | 15946.0 |
| 2024-10-30 05:00:00 | ES | Futures | 6103.99 | 6108.92 | 6101.65 | 6106.33 | 13707.0 |
| 2024-10-30 06:00:00 | ES | Futures | 6106.07 | 6109.18 | 6096.46 | 6097.76 | 23193.0 |
| 2024-10-30 07:00:00 | ES | Futures | 6098.02 | 6103.73 | 6093.87 | 6095.43 | 20603.0 |
| 2024-10-30 08:00:00 | ES | Futures | 6095.43 | 6101.4 | 6089.98 | 6092.05 | 38456.0 |
| 2024-10-30 09:00:00 | ES | Futures | 6092.05 | 6095.69 | 6068.18 | 6094.65 | 195297.0 |
| 2024-10-30 10:00:00 | ES | Futures | 6094.65 | 6107.1 | 6093.87 | 6100.88 | 168327.0 |
| 2024-10-30 11:00:00 | ES | Futures | 6100.88 | 6111.0 | 6092.57 | 6108.66 | 122320.0 |
| 2024-10-30 12:00:00 | ES | Futures | 6108.66 | 6109.7 | 6096.46 | 6096.98 | 89017.0 |
| 2024-10-30 13:00:00 | ES | Futures | 6096.72 | 6100.1 | 6078.3 | 6081.93 | 124821.0 |
| 2024-10-30 14:00:00 | ES | Futures | 6081.93 | 6094.39 | 6081.93 | 6087.9 | 92761.0 |
| 2024-10-30 15:00:00 | ES | Futures | 6088.16 | 6088.16 | 6068.95 | 6075.96 | 211994.0 |
| 2024-10-30 16:00:00 | ES | Futures | 6075.96 | 6082.97 | 6062.73 | 6067.92 | 96175.0 |
| 2024-10-30 18:00:00 | ES | Futures | 6062.47 | 6066.62 | 6054.68 | 6057.28 | 27258.0 |
| 2024-10-30 19:00:00 | ES | Futures | 6057.28 | 6059.09 | 6053.64 | 6053.9 | 6339.0 |
| 2024-10-30 20:00:00 | ES | Futures | 6053.9 | 6056.5 | 6048.97 | 6054.16 | 9383.0 |
| 2024-10-30 21:00:00 | ES | Futures | 6054.16 | 6060.65 | 6054.16 | 6054.94 | 7677.0 |
| 2024-10-30 22:00:00 | ES | Futures | 6055.2 | 6055.98 | 6050.53 | 6052.6 | 7672.0 |
| 2024-10-30 23:00:00 | ES | Futures | 6052.6 | 6053.9 | 6049.23 | 6050.01 | 6452.0 |
| 2024-10-30 00:00:00 | NQ | Futures | 21633.28 | 21636.42 | 21617.89 | 21625.46 | 3038.0 |
| 2024-10-30 01:00:00 | NQ | Futures | 21624.93 | 21636.15 | 21606.15 | 21617.37 | 2945.0 |
| 2024-10-30 02:00:00 | NQ | Futures | 21616.85 | 21655.72 | 21610.06 | 21651.81 | 3494.0 |
| 2024-10-30 03:00:00 | NQ | Futures | 21651.81 | 21666.94 | 21642.16 | 21649.46 | 4789.0 |
| 2024-10-30 04:00:00 | NQ | Futures | 21649.98 | 21671.38 | 21616.85 | 21627.02 | 7730.0 |
| 2024-10-30 05:00:00 | NQ | Futures | 21626.5 | 21656.51 | 21612.93 | 21635.63 | 5931.0 |
| 2024-10-30 06:00:00 | NQ | Futures | 21635.37 | 21644.76 | 21622.59 | 21638.5 | 6225.0 |
| 2024-10-30 07:00:00 | NQ | Futures | 21639.55 | 21660.42 | 21616.59 | 21618.93 | 6886.0 |
| 2024-10-30 08:00:00 | NQ | Futures | 21618.67 | 21639.55 | 21576.41 | 21591.28 | 19893.0 |
| 2024-10-30 09:00:00 | NQ | Futures | 21592.06 | 21592.06 | 21439.43 | 21533.09 | 92117.0 |
| 2024-10-30 10:00:00 | NQ | Futures | 21532.31 | 21603.02 | 21529.18 | 21551.88 | 71642.0 |
| 2024-10-30 11:00:00 | NQ | Futures | 21551.36 | 21588.67 | 21507.26 | 21574.32 | 53751.0 |
| 2024-10-30 12:00:00 | NQ | Futures | 21573.8 | 21585.54 | 21537.27 | 21545.88 | 34057.0 |
| 2024-10-30 13:00:00 | NQ | Futures | 21545.62 | 21555.27 | 21455.34 | 21474.65 | 44929.0 |
| 2024-10-30 14:00:00 | NQ | Futures | 21474.13 | 21522.4 | 21473.34 | 21504.13 | 31923.0 |
| 2024-10-30 15:00:00 | NQ | Futures | 21504.13 | 21504.39 | 21410.2 | 21430.82 | 60628.0 |
| 2024-10-30 16:00:00 | NQ | Futures | 21431.08 | 21487.43 | 21366.11 | 21402.12 | 35396.0 |
| 2024-10-30 18:00:00 | NQ | Futures | 21376.02 | 21390.37 | 21318.36 | 21331.15 | 10308.0 |
| 2024-10-30 19:00:00 | NQ | Futures | 21329.06 | 21340.02 | 21314.45 | 21318.1 | 4558.0 |
| 2024-10-30 20:00:00 | NQ | Futures | 21316.54 | 21335.58 | 21291.49 | 21329.32 | 5021.0 |
| 2024-10-30 21:00:00 | NQ | Futures | 21329.58 | 21356.98 | 21329.06 | 21334.02 | 4261.0 |
| 2024-10-30 22:00:00 | NQ | Futures | 21333.23 | 21339.24 | 21315.23 | 21325.15 | 3328.0 |
| 2024-10-30 23:00:00 | NQ | Futures | 21325.93 | 21333.76 | 21309.23 | 21313.14 | 2951.0 |
| 2024-10-30 00:00:00 | YM | Futures | 44191.4 | 44191.4 | 44160.2 | 44162.2 | 685.0 |
| 2024-10-30 01:00:00 | YM | Futures | 44162.2 | 44185.1 | 44156.0 | 44170.6 | 774.0 |
| 2024-10-30 02:00:00 | YM | Futures | 44169.5 | 44228.9 | 44163.3 | 44222.6 | 776.0 |
| 2024-10-30 03:00:00 | YM | Futures | 44222.6 | 44229.9 | 44195.5 | 44197.6 | 1000.0 |
> showing 50 of 2,147 rows — these rows as CSV