PREVIEW / futures_1hour / 2024-11-26
file: by_date/futures_1hour/2024/2024-11-26.parquet size: 67 KB rows: 2,123
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-26 00:00:00 | ES | Futures | 6237.39 | 6238.68 | 6230.9 | 6232.45 | 5979.0 |
| 2024-11-26 01:00:00 | ES | Futures | 6232.71 | 6241.02 | 6232.45 | 6236.87 | 5871.0 |
| 2024-11-26 02:00:00 | ES | Futures | 6236.61 | 6238.16 | 6229.34 | 6229.86 | 10000.0 |
| 2024-11-26 03:00:00 | ES | Futures | 6229.6 | 6233.75 | 6225.45 | 6229.08 | 20128.0 |
| 2024-11-26 04:00:00 | ES | Futures | 6229.34 | 6236.09 | 6228.3 | 6234.79 | 11789.0 |
| 2024-11-26 05:00:00 | ES | Futures | 6235.05 | 6239.46 | 6230.12 | 6238.94 | 11283.0 |
| 2024-11-26 06:00:00 | ES | Futures | 6238.94 | 6251.4 | 6235.57 | 6249.32 | 15185.0 |
| 2024-11-26 07:00:00 | ES | Futures | 6249.32 | 6252.18 | 6246.47 | 6251.4 | 24447.0 |
| 2024-11-26 08:00:00 | ES | Futures | 6251.14 | 6252.7 | 6246.47 | 6249.06 | 30682.0 |
| 2024-11-26 09:00:00 | ES | Futures | 6249.32 | 6256.59 | 6244.65 | 6250.36 | 171971.0 |
| 2024-11-26 10:00:00 | ES | Futures | 6249.58 | 6255.29 | 6240.24 | 6250.62 | 197729.0 |
| 2024-11-26 11:00:00 | ES | Futures | 6250.36 | 6259.19 | 6248.54 | 6257.89 | 117206.0 |
| 2024-11-26 12:00:00 | ES | Futures | 6257.89 | 6261.78 | 6250.62 | 6261.26 | 79527.0 |
| 2024-11-26 13:00:00 | ES | Futures | 6261.26 | 6262.56 | 6256.33 | 6262.04 | 61415.0 |
| 2024-11-26 14:00:00 | ES | Futures | 6262.04 | 6264.64 | 6252.44 | 6260.48 | 107971.0 |
| 2024-11-26 15:00:00 | ES | Futures | 6260.48 | 6274.24 | 6259.7 | 6266.97 | 202999.0 |
| 2024-11-26 16:00:00 | ES | Futures | 6266.97 | 6273.72 | 6266.71 | 6271.64 | 79131.0 |
| 2024-11-26 18:00:00 | ES | Futures | 6271.9 | 6273.46 | 6266.45 | 6270.6 | 7730.0 |
| 2024-11-26 19:00:00 | ES | Futures | 6270.6 | 6271.38 | 6266.71 | 6270.34 | 5851.0 |
| 2024-11-26 20:00:00 | ES | Futures | 6270.09 | 6272.68 | 6269.57 | 6272.42 | 4547.0 |
| 2024-11-26 21:00:00 | ES | Futures | 6272.42 | 6277.35 | 6271.64 | 6273.98 | 7667.0 |
| 2024-11-26 22:00:00 | ES | Futures | 6273.98 | 6274.24 | 6268.53 | 6270.34 | 5419.0 |
| 2024-11-26 23:00:00 | ES | Futures | 6270.34 | 6270.34 | 6264.12 | 6266.45 | 4848.0 |
| 2024-11-26 00:00:00 | NQ | Futures | 21813.31 | 21821.92 | 21781.22 | 21793.75 | 3649.0 |
| 2024-11-26 01:00:00 | NQ | Futures | 21794.01 | 21837.58 | 21793.22 | 21819.58 | 3527.0 |
| 2024-11-26 02:00:00 | NQ | Futures | 21819.05 | 21822.45 | 21786.18 | 21788.79 | 5113.0 |
| 2024-11-26 03:00:00 | NQ | Futures | 21788.79 | 21806.01 | 21762.17 | 21780.44 | 9272.0 |
| 2024-11-26 04:00:00 | NQ | Futures | 21780.96 | 21809.14 | 21774.44 | 21797.92 | 6874.0 |
| 2024-11-26 05:00:00 | NQ | Futures | 21797.92 | 21818.27 | 21772.09 | 21805.75 | 6118.0 |
| 2024-11-26 06:00:00 | NQ | Futures | 21806.53 | 21860.8 | 21791.66 | 21852.97 | 7726.0 |
| 2024-11-26 07:00:00 | NQ | Futures | 21852.71 | 21869.67 | 21839.93 | 21861.06 | 11814.0 |
| 2024-11-26 08:00:00 | NQ | Futures | 21861.06 | 21869.15 | 21832.88 | 21856.63 | 12241.0 |
| 2024-11-26 09:00:00 | NQ | Futures | 21857.41 | 21942.47 | 21837.84 | 21889.24 | 76473.0 |
| 2024-11-26 10:00:00 | NQ | Futures | 21889.24 | 21913.5 | 21832.62 | 21864.71 | 80964.0 |
| 2024-11-26 11:00:00 | NQ | Futures | 21864.45 | 21899.68 | 21836.8 | 21880.37 | 54027.0 |
| 2024-11-26 12:00:00 | NQ | Futures | 21880.37 | 21900.2 | 21840.19 | 21897.07 | 34499.0 |
| 2024-11-26 13:00:00 | NQ | Futures | 21896.81 | 21897.07 | 21857.93 | 21884.28 | 26130.0 |
| 2024-11-26 14:00:00 | NQ | Futures | 21883.76 | 21897.33 | 21816.18 | 21846.19 | 46579.0 |
| 2024-11-26 15:00:00 | NQ | Futures | 21845.67 | 21925.77 | 21840.45 | 21905.94 | 54404.0 |
| 2024-11-26 16:00:00 | NQ | Futures | 21905.94 | 21925.25 | 21904.37 | 21915.33 | 12372.0 |
| 2024-11-26 18:00:00 | NQ | Futures | 21906.98 | 21915.33 | 21882.98 | 21901.76 | 3475.0 |
| 2024-11-26 19:00:00 | NQ | Futures | 21902.81 | 21905.94 | 21887.15 | 21901.76 | 2917.0 |
| 2024-11-26 20:00:00 | NQ | Futures | 21902.55 | 21914.29 | 21898.63 | 21911.16 | 2127.0 |
| 2024-11-26 21:00:00 | NQ | Futures | 21911.68 | 21936.46 | 21907.76 | 21922.11 | 3928.0 |
| 2024-11-26 22:00:00 | NQ | Futures | 21922.9 | 21923.68 | 21893.41 | 21899.94 | 3162.0 |
| 2024-11-26 23:00:00 | NQ | Futures | 21899.41 | 21901.24 | 21872.8 | 21881.41 | 2661.0 |
| 2024-11-26 00:00:00 | YM | Futures | 46660.0 | 46670.5 | 46636.1 | 46646.5 | 619.0 |
| 2024-11-26 01:00:00 | YM | Futures | 46646.5 | 46688.1 | 46643.4 | 46665.3 | 694.0 |
| 2024-11-26 02:00:00 | YM | Futures | 46664.2 | 46688.1 | 46624.7 | 46627.8 | 1237.0 |
| 2024-11-26 03:00:00 | YM | Futures | 46626.7 | 46647.6 | 46603.8 | 46626.7 | 2123.0 |
> showing 50 of 2,123 rows — these rows as CSV