PREVIEW / futures_1hour / 2022-03-30
file: by_date/futures_1hour/2022/2022-03-30.parquet size: 68 KB rows: 2,049
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-30 00:00:00 | ES | Futures | 5236.27 | 5239.11 | 5230.61 | 5234.01 | 6035.0 |
| 2022-03-30 01:00:00 | ES | Futures | 5234.01 | 5245.91 | 5231.74 | 5245.63 | 9297.0 |
| 2022-03-30 02:00:00 | ES | Futures | 5245.63 | 5246.48 | 5236.84 | 5241.38 | 7867.0 |
| 2022-03-30 03:00:00 | ES | Futures | 5241.09 | 5241.94 | 5226.92 | 5232.02 | 14823.0 |
| 2022-03-30 04:00:00 | ES | Futures | 5232.31 | 5232.31 | 5220.69 | 5224.65 | 16162.0 |
| 2022-03-30 05:00:00 | ES | Futures | 5224.65 | 5231.17 | 5224.37 | 5230.32 | 8181.0 |
| 2022-03-30 06:00:00 | ES | Futures | 5230.61 | 5232.02 | 5220.97 | 5230.04 | 14189.0 |
| 2022-03-30 07:00:00 | ES | Futures | 5230.32 | 5234.57 | 5229.19 | 5232.02 | 10043.0 |
| 2022-03-30 08:00:00 | ES | Futures | 5232.02 | 5232.02 | 5217.57 | 5227.49 | 27397.0 |
| 2022-03-30 09:00:00 | ES | Futures | 5227.49 | 5238.54 | 5222.39 | 5237.41 | 126801.0 |
| 2022-03-30 10:00:00 | ES | Futures | 5237.41 | 5240.81 | 5224.37 | 5225.22 | 142350.0 |
| 2022-03-30 11:00:00 | ES | Futures | 5225.5 | 5227.77 | 5211.33 | 5223.24 | 129278.0 |
| 2022-03-30 12:00:00 | ES | Futures | 5222.95 | 5228.34 | 5216.43 | 5226.07 | 74557.0 |
| 2022-03-30 13:00:00 | ES | Futures | 5225.79 | 5226.35 | 5209.91 | 5211.33 | 77403.0 |
| 2022-03-30 14:00:00 | ES | Futures | 5211.62 | 5219.27 | 5201.69 | 5202.83 | 97312.0 |
| 2022-03-30 15:00:00 | ES | Futures | 5203.11 | 5213.32 | 5186.67 | 5213.03 | 293535.0 |
| 2022-03-30 16:00:00 | ES | Futures | 5213.32 | 5219.83 | 5211.05 | 5217.0 | 54831.0 |
| 2022-03-30 18:00:00 | ES | Futures | 5214.17 | 5217.57 | 5213.88 | 5216.15 | 3629.0 |
| 2022-03-30 19:00:00 | ES | Futures | 5216.15 | 5217.0 | 5212.75 | 5213.88 | 3495.0 |
| 2022-03-30 20:00:00 | ES | Futures | 5214.17 | 5231.46 | 5213.03 | 5229.76 | 14436.0 |
| 2022-03-30 21:00:00 | ES | Futures | 5229.76 | 5230.61 | 5225.79 | 5226.64 | 5765.0 |
| 2022-03-30 22:00:00 | ES | Futures | 5226.64 | 5230.04 | 5224.37 | 5226.64 | 5070.0 |
| 2022-03-30 23:00:00 | ES | Futures | 5226.64 | 5227.2 | 5221.25 | 5221.82 | 3666.0 |
| 2022-03-30 00:00:00 | NQ | Futures | 17651.65 | 17672.24 | 17636.28 | 17647.3 | 3323.0 |
| 2022-03-30 01:00:00 | NQ | Futures | 17646.43 | 17682.68 | 17635.12 | 17682.1 | 3693.0 |
| 2022-03-30 02:00:00 | NQ | Futures | 17681.52 | 17685.0 | 17639.18 | 17652.81 | 3831.0 |
| 2022-03-30 03:00:00 | NQ | Futures | 17653.68 | 17654.84 | 17595.69 | 17612.21 | 9143.0 |
| 2022-03-30 04:00:00 | NQ | Futures | 17612.5 | 17616.85 | 17569.01 | 17586.99 | 7720.0 |
| 2022-03-30 05:00:00 | NQ | Futures | 17588.44 | 17610.76 | 17586.7 | 17608.44 | 4793.0 |
| 2022-03-30 06:00:00 | NQ | Futures | 17608.73 | 17610.18 | 17562.92 | 17594.82 | 7242.0 |
| 2022-03-30 07:00:00 | NQ | Futures | 17595.11 | 17624.68 | 17592.5 | 17614.24 | 5040.0 |
| 2022-03-30 08:00:00 | NQ | Futures | 17615.98 | 17615.98 | 17545.81 | 17582.93 | 14418.0 |
| 2022-03-30 09:00:00 | NQ | Futures | 17582.35 | 17640.92 | 17561.18 | 17616.27 | 63300.0 |
| 2022-03-30 10:00:00 | NQ | Futures | 17616.85 | 17670.79 | 17573.65 | 17580.61 | 72905.0 |
| 2022-03-30 11:00:00 | NQ | Futures | 17581.19 | 17586.99 | 17510.14 | 17577.42 | 64488.0 |
| 2022-03-30 12:00:00 | NQ | Futures | 17577.42 | 17626.71 | 17548.13 | 17621.78 | 37876.0 |
| 2022-03-30 13:00:00 | NQ | Futures | 17621.2 | 17625.26 | 17540.01 | 17546.97 | 43936.0 |
| 2022-03-30 14:00:00 | NQ | Futures | 17546.1 | 17578.58 | 17485.5 | 17492.74 | 44469.0 |
| 2022-03-30 15:00:00 | NQ | Futures | 17493.03 | 17497.38 | 17412.71 | 17492.16 | 84192.0 |
| 2022-03-30 16:00:00 | NQ | Futures | 17491.87 | 17530.73 | 17490.42 | 17520.29 | 14292.0 |
| 2022-03-30 18:00:00 | NQ | Futures | 17515.07 | 17526.09 | 17511.01 | 17523.77 | 1951.0 |
| 2022-03-30 19:00:00 | NQ | Futures | 17523.48 | 17530.73 | 17511.88 | 17518.84 | 1750.0 |
| 2022-03-30 20:00:00 | NQ | Futures | 17519.13 | 17592.5 | 17514.49 | 17582.06 | 6699.0 |
| 2022-03-30 21:00:00 | NQ | Futures | 17582.93 | 17586.12 | 17563.79 | 17566.98 | 2981.0 |
| 2022-03-30 22:00:00 | NQ | Futures | 17565.53 | 17589.89 | 17556.25 | 17581.77 | 3128.0 |
| 2022-03-30 23:00:00 | NQ | Futures | 17582.93 | 17585.25 | 17563.21 | 17567.85 | 1709.0 |
| 2022-03-30 00:00:00 | YM | Futures | 39615.5 | 39629.1 | 39570.4 | 39589.6 | 812.0 |
| 2022-03-30 01:00:00 | YM | Futures | 39591.9 | 39678.7 | 39577.2 | 39677.5 | 1269.0 |
| 2022-03-30 02:00:00 | YM | Futures | 39678.7 | 39680.9 | 39630.2 | 39661.8 | 1385.0 |
| 2022-03-30 03:00:00 | YM | Futures | 39659.5 | 39664.0 | 39564.8 | 39603.1 | 2860.0 |
> showing 50 of 2,049 rows — these rows as CSV