PREVIEW / futures_1hour / 2024-10-04
file: by_date/futures_1hour/2024/2024-10-04.parquet size: 58 KB rows: 1,690
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-10-04 00:00:00 | ES | Futures | 5971.89 | 5976.82 | 5968.26 | 5970.34 | 4832.0 |
| 2024-10-04 01:00:00 | ES | Futures | 5970.6 | 5974.49 | 5969.82 | 5971.11 | 4941.0 |
| 2024-10-04 02:00:00 | ES | Futures | 5971.37 | 5972.67 | 5965.66 | 5965.66 | 4952.0 |
| 2024-10-04 03:00:00 | ES | Futures | 5965.92 | 5977.86 | 5962.29 | 5975.79 | 13631.0 |
| 2024-10-04 04:00:00 | ES | Futures | 5975.79 | 5977.6 | 5969.04 | 5969.3 | 8562.0 |
| 2024-10-04 05:00:00 | ES | Futures | 5969.56 | 5977.86 | 5968.52 | 5976.82 | 6655.0 |
| 2024-10-04 06:00:00 | ES | Futures | 5977.08 | 5985.39 | 5976.82 | 5979.94 | 11478.0 |
| 2024-10-04 07:00:00 | ES | Futures | 5980.2 | 5987.72 | 5978.64 | 5984.61 | 15676.0 |
| 2024-10-04 08:00:00 | ES | Futures | 5984.61 | 6021.46 | 5981.5 | 6020.42 | 102112.0 |
| 2024-10-04 09:00:00 | ES | Futures | 6020.42 | 6024.32 | 5988.5 | 5991.36 | 202411.0 |
| 2024-10-04 10:00:00 | ES | Futures | 5991.36 | 6002.0 | 5968.52 | 5989.54 | 276064.0 |
| 2024-10-04 11:00:00 | ES | Futures | 5989.28 | 5997.07 | 5971.11 | 5993.95 | 177522.0 |
| 2024-10-04 12:00:00 | ES | Futures | 5994.21 | 6005.63 | 5983.31 | 6000.7 | 111271.0 |
| 2024-10-04 13:00:00 | ES | Futures | 6000.96 | 6006.67 | 5985.39 | 5992.14 | 91565.0 |
| 2024-10-04 14:00:00 | ES | Futures | 5992.4 | 6006.41 | 5986.69 | 6005.63 | 82907.0 |
| 2024-10-04 15:00:00 | ES | Futures | 6005.63 | 6025.87 | 6002.0 | 6020.68 | 165685.0 |
| 2024-10-04 16:00:00 | ES | Futures | 6020.68 | 6021.98 | 6015.23 | 6016.27 | 59030.0 |
| 2024-10-04 00:00:00 | NQ | Futures | 20885.77 | 20909.51 | 20865.42 | 20877.42 | 3401.0 |
| 2024-10-04 01:00:00 | NQ | Futures | 20878.2 | 20904.3 | 20873.77 | 20888.9 | 3282.0 |
| 2024-10-04 02:00:00 | NQ | Futures | 20889.68 | 20893.08 | 20863.07 | 20865.94 | 2893.0 |
| 2024-10-04 03:00:00 | NQ | Futures | 20866.46 | 20914.21 | 20843.5 | 20907.43 | 6325.0 |
| 2024-10-04 04:00:00 | NQ | Futures | 20906.9 | 20917.34 | 20872.2 | 20875.59 | 5248.0 |
| 2024-10-04 05:00:00 | NQ | Futures | 20876.64 | 20915.51 | 20867.77 | 20912.12 | 3804.0 |
| 2024-10-04 06:00:00 | NQ | Futures | 20912.38 | 20953.87 | 20911.34 | 20926.21 | 6673.0 |
| 2024-10-04 07:00:00 | NQ | Futures | 20926.47 | 20962.22 | 20918.12 | 20938.47 | 6354.0 |
| 2024-10-04 08:00:00 | NQ | Futures | 20939.26 | 21129.72 | 20926.73 | 21128.68 | 40455.0 |
| 2024-10-04 09:00:00 | NQ | Futures | 21129.2 | 21148.25 | 20948.91 | 20963.26 | 90298.0 |
| 2024-10-04 10:00:00 | NQ | Futures | 20963.26 | 21007.88 | 20886.81 | 21005.27 | 103650.0 |
| 2024-10-04 11:00:00 | NQ | Futures | 21004.49 | 21040.49 | 20908.73 | 21020.66 | 72392.0 |
| 2024-10-04 12:00:00 | NQ | Futures | 21020.66 | 21063.19 | 20958.04 | 21033.71 | 49754.0 |
| 2024-10-04 13:00:00 | NQ | Futures | 21033.71 | 21051.45 | 20960.39 | 20993.53 | 39214.0 |
| 2024-10-04 14:00:00 | NQ | Futures | 20993.79 | 21051.97 | 20970.57 | 21050.67 | 33512.0 |
| 2024-10-04 15:00:00 | NQ | Futures | 21050.67 | 21129.2 | 21034.49 | 21110.15 | 50689.0 |
| 2024-10-04 16:00:00 | NQ | Futures | 21109.89 | 21116.42 | 21078.85 | 21084.06 | 11803.0 |
| 2024-10-04 00:00:00 | YM | Futures | 44036.3 | 44058.2 | 44018.6 | 44025.9 | 397.0 |
| 2024-10-04 01:00:00 | YM | Futures | 44026.9 | 44044.6 | 44021.7 | 44028.0 | 478.0 |
| 2024-10-04 02:00:00 | YM | Futures | 44029.0 | 44036.3 | 43986.4 | 43990.5 | 685.0 |
| 2024-10-04 03:00:00 | YM | Futures | 43990.5 | 44066.5 | 43973.9 | 44060.2 | 1387.0 |
| 2024-10-04 04:00:00 | YM | Futures | 44061.3 | 44062.3 | 43990.5 | 43997.8 | 1376.0 |
| 2024-10-04 05:00:00 | YM | Futures | 43996.8 | 44034.2 | 43990.5 | 44026.9 | 724.0 |
| 2024-10-04 06:00:00 | YM | Futures | 44026.9 | 44091.5 | 44024.9 | 44058.2 | 1464.0 |
| 2024-10-04 07:00:00 | YM | Futures | 44059.2 | 44123.7 | 44058.2 | 44118.5 | 1640.0 |
| 2024-10-04 08:00:00 | YM | Futures | 44120.6 | 44323.6 | 44095.6 | 44307.9 | 9506.0 |
| 2024-10-04 09:00:00 | YM | Futures | 44309.0 | 44379.8 | 44192.4 | 44218.4 | 23657.0 |
| 2024-10-04 10:00:00 | YM | Futures | 44217.4 | 44300.7 | 43989.5 | 44112.3 | 24295.0 |
| 2024-10-04 11:00:00 | YM | Futures | 44112.3 | 44179.9 | 43993.6 | 44177.9 | 11286.0 |
| 2024-10-04 12:00:00 | YM | Futures | 44179.9 | 44273.6 | 44120.6 | 44233.0 | 7457.0 |
| 2024-10-04 13:00:00 | YM | Futures | 44232.0 | 44288.2 | 44135.2 | 44177.9 | 5729.0 |
| 2024-10-04 14:00:00 | YM | Futures | 44176.8 | 44291.3 | 44133.1 | 44284.0 | 5501.0 |
| 2024-10-04 15:00:00 | YM | Futures | 44281.9 | 44405.8 | 44257.0 | 44381.8 | 12115.0 |
> showing 50 of 1,690 rows — these rows as CSV