PREVIEW / futures_1hour / 2024-06-24
file: by_date/futures_1hour/2024/2024-06-24.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-06-24 00:00:00 | ES | Futures | 5795.92 | 5798.54 | 5794.35 | 5798.02 | 2765.0 |
| 2024-06-24 01:00:00 | ES | Futures | 5798.02 | 5803.79 | 5798.02 | 5803.0 | 6116.0 |
| 2024-06-24 02:00:00 | ES | Futures | 5802.74 | 5806.41 | 5802.47 | 5804.57 | 8811.0 |
| 2024-06-24 03:00:00 | ES | Futures | 5804.31 | 5813.49 | 5803.0 | 5812.44 | 15297.0 |
| 2024-06-24 04:00:00 | ES | Futures | 5812.17 | 5815.85 | 5810.34 | 5812.17 | 14096.0 |
| 2024-06-24 05:00:00 | ES | Futures | 5812.17 | 5813.75 | 5803.26 | 5806.41 | 11897.0 |
| 2024-06-24 06:00:00 | ES | Futures | 5806.14 | 5811.13 | 5805.1 | 5810.34 | 10301.0 |
| 2024-06-24 07:00:00 | ES | Futures | 5810.34 | 5812.44 | 5806.14 | 5806.93 | 13526.0 |
| 2024-06-24 08:00:00 | ES | Futures | 5806.93 | 5809.55 | 5800.38 | 5800.9 | 24639.0 |
| 2024-06-24 09:00:00 | ES | Futures | 5801.16 | 5816.89 | 5794.61 | 5815.32 | 143944.0 |
| 2024-06-24 10:00:00 | ES | Futures | 5815.06 | 5828.95 | 5804.83 | 5818.73 | 267532.0 |
| 2024-06-24 11:00:00 | ES | Futures | 5818.47 | 5822.66 | 5814.01 | 5821.09 | 122700.0 |
| 2024-06-24 12:00:00 | ES | Futures | 5820.83 | 5821.61 | 5806.67 | 5809.29 | 88476.0 |
| 2024-06-24 13:00:00 | ES | Futures | 5809.29 | 5811.39 | 5793.04 | 5796.97 | 166123.0 |
| 2024-06-24 14:00:00 | ES | Futures | 5797.23 | 5803.79 | 5791.2 | 5799.85 | 119488.0 |
| 2024-06-24 15:00:00 | ES | Futures | 5799.59 | 5804.31 | 5782.81 | 5783.07 | 214088.0 |
| 2024-06-24 16:00:00 | ES | Futures | 5783.07 | 5785.96 | 5778.36 | 5784.12 | 73173.0 |
| 2024-06-24 18:00:00 | ES | Futures | 5784.39 | 5787.53 | 5783.34 | 5785.43 | 4615.0 |
| 2024-06-24 19:00:00 | ES | Futures | 5785.43 | 5788.06 | 5784.91 | 5787.79 | 2980.0 |
| 2024-06-24 20:00:00 | ES | Futures | 5787.79 | 5788.06 | 5783.6 | 5784.12 | 3799.0 |
| 2024-06-24 21:00:00 | ES | Futures | 5784.39 | 5788.06 | 5781.5 | 5787.27 | 5667.0 |
| 2024-06-24 22:00:00 | ES | Futures | 5787.27 | 5788.58 | 5786.74 | 5787.79 | 3610.0 |
| 2024-06-24 23:00:00 | ES | Futures | 5787.79 | 5792.51 | 5787.79 | 5792.25 | 4910.0 |
| 2024-06-24 00:00:00 | NQ | Futures | 21079.79 | 21090.09 | 21068.97 | 21087.45 | 2204.0 |
| 2024-06-24 01:00:00 | NQ | Futures | 21087.19 | 21115.43 | 21086.66 | 21110.68 | 4016.0 |
| 2024-06-24 02:00:00 | NQ | Futures | 21110.15 | 21132.86 | 21104.61 | 21114.38 | 4655.0 |
| 2024-06-24 03:00:00 | NQ | Futures | 21113.58 | 21149.22 | 21099.59 | 21137.87 | 6804.0 |
| 2024-06-24 04:00:00 | NQ | Futures | 21137.87 | 21150.28 | 21115.96 | 21125.46 | 7304.0 |
| 2024-06-24 05:00:00 | NQ | Futures | 21124.67 | 21129.69 | 21054.72 | 21071.35 | 8251.0 |
| 2024-06-24 06:00:00 | NQ | Futures | 21071.35 | 21094.84 | 21065.54 | 21085.07 | 6575.0 |
| 2024-06-24 07:00:00 | NQ | Futures | 21084.28 | 21101.44 | 21066.33 | 21070.56 | 7792.0 |
| 2024-06-24 08:00:00 | NQ | Futures | 21070.03 | 21087.71 | 21037.29 | 21048.91 | 16382.0 |
| 2024-06-24 09:00:00 | NQ | Futures | 21048.38 | 21081.91 | 20977.9 | 21062.37 | 98083.0 |
| 2024-06-24 10:00:00 | NQ | Futures | 21062.64 | 21113.85 | 20929.85 | 21020.4 | 135088.0 |
| 2024-06-24 11:00:00 | NQ | Futures | 21020.66 | 21046.53 | 20983.71 | 21032.01 | 72705.0 |
| 2024-06-24 12:00:00 | NQ | Futures | 21032.01 | 21035.97 | 20950.97 | 20961.27 | 51366.0 |
| 2024-06-24 13:00:00 | NQ | Futures | 20961.79 | 20977.37 | 20894.48 | 20918.24 | 65217.0 |
| 2024-06-24 14:00:00 | NQ | Futures | 20918.24 | 20943.58 | 20872.83 | 20929.06 | 61968.0 |
| 2024-06-24 15:00:00 | NQ | Futures | 20929.06 | 20965.49 | 20844.59 | 20849.6 | 81137.0 |
| 2024-06-24 16:00:00 | NQ | Futures | 20849.07 | 20870.98 | 20831.39 | 20857.26 | 20776.0 |
| 2024-06-24 18:00:00 | NQ | Futures | 20860.95 | 20874.42 | 20854.88 | 20864.38 | 2820.0 |
| 2024-06-24 19:00:00 | NQ | Futures | 20864.38 | 20879.43 | 20860.95 | 20877.58 | 2355.0 |
| 2024-06-24 20:00:00 | NQ | Futures | 20877.58 | 20881.54 | 20854.88 | 20857.52 | 2472.0 |
| 2024-06-24 21:00:00 | NQ | Futures | 20858.05 | 20886.03 | 20846.96 | 20882.07 | 4436.0 |
| 2024-06-24 22:00:00 | NQ | Futures | 20882.6 | 20893.42 | 20878.9 | 20886.82 | 2981.0 |
| 2024-06-24 23:00:00 | NQ | Futures | 20887.09 | 20903.19 | 20886.56 | 20901.34 | 2905.0 |
| 2024-06-24 00:00:00 | YM | Futures | 41501.6 | 41515.3 | 41493.2 | 41510.1 | 509.0 |
| 2024-06-24 01:00:00 | YM | Futures | 41510.1 | 41543.7 | 41509.0 | 41539.5 | 937.0 |
| 2024-06-24 02:00:00 | YM | Futures | 41540.5 | 41574.1 | 41537.4 | 41560.5 | 1317.0 |
| 2024-06-24 03:00:00 | YM | Futures | 41559.4 | 41624.6 | 41554.2 | 41623.5 | 2129.0 |
> showing 50 of 2,051 rows — these rows as CSV