PREVIEW / etf_30min / 2024-07-19
file: by_date/etf_30min/2024/2024-07-19.parquet size: 762 KB rows: 30,720
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-07-19 04:00:00 | SPY | ETF | 551.62 | 552.29 | 551.07 | 552.08 | 20771.0 |
| 2024-07-19 04:30:00 | SPY | ETF | 552.0 | 552.4 | 551.89 | 552.02 | 5129.0 |
| 2024-07-19 05:00:00 | SPY | ETF | 552.14 | 552.72 | 551.65 | 551.75 | 24761.0 |
| 2024-07-19 05:30:00 | SPY | ETF | 551.7 | 552.55 | 551.56 | 552.34 | 5605.0 |
| 2024-07-19 06:00:00 | SPY | ETF | 552.6 | 553.44 | 552.6 | 553.44 | 6756.0 |
| 2024-07-19 06:30:00 | SPY | ETF | 553.28 | 553.28 | 552.67 | 552.81 | 27779.0 |
| 2024-07-19 07:00:00 | SPY | ETF | 552.76 | 553.78 | 552.65 | 553.58 | 103361.0 |
| 2024-07-19 07:30:00 | SPY | ETF | 553.66 | 553.73 | 553.38 | 553.55 | 93349.0 |
| 2024-07-19 08:00:00 | SPY | ETF | 552.98 | 554.33 | 551.11 | 553.03 | 160270.0 |
| 2024-07-19 08:30:00 | SPY | ETF | 553.0 | 553.98 | 553.0 | 553.89 | 73974.0 |
| 2024-07-19 09:00:00 | SPY | ETF | 553.94 | 553.98 | 551.91 | 552.42 | 241961.0 |
| 2024-07-19 09:30:00 | SPY | ETF | 552.42 | 554.08 | 551.8 | 552.99 | 3538902.0 |
| 2024-07-19 10:00:00 | SPY | ETF | 552.985 | 553.295 | 551.04 | 551.11 | 1817734.0 |
| 2024-07-19 10:30:00 | SPY | ETF | 551.13 | 551.75 | 550.66 | 551.12 | 1892523.0 |
| 2024-07-19 11:00:00 | SPY | ETF | 551.16 | 551.99 | 549.595 | 549.645 | 2036997.0 |
| 2024-07-19 11:30:00 | SPY | ETF | 549.6478 | 551.07 | 549.2172 | 551.0644 | 2288846.0 |
| 2024-07-19 12:00:00 | SPY | ETF | 551.03 | 551.49 | 549.97 | 550.07 | 1649324.0 |
| 2024-07-19 12:30:00 | SPY | ETF | 550.07 | 550.19 | 548.92 | 549.3599 | 1738729.0 |
| 2024-07-19 13:00:00 | SPY | ETF | 549.355 | 549.355 | 547.91 | 548.59 | 1975661.0 |
| 2024-07-19 13:30:00 | SPY | ETF | 548.57 | 549.44 | 548.09 | 549.42 | 1517220.0 |
| 2024-07-19 14:00:00 | SPY | ETF | 549.4 | 549.716 | 548.63 | 548.69 | 1640249.0 |
| 2024-07-19 14:30:00 | SPY | ETF | 548.7 | 549.23 | 548.02 | 549.12 | 2106421.0 |
| 2024-07-19 15:00:00 | SPY | ETF | 549.13 | 550.46 | 549.04 | 549.99 | 2547756.0 |
| 2024-07-19 15:30:00 | SPY | ETF | 549.99 | 550.08 | 548.14 | 548.93 | 8038860.0 |
| 2024-07-19 16:00:00 | SPY | ETF | 548.95 | 549.56 | 548.32 | 548.74 | 3394453.0 |
| 2024-07-19 16:30:00 | SPY | ETF | 548.65 | 548.96 | 548.62 | 548.92 | 160344.0 |
| 2024-07-19 17:00:00 | SPY | ETF | 548.81 | 548.99 | 548.58 | 548.58 | 91108.0 |
| 2024-07-19 17:30:00 | SPY | ETF | 548.6 | 548.7166 | 548.5 | 548.5 | 30104.0 |
| 2024-07-19 18:00:00 | SPY | ETF | 548.64 | 548.86 | 548.64 | 548.78 | 20085.0 |
| 2024-07-19 18:30:00 | SPY | ETF | 548.777 | 548.8 | 548.7702 | 548.79 | 2821.0 |
| 2024-07-19 19:00:00 | SPY | ETF | 548.82 | 548.82 | 548.61 | 548.64 | 2227.0 |
| 2024-07-19 19:30:00 | SPY | ETF | 548.6 | 549.05 | 548.6 | 549.05 | 39117.0 |
| 2024-07-19 04:00:00 | QQQ | ETF | 477.46 | 478.56 | 477.19 | 478.49 | 125428.0 |
| 2024-07-19 04:30:00 | QQQ | ETF | 478.42 | 478.97 | 478.25 | 478.51 | 47976.0 |
| 2024-07-19 05:00:00 | QQQ | ETF | 478.33 | 479.07 | 477.73 | 477.73 | 58040.0 |
| 2024-07-19 05:30:00 | QQQ | ETF | 477.87 | 478.9 | 477.78 | 478.77 | 74233.0 |
| 2024-07-19 06:00:00 | QQQ | ETF | 478.68 | 480.04 | 478.68 | 479.93 | 91392.0 |
| 2024-07-19 06:30:00 | QQQ | ETF | 479.89 | 479.9 | 479.1 | 479.19 | 58945.0 |
| 2024-07-19 07:00:00 | QQQ | ETF | 479.21 | 480.88 | 479.09 | 480.6 | 132946.0 |
| 2024-07-19 07:30:00 | QQQ | ETF | 480.73 | 480.84 | 480.33 | 480.43 | 78321.0 |
| 2024-07-19 08:00:00 | QQQ | ETF | 480.2 | 481.76 | 476.8 | 479.99 | 217385.0 |
| 2024-07-19 08:30:00 | QQQ | ETF | 479.98 | 481.3 | 479.93 | 480.92 | 112110.0 |
| 2024-07-19 09:00:00 | QQQ | ETF | 480.89 | 480.97 | 479.19 | 479.21 | 371417.0 |
| 2024-07-19 09:30:00 | QQQ | ETF | 479.17 | 481.69 | 478.34 | 479.5091 | 3718397.0 |
| 2024-07-19 10:00:00 | QQQ | ETF | 479.52 | 480.28 | 477.46 | 477.52 | 2188249.0 |
| 2024-07-19 10:30:00 | QQQ | ETF | 477.55 | 478.43 | 476.8974 | 478.105 | 1885229.0 |
| 2024-07-19 11:00:00 | QQQ | ETF | 478.13 | 479.28 | 476.1 | 476.198 | 1532963.0 |
| 2024-07-19 11:30:00 | QQQ | ETF | 476.24 | 477.88 | 475.19 | 477.87 | 2146318.0 |
| 2024-07-19 12:00:00 | QQQ | ETF | 477.83 | 478.09 | 475.98 | 476.2 | 1153940.0 |
| 2024-07-19 12:30:00 | QQQ | ETF | 476.2 | 476.375 | 474.73 | 475.75 | 1706650.0 |
> showing 50 of 30,720 rows — these rows as CSV