PREVIEW / futures_1hour / 2024-08-07
file: by_date/futures_1hour/2024/2024-08-07.parquet size: 71 KB rows: 2,145
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-07 00:00:00 | ES | Futures | 5568.1 | 5578.32 | 5567.31 | 5573.34 | 10019.0 |
| 2024-08-07 01:00:00 | ES | Futures | 5573.34 | 5575.18 | 5558.66 | 5560.76 | 13755.0 |
| 2024-08-07 02:00:00 | ES | Futures | 5561.02 | 5564.43 | 5540.84 | 5557.09 | 17747.0 |
| 2024-08-07 03:00:00 | ES | Futures | 5557.09 | 5562.59 | 5536.9 | 5546.6 | 33092.0 |
| 2024-08-07 04:00:00 | ES | Futures | 5546.86 | 5577.54 | 5544.24 | 5577.54 | 22425.0 |
| 2024-08-07 05:00:00 | ES | Futures | 5577.28 | 5586.71 | 5573.08 | 5581.73 | 22565.0 |
| 2024-08-07 06:00:00 | ES | Futures | 5581.73 | 5590.65 | 5579.64 | 5588.55 | 20590.0 |
| 2024-08-07 07:00:00 | ES | Futures | 5588.55 | 5593.53 | 5577.8 | 5580.68 | 24546.0 |
| 2024-08-07 08:00:00 | ES | Futures | 5580.68 | 5588.29 | 5575.7 | 5585.67 | 31122.0 |
| 2024-08-07 09:00:00 | ES | Futures | 5585.4 | 5615.29 | 5577.8 | 5613.98 | 221468.0 |
| 2024-08-07 10:00:00 | ES | Futures | 5613.72 | 5620.01 | 5584.35 | 5607.69 | 307632.0 |
| 2024-08-07 11:00:00 | ES | Futures | 5607.69 | 5615.03 | 5571.51 | 5581.99 | 197265.0 |
| 2024-08-07 12:00:00 | ES | Futures | 5582.26 | 5582.78 | 5546.08 | 5550.54 | 200465.0 |
| 2024-08-07 13:00:00 | ES | Futures | 5550.27 | 5553.94 | 5512.52 | 5518.55 | 226431.0 |
| 2024-08-07 14:00:00 | ES | Futures | 5518.29 | 5520.39 | 5484.99 | 5491.55 | 228720.0 |
| 2024-08-07 15:00:00 | ES | Futures | 5491.55 | 5519.08 | 5476.34 | 5483.16 | 324551.0 |
| 2024-08-07 16:00:00 | ES | Futures | 5483.16 | 5488.4 | 5449.6 | 5455.37 | 126284.0 |
| 2024-08-07 18:00:00 | ES | Futures | 5461.66 | 5472.93 | 5455.89 | 5466.64 | 20222.0 |
| 2024-08-07 19:00:00 | ES | Futures | 5466.64 | 5467.95 | 5434.13 | 5455.37 | 27565.0 |
| 2024-08-07 20:00:00 | ES | Futures | 5455.11 | 5474.77 | 5451.18 | 5463.76 | 22757.0 |
| 2024-08-07 21:00:00 | ES | Futures | 5463.76 | 5478.18 | 5461.4 | 5476.34 | 12976.0 |
| 2024-08-07 22:00:00 | ES | Futures | 5476.34 | 5487.09 | 5476.34 | 5484.73 | 14300.0 |
| 2024-08-07 23:00:00 | ES | Futures | 5484.99 | 5494.43 | 5478.96 | 5484.73 | 10921.0 |
| 2024-08-07 00:00:00 | NQ | Futures | 19415.91 | 19470.03 | 19399.55 | 19427.79 | 4574.0 |
| 2024-08-07 01:00:00 | NQ | Futures | 19428.06 | 19437.56 | 19339.36 | 19353.35 | 5576.0 |
| 2024-08-07 02:00:00 | NQ | Futures | 19353.61 | 19373.15 | 19272.83 | 19341.73 | 6380.0 |
| 2024-08-07 03:00:00 | NQ | Futures | 19342.26 | 19359.68 | 19239.04 | 19278.11 | 11563.0 |
| 2024-08-07 04:00:00 | NQ | Futures | 19281.81 | 19427.0 | 19264.12 | 19425.68 | 10649.0 |
| 2024-08-07 05:00:00 | NQ | Futures | 19425.42 | 19477.16 | 19399.55 | 19439.67 | 8393.0 |
| 2024-08-07 06:00:00 | NQ | Futures | 19441.52 | 19482.96 | 19427.0 | 19468.18 | 6738.0 |
| 2024-08-07 07:00:00 | NQ | Futures | 19468.18 | 19494.32 | 19405.88 | 19423.3 | 8960.0 |
| 2024-08-07 08:00:00 | NQ | Futures | 19425.42 | 19484.81 | 19412.48 | 19462.9 | 13718.0 |
| 2024-08-07 09:00:00 | NQ | Futures | 19463.96 | 19596.48 | 19434.92 | 19556.35 | 82769.0 |
| 2024-08-07 10:00:00 | NQ | Futures | 19556.09 | 19594.89 | 19435.18 | 19546.32 | 100919.0 |
| 2024-08-07 11:00:00 | NQ | Futures | 19547.38 | 19586.18 | 19367.08 | 19428.06 | 71948.0 |
| 2024-08-07 12:00:00 | NQ | Futures | 19429.9 | 19434.13 | 19280.49 | 19304.25 | 65962.0 |
| 2024-08-07 13:00:00 | NQ | Futures | 19304.51 | 19321.41 | 19107.05 | 19130.28 | 73593.0 |
| 2024-08-07 14:00:00 | NQ | Futures | 19130.55 | 19148.5 | 19007.27 | 19038.42 | 71944.0 |
| 2024-08-07 15:00:00 | NQ | Futures | 19038.68 | 19161.96 | 18955.79 | 18977.7 | 86137.0 |
| 2024-08-07 16:00:00 | NQ | Futures | 18977.7 | 19006.74 | 18833.83 | 18853.1 | 27672.0 |
| 2024-08-07 18:00:00 | NQ | Futures | 18872.64 | 18930.71 | 18861.29 | 18895.87 | 9376.0 |
| 2024-08-07 19:00:00 | NQ | Futures | 18897.19 | 18906.95 | 18734.05 | 18841.22 | 10340.0 |
| 2024-08-07 20:00:00 | NQ | Futures | 18844.65 | 18945.5 | 18821.95 | 18910.91 | 10804.0 |
| 2024-08-07 21:00:00 | NQ | Futures | 18907.22 | 18994.6 | 18895.08 | 18984.04 | 7027.0 |
| 2024-08-07 22:00:00 | NQ | Futures | 18983.25 | 19051.35 | 18983.25 | 19038.42 | 7092.0 |
| 2024-08-07 23:00:00 | NQ | Futures | 19039.21 | 19090.42 | 19000.14 | 19028.65 | 5370.0 |
| 2024-08-07 00:00:00 | YM | Futures | 41405.0 | 41441.8 | 41400.8 | 41432.3 | 929.0 |
| 2024-08-07 01:00:00 | YM | Futures | 41433.3 | 41448.1 | 41361.9 | 41384.0 | 1356.0 |
| 2024-08-07 02:00:00 | YM | Futures | 41379.8 | 41395.5 | 41271.5 | 41370.3 | 2828.0 |
| 2024-08-07 03:00:00 | YM | Futures | 41371.4 | 41391.3 | 41260.0 | 41326.2 | 3496.0 |
> showing 50 of 2,145 rows — these rows as CSV