PREVIEW / etf_daily / 2024-09-05
file: by_date/etf_daily/2024/2024-09-05.parquet size: 133 KB rows: 3,494
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-09-05 | SPY | ETF | 550.89 | 553.7995 | 547.1 | 549.61 | 44258735.0 |
| 2024-09-05 | QQQ | ETF | 458.97 | 465.36 | 457.939 | 461.04 | 34452385.0 |
| 2024-09-05 | IWM | ETF | 213.54 | 214.03 | 210.92 | 211.93 | 24132347.0 |
| 2024-09-05 | DIA | ETF | 411.34 | 411.66 | 405.98 | 408.46 | 2224164.0 |
| 2024-09-05 | GLD | ETF | 232.72 | 232.89 | 231.33 | 232.35 | 4823077.0 |
| 2024-09-05 | TLT | ETF | 99.34 | 99.6787 | 98.775 | 99.57 | 47392948.0 |
| 2024-09-05 | AAA | ETF | 25.05 | 25.05 | 25.02 | 25.02 | 5234.0 |
| 2024-09-05 | AAAU | ETF | 24.91 | 24.93 | 24.76 | 24.87 | 2377571.0 |
| 2024-09-05 | AADR | ETF | 61.8662 | 61.8662 | 61.8662 | 61.8662 | 164.0 |
| 2024-09-05 | AAPB | ETF | 27.43 | 28.33 | 27.43 | 27.59 | 59116.0 |
| 2024-09-05 | AAPD | ETF | 17.41 | 17.41 | 17.11 | 17.34 | 314127.0 |
| 2024-09-05 | AAPR | ETF | 25.8 | 25.8 | 25.7472 | 25.7472 | 827.0 |
| 2024-09-05 | AAPU | ETF | 35.06 | 36.24 | 35.06 | 35.3 | 690621.0 |
| 2024-09-05 | AAPX | ETF | 32.09 | 32.66 | 31.8 | 31.83 | 11577.0 |
| 2024-09-05 | AAPY | ETF | 26.8 | 26.89 | 26.7938 | 26.7938 | 533.0 |
| 2024-09-05 | AAXJ | ETF | 71.51 | 71.86 | 71.35 | 71.53 | 270745.0 |
| 2024-09-05 | ABCS | ETF | 27.62 | 27.62 | 27.36 | 27.36 | 1406.0 |
| 2024-09-05 | ABEQ | ETF | 32.56 | 32.56 | 32.29 | 32.3461 | 5596.0 |
| 2024-09-05 | ABNY | ETF | 79.0 | 80.75 | 79.0 | 80.614 | 2268.0 |
| 2024-09-05 | ACES | ETF | 28.04 | 28.2 | 27.77 | 27.88 | 119177.0 |
| 2024-09-05 | ACIO | ETF | 38.69 | 38.78 | 38.49 | 38.55 | 166142.0 |
| 2024-09-05 | ACSI | ETF | 56.68 | 56.69 | 56.5662 | 56.5662 | 307.0 |
| 2024-09-05 | ACT | ETF | 35.7 | 35.7 | 35.09 | 35.31 | 251931.0 |
| 2024-09-05 | ACTV | ETF | 32.72 | 32.73 | 32.4501 | 32.4501 | 4006.0 |
| 2024-09-05 | ACVF | ETF | 42.06 | 42.06 | 41.78 | 41.82 | 3737.0 |
| 2024-09-05 | ACWI | ETF | 114.41 | 114.93 | 113.79 | 114.25 | 1311854.0 |
| 2024-09-05 | ACWV | ETF | 113.53 | 113.63 | 112.44 | 112.92 | 157998.0 |
| 2024-09-05 | ACWX | ETF | 54.75 | 54.89 | 54.54 | 54.69 | 416320.0 |
| 2024-09-05 | ADFI | ETF | 8.75 | 8.8 | 8.72 | 8.74 | 12967.0 |
| 2024-09-05 | ADIV | ETF | 15.12 | 15.1715 | 15.12 | 15.1715 | 233.0 |
| 2024-09-05 | ADME | ETF | 44.6 | 44.85 | 44.45 | 44.5925 | 10925.0 |
| 2024-09-05 | ADPV | ETF | 31.62 | 31.62 | 31.3383 | 31.3383 | 1733.0 |
| 2024-09-05 | AEMB | ETF | 39.34 | 39.34 | 39.33 | 39.33 | 487.0 |
| 2024-09-05 | AESR | ETF | 16.1699 | 16.25 | 16.0901 | 16.14 | 15961.0 |
| 2024-09-05 | AETH | ETF | 30.96 | 30.9904 | 30.4879 | 30.4879 | 2573.0 |
| 2024-09-05 | AFIF | ETF | 9.2 | 9.22 | 9.2 | 9.21 | 15834.0 |
| 2024-09-05 | AFK | ETF | 15.75 | 16.031 | 15.59 | 15.8 | 96516.0 |
| 2024-09-05 | AFLG | ETF | 32.396 | 32.396 | 32.241 | 32.321 | 8335.0 |
| 2024-09-05 | AFMC | ETF | 30.34 | 30.34 | 30.314 | 30.314 | 388.0 |
| 2024-09-05 | AFSM | ETF | 29.18 | 29.28 | 29.12 | 29.21 | 6317.0 |
| 2024-09-05 | AFTY | ETF | 13.913 | 13.913 | 13.913 | 13.913 | 70.0 |
| 2024-09-05 | AGG | ETF | 101.02 | 101.115 | 100.75 | 101.06 | 11918593.0 |
| 2024-09-05 | AGGH | ETF | 21.82 | 21.82 | 21.5701 | 21.8 | 71171.0 |
| 2024-09-05 | AGGY | ETF | 44.67 | 44.75 | 44.59 | 44.75 | 188856.0 |
| 2024-09-05 | AGIX | ETF | 23.52 | 23.61 | 23.5 | 23.5024 | 654.0 |
| 2024-09-05 | AGMI | ETF | 25.19 | 25.19 | 24.7799 | 24.7799 | 108.0 |
| 2024-09-05 | AGNG | ETF | 32.75 | 32.75 | 32.3704 | 32.41 | 1309.0 |
| 2024-09-05 | AGOX | ETF | 27.66 | 27.71 | 27.22 | 27.71 | 38638.0 |
| 2024-09-05 | AGQ | ETF | 35.26 | 35.86 | 34.655 | 34.86 | 1542545.0 |
| 2024-09-05 | AGQI | ETF | 14.3 | 14.33 | 14.261 | 14.29 | 7401.0 |
> showing 50 of 3,494 rows — these rows as CSV