PREVIEW / etf_30min / 2024-09-18
file: by_date/etf_30min/2024/2024-09-18.parquet size: 832 KB rows: 33,087
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-09-18 04:00:00 | SPY | ETF | 563.27 | 563.27 | 562.94 | 562.94 | 31208.0 |
| 2024-09-18 04:30:00 | SPY | ETF | 562.91 | 563.37 | 562.91 | 563.37 | 2193.0 |
| 2024-09-18 05:00:00 | SPY | ETF | 563.36 | 563.51 | 563.31 | 563.51 | 1010.0 |
| 2024-09-18 05:30:00 | SPY | ETF | 563.69 | 563.92 | 563.69 | 563.92 | 1375.0 |
| 2024-09-18 06:00:00 | SPY | ETF | 563.85 | 563.85 | 563.66 | 563.83 | 19158.0 |
| 2024-09-18 06:30:00 | SPY | ETF | 563.82 | 563.97 | 563.78 | 563.84 | 3518.0 |
| 2024-09-18 07:00:00 | SPY | ETF | 563.84 | 563.95 | 563.63 | 563.76 | 46981.0 |
| 2024-09-18 07:30:00 | SPY | ETF | 563.84 | 563.91 | 563.45 | 563.45 | 10183.0 |
| 2024-09-18 08:00:00 | SPY | ETF | 563.86 | 564.0 | 562.94 | 563.51 | 79936.0 |
| 2024-09-18 08:30:00 | SPY | ETF | 563.51 | 564.1 | 563.51 | 563.75 | 52096.0 |
| 2024-09-18 09:00:00 | SPY | ETF | 563.97 | 564.01 | 563.61 | 563.71 | 90611.0 |
| 2024-09-18 09:30:00 | SPY | ETF | 563.74 | 563.93 | 562.53 | 563.0 | 2192513.0 |
| 2024-09-18 10:00:00 | SPY | ETF | 563.02 | 563.26 | 562.13 | 563.13 | 1710259.0 |
| 2024-09-18 10:30:00 | SPY | ETF | 563.12 | 563.35 | 562.42 | 562.8 | 1002692.0 |
| 2024-09-18 11:00:00 | SPY | ETF | 562.79 | 563.16 | 562.25 | 562.76 | 821570.0 |
| 2024-09-18 11:30:00 | SPY | ETF | 562.75 | 562.77 | 561.55 | 561.6406 | 1170385.0 |
| 2024-09-18 12:00:00 | SPY | ETF | 561.63 | 563.07 | 561.34 | 563.0032 | 840674.0 |
| 2024-09-18 12:30:00 | SPY | ETF | 563.019 | 563.715 | 562.81 | 563.62 | 839742.0 |
| 2024-09-18 13:00:00 | SPY | ETF | 563.63 | 563.73 | 563.0105 | 563.72 | 769983.0 |
| 2024-09-18 13:30:00 | SPY | ETF | 563.71 | 564.275 | 562.85 | 563.15 | 1429092.0 |
| 2024-09-18 14:00:00 | SPY | ETF | 563.14 | 568.69 | 561.8 | 565.9 | 9269008.0 |
| 2024-09-18 14:30:00 | SPY | ETF | 565.93 | 566.98 | 563.37 | 563.79 | 5120464.0 |
| 2024-09-18 15:00:00 | SPY | ETF | 563.81 | 565.86 | 561.61 | 564.94 | 5321447.0 |
| 2024-09-18 15:30:00 | SPY | ETF | 564.94 | 565.53 | 560.83 | 561.33 | 6184464.0 |
| 2024-09-18 16:00:00 | SPY | ETF | 561.31 | 562.86 | 561.05 | 562.56 | 3848900.0 |
| 2024-09-18 16:30:00 | SPY | ETF | 562.59 | 562.8 | 562.01 | 562.2835 | 157173.0 |
| 2024-09-18 17:00:00 | SPY | ETF | 562.2 | 562.5 | 562.19 | 562.49 | 51584.0 |
| 2024-09-18 17:30:00 | SPY | ETF | 562.49 | 562.59 | 561.4 | 561.4 | 77289.0 |
| 2024-09-18 18:00:00 | SPY | ETF | 562.48 | 563.33 | 562.44 | 563.33 | 103406.0 |
| 2024-09-18 18:30:00 | SPY | ETF | 563.36 | 563.4676 | 563.0 | 563.0314 | 55966.0 |
| 2024-09-18 19:00:00 | SPY | ETF | 563.24 | 563.4 | 562.64 | 562.78 | 66622.0 |
| 2024-09-18 19:30:00 | SPY | ETF | 562.63 | 565.13 | 562.6 | 565.0 | 71138.0 |
| 2024-09-18 04:00:00 | QQQ | ETF | 473.98 | 473.99 | 473.11 | 473.19 | 31191.0 |
| 2024-09-18 04:30:00 | QQQ | ETF | 473.1 | 473.68 | 473.01 | 473.65 | 10143.0 |
| 2024-09-18 05:00:00 | QQQ | ETF | 473.61 | 473.95 | 473.61 | 473.89 | 7933.0 |
| 2024-09-18 05:30:00 | QQQ | ETF | 473.97 | 474.25 | 473.93 | 474.25 | 3693.0 |
| 2024-09-18 06:00:00 | QQQ | ETF | 474.32 | 474.32 | 473.99 | 474.07 | 23681.0 |
| 2024-09-18 06:30:00 | QQQ | ETF | 474.07 | 474.33 | 474.0 | 474.3 | 37019.0 |
| 2024-09-18 07:00:00 | QQQ | ETF | 474.3 | 474.68 | 474.24 | 474.39 | 31923.0 |
| 2024-09-18 07:30:00 | QQQ | ETF | 474.49 | 474.49 | 474.06 | 474.12 | 14018.0 |
| 2024-09-18 08:00:00 | QQQ | ETF | 474.34 | 474.65 | 473.13 | 474.02 | 131878.0 |
| 2024-09-18 08:30:00 | QQQ | ETF | 474.0 | 474.73 | 474.0 | 474.61 | 77222.0 |
| 2024-09-18 09:00:00 | QQQ | ETF | 474.64 | 474.84 | 474.5 | 474.74 | 96092.0 |
| 2024-09-18 09:30:00 | QQQ | ETF | 474.7 | 474.8299 | 473.19 | 474.2 | 1761661.0 |
| 2024-09-18 10:00:00 | QQQ | ETF | 474.22 | 474.38 | 472.74 | 473.9888 | 1276652.0 |
| 2024-09-18 10:30:00 | QQQ | ETF | 473.9493 | 474.57 | 473.33 | 473.76 | 912970.0 |
| 2024-09-18 11:00:00 | QQQ | ETF | 473.76 | 474.1896 | 472.45 | 473.165 | 1034740.0 |
| 2024-09-18 11:30:00 | QQQ | ETF | 473.15 | 473.15 | 471.31 | 471.5762 | 880360.0 |
| 2024-09-18 12:00:00 | QQQ | ETF | 471.55 | 473.3799 | 471.25 | 473.3099 | 854763.0 |
| 2024-09-18 12:30:00 | QQQ | ETF | 473.3 | 474.28 | 472.88 | 474.13 | 812715.0 |
> showing 50 of 33,087 rows — these rows as CSV