PREVIEW / etf_daily / 2024-08-20
file: by_date/etf_daily/2024/2024-08-20.parquet size: 132 KB rows: 3,453
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-08-20 | SPY | ETF | 559.15 | 560.84 | 557.325 | 558.7 | 33692327.0 |
| 2024-08-20 | QQQ | ETF | 480.35 | 482.94 | 478.55 | 480.26 | 29209340.0 |
| 2024-08-20 | IWM | ETF | 214.89 | 214.95 | 212.05 | 212.69 | 21636619.0 |
| 2024-08-20 | DIA | ETF | 408.62 | 409.35 | 407.78 | 408.56 | 1982953.0 |
| 2024-08-20 | GLD | ETF | 233.71 | 234.01 | 231.13 | 232.46 | 9067311.0 |
| 2024-08-20 | TLT | ETF | 98.32 | 98.855 | 98.12 | 98.67 | 25212849.0 |
| 2024-08-20 | AAA | ETF | 25.13 | 25.14 | 25.03 | 25.12 | 10149.0 |
| 2024-08-20 | AAAU | ETF | 25.01 | 25.04 | 24.75 | 24.88 | 1751213.0 |
| 2024-08-20 | AADR | ETF | 62.622 | 62.622 | 62.622 | 62.622 | 65.0 |
| 2024-08-20 | AAPB | ETF | 28.59 | 28.89 | 28.59 | 28.73 | 60272.0 |
| 2024-08-20 | AAPD | ETF | 17.04 | 17.05 | 16.9393 | 16.98 | 232534.0 |
| 2024-08-20 | AAPR | ETF | 25.78 | 25.81 | 25.74 | 25.81 | 5627.0 |
| 2024-08-20 | AAPU | ETF | 36.57 | 37.0197 | 36.48 | 36.8 | 412220.0 |
| 2024-08-20 | AAPX | ETF | 32.98 | 33.5 | 32.98 | 33.37 | 16028.0 |
| 2024-08-20 | AAPY | ETF | 27.6 | 27.6 | 27.5845 | 27.5845 | 958.0 |
| 2024-08-20 | AAXJ | ETF | 73.38 | 73.39 | 72.815 | 72.94 | 219116.0 |
| 2024-08-20 | ABCS | ETF | 27.4 | 27.4 | 27.19 | 27.2455 | 8288.0 |
| 2024-08-20 | ABEQ | ETF | 31.864 | 31.8689 | 31.84 | 31.8689 | 567.0 |
| 2024-08-20 | ABNY | ETF | 81.35 | 81.35 | 80.15 | 80.228 | 1155.0 |
| 2024-08-20 | ACES | ETF | 28.71 | 28.745 | 28.15 | 28.15 | 12178.0 |
| 2024-08-20 | ACIO | ETF | 39.06 | 39.12 | 38.935 | 39.01 | 118784.0 |
| 2024-08-20 | ACSI | ETF | 56.15 | 56.4177 | 56.15 | 56.4177 | 150.0 |
| 2024-08-20 | ACT | ETF | 34.49 | 34.49 | 33.98 | 34.04 | 143784.0 |
| 2024-08-20 | ACTV | ETF | 32.45 | 32.45 | 32.26 | 32.26 | 5996.0 |
| 2024-08-20 | ACVF | ETF | 42.56 | 42.635 | 42.42 | 42.4845 | 5444.0 |
| 2024-08-20 | ACWI | ETF | 115.87 | 116.1 | 115.37 | 115.66 | 1562044.0 |
| 2024-08-20 | ACWV | ETF | 111.31 | 111.59 | 111.31 | 111.48 | 149562.0 |
| 2024-08-20 | ACWX | ETF | 55.16 | 55.16 | 54.785 | 54.9 | 515109.0 |
| 2024-08-20 | ADFI | ETF | 8.7195 | 8.73 | 8.68 | 8.73 | 16215.0 |
| 2024-08-20 | ADIV | ETF | 15.14 | 15.3041 | 15.14 | 15.3041 | 10589.0 |
| 2024-08-20 | ADME | ETF | 45.27 | 45.27 | 45.122 | 45.1805 | 6782.0 |
| 2024-08-20 | ADPV | ETF | 31.25 | 31.25 | 31.0489 | 31.0489 | 3933.0 |
| 2024-08-20 | AEMB | ETF | 39.605 | 39.605 | 39.605 | 39.605 | 5.0 |
| 2024-08-20 | AESR | ETF | 16.73 | 16.73 | 16.63 | 16.67 | 22819.0 |
| 2024-08-20 | AETH | ETF | 33.79 | 33.79 | 33.37 | 33.7611 | 1020.0 |
| 2024-08-20 | AFIF | ETF | 9.2 | 9.2 | 9.14 | 9.17 | 22292.0 |
| 2024-08-20 | AFK | ETF | 16.45 | 16.45 | 16.13 | 16.4 | 11050.0 |
| 2024-08-20 | AFLG | ETF | 32.83 | 32.83 | 32.61 | 32.6393 | 4696.0 |
| 2024-08-20 | AFMC | ETF | 30.9 | 30.9 | 30.5067 | 30.5067 | 814.0 |
| 2024-08-20 | AFSM | ETF | 29.6417 | 29.6417 | 29.46 | 29.4719 | 1387.0 |
| 2024-08-20 | AFTY | ETF | 14.1714 | 14.1714 | 14.1714 | 14.1714 | 22.0 |
| 2024-08-20 | AGG | ETF | 100.41 | 100.56 | 100.33 | 100.53 | 5505498.0 |
| 2024-08-20 | AGGH | ETF | 21.65 | 21.74 | 21.54 | 21.74 | 61131.0 |
| 2024-08-20 | AGGY | ETF | 44.44 | 44.52 | 44.42 | 44.52 | 67434.0 |
| 2024-08-20 | AGIX | ETF | 25.2 | 25.3 | 25.11 | 25.125 | 2089.0 |
| 2024-08-20 | AGMI | ETF | 27.3 | 27.3 | 27.01 | 27.01 | 742.0 |
| 2024-08-20 | AGNG | ETF | 32.39 | 32.57 | 32.39 | 32.52 | 9639.0 |
| 2024-08-20 | AGOX | ETF | 29.29 | 29.6999 | 29.1801 | 29.44 | 49091.0 |
| 2024-08-20 | AGQ | ETF | 38.08 | 38.27 | 36.54 | 36.92 | 1964480.0 |
| 2024-08-20 | AGQI | ETF | 14.38 | 14.405 | 14.38 | 14.3959 | 1884.0 |
> showing 50 of 3,453 rows — these rows as CSV