PREVIEW / etf_30min / 2026-05-27
file: by_date/etf_30min/2026/2026-05-27.parquet size: 1.1 MB rows: 46,936
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 |
|---|---|---|---|---|---|---|---|
| 2026-05-27 04:00:00 | SPY | ETF | 753.56 | 753.56 | 750.24 | 752.39 | 69120.0 |
| 2026-05-27 04:30:00 | SPY | ETF | 752.38 | 752.6 | 752.2 | 752.45 | 12108.0 |
| 2026-05-27 05:00:00 | SPY | ETF | 752.37 | 752.55 | 752.27 | 752.39 | 9923.0 |
| 2026-05-27 05:30:00 | SPY | ETF | 752.33 | 752.76 | 752.33 | 752.66 | 9428.0 |
| 2026-05-27 06:00:00 | SPY | ETF | 752.7 | 753.11 | 752.69 | 752.83 | 24263.0 |
| 2026-05-27 06:30:00 | SPY | ETF | 752.83 | 752.94 | 752.62 | 752.84 | 23889.0 |
| 2026-05-27 07:00:00 | SPY | ETF | 752.9 | 753.29 | 752.62 | 752.66 | 172477.0 |
| 2026-05-27 07:30:00 | SPY | ETF | 752.6535 | 752.7 | 751.7636 | 751.77 | 86297.0 |
| 2026-05-27 08:00:00 | SPY | ETF | 751.78 | 754.0 | 751.25 | 753.35 | 344064.0 |
| 2026-05-27 08:30:00 | SPY | ETF | 753.32 | 753.44 | 751.8661 | 751.95 | 141785.0 |
| 2026-05-27 09:00:00 | SPY | ETF | 751.9666 | 752.05 | 750.9 | 750.9 | 205077.0 |
| 2026-05-27 09:30:00 | SPY | ETF | 750.9 | 751.3 | 749.23 | 750.49 | 5116947.0 |
| 2026-05-27 10:00:00 | SPY | ETF | 750.505 | 751.38 | 749.55 | 750.045 | 2767656.0 |
| 2026-05-27 10:30:00 | SPY | ETF | 750.04 | 751.02 | 749.27 | 749.68 | 1744086.0 |
| 2026-05-27 11:00:00 | SPY | ETF | 749.69 | 750.16 | 748.91 | 749.54 | 1440729.0 |
| 2026-05-27 11:30:00 | SPY | ETF | 749.54 | 750.2 | 748.37 | 749.105 | 1689236.0 |
| 2026-05-27 12:00:00 | SPY | ETF | 749.09 | 749.83 | 748.54 | 749.6701 | 1223932.0 |
| 2026-05-27 12:30:00 | SPY | ETF | 749.65 | 750.615 | 749.48 | 749.79 | 1185266.0 |
| 2026-05-27 13:00:00 | SPY | ETF | 749.79 | 749.91 | 748.22 | 749.16 | 1298161.0 |
| 2026-05-27 13:30:00 | SPY | ETF | 749.16 | 750.05 | 749.145 | 749.72 | 997924.0 |
| 2026-05-27 14:00:00 | SPY | ETF | 749.71 | 750.81 | 749.3 | 750.72 | 1484220.0 |
| 2026-05-27 14:30:00 | SPY | ETF | 750.71 | 751.0501 | 750.41 | 750.81 | 1285986.0 |
| 2026-05-27 15:00:00 | SPY | ETF | 750.82 | 751.13 | 750.31 | 750.5601 | 1372187.0 |
| 2026-05-27 15:30:00 | SPY | ETF | 750.56 | 750.88 | 750.1 | 750.47 | 5115040.0 |
| 2026-05-27 16:00:00 | SPY | ETF | 750.49 | 751.45 | 750.2925 | 751.15 | 1752369.0 |
| 2026-05-27 16:30:00 | SPY | ETF | 751.17 | 752.18 | 751.11 | 752.0 | 244405.0 |
| 2026-05-27 17:00:00 | SPY | ETF | 751.9 | 751.93 | 751.51 | 751.59 | 52909.0 |
| 2026-05-27 17:30:00 | SPY | ETF | 751.64 | 751.86 | 751.4 | 751.84 | 53599.0 |
| 2026-05-27 18:00:00 | SPY | ETF | 751.89 | 752.25 | 750.46 | 751.07 | 470378.0 |
| 2026-05-27 18:30:00 | SPY | ETF | 751.0 | 751.2595 | 750.68 | 751.18 | 24915.0 |
| 2026-05-27 19:00:00 | SPY | ETF | 751.2217 | 751.45 | 750.65 | 750.8714 | 23548.0 |
| 2026-05-27 19:30:00 | SPY | ETF | 750.77 | 750.77 | 749.8 | 750.05 | 27857.0 |
| 2026-05-27 04:00:00 | QQQ | ETF | 732.57 | 733.65 | 729.85 | 733.5 | 176440.0 |
| 2026-05-27 04:30:00 | QQQ | ETF | 733.49 | 733.65 | 733.08 | 733.2 | 32402.0 |
| 2026-05-27 05:00:00 | QQQ | ETF | 733.13 | 733.28 | 732.61 | 732.94 | 43672.0 |
| 2026-05-27 05:30:00 | QQQ | ETF | 732.85 | 733.59 | 732.79 | 733.537 | 28127.0 |
| 2026-05-27 06:00:00 | QQQ | ETF | 733.5761 | 734.39 | 733.54 | 734.06 | 48747.0 |
| 2026-05-27 06:30:00 | QQQ | ETF | 734.01 | 734.21 | 733.61 | 734.08 | 48323.0 |
| 2026-05-27 07:00:00 | QQQ | ETF | 734.12 | 735.46 | 734.09 | 734.95 | 90679.0 |
| 2026-05-27 07:30:00 | QQQ | ETF | 734.9652 | 735.59 | 734.8 | 734.8 | 98048.0 |
| 2026-05-27 08:00:00 | QQQ | ETF | 734.8 | 737.6 | 729.733 | 736.99 | 306678.0 |
| 2026-05-27 08:30:00 | QQQ | ETF | 736.99 | 737.065 | 734.62 | 734.75 | 237226.0 |
| 2026-05-27 09:00:00 | QQQ | ETF | 734.8 | 734.97 | 732.97 | 732.97 | 441141.0 |
| 2026-05-27 09:30:00 | QQQ | ETF | 732.96 | 733.32 | 726.86 | 729.9 | 6424014.0 |
| 2026-05-27 10:00:00 | QQQ | ETF | 729.84 | 730.83 | 725.67 | 726.355 | 3267483.0 |
| 2026-05-27 10:30:00 | QQQ | ETF | 726.32 | 728.97 | 725.44 | 726.92 | 2402555.0 |
| 2026-05-27 11:00:00 | QQQ | ETF | 726.94 | 727.82 | 725.545 | 727.18 | 1647106.0 |
| 2026-05-27 11:30:00 | QQQ | ETF | 727.19 | 727.9199 | 725.53 | 726.8 | 1537405.0 |
| 2026-05-27 12:00:00 | QQQ | ETF | 726.79 | 728.775 | 726.11 | 728.2 | 1465596.0 |
| 2026-05-27 12:30:00 | QQQ | ETF | 728.16 | 729.56 | 727.77 | 728.0996 | 1232148.0 |
> showing 50 of 46,936 rows — these rows as CSV