PREVIEW / futures_1hour / 2024-07-19
file: by_date/futures_1hour/2024/2024-07-19.parquet size: 56 KB rows: 1,647
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-19 00:00:00 | ES | Futures | 5875.88 | 5876.67 | 5874.05 | 5876.4 | 2585.0 |
| 2024-07-19 01:00:00 | ES | Futures | 5876.4 | 5878.5 | 5874.57 | 5878.5 | 2954.0 |
| 2024-07-19 02:00:00 | ES | Futures | 5878.5 | 5880.34 | 5863.56 | 5865.92 | 12260.0 |
| 2024-07-19 03:00:00 | ES | Futures | 5866.18 | 5867.49 | 5839.44 | 5850.45 | 39984.0 |
| 2024-07-19 04:00:00 | ES | Futures | 5850.45 | 5861.72 | 5845.21 | 5856.74 | 25058.0 |
| 2024-07-19 05:00:00 | ES | Futures | 5856.74 | 5862.25 | 5849.14 | 5858.84 | 27988.0 |
| 2024-07-19 06:00:00 | ES | Futures | 5858.84 | 5870.64 | 5858.05 | 5862.25 | 22680.0 |
| 2024-07-19 07:00:00 | ES | Futures | 5862.25 | 5874.05 | 5861.46 | 5871.69 | 18977.0 |
| 2024-07-19 08:00:00 | ES | Futures | 5871.69 | 5876.14 | 5864.87 | 5875.36 | 35925.0 |
| 2024-07-19 09:00:00 | ES | Futures | 5875.36 | 5877.45 | 5853.07 | 5865.39 | 259528.0 |
| 2024-07-19 10:00:00 | ES | Futures | 5865.39 | 5869.06 | 5841.01 | 5846.26 | 282851.0 |
| 2024-07-19 11:00:00 | ES | Futures | 5846.52 | 5855.43 | 5825.55 | 5845.47 | 274268.0 |
| 2024-07-19 12:00:00 | ES | Futures | 5845.21 | 5849.93 | 5822.66 | 5827.12 | 219122.0 |
| 2024-07-19 13:00:00 | ES | Futures | 5827.38 | 5828.43 | 5811.65 | 5827.64 | 200912.0 |
| 2024-07-19 14:00:00 | ES | Futures | 5827.64 | 5831.05 | 5813.22 | 5825.02 | 155449.0 |
| 2024-07-19 15:00:00 | ES | Futures | 5825.02 | 5839.44 | 5815.32 | 5823.97 | 323986.0 |
| 2024-07-19 16:00:00 | ES | Futures | 5824.23 | 5830.79 | 5817.16 | 5822.92 | 79688.0 |
| 2024-07-19 00:00:00 | NQ | Futures | 21072.14 | 21076.36 | 21065.01 | 21073.46 | 1283.0 |
| 2024-07-19 01:00:00 | NQ | Futures | 21073.72 | 21079.79 | 21063.69 | 21079.27 | 1652.0 |
| 2024-07-19 02:00:00 | NQ | Futures | 21079.27 | 21097.22 | 21010.9 | 21020.93 | 7739.0 |
| 2024-07-19 03:00:00 | NQ | Futures | 21021.45 | 21021.72 | 20858.31 | 20903.98 | 24810.0 |
| 2024-07-19 04:00:00 | NQ | Futures | 20903.98 | 20975.26 | 20891.58 | 20949.65 | 15116.0 |
| 2024-07-19 05:00:00 | NQ | Futures | 20950.18 | 20977.11 | 20915.33 | 20961.0 | 13533.0 |
| 2024-07-19 06:00:00 | NQ | Futures | 20959.95 | 21020.93 | 20957.57 | 20980.8 | 12613.0 |
| 2024-07-19 07:00:00 | NQ | Futures | 20980.8 | 21054.45 | 20974.47 | 21037.56 | 15160.0 |
| 2024-07-19 08:00:00 | NQ | Futures | 21037.29 | 21060.0 | 21011.69 | 21054.72 | 13936.0 |
| 2024-07-19 09:00:00 | NQ | Futures | 21053.92 | 21093.79 | 20945.16 | 20996.11 | 101942.0 |
| 2024-07-19 10:00:00 | NQ | Futures | 20995.85 | 21030.96 | 20880.49 | 20935.13 | 117093.0 |
| 2024-07-19 11:00:00 | NQ | Futures | 20935.4 | 20986.87 | 20806.04 | 20925.1 | 103269.0 |
| 2024-07-19 12:00:00 | NQ | Futures | 20926.16 | 20935.13 | 20787.57 | 20832.71 | 78603.0 |
| 2024-07-19 13:00:00 | NQ | Futures | 20832.71 | 20834.82 | 20753.25 | 20824.52 | 68897.0 |
| 2024-07-19 14:00:00 | NQ | Futures | 20823.73 | 20850.39 | 20769.88 | 20823.47 | 54392.0 |
| 2024-07-19 15:00:00 | NQ | Futures | 20824.0 | 20891.05 | 20785.98 | 20814.23 | 89659.0 |
| 2024-07-19 16:00:00 | NQ | Futures | 20814.76 | 20842.21 | 20794.17 | 20803.41 | 17973.0 |
| 2024-07-19 00:00:00 | YM | Futures | 43058.8 | 43058.8 | 43044.1 | 43052.5 | 571.0 |
| 2024-07-19 01:00:00 | YM | Futures | 43053.6 | 43073.5 | 43048.3 | 43072.5 | 489.0 |
| 2024-07-19 02:00:00 | YM | Futures | 43071.4 | 43078.8 | 42970.6 | 42974.8 | 2340.0 |
| 2024-07-19 03:00:00 | YM | Futures | 42975.8 | 42995.8 | 42884.4 | 42939.0 | 5526.0 |
| 2024-07-19 04:00:00 | YM | Futures | 42936.9 | 43001.0 | 42907.5 | 42925.4 | 4337.0 |
| 2024-07-19 05:00:00 | YM | Futures | 42925.4 | 42964.3 | 42888.6 | 42932.7 | 3776.0 |
| 2024-07-19 06:00:00 | YM | Futures | 42930.6 | 42981.1 | 42909.6 | 42942.2 | 4432.0 |
| 2024-07-19 07:00:00 | YM | Futures | 42942.2 | 43002.1 | 42930.6 | 42975.8 | 4670.0 |
| 2024-07-19 08:00:00 | YM | Futures | 42975.8 | 42985.3 | 42902.3 | 42963.2 | 3358.0 |
| 2024-07-19 09:00:00 | YM | Futures | 42964.3 | 42968.5 | 42710.0 | 42845.5 | 38023.0 |
| 2024-07-19 10:00:00 | YM | Futures | 42842.4 | 42865.5 | 42668.0 | 42700.5 | 26671.0 |
| 2024-07-19 11:00:00 | YM | Futures | 42701.6 | 42744.7 | 42533.5 | 42671.1 | 21715.0 |
| 2024-07-19 12:00:00 | YM | Futures | 42671.1 | 42749.9 | 42577.6 | 42582.8 | 16743.0 |
| 2024-07-19 13:00:00 | YM | Futures | 42583.9 | 42623.8 | 42518.8 | 42622.8 | 13579.0 |
| 2024-07-19 14:00:00 | YM | Futures | 42621.7 | 42651.1 | 42552.4 | 42616.5 | 10614.0 |
| 2024-07-19 15:00:00 | YM | Futures | 42617.5 | 42717.3 | 42553.4 | 42622.8 | 18905.0 |
> showing 50 of 1,647 rows — these rows as CSV