PREVIEW / futures_1hour / 2024-12-02
file: by_date/futures_1hour/2024/2024-12-02.parquet size: 68 KB rows: 2,116
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-12-02 00:00:00 | ES | Futures | 6270.34 | 6272.16 | 6268.79 | 6269.05 | 4521.0 |
| 2024-12-02 01:00:00 | ES | Futures | 6269.05 | 6269.57 | 6265.93 | 6269.57 | 5364.0 |
| 2024-12-02 02:00:00 | ES | Futures | 6269.57 | 6270.34 | 6267.23 | 6269.83 | 6431.0 |
| 2024-12-02 03:00:00 | ES | Futures | 6269.83 | 6272.16 | 6268.53 | 6271.9 | 10261.0 |
| 2024-12-02 04:00:00 | ES | Futures | 6272.16 | 6272.68 | 6268.79 | 6269.83 | 8444.0 |
| 2024-12-02 05:00:00 | ES | Futures | 6270.09 | 6272.16 | 6267.49 | 6270.34 | 9243.0 |
| 2024-12-02 06:00:00 | ES | Futures | 6270.6 | 6274.5 | 6270.09 | 6274.24 | 10664.0 |
| 2024-12-02 07:00:00 | ES | Futures | 6274.5 | 6282.02 | 6273.72 | 6279.69 | 16856.0 |
| 2024-12-02 08:00:00 | ES | Futures | 6279.69 | 6283.58 | 6278.39 | 6282.28 | 21961.0 |
| 2024-12-02 09:00:00 | ES | Futures | 6282.28 | 6292.92 | 6280.21 | 6284.62 | 142369.0 |
| 2024-12-02 10:00:00 | ES | Futures | 6284.62 | 6292.14 | 6280.47 | 6283.06 | 144806.0 |
| 2024-12-02 11:00:00 | ES | Futures | 6282.8 | 6295.0 | 6280.73 | 6292.66 | 92770.0 |
| 2024-12-02 12:00:00 | ES | Futures | 6292.92 | 6296.04 | 6289.81 | 6291.89 | 61291.0 |
| 2024-12-02 13:00:00 | ES | Futures | 6291.89 | 6295.0 | 6289.81 | 6293.96 | 51430.0 |
| 2024-12-02 14:00:00 | ES | Futures | 6293.96 | 6296.04 | 6286.69 | 6295.52 | 64163.0 |
| 2024-12-02 15:00:00 | ES | Futures | 6295.52 | 6299.67 | 6290.59 | 6292.92 | 181071.0 |
| 2024-12-02 16:00:00 | ES | Futures | 6292.92 | 6298.89 | 6292.14 | 6293.96 | 54912.0 |
| 2024-12-02 18:00:00 | ES | Futures | 6295.0 | 6297.34 | 6291.37 | 6294.48 | 5699.0 |
| 2024-12-02 19:00:00 | ES | Futures | 6294.48 | 6295.52 | 6291.89 | 6292.92 | 4933.0 |
| 2024-12-02 20:00:00 | ES | Futures | 6292.66 | 6294.22 | 6291.37 | 6291.63 | 6070.0 |
| 2024-12-02 21:00:00 | ES | Futures | 6291.63 | 6293.44 | 6290.85 | 6292.92 | 3180.0 |
| 2024-12-02 22:00:00 | ES | Futures | 6292.66 | 6298.11 | 6292.66 | 6296.82 | 4281.0 |
| 2024-12-02 23:00:00 | ES | Futures | 6296.82 | 6298.63 | 6295.78 | 6296.04 | 2987.0 |
| 2024-12-02 00:00:00 | NQ | Futures | 21872.28 | 21879.06 | 21861.32 | 21868.89 | 2304.0 |
| 2024-12-02 01:00:00 | NQ | Futures | 21868.89 | 21871.5 | 21854.02 | 21867.58 | 2546.0 |
| 2024-12-02 02:00:00 | NQ | Futures | 21867.84 | 21877.24 | 21861.32 | 21876.19 | 2465.0 |
| 2024-12-02 03:00:00 | NQ | Futures | 21876.72 | 21889.5 | 21866.54 | 21885.59 | 4239.0 |
| 2024-12-02 04:00:00 | NQ | Futures | 21885.85 | 21888.98 | 21864.45 | 21866.8 | 4289.0 |
| 2024-12-02 05:00:00 | NQ | Futures | 21867.06 | 21878.54 | 21854.02 | 21863.67 | 5123.0 |
| 2024-12-02 06:00:00 | NQ | Futures | 21864.19 | 21885.33 | 21861.84 | 21883.5 | 4109.0 |
| 2024-12-02 07:00:00 | NQ | Futures | 21883.76 | 21929.16 | 21880.63 | 21923.68 | 9061.0 |
| 2024-12-02 08:00:00 | NQ | Futures | 21923.42 | 21954.99 | 21915.59 | 21944.29 | 13399.0 |
| 2024-12-02 09:00:00 | NQ | Futures | 21944.55 | 22094.06 | 21941.94 | 22074.49 | 85320.0 |
| 2024-12-02 10:00:00 | NQ | Futures | 22075.53 | 22130.06 | 22063.79 | 22079.71 | 82187.0 |
| 2024-12-02 11:00:00 | NQ | Futures | 22079.71 | 22165.81 | 22075.79 | 22156.15 | 54247.0 |
| 2024-12-02 12:00:00 | NQ | Futures | 22156.15 | 22187.72 | 22151.72 | 22154.59 | 39192.0 |
| 2024-12-02 13:00:00 | NQ | Futures | 22154.33 | 22160.33 | 22119.62 | 22138.67 | 33402.0 |
| 2024-12-02 14:00:00 | NQ | Futures | 22138.41 | 22146.76 | 22100.58 | 22145.72 | 34186.0 |
| 2024-12-02 15:00:00 | NQ | Futures | 22145.72 | 22168.15 | 22127.71 | 22143.11 | 53852.0 |
| 2024-12-02 16:00:00 | NQ | Futures | 22142.85 | 22166.59 | 22133.71 | 22136.84 | 15132.0 |
| 2024-12-02 18:00:00 | NQ | Futures | 22146.24 | 22150.93 | 22129.28 | 22139.98 | 3105.0 |
| 2024-12-02 19:00:00 | NQ | Futures | 22141.28 | 22146.5 | 22129.8 | 22136.84 | 2359.0 |
| 2024-12-02 20:00:00 | NQ | Futures | 22136.32 | 22153.54 | 22128.76 | 22142.06 | 3249.0 |
| 2024-12-02 21:00:00 | NQ | Futures | 22142.06 | 22147.28 | 22135.8 | 22144.15 | 1757.0 |
| 2024-12-02 22:00:00 | NQ | Futures | 22144.15 | 22165.02 | 22144.15 | 22156.94 | 2666.0 |
| 2024-12-02 23:00:00 | NQ | Futures | 22157.72 | 22166.85 | 22150.93 | 22151.46 | 1773.0 |
| 2024-12-02 00:00:00 | YM | Futures | 46805.8 | 46823.4 | 46799.5 | 46799.5 | 406.0 |
| 2024-12-02 01:00:00 | YM | Futures | 46799.5 | 46807.8 | 46774.5 | 46805.8 | 619.0 |
| 2024-12-02 02:00:00 | YM | Futures | 46805.8 | 46812.0 | 46772.4 | 46783.9 | 1202.0 |
| 2024-12-02 03:00:00 | YM | Futures | 46786.0 | 46820.3 | 46775.6 | 46816.2 | 1255.0 |
> showing 50 of 2,116 rows — these rows as CSV