PREVIEW / futures_1hour / 2024-06-18
file: by_date/futures_1hour/2024/2024-06-18.parquet size: 64 KB rows: 2,005
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-06-18 00:00:00 | ES | Futures | 5816.11 | 5817.16 | 5813.49 | 5814.27 | 1939.0 |
| 2024-06-18 01:00:00 | ES | Futures | 5814.27 | 5817.94 | 5813.49 | 5817.68 | 2444.0 |
| 2024-06-18 02:00:00 | ES | Futures | 5817.94 | 5819.78 | 5816.11 | 5817.42 | 7799.0 |
| 2024-06-18 03:00:00 | ES | Futures | 5817.42 | 5819.25 | 5813.22 | 5813.49 | 12869.0 |
| 2024-06-18 04:00:00 | ES | Futures | 5813.49 | 5817.94 | 5811.13 | 5815.58 | 15312.0 |
| 2024-06-18 05:00:00 | ES | Futures | 5815.32 | 5821.35 | 5815.32 | 5818.2 | 10505.0 |
| 2024-06-18 06:00:00 | ES | Futures | 5817.94 | 5821.09 | 5814.53 | 5815.58 | 10554.0 |
| 2024-06-18 07:00:00 | ES | Futures | 5815.85 | 5816.37 | 5814.01 | 5815.32 | 12280.0 |
| 2024-06-18 08:00:00 | ES | Futures | 5815.58 | 5823.45 | 5812.17 | 5815.32 | 43976.0 |
| 2024-06-18 09:00:00 | ES | Futures | 5815.32 | 5829.22 | 5811.91 | 5821.87 | 142405.0 |
| 2024-06-18 10:00:00 | ES | Futures | 5821.87 | 5826.59 | 5815.58 | 5817.16 | 136165.0 |
| 2024-06-18 11:00:00 | ES | Futures | 5817.42 | 5824.76 | 5813.22 | 5824.5 | 101604.0 |
| 2024-06-18 12:00:00 | ES | Futures | 5824.23 | 5827.38 | 5818.2 | 5824.76 | 78092.0 |
| 2024-06-18 13:00:00 | ES | Futures | 5824.76 | 5832.89 | 5820.56 | 5827.38 | 84765.0 |
| 2024-06-18 14:00:00 | ES | Futures | 5827.64 | 5827.9 | 5816.37 | 5826.59 | 98867.0 |
| 2024-06-18 15:00:00 | ES | Futures | 5826.86 | 5832.36 | 5820.04 | 5832.1 | 167888.0 |
| 2024-06-18 16:00:00 | ES | Futures | 5832.1 | 5833.41 | 5827.9 | 5832.62 | 40671.0 |
| 2024-06-18 18:00:00 | ES | Futures | 5832.36 | 5837.87 | 5830.53 | 5837.08 | 4194.0 |
| 2024-06-18 19:00:00 | ES | Futures | 5837.08 | 5837.08 | 5833.93 | 5835.51 | 2138.0 |
| 2024-06-18 20:00:00 | ES | Futures | 5835.51 | 5835.51 | 5830.79 | 5831.57 | 4099.0 |
| 2024-06-18 21:00:00 | ES | Futures | 5831.31 | 5833.15 | 5830.79 | 5831.57 | 2376.0 |
| 2024-06-18 22:00:00 | ES | Futures | 5831.57 | 5833.93 | 5831.57 | 5832.1 | 1568.0 |
| 2024-06-18 23:00:00 | ES | Futures | 5832.1 | 5833.41 | 5831.05 | 5831.57 | 1143.0 |
| 2024-06-18 00:00:00 | NQ | Futures | 21312.63 | 21316.32 | 21301.28 | 21306.82 | 1313.0 |
| 2024-06-18 01:00:00 | NQ | Futures | 21307.08 | 21322.13 | 21301.01 | 21319.23 | 1804.0 |
| 2024-06-18 02:00:00 | NQ | Futures | 21319.75 | 21332.95 | 21315.8 | 21327.67 | 4000.0 |
| 2024-06-18 03:00:00 | NQ | Futures | 21327.94 | 21346.42 | 21319.49 | 21335.59 | 6206.0 |
| 2024-06-18 04:00:00 | NQ | Futures | 21335.59 | 21367.27 | 21334.54 | 21356.98 | 7386.0 |
| 2024-06-18 05:00:00 | NQ | Futures | 21356.71 | 21384.69 | 21355.13 | 21369.65 | 5871.0 |
| 2024-06-18 06:00:00 | NQ | Futures | 21369.65 | 21379.94 | 21349.06 | 21357.77 | 5246.0 |
| 2024-06-18 07:00:00 | NQ | Futures | 21357.77 | 21365.16 | 21341.93 | 21353.28 | 5527.0 |
| 2024-06-18 08:00:00 | NQ | Futures | 21353.81 | 21404.23 | 21321.6 | 21340.87 | 21089.0 |
| 2024-06-18 09:00:00 | NQ | Futures | 21340.61 | 21349.85 | 21292.04 | 21307.61 | 80563.0 |
| 2024-06-18 10:00:00 | NQ | Futures | 21307.61 | 21343.78 | 21282.27 | 21290.45 | 71942.0 |
| 2024-06-18 11:00:00 | NQ | Futures | 21290.19 | 21317.91 | 21252.7 | 21316.59 | 56718.0 |
| 2024-06-18 12:00:00 | NQ | Futures | 21316.06 | 21340.35 | 21296.52 | 21335.07 | 38580.0 |
| 2024-06-18 13:00:00 | NQ | Futures | 21335.33 | 21360.94 | 21315.0 | 21332.43 | 40487.0 |
| 2024-06-18 14:00:00 | NQ | Futures | 21332.69 | 21337.71 | 21287.81 | 21330.05 | 43810.0 |
| 2024-06-18 15:00:00 | NQ | Futures | 21330.05 | 21339.82 | 21303.92 | 21329.79 | 69025.0 |
| 2024-06-18 16:00:00 | NQ | Futures | 21329.79 | 21340.35 | 21321.07 | 21340.35 | 11373.0 |
| 2024-06-18 18:00:00 | NQ | Futures | 21334.54 | 21364.37 | 21334.01 | 21361.2 | 2569.0 |
| 2024-06-18 19:00:00 | NQ | Futures | 21360.67 | 21360.94 | 21348.53 | 21354.86 | 1363.0 |
| 2024-06-18 20:00:00 | NQ | Futures | 21354.34 | 21355.13 | 21339.03 | 21342.19 | 2318.0 |
| 2024-06-18 21:00:00 | NQ | Futures | 21341.93 | 21351.7 | 21340.08 | 21345.36 | 1482.0 |
| 2024-06-18 22:00:00 | NQ | Futures | 21345.89 | 21357.24 | 21343.51 | 21351.17 | 1430.0 |
| 2024-06-18 23:00:00 | NQ | Futures | 21351.43 | 21358.82 | 21346.68 | 21350.64 | 1227.0 |
| 2024-06-18 00:00:00 | YM | Futures | 41252.6 | 41258.9 | 41236.9 | 41241.1 | 433.0 |
| 2024-06-18 01:00:00 | YM | Futures | 41244.2 | 41263.1 | 41236.9 | 41263.1 | 398.0 |
| 2024-06-18 02:00:00 | YM | Futures | 41262.1 | 41278.9 | 41246.3 | 41247.4 | 1072.0 |
| 2024-06-18 03:00:00 | YM | Futures | 41246.3 | 41268.4 | 41195.9 | 41196.9 | 1772.0 |
> showing 50 of 2,005 rows — these rows as CSV