PREVIEW / futures_1hour / 2022-03-29
file: by_date/futures_1hour/2022/2022-03-29.parquet size: 71 KB rows: 2,075
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.99 | 5180.15 | 5182.7 | 2959.0 |
| 2022-03-29 01:00:00 | ES | Futures | 5182.7 | 5194.33 | 5180.44 | 5193.76 | 9655.0 |
| 2022-03-29 02:00:00 | ES | Futures | 5193.76 | 5194.89 | 5183.55 | 5192.62 | 10826.0 |
| 2022-03-29 03:00:00 | ES | Futures | 5192.91 | 5196.88 | 5182.14 | 5191.21 | 15446.0 |
| 2022-03-29 04:00:00 | ES | Futures | 5190.92 | 5196.88 | 5189.79 | 5194.61 | 10315.0 |
| 2022-03-29 05:00:00 | ES | Futures | 5194.61 | 5207.08 | 5193.47 | 5201.69 | 31258.0 |
| 2022-03-29 06:00:00 | ES | Futures | 5201.41 | 5202.54 | 5192.62 | 5198.29 | 12794.0 |
| 2022-03-29 07:00:00 | ES | Futures | 5198.01 | 5213.6 | 5193.19 | 5208.5 | 55385.0 |
| 2022-03-29 08:00:00 | ES | Futures | 5208.5 | 5228.05 | 5206.23 | 5222.95 | 64483.0 |
| 2022-03-29 09:00:00 | ES | Futures | 5222.95 | 5241.38 | 5211.62 | 5218.98 | 193910.0 |
| 2022-03-29 10:00:00 | ES | Futures | 5218.7 | 5223.52 | 5194.61 | 5217.57 | 225460.0 |
| 2022-03-29 11:00:00 | ES | Futures | 5217.85 | 5226.64 | 5207.08 | 5220.4 | 109705.0 |
| 2022-03-29 12:00:00 | ES | Futures | 5220.69 | 5221.25 | 5198.29 | 5207.65 | 94983.0 |
| 2022-03-29 13:00:00 | ES | Futures | 5207.65 | 5221.82 | 5199.99 | 5221.54 | 76409.0 |
| 2022-03-29 14:00:00 | ES | Futures | 5221.54 | 5236.27 | 5216.43 | 5233.44 | 90224.0 |
| 2022-03-29 15:00:00 | ES | Futures | 5233.44 | 5250.45 | 5230.61 | 5245.91 | 225627.0 |
| 2022-03-29 16:00:00 | ES | Futures | 5245.91 | 5246.19 | 5237.41 | 5239.39 | 54451.0 |
| 2022-03-29 18:00:00 | ES | Futures | 5239.39 | 5240.24 | 5233.72 | 5237.41 | 7323.0 |
| 2022-03-29 19:00:00 | ES | Futures | 5237.69 | 5240.24 | 5236.56 | 5239.68 | 4811.0 |
| 2022-03-29 20:00:00 | ES | Futures | 5239.68 | 5240.24 | 5233.72 | 5236.27 | 7105.0 |
| 2022-03-29 21:00:00 | ES | Futures | 5236.27 | 5246.48 | 5234.57 | 5239.39 | 10606.0 |
| 2022-03-29 22:00:00 | ES | Futures | 5239.68 | 5239.96 | 5234.01 | 5234.86 | 5511.0 |
| 2022-03-29 23:00:00 | ES | Futures | 5235.14 | 5239.11 | 5235.14 | 5236.27 | 5000.0 |
| 2022-03-29 00:00:00 | NQ | Futures | 17362.26 | 17372.69 | 17357.62 | 17368.06 | 3028.0 |
| 2022-03-29 01:00:00 | NQ | Futures | 17368.06 | 17430.11 | 17355.3 | 17428.37 | 6897.0 |
| 2022-03-29 02:00:00 | NQ | Futures | 17428.95 | 17442.0 | 17392.99 | 17433.3 | 5664.0 |
| 2022-03-29 03:00:00 | NQ | Futures | 17434.17 | 17445.77 | 17385.16 | 17408.36 | 9384.0 |
| 2022-03-29 04:00:00 | NQ | Futures | 17407.78 | 17435.04 | 17403.14 | 17423.73 | 5772.0 |
| 2022-03-29 05:00:00 | NQ | Futures | 17423.44 | 17495.06 | 17416.77 | 17461.14 | 17500.0 |
| 2022-03-29 06:00:00 | NQ | Futures | 17460.85 | 17464.91 | 17420.54 | 17429.24 | 6987.0 |
| 2022-03-29 07:00:00 | NQ | Futures | 17429.53 | 17514.78 | 17413.58 | 17499.99 | 19128.0 |
| 2022-03-29 08:00:00 | NQ | Futures | 17499.41 | 17592.5 | 17491.29 | 17586.41 | 29603.0 |
| 2022-03-29 09:00:00 | NQ | Futures | 17586.99 | 17653.1 | 17521.45 | 17575.1 | 85729.0 |
| 2022-03-29 10:00:00 | NQ | Futures | 17575.1 | 17610.76 | 17436.2 | 17547.55 | 101911.0 |
| 2022-03-29 11:00:00 | NQ | Futures | 17547.84 | 17598.01 | 17495.93 | 17570.46 | 50151.0 |
| 2022-03-29 12:00:00 | NQ | Futures | 17571.33 | 17580.03 | 17490.13 | 17543.49 | 42506.0 |
| 2022-03-29 13:00:00 | NQ | Futures | 17542.62 | 17619.17 | 17502.89 | 17614.53 | 36712.0 |
| 2022-03-29 14:00:00 | NQ | Futures | 17614.82 | 17664.7 | 17581.19 | 17655.13 | 36614.0 |
| 2022-03-29 15:00:00 | NQ | Futures | 17654.84 | 17710.23 | 17633.96 | 17678.62 | 62372.0 |
| 2022-03-29 16:00:00 | NQ | Futures | 17678.62 | 17685.58 | 17651.07 | 17658.61 | 13485.0 |
| 2022-03-29 18:00:00 | NQ | Futures | 17656.0 | 17662.96 | 17632.8 | 17642.08 | 3479.0 |
| 2022-03-29 19:00:00 | NQ | Futures | 17642.37 | 17660.93 | 17639.76 | 17656.29 | 2609.0 |
| 2022-03-29 20:00:00 | NQ | Futures | 17655.13 | 17671.08 | 17633.38 | 17655.42 | 3663.0 |
| 2022-03-29 21:00:00 | NQ | Futures | 17654.26 | 17702.69 | 17650.78 | 17665.57 | 5605.0 |
| 2022-03-29 22:00:00 | NQ | Futures | 17666.44 | 17671.08 | 17646.43 | 17647.3 | 2879.0 |
| 2022-03-29 23:00:00 | NQ | Futures | 17647.01 | 17666.73 | 17646.72 | 17651.36 | 2668.0 |
| 2022-03-29 00:00:00 | YM | Futures | 39316.8 | 39331.4 | 39311.2 | 39329.2 | 357.0 |
| 2022-03-29 01:00:00 | YM | Futures | 39328.1 | 39391.2 | 39317.9 | 39385.6 | 1442.0 |
| 2022-03-29 02:00:00 | YM | Futures | 39386.7 | 39392.3 | 39304.4 | 39372.0 | 2053.0 |
| 2022-03-29 03:00:00 | YM | Futures | 39376.5 | 39420.5 | 39310.0 | 39394.6 | 3666.0 |
> showing 50 of 2,075 rows — these rows as CSV