PREVIEW / etf_daily / 2024-04-30
file: by_date/etf_daily/2024/2024-04-30.parquet size: 120 KB rows: 3,330
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-04-30 | SPY | ETF | 508.56 | 509.56 | 501.98 | 501.98 | 77483600.0 |
| 2024-04-30 | QQQ | ETF | 431.15 | 432.56 | 424.51 | 424.59 | 43665934.0 |
| 2024-04-30 | IWM | ETF | 198.11 | 198.65 | 195.75 | 195.9 | 30606800.0 |
| 2024-04-30 | DIA | ETF | 382.46 | 382.75 | 378.08 | 378.13 | 3463600.0 |
| 2024-04-30 | GLD | ETF | 213.38 | 214.13 | 211.8 | 211.87 | 11248600.0 |
| 2024-04-30 | TLT | ETF | 88.42 | 88.73 | 88.1 | 88.22 | 41054700.0 |
| 2024-04-30 | AAA | ETF | 25.09 | 25.09 | 25.06 | 25.065 | 2100.0 |
| 2024-04-30 | AAAU | ETF | 22.82 | 22.9 | 22.66 | 22.68 | 3751200.0 |
| 2024-04-30 | AADR | ETF | 61.05 | 61.05 | 61.02 | 61.02 | 200.0 |
| 2024-04-30 | AAPB | ETF | 17.7 | 18.0057 | 17.04 | 17.06 | 175573.0 |
| 2024-04-30 | AAPD | ETF | 22.51 | 22.92 | 22.2776 | 22.92 | 191990.0 |
| 2024-04-30 | AAPR | ETF | 24.58 | 24.58 | 24.34 | 24.34 | 141525.0 |
| 2024-04-30 | AAPU | ETF | 22.82 | 23.2296 | 21.94 | 21.99 | 387234.0 |
| 2024-04-30 | AAPX | ETF | 20.63 | 20.95 | 20.04 | 20.07 | 9245.0 |
| 2024-04-30 | AAPY | ETF | 23.78 | 23.85 | 23.3761 | 23.3761 | 527.0 |
| 2024-04-30 | AAXJ | ETF | 68.4 | 68.66 | 68.13 | 68.14 | 294500.0 |
| 2024-04-30 | ABCS | ETF | 26.04 | 26.05 | 25.6652 | 25.6652 | 3150.0 |
| 2024-04-30 | ABEQ | ETF | 29.84 | 29.84 | 29.643 | 29.643 | 11300.0 |
| 2024-04-30 | ACES | ETF | 27.21 | 27.35 | 26.85 | 26.85 | 83800.0 |
| 2024-04-30 | ACIO | ETF | 35.33 | 35.36 | 34.96 | 34.97 | 101600.0 |
| 2024-04-30 | ACSI | ETF | 51.008 | 51.008 | 51.008 | 51.008 | 100.0 |
| 2024-04-30 | ACT | ETF | 29.88 | 29.94 | 29.53 | 29.73 | 186420.0 |
| 2024-04-30 | ACTV | ETF | 33.19 | 33.19 | 32.856 | 32.856 | 4200.0 |
| 2024-04-30 | ACVF | ETF | 38.95 | 38.95 | 38.44 | 38.52 | 12800.0 |
| 2024-04-30 | ACWF | ETF | 40.396 | 40.396 | 39.9766 | 39.9766 | 3099.0 |
| 2024-04-30 | ACWI | ETF | 107.45 | 107.66 | 106.22 | 106.22 | 2361000.0 |
| 2024-04-30 | ACWV | ETF | 102.52 | 102.75 | 101.82 | 102.2 | 191000.0 |
| 2024-04-30 | ACWX | ETF | 52.5 | 52.68 | 52.08 | 52.09 | 819100.0 |
| 2024-04-30 | ADFI | ETF | 8.36 | 8.37 | 8.34 | 8.35 | 43100.0 |
| 2024-04-30 | ADIV | ETF | 14.12 | 14.12 | 14.08 | 14.08 | 300.0 |
| 2024-04-30 | ADME | ETF | 40.78 | 40.797 | 40.41 | 40.41 | 4000.0 |
| 2024-04-30 | ADPV | ETF | 29.14 | 29.14 | 28.6991 | 28.6991 | 9326.0 |
| 2024-04-30 | AEMB | ETF | 37.983 | 38.03 | 37.983 | 38.03 | 500.0 |
| 2024-04-30 | AESR | ETF | 14.971 | 15.01 | 14.822 | 14.822 | 23400.0 |
| 2024-04-30 | AETH | ETF | 39.64 | 39.64 | 38.38 | 38.3817 | 2790.0 |
| 2024-04-30 | AFIF | ETF | 9.02 | 9.06 | 9.02 | 9.05 | 15400.0 |
| 2024-04-30 | AFK | ETF | 14.91 | 15.04 | 14.71 | 14.81 | 3700.0 |
| 2024-04-30 | AFLG | ETF | 29.35 | 29.35 | 29.35 | 29.35 | 100.0 |
| 2024-04-30 | AFSM | ETF | 27.995 | 27.995 | 27.68 | 27.68 | 2300.0 |
| 2024-04-30 | AFTY | ETF | 14.53 | 14.53 | 14.414 | 14.414 | 5000.0 |
| 2024-04-30 | AGG | ETF | 95.32 | 95.5 | 95.15 | 95.23 | 11228300.0 |
| 2024-04-30 | AGGH | ETF | 20.6 | 20.6205 | 20.5 | 20.5362 | 38236.0 |
| 2024-04-30 | AGGY | ETF | 42.2 | 42.27 | 42.14 | 42.155 | 50900.0 |
| 2024-04-30 | AGNG | ETF | 28.833 | 28.833 | 28.71 | 28.71 | 1300.0 |
| 2024-04-30 | AGOX | ETF | 25.38 | 25.38 | 24.65 | 24.65 | 26600.0 |
| 2024-04-30 | AGQ | ETF | 32.14 | 32.52 | 31.55 | 31.64 | 1854100.0 |
| 2024-04-30 | AGQI | ETF | 13.83 | 13.84 | 13.7089 | 13.7089 | 19062.0 |
| 2024-04-30 | AGRH | ETF | 25.93 | 25.935 | 25.93 | 25.935 | 290.0 |
| 2024-04-30 | AGZ | ETF | 106.64 | 106.71 | 106.57 | 106.58 | 16900.0 |
| 2024-04-30 | AGZD | ETF | 22.1 | 22.23 | 22.1 | 22.13 | 29100.0 |
> showing 50 of 3,330 rows — these rows as CSV