PREVIEW / futures_1hour / 2024-11-07
file: by_date/futures_1hour/2024/2024-11-07.parquet size: 70 KB rows: 2,131
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-07 00:00:00 | ES | Futures | 6193.79 | 6197.94 | 6192.23 | 6197.16 | 6036.0 |
| 2024-11-07 01:00:00 | ES | Futures | 6197.16 | 6199.24 | 6193.79 | 6194.56 | 5085.0 |
| 2024-11-07 02:00:00 | ES | Futures | 6194.56 | 6195.6 | 6186.26 | 6188.6 | 9047.0 |
| 2024-11-07 03:00:00 | ES | Futures | 6188.6 | 6200.53 | 6188.08 | 6195.08 | 20847.0 |
| 2024-11-07 04:00:00 | ES | Futures | 6195.08 | 6200.53 | 6191.71 | 6194.82 | 15021.0 |
| 2024-11-07 05:00:00 | ES | Futures | 6195.08 | 6198.98 | 6194.56 | 6198.46 | 12209.0 |
| 2024-11-07 06:00:00 | ES | Futures | 6198.72 | 6198.72 | 6191.97 | 6198.46 | 11470.0 |
| 2024-11-07 07:00:00 | ES | Futures | 6197.94 | 6202.87 | 6195.86 | 6200.79 | 18875.0 |
| 2024-11-07 08:00:00 | ES | Futures | 6200.79 | 6204.69 | 6194.3 | 6200.79 | 34538.0 |
| 2024-11-07 09:00:00 | ES | Futures | 6200.79 | 6214.81 | 6198.46 | 6213.77 | 146417.0 |
| 2024-11-07 10:00:00 | ES | Futures | 6214.03 | 6224.67 | 6211.95 | 6222.85 | 154955.0 |
| 2024-11-07 11:00:00 | ES | Futures | 6222.85 | 6227.78 | 6215.33 | 6226.23 | 106249.0 |
| 2024-11-07 12:00:00 | ES | Futures | 6226.49 | 6230.64 | 6222.33 | 6229.08 | 74374.0 |
| 2024-11-07 13:00:00 | ES | Futures | 6229.08 | 6229.6 | 6216.1 | 6222.33 | 84360.0 |
| 2024-11-07 14:00:00 | ES | Futures | 6222.33 | 6235.57 | 6213.51 | 6235.57 | 155322.0 |
| 2024-11-07 15:00:00 | ES | Futures | 6235.57 | 6242.06 | 6227.0 | 6231.16 | 239336.0 |
| 2024-11-07 16:00:00 | ES | Futures | 6230.9 | 6238.42 | 6229.86 | 6235.31 | 70366.0 |
| 2024-11-07 18:00:00 | ES | Futures | 6236.61 | 6237.9 | 6230.64 | 6236.09 | 5622.0 |
| 2024-11-07 19:00:00 | ES | Futures | 6236.09 | 6237.9 | 6231.94 | 6232.45 | 4772.0 |
| 2024-11-07 20:00:00 | ES | Futures | 6232.71 | 6234.53 | 6230.64 | 6234.27 | 5723.0 |
| 2024-11-07 21:00:00 | ES | Futures | 6234.01 | 6235.83 | 6229.86 | 6230.12 | 5302.0 |
| 2024-11-07 22:00:00 | ES | Futures | 6230.12 | 6232.97 | 6230.12 | 6231.68 | 3559.0 |
| 2024-11-07 23:00:00 | ES | Futures | 6231.42 | 6234.01 | 6230.64 | 6231.68 | 3210.0 |
| 2024-11-07 00:00:00 | NQ | Futures | 21835.23 | 21868.63 | 21829.23 | 21863.41 | 4311.0 |
| 2024-11-07 01:00:00 | NQ | Futures | 21863.41 | 21881.41 | 21856.89 | 21864.71 | 3619.0 |
| 2024-11-07 02:00:00 | NQ | Futures | 21863.93 | 21866.54 | 21820.88 | 21836.8 | 4983.0 |
| 2024-11-07 03:00:00 | NQ | Futures | 21836.53 | 21875.93 | 21828.97 | 21849.06 | 7353.0 |
| 2024-11-07 04:00:00 | NQ | Futures | 21848.28 | 21873.32 | 21827.92 | 21854.28 | 5649.0 |
| 2024-11-07 05:00:00 | NQ | Futures | 21855.32 | 21866.54 | 21846.19 | 21859.5 | 3332.0 |
| 2024-11-07 06:00:00 | NQ | Futures | 21859.23 | 21860.54 | 21837.32 | 21858.45 | 3939.0 |
| 2024-11-07 07:00:00 | NQ | Futures | 21857.41 | 21893.15 | 21855.06 | 21882.72 | 8118.0 |
| 2024-11-07 08:00:00 | NQ | Futures | 21882.19 | 21915.85 | 21873.06 | 21902.55 | 16144.0 |
| 2024-11-07 09:00:00 | NQ | Futures | 21901.5 | 22031.96 | 21898.63 | 22030.13 | 69370.0 |
| 2024-11-07 10:00:00 | NQ | Futures | 22030.39 | 22091.19 | 22006.91 | 22084.66 | 68932.0 |
| 2024-11-07 11:00:00 | NQ | Futures | 22084.4 | 22124.32 | 22046.31 | 22119.1 | 47191.0 |
| 2024-11-07 12:00:00 | NQ | Futures | 22119.62 | 22122.76 | 22082.31 | 22119.36 | 32378.0 |
| 2024-11-07 13:00:00 | NQ | Futures | 22119.89 | 22121.45 | 22074.49 | 22104.49 | 28963.0 |
| 2024-11-07 14:00:00 | NQ | Futures | 22104.49 | 22159.81 | 22082.84 | 22159.81 | 47273.0 |
| 2024-11-07 15:00:00 | NQ | Futures | 22159.81 | 22180.68 | 22130.06 | 22147.8 | 63967.0 |
| 2024-11-07 16:00:00 | NQ | Futures | 22147.8 | 22179.37 | 22134.76 | 22151.72 | 17161.0 |
| 2024-11-07 18:00:00 | NQ | Futures | 22150.67 | 22157.46 | 22127.97 | 22153.8 | 2902.0 |
| 2024-11-07 19:00:00 | NQ | Futures | 22153.54 | 22166.07 | 22146.5 | 22150.67 | 2986.0 |
| 2024-11-07 20:00:00 | NQ | Futures | 22150.93 | 22160.85 | 22141.54 | 22159.02 | 2892.0 |
| 2024-11-07 21:00:00 | NQ | Futures | 22158.5 | 22172.33 | 22144.67 | 22145.98 | 3364.0 |
| 2024-11-07 22:00:00 | NQ | Futures | 22145.98 | 22161.89 | 22145.19 | 22153.28 | 2231.0 |
| 2024-11-07 23:00:00 | NQ | Futures | 22152.76 | 22161.11 | 22148.59 | 22150.67 | 1487.0 |
| 2024-11-07 00:00:00 | YM | Futures | 45795.2 | 45810.8 | 45778.5 | 45795.2 | 837.0 |
| 2024-11-07 01:00:00 | YM | Futures | 45794.1 | 45800.4 | 45758.8 | 45759.8 | 808.0 |
| 2024-11-07 02:00:00 | YM | Futures | 45758.8 | 45780.6 | 45716.1 | 45736.9 | 1778.0 |
| 2024-11-07 03:00:00 | YM | Futures | 45739.0 | 45803.5 | 45732.7 | 45776.4 | 1863.0 |
> showing 50 of 2,131 rows — these rows as CSV