PREVIEW / futures_1hour / 2024-10-08
file: by_date/futures_1hour/2024/2024-10-08.parquet size: 68 KB rows: 2,094
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-08 00:00:00 | ES | Futures | 5962.55 | 5967.48 | 5962.03 | 5965.92 | 2598.0 |
| 2024-10-08 01:00:00 | ES | Futures | 5965.92 | 5967.74 | 5958.92 | 5962.29 | 7349.0 |
| 2024-10-08 02:00:00 | ES | Futures | 5962.29 | 5965.15 | 5957.1 | 5963.85 | 9110.0 |
| 2024-10-08 03:00:00 | ES | Futures | 5964.11 | 5972.67 | 5954.76 | 5967.22 | 22078.0 |
| 2024-10-08 04:00:00 | ES | Futures | 5967.22 | 5973.45 | 5964.37 | 5972.15 | 14530.0 |
| 2024-10-08 05:00:00 | ES | Futures | 5972.15 | 5987.72 | 5972.15 | 5984.35 | 18940.0 |
| 2024-10-08 06:00:00 | ES | Futures | 5984.35 | 5988.76 | 5980.46 | 5988.76 | 14010.0 |
| 2024-10-08 07:00:00 | ES | Futures | 5988.5 | 5990.58 | 5983.57 | 5988.24 | 17292.0 |
| 2024-10-08 08:00:00 | ES | Futures | 5988.5 | 5990.06 | 5983.31 | 5985.65 | 23059.0 |
| 2024-10-08 09:00:00 | ES | Futures | 5985.91 | 5998.36 | 5983.31 | 5996.55 | 153942.0 |
| 2024-10-08 10:00:00 | ES | Futures | 5996.55 | 6015.75 | 5992.91 | 6007.97 | 177988.0 |
| 2024-10-08 11:00:00 | ES | Futures | 6007.97 | 6013.68 | 6002.26 | 6013.16 | 89410.0 |
| 2024-10-08 12:00:00 | ES | Futures | 6012.9 | 6013.68 | 6003.81 | 6009.0 | 68519.0 |
| 2024-10-08 13:00:00 | ES | Futures | 6009.0 | 6009.78 | 5994.47 | 6007.19 | 85866.0 |
| 2024-10-08 14:00:00 | ES | Futures | 6007.19 | 6019.13 | 6006.67 | 6017.31 | 66819.0 |
| 2024-10-08 15:00:00 | ES | Futures | 6017.57 | 6027.95 | 6013.68 | 6021.72 | 180866.0 |
| 2024-10-08 16:00:00 | ES | Futures | 6021.72 | 6022.5 | 6017.05 | 6019.13 | 61638.0 |
| 2024-10-08 18:00:00 | ES | Futures | 6020.16 | 6020.68 | 6015.75 | 6019.65 | 3667.0 |
| 2024-10-08 19:00:00 | ES | Futures | 6019.65 | 6021.2 | 6015.75 | 6016.27 | 2389.0 |
| 2024-10-08 20:00:00 | ES | Futures | 6016.53 | 6017.05 | 6014.45 | 6016.01 | 3216.0 |
| 2024-10-08 21:00:00 | ES | Futures | 6016.27 | 6018.61 | 6014.2 | 6016.27 | 5685.0 |
| 2024-10-08 22:00:00 | ES | Futures | 6016.01 | 6016.27 | 6009.78 | 6011.08 | 6746.0 |
| 2024-10-08 23:00:00 | ES | Futures | 6011.34 | 6012.38 | 6009.52 | 6010.82 | 3756.0 |
| 2024-10-08 00:00:00 | NQ | Futures | 20857.33 | 20883.94 | 20855.77 | 20874.81 | 1613.0 |
| 2024-10-08 01:00:00 | NQ | Futures | 20875.33 | 20885.25 | 20837.24 | 20851.07 | 4275.0 |
| 2024-10-08 02:00:00 | NQ | Futures | 20850.55 | 20862.03 | 20825.24 | 20851.33 | 4120.0 |
| 2024-10-08 03:00:00 | NQ | Futures | 20852.37 | 20901.43 | 20812.98 | 20880.29 | 10023.0 |
| 2024-10-08 04:00:00 | NQ | Futures | 20880.55 | 20899.34 | 20858.37 | 20892.29 | 6949.0 |
| 2024-10-08 05:00:00 | NQ | Futures | 20892.03 | 20966.91 | 20892.03 | 20949.17 | 10852.0 |
| 2024-10-08 06:00:00 | NQ | Futures | 20948.91 | 20972.13 | 20929.86 | 20966.13 | 6916.0 |
| 2024-10-08 07:00:00 | NQ | Futures | 20965.61 | 20978.39 | 20945.52 | 20970.83 | 6705.0 |
| 2024-10-08 08:00:00 | NQ | Futures | 20971.61 | 20981.53 | 20933.26 | 20940.82 | 8410.0 |
| 2024-10-08 09:00:00 | NQ | Futures | 20940.56 | 21037.88 | 20931.69 | 21035.79 | 59448.0 |
| 2024-10-08 10:00:00 | NQ | Futures | 21035.53 | 21158.68 | 21035.01 | 21122.42 | 81130.0 |
| 2024-10-08 11:00:00 | NQ | Futures | 21123.46 | 21146.16 | 21093.72 | 21141.99 | 37008.0 |
| 2024-10-08 12:00:00 | NQ | Futures | 21141.46 | 21141.46 | 21081.72 | 21115.9 | 29286.0 |
| 2024-10-08 13:00:00 | NQ | Futures | 21115.9 | 21121.64 | 21044.93 | 21115.11 | 37866.0 |
| 2024-10-08 14:00:00 | NQ | Futures | 21115.11 | 21168.08 | 21105.72 | 21158.95 | 29529.0 |
| 2024-10-08 15:00:00 | NQ | Futures | 21158.68 | 21216.87 | 21139.38 | 21186.08 | 53526.0 |
| 2024-10-08 16:00:00 | NQ | Futures | 21186.34 | 21186.6 | 21161.29 | 21171.73 | 14204.0 |
| 2024-10-08 18:00:00 | NQ | Futures | 21180.08 | 21180.08 | 21155.81 | 21175.38 | 2560.0 |
| 2024-10-08 19:00:00 | NQ | Futures | 21175.12 | 21182.95 | 21155.81 | 21158.95 | 2381.0 |
| 2024-10-08 20:00:00 | NQ | Futures | 21159.47 | 21166.25 | 21149.03 | 21162.86 | 2108.0 |
| 2024-10-08 21:00:00 | NQ | Futures | 21162.86 | 21174.86 | 21145.64 | 21159.99 | 4269.0 |
| 2024-10-08 22:00:00 | NQ | Futures | 21158.95 | 21158.95 | 21121.9 | 21129.98 | 4288.0 |
| 2024-10-08 23:00:00 | NQ | Futures | 21129.2 | 21136.77 | 21116.68 | 21120.85 | 2799.0 |
| 2024-10-08 00:00:00 | YM | Futures | 43935.4 | 43955.1 | 43932.2 | 43951.0 | 163.0 |
| 2024-10-08 01:00:00 | YM | Futures | 43948.9 | 43958.3 | 43912.5 | 43933.3 | 423.0 |
| 2024-10-08 02:00:00 | YM | Futures | 43932.2 | 43961.4 | 43906.2 | 43947.8 | 823.0 |
| 2024-10-08 03:00:00 | YM | Futures | 43951.0 | 43986.4 | 43882.3 | 43952.0 | 1548.0 |
> showing 50 of 2,094 rows — these rows as CSV