PREVIEW / futures_1hour / 2024-10-09
file: by_date/futures_1hour/2024/2024-10-09.parquet size: 67 KB rows: 2,085
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-09 00:00:00 | ES | Futures | 6010.82 | 6012.12 | 6007.97 | 6009.26 | 2156.0 |
| 2024-10-09 01:00:00 | ES | Futures | 6009.52 | 6013.94 | 6007.71 | 6008.75 | 6683.0 |
| 2024-10-09 02:00:00 | ES | Futures | 6008.49 | 6010.82 | 6004.07 | 6006.93 | 6827.0 |
| 2024-10-09 03:00:00 | ES | Futures | 6006.93 | 6008.49 | 6000.96 | 6006.93 | 13300.0 |
| 2024-10-09 04:00:00 | ES | Futures | 6006.93 | 6009.78 | 6002.26 | 6008.75 | 9260.0 |
| 2024-10-09 05:00:00 | ES | Futures | 6008.75 | 6016.27 | 6008.23 | 6014.71 | 7286.0 |
| 2024-10-09 06:00:00 | ES | Futures | 6014.45 | 6022.24 | 6013.16 | 6018.61 | 8235.0 |
| 2024-10-09 07:00:00 | ES | Futures | 6018.61 | 6020.94 | 6015.75 | 6016.53 | 10303.0 |
| 2024-10-09 08:00:00 | ES | Futures | 6016.53 | 6020.94 | 6013.16 | 6018.35 | 20540.0 |
| 2024-10-09 09:00:00 | ES | Futures | 6018.61 | 6027.43 | 6014.45 | 6025.35 | 116582.0 |
| 2024-10-09 10:00:00 | ES | Futures | 6025.35 | 6040.41 | 6024.06 | 6039.63 | 153645.0 |
| 2024-10-09 11:00:00 | ES | Futures | 6039.63 | 6062.47 | 6039.63 | 6060.91 | 134475.0 |
| 2024-10-09 12:00:00 | ES | Futures | 6060.91 | 6061.17 | 6046.38 | 6050.01 | 93065.0 |
| 2024-10-09 13:00:00 | ES | Futures | 6050.01 | 6057.8 | 6040.41 | 6048.45 | 100445.0 |
| 2024-10-09 14:00:00 | ES | Futures | 6048.45 | 6056.76 | 6045.34 | 6053.64 | 88091.0 |
| 2024-10-09 15:00:00 | ES | Futures | 6053.38 | 6069.21 | 6048.19 | 6062.21 | 201285.0 |
| 2024-10-09 16:00:00 | ES | Futures | 6062.47 | 6063.25 | 6053.64 | 6058.83 | 58267.0 |
| 2024-10-09 18:00:00 | ES | Futures | 6058.31 | 6061.43 | 6056.5 | 6060.39 | 3878.0 |
| 2024-10-09 19:00:00 | ES | Futures | 6060.39 | 6062.99 | 6058.57 | 6061.17 | 3007.0 |
| 2024-10-09 20:00:00 | ES | Futures | 6061.43 | 6063.5 | 6058.83 | 6061.95 | 4254.0 |
| 2024-10-09 21:00:00 | ES | Futures | 6061.69 | 6064.54 | 6060.65 | 6062.21 | 5518.0 |
| 2024-10-09 22:00:00 | ES | Futures | 6061.95 | 6065.06 | 6059.87 | 6064.02 | 4332.0 |
| 2024-10-09 23:00:00 | ES | Futures | 6064.02 | 6065.32 | 6062.21 | 6064.54 | 3177.0 |
| 2024-10-09 00:00:00 | NQ | Futures | 21120.33 | 21129.72 | 21105.46 | 21114.33 | 1624.0 |
| 2024-10-09 01:00:00 | NQ | Futures | 21114.07 | 21135.72 | 21109.37 | 21115.37 | 3649.0 |
| 2024-10-09 02:00:00 | NQ | Futures | 21114.33 | 21125.29 | 21092.41 | 21114.59 | 4262.0 |
| 2024-10-09 03:00:00 | NQ | Futures | 21114.59 | 21125.03 | 21077.54 | 21110.42 | 7147.0 |
| 2024-10-09 04:00:00 | NQ | Futures | 21111.2 | 21131.81 | 21091.11 | 21126.85 | 6450.0 |
| 2024-10-09 05:00:00 | NQ | Futures | 21126.85 | 21153.47 | 21125.29 | 21146.94 | 3949.0 |
| 2024-10-09 06:00:00 | NQ | Futures | 21146.42 | 21178.77 | 21139.12 | 21166.51 | 4851.0 |
| 2024-10-09 07:00:00 | NQ | Futures | 21165.73 | 21177.21 | 21138.07 | 21140.94 | 5619.0 |
| 2024-10-09 08:00:00 | NQ | Futures | 21142.25 | 21163.9 | 21133.12 | 21156.34 | 9382.0 |
| 2024-10-09 09:00:00 | NQ | Futures | 21155.81 | 21186.86 | 21121.9 | 21150.6 | 55454.0 |
| 2024-10-09 10:00:00 | NQ | Futures | 21150.07 | 21252.61 | 21147.73 | 21250.0 | 67715.0 |
| 2024-10-09 11:00:00 | NQ | Futures | 21250.79 | 21340.8 | 21249.48 | 21337.93 | 49669.0 |
| 2024-10-09 12:00:00 | NQ | Futures | 21338.45 | 21339.76 | 21257.05 | 21285.75 | 43001.0 |
| 2024-10-09 13:00:00 | NQ | Futures | 21285.49 | 21320.97 | 21243.48 | 21289.14 | 32243.0 |
| 2024-10-09 14:00:00 | NQ | Futures | 21290.18 | 21354.89 | 21278.97 | 21325.41 | 35937.0 |
| 2024-10-09 15:00:00 | NQ | Futures | 21325.15 | 21376.81 | 21295.92 | 21351.24 | 50258.0 |
| 2024-10-09 16:00:00 | NQ | Futures | 21350.98 | 21352.02 | 21308.45 | 21341.85 | 15265.0 |
| 2024-10-09 18:00:00 | NQ | Futures | 21337.67 | 21345.5 | 21327.76 | 21341.58 | 2310.0 |
| 2024-10-09 19:00:00 | NQ | Futures | 21340.8 | 21354.63 | 21330.89 | 21342.63 | 2298.0 |
| 2024-10-09 20:00:00 | NQ | Futures | 21343.41 | 21351.24 | 21327.76 | 21344.98 | 2331.0 |
| 2024-10-09 21:00:00 | NQ | Futures | 21342.63 | 21356.98 | 21338.19 | 21343.67 | 2488.0 |
| 2024-10-09 22:00:00 | NQ | Futures | 21343.15 | 21365.85 | 21335.84 | 21361.67 | 2317.0 |
| 2024-10-09 23:00:00 | NQ | Futures | 21361.15 | 21367.68 | 21352.54 | 21364.54 | 1850.0 |
| 2024-10-09 00:00:00 | YM | Futures | 44060.2 | 44065.5 | 44046.7 | 44053.0 | 113.0 |
| 2024-10-09 01:00:00 | YM | Futures | 44055.0 | 44076.9 | 44039.4 | 44047.8 | 582.0 |
| 2024-10-09 02:00:00 | YM | Futures | 44047.8 | 44063.4 | 44022.8 | 44028.0 | 851.0 |
| 2024-10-09 03:00:00 | YM | Futures | 44029.0 | 44039.4 | 43985.3 | 44033.2 | 1289.0 |
> showing 50 of 2,085 rows — these rows as CSV