PREVIEW / futures_1hour / 2024-09-23
file: by_date/futures_1hour/2024/2024-09-23.parquet size: 67 KB rows: 2,075
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-09-23 00:00:00 | ES | Futures | 5999.14 | 6001.48 | 5998.88 | 5999.92 | 2424.0 |
| 2024-09-23 01:00:00 | ES | Futures | 5999.92 | 5999.92 | 5994.21 | 5994.99 | 4149.0 |
| 2024-09-23 02:00:00 | ES | Futures | 5994.99 | 5994.99 | 5989.8 | 5990.06 | 6215.0 |
| 2024-09-23 03:00:00 | ES | Futures | 5990.32 | 5990.58 | 5964.11 | 5984.09 | 29387.0 |
| 2024-09-23 04:00:00 | ES | Futures | 5984.35 | 5987.46 | 5978.12 | 5984.61 | 17894.0 |
| 2024-09-23 05:00:00 | ES | Futures | 5984.87 | 5992.14 | 5979.68 | 5991.36 | 10111.0 |
| 2024-09-23 06:00:00 | ES | Futures | 5991.36 | 5993.69 | 5989.02 | 5989.54 | 7634.0 |
| 2024-09-23 07:00:00 | ES | Futures | 5989.28 | 5993.17 | 5983.31 | 5992.14 | 10587.0 |
| 2024-09-23 08:00:00 | ES | Futures | 5991.88 | 5995.51 | 5986.69 | 5994.21 | 20051.0 |
| 2024-09-23 09:00:00 | ES | Futures | 5993.95 | 5997.59 | 5983.05 | 5988.5 | 124434.0 |
| 2024-09-23 10:00:00 | ES | Futures | 5988.5 | 6004.85 | 5984.61 | 5999.66 | 174303.0 |
| 2024-09-23 11:00:00 | ES | Futures | 5999.66 | 6002.78 | 5987.72 | 5996.81 | 126467.0 |
| 2024-09-23 12:00:00 | ES | Futures | 5996.81 | 5997.59 | 5982.53 | 5985.91 | 112762.0 |
| 2024-09-23 13:00:00 | ES | Futures | 5985.91 | 5993.69 | 5980.46 | 5992.91 | 93083.0 |
| 2024-09-23 14:00:00 | ES | Futures | 5992.65 | 5995.25 | 5987.72 | 5994.47 | 65522.0 |
| 2024-09-23 15:00:00 | ES | Futures | 5994.47 | 5999.66 | 5990.06 | 5996.29 | 135817.0 |
| 2024-09-23 16:00:00 | ES | Futures | 5996.29 | 5998.36 | 5992.91 | 5994.73 | 33628.0 |
| 2024-09-23 18:00:00 | ES | Futures | 5993.95 | 5994.99 | 5989.8 | 5990.58 | 2952.0 |
| 2024-09-23 19:00:00 | ES | Futures | 5990.58 | 5993.95 | 5989.28 | 5992.65 | 2774.0 |
| 2024-09-23 20:00:00 | ES | Futures | 5992.65 | 5994.47 | 5986.69 | 5989.8 | 5226.0 |
| 2024-09-23 21:00:00 | ES | Futures | 5990.06 | 5997.59 | 5986.69 | 5988.24 | 11114.0 |
| 2024-09-23 22:00:00 | ES | Futures | 5988.24 | 5989.02 | 5983.31 | 5987.2 | 6769.0 |
| 2024-09-23 23:00:00 | ES | Futures | 5986.95 | 5989.02 | 5984.87 | 5987.72 | 4207.0 |
| 2024-09-23 00:00:00 | NQ | Futures | 21024.84 | 21037.62 | 21017.53 | 21021.18 | 1794.0 |
| 2024-09-23 01:00:00 | NQ | Futures | 21022.75 | 21023.53 | 20981.53 | 20983.87 | 3094.0 |
| 2024-09-23 02:00:00 | NQ | Futures | 20984.92 | 20985.96 | 20959.09 | 20963.52 | 4033.0 |
| 2024-09-23 03:00:00 | NQ | Futures | 20963.52 | 20965.35 | 20826.28 | 20935.87 | 14325.0 |
| 2024-09-23 04:00:00 | NQ | Futures | 20936.65 | 20948.91 | 20889.94 | 20920.47 | 9258.0 |
| 2024-09-23 05:00:00 | NQ | Futures | 20922.04 | 20959.35 | 20900.12 | 20954.91 | 5837.0 |
| 2024-09-23 06:00:00 | NQ | Futures | 20954.91 | 20967.44 | 20946.3 | 20948.39 | 4327.0 |
| 2024-09-23 07:00:00 | NQ | Futures | 20947.61 | 20960.65 | 20919.43 | 20955.17 | 6119.0 |
| 2024-09-23 08:00:00 | NQ | Futures | 20954.91 | 20974.48 | 20935.08 | 20964.3 | 9188.0 |
| 2024-09-23 09:00:00 | NQ | Futures | 20964.3 | 20982.57 | 20905.6 | 20941.87 | 53935.0 |
| 2024-09-23 10:00:00 | NQ | Futures | 20942.39 | 21005.27 | 20918.91 | 20973.7 | 67631.0 |
| 2024-09-23 11:00:00 | NQ | Futures | 20974.22 | 21004.22 | 20922.3 | 20982.83 | 46739.0 |
| 2024-09-23 12:00:00 | NQ | Futures | 20982.83 | 20985.7 | 20909.77 | 20921.25 | 40154.0 |
| 2024-09-23 13:00:00 | NQ | Futures | 20920.73 | 20954.91 | 20892.55 | 20949.69 | 29640.0 |
| 2024-09-23 14:00:00 | NQ | Futures | 20949.43 | 20962.48 | 20932.21 | 20957.78 | 22999.0 |
| 2024-09-23 15:00:00 | NQ | Futures | 20957.52 | 20966.13 | 20929.34 | 20952.82 | 36834.0 |
| 2024-09-23 16:00:00 | NQ | Futures | 20952.56 | 20962.48 | 20930.39 | 20939.0 | 9052.0 |
| 2024-09-23 18:00:00 | NQ | Futures | 20939.0 | 20942.39 | 20920.21 | 20925.95 | 1790.0 |
| 2024-09-23 19:00:00 | NQ | Futures | 20927.52 | 20949.17 | 20917.86 | 20945.0 | 2086.0 |
| 2024-09-23 20:00:00 | NQ | Futures | 20944.21 | 20954.91 | 20914.21 | 20933.52 | 3197.0 |
| 2024-09-23 21:00:00 | NQ | Futures | 20933.78 | 20972.92 | 20920.99 | 20926.21 | 5177.0 |
| 2024-09-23 22:00:00 | NQ | Futures | 20925.95 | 20927.52 | 20896.47 | 20919.95 | 3648.0 |
| 2024-09-23 23:00:00 | NQ | Futures | 20918.91 | 20931.69 | 20906.9 | 20925.43 | 1828.0 |
| 2024-09-23 00:00:00 | YM | Futures | 44239.3 | 44253.8 | 44238.2 | 44250.7 | 266.0 |
| 2024-09-23 01:00:00 | YM | Futures | 44250.7 | 44257.0 | 44234.1 | 44236.1 | 540.0 |
| 2024-09-23 02:00:00 | YM | Futures | 44238.2 | 44239.3 | 44189.3 | 44190.3 | 1046.0 |
| 2024-09-23 03:00:00 | YM | Futures | 44191.4 | 44194.5 | 44045.7 | 44155.0 | 3438.0 |
> showing 50 of 2,075 rows — these rows as CSV