PREVIEW / futures_1hour / 2022-10-21
file: by_date/futures_1hour/2022/2022-10-21.parquet size: 59 KB rows: 1,658
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-10-21 00:00:00 | ES | Futures | 4132.84 | 4135.1 | 4128.61 | 4132.84 | 5911.0 |
| 2022-10-21 01:00:00 | ES | Futures | 4132.84 | 4133.69 | 4126.92 | 4129.18 | 6783.0 |
| 2022-10-21 02:00:00 | ES | Futures | 4129.18 | 4140.45 | 4126.36 | 4135.94 | 14767.0 |
| 2022-10-21 03:00:00 | ES | Futures | 4136.22 | 4149.19 | 4125.79 | 4128.9 | 26610.0 |
| 2022-10-21 04:00:00 | ES | Futures | 4128.61 | 4129.46 | 4116.49 | 4118.18 | 31687.0 |
| 2022-10-21 05:00:00 | ES | Futures | 4118.47 | 4124.95 | 4112.26 | 4122.98 | 24927.0 |
| 2022-10-21 06:00:00 | ES | Futures | 4122.98 | 4128.33 | 4116.77 | 4126.36 | 17018.0 |
| 2022-10-21 07:00:00 | ES | Futures | 4126.08 | 4132.56 | 4119.03 | 4119.59 | 26499.0 |
| 2022-10-21 08:00:00 | ES | Futures | 4119.59 | 4124.39 | 4106.06 | 4122.13 | 86928.0 |
| 2022-10-21 09:00:00 | ES | Futures | 4121.85 | 4184.99 | 4121.28 | 4184.99 | 546213.0 |
| 2022-10-21 10:00:00 | ES | Futures | 4184.99 | 4202.75 | 4152.86 | 4158.78 | 468111.0 |
| 2022-10-21 11:00:00 | ES | Futures | 4158.78 | 4195.99 | 4146.94 | 4195.7 | 341957.0 |
| 2022-10-21 12:00:00 | ES | Futures | 4195.99 | 4217.13 | 4186.68 | 4210.36 | 257695.0 |
| 2022-10-21 13:00:00 | ES | Futures | 4210.36 | 4226.15 | 4203.32 | 4225.3 | 161100.0 |
| 2022-10-21 14:00:00 | ES | Futures | 4225.58 | 4233.76 | 4218.54 | 4228.4 | 146006.0 |
| 2022-10-21 15:00:00 | ES | Futures | 4228.69 | 4250.39 | 4226.71 | 4243.91 | 269777.0 |
| 2022-10-21 16:00:00 | ES | Futures | 4243.91 | 4254.62 | 4242.22 | 4253.21 | 80592.0 |
| 2022-10-21 00:00:00 | NQ | Futures | 12670.78 | 12676.82 | 12649.23 | 12665.61 | 4357.0 |
| 2022-10-21 01:00:00 | NQ | Futures | 12665.33 | 12671.65 | 12646.07 | 12662.16 | 5356.0 |
| 2022-10-21 02:00:00 | NQ | Futures | 12661.02 | 12702.39 | 12649.23 | 12686.87 | 7437.0 |
| 2022-10-21 03:00:00 | NQ | Futures | 12687.45 | 12741.47 | 12648.37 | 12661.88 | 15562.0 |
| 2022-10-21 04:00:00 | NQ | Futures | 12661.02 | 12667.91 | 12614.76 | 12628.26 | 17470.0 |
| 2022-10-21 05:00:00 | NQ | Futures | 12628.26 | 12651.25 | 12604.12 | 12643.78 | 12826.0 |
| 2022-10-21 06:00:00 | NQ | Futures | 12642.34 | 12652.4 | 12616.77 | 12645.5 | 9117.0 |
| 2022-10-21 07:00:00 | NQ | Futures | 12644.35 | 12674.52 | 12620.79 | 12622.51 | 12744.0 |
| 2022-10-21 08:00:00 | NQ | Futures | 12621.65 | 12634.87 | 12568.21 | 12621.65 | 31894.0 |
| 2022-10-21 09:00:00 | NQ | Futures | 12620.5 | 12821.34 | 12619.93 | 12821.34 | 159514.0 |
| 2022-10-21 10:00:00 | NQ | Futures | 12821.63 | 12901.22 | 12732.85 | 12745.49 | 129526.0 |
| 2022-10-21 11:00:00 | NQ | Futures | 12745.78 | 12888.0 | 12700.95 | 12886.57 | 97910.0 |
| 2022-10-21 12:00:00 | NQ | Futures | 12887.14 | 12939.15 | 12848.93 | 12909.55 | 83018.0 |
| 2022-10-21 13:00:00 | NQ | Futures | 12909.84 | 12977.94 | 12898.35 | 12977.36 | 55032.0 |
| 2022-10-21 14:00:00 | NQ | Futures | 12977.65 | 13010.4 | 12956.67 | 12991.15 | 53227.0 |
| 2022-10-21 15:00:00 | NQ | Futures | 12991.44 | 13072.47 | 12980.81 | 13049.19 | 79504.0 |
| 2022-10-21 16:00:00 | NQ | Futures | 13048.62 | 13086.26 | 13042.87 | 13076.78 | 18049.0 |
| 2022-10-21 00:00:00 | YM | Futures | 34027.2 | 34051.9 | 34002.6 | 34038.5 | 1015.0 |
| 2022-10-21 01:00:00 | YM | Futures | 34037.3 | 34039.6 | 33994.7 | 34003.7 | 1046.0 |
| 2022-10-21 02:00:00 | YM | Futures | 34003.7 | 34082.2 | 33980.1 | 34046.3 | 2747.0 |
| 2022-10-21 03:00:00 | YM | Futures | 34049.7 | 34135.0 | 33975.6 | 33995.8 | 4339.0 |
| 2022-10-21 04:00:00 | YM | Futures | 33992.5 | 33998.1 | 33901.6 | 33916.1 | 5406.0 |
| 2022-10-21 05:00:00 | YM | Futures | 33919.5 | 33953.2 | 33873.5 | 33940.8 | 3855.0 |
| 2022-10-21 06:00:00 | YM | Futures | 33939.7 | 33990.2 | 33901.6 | 33975.6 | 3010.0 |
| 2022-10-21 07:00:00 | YM | Futures | 33973.4 | 33977.9 | 33865.6 | 33874.6 | 6499.0 |
| 2022-10-21 08:00:00 | YM | Futures | 33874.6 | 33908.3 | 33781.5 | 33895.9 | 10283.0 |
| 2022-10-21 09:00:00 | YM | Futures | 33894.8 | 34479.5 | 33893.7 | 34479.5 | 56362.0 |
| 2022-10-21 10:00:00 | YM | Futures | 34479.5 | 34567.0 | 34213.5 | 34269.6 | 39722.0 |
| 2022-10-21 11:00:00 | YM | Futures | 34270.8 | 34577.1 | 34190.0 | 34567.0 | 30252.0 |
| 2022-10-21 12:00:00 | YM | Futures | 34568.2 | 34743.2 | 34487.4 | 34701.7 | 24652.0 |
| 2022-10-21 13:00:00 | YM | Futures | 34704.0 | 34801.6 | 34640.0 | 34788.1 | 14251.0 |
| 2022-10-21 14:00:00 | YM | Futures | 34787.0 | 34845.4 | 34727.5 | 34798.2 | 12086.0 |
| 2022-10-21 15:00:00 | YM | Futures | 34799.3 | 34972.2 | 34788.1 | 34931.8 | 18515.0 |
> showing 50 of 1,658 rows — these rows as CSV