PREVIEW / futures_1hour / 2024-07-25
file: by_date/futures_1hour/2024/2024-07-25.parquet size: 70 KB rows: 2,135
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-07-25 00:00:00 | ES | Futures | 5750.83 | 5752.4 | 5747.94 | 5749.52 | 5597.0 |
| 2024-07-25 01:00:00 | ES | Futures | 5749.52 | 5751.88 | 5744.27 | 5744.8 | 6607.0 |
| 2024-07-25 02:00:00 | ES | Futures | 5744.8 | 5749.78 | 5727.23 | 5746.37 | 34155.0 |
| 2024-07-25 03:00:00 | ES | Futures | 5746.37 | 5749.26 | 5728.02 | 5732.74 | 46259.0 |
| 2024-07-25 04:00:00 | ES | Futures | 5732.74 | 5743.49 | 5716.22 | 5741.65 | 61052.0 |
| 2024-07-25 05:00:00 | ES | Futures | 5741.91 | 5747.94 | 5726.97 | 5728.81 | 31595.0 |
| 2024-07-25 06:00:00 | ES | Futures | 5728.81 | 5731.69 | 5719.89 | 5729.59 | 29953.0 |
| 2024-07-25 07:00:00 | ES | Futures | 5729.59 | 5737.46 | 5723.04 | 5723.83 | 31636.0 |
| 2024-07-25 08:00:00 | ES | Futures | 5723.83 | 5741.91 | 5717.53 | 5741.91 | 81212.0 |
| 2024-07-25 09:00:00 | ES | Futures | 5741.91 | 5741.91 | 5719.37 | 5722.25 | 292719.0 |
| 2024-07-25 10:00:00 | ES | Futures | 5722.51 | 5753.45 | 5696.82 | 5752.93 | 548354.0 |
| 2024-07-25 11:00:00 | ES | Futures | 5752.93 | 5772.33 | 5745.06 | 5765.25 | 323096.0 |
| 2024-07-25 12:00:00 | ES | Futures | 5765.25 | 5793.56 | 5758.17 | 5788.06 | 266989.0 |
| 2024-07-25 13:00:00 | ES | Futures | 5788.06 | 5802.47 | 5766.82 | 5772.33 | 214741.0 |
| 2024-07-25 14:00:00 | ES | Futures | 5772.33 | 5772.85 | 5729.07 | 5732.21 | 237052.0 |
| 2024-07-25 15:00:00 | ES | Futures | 5731.95 | 5762.63 | 5703.64 | 5706.0 | 400693.0 |
| 2024-07-25 16:00:00 | ES | Futures | 5706.0 | 5710.19 | 5697.61 | 5709.67 | 126760.0 |
| 2024-07-25 18:00:00 | ES | Futures | 5710.98 | 5718.06 | 5710.19 | 5711.5 | 10447.0 |
| 2024-07-25 19:00:00 | ES | Futures | 5711.5 | 5717.01 | 5710.46 | 5716.75 | 5712.0 |
| 2024-07-25 20:00:00 | ES | Futures | 5716.48 | 5724.35 | 5715.7 | 5720.16 | 7593.0 |
| 2024-07-25 21:00:00 | ES | Futures | 5720.16 | 5729.33 | 5719.63 | 5728.02 | 7231.0 |
| 2024-07-25 22:00:00 | ES | Futures | 5728.02 | 5730.64 | 5725.66 | 5726.18 | 4989.0 |
| 2024-07-25 23:00:00 | ES | Futures | 5726.18 | 5729.59 | 5724.09 | 5727.5 | 4418.0 |
| 2024-07-25 00:00:00 | NQ | Futures | 20345.4 | 20352.52 | 20323.48 | 20331.14 | 3654.0 |
| 2024-07-25 01:00:00 | NQ | Futures | 20331.14 | 20346.72 | 20308.17 | 20311.08 | 3479.0 |
| 2024-07-25 02:00:00 | NQ | Futures | 20311.08 | 20354.11 | 20225.28 | 20320.58 | 17845.0 |
| 2024-07-25 03:00:00 | NQ | Futures | 20320.32 | 20339.06 | 20234.79 | 20260.13 | 19217.0 |
| 2024-07-25 04:00:00 | NQ | Futures | 20258.55 | 20278.61 | 20128.14 | 20271.74 | 26841.0 |
| 2024-07-25 05:00:00 | NQ | Futures | 20272.01 | 20310.81 | 20204.96 | 20214.46 | 15081.0 |
| 2024-07-25 06:00:00 | NQ | Futures | 20213.67 | 20241.12 | 20164.57 | 20230.3 | 16323.0 |
| 2024-07-25 07:00:00 | NQ | Futures | 20231.09 | 20282.3 | 20196.51 | 20201.0 | 14374.0 |
| 2024-07-25 08:00:00 | NQ | Futures | 20200.73 | 20310.55 | 20147.14 | 20309.49 | 32917.0 |
| 2024-07-25 09:00:00 | NQ | Futures | 20308.97 | 20320.85 | 20080.09 | 20095.67 | 129098.0 |
| 2024-07-25 10:00:00 | NQ | Futures | 20096.46 | 20291.81 | 19939.39 | 20289.43 | 183530.0 |
| 2024-07-25 11:00:00 | NQ | Futures | 20288.9 | 20358.33 | 20213.14 | 20310.81 | 105902.0 |
| 2024-07-25 12:00:00 | NQ | Futures | 20310.55 | 20444.12 | 20264.09 | 20415.35 | 91812.0 |
| 2024-07-25 13:00:00 | NQ | Futures | 20415.88 | 20475.01 | 20321.37 | 20368.36 | 66999.0 |
| 2024-07-25 14:00:00 | NQ | Futures | 20368.1 | 20373.38 | 20178.82 | 20198.09 | 69159.0 |
| 2024-07-25 15:00:00 | NQ | Futures | 20197.3 | 20320.85 | 20043.66 | 20053.17 | 104832.0 |
| 2024-07-25 16:00:00 | NQ | Futures | 20053.43 | 20069.8 | 20000.37 | 20057.13 | 33223.0 |
| 2024-07-25 18:00:00 | NQ | Futures | 20065.84 | 20099.63 | 20061.35 | 20068.48 | 6551.0 |
| 2024-07-25 19:00:00 | NQ | Futures | 20068.48 | 20089.33 | 20057.39 | 20087.48 | 3472.0 |
| 2024-07-25 20:00:00 | NQ | Futures | 20086.16 | 20129.99 | 20082.47 | 20113.09 | 5009.0 |
| 2024-07-25 21:00:00 | NQ | Futures | 20112.83 | 20151.9 | 20110.98 | 20148.73 | 4155.0 |
| 2024-07-25 22:00:00 | NQ | Futures | 20147.94 | 20159.55 | 20131.83 | 20134.47 | 3313.0 |
| 2024-07-25 23:00:00 | NQ | Futures | 20134.21 | 20156.91 | 20123.12 | 20140.02 | 3659.0 |
| 2024-07-25 00:00:00 | YM | Futures | 42233.0 | 42237.2 | 42216.1 | 42228.8 | 662.0 |
| 2024-07-25 01:00:00 | YM | Futures | 42229.8 | 42240.3 | 42207.7 | 42207.7 | 796.0 |
| 2024-07-25 02:00:00 | YM | Futures | 42210.9 | 42235.1 | 42115.3 | 42215.1 | 3426.0 |
| 2024-07-25 03:00:00 | YM | Futures | 42215.1 | 42223.5 | 42105.8 | 42158.4 | 4740.0 |
> showing 50 of 2,135 rows — these rows as CSV