PREVIEW / futures_1hour / 2024-08-20
file: by_date/futures_1hour/2024/2024-08-20.parquet size: 67 KB rows: 2,045
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-20 00:00:00 | ES | Futures | 5903.15 | 5907.34 | 5902.88 | 5905.51 | 2599.0 |
| 2024-08-20 01:00:00 | ES | Futures | 5905.24 | 5907.34 | 5904.19 | 5906.82 | 2536.0 |
| 2024-08-20 02:00:00 | ES | Futures | 5906.82 | 5910.75 | 5904.19 | 5909.44 | 5206.0 |
| 2024-08-20 03:00:00 | ES | Futures | 5909.7 | 5915.73 | 5907.6 | 5913.11 | 10995.0 |
| 2024-08-20 04:00:00 | ES | Futures | 5913.11 | 5913.37 | 5900.79 | 5907.34 | 11836.0 |
| 2024-08-20 05:00:00 | ES | Futures | 5907.08 | 5911.01 | 5906.03 | 5906.82 | 6309.0 |
| 2024-08-20 06:00:00 | ES | Futures | 5906.55 | 5911.01 | 5904.19 | 5908.91 | 6760.0 |
| 2024-08-20 07:00:00 | ES | Futures | 5908.65 | 5911.53 | 5906.03 | 5908.39 | 7817.0 |
| 2024-08-20 08:00:00 | ES | Futures | 5908.39 | 5910.22 | 5902.88 | 5904.46 | 17552.0 |
| 2024-08-20 09:00:00 | ES | Futures | 5904.19 | 5918.35 | 5899.21 | 5917.04 | 114152.0 |
| 2024-08-20 10:00:00 | ES | Futures | 5917.04 | 5917.83 | 5887.42 | 5891.87 | 217030.0 |
| 2024-08-20 11:00:00 | ES | Futures | 5892.13 | 5901.83 | 5886.1 | 5901.31 | 113895.0 |
| 2024-08-20 12:00:00 | ES | Futures | 5901.31 | 5902.88 | 5887.94 | 5888.2 | 101108.0 |
| 2024-08-20 13:00:00 | ES | Futures | 5888.46 | 5892.92 | 5880.6 | 5891.09 | 80980.0 |
| 2024-08-20 14:00:00 | ES | Futures | 5891.09 | 5906.29 | 5889.78 | 5898.95 | 77837.0 |
| 2024-08-20 15:00:00 | ES | Futures | 5899.21 | 5900.79 | 5891.87 | 5894.49 | 133256.0 |
| 2024-08-20 16:00:00 | ES | Futures | 5894.49 | 5899.48 | 5893.45 | 5893.45 | 37599.0 |
| 2024-08-20 18:00:00 | ES | Futures | 5892.92 | 5895.54 | 5891.09 | 5893.45 | 4147.0 |
| 2024-08-20 19:00:00 | ES | Futures | 5893.71 | 5895.54 | 5891.87 | 5893.18 | 2679.0 |
| 2024-08-20 20:00:00 | ES | Futures | 5893.18 | 5900.79 | 5893.18 | 5899.74 | 4644.0 |
| 2024-08-20 21:00:00 | ES | Futures | 5899.74 | 5900.26 | 5896.07 | 5896.85 | 4175.0 |
| 2024-08-20 22:00:00 | ES | Futures | 5896.85 | 5899.48 | 5895.02 | 5898.43 | 2769.0 |
| 2024-08-20 23:00:00 | ES | Futures | 5898.43 | 5902.62 | 5898.16 | 5900.26 | 3305.0 |
| 2024-08-20 00:00:00 | NQ | Futures | 20987.4 | 21006.94 | 20984.23 | 20994.53 | 3021.0 |
| 2024-08-20 01:00:00 | NQ | Futures | 20995.06 | 21010.37 | 20988.46 | 21001.66 | 3078.0 |
| 2024-08-20 02:00:00 | NQ | Futures | 21000.34 | 21017.76 | 20984.5 | 21004.56 | 3398.0 |
| 2024-08-20 03:00:00 | NQ | Futures | 21005.09 | 21045.74 | 20994.53 | 21024.36 | 6389.0 |
| 2024-08-20 04:00:00 | NQ | Futures | 21024.89 | 21026.73 | 20959.95 | 20986.61 | 7767.0 |
| 2024-08-20 05:00:00 | NQ | Futures | 20986.87 | 21015.12 | 20985.29 | 20993.74 | 4005.0 |
| 2024-08-20 06:00:00 | NQ | Futures | 20993.74 | 21004.56 | 20980.27 | 20990.3 | 4237.0 |
| 2024-08-20 07:00:00 | NQ | Futures | 20989.78 | 21002.45 | 20972.09 | 20985.55 | 5069.0 |
| 2024-08-20 08:00:00 | NQ | Futures | 20985.55 | 20991.1 | 20951.24 | 20958.36 | 10569.0 |
| 2024-08-20 09:00:00 | NQ | Futures | 20958.63 | 21039.41 | 20920.35 | 21032.54 | 71598.0 |
| 2024-08-20 10:00:00 | NQ | Futures | 21032.54 | 21037.82 | 20847.23 | 20892.1 | 105849.0 |
| 2024-08-20 11:00:00 | NQ | Futures | 20892.37 | 20963.64 | 20878.64 | 20963.11 | 59761.0 |
| 2024-08-20 12:00:00 | NQ | Futures | 20963.11 | 20969.19 | 20882.07 | 20883.66 | 42346.0 |
| 2024-08-20 13:00:00 | NQ | Futures | 20884.45 | 20920.88 | 20852.77 | 20917.71 | 35809.0 |
| 2024-08-20 14:00:00 | NQ | Futures | 20917.97 | 20978.95 | 20909.79 | 20961.79 | 36821.0 |
| 2024-08-20 15:00:00 | NQ | Futures | 20962.06 | 20970.51 | 20911.11 | 20919.82 | 48841.0 |
| 2024-08-20 16:00:00 | NQ | Futures | 20920.09 | 20942.0 | 20910.58 | 20912.43 | 12153.0 |
| 2024-08-20 18:00:00 | NQ | Futures | 20910.58 | 20927.48 | 20894.22 | 20904.51 | 3287.0 |
| 2024-08-20 19:00:00 | NQ | Futures | 20904.77 | 20913.75 | 20892.1 | 20896.85 | 2083.0 |
| 2024-08-20 20:00:00 | NQ | Futures | 20896.59 | 20937.77 | 20896.33 | 20934.34 | 3386.0 |
| 2024-08-20 21:00:00 | NQ | Futures | 20933.55 | 20943.32 | 20923.25 | 20925.89 | 3095.0 |
| 2024-08-20 22:00:00 | NQ | Futures | 20926.68 | 20936.19 | 20915.33 | 20929.59 | 2400.0 |
| 2024-08-20 23:00:00 | NQ | Futures | 20929.85 | 20951.76 | 20929.32 | 20941.73 | 1874.0 |
| 2024-08-20 00:00:00 | YM | Futures | 43085.1 | 43103.0 | 43084.0 | 43100.9 | 487.0 |
| 2024-08-20 01:00:00 | YM | Futures | 43099.8 | 43108.2 | 43096.7 | 43103.0 | 461.0 |
| 2024-08-20 02:00:00 | YM | Futures | 43103.0 | 43146.0 | 43087.2 | 43145.0 | 1190.0 |
| 2024-08-20 03:00:00 | YM | Futures | 43146.0 | 43169.2 | 43132.4 | 43157.6 | 1808.0 |
> showing 50 of 2,045 rows — these rows as CSV