PREVIEW / futures_1hour / 2024-07-16
file: by_date/futures_1hour/2024/2024-07-16.parquet size: 66 KB rows: 2,052
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-07-16 00:00:00 | ES | Futures | 5969.74 | 5970.78 | 5968.69 | 5969.74 | 2459.0 |
| 2024-07-16 01:00:00 | ES | Futures | 5969.74 | 5971.83 | 5968.95 | 5970.78 | 4649.0 |
| 2024-07-16 02:00:00 | ES | Futures | 5970.52 | 5970.52 | 5963.71 | 5965.02 | 6597.0 |
| 2024-07-16 03:00:00 | ES | Futures | 5965.28 | 5965.28 | 5956.36 | 5957.15 | 15291.0 |
| 2024-07-16 04:00:00 | ES | Futures | 5957.15 | 5962.92 | 5949.02 | 5961.61 | 15234.0 |
| 2024-07-16 05:00:00 | ES | Futures | 5961.87 | 5963.97 | 5959.25 | 5963.18 | 9478.0 |
| 2024-07-16 06:00:00 | ES | Futures | 5963.18 | 5969.21 | 5963.18 | 5966.07 | 13250.0 |
| 2024-07-16 07:00:00 | ES | Futures | 5966.33 | 5969.21 | 5965.28 | 5968.42 | 8922.0 |
| 2024-07-16 08:00:00 | ES | Futures | 5968.16 | 5975.5 | 5961.08 | 5971.31 | 37533.0 |
| 2024-07-16 09:00:00 | ES | Futures | 5971.31 | 5983.37 | 5968.16 | 5977.6 | 182345.0 |
| 2024-07-16 10:00:00 | ES | Futures | 5977.6 | 5984.42 | 5967.11 | 5979.17 | 262758.0 |
| 2024-07-16 11:00:00 | ES | Futures | 5979.17 | 5992.28 | 5974.45 | 5977.6 | 184247.0 |
| 2024-07-16 12:00:00 | ES | Futures | 5977.86 | 5983.11 | 5968.42 | 5982.32 | 156174.0 |
| 2024-07-16 13:00:00 | ES | Futures | 5982.58 | 5982.58 | 5971.05 | 5978.91 | 98902.0 |
| 2024-07-16 14:00:00 | ES | Futures | 5978.91 | 5993.59 | 5972.36 | 5993.07 | 132983.0 |
| 2024-07-16 15:00:00 | ES | Futures | 5993.33 | 5999.62 | 5987.04 | 5995.95 | 216904.0 |
| 2024-07-16 16:00:00 | ES | Futures | 5996.21 | 5996.21 | 5990.18 | 5993.59 | 50114.0 |
| 2024-07-16 18:00:00 | ES | Futures | 5993.07 | 5995.95 | 5992.02 | 5994.9 | 4255.0 |
| 2024-07-16 19:00:00 | ES | Futures | 5994.9 | 5994.9 | 5989.4 | 5990.71 | 3658.0 |
| 2024-07-16 20:00:00 | ES | Futures | 5990.97 | 5992.28 | 5988.35 | 5989.66 | 3962.0 |
| 2024-07-16 21:00:00 | ES | Futures | 5989.92 | 5989.92 | 5987.82 | 5988.35 | 4392.0 |
| 2024-07-16 22:00:00 | ES | Futures | 5988.61 | 5991.23 | 5988.09 | 5989.14 | 2630.0 |
| 2024-07-16 23:00:00 | ES | Futures | 5988.87 | 5990.18 | 5984.68 | 5987.3 | 4727.0 |
| 2024-07-16 00:00:00 | NQ | Futures | 21802.58 | 21808.39 | 21793.08 | 21793.6 | 1475.0 |
| 2024-07-16 01:00:00 | NQ | Futures | 21794.13 | 21804.16 | 21787.53 | 21794.66 | 2070.0 |
| 2024-07-16 02:00:00 | NQ | Futures | 21794.66 | 21795.98 | 21766.15 | 21773.28 | 3620.0 |
| 2024-07-16 03:00:00 | NQ | Futures | 21773.28 | 21773.54 | 21713.35 | 21732.62 | 8900.0 |
| 2024-07-16 04:00:00 | NQ | Futures | 21732.89 | 21758.49 | 21690.65 | 21754.53 | 10963.0 |
| 2024-07-16 05:00:00 | NQ | Futures | 21755.06 | 21763.25 | 21726.55 | 21752.95 | 5923.0 |
| 2024-07-16 06:00:00 | NQ | Futures | 21752.16 | 21789.64 | 21748.2 | 21772.75 | 6872.0 |
| 2024-07-16 07:00:00 | NQ | Futures | 21773.28 | 21791.76 | 21770.11 | 21784.63 | 7875.0 |
| 2024-07-16 08:00:00 | NQ | Futures | 21784.89 | 21808.65 | 21725.76 | 21792.02 | 14946.0 |
| 2024-07-16 09:00:00 | NQ | Futures | 21792.28 | 21841.38 | 21717.31 | 21732.1 | 86195.0 |
| 2024-07-16 10:00:00 | NQ | Futures | 21731.83 | 21746.88 | 21631.25 | 21690.91 | 127099.0 |
| 2024-07-16 11:00:00 | NQ | Futures | 21690.65 | 21761.4 | 21670.32 | 21699.89 | 71366.0 |
| 2024-07-16 12:00:00 | NQ | Futures | 21700.15 | 21717.58 | 21609.08 | 21694.61 | 75250.0 |
| 2024-07-16 13:00:00 | NQ | Futures | 21694.08 | 21694.08 | 21641.29 | 21673.49 | 43610.0 |
| 2024-07-16 14:00:00 | NQ | Futures | 21673.23 | 21741.86 | 21631.52 | 21741.6 | 57881.0 |
| 2024-07-16 15:00:00 | NQ | Futures | 21741.6 | 21767.21 | 21708.6 | 21751.63 | 64044.0 |
| 2024-07-16 16:00:00 | NQ | Futures | 21751.89 | 21760.87 | 21737.64 | 21740.01 | 14844.0 |
| 2024-07-16 18:00:00 | NQ | Futures | 21742.65 | 21749.78 | 21729.72 | 21740.54 | 2269.0 |
| 2024-07-16 19:00:00 | NQ | Futures | 21741.07 | 21741.86 | 21706.75 | 21715.46 | 3094.0 |
| 2024-07-16 20:00:00 | NQ | Futures | 21715.73 | 21730.25 | 21707.28 | 21713.62 | 2301.0 |
| 2024-07-16 21:00:00 | NQ | Futures | 21714.41 | 21714.67 | 21695.93 | 21699.89 | 2926.0 |
| 2024-07-16 22:00:00 | NQ | Futures | 21700.42 | 21713.62 | 21696.46 | 21701.74 | 1999.0 |
| 2024-07-16 23:00:00 | NQ | Futures | 21701.74 | 21704.64 | 21673.49 | 21683.79 | 3054.0 |
| 2024-07-16 00:00:00 | YM | Futures | 42628.0 | 42641.7 | 42613.3 | 42631.2 | 1089.0 |
| 2024-07-16 01:00:00 | YM | Futures | 42631.2 | 42639.6 | 42622.8 | 42631.2 | 543.0 |
| 2024-07-16 02:00:00 | YM | Futures | 42631.2 | 42631.2 | 42581.8 | 42586.0 | 1170.0 |
| 2024-07-16 03:00:00 | YM | Futures | 42587.0 | 42595.5 | 42540.8 | 42544.0 | 1739.0 |
> showing 50 of 2,052 rows — these rows as CSV