PREVIEW / futures_1hour / 2022-05-16
file: by_date/futures_1hour/2022/2022-05-16.parquet size: 69 KB rows: 2,050
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-16 00:00:00 | ES | Futures | 4525.69 | 4537.59 | 4524.27 | 4534.48 | 9059.0 |
| 2022-05-16 01:00:00 | ES | Futures | 4535.04 | 4539.86 | 4530.79 | 4535.33 | 10376.0 |
| 2022-05-16 02:00:00 | ES | Futures | 4535.61 | 4537.03 | 4520.02 | 4527.11 | 14831.0 |
| 2022-05-16 03:00:00 | ES | Futures | 4527.39 | 4540.15 | 4514.92 | 4532.21 | 23282.0 |
| 2022-05-16 04:00:00 | ES | Futures | 4532.49 | 4552.33 | 4531.64 | 4552.33 | 19093.0 |
| 2022-05-16 05:00:00 | ES | Futures | 4552.62 | 4553.75 | 4535.61 | 4537.03 | 12101.0 |
| 2022-05-16 06:00:00 | ES | Futures | 4537.03 | 4545.81 | 4536.74 | 4541.56 | 11579.0 |
| 2022-05-16 07:00:00 | ES | Futures | 4541.56 | 4548.08 | 4538.73 | 4545.25 | 12344.0 |
| 2022-05-16 08:00:00 | ES | Futures | 4545.25 | 4564.8 | 4540.71 | 4548.36 | 35473.0 |
| 2022-05-16 09:00:00 | ES | Futures | 4548.36 | 4553.75 | 4511.8 | 4524.84 | 224718.0 |
| 2022-05-16 10:00:00 | ES | Futures | 4524.84 | 4559.99 | 4512.37 | 4522.57 | 234901.0 |
| 2022-05-16 11:00:00 | ES | Futures | 4522.86 | 4558.85 | 4516.34 | 4555.73 | 193983.0 |
| 2022-05-16 12:00:00 | ES | Futures | 4556.02 | 4562.82 | 4532.78 | 4537.31 | 132199.0 |
| 2022-05-16 13:00:00 | ES | Futures | 4537.03 | 4571.32 | 4531.93 | 4562.54 | 132871.0 |
| 2022-05-16 14:00:00 | ES | Futures | 4562.25 | 4584.36 | 4556.3 | 4573.87 | 153106.0 |
| 2022-05-16 15:00:00 | ES | Futures | 4573.87 | 4578.13 | 4531.64 | 4542.41 | 272291.0 |
| 2022-05-16 16:00:00 | ES | Futures | 4542.13 | 4543.55 | 4534.48 | 4535.33 | 49490.0 |
| 2022-05-16 18:00:00 | ES | Futures | 4537.31 | 4543.26 | 4535.61 | 4541.56 | 5136.0 |
| 2022-05-16 19:00:00 | ES | Futures | 4541.56 | 4544.96 | 4537.88 | 4544.96 | 4942.0 |
| 2022-05-16 20:00:00 | ES | Futures | 4544.68 | 4556.3 | 4539.01 | 4549.22 | 11695.0 |
| 2022-05-16 21:00:00 | ES | Futures | 4549.22 | 4562.54 | 4546.66 | 4561.4 | 11273.0 |
| 2022-05-16 22:00:00 | ES | Futures | 4561.4 | 4561.69 | 4548.65 | 4550.63 | 7945.0 |
| 2022-05-16 23:00:00 | ES | Futures | 4550.92 | 4556.58 | 4549.5 | 4554.03 | 5537.0 |
| 2022-05-16 00:00:00 | NQ | Futures | 14254.3 | 14311.14 | 14250.24 | 14281.27 | 4680.0 |
| 2022-05-16 01:00:00 | NQ | Futures | 14282.14 | 14303.02 | 14269.96 | 14290.84 | 3771.0 |
| 2022-05-16 02:00:00 | NQ | Futures | 14292.0 | 14297.51 | 14226.18 | 14246.18 | 7463.0 |
| 2022-05-16 03:00:00 | NQ | Futures | 14247.34 | 14291.42 | 14185.87 | 14251.69 | 12401.0 |
| 2022-05-16 04:00:00 | NQ | Futures | 14251.11 | 14321.58 | 14250.24 | 14321.58 | 8328.0 |
| 2022-05-16 05:00:00 | NQ | Futures | 14321.0 | 14330.86 | 14252.27 | 14258.07 | 6859.0 |
| 2022-05-16 06:00:00 | NQ | Futures | 14260.39 | 14300.99 | 14259.23 | 14290.55 | 4993.0 |
| 2022-05-16 07:00:00 | NQ | Futures | 14291.42 | 14318.1 | 14280.69 | 14304.76 | 5965.0 |
| 2022-05-16 08:00:00 | NQ | Futures | 14306.79 | 14398.71 | 14282.14 | 14331.73 | 17324.0 |
| 2022-05-16 09:00:00 | NQ | Futures | 14331.73 | 14344.49 | 14170.5 | 14212.26 | 92553.0 |
| 2022-05-16 10:00:00 | NQ | Futures | 14209.94 | 14354.05 | 14154.84 | 14160.35 | 102841.0 |
| 2022-05-16 11:00:00 | NQ | Futures | 14161.51 | 14309.98 | 14139.47 | 14299.54 | 75522.0 |
| 2022-05-16 12:00:00 | NQ | Futures | 14299.83 | 14324.77 | 14183.55 | 14196.02 | 44621.0 |
| 2022-05-16 13:00:00 | NQ | Futures | 14195.44 | 14328.54 | 14170.5 | 14293.45 | 46489.0 |
| 2022-05-16 14:00:00 | NQ | Futures | 14294.61 | 14386.24 | 14265.61 | 14338.11 | 50665.0 |
| 2022-05-16 15:00:00 | NQ | Futures | 14337.53 | 14346.52 | 14164.99 | 14205.01 | 71502.0 |
| 2022-05-16 16:00:00 | NQ | Futures | 14205.01 | 14215.16 | 14186.74 | 14193.41 | 14171.0 |
| 2022-05-16 18:00:00 | NQ | Futures | 14191.96 | 14229.66 | 14190.22 | 14219.8 | 3679.0 |
| 2022-05-16 19:00:00 | NQ | Futures | 14220.96 | 14232.85 | 14202.98 | 14229.37 | 2992.0 |
| 2022-05-16 20:00:00 | NQ | Futures | 14229.66 | 14278.95 | 14211.68 | 14257.2 | 5378.0 |
| 2022-05-16 21:00:00 | NQ | Futures | 14255.17 | 14310.56 | 14243.86 | 14300.7 | 6330.0 |
| 2022-05-16 22:00:00 | NQ | Futures | 14300.99 | 14303.31 | 14247.05 | 14259.52 | 5327.0 |
| 2022-05-16 23:00:00 | NQ | Futures | 14260.97 | 14285.62 | 14252.56 | 14278.08 | 2452.0 |
| 2022-05-16 00:00:00 | YM | Futures | 36018.2 | 36079.1 | 36000.2 | 36071.2 | 1280.0 |
| 2022-05-16 01:00:00 | YM | Futures | 36076.8 | 36109.5 | 36046.4 | 36075.7 | 1132.0 |
| 2022-05-16 02:00:00 | YM | Futures | 36075.7 | 36082.5 | 35974.3 | 36028.4 | 1821.0 |
| 2022-05-16 03:00:00 | YM | Futures | 36030.6 | 36121.9 | 35960.7 | 36079.1 | 3236.0 |
> showing 50 of 2,050 rows — these rows as CSV