PREVIEW / futures_1hour / 2024-10-14
file: by_date/futures_1hour/2024/2024-10-14.parquet size: 66 KB rows: 2,051
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-14 00:00:00 | ES | Futures | 6078.56 | 6079.34 | 6077.52 | 6078.82 | 1228.0 |
| 2024-10-14 01:00:00 | ES | Futures | 6079.08 | 6081.67 | 6078.82 | 6080.11 | 3294.0 |
| 2024-10-14 02:00:00 | ES | Futures | 6080.11 | 6083.23 | 6079.08 | 6082.19 | 4408.0 |
| 2024-10-14 03:00:00 | ES | Futures | 6082.45 | 6088.16 | 6079.08 | 6087.9 | 8036.0 |
| 2024-10-14 04:00:00 | ES | Futures | 6087.64 | 6089.2 | 6085.3 | 6086.34 | 8828.0 |
| 2024-10-14 05:00:00 | ES | Futures | 6086.34 | 6091.53 | 6086.34 | 6090.75 | 6736.0 |
| 2024-10-14 06:00:00 | ES | Futures | 6090.75 | 6098.28 | 6090.75 | 6093.09 | 13415.0 |
| 2024-10-14 07:00:00 | ES | Futures | 6093.09 | 6094.13 | 6090.24 | 6092.31 | 8666.0 |
| 2024-10-14 08:00:00 | ES | Futures | 6092.57 | 6097.5 | 6091.53 | 6096.72 | 13465.0 |
| 2024-10-14 09:00:00 | ES | Futures | 6096.98 | 6123.45 | 6096.72 | 6123.2 | 129136.0 |
| 2024-10-14 10:00:00 | ES | Futures | 6123.45 | 6128.65 | 6116.19 | 6118.78 | 123865.0 |
| 2024-10-14 11:00:00 | ES | Futures | 6118.52 | 6125.01 | 6113.07 | 6124.75 | 94668.0 |
| 2024-10-14 12:00:00 | ES | Futures | 6125.01 | 6130.46 | 6124.23 | 6128.9 | 52065.0 |
| 2024-10-14 13:00:00 | ES | Futures | 6128.9 | 6132.28 | 6125.79 | 6126.31 | 39950.0 |
| 2024-10-14 14:00:00 | ES | Futures | 6126.31 | 6137.47 | 6123.2 | 6133.06 | 74286.0 |
| 2024-10-14 15:00:00 | ES | Futures | 6133.32 | 6143.96 | 6130.46 | 6134.35 | 182300.0 |
| 2024-10-14 16:00:00 | ES | Futures | 6134.35 | 6139.55 | 6131.5 | 6139.03 | 49954.0 |
| 2024-10-14 18:00:00 | ES | Futures | 6139.55 | 6139.8 | 6134.87 | 6136.69 | 6342.0 |
| 2024-10-14 19:00:00 | ES | Futures | 6136.95 | 6139.03 | 6135.91 | 6137.99 | 2581.0 |
| 2024-10-14 20:00:00 | ES | Futures | 6138.25 | 6138.77 | 6131.5 | 6134.61 | 7657.0 |
| 2024-10-14 21:00:00 | ES | Futures | 6134.35 | 6139.8 | 6133.84 | 6139.03 | 5645.0 |
| 2024-10-14 22:00:00 | ES | Futures | 6138.77 | 6140.84 | 6137.73 | 6137.99 | 3171.0 |
| 2024-10-14 23:00:00 | ES | Futures | 6137.99 | 6139.55 | 6136.69 | 6139.55 | 3672.0 |
| 2024-10-14 00:00:00 | NQ | Futures | 21298.79 | 21305.06 | 21293.84 | 21303.23 | 814.0 |
| 2024-10-14 01:00:00 | NQ | Futures | 21304.27 | 21325.41 | 21302.19 | 21322.8 | 2727.0 |
| 2024-10-14 02:00:00 | NQ | Futures | 21322.8 | 21340.02 | 21316.54 | 21333.23 | 3350.0 |
| 2024-10-14 03:00:00 | NQ | Futures | 21333.23 | 21360.37 | 21315.75 | 21358.02 | 5065.0 |
| 2024-10-14 04:00:00 | NQ | Futures | 21357.76 | 21377.85 | 21348.11 | 21357.24 | 5796.0 |
| 2024-10-14 05:00:00 | NQ | Futures | 21358.02 | 21384.37 | 21358.02 | 21382.03 | 3666.0 |
| 2024-10-14 06:00:00 | NQ | Futures | 21382.03 | 21422.47 | 21382.03 | 21405.77 | 7138.0 |
| 2024-10-14 07:00:00 | NQ | Futures | 21406.29 | 21413.6 | 21392.46 | 21401.85 | 4737.0 |
| 2024-10-14 08:00:00 | NQ | Futures | 21402.38 | 21437.6 | 21397.42 | 21435.51 | 6660.0 |
| 2024-10-14 09:00:00 | NQ | Futures | 21435.25 | 21573.54 | 21434.73 | 21573.01 | 63750.0 |
| 2024-10-14 10:00:00 | NQ | Futures | 21573.8 | 21582.67 | 21448.04 | 21460.56 | 69032.0 |
| 2024-10-14 11:00:00 | NQ | Futures | 21460.82 | 21485.35 | 21420.9 | 21482.74 | 55131.0 |
| 2024-10-14 12:00:00 | NQ | Futures | 21482.48 | 21518.48 | 21476.21 | 21503.61 | 27897.0 |
| 2024-10-14 13:00:00 | NQ | Futures | 21503.87 | 21524.22 | 21493.17 | 21507.26 | 21851.0 |
| 2024-10-14 14:00:00 | NQ | Futures | 21507.52 | 21543.01 | 21495.52 | 21526.57 | 26131.0 |
| 2024-10-14 15:00:00 | NQ | Futures | 21526.57 | 21568.84 | 21512.74 | 21521.87 | 49522.0 |
| 2024-10-14 16:00:00 | NQ | Futures | 21521.61 | 21541.7 | 21502.05 | 21539.36 | 12799.0 |
| 2024-10-14 18:00:00 | NQ | Futures | 21539.62 | 21541.7 | 21514.05 | 21526.31 | 3235.0 |
| 2024-10-14 19:00:00 | NQ | Futures | 21526.05 | 21536.49 | 21519.79 | 21532.57 | 1547.0 |
| 2024-10-14 20:00:00 | NQ | Futures | 21532.57 | 21535.44 | 21488.74 | 21502.31 | 4711.0 |
| 2024-10-14 21:00:00 | NQ | Futures | 21501.52 | 21532.31 | 21497.35 | 21529.18 | 3109.0 |
| 2024-10-14 22:00:00 | NQ | Futures | 21528.92 | 21538.05 | 21519.0 | 21523.18 | 1757.0 |
| 2024-10-14 23:00:00 | NQ | Futures | 21522.4 | 21535.7 | 21516.66 | 21534.14 | 2067.0 |
| 2024-10-14 00:00:00 | YM | Futures | 44900.1 | 44903.3 | 44886.6 | 44891.8 | 315.0 |
| 2024-10-14 01:00:00 | YM | Futures | 44891.8 | 44899.1 | 44876.2 | 44881.4 | 618.0 |
| 2024-10-14 02:00:00 | YM | Futures | 44882.4 | 44898.1 | 44872.0 | 44896.0 | 841.0 |
| 2024-10-14 03:00:00 | YM | Futures | 44896.0 | 44929.3 | 44874.1 | 44928.2 | 1020.0 |
> showing 50 of 2,051 rows — these rows as CSV