PREVIEW / futures_1hour / 2024-11-28
file: by_date/futures_1hour/2024/2024-11-28.parquet size: 53 KB rows: 1,652
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-28 00:00:00 | ES | Futures | 6251.4 | 6253.22 | 6250.88 | 6252.44 | 2466.0 |
| 2024-11-28 01:00:00 | ES | Futures | 6252.44 | 6252.96 | 6251.14 | 6251.66 | 2978.0 |
| 2024-11-28 02:00:00 | ES | Futures | 6251.66 | 6252.18 | 6249.06 | 6250.62 | 4048.0 |
| 2024-11-28 03:00:00 | ES | Futures | 6250.88 | 6251.66 | 6249.06 | 6251.4 | 6420.0 |
| 2024-11-28 04:00:00 | ES | Futures | 6251.4 | 6253.22 | 6250.88 | 6252.44 | 4463.0 |
| 2024-11-28 05:00:00 | ES | Futures | 6252.7 | 6253.22 | 6250.88 | 6252.7 | 3689.0 |
| 2024-11-28 06:00:00 | ES | Futures | 6252.96 | 6254.25 | 6250.88 | 6253.48 | 5020.0 |
| 2024-11-28 07:00:00 | ES | Futures | 6253.74 | 6254.51 | 6252.7 | 6254.25 | 5007.0 |
| 2024-11-28 08:00:00 | ES | Futures | 6254.25 | 6255.03 | 6252.7 | 6254.51 | 5453.0 |
| 2024-11-28 09:00:00 | ES | Futures | 6254.77 | 6258.41 | 6253.22 | 6257.89 | 13203.0 |
| 2024-11-28 10:00:00 | ES | Futures | 6257.63 | 6261.0 | 6257.37 | 6260.22 | 10483.0 |
| 2024-11-28 11:00:00 | ES | Futures | 6260.22 | 6262.3 | 6257.89 | 6258.41 | 10524.0 |
| 2024-11-28 12:00:00 | ES | Futures | 6258.41 | 6261.78 | 6258.15 | 6259.44 | 4975.0 |
| 2024-11-28 18:00:00 | ES | Futures | 6256.85 | 6260.48 | 6255.29 | 6259.44 | 3593.0 |
| 2024-11-28 19:00:00 | ES | Futures | 6259.7 | 6259.96 | 6247.25 | 6249.58 | 4944.0 |
| 2024-11-28 20:00:00 | ES | Futures | 6249.58 | 6258.93 | 6247.25 | 6258.67 | 6065.0 |
| 2024-11-28 21:00:00 | ES | Futures | 6258.67 | 6262.82 | 6258.41 | 6262.3 | 4946.0 |
| 2024-11-28 22:00:00 | ES | Futures | 6262.3 | 6263.86 | 6261.0 | 6262.82 | 4790.0 |
| 2024-11-28 23:00:00 | ES | Futures | 6263.08 | 6264.89 | 6262.56 | 6264.64 | 4712.0 |
| 2024-11-28 00:00:00 | NQ | Futures | 21765.31 | 21770.26 | 21760.35 | 21767.65 | 807.0 |
| 2024-11-28 01:00:00 | NQ | Futures | 21767.65 | 21774.96 | 21762.17 | 21773.65 | 1240.0 |
| 2024-11-28 02:00:00 | NQ | Futures | 21773.65 | 21780.96 | 21763.22 | 21772.61 | 2304.0 |
| 2024-11-28 03:00:00 | NQ | Futures | 21772.61 | 21778.09 | 21753.56 | 21764.26 | 3077.0 |
| 2024-11-28 04:00:00 | NQ | Futures | 21764.0 | 21771.05 | 21759.04 | 21767.39 | 1854.0 |
| 2024-11-28 05:00:00 | NQ | Futures | 21768.18 | 21771.83 | 21761.13 | 21768.96 | 1482.0 |
| 2024-11-28 06:00:00 | NQ | Futures | 21769.74 | 21774.44 | 21758.52 | 21772.09 | 2104.0 |
| 2024-11-28 07:00:00 | NQ | Futures | 21772.35 | 21786.7 | 21769.22 | 21783.83 | 2108.0 |
| 2024-11-28 08:00:00 | NQ | Futures | 21784.35 | 21789.31 | 21768.44 | 21782.0 | 2783.0 |
| 2024-11-28 09:00:00 | NQ | Futures | 21781.74 | 21808.88 | 21775.74 | 21800.27 | 8262.0 |
| 2024-11-28 10:00:00 | NQ | Futures | 21800.79 | 21818.01 | 21796.09 | 21810.18 | 8457.0 |
| 2024-11-28 11:00:00 | NQ | Futures | 21810.18 | 21822.18 | 21789.31 | 21793.48 | 6091.0 |
| 2024-11-28 12:00:00 | NQ | Futures | 21794.01 | 21813.84 | 21793.48 | 21801.83 | 3826.0 |
| 2024-11-28 18:00:00 | NQ | Futures | 21795.57 | 21804.18 | 21784.35 | 21799.49 | 1604.0 |
| 2024-11-28 19:00:00 | NQ | Futures | 21799.22 | 21801.57 | 21737.91 | 21748.35 | 3664.0 |
| 2024-11-28 20:00:00 | NQ | Futures | 21748.61 | 21788.27 | 21731.65 | 21787.22 | 4760.0 |
| 2024-11-28 21:00:00 | NQ | Futures | 21787.74 | 21813.84 | 21787.48 | 21812.27 | 3334.0 |
| 2024-11-28 22:00:00 | NQ | Futures | 21813.31 | 21832.1 | 21813.31 | 21826.36 | 3226.0 |
| 2024-11-28 23:00:00 | NQ | Futures | 21827.4 | 21851.67 | 21826.88 | 21845.41 | 3590.0 |
| 2024-11-28 00:00:00 | YM | Futures | 46713.1 | 46722.5 | 46706.9 | 46719.4 | 320.0 |
| 2024-11-28 01:00:00 | YM | Futures | 46718.3 | 46721.5 | 46701.7 | 46704.8 | 294.0 |
| 2024-11-28 02:00:00 | YM | Futures | 46703.8 | 46705.8 | 46646.5 | 46659.0 | 1729.0 |
| 2024-11-28 03:00:00 | YM | Futures | 46659.0 | 46710.0 | 46659.0 | 46696.5 | 2046.0 |
| 2024-11-28 04:00:00 | YM | Futures | 46694.4 | 46726.7 | 46692.3 | 46694.4 | 1065.0 |
| 2024-11-28 05:00:00 | YM | Futures | 46696.5 | 46698.6 | 46674.6 | 46696.5 | 1954.0 |
| 2024-11-28 06:00:00 | YM | Futures | 46697.5 | 46741.2 | 46692.3 | 46713.1 | 2133.0 |
| 2024-11-28 07:00:00 | YM | Futures | 46715.2 | 46717.3 | 46672.5 | 46709.0 | 1953.0 |
| 2024-11-28 08:00:00 | YM | Futures | 46709.0 | 46737.1 | 46707.9 | 46719.4 | 2240.0 |
| 2024-11-28 09:00:00 | YM | Futures | 46720.4 | 46749.6 | 46700.6 | 46733.9 | 3058.0 |
| 2024-11-28 10:00:00 | YM | Futures | 46732.9 | 46775.6 | 46718.3 | 46757.9 | 5374.0 |
| 2024-11-28 11:00:00 | YM | Futures | 46756.8 | 46776.6 | 46755.8 | 46773.5 | 1776.0 |
> showing 50 of 1,652 rows — these rows as CSV