PREVIEW / futures_1hour / 2023-11-10
file: by_date/futures_1hour/2023/2023-11-10.parquet size: 56 KB rows: 1,666
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-10 00:00:00 | ES | Futures | 4742.77 | 4744.12 | 4740.32 | 4743.04 | 5993.0 |
| 2023-11-10 01:00:00 | ES | Futures | 4742.77 | 4745.21 | 4741.41 | 4743.58 | 6257.0 |
| 2023-11-10 02:00:00 | ES | Futures | 4743.85 | 4750.1 | 4743.04 | 4748.47 | 13288.0 |
| 2023-11-10 03:00:00 | ES | Futures | 4748.74 | 4750.91 | 4743.04 | 4744.94 | 18451.0 |
| 2023-11-10 04:00:00 | ES | Futures | 4744.94 | 4745.21 | 4735.71 | 4743.04 | 17893.0 |
| 2023-11-10 05:00:00 | ES | Futures | 4743.31 | 4743.31 | 4734.35 | 4738.15 | 16136.0 |
| 2023-11-10 06:00:00 | ES | Futures | 4738.15 | 4738.69 | 4731.63 | 4737.88 | 14802.0 |
| 2023-11-10 07:00:00 | ES | Futures | 4737.88 | 4750.37 | 4735.71 | 4749.01 | 27816.0 |
| 2023-11-10 08:00:00 | ES | Futures | 4749.28 | 4760.96 | 4746.3 | 4759.06 | 47219.0 |
| 2023-11-10 09:00:00 | ES | Futures | 4759.33 | 4764.76 | 4749.28 | 4759.33 | 203405.0 |
| 2023-11-10 10:00:00 | ES | Futures | 4759.88 | 4760.42 | 4744.4 | 4755.26 | 246959.0 |
| 2023-11-10 11:00:00 | ES | Futures | 4754.99 | 4771.82 | 4754.72 | 4770.19 | 174531.0 |
| 2023-11-10 12:00:00 | ES | Futures | 4770.47 | 4795.18 | 4769.65 | 4792.73 | 197614.0 |
| 2023-11-10 13:00:00 | ES | Futures | 4792.73 | 4803.32 | 4786.22 | 4800.34 | 158366.0 |
| 2023-11-10 14:00:00 | ES | Futures | 4800.61 | 4805.5 | 4799.25 | 4801.97 | 106028.0 |
| 2023-11-10 15:00:00 | ES | Futures | 4801.97 | 4815.82 | 4801.42 | 4812.29 | 283936.0 |
| 2023-11-10 16:00:00 | ES | Futures | 4812.29 | 4817.99 | 4803.32 | 4806.04 | 83370.0 |
| 2023-11-10 00:00:00 | NQ | Futures | 16752.32 | 16756.16 | 16740.78 | 16750.67 | 3831.0 |
| 2023-11-10 01:00:00 | NQ | Futures | 16750.4 | 16756.99 | 16742.43 | 16751.22 | 2872.0 |
| 2023-11-10 02:00:00 | NQ | Futures | 16752.04 | 16775.94 | 16747.1 | 16768.52 | 7313.0 |
| 2023-11-10 03:00:00 | NQ | Futures | 16768.52 | 16779.51 | 16744.35 | 16753.69 | 9756.0 |
| 2023-11-10 04:00:00 | NQ | Futures | 16753.14 | 16758.36 | 16709.47 | 16743.8 | 11799.0 |
| 2023-11-10 05:00:00 | NQ | Futures | 16743.53 | 16745.73 | 16717.44 | 16734.74 | 8572.0 |
| 2023-11-10 06:00:00 | NQ | Futures | 16734.19 | 16736.39 | 16707.55 | 16731.44 | 8137.0 |
| 2023-11-10 07:00:00 | NQ | Futures | 16731.99 | 16790.77 | 16723.2 | 16783.9 | 16637.0 |
| 2023-11-10 08:00:00 | NQ | Futures | 16783.36 | 16832.25 | 16771.27 | 16830.05 | 24067.0 |
| 2023-11-10 09:00:00 | NQ | Futures | 16830.05 | 16909.15 | 16815.49 | 16894.05 | 82412.0 |
| 2023-11-10 10:00:00 | NQ | Futures | 16892.12 | 16897.07 | 16833.62 | 16890.47 | 110212.0 |
| 2023-11-10 11:00:00 | NQ | Futures | 16889.93 | 16976.44 | 16887.73 | 16974.8 | 76865.0 |
| 2023-11-10 12:00:00 | NQ | Futures | 16974.8 | 17071.48 | 16968.75 | 17053.63 | 80472.0 |
| 2023-11-10 13:00:00 | NQ | Futures | 17054.17 | 17104.71 | 17031.1 | 17093.18 | 60335.0 |
| 2023-11-10 14:00:00 | NQ | Futures | 17093.18 | 17117.07 | 17086.04 | 17104.71 | 37528.0 |
| 2023-11-10 15:00:00 | NQ | Futures | 17104.99 | 17143.99 | 17101.14 | 17136.02 | 71653.0 |
| 2023-11-10 16:00:00 | NQ | Futures | 17135.75 | 17153.05 | 17114.05 | 17120.37 | 23015.0 |
| 2023-11-10 00:00:00 | YM | Futures | 36880.8 | 36892.7 | 36867.8 | 36884.1 | 801.0 |
| 2023-11-10 01:00:00 | YM | Futures | 36884.1 | 36901.4 | 36874.3 | 36894.9 | 801.0 |
| 2023-11-10 02:00:00 | YM | Futures | 36893.8 | 36936.1 | 36888.4 | 36927.5 | 2463.0 |
| 2023-11-10 03:00:00 | YM | Futures | 36927.5 | 36947.0 | 36893.8 | 36907.9 | 4742.0 |
| 2023-11-10 04:00:00 | YM | Futures | 36907.9 | 36912.3 | 36841.8 | 36910.1 | 5838.0 |
| 2023-11-10 05:00:00 | YM | Futures | 36912.3 | 36913.4 | 36845.0 | 36873.2 | 2618.0 |
| 2023-11-10 06:00:00 | YM | Futures | 36872.1 | 36876.5 | 36824.4 | 36872.1 | 2160.0 |
| 2023-11-10 07:00:00 | YM | Futures | 36872.1 | 36937.2 | 36858.0 | 36923.1 | 4386.0 |
| 2023-11-10 08:00:00 | YM | Futures | 36922.0 | 36989.3 | 36904.7 | 36970.8 | 6066.0 |
| 2023-11-10 09:00:00 | YM | Futures | 36971.9 | 37021.8 | 36901.4 | 36925.3 | 23255.0 |
| 2023-11-10 10:00:00 | YM | Futures | 36925.3 | 36932.9 | 36837.4 | 36900.3 | 19838.0 |
| 2023-11-10 11:00:00 | YM | Futures | 36899.3 | 37000.1 | 36898.2 | 36977.4 | 13258.0 |
| 2023-11-10 12:00:00 | YM | Futures | 36977.4 | 37146.6 | 36976.3 | 37128.1 | 15265.0 |
| 2023-11-10 13:00:00 | YM | Futures | 37128.1 | 37171.5 | 37067.4 | 37157.4 | 12662.0 |
| 2023-11-10 14:00:00 | YM | Futures | 37156.3 | 37192.1 | 37150.9 | 37163.9 | 7605.0 |
| 2023-11-10 15:00:00 | YM | Futures | 37163.9 | 37277.8 | 37161.8 | 37246.4 | 16096.0 |
> showing 50 of 1,666 rows — these rows as CSV