PREVIEW / etf_daily / 2023-11-30
file: by_date/etf_daily/2023/2023-11-30.parquet size: 113 KB rows: 3,143
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-30 | SPY | ETF | 455.48 | 456.76 | 453.34 | 456.4 | 79752700.0 |
| 2023-11-30 | QQQ | ETF | 390.08 | 390.55 | 385.82 | 388.83 | 52834381.0 |
| 2023-11-30 | IWM | ETF | 180.05 | 180.64 | 178.76 | 179.66 | 32216800.0 |
| 2023-11-30 | DIA | ETF | 356.71 | 360.18 | 356.45 | 360.0 | 4094300.0 |
| 2023-11-30 | GLD | ETF | 188.89 | 189.24 | 188.28 | 188.75 | 7558100.0 |
| 2023-11-30 | TLT | ETF | 91.97 | 92.29 | 91.16 | 91.56 | 60520900.0 |
| 2023-11-30 | AAA | ETF | 25.04 | 25.05 | 24.98 | 25.05 | 2200.0 |
| 2023-11-30 | AAAU | ETF | 20.18 | 20.22 | 20.12 | 20.17 | 1528600.0 |
| 2023-11-30 | AADR | ETF | 53.87 | 53.87 | 53.84 | 53.84 | 400.0 |
| 2023-11-30 | AAPB | ETF | 26.8 | 26.91 | 26.481 | 26.89 | 14785.0 |
| 2023-11-30 | AAPD | ETF | 20.6105 | 20.81 | 20.5991 | 20.62 | 164606.0 |
| 2023-11-30 | AAPU | ETF | 27.23 | 27.29 | 26.88 | 27.23 | 67640.0 |
| 2023-11-30 | AAPY | ETF | 26.53 | 26.62 | 26.53 | 26.62 | 393.0 |
| 2023-11-30 | AAXJ | ETF | 65.45 | 65.58 | 65.06 | 65.41 | 633200.0 |
| 2023-11-30 | ABEQ | ETF | 27.97 | 28.125 | 27.97 | 28.125 | 19000.0 |
| 2023-11-30 | ACES | ETF | 31.34 | 31.44 | 30.75 | 31.29 | 138000.0 |
| 2023-11-30 | ACIO | ETF | 32.245 | 32.32 | 32.11 | 32.32 | 27800.0 |
| 2023-11-30 | ACSI | ETF | 47.986 | 47.986 | 47.986 | 47.986 | 100.0 |
| 2023-11-30 | ACT | ETF | 27.59 | 27.83 | 27.555 | 27.71 | 134520.0 |
| 2023-11-30 | ACTV | ETF | 29.84 | 30.03 | 29.8 | 30.0 | 5500.0 |
| 2023-11-30 | ACVF | ETF | 34.9 | 34.9 | 34.66 | 34.877 | 7900.0 |
| 2023-11-30 | ACWF | ETF | 36.5399 | 36.6201 | 36.48 | 36.6201 | 4223.0 |
| 2023-11-30 | ACWI | ETF | 97.89 | 98.12 | 97.58 | 98.02 | 3946800.0 |
| 2023-11-30 | ACWV | ETF | 98.33 | 98.77 | 98.03 | 98.77 | 321500.0 |
| 2023-11-30 | ACWX | ETF | 49.4 | 49.42 | 49.11 | 49.31 | 2256200.0 |
| 2023-11-30 | ADFI | ETF | 8.385 | 8.42 | 8.37 | 8.395 | 14600.0 |
| 2023-11-30 | ADIV | ETF | 13.76 | 13.76 | 13.748 | 13.748 | 100.0 |
| 2023-11-30 | ADME | ETF | 36.9 | 37.13 | 36.9 | 37.13 | 4900.0 |
| 2023-11-30 | ADPV | ETF | 23.4601 | 23.52 | 23.36 | 23.52 | 6591.0 |
| 2023-11-30 | AEMB | ETF | 36.966 | 36.966 | 36.966 | 36.966 | 100.0 |
| 2023-11-30 | AESR | ETF | 13.0 | 13.06 | 12.94 | 13.06 | 22300.0 |
| 2023-11-30 | AETH | ETF | 30.38 | 30.61 | 30.38 | 30.5586 | 2075.0 |
| 2023-11-30 | AFIF | ETF | 8.98 | 8.98 | 8.97 | 8.98 | 10500.0 |
| 2023-11-30 | AFK | ETF | 13.99 | 14.01 | 13.85 | 13.99 | 6200.0 |
| 2023-11-30 | AFMC | ETF | 24.654 | 24.654 | 24.654 | 24.654 | 200.0 |
| 2023-11-30 | AFSM | ETF | 24.76 | 24.76 | 24.675 | 24.675 | 500.0 |
| 2023-11-30 | AGG | ETF | 96.38 | 96.41 | 96.13 | 96.26 | 8889100.0 |
| 2023-11-30 | AGGH | ETF | 21.5 | 21.52 | 21.35 | 21.3702 | 7766.0 |
| 2023-11-30 | AGGY | ETF | 42.66 | 42.68 | 42.553 | 42.64 | 106000.0 |
| 2023-11-30 | AGNG | ETF | 26.73 | 27.14 | 26.66 | 26.83 | 1600.0 |
| 2023-11-30 | AGOX | ETF | 23.78 | 23.88 | 23.76 | 23.88 | 44400.0 |
| 2023-11-30 | AGQ | ETF | 30.71 | 31.17 | 30.42 | 31.15 | 820600.0 |
| 2023-11-30 | AGQI | ETF | 12.74 | 12.75 | 12.7 | 12.75 | 716403.0 |
| 2023-11-30 | AGRH | ETF | 25.795 | 25.805 | 25.795 | 25.8 | 4028.0 |
| 2023-11-30 | AGZ | ETF | 107.09 | 107.14 | 106.99 | 107.14 | 22800.0 |
| 2023-11-30 | AGZD | ETF | 22.33 | 22.37 | 22.12 | 22.37 | 54100.0 |
| 2023-11-30 | AHLT | ETF | 24.35 | 24.35 | 24.185 | 24.2833 | 13606.0 |
| 2023-11-30 | AHYB | ETF | 44.42 | 44.511 | 44.41 | 44.511 | 1600.0 |
| 2023-11-30 | AIA | ETF | 57.65 | 57.65 | 57.27 | 57.4 | 28400.0 |
| 2023-11-30 | AIEQ | ETF | 31.35 | 31.38 | 31.046 | 31.157 | 12100.0 |
> showing 50 of 3,143 rows — these rows as CSV