PREVIEW / futures_1hour / 2022-11-04
file: by_date/futures_1hour/2022/2022-11-04.parquet size: 60 KB rows: 1,723
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-11-04 00:00:00 | ES | Futures | 4203.88 | 4215.15 | 4202.75 | 4213.46 | 13907.0 |
| 2022-11-04 01:00:00 | ES | Futures | 4213.46 | 4217.41 | 4210.64 | 4210.64 | 11823.0 |
| 2022-11-04 02:00:00 | ES | Futures | 4210.93 | 4228.4 | 4210.08 | 4224.18 | 16903.0 |
| 2022-11-04 03:00:00 | ES | Futures | 4223.89 | 4226.99 | 4207.83 | 4210.93 | 17031.0 |
| 2022-11-04 04:00:00 | ES | Futures | 4210.64 | 4224.18 | 4208.67 | 4223.61 | 25308.0 |
| 2022-11-04 05:00:00 | ES | Futures | 4223.33 | 4236.86 | 4221.36 | 4230.66 | 32183.0 |
| 2022-11-04 06:00:00 | ES | Futures | 4230.38 | 4240.81 | 4226.43 | 4237.42 | 20633.0 |
| 2022-11-04 07:00:00 | ES | Futures | 4237.42 | 4246.73 | 4230.66 | 4238.83 | 35082.0 |
| 2022-11-04 08:00:00 | ES | Futures | 4238.83 | 4256.31 | 4184.43 | 4254.06 | 151203.0 |
| 2022-11-04 09:00:00 | ES | Futures | 4254.34 | 4273.51 | 4215.15 | 4247.85 | 350083.0 |
| 2022-11-04 10:00:00 | ES | Futures | 4247.85 | 4290.98 | 4243.34 | 4267.59 | 372250.0 |
| 2022-11-04 11:00:00 | ES | Futures | 4267.59 | 4274.35 | 4198.81 | 4201.06 | 304959.0 |
| 2022-11-04 12:00:00 | ES | Futures | 4201.06 | 4223.89 | 4190.63 | 4204.16 | 277609.0 |
| 2022-11-04 13:00:00 | ES | Futures | 4204.44 | 4213.46 | 4191.19 | 4198.52 | 172761.0 |
| 2022-11-04 14:00:00 | ES | Futures | 4198.24 | 4237.42 | 4189.22 | 4234.61 | 192319.0 |
| 2022-11-04 15:00:00 | ES | Futures | 4234.61 | 4263.92 | 4230.38 | 4262.51 | 318331.0 |
| 2022-11-04 16:00:00 | ES | Futures | 4262.51 | 4268.15 | 4251.24 | 4254.06 | 65522.0 |
| 2022-11-04 00:00:00 | NQ | Futures | 12349.84 | 12391.5 | 12346.39 | 12384.61 | 5198.0 |
| 2022-11-04 01:00:00 | NQ | Futures | 12384.32 | 12404.72 | 12376.56 | 12378.86 | 5483.0 |
| 2022-11-04 02:00:00 | NQ | Futures | 12380.3 | 12445.81 | 12375.13 | 12428.86 | 7675.0 |
| 2022-11-04 03:00:00 | NQ | Futures | 12428.57 | 12439.77 | 12355.01 | 12363.35 | 12620.0 |
| 2022-11-04 04:00:00 | NQ | Futures | 12363.35 | 12400.41 | 12354.44 | 12398.4 | 11490.0 |
| 2022-11-04 05:00:00 | NQ | Futures | 12399.26 | 12448.68 | 12393.8 | 12418.22 | 14162.0 |
| 2022-11-04 06:00:00 | NQ | Futures | 12418.22 | 12445.23 | 12404.15 | 12433.74 | 8474.0 |
| 2022-11-04 07:00:00 | NQ | Futures | 12434.03 | 12463.34 | 12410.18 | 12432.02 | 13955.0 |
| 2022-11-04 08:00:00 | NQ | Futures | 12432.59 | 12501.84 | 12223.99 | 12496.38 | 76240.0 |
| 2022-11-04 09:00:00 | NQ | Futures | 12496.09 | 12600.68 | 12325.71 | 12463.62 | 137488.0 |
| 2022-11-04 10:00:00 | NQ | Futures | 12463.34 | 12612.74 | 12419.95 | 12515.34 | 131116.0 |
| 2022-11-04 11:00:00 | NQ | Futures | 12515.92 | 12535.17 | 12298.41 | 12304.16 | 98340.0 |
| 2022-11-04 12:00:00 | NQ | Futures | 12303.87 | 12407.59 | 12273.13 | 12313.64 | 87737.0 |
| 2022-11-04 13:00:00 | NQ | Futures | 12314.5 | 12341.8 | 12260.48 | 12283.47 | 63909.0 |
| 2022-11-04 14:00:00 | NQ | Futures | 12283.76 | 12431.73 | 12254.74 | 12421.96 | 64661.0 |
| 2022-11-04 15:00:00 | NQ | Futures | 12421.67 | 12523.39 | 12404.15 | 12519.94 | 87355.0 |
| 2022-11-04 16:00:00 | NQ | Futures | 12519.36 | 12546.37 | 12488.62 | 12494.37 | 22007.0 |
| 2022-11-04 00:00:00 | YM | Futures | 35910.4 | 35993.4 | 35900.3 | 35979.9 | 1612.0 |
| 2022-11-04 01:00:00 | YM | Futures | 35983.3 | 36008.0 | 35963.1 | 35965.3 | 1487.0 |
| 2022-11-04 02:00:00 | YM | Futures | 35965.3 | 36085.4 | 35957.5 | 36048.4 | 2700.0 |
| 2022-11-04 03:00:00 | YM | Futures | 36045.0 | 36068.6 | 35955.2 | 35981.1 | 3211.0 |
| 2022-11-04 04:00:00 | YM | Futures | 35982.2 | 36068.6 | 35967.6 | 36064.1 | 3828.0 |
| 2022-11-04 05:00:00 | YM | Futures | 36067.5 | 36150.5 | 36043.9 | 36103.4 | 4923.0 |
| 2022-11-04 06:00:00 | YM | Futures | 36104.5 | 36186.4 | 36069.7 | 36164.0 | 3507.0 |
| 2022-11-04 07:00:00 | YM | Futures | 36162.9 | 36235.8 | 36114.6 | 36173.0 | 5167.0 |
| 2022-11-04 08:00:00 | YM | Futures | 36173.0 | 36277.3 | 35765.6 | 36263.9 | 25403.0 |
| 2022-11-04 09:00:00 | YM | Futures | 36263.9 | 36358.1 | 36076.4 | 36259.4 | 42440.0 |
| 2022-11-04 10:00:00 | YM | Futures | 36259.4 | 36620.7 | 36256.0 | 36461.4 | 39628.0 |
| 2022-11-04 11:00:00 | YM | Futures | 36465.9 | 36533.2 | 35922.7 | 35940.7 | 32235.0 |
| 2022-11-04 12:00:00 | YM | Futures | 35941.8 | 36085.4 | 35854.2 | 35962.0 | 28329.0 |
| 2022-11-04 13:00:00 | YM | Futures | 35963.1 | 36030.4 | 35866.6 | 35911.5 | 20579.0 |
| 2022-11-04 14:00:00 | YM | Futures | 35911.5 | 36180.8 | 35848.6 | 36156.1 | 22234.0 |
| 2022-11-04 15:00:00 | YM | Futures | 36156.1 | 36408.6 | 36128.1 | 36397.4 | 26499.0 |
> showing 50 of 1,723 rows — these rows as CSV