PREVIEW / futures_1hour / 2024-02-07
file: by_date/futures_1hour/2024/2024-02-07.parquet size: 65 KB rows: 2,090
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-02-07 00:00:00 | ES | Futures | 5345.22 | 5345.76 | 5343.07 | 5344.95 | 3674.0 |
| 2024-02-07 01:00:00 | ES | Futures | 5345.22 | 5345.22 | 5340.66 | 5344.42 | 5065.0 |
| 2024-02-07 02:00:00 | ES | Futures | 5344.15 | 5345.22 | 5340.66 | 5341.73 | 5857.0 |
| 2024-02-07 03:00:00 | ES | Futures | 5341.73 | 5344.42 | 5340.92 | 5344.15 | 8087.0 |
| 2024-02-07 04:00:00 | ES | Futures | 5344.15 | 5346.56 | 5342.27 | 5345.49 | 8147.0 |
| 2024-02-07 05:00:00 | ES | Futures | 5345.49 | 5346.03 | 5339.58 | 5340.92 | 8336.0 |
| 2024-02-07 06:00:00 | ES | Futures | 5340.92 | 5345.76 | 5340.92 | 5344.42 | 10781.0 |
| 2024-02-07 07:00:00 | ES | Futures | 5344.42 | 5354.35 | 5340.39 | 5353.82 | 22218.0 |
| 2024-02-07 08:00:00 | ES | Futures | 5353.55 | 5362.95 | 5352.74 | 5360.8 | 39116.0 |
| 2024-02-07 09:00:00 | ES | Futures | 5360.8 | 5371.01 | 5358.92 | 5364.56 | 188868.0 |
| 2024-02-07 10:00:00 | ES | Futures | 5364.56 | 5388.2 | 5360.53 | 5379.6 | 257141.0 |
| 2024-02-07 11:00:00 | ES | Futures | 5379.6 | 5386.05 | 5375.04 | 5383.09 | 134469.0 |
| 2024-02-07 12:00:00 | ES | Futures | 5383.09 | 5386.05 | 5374.5 | 5382.82 | 98364.0 |
| 2024-02-07 13:00:00 | ES | Futures | 5382.82 | 5392.49 | 5377.45 | 5388.46 | 131773.0 |
| 2024-02-07 14:00:00 | ES | Futures | 5388.2 | 5391.42 | 5385.24 | 5391.15 | 81369.0 |
| 2024-02-07 15:00:00 | ES | Futures | 5391.15 | 5393.3 | 5383.36 | 5388.46 | 172230.0 |
| 2024-02-07 16:00:00 | ES | Futures | 5388.46 | 5389.27 | 5385.24 | 5388.46 | 56313.0 |
| 2024-02-07 18:00:00 | ES | Futures | 5388.73 | 5389.27 | 5384.17 | 5386.58 | 4938.0 |
| 2024-02-07 19:00:00 | ES | Futures | 5386.32 | 5386.85 | 5384.44 | 5384.97 | 3378.0 |
| 2024-02-07 20:00:00 | ES | Futures | 5384.97 | 5387.66 | 5383.9 | 5387.39 | 4456.0 |
| 2024-02-07 21:00:00 | ES | Futures | 5387.39 | 5388.73 | 5384.97 | 5385.78 | 3289.0 |
| 2024-02-07 22:00:00 | ES | Futures | 5385.78 | 5386.58 | 5385.24 | 5385.78 | 1747.0 |
| 2024-02-07 23:00:00 | ES | Futures | 5385.51 | 5387.12 | 5385.51 | 5386.58 | 1686.0 |
| 2024-02-07 00:00:00 | NQ | Futures | 19156.88 | 19163.93 | 19150.1 | 19161.76 | 2600.0 |
| 2024-02-07 01:00:00 | NQ | Futures | 19162.58 | 19162.58 | 19125.15 | 19145.22 | 4348.0 |
| 2024-02-07 02:00:00 | NQ | Futures | 19144.68 | 19150.64 | 19127.32 | 19136.81 | 4341.0 |
| 2024-02-07 03:00:00 | NQ | Futures | 19137.35 | 19154.98 | 19132.47 | 19153.35 | 4794.0 |
| 2024-02-07 04:00:00 | NQ | Futures | 19153.9 | 19177.49 | 19145.22 | 19173.15 | 6911.0 |
| 2024-02-07 05:00:00 | NQ | Futures | 19173.42 | 19183.73 | 19150.1 | 19159.86 | 5661.0 |
| 2024-02-07 06:00:00 | NQ | Futures | 19160.41 | 19188.88 | 19155.25 | 19180.47 | 6230.0 |
| 2024-02-07 07:00:00 | NQ | Futures | 19180.75 | 19213.56 | 19150.1 | 19211.39 | 12770.0 |
| 2024-02-07 08:00:00 | NQ | Futures | 19211.39 | 19251.8 | 19207.32 | 19240.14 | 23149.0 |
| 2024-02-07 09:00:00 | NQ | Futures | 19240.14 | 19287.6 | 19221.7 | 19250.99 | 94373.0 |
| 2024-02-07 10:00:00 | NQ | Futures | 19250.99 | 19391.74 | 19228.75 | 19346.18 | 122207.0 |
| 2024-02-07 11:00:00 | NQ | Futures | 19346.18 | 19368.42 | 19312.28 | 19358.11 | 72476.0 |
| 2024-02-07 12:00:00 | NQ | Futures | 19357.84 | 19368.15 | 19287.33 | 19330.45 | 55806.0 |
| 2024-02-07 13:00:00 | NQ | Futures | 19330.45 | 19373.84 | 19296.82 | 19366.52 | 58677.0 |
| 2024-02-07 14:00:00 | NQ | Futures | 19366.25 | 19376.56 | 19344.01 | 19368.42 | 36611.0 |
| 2024-02-07 15:00:00 | NQ | Futures | 19368.69 | 19381.71 | 19342.93 | 19354.59 | 53563.0 |
| 2024-02-07 16:00:00 | NQ | Futures | 19354.86 | 19375.47 | 19347.27 | 19370.86 | 14044.0 |
| 2024-02-07 18:00:00 | NQ | Futures | 19370.86 | 19370.86 | 19348.08 | 19356.22 | 2940.0 |
| 2024-02-07 19:00:00 | NQ | Futures | 19355.67 | 19357.3 | 19349.16 | 19351.88 | 1989.0 |
| 2024-02-07 20:00:00 | NQ | Futures | 19352.15 | 19366.79 | 19349.98 | 19365.44 | 3729.0 |
| 2024-02-07 21:00:00 | NQ | Futures | 19365.44 | 19372.49 | 19357.3 | 19360.01 | 2598.0 |
| 2024-02-07 22:00:00 | NQ | Futures | 19359.74 | 19364.35 | 19357.57 | 19360.28 | 1409.0 |
| 2024-02-07 23:00:00 | NQ | Futures | 19360.28 | 19367.88 | 19359.2 | 19364.89 | 1167.0 |
| 2024-02-07 00:00:00 | YM | Futures | 41484.1 | 41487.3 | 41472.3 | 41486.2 | 318.0 |
| 2024-02-07 01:00:00 | YM | Futures | 41487.3 | 41490.5 | 41464.8 | 41489.5 | 524.0 |
| 2024-02-07 02:00:00 | YM | Futures | 41488.4 | 41500.2 | 41466.9 | 41469.1 | 1560.0 |
| 2024-02-07 03:00:00 | YM | Futures | 41471.2 | 41504.5 | 41471.2 | 41502.4 | 1601.0 |
> showing 50 of 2,090 rows — these rows as CSV