PREVIEW / futures_1hour / 2022-04-26
file: by_date/futures_1hour/2022/2022-04-26.parquet size: 71 KB rows: 2,083
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-04-26 00:00:00 | ES | Futures | 4877.72 | 4878.57 | 4874.89 | 4876.87 | 3750.0 |
| 2022-04-26 01:00:00 | ES | Futures | 4876.87 | 4878.01 | 4869.22 | 4874.04 | 7739.0 |
| 2022-04-26 02:00:00 | ES | Futures | 4873.75 | 4875.74 | 4857.03 | 4865.82 | 14142.0 |
| 2022-04-26 03:00:00 | ES | Futures | 4866.1 | 4867.52 | 4838.89 | 4844.84 | 27808.0 |
| 2022-04-26 04:00:00 | ES | Futures | 4844.84 | 4860.15 | 4842.58 | 4859.87 | 14255.0 |
| 2022-04-26 05:00:00 | ES | Futures | 4859.58 | 4861.85 | 4850.51 | 4855.61 | 11987.0 |
| 2022-04-26 06:00:00 | ES | Futures | 4855.61 | 4859.58 | 4847.96 | 4848.24 | 11838.0 |
| 2022-04-26 07:00:00 | ES | Futures | 4848.24 | 4851.36 | 4842.01 | 4851.08 | 17485.0 |
| 2022-04-26 08:00:00 | ES | Futures | 4851.08 | 4852.21 | 4837.19 | 4844.56 | 31713.0 |
| 2022-04-26 09:00:00 | ES | Futures | 4844.84 | 4844.84 | 4808.56 | 4813.67 | 190260.0 |
| 2022-04-26 10:00:00 | ES | Futures | 4813.1 | 4822.45 | 4775.12 | 4781.64 | 323659.0 |
| 2022-04-26 11:00:00 | ES | Futures | 4781.64 | 4787.02 | 4762.93 | 4763.21 | 218620.0 |
| 2022-04-26 12:00:00 | ES | Futures | 4763.5 | 4795.81 | 4763.21 | 4795.24 | 173899.0 |
| 2022-04-26 13:00:00 | ES | Futures | 4794.96 | 4795.52 | 4754.99 | 4762.93 | 168272.0 |
| 2022-04-26 14:00:00 | ES | Futures | 4762.93 | 4781.07 | 4757.83 | 4777.95 | 159387.0 |
| 2022-04-26 15:00:00 | ES | Futures | 4777.95 | 4783.62 | 4724.66 | 4725.52 | 380142.0 |
| 2022-04-26 16:00:00 | ES | Futures | 4725.52 | 4734.3 | 4690.09 | 4694.62 | 158441.0 |
| 2022-04-26 18:00:00 | ES | Futures | 4704.54 | 4736.29 | 4703.97 | 4722.68 | 27011.0 |
| 2022-04-26 19:00:00 | ES | Futures | 4722.96 | 4735.44 | 4722.68 | 4731.47 | 9156.0 |
| 2022-04-26 20:00:00 | ES | Futures | 4732.03 | 4736.85 | 4720.7 | 4722.96 | 11819.0 |
| 2022-04-26 21:00:00 | ES | Futures | 4722.96 | 4749.32 | 4722.68 | 4741.95 | 16700.0 |
| 2022-04-26 22:00:00 | ES | Futures | 4741.67 | 4753.01 | 4730.62 | 4751.02 | 15605.0 |
| 2022-04-26 23:00:00 | ES | Futures | 4751.02 | 4755.84 | 4746.21 | 4752.16 | 8567.0 |
| 2022-04-26 00:00:00 | NQ | Futures | 15743.91 | 15745.93 | 15728.25 | 15741.88 | 1668.0 |
| 2022-04-26 01:00:00 | NQ | Futures | 15740.72 | 15745.07 | 15705.92 | 15723.03 | 3806.0 |
| 2022-04-26 02:00:00 | NQ | Futures | 15723.32 | 15734.63 | 15656.33 | 15685.04 | 6835.0 |
| 2022-04-26 03:00:00 | NQ | Futures | 15685.33 | 15688.23 | 15580.07 | 15605.88 | 12767.0 |
| 2022-04-26 04:00:00 | NQ | Futures | 15606.17 | 15685.33 | 15599.5 | 15684.46 | 8243.0 |
| 2022-04-26 05:00:00 | NQ | Futures | 15684.46 | 15693.45 | 15648.21 | 15663.0 | 6420.0 |
| 2022-04-26 06:00:00 | NQ | Futures | 15663.87 | 15677.5 | 15630.81 | 15633.13 | 5676.0 |
| 2022-04-26 07:00:00 | NQ | Futures | 15632.55 | 15650.24 | 15610.23 | 15644.44 | 7577.0 |
| 2022-04-26 08:00:00 | NQ | Futures | 15645.31 | 15654.3 | 15598.34 | 15631.1 | 13293.0 |
| 2022-04-26 09:00:00 | NQ | Futures | 15631.97 | 15632.26 | 15372.16 | 15389.85 | 88804.0 |
| 2022-04-26 10:00:00 | NQ | Futures | 15389.27 | 15397.38 | 15237.9 | 15247.47 | 125337.0 |
| 2022-04-26 11:00:00 | NQ | Futures | 15247.47 | 15278.21 | 15190.34 | 15196.43 | 79208.0 |
| 2022-04-26 12:00:00 | NQ | Futures | 15198.17 | 15345.19 | 15197.88 | 15331.56 | 73621.0 |
| 2022-04-26 13:00:00 | NQ | Futures | 15331.56 | 15333.3 | 15193.24 | 15223.4 | 58487.0 |
| 2022-04-26 14:00:00 | NQ | Futures | 15221.95 | 15315.61 | 15201.65 | 15305.46 | 64967.0 |
| 2022-04-26 15:00:00 | NQ | Futures | 15305.46 | 15326.05 | 15085.95 | 15089.14 | 100402.0 |
| 2022-04-26 16:00:00 | NQ | Futures | 15089.14 | 15108.28 | 14848.46 | 14864.7 | 70014.0 |
| 2022-04-26 18:00:00 | NQ | Futures | 14940.67 | 15127.71 | 14937.48 | 15038.98 | 23870.0 |
| 2022-04-26 19:00:00 | NQ | Futures | 15039.85 | 15093.78 | 15036.08 | 15074.93 | 6919.0 |
| 2022-04-26 20:00:00 | NQ | Futures | 15075.51 | 15090.88 | 15022.16 | 15034.05 | 5639.0 |
| 2022-04-26 21:00:00 | NQ | Futures | 15032.31 | 15153.81 | 15026.51 | 15107.41 | 9876.0 |
| 2022-04-26 22:00:00 | NQ | Futures | 15106.25 | 15157.58 | 15069.13 | 15148.3 | 7042.0 |
| 2022-04-26 23:00:00 | NQ | Futures | 15149.17 | 15172.07 | 15116.98 | 15156.13 | 5188.0 |
| 2022-04-26 00:00:00 | YM | Futures | 38357.4 | 38369.8 | 38343.9 | 38363.1 | 741.0 |
| 2022-04-26 01:00:00 | YM | Futures | 38360.8 | 38372.1 | 38309.0 | 38338.3 | 1500.0 |
| 2022-04-26 02:00:00 | YM | Futures | 38338.3 | 38352.9 | 38227.8 | 38290.9 | 2886.0 |
| 2022-04-26 03:00:00 | YM | Futures | 38293.2 | 38297.7 | 38088.0 | 38129.7 | 7099.0 |
> showing 50 of 2,083 rows — these rows as CSV