PREVIEW / futures_1hour / 2024-08-30
file: by_date/futures_1hour/2024/2024-08-30.parquet size: 55 KB rows: 1,632
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-08-30 00:00:00 | ES | Futures | 5892.92 | 5895.54 | 5890.04 | 5895.02 | 2803.0 |
| 2024-08-30 01:00:00 | ES | Futures | 5894.76 | 5898.16 | 5892.4 | 5893.71 | 5386.0 |
| 2024-08-30 02:00:00 | ES | Futures | 5893.97 | 5899.21 | 5893.18 | 5895.02 | 8622.0 |
| 2024-08-30 03:00:00 | ES | Futures | 5895.02 | 5908.65 | 5893.71 | 5905.24 | 13528.0 |
| 2024-08-30 04:00:00 | ES | Futures | 5905.24 | 5909.18 | 5903.41 | 5906.03 | 9672.0 |
| 2024-08-30 05:00:00 | ES | Futures | 5905.77 | 5907.86 | 5903.67 | 5907.86 | 5243.0 |
| 2024-08-30 06:00:00 | ES | Futures | 5907.86 | 5911.01 | 5900.26 | 5910.75 | 8246.0 |
| 2024-08-30 07:00:00 | ES | Futures | 5910.49 | 5911.53 | 5902.36 | 5906.03 | 10284.0 |
| 2024-08-30 08:00:00 | ES | Futures | 5906.29 | 5914.16 | 5899.48 | 5901.31 | 33437.0 |
| 2024-08-30 09:00:00 | ES | Futures | 5901.57 | 5917.3 | 5899.21 | 5915.21 | 145502.0 |
| 2024-08-30 10:00:00 | ES | Futures | 5914.94 | 5920.71 | 5895.81 | 5896.59 | 188183.0 |
| 2024-08-30 11:00:00 | ES | Futures | 5896.59 | 5902.1 | 5876.93 | 5887.68 | 200570.0 |
| 2024-08-30 12:00:00 | ES | Futures | 5887.68 | 5893.18 | 5866.44 | 5887.42 | 154700.0 |
| 2024-08-30 13:00:00 | ES | Futures | 5887.15 | 5895.28 | 5881.65 | 5884.53 | 102192.0 |
| 2024-08-30 14:00:00 | ES | Futures | 5884.79 | 5906.55 | 5881.65 | 5903.93 | 116933.0 |
| 2024-08-30 15:00:00 | ES | Futures | 5903.93 | 5940.64 | 5898.16 | 5933.56 | 336246.0 |
| 2024-08-30 16:00:00 | ES | Futures | 5933.56 | 5936.96 | 5928.31 | 5931.72 | 85841.0 |
| 2024-08-30 00:00:00 | NQ | Futures | 20541.27 | 20556.58 | 20522.26 | 20552.89 | 1936.0 |
| 2024-08-30 01:00:00 | NQ | Futures | 20552.62 | 20571.63 | 20539.95 | 20543.91 | 3084.0 |
| 2024-08-30 02:00:00 | NQ | Futures | 20544.97 | 20578.49 | 20540.21 | 20569.52 | 4467.0 |
| 2024-08-30 03:00:00 | NQ | Futures | 20568.46 | 20632.34 | 20549.45 | 20613.87 | 7302.0 |
| 2024-08-30 04:00:00 | NQ | Futures | 20613.6 | 20626.54 | 20594.07 | 20610.17 | 5633.0 |
| 2024-08-30 05:00:00 | NQ | Futures | 20610.96 | 20622.84 | 20602.25 | 20622.05 | 2653.0 |
| 2024-08-30 06:00:00 | NQ | Futures | 20622.05 | 20640.53 | 20589.58 | 20640.26 | 4997.0 |
| 2024-08-30 07:00:00 | NQ | Futures | 20638.94 | 20638.94 | 20604.1 | 20618.88 | 4715.0 |
| 2024-08-30 08:00:00 | NQ | Futures | 20618.62 | 20667.72 | 20599.61 | 20618.35 | 17413.0 |
| 2024-08-30 09:00:00 | NQ | Futures | 20619.67 | 20699.66 | 20605.42 | 20688.84 | 60923.0 |
| 2024-08-30 10:00:00 | NQ | Futures | 20689.36 | 20726.59 | 20555.53 | 20557.64 | 81839.0 |
| 2024-08-30 11:00:00 | NQ | Futures | 20557.9 | 20593.8 | 20500.09 | 20550.25 | 63645.0 |
| 2024-08-30 12:00:00 | NQ | Futures | 20550.25 | 20572.68 | 20453.89 | 20551.83 | 49914.0 |
| 2024-08-30 13:00:00 | NQ | Futures | 20551.83 | 20590.11 | 20525.43 | 20534.14 | 36884.0 |
| 2024-08-30 14:00:00 | NQ | Futures | 20534.93 | 20631.02 | 20520.94 | 20615.98 | 34552.0 |
| 2024-08-30 15:00:00 | NQ | Futures | 20616.24 | 20730.81 | 20583.51 | 20707.05 | 72273.0 |
| 2024-08-30 16:00:00 | NQ | Futures | 20707.05 | 20723.95 | 20686.99 | 20690.42 | 14849.0 |
| 2024-08-30 00:00:00 | YM | Futures | 43555.8 | 43566.3 | 43542.2 | 43559.0 | 378.0 |
| 2024-08-30 01:00:00 | YM | Futures | 43561.1 | 43572.6 | 43546.4 | 43555.8 | 528.0 |
| 2024-08-30 02:00:00 | YM | Futures | 43556.9 | 43588.4 | 43539.0 | 43541.1 | 1403.0 |
| 2024-08-30 03:00:00 | YM | Futures | 43540.1 | 43619.9 | 43540.1 | 43607.3 | 1498.0 |
| 2024-08-30 04:00:00 | YM | Futures | 43607.3 | 43638.8 | 43596.8 | 43597.8 | 1214.0 |
| 2024-08-30 05:00:00 | YM | Futures | 43596.8 | 43627.3 | 43592.6 | 43627.3 | 925.0 |
| 2024-08-30 06:00:00 | YM | Futures | 43628.3 | 43647.2 | 43588.4 | 43646.2 | 1324.0 |
| 2024-08-30 07:00:00 | YM | Futures | 43646.2 | 43655.6 | 43613.6 | 43635.7 | 1210.0 |
| 2024-08-30 08:00:00 | YM | Futures | 43636.7 | 43669.3 | 43577.9 | 43582.1 | 2956.0 |
| 2024-08-30 09:00:00 | YM | Futures | 43582.1 | 43707.1 | 43511.7 | 43592.6 | 16785.0 |
| 2024-08-30 10:00:00 | YM | Futures | 43602.1 | 43653.5 | 43545.3 | 43545.3 | 15132.0 |
| 2024-08-30 11:00:00 | YM | Futures | 43546.4 | 43587.3 | 43403.5 | 43447.6 | 12393.0 |
| 2024-08-30 12:00:00 | YM | Futures | 43444.4 | 43492.8 | 43322.6 | 43445.5 | 9663.0 |
| 2024-08-30 13:00:00 | YM | Futures | 43445.5 | 43498.0 | 43395.1 | 43437.1 | 5833.0 |
| 2024-08-30 14:00:00 | YM | Futures | 43437.1 | 43553.7 | 43422.4 | 43525.3 | 6142.0 |
| 2024-08-30 15:00:00 | YM | Futures | 43524.3 | 43788.0 | 43484.4 | 43745.0 | 16376.0 |
> showing 50 of 1,632 rows — these rows as CSV