PREVIEW / futures_1hour / 2024-06-13
file: by_date/futures_1hour/2024/2024-06-13.parquet size: 65 KB rows: 1,962
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-13 00:00:00 | ES | Futures | 5773.63 | 5774.16 | 5772.57 | 5773.37 | 1936.0 |
| 2024-06-13 01:00:00 | ES | Futures | 5773.63 | 5773.63 | 5768.06 | 5769.39 | 4508.0 |
| 2024-06-13 02:00:00 | ES | Futures | 5769.39 | 5774.43 | 5767.79 | 5773.9 | 6828.0 |
| 2024-06-13 03:00:00 | ES | Futures | 5773.63 | 5776.81 | 5769.39 | 5770.98 | 15125.0 |
| 2024-06-13 04:00:00 | ES | Futures | 5770.98 | 5773.37 | 5765.94 | 5768.32 | 13765.0 |
| 2024-06-13 05:00:00 | ES | Futures | 5768.32 | 5771.51 | 5760.1 | 5761.16 | 13881.0 |
| 2024-06-13 06:00:00 | ES | Futures | 5761.43 | 5765.41 | 5757.98 | 5764.88 | 17972.0 |
| 2024-06-13 07:00:00 | ES | Futures | 5764.88 | 5768.32 | 5763.81 | 5765.14 | 16026.0 |
| 2024-06-13 08:00:00 | ES | Futures | 5764.88 | 5786.36 | 5764.88 | 5774.96 | 79776.0 |
| 2024-06-13 09:00:00 | ES | Futures | 5774.96 | 5778.67 | 5762.22 | 5764.88 | 165555.0 |
| 2024-06-13 10:00:00 | ES | Futures | 5764.88 | 5768.06 | 5748.43 | 5749.75 | 223865.0 |
| 2024-06-13 11:00:00 | ES | Futures | 5749.75 | 5761.43 | 5746.31 | 5756.39 | 142373.0 |
| 2024-06-13 12:00:00 | ES | Futures | 5756.39 | 5756.65 | 5739.41 | 5751.35 | 158711.0 |
| 2024-06-13 13:00:00 | ES | Futures | 5751.35 | 5764.61 | 5749.75 | 5761.43 | 107164.0 |
| 2024-06-13 14:00:00 | ES | Futures | 5761.69 | 5771.24 | 5756.65 | 5770.18 | 86488.0 |
| 2024-06-13 15:00:00 | ES | Futures | 5770.18 | 5778.94 | 5766.73 | 5769.12 | 187839.0 |
| 2024-06-13 16:00:00 | ES | Futures | 5769.12 | 5776.02 | 5766.47 | 5768.86 | 58067.0 |
| 2024-06-13 18:00:00 | ES | Futures | 5768.59 | 5770.71 | 5764.35 | 5769.12 | 4896.0 |
| 2024-06-13 19:00:00 | ES | Futures | 5769.39 | 5771.51 | 5767.53 | 5770.71 | 2473.0 |
| 2024-06-13 20:00:00 | ES | Futures | 5770.45 | 5771.77 | 5769.39 | 5769.92 | 4052.0 |
| 2024-06-13 21:00:00 | ES | Futures | 5769.92 | 5772.83 | 5769.65 | 5772.57 | 3642.0 |
| 2024-06-13 22:00:00 | ES | Futures | 5772.3 | 5773.63 | 5771.51 | 5773.1 | 2756.0 |
| 2024-06-13 23:00:00 | ES | Futures | 5773.1 | 5774.43 | 5772.57 | 5774.16 | 3370.0 |
| 2024-06-13 00:00:00 | NQ | Futures | 21011.37 | 21015.65 | 21005.22 | 21012.71 | 1824.0 |
| 2024-06-13 01:00:00 | NQ | Futures | 21013.78 | 21014.05 | 20992.91 | 21000.94 | 3150.0 |
| 2024-06-13 02:00:00 | NQ | Futures | 21001.21 | 21028.76 | 20995.32 | 21025.55 | 4857.0 |
| 2024-06-13 03:00:00 | NQ | Futures | 21025.01 | 21049.09 | 21010.3 | 21031.17 | 8397.0 |
| 2024-06-13 04:00:00 | NQ | Futures | 21032.24 | 21037.05 | 21001.47 | 21015.38 | 7022.0 |
| 2024-06-13 05:00:00 | NQ | Futures | 21015.38 | 21023.14 | 20954.66 | 20969.11 | 8402.0 |
| 2024-06-13 06:00:00 | NQ | Futures | 20969.64 | 20993.45 | 20955.2 | 20989.44 | 6075.0 |
| 2024-06-13 07:00:00 | NQ | Futures | 20989.7 | 21003.35 | 20978.47 | 20982.48 | 7236.0 |
| 2024-06-13 08:00:00 | NQ | Futures | 20981.95 | 21069.69 | 20979.81 | 21003.61 | 30054.0 |
| 2024-06-13 09:00:00 | NQ | Futures | 21003.61 | 21040.26 | 20988.1 | 21005.75 | 78349.0 |
| 2024-06-13 10:00:00 | NQ | Futures | 21005.49 | 21026.35 | 20902.5 | 20923.9 | 100292.0 |
| 2024-06-13 11:00:00 | NQ | Futures | 20924.17 | 20981.95 | 20913.46 | 20958.94 | 52708.0 |
| 2024-06-13 12:00:00 | NQ | Futures | 20959.48 | 20960.55 | 20865.31 | 20912.39 | 61416.0 |
| 2024-06-13 13:00:00 | NQ | Futures | 20912.13 | 20957.34 | 20905.17 | 20938.08 | 40910.0 |
| 2024-06-13 14:00:00 | NQ | Futures | 20938.34 | 20978.2 | 20916.67 | 20971.25 | 36513.0 |
| 2024-06-13 15:00:00 | NQ | Futures | 20971.51 | 21006.82 | 20956.0 | 20964.83 | 60826.0 |
| 2024-06-13 16:00:00 | NQ | Futures | 20964.29 | 21013.51 | 20960.55 | 20980.61 | 18913.0 |
| 2024-06-13 18:00:00 | NQ | Futures | 20975.26 | 20988.63 | 20964.29 | 20983.02 | 2637.0 |
| 2024-06-13 19:00:00 | NQ | Futures | 20983.02 | 20996.93 | 20973.39 | 20992.38 | 2121.0 |
| 2024-06-13 20:00:00 | NQ | Futures | 20992.65 | 20998.53 | 20987.03 | 20988.9 | 2329.0 |
| 2024-06-13 21:00:00 | NQ | Futures | 20989.17 | 21004.15 | 20985.16 | 21002.01 | 2208.0 |
| 2024-06-13 22:00:00 | NQ | Futures | 21001.74 | 21013.24 | 20998.0 | 21009.5 | 2001.0 |
| 2024-06-13 23:00:00 | NQ | Futures | 21009.5 | 21019.4 | 21007.63 | 21015.38 | 2570.0 |
| 2024-06-13 00:00:00 | YM | Futures | 41122.9 | 41127.2 | 41115.5 | 41119.7 | 243.0 |
| 2024-06-13 01:00:00 | YM | Futures | 41120.8 | 41120.8 | 41086.8 | 41091.1 | 590.0 |
| 2024-06-13 02:00:00 | YM | Futures | 41091.1 | 41119.7 | 41083.6 | 41116.5 | 1235.0 |
| 2024-06-13 03:00:00 | YM | Futures | 41116.5 | 41122.9 | 41067.7 | 41068.8 | 1765.0 |
> showing 50 of 1,962 rows — these rows as CSV