PREVIEW / futures_1hour / 2022-04-21
file: by_date/futures_1hour/2022/2022-04-21.parquet size: 70 KB rows: 2,082
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-21 00:00:00 | ES | Futures | 5069.33 | 5073.58 | 5069.04 | 5073.3 | 2755.0 |
| 2022-04-21 01:00:00 | ES | Futures | 5073.3 | 5081.8 | 5070.46 | 5075.0 | 8369.0 |
| 2022-04-21 02:00:00 | ES | Futures | 5075.0 | 5075.56 | 5065.93 | 5073.58 | 10924.0 |
| 2022-04-21 03:00:00 | ES | Futures | 5073.86 | 5092.0 | 5068.48 | 5089.45 | 20503.0 |
| 2022-04-21 04:00:00 | ES | Futures | 5089.45 | 5094.84 | 5088.04 | 5093.14 | 15289.0 |
| 2022-04-21 05:00:00 | ES | Futures | 5093.14 | 5093.99 | 5084.07 | 5085.77 | 11183.0 |
| 2022-04-21 06:00:00 | ES | Futures | 5085.77 | 5094.27 | 5084.07 | 5093.14 | 10369.0 |
| 2022-04-21 07:00:00 | ES | Futures | 5093.14 | 5098.81 | 5088.6 | 5096.82 | 16681.0 |
| 2022-04-21 08:00:00 | ES | Futures | 5097.11 | 5099.37 | 5089.74 | 5098.81 | 22708.0 |
| 2022-04-21 09:00:00 | ES | Futures | 5098.52 | 5112.13 | 5093.7 | 5105.04 | 167709.0 |
| 2022-04-21 10:00:00 | ES | Futures | 5105.04 | 5105.61 | 5077.26 | 5081.8 | 200559.0 |
| 2022-04-21 11:00:00 | ES | Futures | 5081.8 | 5085.2 | 5051.47 | 5051.75 | 170305.0 |
| 2022-04-21 12:00:00 | ES | Futures | 5052.04 | 5056.01 | 5028.23 | 5028.51 | 158962.0 |
| 2022-04-21 13:00:00 | ES | Futures | 5028.51 | 5039.28 | 5013.77 | 5018.03 | 210688.0 |
| 2022-04-21 14:00:00 | ES | Futures | 5018.03 | 5020.29 | 4985.15 | 4989.4 | 207610.0 |
| 2022-04-21 15:00:00 | ES | Futures | 4989.4 | 4995.35 | 4965.87 | 4975.79 | 323391.0 |
| 2022-04-21 16:00:00 | ES | Futures | 4975.79 | 4978.06 | 4966.72 | 4972.39 | 61171.0 |
| 2022-04-21 18:00:00 | ES | Futures | 4972.39 | 4977.21 | 4968.14 | 4973.24 | 6267.0 |
| 2022-04-21 19:00:00 | ES | Futures | 4972.96 | 4975.23 | 4961.9 | 4963.32 | 8527.0 |
| 2022-04-21 20:00:00 | ES | Futures | 4963.6 | 4970.41 | 4945.46 | 4953.4 | 17926.0 |
| 2022-04-21 21:00:00 | ES | Futures | 4953.4 | 4959.92 | 4950.28 | 4958.79 | 14083.0 |
| 2022-04-21 22:00:00 | ES | Futures | 4958.79 | 4963.6 | 4956.24 | 4957.94 | 8760.0 |
| 2022-04-21 23:00:00 | ES | Futures | 4957.94 | 4961.62 | 4954.25 | 4960.2 | 6079.0 |
| 2022-04-21 00:00:00 | NQ | Futures | 16334.87 | 16352.56 | 16334.58 | 16348.5 | 1608.0 |
| 2022-04-21 01:00:00 | NQ | Futures | 16348.21 | 16393.16 | 16330.23 | 16351.11 | 6316.0 |
| 2022-04-21 02:00:00 | NQ | Futures | 16351.98 | 16352.56 | 16301.82 | 16341.25 | 7786.0 |
| 2022-04-21 03:00:00 | NQ | Futures | 16342.12 | 16421.0 | 16320.38 | 16409.69 | 10038.0 |
| 2022-04-21 04:00:00 | NQ | Futures | 16408.82 | 16441.59 | 16403.89 | 16440.72 | 8138.0 |
| 2022-04-21 05:00:00 | NQ | Futures | 16439.27 | 16445.64 | 16391.71 | 16395.77 | 5287.0 |
| 2022-04-21 06:00:00 | NQ | Futures | 16396.06 | 16438.98 | 16385.91 | 16427.38 | 5129.0 |
| 2022-04-21 07:00:00 | NQ | Futures | 16427.67 | 16457.82 | 16402.73 | 16451.15 | 8398.0 |
| 2022-04-21 08:00:00 | NQ | Futures | 16450.57 | 16463.33 | 16409.4 | 16451.73 | 12362.0 |
| 2022-04-21 09:00:00 | NQ | Futures | 16451.44 | 16566.85 | 16429.12 | 16476.38 | 82457.0 |
| 2022-04-21 10:00:00 | NQ | Futures | 16476.67 | 16491.46 | 16316.32 | 16347.92 | 95798.0 |
| 2022-04-21 11:00:00 | NQ | Futures | 16349.08 | 16383.3 | 16195.98 | 16198.01 | 77387.0 |
| 2022-04-21 12:00:00 | NQ | Futures | 16198.01 | 16223.52 | 16128.99 | 16137.69 | 60465.0 |
| 2022-04-21 13:00:00 | NQ | Futures | 16137.11 | 16181.77 | 16069.26 | 16082.02 | 74753.0 |
| 2022-04-21 14:00:00 | NQ | Futures | 16080.57 | 16080.57 | 15939.35 | 15959.07 | 81282.0 |
| 2022-04-21 15:00:00 | NQ | Futures | 15958.78 | 15972.41 | 15867.43 | 15916.15 | 98502.0 |
| 2022-04-21 16:00:00 | NQ | Futures | 15915.57 | 15933.26 | 15852.94 | 15908.61 | 22431.0 |
| 2022-04-21 18:00:00 | NQ | Futures | 15913.83 | 15922.53 | 15881.93 | 15908.32 | 4476.0 |
| 2022-04-21 19:00:00 | NQ | Futures | 15908.61 | 15916.73 | 15861.06 | 15869.46 | 4525.0 |
| 2022-04-21 20:00:00 | NQ | Futures | 15870.62 | 15899.33 | 15788.85 | 15816.98 | 10080.0 |
| 2022-04-21 21:00:00 | NQ | Futures | 15816.98 | 15860.48 | 15809.44 | 15844.24 | 7841.0 |
| 2022-04-21 22:00:00 | NQ | Futures | 15844.24 | 15879.9 | 15838.73 | 15855.26 | 4537.0 |
| 2022-04-21 23:00:00 | NQ | Futures | 15855.26 | 15873.52 | 15835.83 | 15870.04 | 3046.0 |
| 2022-04-21 00:00:00 | YM | Futures | 39646.0 | 39675.3 | 39642.6 | 39673.0 | 630.0 |
| 2022-04-21 01:00:00 | YM | Futures | 39674.2 | 39728.3 | 39659.5 | 39685.4 | 1982.0 |
| 2022-04-21 02:00:00 | YM | Futures | 39685.4 | 39692.2 | 39640.3 | 39685.4 | 2455.0 |
| 2022-04-21 03:00:00 | YM | Futures | 39687.7 | 39795.9 | 39644.8 | 39782.4 | 5935.0 |
> showing 50 of 2,082 rows — these rows as CSV