PREVIEW / futures_1hour / 2023-02-22
file: by_date/futures_1hour/2023/2023-02-22.parquet size: 66 KB rows: 2,043
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-22 00:00:00 | ES | Futures | 4489.08 | 4489.36 | 4486.57 | 4487.96 | 3460.0 |
| 2023-02-22 01:00:00 | ES | Futures | 4487.69 | 4489.08 | 4485.17 | 4486.29 | 4657.0 |
| 2023-02-22 02:00:00 | ES | Futures | 4486.29 | 4491.04 | 4483.49 | 4486.85 | 10895.0 |
| 2023-02-22 03:00:00 | ES | Futures | 4486.85 | 4491.88 | 4472.31 | 4480.14 | 38368.0 |
| 2023-02-22 04:00:00 | ES | Futures | 4480.42 | 4486.29 | 4473.98 | 4483.49 | 29824.0 |
| 2023-02-22 05:00:00 | ES | Futures | 4483.49 | 4484.89 | 4475.38 | 4481.25 | 18075.0 |
| 2023-02-22 06:00:00 | ES | Futures | 4481.25 | 4482.93 | 4468.67 | 4478.74 | 29344.0 |
| 2023-02-22 07:00:00 | ES | Futures | 4478.74 | 4496.91 | 4477.9 | 4492.16 | 51732.0 |
| 2023-02-22 08:00:00 | ES | Futures | 4492.44 | 4493.28 | 4485.45 | 4488.8 | 38220.0 |
| 2023-02-22 09:00:00 | ES | Futures | 4488.52 | 4494.4 | 4481.25 | 4486.01 | 192085.0 |
| 2023-02-22 10:00:00 | ES | Futures | 4486.01 | 4487.13 | 4462.52 | 4479.3 | 298573.0 |
| 2023-02-22 11:00:00 | ES | Futures | 4479.3 | 4484.89 | 4473.15 | 4482.93 | 156717.0 |
| 2023-02-22 12:00:00 | ES | Futures | 4482.93 | 4495.23 | 4478.74 | 4490.48 | 120825.0 |
| 2023-02-22 13:00:00 | ES | Futures | 4490.48 | 4499.15 | 4486.85 | 4493.0 | 96542.0 |
| 2023-02-22 14:00:00 | ES | Futures | 4492.44 | 4501.67 | 4460.84 | 4461.68 | 366817.0 |
| 2023-02-22 15:00:00 | ES | Futures | 4461.68 | 4475.1 | 4455.53 | 4473.98 | 313913.0 |
| 2023-02-22 16:00:00 | ES | Futures | 4473.98 | 4484.33 | 4471.47 | 4483.21 | 64344.0 |
| 2023-02-22 18:00:00 | ES | Futures | 4484.89 | 4485.45 | 4479.3 | 4484.89 | 10270.0 |
| 2023-02-22 19:00:00 | ES | Futures | 4484.61 | 4488.24 | 4484.05 | 4485.73 | 6381.0 |
| 2023-02-22 20:00:00 | ES | Futures | 4485.73 | 4492.16 | 4484.05 | 4492.16 | 7594.0 |
| 2023-02-22 21:00:00 | ES | Futures | 4492.16 | 4494.12 | 4490.2 | 4493.56 | 7802.0 |
| 2023-02-22 22:00:00 | ES | Futures | 4493.56 | 4494.95 | 4491.88 | 4492.72 | 4976.0 |
| 2023-02-22 23:00:00 | ES | Futures | 4492.72 | 4494.4 | 4491.6 | 4494.4 | 2866.0 |
| 2023-02-22 00:00:00 | NQ | Futures | 13802.51 | 13802.51 | 13791.42 | 13794.55 | 1968.0 |
| 2023-02-22 01:00:00 | NQ | Futures | 13794.55 | 13802.23 | 13780.89 | 13790.85 | 2507.0 |
| 2023-02-22 02:00:00 | NQ | Futures | 13790.57 | 13815.6 | 13775.2 | 13797.11 | 5623.0 |
| 2023-02-22 03:00:00 | NQ | Futures | 13797.96 | 13820.72 | 13729.11 | 13763.25 | 15486.0 |
| 2023-02-22 04:00:00 | NQ | Futures | 13764.96 | 13793.69 | 13735.94 | 13780.89 | 12429.0 |
| 2023-02-22 05:00:00 | NQ | Futures | 13780.89 | 13785.16 | 13748.46 | 13771.22 | 7217.0 |
| 2023-02-22 06:00:00 | NQ | Futures | 13771.22 | 13776.34 | 13727.69 | 13764.96 | 9141.0 |
| 2023-02-22 07:00:00 | NQ | Futures | 13764.96 | 13841.49 | 13758.7 | 13819.87 | 19158.0 |
| 2023-02-22 08:00:00 | NQ | Futures | 13819.87 | 13824.14 | 13790.85 | 13804.51 | 13977.0 |
| 2023-02-22 09:00:00 | NQ | Futures | 13804.51 | 13854.29 | 13787.15 | 13795.12 | 68927.0 |
| 2023-02-22 10:00:00 | NQ | Futures | 13795.12 | 13798.82 | 13694.41 | 13769.8 | 110361.0 |
| 2023-02-22 11:00:00 | NQ | Futures | 13770.08 | 13789.43 | 13742.77 | 13779.19 | 52739.0 |
| 2023-02-22 12:00:00 | NQ | Futures | 13779.47 | 13825.27 | 13757.56 | 13808.2 | 43596.0 |
| 2023-02-22 13:00:00 | NQ | Futures | 13808.49 | 13848.32 | 13797.39 | 13826.41 | 33398.0 |
| 2023-02-22 14:00:00 | NQ | Futures | 13824.42 | 13872.5 | 13723.99 | 13726.84 | 116757.0 |
| 2023-02-22 15:00:00 | NQ | Futures | 13727.69 | 13774.92 | 13710.62 | 13773.5 | 80883.0 |
| 2023-02-22 16:00:00 | NQ | Futures | 13772.93 | 13859.41 | 13762.4 | 13845.19 | 19865.0 |
| 2023-02-22 18:00:00 | NQ | Futures | 13856.28 | 13859.7 | 13828.69 | 13846.33 | 5933.0 |
| 2023-02-22 19:00:00 | NQ | Futures | 13845.76 | 13858.27 | 13843.77 | 13847.75 | 3545.0 |
| 2023-02-22 20:00:00 | NQ | Futures | 13848.03 | 13882.17 | 13843.2 | 13881.6 | 5117.0 |
| 2023-02-22 21:00:00 | NQ | Futures | 13881.6 | 13894.12 | 13876.2 | 13892.13 | 4424.0 |
| 2023-02-22 22:00:00 | NQ | Futures | 13892.13 | 13897.82 | 13881.6 | 13885.59 | 3071.0 |
| 2023-02-22 23:00:00 | NQ | Futures | 13886.44 | 13890.99 | 13880.47 | 13890.71 | 1081.0 |
| 2023-02-22 00:00:00 | YM | Futures | 37009.8 | 37010.9 | 36989.7 | 36999.7 | 451.0 |
| 2023-02-22 01:00:00 | YM | Futures | 36998.6 | 37006.4 | 36978.6 | 36984.2 | 712.0 |
| 2023-02-22 02:00:00 | YM | Futures | 36984.2 | 37010.9 | 36961.9 | 36986.4 | 2102.0 |
| 2023-02-22 03:00:00 | YM | Futures | 36986.4 | 37016.5 | 36897.2 | 36950.7 | 5585.0 |
> showing 50 of 2,043 rows — these rows as CSV