PREVIEW / futures_1hour / 2022-03-22
file: by_date/futures_1hour/2022/2022-03-22.parquet size: 68 KB rows: 2,053
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-03-22 00:00:00 | ES | Futures | 5035.88 | 5039.85 | 5032.2 | 5035.03 | 3998.0 |
| 2022-03-22 01:00:00 | ES | Futures | 5034.75 | 5037.3 | 5029.36 | 5035.6 | 5367.0 |
| 2022-03-22 02:00:00 | ES | Futures | 5036.17 | 5042.4 | 5033.9 | 5036.45 | 4987.0 |
| 2022-03-22 03:00:00 | ES | Futures | 5036.45 | 5051.47 | 5034.75 | 5050.9 | 9079.0 |
| 2022-03-22 04:00:00 | ES | Futures | 5050.62 | 5069.04 | 5049.2 | 5064.23 | 19301.0 |
| 2022-03-22 05:00:00 | ES | Futures | 5064.51 | 5070.75 | 5060.82 | 5065.08 | 12469.0 |
| 2022-03-22 06:00:00 | ES | Futures | 5064.79 | 5069.61 | 5058.84 | 5066.49 | 13505.0 |
| 2022-03-22 07:00:00 | ES | Futures | 5066.21 | 5067.06 | 5059.69 | 5060.82 | 12609.0 |
| 2022-03-22 08:00:00 | ES | Futures | 5061.11 | 5065.64 | 5055.16 | 5065.36 | 23061.0 |
| 2022-03-22 09:00:00 | ES | Futures | 5065.36 | 5082.93 | 5061.39 | 5080.1 | 150313.0 |
| 2022-03-22 10:00:00 | ES | Futures | 5080.1 | 5104.76 | 5080.1 | 5098.24 | 184153.0 |
| 2022-03-22 11:00:00 | ES | Futures | 5098.52 | 5108.73 | 5091.72 | 5097.11 | 114895.0 |
| 2022-03-22 12:00:00 | ES | Futures | 5097.39 | 5102.77 | 5086.62 | 5100.51 | 109170.0 |
| 2022-03-22 13:00:00 | ES | Futures | 5100.51 | 5107.31 | 5095.4 | 5106.46 | 82632.0 |
| 2022-03-22 14:00:00 | ES | Futures | 5106.46 | 5107.31 | 5090.59 | 5100.51 | 96308.0 |
| 2022-03-22 15:00:00 | ES | Futures | 5100.51 | 5118.65 | 5098.52 | 5108.16 | 229403.0 |
| 2022-03-22 16:00:00 | ES | Futures | 5107.88 | 5110.71 | 5106.46 | 5108.44 | 57515.0 |
| 2022-03-22 18:00:00 | ES | Futures | 5106.46 | 5116.1 | 5101.07 | 5112.41 | 7566.0 |
| 2022-03-22 19:00:00 | ES | Futures | 5112.41 | 5113.83 | 5109.86 | 5112.98 | 3671.0 |
| 2022-03-22 20:00:00 | ES | Futures | 5112.98 | 5116.66 | 5105.33 | 5105.89 | 7571.0 |
| 2022-03-22 21:00:00 | ES | Futures | 5106.18 | 5111.84 | 5105.04 | 5111.84 | 6610.0 |
| 2022-03-22 22:00:00 | ES | Futures | 5111.84 | 5117.8 | 5107.03 | 5115.81 | 6658.0 |
| 2022-03-22 23:00:00 | ES | Futures | 5116.1 | 5117.23 | 5110.71 | 5111.56 | 3473.0 |
| 2022-03-22 00:00:00 | NQ | Futures | 16614.99 | 16628.62 | 16593.53 | 16604.55 | 1892.0 |
| 2022-03-22 01:00:00 | NQ | Futures | 16604.55 | 16632.97 | 16587.73 | 16624.27 | 3263.0 |
| 2022-03-22 02:00:00 | NQ | Futures | 16624.56 | 16648.34 | 16617.02 | 16620.5 | 2945.0 |
| 2022-03-22 03:00:00 | NQ | Futures | 16620.21 | 16694.15 | 16614.41 | 16681.68 | 5772.0 |
| 2022-03-22 04:00:00 | NQ | Futures | 16681.39 | 16751.28 | 16673.57 | 16734.75 | 11247.0 |
| 2022-03-22 05:00:00 | NQ | Futures | 16734.75 | 16758.53 | 16712.71 | 16724.6 | 6109.0 |
| 2022-03-22 06:00:00 | NQ | Futures | 16723.73 | 16741.71 | 16695.89 | 16727.79 | 6650.0 |
| 2022-03-22 07:00:00 | NQ | Futures | 16728.37 | 16730.11 | 16679.94 | 16685.45 | 6699.0 |
| 2022-03-22 08:00:00 | NQ | Futures | 16686.61 | 16701.69 | 16658.78 | 16697.63 | 9229.0 |
| 2022-03-22 09:00:00 | NQ | Futures | 16698.21 | 16806.08 | 16672.41 | 16782.31 | 77240.0 |
| 2022-03-22 10:00:00 | NQ | Futures | 16781.73 | 16976.01 | 16781.44 | 16951.07 | 89820.0 |
| 2022-03-22 11:00:00 | NQ | Futures | 16950.49 | 17032.84 | 16927.0 | 16962.96 | 60305.0 |
| 2022-03-22 12:00:00 | NQ | Futures | 16963.25 | 16985.29 | 16900.91 | 16948.46 | 50135.0 |
| 2022-03-22 13:00:00 | NQ | Futures | 16949.04 | 16988.77 | 16914.53 | 16987.32 | 38065.0 |
| 2022-03-22 14:00:00 | NQ | Futures | 16987.32 | 17003.85 | 16923.23 | 16984.42 | 42366.0 |
| 2022-03-22 15:00:00 | NQ | Futures | 16985.0 | 17039.8 | 16966.73 | 16998.34 | 56868.0 |
| 2022-03-22 16:00:00 | NQ | Futures | 16997.76 | 17015.74 | 16992.54 | 16997.76 | 10889.0 |
| 2022-03-22 18:00:00 | NQ | Futures | 16997.18 | 17018.06 | 16969.63 | 17009.36 | 4600.0 |
| 2022-03-22 19:00:00 | NQ | Futures | 17009.94 | 17014.87 | 16993.99 | 17011.68 | 2398.0 |
| 2022-03-22 20:00:00 | NQ | Futures | 17011.1 | 17023.85 | 16971.66 | 16978.33 | 4152.0 |
| 2022-03-22 21:00:00 | NQ | Futures | 16978.33 | 16993.41 | 16970.21 | 16990.22 | 3537.0 |
| 2022-03-22 22:00:00 | NQ | Futures | 16991.09 | 17020.38 | 16963.83 | 17009.36 | 4950.0 |
| 2022-03-22 23:00:00 | NQ | Futures | 17010.52 | 17015.74 | 16991.67 | 16994.86 | 1987.0 |
| 2022-03-22 00:00:00 | YM | Futures | 38781.3 | 38807.2 | 38761.0 | 38776.8 | 506.0 |
| 2022-03-22 01:00:00 | YM | Futures | 38779.1 | 38798.2 | 38740.7 | 38782.4 | 1059.0 |
| 2022-03-22 02:00:00 | YM | Futures | 38784.7 | 38826.4 | 38772.3 | 38794.8 | 754.0 |
| 2022-03-22 03:00:00 | YM | Futures | 38796.0 | 38876.0 | 38780.2 | 38871.5 | 1485.0 |
> showing 50 of 2,053 rows — these rows as CSV