PREVIEW / futures_1hour / 2024-07-10
file: by_date/futures_1hour/2024/2024-07-10.parquet size: 64 KB rows: 2,053
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-07-10 00:00:00 | ES | Futures | 5908.39 | 5909.7 | 5907.34 | 5909.44 | 1938.0 |
| 2024-07-10 01:00:00 | ES | Futures | 5909.44 | 5909.96 | 5904.72 | 5904.72 | 5265.0 |
| 2024-07-10 02:00:00 | ES | Futures | 5904.72 | 5908.91 | 5904.72 | 5906.82 | 7760.0 |
| 2024-07-10 03:00:00 | ES | Futures | 5907.08 | 5910.22 | 5906.55 | 5909.18 | 10269.0 |
| 2024-07-10 04:00:00 | ES | Futures | 5909.44 | 5912.85 | 5908.65 | 5912.85 | 9669.0 |
| 2024-07-10 05:00:00 | ES | Futures | 5912.85 | 5914.16 | 5911.8 | 5913.89 | 8054.0 |
| 2024-07-10 06:00:00 | ES | Futures | 5913.63 | 5915.21 | 5912.85 | 5913.89 | 8192.0 |
| 2024-07-10 07:00:00 | ES | Futures | 5913.89 | 5919.92 | 5912.85 | 5918.88 | 13604.0 |
| 2024-07-10 08:00:00 | ES | Futures | 5918.88 | 5921.23 | 5918.09 | 5918.35 | 20520.0 |
| 2024-07-10 09:00:00 | ES | Futures | 5918.35 | 5921.23 | 5914.94 | 5920.45 | 114170.0 |
| 2024-07-10 10:00:00 | ES | Futures | 5920.45 | 5925.17 | 5915.99 | 5917.56 | 139230.0 |
| 2024-07-10 11:00:00 | ES | Futures | 5917.3 | 5927.79 | 5914.68 | 5926.48 | 114048.0 |
| 2024-07-10 12:00:00 | ES | Futures | 5926.48 | 5942.21 | 5925.95 | 5941.95 | 123604.0 |
| 2024-07-10 13:00:00 | ES | Futures | 5941.95 | 5947.71 | 5939.59 | 5946.93 | 90923.0 |
| 2024-07-10 14:00:00 | ES | Futures | 5947.19 | 5951.91 | 5942.99 | 5950.34 | 83484.0 |
| 2024-07-10 15:00:00 | ES | Futures | 5950.07 | 5967.38 | 5946.66 | 5962.92 | 256366.0 |
| 2024-07-10 16:00:00 | ES | Futures | 5962.66 | 5963.71 | 5959.51 | 5961.08 | 85045.0 |
| 2024-07-10 18:00:00 | ES | Futures | 5960.82 | 5962.66 | 5959.25 | 5961.08 | 5045.0 |
| 2024-07-10 19:00:00 | ES | Futures | 5960.82 | 5961.35 | 5959.25 | 5960.04 | 2441.0 |
| 2024-07-10 20:00:00 | ES | Futures | 5960.04 | 5960.3 | 5956.36 | 5956.89 | 6814.0 |
| 2024-07-10 21:00:00 | ES | Futures | 5956.89 | 5960.82 | 5955.32 | 5960.04 | 4942.0 |
| 2024-07-10 22:00:00 | ES | Futures | 5960.3 | 5961.08 | 5958.99 | 5959.25 | 2466.0 |
| 2024-07-10 23:00:00 | ES | Futures | 5959.25 | 5961.87 | 5958.2 | 5961.61 | 2939.0 |
| 2024-07-10 00:00:00 | NQ | Futures | 21867.78 | 21875.97 | 21861.71 | 21874.38 | 1481.0 |
| 2024-07-10 01:00:00 | NQ | Futures | 21874.12 | 21875.7 | 21853.79 | 21855.11 | 2626.0 |
| 2024-07-10 02:00:00 | NQ | Futures | 21854.58 | 21873.85 | 21854.58 | 21858.54 | 3329.0 |
| 2024-07-10 03:00:00 | NQ | Futures | 21859.07 | 21878.87 | 21855.38 | 21871.48 | 4651.0 |
| 2024-07-10 04:00:00 | NQ | Futures | 21870.69 | 21891.01 | 21869.37 | 21890.75 | 5537.0 |
| 2024-07-10 05:00:00 | NQ | Futures | 21890.48 | 21891.54 | 21880.19 | 21886.79 | 3915.0 |
| 2024-07-10 06:00:00 | NQ | Futures | 21887.05 | 21902.1 | 21884.15 | 21896.82 | 4693.0 |
| 2024-07-10 07:00:00 | NQ | Futures | 21896.56 | 21921.11 | 21889.69 | 21910.55 | 6418.0 |
| 2024-07-10 08:00:00 | NQ | Futures | 21910.02 | 21928.76 | 21908.7 | 21914.77 | 12828.0 |
| 2024-07-10 09:00:00 | NQ | Futures | 21915.3 | 21939.85 | 21880.45 | 21925.59 | 86939.0 |
| 2024-07-10 10:00:00 | NQ | Futures | 21925.33 | 21959.65 | 21882.83 | 21888.9 | 100052.0 |
| 2024-07-10 11:00:00 | NQ | Futures | 21888.9 | 21931.14 | 21860.92 | 21928.76 | 63437.0 |
| 2024-07-10 12:00:00 | NQ | Futures | 21928.5 | 22016.14 | 21921.37 | 22013.5 | 68001.0 |
| 2024-07-10 13:00:00 | NQ | Futures | 22013.5 | 22048.35 | 22006.11 | 22041.48 | 51155.0 |
| 2024-07-10 14:00:00 | NQ | Futures | 22042.01 | 22063.92 | 22027.76 | 22047.55 | 36335.0 |
| 2024-07-10 15:00:00 | NQ | Futures | 22047.29 | 22086.62 | 22019.31 | 22062.34 | 79896.0 |
| 2024-07-10 16:00:00 | NQ | Futures | 22062.6 | 22066.03 | 22045.71 | 22065.24 | 18260.0 |
| 2024-07-10 18:00:00 | NQ | Futures | 22064.19 | 22067.88 | 22048.35 | 22058.11 | 3203.0 |
| 2024-07-10 19:00:00 | NQ | Futures | 22057.59 | 22058.11 | 22044.65 | 22049.14 | 2339.0 |
| 2024-07-10 20:00:00 | NQ | Futures | 22049.14 | 22052.57 | 22025.64 | 22029.34 | 3735.0 |
| 2024-07-10 21:00:00 | NQ | Futures | 22029.08 | 22045.71 | 22019.57 | 22044.91 | 4585.0 |
| 2024-07-10 22:00:00 | NQ | Futures | 22044.65 | 22048.87 | 22038.58 | 22041.22 | 2192.0 |
| 2024-07-10 23:00:00 | NQ | Futures | 22040.96 | 22052.04 | 22037.0 | 22051.78 | 2101.0 |
| 2024-07-10 00:00:00 | YM | Futures | 41589.9 | 41597.3 | 41582.6 | 41596.2 | 415.0 |
| 2024-07-10 01:00:00 | YM | Futures | 41595.2 | 41598.3 | 41565.7 | 41565.7 | 759.0 |
| 2024-07-10 02:00:00 | YM | Futures | 41564.7 | 41600.4 | 41564.7 | 41588.9 | 1200.0 |
| 2024-07-10 03:00:00 | YM | Futures | 41591.0 | 41599.4 | 41566.8 | 41589.9 | 1762.0 |
> showing 50 of 2,053 rows — these rows as CSV