PREVIEW / futures_30min / 2022-03-29
file: by_date/futures_30min/2022/2022-03-29.parquet size: 119 KB rows: 3,946
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-29 00:00:00 | ES | Futures | 5181.0 | 5182.7 | 5180.44 | 5181.0 | 1637.0 |
| 2022-03-29 00:30:00 | ES | Futures | 5181.0 | 5182.99 | 5180.15 | 5182.7 | 1322.0 |
| 2022-03-29 01:00:00 | ES | Futures | 5182.7 | 5185.82 | 5180.44 | 5185.54 | 2175.0 |
| 2022-03-29 01:30:00 | ES | Futures | 5185.54 | 5194.33 | 5185.26 | 5193.76 | 7480.0 |
| 2022-03-29 02:00:00 | ES | Futures | 5193.76 | 5194.33 | 5184.4 | 5184.69 | 6510.0 |
| 2022-03-29 02:30:00 | ES | Futures | 5184.69 | 5194.89 | 5183.55 | 5192.62 | 4316.0 |
| 2022-03-29 03:00:00 | ES | Futures | 5192.91 | 5196.88 | 5182.14 | 5194.61 | 9847.0 |
| 2022-03-29 03:30:00 | ES | Futures | 5194.89 | 5195.46 | 5188.37 | 5191.21 | 5599.0 |
| 2022-03-29 04:00:00 | ES | Futures | 5190.92 | 5195.74 | 5189.79 | 5192.62 | 5352.0 |
| 2022-03-29 04:30:00 | ES | Futures | 5192.91 | 5196.88 | 5190.64 | 5194.61 | 4963.0 |
| 2022-03-29 05:00:00 | ES | Futures | 5194.61 | 5205.95 | 5193.47 | 5199.43 | 17506.0 |
| 2022-03-29 05:30:00 | ES | Futures | 5199.43 | 5207.08 | 5198.58 | 5201.69 | 13752.0 |
| 2022-03-29 06:00:00 | ES | Futures | 5201.41 | 5202.26 | 5192.62 | 5198.58 | 7624.0 |
| 2022-03-29 06:30:00 | ES | Futures | 5198.58 | 5202.54 | 5196.59 | 5198.29 | 5170.0 |
| 2022-03-29 07:00:00 | ES | Futures | 5198.01 | 5202.54 | 5196.03 | 5196.31 | 6100.0 |
| 2022-03-29 07:30:00 | ES | Futures | 5196.59 | 5213.6 | 5193.19 | 5208.5 | 49285.0 |
| 2022-03-29 08:00:00 | ES | Futures | 5208.5 | 5228.05 | 5206.23 | 5225.79 | 39513.0 |
| 2022-03-29 08:30:00 | ES | Futures | 5225.79 | 5225.79 | 5217.57 | 5222.95 | 24970.0 |
| 2022-03-29 09:00:00 | ES | Futures | 5222.95 | 5227.49 | 5218.7 | 5226.64 | 23870.0 |
| 2022-03-29 09:30:00 | ES | Futures | 5226.64 | 5241.38 | 5211.62 | 5218.98 | 170040.0 |
| 2022-03-29 10:00:00 | ES | Futures | 5218.7 | 5223.52 | 5194.61 | 5212.18 | 125446.0 |
| 2022-03-29 10:30:00 | ES | Futures | 5212.18 | 5220.4 | 5199.99 | 5217.57 | 100014.0 |
| 2022-03-29 11:00:00 | ES | Futures | 5217.85 | 5221.54 | 5207.08 | 5219.27 | 58149.0 |
| 2022-03-29 11:30:00 | ES | Futures | 5219.27 | 5226.64 | 5216.43 | 5220.4 | 51556.0 |
| 2022-03-29 12:00:00 | ES | Futures | 5220.69 | 5221.25 | 5205.66 | 5208.21 | 41639.0 |
| 2022-03-29 12:30:00 | ES | Futures | 5207.93 | 5213.03 | 5198.29 | 5207.65 | 53344.0 |
| 2022-03-29 13:00:00 | ES | Futures | 5207.65 | 5208.5 | 5199.99 | 5205.95 | 35166.0 |
| 2022-03-29 13:30:00 | ES | Futures | 5206.23 | 5221.82 | 5203.68 | 5221.54 | 41243.0 |
| 2022-03-29 14:00:00 | ES | Futures | 5221.54 | 5225.5 | 5216.43 | 5224.94 | 40100.0 |
| 2022-03-29 14:30:00 | ES | Futures | 5224.65 | 5236.27 | 5223.52 | 5233.44 | 50124.0 |
| 2022-03-29 15:00:00 | ES | Futures | 5233.44 | 5244.49 | 5230.61 | 5244.21 | 64087.0 |
| 2022-03-29 15:30:00 | ES | Futures | 5244.21 | 5250.45 | 5234.01 | 5245.91 | 161540.0 |
| 2022-03-29 16:00:00 | ES | Futures | 5245.91 | 5246.19 | 5237.41 | 5239.39 | 50275.0 |
| 2022-03-29 16:30:00 | ES | Futures | 5239.39 | 5242.23 | 5238.83 | 5239.39 | 4176.0 |
| 2022-03-29 18:00:00 | ES | Futures | 5239.39 | 5239.68 | 5233.72 | 5236.84 | 4196.0 |
| 2022-03-29 18:30:00 | ES | Futures | 5237.12 | 5240.24 | 5236.84 | 5237.41 | 3127.0 |
| 2022-03-29 19:00:00 | ES | Futures | 5237.69 | 5239.39 | 5236.84 | 5238.26 | 1915.0 |
| 2022-03-29 19:30:00 | ES | Futures | 5238.26 | 5240.24 | 5236.56 | 5239.68 | 2896.0 |
| 2022-03-29 20:00:00 | ES | Futures | 5239.68 | 5239.68 | 5233.72 | 5238.26 | 3990.0 |
| 2022-03-29 20:30:00 | ES | Futures | 5238.26 | 5240.24 | 5235.14 | 5236.27 | 3115.0 |
| 2022-03-29 21:00:00 | ES | Futures | 5236.27 | 5243.08 | 5234.57 | 5241.38 | 5734.0 |
| 2022-03-29 21:30:00 | ES | Futures | 5241.38 | 5246.48 | 5238.54 | 5239.39 | 4872.0 |
| 2022-03-29 22:00:00 | ES | Futures | 5239.68 | 5239.96 | 5236.84 | 5237.12 | 2439.0 |
| 2022-03-29 22:30:00 | ES | Futures | 5237.12 | 5237.41 | 5234.01 | 5234.86 | 3072.0 |
| 2022-03-29 23:00:00 | ES | Futures | 5235.14 | 5238.83 | 5235.14 | 5238.54 | 2595.0 |
| 2022-03-29 23:30:00 | ES | Futures | 5238.54 | 5239.11 | 5235.99 | 5236.27 | 2405.0 |
| 2022-03-29 00:00:00 | NQ | Futures | 17362.26 | 17372.69 | 17357.62 | 17363.71 | 1277.0 |
| 2022-03-29 00:30:00 | NQ | Futures | 17364.0 | 17370.96 | 17358.49 | 17368.06 | 1751.0 |
| 2022-03-29 01:00:00 | NQ | Futures | 17368.06 | 17383.42 | 17355.3 | 17381.1 | 2222.0 |
| 2022-03-29 01:30:00 | NQ | Futures | 17382.26 | 17430.11 | 17381.68 | 17428.37 | 4675.0 |
> showing 50 of 3,946 rows — these rows as CSV