PREVIEW / futures_1hour / 2024-11-11
file: by_date/futures_1hour/2024/2024-11-11.parquet size: 67 KB rows: 2,085
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-11-11 00:00:00 | ES | Futures | 6266.45 | 6268.53 | 6265.93 | 6266.19 | 4173.0 |
| 2024-11-11 01:00:00 | ES | Futures | 6266.45 | 6268.27 | 6265.67 | 6267.49 | 4123.0 |
| 2024-11-11 02:00:00 | ES | Futures | 6267.23 | 6270.09 | 6265.41 | 6269.57 | 6720.0 |
| 2024-11-11 03:00:00 | ES | Futures | 6269.57 | 6275.02 | 6268.79 | 6270.86 | 16835.0 |
| 2024-11-11 04:00:00 | ES | Futures | 6270.86 | 6274.24 | 6268.79 | 6271.38 | 10972.0 |
| 2024-11-11 05:00:00 | ES | Futures | 6271.38 | 6273.46 | 6269.57 | 6269.57 | 8562.0 |
| 2024-11-11 06:00:00 | ES | Futures | 6269.83 | 6273.46 | 6269.57 | 6273.2 | 10231.0 |
| 2024-11-11 07:00:00 | ES | Futures | 6273.2 | 6283.84 | 6272.94 | 6281.5 | 20844.0 |
| 2024-11-11 08:00:00 | ES | Futures | 6281.5 | 6283.06 | 6271.12 | 6272.68 | 26482.0 |
| 2024-11-11 09:00:00 | ES | Futures | 6272.68 | 6275.54 | 6262.3 | 6265.41 | 140543.0 |
| 2024-11-11 10:00:00 | ES | Futures | 6265.41 | 6273.72 | 6258.67 | 6270.6 | 153097.0 |
| 2024-11-11 11:00:00 | ES | Futures | 6270.6 | 6273.72 | 6263.08 | 6268.53 | 85900.0 |
| 2024-11-11 12:00:00 | ES | Futures | 6268.27 | 6269.57 | 6255.55 | 6255.55 | 86287.0 |
| 2024-11-11 13:00:00 | ES | Futures | 6255.55 | 6259.96 | 6242.58 | 6255.81 | 130707.0 |
| 2024-11-11 14:00:00 | ES | Futures | 6255.81 | 6258.15 | 6253.48 | 6256.85 | 55266.0 |
| 2024-11-11 15:00:00 | ES | Futures | 6256.85 | 6263.34 | 6252.96 | 6262.04 | 151330.0 |
| 2024-11-11 16:00:00 | ES | Futures | 6261.78 | 6262.82 | 6255.55 | 6258.15 | 63598.0 |
| 2024-11-11 18:00:00 | ES | Futures | 6258.93 | 6259.19 | 6254.51 | 6257.37 | 4891.0 |
| 2024-11-11 19:00:00 | ES | Futures | 6257.63 | 6258.67 | 6252.18 | 6255.55 | 7044.0 |
| 2024-11-11 20:00:00 | ES | Futures | 6255.29 | 6262.3 | 6254.77 | 6257.89 | 7888.0 |
| 2024-11-11 21:00:00 | ES | Futures | 6257.89 | 6260.48 | 6251.4 | 6253.74 | 10813.0 |
| 2024-11-11 22:00:00 | ES | Futures | 6253.74 | 6257.11 | 6253.22 | 6253.74 | 4601.0 |
| 2024-11-11 23:00:00 | ES | Futures | 6253.74 | 6256.85 | 6252.96 | 6256.59 | 3794.0 |
| 2024-11-11 00:00:00 | NQ | Futures | 22216.68 | 22229.73 | 22215.64 | 22217.99 | 2919.0 |
| 2024-11-11 01:00:00 | NQ | Futures | 22218.25 | 22223.21 | 22211.99 | 22217.21 | 1966.0 |
| 2024-11-11 02:00:00 | NQ | Futures | 22216.42 | 22229.47 | 22206.51 | 22227.64 | 3066.0 |
| 2024-11-11 03:00:00 | NQ | Futures | 22227.64 | 22254.26 | 22212.51 | 22221.9 | 6809.0 |
| 2024-11-11 04:00:00 | NQ | Futures | 22221.12 | 22237.3 | 22205.73 | 22221.64 | 6446.0 |
| 2024-11-11 05:00:00 | NQ | Futures | 22221.38 | 22233.12 | 22200.25 | 22200.77 | 4882.0 |
| 2024-11-11 06:00:00 | NQ | Futures | 22200.77 | 22220.34 | 22196.33 | 22214.34 | 5027.0 |
| 2024-11-11 07:00:00 | NQ | Futures | 22215.38 | 22266.78 | 22214.34 | 22257.91 | 8850.0 |
| 2024-11-11 08:00:00 | NQ | Futures | 22258.43 | 22272.26 | 22216.68 | 22230.25 | 13092.0 |
| 2024-11-11 09:00:00 | NQ | Futures | 22230.77 | 22237.3 | 22086.75 | 22096.66 | 75636.0 |
| 2024-11-11 10:00:00 | NQ | Futures | 22096.14 | 22171.55 | 22078.66 | 22149.63 | 74674.0 |
| 2024-11-11 11:00:00 | NQ | Futures | 22149.63 | 22159.28 | 22115.45 | 22128.5 | 38458.0 |
| 2024-11-11 12:00:00 | NQ | Futures | 22128.76 | 22138.93 | 22080.49 | 22081.53 | 37479.0 |
| 2024-11-11 13:00:00 | NQ | Futures | 22081.27 | 22123.02 | 22019.17 | 22104.23 | 57501.0 |
| 2024-11-11 14:00:00 | NQ | Futures | 22104.49 | 22107.62 | 22079.71 | 22099.8 | 25903.0 |
| 2024-11-11 15:00:00 | NQ | Futures | 22099.53 | 22149.89 | 22093.53 | 22146.5 | 47660.0 |
| 2024-11-11 16:00:00 | NQ | Futures | 22146.5 | 22160.33 | 22130.58 | 22136.06 | 15167.0 |
| 2024-11-11 18:00:00 | NQ | Futures | 22147.28 | 22147.28 | 22126.67 | 22142.58 | 2673.0 |
| 2024-11-11 19:00:00 | NQ | Futures | 22141.28 | 22148.59 | 22122.76 | 22139.45 | 3853.0 |
| 2024-11-11 20:00:00 | NQ | Futures | 22138.93 | 22177.03 | 22136.32 | 22157.46 | 4978.0 |
| 2024-11-11 21:00:00 | NQ | Futures | 22156.67 | 22168.94 | 22115.71 | 22131.63 | 5540.0 |
| 2024-11-11 22:00:00 | NQ | Futures | 22132.41 | 22151.46 | 22129.28 | 22134.24 | 3558.0 |
| 2024-11-11 23:00:00 | NQ | Futures | 22134.24 | 22150.93 | 22126.67 | 22149.11 | 2671.0 |
| 2024-11-11 00:00:00 | YM | Futures | 45971.1 | 45983.6 | 45967.9 | 45971.1 | 589.0 |
| 2024-11-11 01:00:00 | YM | Futures | 45972.1 | 46002.3 | 45967.9 | 45998.1 | 854.0 |
| 2024-11-11 02:00:00 | YM | Futures | 45997.1 | 46025.2 | 45990.8 | 46025.2 | 1208.0 |
| 2024-11-11 03:00:00 | YM | Futures | 46023.1 | 46055.4 | 46012.7 | 46046.0 | 2033.0 |
> showing 50 of 2,085 rows — these rows as CSV