PREVIEW / futures_1hour / 2022-07-15
file: by_date/futures_1hour/2022/2022-07-15.parquet size: 57 KB rows: 1,631
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-07-15 00:00:00 | ES | Futures | 4314.51 | 4315.36 | 4309.13 | 4309.98 | 4112.0 |
| 2022-07-15 01:00:00 | ES | Futures | 4310.26 | 4311.39 | 4298.64 | 4304.59 | 8717.0 |
| 2022-07-15 02:00:00 | ES | Futures | 4304.88 | 4308.28 | 4291.85 | 4292.41 | 11964.0 |
| 2022-07-15 03:00:00 | ES | Futures | 4292.41 | 4306.29 | 4283.35 | 4299.49 | 20356.0 |
| 2022-07-15 04:00:00 | ES | Futures | 4299.78 | 4315.36 | 4293.26 | 4308.28 | 16002.0 |
| 2022-07-15 05:00:00 | ES | Futures | 4308.56 | 4315.64 | 4303.46 | 4306.01 | 14030.0 |
| 2022-07-15 06:00:00 | ES | Futures | 4306.29 | 4310.83 | 4302.61 | 4308.84 | 11494.0 |
| 2022-07-15 07:00:00 | ES | Futures | 4309.13 | 4316.77 | 4306.86 | 4307.43 | 15861.0 |
| 2022-07-15 08:00:00 | ES | Futures | 4307.43 | 4343.12 | 4290.71 | 4337.45 | 87979.0 |
| 2022-07-15 09:00:00 | ES | Futures | 4337.45 | 4360.11 | 4328.11 | 4338.02 | 261851.0 |
| 2022-07-15 10:00:00 | ES | Futures | 4338.02 | 4371.73 | 4338.02 | 4364.36 | 269365.0 |
| 2022-07-15 11:00:00 | ES | Futures | 4364.08 | 4377.68 | 4362.66 | 4367.76 | 141878.0 |
| 2022-07-15 12:00:00 | ES | Futures | 4367.76 | 4371.45 | 4358.98 | 4365.21 | 101213.0 |
| 2022-07-15 13:00:00 | ES | Futures | 4365.21 | 4376.54 | 4364.93 | 4370.03 | 83739.0 |
| 2022-07-15 14:00:00 | ES | Futures | 4370.03 | 4376.54 | 4364.65 | 4371.73 | 76934.0 |
| 2022-07-15 15:00:00 | ES | Futures | 4371.73 | 4381.64 | 4362.66 | 4379.94 | 198597.0 |
| 2022-07-15 16:00:00 | ES | Futures | 4379.94 | 4383.06 | 4376.26 | 4381.36 | 63920.0 |
| 2022-07-15 00:00:00 | NQ | Futures | 13713.98 | 13715.72 | 13690.26 | 13697.2 | 2161.0 |
| 2022-07-15 01:00:00 | NQ | Futures | 13697.78 | 13702.12 | 13660.18 | 13681.3 | 4052.0 |
| 2022-07-15 02:00:00 | NQ | Futures | 13680.43 | 13696.34 | 13638.78 | 13639.94 | 5646.0 |
| 2022-07-15 03:00:00 | NQ | Futures | 13639.94 | 13684.48 | 13610.14 | 13657.87 | 11460.0 |
| 2022-07-15 04:00:00 | NQ | Futures | 13658.45 | 13713.11 | 13634.73 | 13689.11 | 8451.0 |
| 2022-07-15 05:00:00 | NQ | Futures | 13688.82 | 13709.93 | 13667.12 | 13671.17 | 6629.0 |
| 2022-07-15 06:00:00 | NQ | Futures | 13672.04 | 13685.06 | 13658.45 | 13678.4 | 6040.0 |
| 2022-07-15 07:00:00 | NQ | Futures | 13678.11 | 13700.39 | 13656.13 | 13658.45 | 6432.0 |
| 2022-07-15 08:00:00 | NQ | Futures | 13659.31 | 13775.59 | 13582.95 | 13759.97 | 38926.0 |
| 2022-07-15 09:00:00 | NQ | Futures | 13759.39 | 13866.12 | 13713.98 | 13768.07 | 94941.0 |
| 2022-07-15 10:00:00 | NQ | Futures | 13769.51 | 13871.9 | 13758.81 | 13820.42 | 89656.0 |
| 2022-07-15 11:00:00 | NQ | Futures | 13820.71 | 13883.19 | 13813.48 | 13833.15 | 58398.0 |
| 2022-07-15 12:00:00 | NQ | Futures | 13833.44 | 13846.74 | 13801.33 | 13829.68 | 47452.0 |
| 2022-07-15 13:00:00 | NQ | Futures | 13830.25 | 13872.19 | 13824.76 | 13860.91 | 39336.0 |
| 2022-07-15 14:00:00 | NQ | Futures | 13861.2 | 13881.16 | 13832.57 | 13861.78 | 33540.0 |
| 2022-07-15 15:00:00 | NQ | Futures | 13861.78 | 13898.8 | 13834.01 | 13893.89 | 54346.0 |
| 2022-07-15 16:00:00 | NQ | Futures | 13893.6 | 13908.35 | 13882.32 | 13905.75 | 14622.0 |
| 2022-07-15 00:00:00 | YM | Futures | 34637.9 | 34642.4 | 34598.4 | 34606.3 | 626.0 |
| 2022-07-15 01:00:00 | YM | Futures | 34606.3 | 34615.3 | 34523.9 | 34567.9 | 1980.0 |
| 2022-07-15 02:00:00 | YM | Futures | 34565.7 | 34592.8 | 34474.3 | 34477.7 | 2636.0 |
| 2022-07-15 03:00:00 | YM | Futures | 34476.5 | 34583.7 | 34408.8 | 34537.5 | 4509.0 |
| 2022-07-15 04:00:00 | YM | Futures | 34540.9 | 34659.3 | 34496.8 | 34605.2 | 3595.0 |
| 2022-07-15 05:00:00 | YM | Futures | 34607.4 | 34665.0 | 34571.3 | 34618.7 | 5076.0 |
| 2022-07-15 06:00:00 | YM | Futures | 34619.8 | 34658.2 | 34591.6 | 34645.8 | 3203.0 |
| 2022-07-15 07:00:00 | YM | Futures | 34646.9 | 34719.1 | 34644.7 | 34660.5 | 3900.0 |
| 2022-07-15 08:00:00 | YM | Futures | 34661.6 | 34947.1 | 34571.3 | 34892.9 | 14917.0 |
| 2022-07-15 09:00:00 | YM | Futures | 34891.8 | 35094.9 | 34859.0 | 34921.1 | 35883.0 |
| 2022-07-15 10:00:00 | YM | Futures | 34925.6 | 35235.9 | 34925.6 | 35177.2 | 32254.0 |
| 2022-07-15 11:00:00 | YM | Futures | 35177.2 | 35276.5 | 35166.0 | 35167.1 | 14890.0 |
| 2022-07-15 12:00:00 | YM | Futures | 35167.1 | 35205.4 | 35106.2 | 35147.9 | 9727.0 |
| 2022-07-15 13:00:00 | YM | Futures | 35147.9 | 35254.0 | 35137.7 | 35177.2 | 11133.0 |
| 2022-07-15 14:00:00 | YM | Futures | 35178.4 | 35224.6 | 35144.5 | 35195.3 | 11182.0 |
| 2022-07-15 15:00:00 | YM | Futures | 35195.3 | 35268.6 | 35128.7 | 35260.7 | 18965.0 |
> showing 50 of 1,631 rows — these rows as CSV