PREVIEW / futures_30min / 2023-05-28
file: by_date/futures_30min/2023/2023-05-28.parquet size: 26 KB rows: 699
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-28 18:00:00 | ES | Futures | 4703.64 | 4707.52 | 4693.1 | 4696.7 | 14080.0 |
| 2023-05-28 18:30:00 | ES | Futures | 4696.7 | 4697.81 | 4692.54 | 4693.93 | 3885.0 |
| 2023-05-28 19:00:00 | ES | Futures | 4694.21 | 4695.59 | 4693.1 | 4694.21 | 2178.0 |
| 2023-05-28 19:30:00 | ES | Futures | 4693.93 | 4695.59 | 4692.82 | 4693.65 | 2657.0 |
| 2023-05-28 20:00:00 | ES | Futures | 4693.65 | 4697.81 | 4689.77 | 4690.05 | 7337.0 |
| 2023-05-28 20:30:00 | ES | Futures | 4690.05 | 4690.05 | 4686.99 | 4688.1 | 5055.0 |
| 2023-05-28 21:00:00 | ES | Futures | 4688.38 | 4689.49 | 4686.16 | 4687.27 | 4520.0 |
| 2023-05-28 21:30:00 | ES | Futures | 4687.55 | 4687.55 | 4684.22 | 4686.99 | 4065.0 |
| 2023-05-28 22:00:00 | ES | Futures | 4686.99 | 4689.21 | 4686.44 | 4686.72 | 2536.0 |
| 2023-05-28 22:30:00 | ES | Futures | 4686.72 | 4687.83 | 4685.61 | 4687.27 | 1977.0 |
| 2023-05-28 23:00:00 | ES | Futures | 4687.27 | 4689.21 | 4686.99 | 4688.94 | 2307.0 |
| 2023-05-28 23:30:00 | ES | Futures | 4688.66 | 4688.66 | 4683.94 | 4683.94 | 2938.0 |
| 2023-05-28 18:00:00 | NQ | Futures | 16259.69 | 16284.74 | 16217.45 | 16234.63 | 7198.0 |
| 2023-05-28 18:30:00 | NQ | Futures | 16235.19 | 16241.1 | 16224.77 | 16230.97 | 2113.0 |
| 2023-05-28 19:00:00 | NQ | Futures | 16230.97 | 16249.55 | 16227.59 | 16239.7 | 1889.0 |
| 2023-05-28 19:30:00 | NQ | Futures | 16238.85 | 16246.74 | 16236.04 | 16236.32 | 1485.0 |
| 2023-05-28 20:00:00 | NQ | Futures | 16236.6 | 16269.26 | 16234.35 | 16237.16 | 4654.0 |
| 2023-05-28 20:30:00 | NQ | Futures | 16237.16 | 16237.16 | 16217.45 | 16223.93 | 3435.0 |
| 2023-05-28 21:00:00 | NQ | Futures | 16223.08 | 16237.44 | 16217.45 | 16221.11 | 3337.0 |
| 2023-05-28 21:30:00 | NQ | Futures | 16221.4 | 16224.49 | 16202.53 | 16221.11 | 3406.0 |
| 2023-05-28 22:00:00 | NQ | Futures | 16220.83 | 16229.28 | 16210.98 | 16212.67 | 2051.0 |
| 2023-05-28 22:30:00 | NQ | Futures | 16212.39 | 16218.86 | 16207.6 | 16215.76 | 1424.0 |
| 2023-05-28 23:00:00 | NQ | Futures | 16216.05 | 16221.68 | 16211.54 | 16221.68 | 1333.0 |
| 2023-05-28 23:30:00 | NQ | Futures | 16221.4 | 16221.4 | 16209.01 | 16209.85 | 1414.0 |
| 2023-05-28 18:00:00 | YM | Futures | 36783.6 | 36839.9 | 36738.2 | 36761.5 | 1577.0 |
| 2023-05-28 18:30:00 | YM | Futures | 36763.7 | 36768.1 | 36731.6 | 36742.7 | 571.0 |
| 2023-05-28 19:00:00 | YM | Futures | 36744.9 | 36749.3 | 36733.8 | 36740.5 | 442.0 |
| 2023-05-28 19:30:00 | YM | Futures | 36740.5 | 36761.5 | 36737.1 | 36742.7 | 560.0 |
| 2023-05-28 20:00:00 | YM | Futures | 36741.6 | 36757.0 | 36707.3 | 36709.5 | 670.0 |
| 2023-05-28 20:30:00 | YM | Futures | 36710.6 | 36710.6 | 36689.6 | 36697.3 | 480.0 |
| 2023-05-28 21:00:00 | YM | Futures | 36700.7 | 36700.7 | 36681.9 | 36692.9 | 381.0 |
| 2023-05-28 21:30:00 | YM | Futures | 36694.0 | 36695.1 | 36674.1 | 36685.2 | 399.0 |
| 2023-05-28 22:00:00 | YM | Futures | 36685.2 | 36699.6 | 36684.1 | 36688.5 | 290.0 |
| 2023-05-28 22:30:00 | YM | Futures | 36689.6 | 36694.0 | 36681.9 | 36684.1 | 197.0 |
| 2023-05-28 23:00:00 | YM | Futures | 36685.2 | 36695.1 | 36683.0 | 36689.6 | 196.0 |
| 2023-05-28 23:30:00 | YM | Futures | 36688.5 | 36689.6 | 36656.4 | 36657.6 | 281.0 |
| 2023-05-28 18:00:00 | CL | Futures | 59.57 | 59.77 | 59.44 | 59.64 | 2235.0 |
| 2023-05-28 18:30:00 | CL | Futures | 59.64 | 59.67 | 59.51 | 59.52 | 477.0 |
| 2023-05-28 19:00:00 | CL | Futures | 59.53 | 59.54 | 59.44 | 59.54 | 360.0 |
| 2023-05-28 19:30:00 | CL | Futures | 59.53 | 59.57 | 59.5 | 59.56 | 326.0 |
| 2023-05-28 20:00:00 | CL | Futures | 59.57 | 59.61 | 59.53 | 59.57 | 922.0 |
| 2023-05-28 20:30:00 | CL | Futures | 59.57 | 59.62 | 59.53 | 59.58 | 1020.0 |
| 2023-05-28 21:00:00 | CL | Futures | 59.57 | 59.77 | 59.45 | 59.67 | 2554.0 |
| 2023-05-28 21:30:00 | CL | Futures | 59.68 | 59.73 | 59.58 | 59.7 | 1013.0 |
| 2023-05-28 22:00:00 | CL | Futures | 59.71 | 59.8 | 59.7 | 59.74 | 1180.0 |
| 2023-05-28 22:30:00 | CL | Futures | 59.74 | 59.83 | 59.66 | 59.68 | 959.0 |
| 2023-05-28 23:00:00 | CL | Futures | 59.68 | 59.72 | 59.61 | 59.66 | 493.0 |
| 2023-05-28 23:30:00 | CL | Futures | 59.65 | 59.66 | 59.59 | 59.61 | 381.0 |
| 2023-05-28 18:00:00 | GC | Futures | 2234.2 | 2237.7 | 2232.6 | 2235.7 | 1941.0 |
| 2023-05-28 18:30:00 | GC | Futures | 2235.5 | 2236.3 | 2234.3 | 2235.0 | 364.0 |
> showing 50 of 699 rows — these rows as CSV