PREVIEW / futures_1hour / 2022-02-16
file: by_date/futures_1hour/2022/2022-02-16.parquet size: 69 KB rows: 2,085
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-02-16 00:00:00 | ES | Futures | 5039.25 | 5043.49 | 5038.97 | 5042.08 | 3467.0 |
| 2022-02-16 01:00:00 | ES | Futures | 5042.36 | 5046.04 | 5038.97 | 5044.34 | 4111.0 |
| 2022-02-16 02:00:00 | ES | Futures | 5044.34 | 5048.58 | 5040.1 | 5044.34 | 6707.0 |
| 2022-02-16 03:00:00 | ES | Futures | 5044.06 | 5066.4 | 5037.84 | 5061.87 | 29046.0 |
| 2022-02-16 04:00:00 | ES | Futures | 5061.59 | 5071.21 | 5046.6 | 5048.3 | 26120.0 |
| 2022-02-16 05:00:00 | ES | Futures | 5048.3 | 5049.43 | 5033.88 | 5044.91 | 17999.0 |
| 2022-02-16 06:00:00 | ES | Futures | 5044.91 | 5049.15 | 5038.97 | 5046.04 | 12572.0 |
| 2022-02-16 07:00:00 | ES | Futures | 5045.76 | 5050.28 | 5035.01 | 5039.25 | 22841.0 |
| 2022-02-16 08:00:00 | ES | Futures | 5038.97 | 5050.28 | 5026.81 | 5029.64 | 54236.0 |
| 2022-02-16 09:00:00 | ES | Futures | 5029.64 | 5036.14 | 5008.71 | 5012.67 | 193633.0 |
| 2022-02-16 10:00:00 | ES | Futures | 5012.38 | 5022.0 | 5006.73 | 5015.5 | 169276.0 |
| 2022-02-16 11:00:00 | ES | Futures | 5015.78 | 5023.98 | 5012.67 | 5022.28 | 104598.0 |
| 2022-02-16 12:00:00 | ES | Futures | 5022.0 | 5026.24 | 5003.05 | 5013.8 | 102394.0 |
| 2022-02-16 13:00:00 | ES | Futures | 5013.8 | 5019.45 | 5009.27 | 5015.21 | 66429.0 |
| 2022-02-16 14:00:00 | ES | Futures | 5014.65 | 5063.29 | 5004.18 | 5055.94 | 256654.0 |
| 2022-02-16 15:00:00 | ES | Futures | 5056.22 | 5072.9 | 5052.54 | 5056.78 | 217572.0 |
| 2022-02-16 16:00:00 | ES | Futures | 5056.78 | 5058.76 | 5049.15 | 5050.85 | 53602.0 |
| 2022-02-16 18:00:00 | ES | Futures | 5050.0 | 5061.87 | 5045.47 | 5047.17 | 15686.0 |
| 2022-02-16 19:00:00 | ES | Futures | 5046.89 | 5050.0 | 5043.78 | 5047.45 | 10498.0 |
| 2022-02-16 20:00:00 | ES | Futures | 5047.17 | 5051.41 | 5045.76 | 5047.73 | 6161.0 |
| 2022-02-16 21:00:00 | ES | Futures | 5047.73 | 5053.67 | 5047.73 | 5053.39 | 4135.0 |
| 2022-02-16 22:00:00 | ES | Futures | 5053.39 | 5054.24 | 5033.88 | 5033.88 | 17153.0 |
| 2022-02-16 23:00:00 | ES | Futures | 5033.88 | 5037.27 | 5017.76 | 5025.96 | 40177.0 |
| 2022-02-16 00:00:00 | NQ | Futures | 16885.33 | 16903.3 | 16884.75 | 16893.44 | 2846.0 |
| 2022-02-16 01:00:00 | NQ | Futures | 16893.73 | 16910.54 | 16884.17 | 16903.01 | 2487.0 |
| 2022-02-16 02:00:00 | NQ | Futures | 16903.01 | 16920.68 | 16888.8 | 16908.22 | 4822.0 |
| 2022-02-16 03:00:00 | NQ | Futures | 16907.64 | 16999.8 | 16874.31 | 16960.1 | 22238.0 |
| 2022-02-16 04:00:00 | NQ | Futures | 16960.97 | 17004.73 | 16926.48 | 16931.7 | 15826.0 |
| 2022-02-16 05:00:00 | NQ | Futures | 16931.41 | 16944.74 | 16885.62 | 16917.21 | 9607.0 |
| 2022-02-16 06:00:00 | NQ | Futures | 16917.21 | 16943.0 | 16904.45 | 16933.73 | 6219.0 |
| 2022-02-16 07:00:00 | NQ | Futures | 16933.15 | 16951.98 | 16876.05 | 16893.15 | 13585.0 |
| 2022-02-16 08:00:00 | NQ | Futures | 16893.15 | 16933.44 | 16827.94 | 16839.54 | 24144.0 |
| 2022-02-16 09:00:00 | NQ | Futures | 16839.25 | 16846.49 | 16671.44 | 16702.74 | 85608.0 |
| 2022-02-16 10:00:00 | NQ | Futures | 16702.45 | 16770.56 | 16676.95 | 16745.92 | 72859.0 |
| 2022-02-16 11:00:00 | NQ | Futures | 16746.5 | 16785.63 | 16718.1 | 16761.0 | 45534.0 |
| 2022-02-16 12:00:00 | NQ | Futures | 16760.71 | 16778.96 | 16676.08 | 16709.41 | 41130.0 |
| 2022-02-16 13:00:00 | NQ | Futures | 16709.12 | 16742.45 | 16689.99 | 16723.32 | 26066.0 |
| 2022-02-16 14:00:00 | NQ | Futures | 16723.32 | 16933.44 | 16684.19 | 16909.96 | 106220.0 |
| 2022-02-16 15:00:00 | NQ | Futures | 16910.25 | 16977.49 | 16903.01 | 16927.06 | 68570.0 |
| 2022-02-16 16:00:00 | NQ | Futures | 16926.48 | 16974.01 | 16880.4 | 16916.63 | 21439.0 |
| 2022-02-16 18:00:00 | NQ | Futures | 16916.34 | 16947.93 | 16885.91 | 16892.86 | 7573.0 |
| 2022-02-16 19:00:00 | NQ | Futures | 16894.02 | 16905.9 | 16878.95 | 16892.57 | 4197.0 |
| 2022-02-16 20:00:00 | NQ | Futures | 16892.57 | 16907.64 | 16886.2 | 16896.92 | 2843.0 |
| 2022-02-16 21:00:00 | NQ | Futures | 16898.95 | 16922.42 | 16895.18 | 16918.08 | 2370.0 |
| 2022-02-16 22:00:00 | NQ | Futures | 16918.66 | 16927.06 | 16823.6 | 16829.97 | 6510.0 |
| 2022-02-16 23:00:00 | NQ | Futures | 16828.52 | 16829.68 | 16742.16 | 16793.74 | 19065.0 |
| 2022-02-16 00:00:00 | YM | Futures | 39173.4 | 39203.8 | 39170.1 | 39193.7 | 1235.0 |
| 2022-02-16 01:00:00 | YM | Futures | 39194.8 | 39215.0 | 39170.1 | 39206.0 | 1184.0 |
| 2022-02-16 02:00:00 | YM | Futures | 39202.6 | 39242.0 | 39177.9 | 39207.1 | 2995.0 |
| 2022-02-16 03:00:00 | YM | Futures | 39207.1 | 39369.0 | 39170.1 | 39340.9 | 8989.0 |
> showing 50 of 2,085 rows — these rows as CSV