PREVIEW / etf_daily / 2024-04-19
file: by_date/etf_daily/2024/2024-04-19.parquet size: 119 KB rows: 3,309
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-19 | SPY | ETF | 499.44 | 500.46 | 493.86 | 495.16 | 102129100.0 |
| 2024-04-19 | QQQ | ETF | 422.22 | 422.75 | 413.07 | 414.65 | 75230990.0 |
| 2024-04-19 | IWM | ETF | 191.94 | 194.39 | 191.34 | 193.14 | 42499200.0 |
| 2024-04-19 | DIA | ETF | 378.69 | 381.03 | 377.92 | 379.8 | 5074800.0 |
| 2024-04-19 | GLD | ETF | 220.49 | 222.36 | 220.08 | 221.03 | 8369000.0 |
| 2024-04-19 | TLT | ETF | 89.39 | 89.39 | 88.91 | 89.15 | 44808000.0 |
| 2024-04-19 | AAA | ETF | 25.135 | 25.15 | 25.12 | 25.138 | 3700.0 |
| 2024-04-19 | AAAU | ETF | 23.59 | 23.78 | 23.54 | 23.64 | 3776000.0 |
| 2024-04-19 | AADR | ETF | 59.36 | 59.36 | 59.36 | 59.36 | 100.0 |
| 2024-04-19 | AAPB | ETF | 16.24 | 16.34 | 15.91 | 16.09 | 106356.0 |
| 2024-04-19 | AAPD | ETF | 23.41 | 23.7201 | 23.4099 | 23.61 | 299777.0 |
| 2024-04-19 | AAPR | ETF | 24.35 | 24.38 | 24.26 | 24.2987 | 75608.0 |
| 2024-04-19 | AAPU | ETF | 20.99 | 21.09 | 20.48 | 20.73 | 320416.0 |
| 2024-04-19 | AAPX | ETF | 19.07 | 19.07 | 18.551 | 18.74 | 38795.0 |
| 2024-04-19 | AAPY | ETF | 22.9477 | 22.9477 | 22.9189 | 22.9189 | 619.0 |
| 2024-04-19 | AAXJ | ETF | 65.61 | 65.71 | 65.3 | 65.49 | 510700.0 |
| 2024-04-19 | ABCS | ETF | 25.4703 | 25.5119 | 25.47 | 25.5119 | 1300.0 |
| 2024-04-19 | ABEQ | ETF | 29.54 | 29.667 | 29.54 | 29.667 | 4700.0 |
| 2024-04-19 | ACES | ETF | 25.87 | 26.16 | 25.81 | 25.99 | 212200.0 |
| 2024-04-19 | ACIO | ETF | 34.86 | 34.88 | 34.69 | 34.735 | 178300.0 |
| 2024-04-19 | ACSI | ETF | 49.915 | 49.915 | 49.915 | 49.915 | 100.0 |
| 2024-04-19 | ACT | ETF | 29.51 | 29.82 | 29.48 | 29.77 | 207315.0 |
| 2024-04-19 | ACTV | ETF | 32.29 | 32.73 | 32.29 | 32.538 | 4500.0 |
| 2024-04-19 | ACVF | ETF | 38.1 | 38.165 | 37.81 | 37.877 | 9000.0 |
| 2024-04-19 | ACWF | ETF | 39.5767 | 39.71 | 39.35 | 39.39 | 2288.0 |
| 2024-04-19 | ACWI | ETF | 105.08 | 105.39 | 104.29 | 104.54 | 3511500.0 |
| 2024-04-19 | ACWV | ETF | 101.32 | 102.22 | 101.32 | 101.95 | 170400.0 |
| 2024-04-19 | ACWX | ETF | 51.12 | 51.32 | 51.02 | 51.16 | 1367700.0 |
| 2024-04-19 | ADFI | ETF | 8.32 | 8.36 | 8.309 | 8.35 | 28800.0 |
| 2024-04-19 | ADIV | ETF | 13.57 | 13.57 | 13.57 | 13.57 | 300.0 |
| 2024-04-19 | ADME | ETF | 40.151 | 40.18 | 39.941 | 39.984 | 5600.0 |
| 2024-04-19 | ADPV | ETF | 27.77 | 27.7919 | 27.65 | 27.7127 | 1337.0 |
| 2024-04-19 | AEMB | ETF | 38.09 | 38.09 | 37.916 | 37.916 | 900.0 |
| 2024-04-19 | AESR | ETF | 14.69 | 14.69 | 14.55 | 14.59 | 36800.0 |
| 2024-04-19 | AETH | ETF | 40.91 | 41.23 | 40.83 | 41.111 | 2662.0 |
| 2024-04-19 | AFIF | ETF | 9.04 | 9.04 | 9.03 | 9.03 | 22900.0 |
| 2024-04-19 | AFK | ETF | 14.67 | 14.7 | 14.6 | 14.65 | 4000.0 |
| 2024-04-19 | AFLG | ETF | 29.347 | 29.347 | 29.11 | 29.11 | 200.0 |
| 2024-04-19 | AFMC | ETF | 28.012 | 28.012 | 28.012 | 28.012 | 100.0 |
| 2024-04-19 | AFSM | ETF | 27.03 | 27.222 | 26.99 | 27.222 | 900.0 |
| 2024-04-19 | AFTY | ETF | 14.1 | 14.106 | 14.03 | 14.106 | 3000.0 |
| 2024-04-19 | AGG | ETF | 95.53 | 95.55 | 95.33 | 95.38 | 9121700.0 |
| 2024-04-19 | AGGH | ETF | 20.65 | 20.6813 | 20.5601 | 20.6503 | 30884.0 |
| 2024-04-19 | AGGY | ETF | 42.42 | 42.42 | 42.33 | 42.39 | 96700.0 |
| 2024-04-19 | AGNG | ETF | 28.26 | 28.371 | 28.01 | 28.24 | 2900.0 |
| 2024-04-19 | AGOX | ETF | 24.27 | 24.52 | 24.05 | 24.45 | 22000.0 |
| 2024-04-19 | AGQ | ETF | 37.05 | 38.16 | 36.96 | 37.88 | 1478200.0 |
| 2024-04-19 | AGQI | ETF | 13.49 | 13.54 | 13.47 | 13.5117 | 35440.0 |
| 2024-04-19 | AGRH | ETF | 25.84 | 25.84 | 25.8053 | 25.8053 | 2633.0 |
| 2024-04-19 | AGZ | ETF | 106.72 | 106.8 | 106.69 | 106.79 | 10200.0 |
> showing 50 of 3,309 rows — these rows as CSV