PREVIEW / futures_1hour / 2024-04-23
file: by_date/futures_1hour/2024/2024-04-23.parquet size: 67 KB rows: 2,083
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-04-23 00:00:00 | ES | Futures | 5356.32 | 5358.44 | 5354.2 | 5354.99 | 2752.0 |
| 2024-04-23 01:00:00 | ES | Futures | 5354.99 | 5357.38 | 5352.08 | 5355.79 | 4262.0 |
| 2024-04-23 02:00:00 | ES | Futures | 5356.06 | 5359.5 | 5351.01 | 5358.97 | 6285.0 |
| 2024-04-23 03:00:00 | ES | Futures | 5358.97 | 5363.75 | 5357.12 | 5360.3 | 19563.0 |
| 2024-04-23 04:00:00 | ES | Futures | 5360.57 | 5368.52 | 5359.24 | 5361.63 | 15898.0 |
| 2024-04-23 05:00:00 | ES | Futures | 5361.63 | 5366.67 | 5358.71 | 5360.57 | 11250.0 |
| 2024-04-23 06:00:00 | ES | Futures | 5360.57 | 5374.1 | 5360.03 | 5373.3 | 16137.0 |
| 2024-04-23 07:00:00 | ES | Futures | 5373.56 | 5376.22 | 5365.34 | 5367.2 | 19290.0 |
| 2024-04-23 08:00:00 | ES | Futures | 5367.46 | 5377.54 | 5360.3 | 5375.16 | 34037.0 |
| 2024-04-23 09:00:00 | ES | Futures | 5375.42 | 5400.09 | 5373.56 | 5393.46 | 213566.0 |
| 2024-04-23 10:00:00 | ES | Futures | 5393.46 | 5417.87 | 5389.22 | 5416.54 | 251633.0 |
| 2024-04-23 11:00:00 | ES | Futures | 5416.54 | 5417.6 | 5403.81 | 5406.99 | 144852.0 |
| 2024-04-23 12:00:00 | ES | Futures | 5406.99 | 5420.52 | 5405.67 | 5416.01 | 96502.0 |
| 2024-04-23 13:00:00 | ES | Futures | 5416.01 | 5425.56 | 5409.38 | 5424.5 | 92547.0 |
| 2024-04-23 14:00:00 | ES | Futures | 5424.5 | 5425.56 | 5416.81 | 5421.85 | 79037.0 |
| 2024-04-23 15:00:00 | ES | Futures | 5421.58 | 5422.38 | 5413.36 | 5420.26 | 192845.0 |
| 2024-04-23 16:00:00 | ES | Futures | 5420.26 | 5426.36 | 5415.75 | 5425.03 | 67659.0 |
| 2024-04-23 18:00:00 | ES | Futures | 5428.22 | 5430.6 | 5424.24 | 5427.15 | 8518.0 |
| 2024-04-23 19:00:00 | ES | Futures | 5426.89 | 5432.99 | 5426.09 | 5429.28 | 8334.0 |
| 2024-04-23 20:00:00 | ES | Futures | 5429.28 | 5434.05 | 5426.62 | 5433.26 | 8261.0 |
| 2024-04-23 21:00:00 | ES | Futures | 5432.99 | 5435.38 | 5431.13 | 5435.11 | 6269.0 |
| 2024-04-23 22:00:00 | ES | Futures | 5434.85 | 5437.24 | 5434.05 | 5436.7 | 6463.0 |
| 2024-04-23 23:00:00 | ES | Futures | 5436.7 | 5440.95 | 5436.17 | 5438.83 | 7205.0 |
| 2024-04-23 00:00:00 | NQ | Futures | 18545.52 | 18556.49 | 18537.76 | 18544.45 | 2125.0 |
| 2024-04-23 01:00:00 | NQ | Futures | 18543.91 | 18556.22 | 18530.0 | 18550.07 | 3836.0 |
| 2024-04-23 02:00:00 | NQ | Futures | 18550.87 | 18569.86 | 18532.14 | 18566.38 | 4684.0 |
| 2024-04-23 03:00:00 | NQ | Futures | 18566.12 | 18586.18 | 18557.56 | 18579.22 | 10095.0 |
| 2024-04-23 04:00:00 | NQ | Futures | 18580.03 | 18619.89 | 18580.03 | 18600.89 | 10670.0 |
| 2024-04-23 05:00:00 | NQ | Futures | 18599.29 | 18623.36 | 18582.7 | 18592.06 | 8658.0 |
| 2024-04-23 06:00:00 | NQ | Futures | 18591.8 | 18636.2 | 18587.25 | 18629.52 | 8881.0 |
| 2024-04-23 07:00:00 | NQ | Futures | 18629.52 | 18650.11 | 18602.23 | 18608.65 | 11427.0 |
| 2024-04-23 08:00:00 | NQ | Futures | 18608.92 | 18647.97 | 18575.48 | 18641.82 | 18777.0 |
| 2024-04-23 09:00:00 | NQ | Futures | 18642.09 | 18754.97 | 18630.85 | 18726.35 | 109566.0 |
| 2024-04-23 10:00:00 | NQ | Futures | 18726.62 | 18831.21 | 18698.8 | 18824.26 | 106998.0 |
| 2024-04-23 11:00:00 | NQ | Futures | 18823.99 | 18840.31 | 18769.42 | 18793.5 | 63213.0 |
| 2024-04-23 12:00:00 | NQ | Futures | 18793.76 | 18849.14 | 18793.76 | 18825.6 | 41236.0 |
| 2024-04-23 13:00:00 | NQ | Futures | 18826.13 | 18875.89 | 18801.52 | 18871.61 | 44596.0 |
| 2024-04-23 14:00:00 | NQ | Futures | 18871.87 | 18893.54 | 18854.22 | 18880.7 | 35594.0 |
| 2024-04-23 15:00:00 | NQ | Futures | 18880.97 | 18884.71 | 18823.99 | 18840.04 | 60162.0 |
| 2024-04-23 16:00:00 | NQ | Futures | 18839.51 | 18902.9 | 18823.72 | 18892.74 | 26380.0 |
| 2024-04-23 18:00:00 | NQ | Futures | 18920.02 | 18937.15 | 18901.03 | 18917.08 | 5639.0 |
| 2024-04-23 19:00:00 | NQ | Futures | 18917.35 | 18957.74 | 18909.06 | 18939.55 | 6449.0 |
| 2024-04-23 20:00:00 | NQ | Futures | 18939.29 | 18961.22 | 18925.11 | 18954.53 | 5055.0 |
| 2024-04-23 21:00:00 | NQ | Futures | 18954.53 | 18972.72 | 18948.11 | 18967.91 | 5209.0 |
| 2024-04-23 22:00:00 | NQ | Futures | 18967.91 | 18979.68 | 18962.83 | 18969.25 | 3532.0 |
| 2024-04-23 23:00:00 | NQ | Futures | 18970.05 | 18987.7 | 18968.44 | 18974.86 | 3858.0 |
| 2024-04-23 00:00:00 | YM | Futures | 40853.2 | 40867.0 | 40837.3 | 40842.6 | 359.0 |
| 2024-04-23 01:00:00 | YM | Futures | 40843.7 | 40856.4 | 40826.7 | 40851.1 | 594.0 |
| 2024-04-23 02:00:00 | YM | Futures | 40852.2 | 40871.3 | 40822.5 | 40870.2 | 1081.0 |
| 2024-04-23 03:00:00 | YM | Futures | 40869.2 | 40909.5 | 40861.7 | 40884.0 | 2803.0 |
> showing 50 of 2,083 rows — these rows as CSV