PREVIEW / futures_1hour / 2024-01-26
file: by_date/futures_1hour/2024/2024-01-26.parquet size: 57 KB rows: 1,666
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-01-26 00:00:00 | ES | Futures | 5267.33 | 5273.51 | 5267.06 | 5270.82 | 6160.0 |
| 2024-01-26 01:00:00 | ES | Futures | 5270.82 | 5271.09 | 5263.57 | 5267.6 | 8818.0 |
| 2024-01-26 02:00:00 | ES | Futures | 5267.6 | 5270.02 | 5262.76 | 5263.84 | 11459.0 |
| 2024-01-26 03:00:00 | ES | Futures | 5263.84 | 5270.55 | 5263.3 | 5268.67 | 15580.0 |
| 2024-01-26 04:00:00 | ES | Futures | 5268.94 | 5278.34 | 5265.45 | 5278.07 | 14314.0 |
| 2024-01-26 05:00:00 | ES | Futures | 5278.34 | 5281.83 | 5276.46 | 5279.69 | 12904.0 |
| 2024-01-26 06:00:00 | ES | Futures | 5279.69 | 5283.71 | 5277.54 | 5282.1 | 12437.0 |
| 2024-01-26 07:00:00 | ES | Futures | 5282.1 | 5288.55 | 5281.83 | 5283.71 | 18213.0 |
| 2024-01-26 08:00:00 | ES | Futures | 5283.71 | 5295.26 | 5277.0 | 5293.11 | 68653.0 |
| 2024-01-26 09:00:00 | ES | Futures | 5292.85 | 5293.11 | 5278.88 | 5285.59 | 166056.0 |
| 2024-01-26 10:00:00 | ES | Futures | 5285.06 | 5300.1 | 5278.07 | 5300.1 | 187179.0 |
| 2024-01-26 11:00:00 | ES | Futures | 5300.1 | 5301.17 | 5289.89 | 5296.88 | 132000.0 |
| 2024-01-26 12:00:00 | ES | Futures | 5296.61 | 5298.22 | 5274.31 | 5277.54 | 153195.0 |
| 2024-01-26 13:00:00 | ES | Futures | 5277.54 | 5283.18 | 5272.43 | 5277.27 | 113182.0 |
| 2024-01-26 14:00:00 | ES | Futures | 5277.27 | 5289.89 | 5276.73 | 5288.28 | 92770.0 |
| 2024-01-26 15:00:00 | ES | Futures | 5288.28 | 5289.09 | 5278.07 | 5282.64 | 160256.0 |
| 2024-01-26 16:00:00 | ES | Futures | 5282.64 | 5282.91 | 5278.07 | 5278.07 | 54307.0 |
| 2024-01-26 00:00:00 | NQ | Futures | 18974.63 | 19009.07 | 18973.0 | 18990.63 | 4835.0 |
| 2024-01-26 01:00:00 | NQ | Futures | 18990.9 | 18993.34 | 18962.15 | 18983.31 | 7389.0 |
| 2024-01-26 02:00:00 | NQ | Futures | 18983.85 | 18996.6 | 18949.14 | 18953.48 | 8034.0 |
| 2024-01-26 03:00:00 | NQ | Futures | 18952.39 | 18980.87 | 18947.51 | 18965.95 | 9298.0 |
| 2024-01-26 04:00:00 | NQ | Futures | 18966.49 | 19020.19 | 18949.95 | 19019.11 | 9907.0 |
| 2024-01-26 05:00:00 | NQ | Futures | 19019.11 | 19035.11 | 19002.84 | 19021.82 | 10103.0 |
| 2024-01-26 06:00:00 | NQ | Futures | 19021.28 | 19044.06 | 19005.28 | 19041.35 | 7841.0 |
| 2024-01-26 07:00:00 | NQ | Futures | 19041.35 | 19082.3 | 19036.19 | 19055.18 | 11119.0 |
| 2024-01-26 08:00:00 | NQ | Futures | 19055.99 | 19105.35 | 19026.16 | 19090.43 | 31946.0 |
| 2024-01-26 09:00:00 | NQ | Futures | 19090.98 | 19091.25 | 19003.11 | 19037.28 | 81144.0 |
| 2024-01-26 10:00:00 | NQ | Futures | 19037.01 | 19121.89 | 18988.73 | 19121.62 | 98227.0 |
| 2024-01-26 11:00:00 | NQ | Futures | 19121.35 | 19124.88 | 19067.92 | 19102.91 | 64916.0 |
| 2024-01-26 12:00:00 | NQ | Futures | 19103.18 | 19127.59 | 19000.67 | 19014.77 | 75655.0 |
| 2024-01-26 13:00:00 | NQ | Futures | 19015.04 | 19038.63 | 18988.19 | 19004.46 | 51703.0 |
| 2024-01-26 14:00:00 | NQ | Futures | 19004.73 | 19064.4 | 18999.85 | 19051.65 | 47384.0 |
| 2024-01-26 15:00:00 | NQ | Futures | 19052.19 | 19057.35 | 19000.94 | 19015.85 | 56764.0 |
| 2024-01-26 16:00:00 | NQ | Futures | 19016.12 | 19019.11 | 18980.87 | 18989.55 | 16300.0 |
| 2024-01-26 00:00:00 | YM | Futures | 40893.4 | 40927.7 | 40893.4 | 40917.0 | 750.0 |
| 2024-01-26 01:00:00 | YM | Futures | 40918.1 | 40918.1 | 40868.7 | 40889.1 | 1153.0 |
| 2024-01-26 02:00:00 | YM | Futures | 40890.1 | 40913.8 | 40875.1 | 40882.6 | 1541.0 |
| 2024-01-26 03:00:00 | YM | Futures | 40882.6 | 40926.7 | 40879.4 | 40918.1 | 2082.0 |
| 2024-01-26 04:00:00 | YM | Futures | 40919.1 | 40966.4 | 40898.7 | 40957.8 | 2554.0 |
| 2024-01-26 05:00:00 | YM | Futures | 40960.0 | 40977.1 | 40954.6 | 40967.5 | 1506.0 |
| 2024-01-26 06:00:00 | YM | Futures | 40966.4 | 40993.2 | 40955.7 | 40968.5 | 1812.0 |
| 2024-01-26 07:00:00 | YM | Futures | 40968.5 | 41042.7 | 40968.5 | 41012.6 | 3991.0 |
| 2024-01-26 08:00:00 | YM | Futures | 41013.7 | 41056.6 | 40924.5 | 41040.5 | 8254.0 |
| 2024-01-26 09:00:00 | YM | Futures | 41041.6 | 41116.8 | 40950.3 | 41070.6 | 24942.0 |
| 2024-01-26 10:00:00 | YM | Futures | 41069.5 | 41216.7 | 41033.0 | 41197.3 | 21037.0 |
| 2024-01-26 11:00:00 | YM | Futures | 41197.3 | 41202.7 | 41126.4 | 41172.6 | 10951.0 |
| 2024-01-26 12:00:00 | YM | Futures | 41171.5 | 41181.2 | 41013.7 | 41049.1 | 13038.0 |
| 2024-01-26 13:00:00 | YM | Futures | 41049.1 | 41094.2 | 41002.9 | 41039.4 | 9444.0 |
| 2024-01-26 14:00:00 | YM | Futures | 41041.6 | 41124.3 | 41035.1 | 41112.5 | 7913.0 |
| 2024-01-26 15:00:00 | YM | Futures | 41111.4 | 41118.9 | 41053.4 | 41095.3 | 11686.0 |
> showing 50 of 1,666 rows — these rows as CSV