PREVIEW / etf_30min / 2026-04-27
file: by_date/etf_30min/2026/2026-04-27.parquet size: 1.0 MB rows: 45,455
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-04-27 04:00:00 | SPY | ETF | 713.87 | 715.04 | 712.72 | 713.21 | 101286.0 |
| 2026-04-27 04:30:00 | SPY | ETF | 713.25 | 713.58 | 713.17 | 713.5 | 12461.0 |
| 2026-04-27 05:00:00 | SPY | ETF | 713.5 | 713.65 | 713.37 | 713.49 | 7621.0 |
| 2026-04-27 05:30:00 | SPY | ETF | 713.47 | 713.7 | 713.42 | 713.47 | 8821.0 |
| 2026-04-27 06:00:00 | SPY | ETF | 713.52 | 713.65 | 713.3 | 713.43 | 12915.0 |
| 2026-04-27 06:30:00 | SPY | ETF | 713.5 | 714.09 | 713.47 | 713.99 | 17473.0 |
| 2026-04-27 07:00:00 | SPY | ETF | 713.95 | 714.4 | 713.941 | 714.28 | 142699.0 |
| 2026-04-27 07:30:00 | SPY | ETF | 714.28 | 714.43 | 714.16 | 714.3 | 88436.0 |
| 2026-04-27 08:00:00 | SPY | ETF | 714.28 | 714.33 | 713.14 | 713.41 | 118880.0 |
| 2026-04-27 08:30:00 | SPY | ETF | 713.43 | 713.84 | 713.1 | 713.4 | 102030.0 |
| 2026-04-27 09:00:00 | SPY | ETF | 713.43 | 713.7 | 712.9 | 713.18 | 238897.0 |
| 2026-04-27 09:30:00 | SPY | ETF | 713.17 | 714.4093 | 712.6 | 714.085 | 4591037.0 |
| 2026-04-27 10:00:00 | SPY | ETF | 714.09 | 714.34 | 713.35 | 713.445 | 1866539.0 |
| 2026-04-27 10:30:00 | SPY | ETF | 713.4592 | 714.45 | 713.072 | 713.62 | 1881815.0 |
| 2026-04-27 11:00:00 | SPY | ETF | 713.66 | 713.8 | 712.295 | 713.0 | 1610720.0 |
| 2026-04-27 11:30:00 | SPY | ETF | 712.99 | 713.48 | 712.76 | 713.4 | 1001096.0 |
| 2026-04-27 12:00:00 | SPY | ETF | 713.41 | 714.12 | 713.18 | 713.86 | 1251350.0 |
| 2026-04-27 12:30:00 | SPY | ETF | 713.87 | 714.31 | 713.86 | 714.13 | 1051249.0 |
| 2026-04-27 13:00:00 | SPY | ETF | 714.12 | 714.755 | 713.88 | 714.6 | 1251614.0 |
| 2026-04-27 13:30:00 | SPY | ETF | 714.6 | 715.21 | 714.58 | 714.8799 | 1328327.0 |
| 2026-04-27 14:00:00 | SPY | ETF | 714.85 | 715.24 | 714.72 | 715.1 | 1405986.0 |
| 2026-04-27 14:30:00 | SPY | ETF | 715.09 | 715.22 | 714.72 | 714.875 | 1038285.0 |
| 2026-04-27 15:00:00 | SPY | ETF | 714.87 | 715.21 | 714.71 | 715.14 | 1326835.0 |
| 2026-04-27 15:30:00 | SPY | ETF | 715.13 | 715.63 | 714.88 | 715.15 | 4490579.0 |
| 2026-04-27 16:00:00 | SPY | ETF | 715.16 | 715.22 | 714.39 | 714.91 | 1648823.0 |
| 2026-04-27 16:30:00 | SPY | ETF | 714.93 | 715.25 | 714.92 | 715.03 | 99825.0 |
| 2026-04-27 17:00:00 | SPY | ETF | 715.0 | 715.15 | 715.0 | 715.12 | 18291.0 |
| 2026-04-27 17:30:00 | SPY | ETF | 715.12 | 715.17 | 714.9 | 715.0586 | 28713.0 |
| 2026-04-27 18:00:00 | SPY | ETF | 715.06 | 716.48 | 715.06 | 716.28 | 78608.0 |
| 2026-04-27 18:30:00 | SPY | ETF | 716.3838 | 716.43 | 716.1 | 716.1364 | 13977.0 |
| 2026-04-27 19:00:00 | SPY | ETF | 716.19 | 716.31 | 716.0 | 716.24 | 13699.0 |
| 2026-04-27 19:30:00 | SPY | ETF | 716.22 | 716.4696 | 716.16 | 716.26 | 24604.0 |
| 2026-04-27 04:00:00 | QQQ | ETF | 664.32 | 666.55 | 662.94 | 663.51 | 167925.0 |
| 2026-04-27 04:30:00 | QQQ | ETF | 663.51 | 664.29 | 663.49 | 664.19 | 51270.0 |
| 2026-04-27 05:00:00 | QQQ | ETF | 664.19 | 664.54 | 664.08 | 664.44 | 52620.0 |
| 2026-04-27 05:30:00 | QQQ | ETF | 664.47 | 664.81 | 664.32 | 664.52 | 38508.0 |
| 2026-04-27 06:00:00 | QQQ | ETF | 664.57 | 664.74 | 664.2 | 664.51 | 48091.0 |
| 2026-04-27 06:30:00 | QQQ | ETF | 664.46 | 665.195 | 664.45 | 665.02 | 52652.0 |
| 2026-04-27 07:00:00 | QQQ | ETF | 665.0 | 665.5406 | 664.98 | 665.44 | 108620.0 |
| 2026-04-27 07:30:00 | QQQ | ETF | 665.48 | 665.6 | 665.1 | 665.2 | 63389.0 |
| 2026-04-27 08:00:00 | QQQ | ETF | 665.15 | 665.22 | 663.19 | 663.65 | 172708.0 |
| 2026-04-27 08:30:00 | QQQ | ETF | 663.64 | 664.04 | 662.95 | 663.61 | 173400.0 |
| 2026-04-27 09:00:00 | QQQ | ETF | 663.5608 | 663.98 | 662.77 | 663.4 | 250444.0 |
| 2026-04-27 09:30:00 | QQQ | ETF | 663.4 | 663.95 | 660.69 | 663.2 | 4588687.0 |
| 2026-04-27 10:00:00 | QQQ | ETF | 663.2 | 663.41 | 661.91 | 662.17 | 2503122.0 |
| 2026-04-27 10:30:00 | QQQ | ETF | 662.17 | 663.28 | 661.27 | 662.38 | 2214077.0 |
| 2026-04-27 11:00:00 | QQQ | ETF | 662.39 | 662.64 | 660.94 | 661.805 | 1439079.0 |
| 2026-04-27 11:30:00 | QQQ | ETF | 661.83 | 662.73 | 661.595 | 662.34 | 1059235.0 |
| 2026-04-27 12:00:00 | QQQ | ETF | 662.39 | 662.91 | 661.9 | 662.58 | 983147.0 |
| 2026-04-27 12:30:00 | QQQ | ETF | 662.58 | 663.33 | 662.58 | 662.94 | 839011.0 |
> showing 50 of 45,455 rows — these rows as CSV