PREVIEW / futures_1hour / 2022-05-25
file: by_date/futures_1hour/2022/2022-05-25.parquet size: 67 KB rows: 2,030
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 |
|---|---|---|---|---|---|---|---|
| 2022-05-25 00:00:00 | ES | Futures | 4498.2 | 4498.2 | 4491.11 | 4492.53 | 3524.0 |
| 2022-05-25 01:00:00 | ES | Futures | 4492.24 | 4497.35 | 4486.86 | 4489.98 | 5092.0 |
| 2022-05-25 02:00:00 | ES | Futures | 4489.98 | 4499.33 | 4478.07 | 4497.63 | 16759.0 |
| 2022-05-25 03:00:00 | ES | Futures | 4497.63 | 4498.2 | 4476.65 | 4478.36 | 18085.0 |
| 2022-05-25 04:00:00 | ES | Futures | 4478.36 | 4480.62 | 4462.2 | 4467.87 | 18589.0 |
| 2022-05-25 05:00:00 | ES | Futures | 4467.3 | 4474.1 | 4454.83 | 4471.55 | 15517.0 |
| 2022-05-25 06:00:00 | ES | Futures | 4470.99 | 4475.8 | 4457.38 | 4458.51 | 16596.0 |
| 2022-05-25 07:00:00 | ES | Futures | 4458.23 | 4463.9 | 4439.81 | 4448.59 | 30646.0 |
| 2022-05-25 08:00:00 | ES | Futures | 4448.31 | 4455.4 | 4436.97 | 4452.0 | 33806.0 |
| 2022-05-25 09:00:00 | ES | Futures | 4451.71 | 4485.44 | 4446.04 | 4475.52 | 195675.0 |
| 2022-05-25 10:00:00 | ES | Futures | 4475.52 | 4509.53 | 4464.47 | 4497.35 | 242272.0 |
| 2022-05-25 11:00:00 | ES | Futures | 4497.35 | 4498.48 | 4471.84 | 4483.46 | 160302.0 |
| 2022-05-25 12:00:00 | ES | Futures | 4483.74 | 4490.26 | 4460.22 | 4475.24 | 129885.0 |
| 2022-05-25 13:00:00 | ES | Futures | 4474.95 | 4483.74 | 4462.2 | 4475.52 | 103409.0 |
| 2022-05-25 14:00:00 | ES | Futures | 4475.8 | 4514.64 | 4453.98 | 4512.08 | 280897.0 |
| 2022-05-25 15:00:00 | ES | Futures | 4512.08 | 4532.49 | 4497.91 | 4511.23 | 287875.0 |
| 2022-05-25 16:00:00 | ES | Futures | 4511.23 | 4511.8 | 4486.29 | 4501.03 | 83641.0 |
| 2022-05-25 18:00:00 | ES | Futures | 4503.58 | 4509.25 | 4501.6 | 4507.27 | 6839.0 |
| 2022-05-25 19:00:00 | ES | Futures | 4507.27 | 4510.1 | 4499.05 | 4500.75 | 5453.0 |
| 2022-05-25 20:00:00 | ES | Futures | 4500.46 | 4527.11 | 4498.2 | 4525.69 | 16169.0 |
| 2022-05-25 21:00:00 | ES | Futures | 4525.41 | 4527.67 | 4504.15 | 4505.57 | 11241.0 |
| 2022-05-25 22:00:00 | ES | Futures | 4505.57 | 4511.23 | 4502.16 | 4506.42 | 6765.0 |
| 2022-05-25 23:00:00 | ES | Futures | 4506.42 | 4508.68 | 4493.94 | 4506.98 | 8118.0 |
| 2022-05-25 00:00:00 | NQ | Futures | 13786.86 | 13787.73 | 13764.83 | 13766.57 | 2571.0 |
| 2022-05-25 01:00:00 | NQ | Futures | 13766.57 | 13786.57 | 13742.79 | 13757.29 | 3363.0 |
| 2022-05-25 02:00:00 | NQ | Futures | 13756.13 | 13785.41 | 13712.63 | 13781.35 | 8847.0 |
| 2022-05-25 03:00:00 | NQ | Futures | 13781.93 | 13782.8 | 13696.68 | 13706.83 | 13919.0 |
| 2022-05-25 04:00:00 | NQ | Futures | 13705.67 | 13720.17 | 13641.59 | 13670.0 | 12381.0 |
| 2022-05-25 05:00:00 | NQ | Futures | 13669.13 | 13686.82 | 13607.66 | 13671.45 | 10932.0 |
| 2022-05-25 06:00:00 | NQ | Futures | 13670.29 | 13694.65 | 13629.12 | 13633.76 | 10004.0 |
| 2022-05-25 07:00:00 | NQ | Futures | 13634.63 | 13651.74 | 13542.41 | 13571.7 | 17819.0 |
| 2022-05-25 08:00:00 | NQ | Futures | 13572.86 | 13617.81 | 13538.35 | 13592.87 | 19886.0 |
| 2022-05-25 09:00:00 | NQ | Futures | 13592.0 | 13753.81 | 13579.82 | 13694.36 | 83626.0 |
| 2022-05-25 10:00:00 | NQ | Futures | 13694.07 | 13837.61 | 13636.95 | 13779.9 | 99542.0 |
| 2022-05-25 11:00:00 | NQ | Futures | 13780.19 | 13805.71 | 13703.93 | 13751.78 | 56029.0 |
| 2022-05-25 12:00:00 | NQ | Futures | 13751.78 | 13772.65 | 13673.48 | 13732.06 | 44087.0 |
| 2022-05-25 13:00:00 | NQ | Futures | 13731.77 | 13767.44 | 13677.83 | 13742.21 | 35805.0 |
| 2022-05-25 14:00:00 | NQ | Futures | 13744.53 | 13891.25 | 13652.61 | 13883.14 | 104170.0 |
| 2022-05-25 15:00:00 | NQ | Futures | 13882.85 | 13960.56 | 13801.07 | 13860.23 | 81008.0 |
| 2022-05-25 16:00:00 | NQ | Futures | 13859.94 | 13863.13 | 13704.8 | 13794.98 | 29235.0 |
| 2022-05-25 18:00:00 | NQ | Futures | 13788.31 | 13828.62 | 13788.31 | 13818.47 | 4455.0 |
| 2022-05-25 19:00:00 | NQ | Futures | 13819.05 | 13832.39 | 13789.47 | 13794.4 | 3037.0 |
| 2022-05-25 20:00:00 | NQ | Futures | 13793.53 | 13909.81 | 13789.47 | 13899.08 | 8375.0 |
| 2022-05-25 21:00:00 | NQ | Futures | 13901.11 | 13912.13 | 13812.67 | 13817.02 | 6739.0 |
| 2022-05-25 22:00:00 | NQ | Futures | 13818.76 | 13828.33 | 13797.01 | 13815.28 | 4628.0 |
| 2022-05-25 23:00:00 | NQ | Futures | 13814.41 | 13823.4 | 13756.42 | 13817.6 | 6264.0 |
| 2022-05-25 00:00:00 | YM | Futures | 36109.5 | 36109.5 | 36063.3 | 36070.1 | 766.0 |
| 2022-05-25 01:00:00 | YM | Futures | 36068.9 | 36097.1 | 36031.7 | 36050.9 | 912.0 |
| 2022-05-25 02:00:00 | YM | Futures | 36052.0 | 36114.0 | 35969.7 | 36101.6 | 3505.0 |
| 2022-05-25 03:00:00 | YM | Futures | 36103.9 | 36105.0 | 35972.0 | 35979.9 | 3636.0 |
> showing 50 of 2,030 rows — these rows as CSV