PREVIEW / futures_1hour / 2023-02-21
file: by_date/futures_1hour/2023/2023-02-21.parquet size: 66 KB rows: 2,040
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-02-21 00:00:00 | ES | Futures | 4551.44 | 4554.79 | 4550.88 | 4554.23 | 5863.0 |
| 2023-02-21 01:00:00 | ES | Futures | 4554.23 | 4555.35 | 4551.72 | 4553.95 | 3919.0 |
| 2023-02-21 02:00:00 | ES | Futures | 4553.95 | 4553.95 | 4544.45 | 4545.56 | 9738.0 |
| 2023-02-21 03:00:00 | ES | Futures | 4545.56 | 4549.2 | 4529.63 | 4530.19 | 39164.0 |
| 2023-02-21 04:00:00 | ES | Futures | 4530.46 | 4551.99 | 4527.11 | 4545.56 | 46720.0 |
| 2023-02-21 05:00:00 | ES | Futures | 4545.56 | 4547.24 | 4534.38 | 4534.66 | 19297.0 |
| 2023-02-21 06:00:00 | ES | Futures | 4534.66 | 4542.77 | 4531.02 | 4541.93 | 17065.0 |
| 2023-02-21 07:00:00 | ES | Futures | 4541.93 | 4543.05 | 4532.14 | 4536.62 | 20294.0 |
| 2023-02-21 08:00:00 | ES | Futures | 4536.34 | 4536.9 | 4527.11 | 4528.23 | 40144.0 |
| 2023-02-21 09:00:00 | ES | Futures | 4528.23 | 4536.62 | 4515.37 | 4517.88 | 238033.0 |
| 2023-02-21 10:00:00 | ES | Futures | 4517.88 | 4522.36 | 4503.9 | 4504.74 | 276441.0 |
| 2023-02-21 11:00:00 | ES | Futures | 4504.74 | 4508.94 | 4492.72 | 4494.95 | 190057.0 |
| 2023-02-21 12:00:00 | ES | Futures | 4494.95 | 4500.55 | 4491.04 | 4499.71 | 120820.0 |
| 2023-02-21 13:00:00 | ES | Futures | 4499.71 | 4500.55 | 4483.77 | 4485.73 | 125372.0 |
| 2023-02-21 14:00:00 | ES | Futures | 4485.73 | 4490.48 | 4475.94 | 4486.01 | 175970.0 |
| 2023-02-21 15:00:00 | ES | Futures | 4486.29 | 4491.6 | 4478.18 | 4480.7 | 281351.0 |
| 2023-02-21 16:00:00 | ES | Futures | 4480.7 | 4485.73 | 4480.42 | 4482.37 | 59149.0 |
| 2023-02-21 18:00:00 | ES | Futures | 4482.09 | 4486.29 | 4479.58 | 4485.17 | 8058.0 |
| 2023-02-21 19:00:00 | ES | Futures | 4485.17 | 4487.96 | 4483.21 | 4487.69 | 8847.0 |
| 2023-02-21 20:00:00 | ES | Futures | 4487.41 | 4490.2 | 4484.89 | 4487.96 | 7799.0 |
| 2023-02-21 21:00:00 | ES | Futures | 4487.69 | 4491.32 | 4486.29 | 4491.32 | 7272.0 |
| 2023-02-21 22:00:00 | ES | Futures | 4491.32 | 4491.6 | 4488.24 | 4491.04 | 4294.0 |
| 2023-02-21 23:00:00 | ES | Futures | 4491.04 | 4491.32 | 4487.69 | 4489.36 | 3673.0 |
| 2023-02-21 00:00:00 | NQ | Futures | 14048.32 | 14065.96 | 14043.2 | 14054.58 | 2990.0 |
| 2023-02-21 01:00:00 | NQ | Futures | 14054.29 | 14062.83 | 14049.17 | 14058.84 | 2085.0 |
| 2023-02-21 02:00:00 | NQ | Futures | 14059.13 | 14059.7 | 14019.01 | 14019.87 | 5581.0 |
| 2023-02-21 03:00:00 | NQ | Futures | 14019.58 | 14035.51 | 13915.17 | 13920.86 | 18204.0 |
| 2023-02-21 04:00:00 | NQ | Futures | 13921.72 | 14017.59 | 13916.31 | 13989.71 | 17854.0 |
| 2023-02-21 05:00:00 | NQ | Futures | 13989.43 | 13996.82 | 13956.99 | 13959.27 | 8549.0 |
| 2023-02-21 06:00:00 | NQ | Futures | 13959.84 | 13988.0 | 13950.17 | 13977.76 | 7533.0 |
| 2023-02-21 07:00:00 | NQ | Futures | 13977.19 | 13980.89 | 13939.07 | 13955.57 | 10704.0 |
| 2023-02-21 08:00:00 | NQ | Futures | 13955.57 | 13958.99 | 13927.98 | 13929.4 | 15760.0 |
| 2023-02-21 09:00:00 | NQ | Futures | 13929.4 | 13985.73 | 13902.09 | 13915.46 | 78505.0 |
| 2023-02-21 10:00:00 | NQ | Futures | 13915.46 | 13930.54 | 13861.12 | 13869.65 | 89870.0 |
| 2023-02-21 11:00:00 | NQ | Futures | 13869.37 | 13887.86 | 13820.44 | 13826.98 | 61469.0 |
| 2023-02-21 12:00:00 | NQ | Futures | 13827.26 | 13854.29 | 13816.45 | 13850.31 | 33673.0 |
| 2023-02-21 13:00:00 | NQ | Futures | 13850.88 | 13854.86 | 13806.5 | 13812.76 | 33640.0 |
| 2023-02-21 14:00:00 | NQ | Futures | 13813.04 | 13821.01 | 13776.91 | 13796.82 | 46767.0 |
| 2023-02-21 15:00:00 | NQ | Futures | 13797.39 | 13816.74 | 13758.42 | 13767.24 | 67363.0 |
| 2023-02-21 16:00:00 | NQ | Futures | 13767.24 | 13790.57 | 13767.24 | 13782.6 | 13484.0 |
| 2023-02-21 18:00:00 | NQ | Futures | 13778.62 | 13788.86 | 13767.52 | 13785.73 | 4165.0 |
| 2023-02-21 19:00:00 | NQ | Futures | 13784.88 | 13796.26 | 13778.9 | 13794.55 | 4622.0 |
| 2023-02-21 20:00:00 | NQ | Futures | 13795.12 | 13803.65 | 13784.31 | 13795.4 | 4170.0 |
| 2023-02-21 21:00:00 | NQ | Futures | 13794.83 | 13818.73 | 13790.57 | 13817.02 | 4138.0 |
| 2023-02-21 22:00:00 | NQ | Futures | 13817.31 | 13817.59 | 13805.36 | 13813.89 | 1825.0 |
| 2023-02-21 23:00:00 | NQ | Futures | 13814.75 | 13815.89 | 13794.26 | 13802.23 | 1850.0 |
| 2023-02-21 00:00:00 | YM | Futures | 37588.0 | 37608.1 | 37582.5 | 37602.5 | 675.0 |
| 2023-02-21 01:00:00 | YM | Futures | 37603.6 | 37612.5 | 37584.7 | 37602.5 | 640.0 |
| 2023-02-21 02:00:00 | YM | Futures | 37600.3 | 37601.4 | 37534.6 | 37547.9 | 1945.0 |
| 2023-02-21 03:00:00 | YM | Futures | 37546.8 | 37586.9 | 37474.4 | 37482.2 | 5847.0 |
> showing 50 of 2,040 rows — these rows as CSV