PREVIEW / etf_daily / 2024-07-05
file: by_date/etf_daily/2024/2024-07-05.parquet size: 131 KB rows: 3,411
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-05 | SPY | ETF | 551.77 | 555.05 | 551.12 | 554.64 | 40374198.0 |
| 2024-07-05 | QQQ | ETF | 491.89 | 496.6 | 491.59 | 496.16 | 28495936.0 |
| 2024-07-05 | IWM | ETF | 201.21 | 201.625 | 199.88 | 200.87 | 17275400.0 |
| 2024-07-05 | DIA | ETF | 393.19 | 394.0 | 391.65 | 393.7 | 2010966.0 |
| 2024-07-05 | GLD | ETF | 219.58 | 221.28 | 219.58 | 220.93 | 5940112.0 |
| 2024-07-05 | TLT | ETF | 92.27 | 92.725 | 91.9 | 92.56 | 34836365.0 |
| 2024-07-05 | AAA | ETF | 25.01 | 25.1 | 25.01 | 25.0562 | 6802.0 |
| 2024-07-05 | AAAU | ETF | 23.49 | 23.675 | 23.485 | 23.635 | 2094995.0 |
| 2024-07-05 | AADR | ETF | 62.1101 | 62.6099 | 62.09 | 62.09 | 811.0 |
| 2024-07-05 | AAPB | ETF | 27.99 | 29.19 | 27.99 | 29.16 | 221565.0 |
| 2024-07-05 | AAPD | ETF | 17.33 | 17.3346 | 16.97 | 16.97 | 293509.0 |
| 2024-07-05 | AAPR | ETF | 25.3501 | 25.43 | 25.3501 | 25.415 | 3426.0 |
| 2024-07-05 | AAPU | ETF | 36.0 | 37.49 | 35.95 | 37.47 | 1211768.0 |
| 2024-07-05 | AAPX | ETF | 32.55 | 34.0 | 32.55 | 34.0 | 45638.0 |
| 2024-07-05 | AAPY | ETF | 27.18 | 27.36 | 27.17 | 27.36 | 856.0 |
| 2024-07-05 | AAXJ | ETF | 73.65 | 73.77 | 73.19 | 73.74 | 391227.0 |
| 2024-07-05 | ABCS | ETF | 25.685 | 25.76 | 25.685 | 25.7388 | 1701.0 |
| 2024-07-05 | ABEQ | ETF | 29.9608 | 30.1215 | 29.9608 | 30.1215 | 4195.0 |
| 2024-07-05 | ABNY | ETF | 103.7 | 104.1495 | 102.95 | 103.678 | 471.0 |
| 2024-07-05 | ACES | ETF | 29.12 | 29.21 | 28.8223 | 29.0287 | 20949.0 |
| 2024-07-05 | ACIO | ETF | 38.14 | 38.38 | 38.14 | 38.38 | 27721.0 |
| 2024-07-05 | ACSI | ETF | 56.0985 | 56.0985 | 56.0985 | 56.0985 | 80.0 |
| 2024-07-05 | ACT | ETF | 30.86 | 30.98 | 30.45 | 30.47 | 161692.0 |
| 2024-07-05 | ACTV | ETF | 31.89 | 31.8908 | 31.78 | 31.8908 | 7649.0 |
| 2024-07-05 | ACVF | ETF | 41.63 | 41.6924 | 41.59 | 41.6924 | 4748.0 |
| 2024-07-05 | ACWI | ETF | 114.03 | 114.715 | 113.93 | 114.66 | 1667749.0 |
| 2024-07-05 | ACWV | ETF | 104.84 | 105.31 | 104.62 | 105.27 | 279448.0 |
| 2024-07-05 | ACWX | ETF | 54.45 | 54.4787 | 53.96 | 54.32 | 541581.0 |
| 2024-07-05 | ADFI | ETF | 8.49 | 8.519 | 8.49 | 8.519 | 26005.0 |
| 2024-07-05 | ADIV | ETF | 14.86 | 14.86 | 14.86 | 14.86 | 97.0 |
| 2024-07-05 | ADME | ETF | 44.535 | 44.68 | 44.525 | 44.6532 | 2724.0 |
| 2024-07-05 | ADPV | ETF | 30.69 | 30.69 | 30.5 | 30.592 | 5596.0 |
| 2024-07-05 | AEMB | ETF | 38.64 | 38.66 | 38.56 | 38.56 | 2584.0 |
| 2024-07-05 | AESR | ETF | 16.58 | 16.68 | 16.57 | 16.68 | 39543.0 |
| 2024-07-05 | AETH | ETF | 38.95 | 39.21 | 38.4492 | 39.0036 | 26126.0 |
| 2024-07-05 | AFIF | ETF | 9.1267 | 9.15 | 9.1267 | 9.15 | 8014.0 |
| 2024-07-05 | AFK | ETF | 15.99 | 16.36 | 15.8614 | 16.17 | 81906.0 |
| 2024-07-05 | AFLG | ETF | 31.8 | 31.9 | 31.8 | 31.8999 | 8962.0 |
| 2024-07-05 | AFMC | ETF | 29.26 | 29.26 | 28.7974 | 28.8463 | 17310.0 |
| 2024-07-05 | AFSM | ETF | 28.0901 | 28.1 | 28.0 | 28.0051 | 6219.0 |
| 2024-07-05 | AFTY | ETF | 13.908 | 13.908 | 13.908 | 13.908 | 9.0 |
| 2024-07-05 | AGG | ETF | 97.45 | 97.63 | 97.305 | 97.58 | 3488321.0 |
| 2024-07-05 | AGGH | ETF | 20.85 | 20.96 | 20.85 | 20.91 | 58203.0 |
| 2024-07-05 | AGGS | ETF | 41.0 | 41.0637 | 41.0 | 41.0637 | 202.0 |
| 2024-07-05 | AGGY | ETF | 43.22 | 43.37 | 43.17 | 43.37 | 78729.0 |
| 2024-07-05 | AGMI | ETF | 27.29 | 27.4445 | 27.27 | 27.4445 | 1407.0 |
| 2024-07-05 | AGNG | ETF | 30.34 | 30.359 | 30.02 | 30.33 | 16601.0 |
| 2024-07-05 | AGOX | ETF | 28.271 | 28.3999 | 28.27 | 28.343 | 7167.0 |
| 2024-07-05 | AGQ | ETF | 41.48 | 43.2 | 41.27 | 42.45 | 2058309.0 |
| 2024-07-05 | AGQI | ETF | 14.5 | 14.5097 | 14.44 | 14.5097 | 3359.0 |
> showing 50 of 3,411 rows — these rows as CSV