PREVIEW / futures_1hour / 2024-08-28
file: by_date/futures_1hour/2024/2024-08-28.parquet size: 65 KB rows: 2,065
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-28 00:00:00 | ES | Futures | 5917.04 | 5919.92 | 5916.52 | 5918.61 | 1410.0 |
| 2024-08-28 01:00:00 | ES | Futures | 5918.61 | 5919.4 | 5916.78 | 5918.88 | 2157.0 |
| 2024-08-28 02:00:00 | ES | Futures | 5918.88 | 5921.23 | 5917.56 | 5920.19 | 3573.0 |
| 2024-08-28 03:00:00 | ES | Futures | 5920.45 | 5920.71 | 5915.99 | 5919.66 | 7077.0 |
| 2024-08-28 04:00:00 | ES | Futures | 5919.66 | 5925.17 | 5916.25 | 5924.38 | 10212.0 |
| 2024-08-28 05:00:00 | ES | Futures | 5924.38 | 5925.43 | 5920.97 | 5923.07 | 5427.0 |
| 2024-08-28 06:00:00 | ES | Futures | 5923.07 | 5923.59 | 5920.19 | 5920.71 | 6529.0 |
| 2024-08-28 07:00:00 | ES | Futures | 5920.71 | 5921.5 | 5911.53 | 5913.11 | 10293.0 |
| 2024-08-28 08:00:00 | ES | Futures | 5913.11 | 5917.56 | 5910.22 | 5917.04 | 18367.0 |
| 2024-08-28 09:00:00 | ES | Futures | 5917.04 | 5919.14 | 5907.86 | 5912.85 | 124190.0 |
| 2024-08-28 10:00:00 | ES | Futures | 5912.58 | 5915.21 | 5895.54 | 5897.64 | 162713.0 |
| 2024-08-28 11:00:00 | ES | Futures | 5897.64 | 5897.9 | 5876.67 | 5885.06 | 203944.0 |
| 2024-08-28 12:00:00 | ES | Futures | 5885.06 | 5887.42 | 5868.28 | 5886.1 | 105729.0 |
| 2024-08-28 13:00:00 | ES | Futures | 5886.1 | 5889.51 | 5850.71 | 5852.29 | 129763.0 |
| 2024-08-28 14:00:00 | ES | Futures | 5852.29 | 5882.17 | 5848.88 | 5880.86 | 143073.0 |
| 2024-08-28 15:00:00 | ES | Futures | 5880.6 | 5895.02 | 5871.42 | 5884.53 | 213766.0 |
| 2024-08-28 16:00:00 | ES | Futures | 5884.53 | 5889.51 | 5847.3 | 5865.66 | 134826.0 |
| 2024-08-28 18:00:00 | ES | Futures | 5852.02 | 5858.84 | 5831.84 | 5841.27 | 20596.0 |
| 2024-08-28 19:00:00 | ES | Futures | 5841.54 | 5844.68 | 5838.39 | 5843.11 | 5598.0 |
| 2024-08-28 20:00:00 | ES | Futures | 5843.11 | 5856.48 | 5842.59 | 5854.38 | 9112.0 |
| 2024-08-28 21:00:00 | ES | Futures | 5854.38 | 5855.96 | 5848.88 | 5851.76 | 6268.0 |
| 2024-08-28 22:00:00 | ES | Futures | 5852.02 | 5861.2 | 5850.45 | 5860.15 | 4367.0 |
| 2024-08-28 23:00:00 | ES | Futures | 5860.15 | 5862.51 | 5859.1 | 5861.2 | 3713.0 |
| 2024-08-28 00:00:00 | NQ | Futures | 20716.82 | 20733.98 | 20713.39 | 20728.7 | 1312.0 |
| 2024-08-28 01:00:00 | NQ | Futures | 20728.17 | 20733.19 | 20715.5 | 20730.55 | 2101.0 |
| 2024-08-28 02:00:00 | NQ | Futures | 20730.55 | 20749.55 | 20727.38 | 20744.27 | 2530.0 |
| 2024-08-28 03:00:00 | NQ | Futures | 20745.33 | 20753.78 | 20721.57 | 20746.38 | 3820.0 |
| 2024-08-28 04:00:00 | NQ | Futures | 20745.06 | 20792.32 | 20722.1 | 20783.08 | 6874.0 |
| 2024-08-28 05:00:00 | NQ | Futures | 20783.61 | 20791.26 | 20758.53 | 20766.98 | 3840.0 |
| 2024-08-28 06:00:00 | NQ | Futures | 20768.3 | 20776.48 | 20756.42 | 20761.96 | 3567.0 |
| 2024-08-28 07:00:00 | NQ | Futures | 20762.49 | 20767.5 | 20706.26 | 20716.03 | 7069.0 |
| 2024-08-28 08:00:00 | NQ | Futures | 20715.76 | 20745.86 | 20701.77 | 20740.84 | 8398.0 |
| 2024-08-28 09:00:00 | NQ | Futures | 20740.58 | 20755.89 | 20622.84 | 20651.62 | 60845.0 |
| 2024-08-28 10:00:00 | NQ | Futures | 20651.88 | 20689.1 | 20542.59 | 20542.85 | 72996.0 |
| 2024-08-28 11:00:00 | NQ | Futures | 20542.59 | 20543.12 | 20420.89 | 20513.29 | 81787.0 |
| 2024-08-28 12:00:00 | NQ | Futures | 20513.02 | 20551.3 | 20445.18 | 20541.53 | 43252.0 |
| 2024-08-28 13:00:00 | NQ | Futures | 20540.74 | 20557.64 | 20370.21 | 20376.02 | 48861.0 |
| 2024-08-28 14:00:00 | NQ | Futures | 20376.55 | 20522.53 | 20356.75 | 20516.72 | 49811.0 |
| 2024-08-28 15:00:00 | NQ | Futures | 20516.46 | 20572.42 | 20492.7 | 20507.22 | 67176.0 |
| 2024-08-28 16:00:00 | NQ | Futures | 20507.22 | 20548.4 | 20302.63 | 20390.27 | 46003.0 |
| 2024-08-28 18:00:00 | NQ | Futures | 20291.81 | 20341.96 | 20210.76 | 20257.49 | 13831.0 |
| 2024-08-28 19:00:00 | NQ | Futures | 20256.7 | 20278.34 | 20244.82 | 20268.05 | 3965.0 |
| 2024-08-28 20:00:00 | NQ | Futures | 20266.99 | 20332.2 | 20264.88 | 20317.41 | 7379.0 |
| 2024-08-28 21:00:00 | NQ | Futures | 20317.68 | 20329.82 | 20290.22 | 20305.53 | 4826.0 |
| 2024-08-28 22:00:00 | NQ | Futures | 20306.06 | 20346.72 | 20292.86 | 20338.0 | 3541.0 |
| 2024-08-28 23:00:00 | NQ | Futures | 20337.21 | 20356.48 | 20336.42 | 20352.26 | 2386.0 |
| 2024-08-28 00:00:00 | YM | Futures | 43456.0 | 43468.6 | 43452.8 | 43461.3 | 216.0 |
| 2024-08-28 01:00:00 | YM | Futures | 43459.2 | 43464.4 | 43450.7 | 43462.3 | 375.0 |
| 2024-08-28 02:00:00 | YM | Futures | 43462.3 | 43479.1 | 43454.9 | 43477.0 | 744.0 |
| 2024-08-28 03:00:00 | YM | Futures | 43476.0 | 43479.1 | 43452.8 | 43470.7 | 870.0 |
> showing 50 of 2,065 rows — these rows as CSV