PREVIEW / futures_1hour / 2024-01-25
file: by_date/futures_1hour/2024/2024-01-25.parquet size: 67 KB rows: 2,084
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-25 00:00:00 | ES | Futures | 5261.69 | 5265.99 | 5260.88 | 5265.45 | 4009.0 |
| 2024-01-25 01:00:00 | ES | Futures | 5265.72 | 5266.26 | 5262.76 | 5264.64 | 4698.0 |
| 2024-01-25 02:00:00 | ES | Futures | 5264.91 | 5269.48 | 5263.84 | 5264.91 | 8622.0 |
| 2024-01-25 03:00:00 | ES | Futures | 5264.91 | 5267.87 | 5261.42 | 5265.99 | 16765.0 |
| 2024-01-25 04:00:00 | ES | Futures | 5265.99 | 5269.21 | 5263.03 | 5266.52 | 12055.0 |
| 2024-01-25 05:00:00 | ES | Futures | 5266.26 | 5266.79 | 5263.03 | 5264.91 | 8362.0 |
| 2024-01-25 06:00:00 | ES | Futures | 5264.91 | 5267.6 | 5263.03 | 5267.33 | 18286.0 |
| 2024-01-25 07:00:00 | ES | Futures | 5267.33 | 5268.94 | 5260.62 | 5261.15 | 17038.0 |
| 2024-01-25 08:00:00 | ES | Futures | 5261.15 | 5283.71 | 5259.54 | 5281.3 | 73532.0 |
| 2024-01-25 09:00:00 | ES | Futures | 5281.3 | 5286.4 | 5275.93 | 5282.1 | 169370.0 |
| 2024-01-25 10:00:00 | ES | Futures | 5282.1 | 5292.85 | 5277.0 | 5280.22 | 207391.0 |
| 2024-01-25 11:00:00 | ES | Futures | 5280.22 | 5290.43 | 5276.46 | 5285.06 | 146624.0 |
| 2024-01-25 12:00:00 | ES | Futures | 5285.06 | 5286.4 | 5269.21 | 5273.78 | 158362.0 |
| 2024-01-25 13:00:00 | ES | Futures | 5273.51 | 5281.83 | 5265.18 | 5267.33 | 151682.0 |
| 2024-01-25 14:00:00 | ES | Futures | 5267.06 | 5274.85 | 5260.88 | 5274.85 | 145221.0 |
| 2024-01-25 15:00:00 | ES | Futures | 5274.58 | 5290.7 | 5270.82 | 5290.16 | 203853.0 |
| 2024-01-25 16:00:00 | ES | Futures | 5290.16 | 5291.77 | 5284.52 | 5284.79 | 75486.0 |
| 2024-01-25 18:00:00 | ES | Futures | 5285.06 | 5285.33 | 5277.54 | 5279.15 | 10738.0 |
| 2024-01-25 19:00:00 | ES | Futures | 5279.15 | 5280.49 | 5276.73 | 5277.81 | 6760.0 |
| 2024-01-25 20:00:00 | ES | Futures | 5278.07 | 5278.07 | 5274.85 | 5277.0 | 8999.0 |
| 2024-01-25 21:00:00 | ES | Futures | 5277.0 | 5281.03 | 5275.39 | 5275.39 | 5504.0 |
| 2024-01-25 22:00:00 | ES | Futures | 5275.66 | 5277.0 | 5274.31 | 5274.85 | 3952.0 |
| 2024-01-25 23:00:00 | ES | Futures | 5274.85 | 5275.39 | 5265.72 | 5267.06 | 9659.0 |
| 2024-01-25 00:00:00 | NQ | Futures | 19103.18 | 19122.44 | 19097.49 | 19121.08 | 2760.0 |
| 2024-01-25 01:00:00 | NQ | Futures | 19120.81 | 19125.96 | 19107.79 | 19118.37 | 3245.0 |
| 2024-01-25 02:00:00 | NQ | Futures | 19118.64 | 19144.4 | 19115.66 | 19122.71 | 4912.0 |
| 2024-01-25 03:00:00 | NQ | Futures | 19122.71 | 19152.81 | 19096.13 | 19131.66 | 12010.0 |
| 2024-01-25 04:00:00 | NQ | Futures | 19132.2 | 19137.35 | 19110.23 | 19123.25 | 7852.0 |
| 2024-01-25 05:00:00 | NQ | Futures | 19122.98 | 19124.06 | 19104.27 | 19112.13 | 5383.0 |
| 2024-01-25 06:00:00 | NQ | Futures | 19112.13 | 19145.76 | 19103.99 | 19143.59 | 9151.0 |
| 2024-01-25 07:00:00 | NQ | Futures | 19143.59 | 19162.3 | 19130.57 | 19134.1 | 12665.0 |
| 2024-01-25 08:00:00 | NQ | Futures | 19134.1 | 19218.17 | 19107.79 | 19208.41 | 35440.0 |
| 2024-01-25 09:00:00 | NQ | Futures | 19208.41 | 19230.92 | 19158.51 | 19167.19 | 89101.0 |
| 2024-01-25 10:00:00 | NQ | Futures | 19167.73 | 19242.58 | 19146.3 | 19209.49 | 110397.0 |
| 2024-01-25 11:00:00 | NQ | Futures | 19209.49 | 19257.77 | 19184.0 | 19227.39 | 75000.0 |
| 2024-01-25 12:00:00 | NQ | Futures | 19227.12 | 19236.07 | 19128.67 | 19148.2 | 73696.0 |
| 2024-01-25 13:00:00 | NQ | Futures | 19149.01 | 19181.83 | 19060.6 | 19067.65 | 81043.0 |
| 2024-01-25 14:00:00 | NQ | Futures | 19067.65 | 19103.45 | 19029.96 | 19102.91 | 64741.0 |
| 2024-01-25 15:00:00 | NQ | Futures | 19102.64 | 19135.73 | 19082.3 | 19134.1 | 65792.0 |
| 2024-01-25 16:00:00 | NQ | Futures | 19133.83 | 19147.93 | 19070.37 | 19070.64 | 22389.0 |
| 2024-01-25 18:00:00 | NQ | Futures | 19061.69 | 19061.96 | 19017.48 | 19030.5 | 7796.0 |
| 2024-01-25 19:00:00 | NQ | Futures | 19030.77 | 19038.36 | 19015.31 | 19017.48 | 5362.0 |
| 2024-01-25 20:00:00 | NQ | Futures | 19017.75 | 19017.75 | 18993.89 | 19005.82 | 6838.0 |
| 2024-01-25 21:00:00 | NQ | Futures | 19005.28 | 19028.6 | 19002.56 | 19004.73 | 4369.0 |
| 2024-01-25 22:00:00 | NQ | Futures | 19004.73 | 19013.68 | 18998.77 | 19003.65 | 3124.0 |
| 2024-01-25 23:00:00 | NQ | Futures | 19003.65 | 19005.82 | 18966.49 | 18974.9 | 6011.0 |
| 2024-01-25 00:00:00 | YM | Futures | 40865.4 | 40882.6 | 40859.0 | 40878.3 | 408.0 |
| 2024-01-25 01:00:00 | YM | Futures | 40879.4 | 40892.3 | 40868.7 | 40883.7 | 826.0 |
| 2024-01-25 02:00:00 | YM | Futures | 40885.8 | 40911.6 | 40879.4 | 40885.8 | 1624.0 |
| 2024-01-25 03:00:00 | YM | Futures | 40884.8 | 40896.6 | 40859.0 | 40888.0 | 2830.0 |
> showing 50 of 2,084 rows — these rows as CSV