PREVIEW / futures_30min / 2024-01-19
file: by_date/futures_30min/2024/2024-01-19.parquet size: 92 KB rows: 3,147
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-19 00:00:00 | ES | Futures | 5172.52 | 5173.86 | 5172.25 | 5173.59 | 1356.0 |
| 2024-01-19 00:30:00 | ES | Futures | 5173.32 | 5173.86 | 5169.29 | 5169.83 | 2535.0 |
| 2024-01-19 01:00:00 | ES | Futures | 5169.56 | 5172.79 | 5169.56 | 5171.17 | 2693.0 |
| 2024-01-19 01:30:00 | ES | Futures | 5171.17 | 5173.86 | 5170.91 | 5172.52 | 3024.0 |
| 2024-01-19 02:00:00 | ES | Futures | 5172.52 | 5179.77 | 5171.17 | 5177.62 | 7952.0 |
| 2024-01-19 02:30:00 | ES | Futures | 5177.62 | 5181.11 | 5176.82 | 5179.5 | 6872.0 |
| 2024-01-19 03:00:00 | ES | Futures | 5179.77 | 5180.58 | 5176.82 | 5178.43 | 10541.0 |
| 2024-01-19 03:30:00 | ES | Futures | 5178.43 | 5183.53 | 5176.01 | 5182.99 | 9390.0 |
| 2024-01-19 04:00:00 | ES | Futures | 5182.99 | 5191.05 | 5182.46 | 5190.24 | 17209.0 |
| 2024-01-19 04:30:00 | ES | Futures | 5189.98 | 5189.98 | 5182.46 | 5188.9 | 10623.0 |
| 2024-01-19 05:00:00 | ES | Futures | 5188.9 | 5189.44 | 5185.68 | 5187.02 | 6606.0 |
| 2024-01-19 05:30:00 | ES | Futures | 5187.02 | 5191.86 | 5185.95 | 5189.98 | 7413.0 |
| 2024-01-19 06:00:00 | ES | Futures | 5189.71 | 5192.66 | 5188.9 | 5191.59 | 7703.0 |
| 2024-01-19 06:30:00 | ES | Futures | 5191.32 | 5195.35 | 5191.05 | 5194.27 | 10711.0 |
| 2024-01-19 07:00:00 | ES | Futures | 5194.01 | 5194.54 | 5189.98 | 5190.51 | 10260.0 |
| 2024-01-19 07:30:00 | ES | Futures | 5190.24 | 5195.62 | 5188.63 | 5194.81 | 11709.0 |
| 2024-01-19 08:00:00 | ES | Futures | 5194.81 | 5201.26 | 5194.81 | 5196.15 | 23470.0 |
| 2024-01-19 08:30:00 | ES | Futures | 5196.15 | 5198.3 | 5189.17 | 5190.51 | 24727.0 |
| 2024-01-19 09:00:00 | ES | Futures | 5190.51 | 5191.59 | 5179.5 | 5180.58 | 49082.0 |
| 2024-01-19 09:30:00 | ES | Futures | 5180.58 | 5184.34 | 5173.05 | 5183.26 | 184030.0 |
| 2024-01-19 10:00:00 | ES | Futures | 5183.53 | 5188.9 | 5173.59 | 5184.07 | 156499.0 |
| 2024-01-19 10:30:00 | ES | Futures | 5183.8 | 5191.32 | 5177.35 | 5187.56 | 96337.0 |
| 2024-01-19 11:00:00 | ES | Futures | 5187.83 | 5199.11 | 5184.87 | 5194.01 | 109179.0 |
| 2024-01-19 11:30:00 | ES | Futures | 5194.27 | 5195.08 | 5187.02 | 5194.54 | 84232.0 |
| 2024-01-19 12:00:00 | ES | Futures | 5194.54 | 5200.99 | 5187.83 | 5199.91 | 76054.0 |
| 2024-01-19 12:30:00 | ES | Futures | 5199.91 | 5209.05 | 5198.84 | 5208.78 | 101076.0 |
| 2024-01-19 13:00:00 | ES | Futures | 5209.05 | 5217.91 | 5203.67 | 5217.37 | 85681.0 |
| 2024-01-19 13:30:00 | ES | Futures | 5217.37 | 5225.43 | 5217.1 | 5225.16 | 69721.0 |
| 2024-01-19 14:00:00 | ES | Futures | 5225.43 | 5236.71 | 5223.55 | 5228.12 | 103448.0 |
| 2024-01-19 14:30:00 | ES | Futures | 5228.38 | 5231.34 | 5221.13 | 5230.8 | 89683.0 |
| 2024-01-19 15:00:00 | ES | Futures | 5231.07 | 5234.56 | 5226.24 | 5230.0 | 74895.0 |
| 2024-01-19 15:30:00 | ES | Futures | 5230.0 | 5234.03 | 5226.77 | 5232.95 | 159820.0 |
| 2024-01-19 16:00:00 | ES | Futures | 5232.95 | 5236.44 | 5229.46 | 5235.37 | 61160.0 |
| 2024-01-19 16:30:00 | ES | Futures | 5235.1 | 5236.71 | 5231.88 | 5231.88 | 40715.0 |
| 2024-01-19 00:00:00 | NQ | Futures | 18625.59 | 18632.91 | 18621.25 | 18625.32 | 1251.0 |
| 2024-01-19 00:30:00 | NQ | Futures | 18625.32 | 18626.94 | 18602.26 | 18604.43 | 2190.0 |
| 2024-01-19 01:00:00 | NQ | Futures | 18604.43 | 18619.89 | 18603.62 | 18609.32 | 2083.0 |
| 2024-01-19 01:30:00 | NQ | Futures | 18609.86 | 18622.88 | 18607.69 | 18619.35 | 2034.0 |
| 2024-01-19 02:00:00 | NQ | Futures | 18619.62 | 18649.45 | 18607.15 | 18632.91 | 5550.0 |
| 2024-01-19 02:30:00 | NQ | Futures | 18632.37 | 18647.83 | 18627.76 | 18643.22 | 4660.0 |
| 2024-01-19 03:00:00 | NQ | Futures | 18642.13 | 18646.47 | 18624.5 | 18634.81 | 5359.0 |
| 2024-01-19 03:30:00 | NQ | Futures | 18634.54 | 18670.88 | 18624.5 | 18669.79 | 5758.0 |
| 2024-01-19 04:00:00 | NQ | Futures | 18669.52 | 18698.81 | 18661.12 | 18694.75 | 8507.0 |
| 2024-01-19 04:30:00 | NQ | Futures | 18694.75 | 18695.02 | 18660.57 | 18687.42 | 5832.0 |
| 2024-01-19 05:00:00 | NQ | Futures | 18687.42 | 18688.24 | 18673.59 | 18679.83 | 3397.0 |
| 2024-01-19 05:30:00 | NQ | Futures | 18680.64 | 18707.49 | 18678.47 | 18697.19 | 4105.0 |
| 2024-01-19 06:00:00 | NQ | Futures | 18697.46 | 18704.51 | 18689.86 | 18699.08 | 3563.0 |
| 2024-01-19 06:30:00 | NQ | Futures | 18699.08 | 18717.26 | 18696.64 | 18710.2 | 5581.0 |
| 2024-01-19 07:00:00 | NQ | Futures | 18709.12 | 18712.65 | 18678.47 | 18684.17 | 6286.0 |
| 2024-01-19 07:30:00 | NQ | Futures | 18683.9 | 18703.42 | 18670.07 | 18700.17 | 7179.0 |
> showing 50 of 3,147 rows — these rows as CSV