PREVIEW / futures_1hour / 2024-08-21
file: by_date/futures_1hour/2024/2024-08-21.parquet size: 66 KB rows: 2,063
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-21 00:00:00 | ES | Futures | 5900.26 | 5903.67 | 5899.74 | 5903.41 | 1641.0 |
| 2024-08-21 01:00:00 | ES | Futures | 5903.41 | 5904.72 | 5898.69 | 5900.0 | 3729.0 |
| 2024-08-21 02:00:00 | ES | Futures | 5900.0 | 5900.79 | 5896.07 | 5897.64 | 4238.0 |
| 2024-08-21 03:00:00 | ES | Futures | 5897.38 | 5900.26 | 5895.28 | 5896.85 | 6081.0 |
| 2024-08-21 04:00:00 | ES | Futures | 5897.12 | 5900.0 | 5893.18 | 5893.45 | 7395.0 |
| 2024-08-21 05:00:00 | ES | Futures | 5893.45 | 5897.12 | 5892.66 | 5894.23 | 6008.0 |
| 2024-08-21 06:00:00 | ES | Futures | 5894.49 | 5903.93 | 5893.97 | 5903.41 | 7610.0 |
| 2024-08-21 07:00:00 | ES | Futures | 5903.15 | 5905.77 | 5900.79 | 5902.62 | 10390.0 |
| 2024-08-21 08:00:00 | ES | Futures | 5902.88 | 5907.86 | 5900.79 | 5903.15 | 13890.0 |
| 2024-08-21 09:00:00 | ES | Futures | 5903.41 | 5912.58 | 5901.31 | 5911.53 | 105392.0 |
| 2024-08-21 10:00:00 | ES | Futures | 5911.53 | 5930.41 | 5892.92 | 5900.0 | 242577.0 |
| 2024-08-21 11:00:00 | ES | Futures | 5899.74 | 5911.53 | 5892.66 | 5896.33 | 121219.0 |
| 2024-08-21 12:00:00 | ES | Futures | 5896.07 | 5911.27 | 5886.63 | 5909.18 | 91821.0 |
| 2024-08-21 13:00:00 | ES | Futures | 5909.44 | 5913.89 | 5906.55 | 5911.8 | 52481.0 |
| 2024-08-21 14:00:00 | ES | Futures | 5912.06 | 5925.95 | 5909.44 | 5915.99 | 118113.0 |
| 2024-08-21 15:00:00 | ES | Futures | 5915.73 | 5918.61 | 5899.74 | 5914.68 | 158955.0 |
| 2024-08-21 16:00:00 | ES | Futures | 5914.42 | 5919.14 | 5909.7 | 5915.99 | 38807.0 |
| 2024-08-21 18:00:00 | ES | Futures | 5916.52 | 5920.97 | 5914.68 | 5918.88 | 3753.0 |
| 2024-08-21 19:00:00 | ES | Futures | 5918.88 | 5920.19 | 5916.78 | 5919.92 | 2164.0 |
| 2024-08-21 20:00:00 | ES | Futures | 5919.66 | 5922.02 | 5918.61 | 5919.14 | 3030.0 |
| 2024-08-21 21:00:00 | ES | Futures | 5919.14 | 5919.66 | 5916.52 | 5918.61 | 2387.0 |
| 2024-08-21 22:00:00 | ES | Futures | 5918.61 | 5918.61 | 5908.39 | 5909.18 | 5200.0 |
| 2024-08-21 23:00:00 | ES | Futures | 5909.44 | 5909.7 | 5905.51 | 5907.6 | 3872.0 |
| 2024-08-21 00:00:00 | NQ | Futures | 20941.73 | 20958.89 | 20939.09 | 20958.89 | 1277.0 |
| 2024-08-21 01:00:00 | NQ | Futures | 20958.63 | 20966.02 | 20936.72 | 20941.2 | 3081.0 |
| 2024-08-21 02:00:00 | NQ | Futures | 20940.94 | 20944.11 | 20915.86 | 20921.67 | 3238.0 |
| 2024-08-21 03:00:00 | NQ | Futures | 20921.93 | 20943.32 | 20906.36 | 20924.31 | 4234.0 |
| 2024-08-21 04:00:00 | NQ | Futures | 20924.31 | 20940.15 | 20901.61 | 20909.53 | 6206.0 |
| 2024-08-21 05:00:00 | NQ | Futures | 20909.53 | 20921.14 | 20897.38 | 20901.87 | 4308.0 |
| 2024-08-21 06:00:00 | NQ | Futures | 20902.93 | 20954.4 | 20902.13 | 20951.24 | 4222.0 |
| 2024-08-21 07:00:00 | NQ | Futures | 20950.44 | 20972.62 | 20933.02 | 20940.94 | 6814.0 |
| 2024-08-21 08:00:00 | NQ | Futures | 20942.26 | 20974.73 | 20931.7 | 20948.86 | 8265.0 |
| 2024-08-21 09:00:00 | NQ | Futures | 20949.12 | 20996.38 | 20921.14 | 20990.57 | 56095.0 |
| 2024-08-21 10:00:00 | NQ | Futures | 20991.36 | 21099.33 | 20911.64 | 20943.05 | 114776.0 |
| 2024-08-21 11:00:00 | NQ | Futures | 20943.58 | 21007.2 | 20910.05 | 20932.76 | 57662.0 |
| 2024-08-21 12:00:00 | NQ | Futures | 20933.55 | 20991.36 | 20877.32 | 20981.86 | 40018.0 |
| 2024-08-21 13:00:00 | NQ | Futures | 20982.39 | 21014.06 | 20964.96 | 21005.88 | 25618.0 |
| 2024-08-21 14:00:00 | NQ | Futures | 21007.46 | 21069.24 | 20990.04 | 21018.29 | 50596.0 |
| 2024-08-21 15:00:00 | NQ | Futures | 21017.49 | 21036.77 | 20942.0 | 21019.08 | 57120.0 |
| 2024-08-21 16:00:00 | NQ | Futures | 21019.34 | 21039.93 | 20993.47 | 21031.75 | 13587.0 |
| 2024-08-21 18:00:00 | NQ | Futures | 21035.45 | 21059.47 | 21025.94 | 21051.02 | 2366.0 |
| 2024-08-21 19:00:00 | NQ | Futures | 21050.23 | 21054.98 | 21038.61 | 21051.28 | 1678.0 |
| 2024-08-21 20:00:00 | NQ | Futures | 21051.02 | 21059.73 | 21042.84 | 21044.69 | 2431.0 |
| 2024-08-21 21:00:00 | NQ | Futures | 21043.89 | 21049.7 | 21032.54 | 21041.25 | 1737.0 |
| 2024-08-21 22:00:00 | NQ | Futures | 21040.73 | 21041.25 | 20990.04 | 20996.64 | 3664.0 |
| 2024-08-21 23:00:00 | NQ | Futures | 20998.22 | 21001.39 | 20977.11 | 20994.53 | 3051.0 |
| 2024-08-21 00:00:00 | YM | Futures | 43085.1 | 43097.7 | 43081.9 | 43096.7 | 308.0 |
| 2024-08-21 01:00:00 | YM | Futures | 43096.7 | 43103.0 | 43078.8 | 43083.0 | 675.0 |
| 2024-08-21 02:00:00 | YM | Futures | 43081.9 | 43100.9 | 43070.4 | 43095.6 | 718.0 |
| 2024-08-21 03:00:00 | YM | Futures | 43095.6 | 43107.2 | 43077.7 | 43086.1 | 874.0 |
> showing 50 of 2,063 rows — these rows as CSV