PREVIEW / futures_1hour / 2024-10-07
file: by_date/futures_1hour/2024/2024-10-07.parquet size: 69 KB rows: 2,112
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-07 00:00:00 | ES | Futures | 6016.79 | 6019.9 | 6015.49 | 6016.53 | 4203.0 |
| 2024-10-07 01:00:00 | ES | Futures | 6016.79 | 6017.31 | 6010.82 | 6011.86 | 5796.0 |
| 2024-10-07 02:00:00 | ES | Futures | 6011.6 | 6015.23 | 6007.19 | 6014.71 | 9206.0 |
| 2024-10-07 03:00:00 | ES | Futures | 6014.97 | 6014.97 | 5996.03 | 5997.85 | 26870.0 |
| 2024-10-07 04:00:00 | ES | Futures | 5997.85 | 6004.85 | 5993.17 | 5993.69 | 14892.0 |
| 2024-10-07 05:00:00 | ES | Futures | 5993.69 | 5993.69 | 5982.27 | 5989.8 | 19472.0 |
| 2024-10-07 06:00:00 | ES | Futures | 5989.8 | 5993.69 | 5986.17 | 5993.43 | 11345.0 |
| 2024-10-07 07:00:00 | ES | Futures | 5993.17 | 5996.29 | 5988.5 | 5995.25 | 14374.0 |
| 2024-10-07 08:00:00 | ES | Futures | 5995.25 | 6001.22 | 5993.69 | 5998.36 | 23454.0 |
| 2024-10-07 09:00:00 | ES | Futures | 5998.36 | 6005.89 | 5993.95 | 5996.29 | 132924.0 |
| 2024-10-07 10:00:00 | ES | Futures | 5996.03 | 6009.26 | 5995.51 | 6002.26 | 139507.0 |
| 2024-10-07 11:00:00 | ES | Futures | 6002.26 | 6007.19 | 5994.99 | 6000.44 | 95015.0 |
| 2024-10-07 12:00:00 | ES | Futures | 6000.44 | 6000.96 | 5989.54 | 5994.99 | 86179.0 |
| 2024-10-07 13:00:00 | ES | Futures | 5995.25 | 5998.88 | 5986.43 | 5992.91 | 68485.0 |
| 2024-10-07 14:00:00 | ES | Futures | 5992.91 | 5993.17 | 5952.69 | 5955.02 | 184596.0 |
| 2024-10-07 15:00:00 | ES | Futures | 5955.02 | 5975.01 | 5953.47 | 5965.92 | 205324.0 |
| 2024-10-07 16:00:00 | ES | Futures | 5965.92 | 5972.67 | 5965.4 | 5969.04 | 47332.0 |
| 2024-10-07 18:00:00 | ES | Futures | 5971.63 | 5973.19 | 5943.35 | 5959.18 | 23726.0 |
| 2024-10-07 19:00:00 | ES | Futures | 5959.18 | 5968.78 | 5957.36 | 5963.07 | 9846.0 |
| 2024-10-07 20:00:00 | ES | Futures | 5963.33 | 5973.71 | 5963.33 | 5970.34 | 7703.0 |
| 2024-10-07 21:00:00 | ES | Futures | 5970.34 | 5971.37 | 5958.92 | 5964.37 | 12929.0 |
| 2024-10-07 22:00:00 | ES | Futures | 5964.11 | 5968.26 | 5958.4 | 5965.92 | 11302.0 |
| 2024-10-07 23:00:00 | ES | Futures | 5965.92 | 5968.0 | 5959.18 | 5962.55 | 6361.0 |
| 2024-10-07 00:00:00 | NQ | Futures | 21101.54 | 21117.46 | 21092.15 | 21099.46 | 2234.0 |
| 2024-10-07 01:00:00 | NQ | Futures | 21099.46 | 21102.59 | 21064.23 | 21071.02 | 3256.0 |
| 2024-10-07 02:00:00 | NQ | Futures | 21071.8 | 21096.07 | 21049.36 | 21092.15 | 4907.0 |
| 2024-10-07 03:00:00 | NQ | Futures | 21092.93 | 21095.02 | 21011.27 | 21025.36 | 12075.0 |
| 2024-10-07 04:00:00 | NQ | Futures | 21024.05 | 21045.19 | 20989.87 | 20990.66 | 7569.0 |
| 2024-10-07 05:00:00 | NQ | Futures | 20991.18 | 20992.74 | 20933.52 | 20972.39 | 11013.0 |
| 2024-10-07 06:00:00 | NQ | Futures | 20972.65 | 20982.57 | 20951.52 | 20977.87 | 5460.0 |
| 2024-10-07 07:00:00 | NQ | Futures | 20978.39 | 20996.14 | 20956.48 | 20988.83 | 6390.0 |
| 2024-10-07 08:00:00 | NQ | Futures | 20988.57 | 21021.97 | 20979.96 | 21003.96 | 9491.0 |
| 2024-10-07 09:00:00 | NQ | Futures | 21004.49 | 21043.88 | 20965.35 | 20987.79 | 59017.0 |
| 2024-10-07 10:00:00 | NQ | Futures | 20988.31 | 21068.41 | 20981.79 | 21045.19 | 60457.0 |
| 2024-10-07 11:00:00 | NQ | Futures | 21045.97 | 21056.67 | 20997.18 | 21029.79 | 36788.0 |
| 2024-10-07 12:00:00 | NQ | Futures | 21030.32 | 21048.32 | 20985.44 | 21015.18 | 32182.0 |
| 2024-10-07 13:00:00 | NQ | Futures | 21015.18 | 21043.36 | 20991.18 | 21028.23 | 24798.0 |
| 2024-10-07 14:00:00 | NQ | Futures | 21027.97 | 21032.4 | 20832.28 | 20840.89 | 65204.0 |
| 2024-10-07 15:00:00 | NQ | Futures | 20841.15 | 20902.47 | 20818.72 | 20872.2 | 64857.0 |
| 2024-10-07 16:00:00 | NQ | Futures | 20872.46 | 20908.47 | 20871.68 | 20890.73 | 10153.0 |
| 2024-10-07 18:00:00 | NQ | Futures | 20899.86 | 20905.34 | 20771.23 | 20833.33 | 9989.0 |
| 2024-10-07 19:00:00 | NQ | Futures | 20834.89 | 20877.68 | 20825.76 | 20855.24 | 5264.0 |
| 2024-10-07 20:00:00 | NQ | Futures | 20856.29 | 20905.08 | 20856.29 | 20889.16 | 4273.0 |
| 2024-10-07 21:00:00 | NQ | Futures | 20889.42 | 20894.38 | 20826.02 | 20853.16 | 6175.0 |
| 2024-10-07 22:00:00 | NQ | Futures | 20851.85 | 20885.51 | 20826.54 | 20872.46 | 5972.0 |
| 2024-10-07 23:00:00 | NQ | Futures | 20871.16 | 20885.51 | 20841.68 | 20857.07 | 3212.0 |
| 2024-10-07 00:00:00 | YM | Futures | 44369.4 | 44385.0 | 44364.1 | 44369.4 | 255.0 |
| 2024-10-07 01:00:00 | YM | Futures | 44369.4 | 44372.5 | 44335.0 | 44340.2 | 445.0 |
| 2024-10-07 02:00:00 | YM | Futures | 44340.2 | 44354.8 | 44311.1 | 44342.3 | 1128.0 |
| 2024-10-07 03:00:00 | YM | Futures | 44341.3 | 44341.3 | 44211.2 | 44232.0 | 3237.0 |
> showing 50 of 2,112 rows — these rows as CSV