PREVIEW / etf_daily / 2024-07-15
file: by_date/etf_daily/2024/2024-07-15.parquet size: 132 KB rows: 3,454
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-07-15 | SPY | ETF | 562.03 | 564.8371 | 559.63 | 561.53 | 39703874.0 |
| 2024-07-15 | QQQ | ETF | 496.61 | 501.01 | 494.09 | 496.15 | 31151386.0 |
| 2024-07-15 | IWM | ETF | 214.79 | 218.24 | 214.3 | 217.19 | 48764771.0 |
| 2024-07-15 | DIA | ETF | 402.47 | 403.58 | 401.4 | 402.36 | 4430020.0 |
| 2024-07-15 | GLD | ETF | 223.39 | 225.59 | 223.02 | 223.83 | 5712710.0 |
| 2024-07-15 | TLT | ETF | 93.0 | 93.3 | 92.78 | 92.86 | 37816630.0 |
| 2024-07-15 | AAA | ETF | 25.0497 | 25.086 | 25.0497 | 25.086 | 6871.0 |
| 2024-07-15 | AAAU | ETF | 23.905 | 24.13 | 23.86 | 23.95 | 2549553.0 |
| 2024-07-15 | AADR | ETF | 63.57 | 63.57 | 62.99 | 63.32 | 869.0 |
| 2024-07-15 | AAPB | ETF | 31.72 | 31.9 | 30.87 | 31.23 | 289597.0 |
| 2024-07-15 | AAPD | ETF | 16.24 | 16.495 | 16.2099 | 16.39 | 324565.0 |
| 2024-07-15 | AAPR | ETF | 25.61 | 25.6295 | 25.53 | 25.53 | 5094.0 |
| 2024-07-15 | AAPU | ETF | 40.76 | 40.93 | 39.6084 | 40.06 | 1462901.0 |
| 2024-07-15 | AAPX | ETF | 36.83 | 37.09 | 35.9432 | 36.33 | 37518.0 |
| 2024-07-15 | AAPY | ETF | 27.8249 | 27.84 | 27.7834 | 27.7834 | 554.0 |
| 2024-07-15 | AAXJ | ETF | 74.76 | 74.78 | 74.255 | 74.34 | 236375.0 |
| 2024-07-15 | ABCS | ETF | 26.8418 | 27.025 | 26.8418 | 26.9081 | 1200.0 |
| 2024-07-15 | ABEQ | ETF | 30.9601 | 31.03 | 30.9601 | 30.9774 | 7732.0 |
| 2024-07-15 | ABNY | ETF | 103.5 | 103.5 | 100.6005 | 101.25 | 824.0 |
| 2024-07-15 | ACES | ETF | 31.76 | 31.76 | 30.95 | 31.03 | 69600.0 |
| 2024-07-15 | ACIO | ETF | 38.69 | 38.85 | 38.61 | 38.68 | 188809.0 |
| 2024-07-15 | ACSI | ETF | 56.462 | 56.462 | 56.462 | 56.462 | 18.0 |
| 2024-07-15 | ACT | ETF | 31.85 | 32.345 | 31.76 | 32.25 | 166885.0 |
| 2024-07-15 | ACTV | ETF | 33.074 | 33.1683 | 32.94 | 33.07 | 109041.0 |
| 2024-07-15 | ACVF | ETF | 42.49 | 42.49 | 42.34 | 42.3453 | 3548.0 |
| 2024-07-15 | ACWI | ETF | 116.42 | 116.68 | 115.77 | 116.07 | 2621927.0 |
| 2024-07-15 | ACWV | ETF | 107.24 | 107.33 | 106.88 | 106.99 | 89643.0 |
| 2024-07-15 | ACWX | ETF | 55.2 | 55.22 | 54.84 | 54.92 | 941241.0 |
| 2024-07-15 | ADFI | ETF | 8.56 | 8.59 | 8.56 | 8.561 | 19333.0 |
| 2024-07-15 | ADIV | ETF | 14.95 | 14.95 | 14.95 | 14.95 | 20.0 |
| 2024-07-15 | ADME | ETF | 45.1124 | 45.25 | 45.0029 | 45.0029 | 6037.0 |
| 2024-07-15 | ADPV | ETF | 31.0986 | 31.17 | 31.0347 | 31.0347 | 2437.0 |
| 2024-07-15 | AEMB | ETF | 39.4 | 39.4 | 38.715 | 38.715 | 123.0 |
| 2024-07-15 | AESR | ETF | 16.615 | 16.88 | 16.615 | 16.7543 | 20310.0 |
| 2024-07-15 | AETH | ETF | 43.95 | 44.75 | 43.815 | 44.5831 | 10775.0 |
| 2024-07-15 | AFIF | ETF | 9.1699 | 9.1775 | 9.1652 | 9.1652 | 3300.0 |
| 2024-07-15 | AFK | ETF | 16.56 | 16.7999 | 16.53 | 16.61 | 23378.0 |
| 2024-07-15 | AFLG | ETF | 32.67 | 32.67 | 32.4981 | 32.4981 | 3062.0 |
| 2024-07-15 | AFMC | ETF | 30.53 | 30.53 | 30.28 | 30.3208 | 1326.0 |
| 2024-07-15 | AFSM | ETF | 29.67 | 29.9526 | 29.5 | 29.73 | 7508.0 |
| 2024-07-15 | AFTY | ETF | 14.23 | 14.26 | 14.22 | 14.22 | 642.0 |
| 2024-07-15 | AGG | ETF | 98.15 | 98.28 | 98.025 | 98.05 | 6969720.0 |
| 2024-07-15 | AGGH | ETF | 20.97 | 21.15 | 20.97 | 21.07 | 144622.0 |
| 2024-07-15 | AGGY | ETF | 43.58 | 43.5851 | 43.49 | 43.49 | 104614.0 |
| 2024-07-15 | AGMI | ETF | 29.11 | 29.11 | 28.8892 | 28.8892 | 181.0 |
| 2024-07-15 | AGNG | ETF | 31.19 | 31.8 | 30.9 | 30.9 | 5629.0 |
| 2024-07-15 | AGOX | ETF | 29.06 | 29.06 | 28.59 | 28.6549 | 27440.0 |
| 2024-07-15 | AGQ | ETF | 41.04 | 41.96 | 40.4 | 40.86 | 1222559.0 |
| 2024-07-15 | AGQI | ETF | 14.72 | 14.72 | 14.61 | 14.635 | 30059.0 |
| 2024-07-15 | AGZ | ETF | 108.38 | 108.4899 | 108.37 | 108.45 | 24172.0 |
> showing 50 of 3,454 rows — these rows as CSV