PREVIEW / futures_1hour / 2021-12-22
file: by_date/futures_1hour/2021/2021-12-22.parquet size: 64 KB rows: 1,996
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-22 00:00:00 | ES | Futures | 5242.59 | 5245.7 | 5239.47 | 5245.13 | 3528.0 |
| 2021-12-22 01:00:00 | ES | Futures | 5244.85 | 5251.63 | 5242.87 | 5244.56 | 5049.0 |
| 2021-12-22 02:00:00 | ES | Futures | 5244.28 | 5248.24 | 5240.32 | 5241.17 | 5588.0 |
| 2021-12-22 03:00:00 | ES | Futures | 5241.17 | 5244.0 | 5228.73 | 5236.36 | 16088.0 |
| 2021-12-22 04:00:00 | ES | Futures | 5236.36 | 5242.02 | 5234.95 | 5237.78 | 8119.0 |
| 2021-12-22 05:00:00 | ES | Futures | 5237.49 | 5250.22 | 5236.65 | 5249.66 | 8259.0 |
| 2021-12-22 06:00:00 | ES | Futures | 5249.94 | 5255.31 | 5247.11 | 5255.31 | 15009.0 |
| 2021-12-22 07:00:00 | ES | Futures | 5255.03 | 5255.59 | 5247.96 | 5248.24 | 12396.0 |
| 2021-12-22 08:00:00 | ES | Futures | 5248.24 | 5249.66 | 5232.97 | 5237.49 | 33129.0 |
| 2021-12-22 09:00:00 | ES | Futures | 5237.78 | 5258.42 | 5235.52 | 5253.33 | 156909.0 |
| 2021-12-22 10:00:00 | ES | Futures | 5253.05 | 5285.85 | 5249.09 | 5283.59 | 208807.0 |
| 2021-12-22 11:00:00 | ES | Futures | 5283.59 | 5290.1 | 5279.35 | 5287.83 | 104219.0 |
| 2021-12-22 12:00:00 | ES | Futures | 5287.83 | 5292.36 | 5283.03 | 5291.51 | 72638.0 |
| 2021-12-22 13:00:00 | ES | Futures | 5291.51 | 5292.08 | 5277.65 | 5280.76 | 70155.0 |
| 2021-12-22 14:00:00 | ES | Futures | 5280.76 | 5286.42 | 5273.41 | 5285.57 | 82039.0 |
| 2021-12-22 15:00:00 | ES | Futures | 5285.57 | 5302.54 | 5283.03 | 5301.13 | 180129.0 |
| 2021-12-22 16:00:00 | ES | Futures | 5301.13 | 5305.93 | 5299.71 | 5304.52 | 56444.0 |
| 2021-12-22 18:00:00 | ES | Futures | 5304.24 | 5309.04 | 5303.95 | 5306.5 | 7468.0 |
| 2021-12-22 19:00:00 | ES | Futures | 5306.5 | 5307.06 | 5302.26 | 5304.52 | 7593.0 |
| 2021-12-22 20:00:00 | ES | Futures | 5304.52 | 5305.08 | 5301.41 | 5302.54 | 4383.0 |
| 2021-12-22 21:00:00 | ES | Futures | 5302.54 | 5306.78 | 5302.54 | 5306.5 | 4146.0 |
| 2021-12-22 22:00:00 | ES | Futures | 5306.22 | 5306.78 | 5303.67 | 5305.08 | 1695.0 |
| 2021-12-22 23:00:00 | ES | Futures | 5305.08 | 5305.65 | 5303.67 | 5304.52 | 1299.0 |
| 2021-12-22 00:00:00 | NQ | Futures | 18472.95 | 18489.18 | 18461.35 | 18483.96 | 3575.0 |
| 2021-12-22 01:00:00 | NQ | Futures | 18484.83 | 18521.34 | 18476.13 | 18498.16 | 4496.0 |
| 2021-12-22 02:00:00 | NQ | Futures | 18497.58 | 18516.42 | 18481.06 | 18483.09 | 3316.0 |
| 2021-12-22 03:00:00 | NQ | Futures | 18482.22 | 18490.04 | 18410.92 | 18442.22 | 8855.0 |
| 2021-12-22 04:00:00 | NQ | Futures | 18441.07 | 18472.37 | 18436.14 | 18453.24 | 5174.0 |
| 2021-12-22 05:00:00 | NQ | Futures | 18452.66 | 18505.98 | 18446.86 | 18501.93 | 5097.0 |
| 2021-12-22 06:00:00 | NQ | Futures | 18501.35 | 18530.91 | 18486.28 | 18525.4 | 5272.0 |
| 2021-12-22 07:00:00 | NQ | Futures | 18524.53 | 18529.75 | 18496.71 | 18498.16 | 4966.0 |
| 2021-12-22 08:00:00 | NQ | Futures | 18498.16 | 18502.8 | 18442.8 | 18474.1 | 12784.0 |
| 2021-12-22 09:00:00 | NQ | Futures | 18474.97 | 18600.18 | 18462.22 | 18556.12 | 75579.0 |
| 2021-12-22 10:00:00 | NQ | Futures | 18554.67 | 18664.22 | 18489.75 | 18658.14 | 89174.0 |
| 2021-12-22 11:00:00 | NQ | Futures | 18658.43 | 18703.35 | 18631.77 | 18696.97 | 52026.0 |
| 2021-12-22 12:00:00 | NQ | Futures | 18697.26 | 18711.46 | 18647.71 | 18681.32 | 40818.0 |
| 2021-12-22 13:00:00 | NQ | Futures | 18681.61 | 18691.18 | 18595.54 | 18624.52 | 40000.0 |
| 2021-12-22 14:00:00 | NQ | Futures | 18624.81 | 18683.93 | 18592.06 | 18681.61 | 37631.0 |
| 2021-12-22 15:00:00 | NQ | Futures | 18681.61 | 18754.07 | 18660.46 | 18743.63 | 52292.0 |
| 2021-12-22 16:00:00 | NQ | Futures | 18743.63 | 18760.44 | 18731.75 | 18756.39 | 10680.0 |
| 2021-12-22 18:00:00 | NQ | Futures | 18756.97 | 18774.36 | 18744.21 | 18763.63 | 3540.0 |
| 2021-12-22 19:00:00 | NQ | Futures | 18762.76 | 18763.34 | 18740.45 | 18748.56 | 3294.0 |
| 2021-12-22 20:00:00 | NQ | Futures | 18747.4 | 18752.91 | 18736.97 | 18743.05 | 2118.0 |
| 2021-12-22 21:00:00 | NQ | Futures | 18743.34 | 18763.34 | 18740.16 | 18759.86 | 1863.0 |
| 2021-12-22 22:00:00 | NQ | Futures | 18758.42 | 18760.73 | 18745.66 | 18748.85 | 1053.0 |
| 2021-12-22 23:00:00 | NQ | Futures | 18748.85 | 18754.07 | 18746.24 | 18749.43 | 588.0 |
| 2021-12-22 00:00:00 | YM | Futures | 39757.8 | 39778.0 | 39730.8 | 39766.8 | 822.0 |
| 2021-12-22 01:00:00 | YM | Futures | 39769.0 | 39807.3 | 39738.7 | 39746.6 | 1015.0 |
| 2021-12-22 02:00:00 | YM | Futures | 39745.4 | 39769.0 | 39717.3 | 39729.7 | 1322.0 |
| 2021-12-22 03:00:00 | YM | Futures | 39729.7 | 39742.1 | 39654.4 | 39711.7 | 3159.0 |
> showing 50 of 1,996 rows — these rows as CSV