PREVIEW / futures_1hour / 2024-11-27
file: by_date/futures_1hour/2024/2024-11-27.parquet size: 66 KB rows: 2,062
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-27 00:00:00 | ES | Futures | 6266.71 | 6268.27 | 6264.12 | 6265.67 | 3915.0 |
| 2024-11-27 01:00:00 | ES | Futures | 6265.93 | 6269.31 | 6265.15 | 6266.71 | 4311.0 |
| 2024-11-27 02:00:00 | ES | Futures | 6266.71 | 6271.64 | 6265.67 | 6267.49 | 7606.0 |
| 2024-11-27 03:00:00 | ES | Futures | 6267.49 | 6268.27 | 6256.33 | 6259.19 | 22181.0 |
| 2024-11-27 04:00:00 | ES | Futures | 6259.19 | 6262.82 | 6253.99 | 6257.63 | 14101.0 |
| 2024-11-27 05:00:00 | ES | Futures | 6257.89 | 6261.52 | 6255.29 | 6260.22 | 9374.0 |
| 2024-11-27 06:00:00 | ES | Futures | 6260.22 | 6261.26 | 6253.74 | 6260.22 | 10034.0 |
| 2024-11-27 07:00:00 | ES | Futures | 6260.22 | 6263.6 | 6257.11 | 6261.78 | 11125.0 |
| 2024-11-27 08:00:00 | ES | Futures | 6261.78 | 6268.27 | 6260.74 | 6265.93 | 23030.0 |
| 2024-11-27 09:00:00 | ES | Futures | 6265.93 | 6266.97 | 6257.37 | 6262.3 | 124156.0 |
| 2024-11-27 10:00:00 | ES | Futures | 6261.78 | 6262.3 | 6242.84 | 6245.95 | 209827.0 |
| 2024-11-27 11:00:00 | ES | Futures | 6246.47 | 6249.06 | 6237.13 | 6238.68 | 150714.0 |
| 2024-11-27 12:00:00 | ES | Futures | 6238.68 | 6241.28 | 6228.82 | 6240.76 | 110068.0 |
| 2024-11-27 13:00:00 | ES | Futures | 6240.5 | 6248.29 | 6238.42 | 6246.21 | 83262.0 |
| 2024-11-27 14:00:00 | ES | Futures | 6246.47 | 6248.29 | 6241.02 | 6244.13 | 67958.0 |
| 2024-11-27 15:00:00 | ES | Futures | 6244.13 | 6247.25 | 6236.09 | 6244.91 | 160329.0 |
| 2024-11-27 16:00:00 | ES | Futures | 6245.17 | 6246.47 | 6242.84 | 6244.65 | 36764.0 |
| 2024-11-27 18:00:00 | ES | Futures | 6244.13 | 6250.88 | 6243.87 | 6249.32 | 3866.0 |
| 2024-11-27 19:00:00 | ES | Futures | 6249.32 | 6252.18 | 6249.32 | 6251.4 | 3636.0 |
| 2024-11-27 20:00:00 | ES | Futures | 6251.14 | 6252.7 | 6250.1 | 6251.14 | 5142.0 |
| 2024-11-27 21:00:00 | ES | Futures | 6251.14 | 6252.96 | 6250.62 | 6252.44 | 2726.0 |
| 2024-11-27 22:00:00 | ES | Futures | 6252.18 | 6252.96 | 6251.4 | 6252.44 | 2105.0 |
| 2024-11-27 23:00:00 | ES | Futures | 6252.44 | 6253.48 | 6251.14 | 6251.66 | 3272.0 |
| 2024-11-27 00:00:00 | NQ | Futures | 21881.93 | 21886.89 | 21866.8 | 21873.32 | 2471.0 |
| 2024-11-27 01:00:00 | NQ | Futures | 21874.37 | 21893.67 | 21872.28 | 21884.8 | 2430.0 |
| 2024-11-27 02:00:00 | NQ | Futures | 21885.59 | 21906.2 | 21878.54 | 21894.2 | 4090.0 |
| 2024-11-27 03:00:00 | NQ | Futures | 21893.94 | 21897.33 | 21835.49 | 21850.89 | 12990.0 |
| 2024-11-27 04:00:00 | NQ | Futures | 21851.15 | 21867.84 | 21816.71 | 21834.97 | 9433.0 |
| 2024-11-27 05:00:00 | NQ | Futures | 21834.45 | 21852.97 | 21822.45 | 21848.8 | 4884.0 |
| 2024-11-27 06:00:00 | NQ | Futures | 21848.8 | 21852.71 | 21817.75 | 21844.1 | 4854.0 |
| 2024-11-27 07:00:00 | NQ | Futures | 21844.1 | 21865.5 | 21829.49 | 21857.93 | 7102.0 |
| 2024-11-27 08:00:00 | NQ | Futures | 21857.93 | 21886.11 | 21855.06 | 21868.11 | 13141.0 |
| 2024-11-27 09:00:00 | NQ | Futures | 21868.37 | 21870.19 | 21748.61 | 21771.05 | 66770.0 |
| 2024-11-27 10:00:00 | NQ | Futures | 21771.05 | 21772.09 | 21630.68 | 21648.94 | 101321.0 |
| 2024-11-27 11:00:00 | NQ | Futures | 21648.94 | 21668.25 | 21598.06 | 21620.76 | 69401.0 |
| 2024-11-27 12:00:00 | NQ | Futures | 21620.24 | 21651.55 | 21577.45 | 21648.42 | 45230.0 |
| 2024-11-27 13:00:00 | NQ | Futures | 21647.9 | 21727.21 | 21640.59 | 21718.6 | 45615.0 |
| 2024-11-27 14:00:00 | NQ | Futures | 21718.86 | 21735.3 | 21697.73 | 21712.08 | 35797.0 |
| 2024-11-27 15:00:00 | NQ | Futures | 21712.34 | 21738.95 | 21675.81 | 21724.86 | 55926.0 |
| 2024-11-27 16:00:00 | NQ | Futures | 21725.13 | 21735.56 | 21705.56 | 21714.69 | 13058.0 |
| 2024-11-27 18:00:00 | NQ | Futures | 21721.47 | 21743.91 | 21715.47 | 21732.43 | 1634.0 |
| 2024-11-27 19:00:00 | NQ | Futures | 21734.78 | 21762.44 | 21732.69 | 21755.13 | 2168.0 |
| 2024-11-27 20:00:00 | NQ | Futures | 21755.13 | 21765.04 | 21742.61 | 21746.0 | 2626.0 |
| 2024-11-27 21:00:00 | NQ | Futures | 21746.78 | 21761.65 | 21744.43 | 21758.78 | 1299.0 |
| 2024-11-27 22:00:00 | NQ | Futures | 21758.52 | 21768.44 | 21751.48 | 21762.96 | 1363.0 |
| 2024-11-27 23:00:00 | NQ | Futures | 21764.26 | 21772.35 | 21760.35 | 21765.31 | 1264.0 |
| 2024-11-27 00:00:00 | YM | Futures | 46808.9 | 46818.2 | 46793.3 | 46795.3 | 511.0 |
| 2024-11-27 01:00:00 | YM | Futures | 46797.4 | 46821.4 | 46796.4 | 46805.8 | 789.0 |
| 2024-11-27 02:00:00 | YM | Futures | 46806.8 | 46838.0 | 46790.1 | 46792.2 | 1437.0 |
| 2024-11-27 03:00:00 | YM | Futures | 46793.3 | 46801.6 | 46737.1 | 46762.0 | 3442.0 |
> showing 50 of 2,062 rows — these rows as CSV