PREVIEW / futures_1hour / 2024-06-14
file: by_date/futures_1hour/2024/2024-06-14.parquet size: 56 KB rows: 1,632
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-06-14 00:00:00 | ES | Futures | 5774.16 | 5774.42 | 5771.8 | 5772.59 | 681.0 |
| 2024-06-14 01:00:00 | ES | Futures | 5772.59 | 5775.21 | 5772.06 | 5774.95 | 1705.0 |
| 2024-06-14 02:00:00 | ES | Futures | 5774.95 | 5775.73 | 5767.34 | 5768.66 | 2748.0 |
| 2024-06-14 03:00:00 | ES | Futures | 5768.39 | 5770.23 | 5761.05 | 5765.25 | 7038.0 |
| 2024-06-14 04:00:00 | ES | Futures | 5764.99 | 5767.87 | 5758.69 | 5758.69 | 7802.0 |
| 2024-06-14 05:00:00 | ES | Futures | 5758.69 | 5760.79 | 5744.54 | 5744.8 | 8669.0 |
| 2024-06-14 06:00:00 | ES | Futures | 5744.54 | 5745.32 | 5732.48 | 5737.46 | 17155.0 |
| 2024-06-14 07:00:00 | ES | Futures | 5737.46 | 5748.47 | 5728.28 | 5741.65 | 17722.0 |
| 2024-06-14 08:00:00 | ES | Futures | 5741.65 | 5749.78 | 5739.82 | 5745.59 | 15685.0 |
| 2024-06-14 09:00:00 | ES | Futures | 5745.85 | 5757.91 | 5743.49 | 5756.86 | 46988.0 |
| 2024-06-14 10:00:00 | ES | Futures | 5756.33 | 5756.33 | 5739.03 | 5753.45 | 67922.0 |
| 2024-06-14 11:00:00 | ES | Futures | 5753.19 | 5759.22 | 5743.23 | 5755.29 | 42665.0 |
| 2024-06-14 12:00:00 | ES | Futures | 5755.02 | 5760.79 | 5750.57 | 5759.74 | 30644.0 |
| 2024-06-14 13:00:00 | ES | Futures | 5759.74 | 5766.56 | 5757.38 | 5759.48 | 32627.0 |
| 2024-06-14 14:00:00 | ES | Futures | 5759.48 | 5765.51 | 5753.19 | 5762.89 | 38471.0 |
| 2024-06-14 15:00:00 | ES | Futures | 5762.63 | 5771.02 | 5760.53 | 5769.97 | 52364.0 |
| 2024-06-14 16:00:00 | ES | Futures | 5770.23 | 5770.49 | 5765.77 | 5767.87 | 13116.0 |
| 2024-06-14 00:00:00 | NQ | Futures | 21015.38 | 21015.65 | 21005.35 | 21011.16 | 949.0 |
| 2024-06-14 01:00:00 | NQ | Futures | 21011.69 | 21020.4 | 21007.99 | 21019.34 | 826.0 |
| 2024-06-14 02:00:00 | NQ | Futures | 21019.34 | 21031.49 | 20995.06 | 21002.18 | 1475.0 |
| 2024-06-14 03:00:00 | NQ | Futures | 21001.39 | 21032.01 | 20979.22 | 21014.86 | 2945.0 |
| 2024-06-14 04:00:00 | NQ | Futures | 21014.33 | 21029.11 | 20987.93 | 20988.98 | 2888.0 |
| 2024-06-14 05:00:00 | NQ | Futures | 20990.04 | 20999.54 | 20925.63 | 20926.68 | 3444.0 |
| 2024-06-14 06:00:00 | NQ | Futures | 20925.36 | 20934.34 | 20888.94 | 20909.0 | 6546.0 |
| 2024-06-14 07:00:00 | NQ | Futures | 20908.47 | 20938.04 | 20868.87 | 20906.09 | 7768.0 |
| 2024-06-14 08:00:00 | NQ | Futures | 20907.15 | 20947.01 | 20902.13 | 20931.17 | 5959.0 |
| 2024-06-14 09:00:00 | NQ | Futures | 20930.64 | 21016.7 | 20921.93 | 21013.01 | 25193.0 |
| 2024-06-14 10:00:00 | NQ | Futures | 21011.95 | 21023.83 | 20944.37 | 21002.98 | 27272.0 |
| 2024-06-14 11:00:00 | NQ | Futures | 21002.45 | 21005.88 | 20931.17 | 20988.98 | 18187.0 |
| 2024-06-14 12:00:00 | NQ | Futures | 20988.72 | 21015.91 | 20972.88 | 21004.82 | 15318.0 |
| 2024-06-14 13:00:00 | NQ | Futures | 21005.35 | 21051.28 | 20999.54 | 21031.22 | 14856.0 |
| 2024-06-14 14:00:00 | NQ | Futures | 21031.75 | 21050.49 | 21001.13 | 21040.46 | 14951.0 |
| 2024-06-14 15:00:00 | NQ | Futures | 21039.93 | 21067.39 | 21019.34 | 21063.96 | 19558.0 |
| 2024-06-14 16:00:00 | NQ | Futures | 21063.43 | 21075.31 | 21055.24 | 21073.2 | 5072.0 |
| 2024-06-14 00:00:00 | YM | Futures | 41053.9 | 41057.1 | 41040.1 | 41046.5 | 376.0 |
| 2024-06-14 01:00:00 | YM | Futures | 41046.5 | 41060.3 | 41044.4 | 41058.2 | 475.0 |
| 2024-06-14 02:00:00 | YM | Futures | 41057.1 | 41060.3 | 40987.0 | 41006.1 | 1377.0 |
| 2024-06-14 03:00:00 | YM | Futures | 41005.1 | 41014.6 | 40924.4 | 40935.0 | 3100.0 |
| 2024-06-14 04:00:00 | YM | Futures | 40933.9 | 40940.3 | 40846.9 | 40849.0 | 3601.0 |
| 2024-06-14 05:00:00 | YM | Futures | 40850.1 | 40868.1 | 40759.8 | 40764.1 | 4383.0 |
| 2024-06-14 06:00:00 | YM | Futures | 40765.1 | 40766.2 | 40674.9 | 40716.3 | 6443.0 |
| 2024-06-14 07:00:00 | YM | Futures | 40716.3 | 40816.1 | 40669.6 | 40754.5 | 6142.0 |
| 2024-06-14 08:00:00 | YM | Futures | 40755.6 | 40803.3 | 40740.7 | 40772.6 | 5035.0 |
| 2024-06-14 09:00:00 | YM | Futures | 40773.6 | 40931.8 | 40753.4 | 40833.1 | 16539.0 |
| 2024-06-14 10:00:00 | YM | Futures | 40830.9 | 40840.5 | 40686.6 | 40832.0 | 17796.0 |
| 2024-06-14 11:00:00 | YM | Futures | 40830.9 | 40958.4 | 40811.8 | 40952.0 | 11960.0 |
| 2024-06-14 12:00:00 | YM | Futures | 40952.0 | 40995.5 | 40898.9 | 40977.5 | 7893.0 |
| 2024-06-14 13:00:00 | YM | Futures | 40976.4 | 41004.0 | 40888.3 | 40901.0 | 6293.0 |
| 2024-06-14 14:00:00 | YM | Futures | 40901.0 | 40979.6 | 40854.3 | 40957.3 | 7533.0 |
| 2024-06-14 15:00:00 | YM | Futures | 40956.2 | 40996.6 | 40926.5 | 40990.2 | 10061.0 |
> showing 50 of 1,632 rows — these rows as CSV