PREVIEW / etf_30min / 2024-09-20
file: by_date/etf_30min/2024/2024-09-20.parquet size: 827 KB rows: 32,643
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-20 04:00:00 | SPY | ETF | 568.99 | 569.0 | 568.15 | 568.16 | 30081.0 |
| 2024-09-20 04:30:00 | SPY | ETF | 568.1 | 568.46 | 568.09 | 568.25 | 10585.0 |
| 2024-09-20 05:00:00 | SPY | ETF | 568.34 | 568.7 | 568.3 | 568.43 | 5294.0 |
| 2024-09-20 05:30:00 | SPY | ETF | 568.25 | 568.28 | 568.09 | 568.27 | 4898.0 |
| 2024-09-20 06:00:00 | SPY | ETF | 568.23 | 568.53 | 568.01 | 568.42 | 14230.0 |
| 2024-09-20 06:30:00 | SPY | ETF | 568.26 | 568.42 | 567.83 | 567.96 | 7295.0 |
| 2024-09-20 07:00:00 | SPY | ETF | 567.97 | 568.12 | 567.72 | 567.75 | 40073.0 |
| 2024-09-20 07:30:00 | SPY | ETF | 567.79 | 568.17 | 567.69 | 568.14 | 128679.0 |
| 2024-09-20 08:00:00 | SPY | ETF | 568.09 | 569.1 | 567.7497 | 568.63 | 109925.0 |
| 2024-09-20 08:30:00 | SPY | ETF | 568.63 | 569.09 | 568.63 | 568.97 | 159652.0 |
| 2024-09-20 09:00:00 | SPY | ETF | 568.93 | 568.94 | 567.69 | 567.86 | 459828.0 |
| 2024-09-20 09:30:00 | SPY | ETF | 567.84 | 568.4958 | 566.93 | 567.149 | 4198478.0 |
| 2024-09-20 10:00:00 | SPY | ETF | 567.07 | 567.64 | 566.41 | 567.22 | 2617020.0 |
| 2024-09-20 10:30:00 | SPY | ETF | 567.23 | 567.76 | 566.26 | 566.395 | 2108300.0 |
| 2024-09-20 11:00:00 | SPY | ETF | 566.4 | 566.4 | 565.17 | 565.99 | 2651417.0 |
| 2024-09-20 11:30:00 | SPY | ETF | 565.98 | 567.36 | 565.71 | 566.93 | 2232467.0 |
| 2024-09-20 12:00:00 | SPY | ETF | 566.95 | 568.0001 | 566.73 | 567.95 | 1424757.0 |
| 2024-09-20 12:30:00 | SPY | ETF | 567.91 | 568.5 | 567.67 | 568.1485 | 1517392.0 |
| 2024-09-20 13:00:00 | SPY | ETF | 568.14 | 568.53 | 567.87 | 568.22 | 1133707.0 |
| 2024-09-20 13:30:00 | SPY | ETF | 568.225 | 568.6455 | 567.92 | 568.07 | 1380372.0 |
| 2024-09-20 14:00:00 | SPY | ETF | 568.065 | 568.14 | 566.41 | 566.62 | 2325064.0 |
| 2024-09-20 14:30:00 | SPY | ETF | 566.6 | 567.725 | 566.09 | 567.4801 | 2631712.0 |
| 2024-09-20 15:00:00 | SPY | ETF | 567.48 | 568.69 | 567.1275 | 568.24 | 2405289.0 |
| 2024-09-20 15:30:00 | SPY | ETF | 568.235 | 569.31 | 567.8 | 568.1 | 7724533.0 |
| 2024-09-20 16:00:00 | SPY | ETF | 568.1 | 568.25 | 567.26 | 567.41 | 4745981.0 |
| 2024-09-20 16:30:00 | SPY | ETF | 567.39 | 568.25 | 567.2 | 567.79 | 251357.0 |
| 2024-09-20 17:00:00 | SPY | ETF | 567.83 | 567.95 | 567.5 | 567.89 | 61545.0 |
| 2024-09-20 17:30:00 | SPY | ETF | 567.86 | 568.0 | 567.41 | 567.5 | 58390.0 |
| 2024-09-20 18:00:00 | SPY | ETF | 567.5 | 568.0 | 567.48 | 567.95 | 52818.0 |
| 2024-09-20 18:30:00 | SPY | ETF | 567.95 | 568.25 | 567.95 | 568.25 | 39024.0 |
| 2024-09-20 19:00:00 | SPY | ETF | 568.25 | 568.29 | 568.05 | 568.05 | 11618.0 |
| 2024-09-20 19:30:00 | SPY | ETF | 568.02 | 568.16 | 568.01 | 568.15 | 8380.0 |
| 2024-09-20 04:00:00 | QQQ | ETF | 483.01 | 483.13 | 482.0 | 482.0 | 76831.0 |
| 2024-09-20 04:30:00 | QQQ | ETF | 481.94 | 482.34 | 481.84 | 482.22 | 17734.0 |
| 2024-09-20 05:00:00 | QQQ | ETF | 482.18 | 482.6 | 482.11 | 482.36 | 22684.0 |
| 2024-09-20 05:30:00 | QQQ | ETF | 482.15 | 482.16 | 481.83 | 481.85 | 13056.0 |
| 2024-09-20 06:00:00 | QQQ | ETF | 481.92 | 482.1 | 481.69 | 482.05 | 13485.0 |
| 2024-09-20 06:30:00 | QQQ | ETF | 481.85 | 482.0 | 481.21 | 481.45 | 50195.0 |
| 2024-09-20 07:00:00 | QQQ | ETF | 481.47 | 481.72 | 481.22 | 481.55 | 98833.0 |
| 2024-09-20 07:30:00 | QQQ | ETF | 481.5 | 482.09 | 481.41 | 482.09 | 56647.0 |
| 2024-09-20 08:00:00 | QQQ | ETF | 481.62 | 483.06 | 481.2401 | 482.95 | 251309.0 |
| 2024-09-20 08:30:00 | QQQ | ETF | 482.8116 | 483.43 | 482.81 | 483.16 | 112513.0 |
| 2024-09-20 09:00:00 | QQQ | ETF | 483.17 | 483.23 | 482.0 | 482.58 | 279338.0 |
| 2024-09-20 09:30:00 | QQQ | ETF | 482.51 | 483.63 | 481.43 | 481.6602 | 2346441.0 |
| 2024-09-20 10:00:00 | QQQ | ETF | 481.68 | 482.269 | 481.0 | 481.675 | 1658826.0 |
| 2024-09-20 10:30:00 | QQQ | ETF | 481.675 | 482.06 | 480.05 | 480.25 | 1506756.0 |
| 2024-09-20 11:00:00 | QQQ | ETF | 480.24 | 480.26 | 478.3 | 479.43 | 1827253.0 |
| 2024-09-20 11:30:00 | QQQ | ETF | 479.42 | 481.35 | 479.3 | 481.04 | 1451552.0 |
| 2024-09-20 12:00:00 | QQQ | ETF | 481.05 | 482.14 | 480.9 | 482.08 | 857832.0 |
| 2024-09-20 12:30:00 | QQQ | ETF | 482.04 | 482.54 | 481.73 | 482.14 | 801891.0 |
> showing 50 of 32,643 rows — these rows as CSV