PREVIEW / etf_daily / 2024-04-18
file: by_date/etf_daily/2024/2024-04-18.parquet size: 119 KB rows: 3,321
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-04-18 | SPY | ETF | 501.98 | 504.13 | 498.56 | 499.52 | 74548100.0 |
| 2024-04-18 | QQQ | ETF | 426.49 | 428.24 | 422.83 | 423.41 | 46549363.0 |
| 2024-04-18 | IWM | ETF | 193.7 | 195.66 | 192.15 | 192.84 | 40238200.0 |
| 2024-04-18 | DIA | ETF | 379.05 | 380.93 | 376.85 | 377.84 | 4579200.0 |
| 2024-04-18 | GLD | ETF | 221.31 | 221.46 | 219.31 | 220.34 | 6496900.0 |
| 2024-04-18 | TLT | ETF | 89.24 | 89.27 | 88.59 | 88.83 | 43839500.0 |
| 2024-04-18 | AAA | ETF | 25.08 | 25.15 | 25.08 | 25.11 | 10500.0 |
| 2024-04-18 | AAAU | ETF | 23.67 | 23.69 | 23.46 | 23.57 | 3881300.0 |
| 2024-04-18 | AADR | ETF | 59.94 | 59.94 | 59.59 | 59.84 | 600.0 |
| 2024-04-18 | AAPB | ETF | 16.66 | 16.7915 | 16.42 | 16.48 | 53919.0 |
| 2024-04-18 | AAPD | ETF | 23.15 | 23.365 | 23.08 | 23.31 | 147358.0 |
| 2024-04-18 | AAPR | ETF | 24.43 | 24.45 | 24.35 | 24.37 | 51475.0 |
| 2024-04-18 | AAPU | ETF | 21.55 | 21.655 | 21.16 | 21.27 | 251055.0 |
| 2024-04-18 | AAPX | ETF | 19.51 | 19.6 | 19.14 | 19.28 | 26318.0 |
| 2024-04-18 | AAPY | ETF | 23.27 | 23.27 | 23.1405 | 23.1405 | 301.0 |
| 2024-04-18 | AAXJ | ETF | 65.89 | 66.28 | 65.76 | 65.95 | 456800.0 |
| 2024-04-18 | ABCS | ETF | 25.5203 | 25.5203 | 25.35 | 25.3795 | 2232.0 |
| 2024-04-18 | ABEQ | ETF | 29.336 | 29.384 | 29.28 | 29.384 | 3300.0 |
| 2024-04-18 | ACES | ETF | 26.32 | 26.468 | 25.82 | 25.99 | 41700.0 |
| 2024-04-18 | ACIO | ETF | 34.98 | 35.119 | 34.872 | 34.88 | 636900.0 |
| 2024-04-18 | ACSI | ETF | 49.96 | 49.96 | 49.96 | 49.96 | 200.0 |
| 2024-04-18 | ACT | ETF | 29.39 | 29.73 | 29.36 | 29.48 | 183036.0 |
| 2024-04-18 | ACTV | ETF | 32.4 | 32.635 | 32.36 | 32.426 | 8600.0 |
| 2024-04-18 | ACVF | ETF | 38.29 | 38.44 | 38.115 | 38.129 | 5200.0 |
| 2024-04-18 | ACWF | ETF | 39.7703 | 39.7703 | 39.66 | 39.6854 | 2243.0 |
| 2024-04-18 | ACWI | ETF | 105.52 | 106.04 | 104.99 | 105.19 | 1116500.0 |
| 2024-04-18 | ACWV | ETF | 101.28 | 101.63 | 101.14 | 101.34 | 208100.0 |
| 2024-04-18 | ACWX | ETF | 51.28 | 51.51 | 51.1 | 51.19 | 904300.0 |
| 2024-04-18 | ADFI | ETF | 8.332 | 8.4 | 8.32 | 8.34 | 26600.0 |
| 2024-04-18 | ADIV | ETF | 13.58 | 13.58 | 13.58 | 13.58 | 100.0 |
| 2024-04-18 | ADME | ETF | 40.45 | 40.65 | 40.25 | 40.285 | 6800.0 |
| 2024-04-18 | ADPV | ETF | 28.09 | 28.55 | 27.95 | 28.0367 | 2352.0 |
| 2024-04-18 | ADVE | ETF | 31.07 | 31.0701 | 30.9717 | 30.9717 | 1031.0 |
| 2024-04-18 | AEMB | ETF | 37.952 | 37.952 | 37.943 | 37.943 | 100.0 |
| 2024-04-18 | AESR | ETF | 14.79 | 14.89 | 14.74 | 14.76 | 54200.0 |
| 2024-04-18 | AETH | ETF | 39.97 | 40.8 | 39.86 | 40.6005 | 13138.0 |
| 2024-04-18 | AFIF | ETF | 9.06 | 9.06 | 9.04 | 9.04 | 45100.0 |
| 2024-04-18 | AFK | ETF | 14.72 | 14.72 | 14.58 | 14.61 | 8900.0 |
| 2024-04-18 | AFLG | ETF | 29.31 | 29.34 | 29.31 | 29.34 | 300.0 |
| 2024-04-18 | AFMC | ETF | 28.26 | 28.26 | 27.931 | 27.931 | 1200.0 |
| 2024-04-18 | AFSM | ETF | 27.46 | 27.48 | 27.095 | 27.095 | 3200.0 |
| 2024-04-18 | AFTY | ETF | 14.185 | 14.185 | 14.185 | 14.185 | 100.0 |
| 2024-04-18 | AGG | ETF | 95.55 | 95.57 | 95.22 | 95.28 | 7717500.0 |
| 2024-04-18 | AGGH | ETF | 20.67 | 20.67 | 20.5701 | 20.61 | 36358.0 |
| 2024-04-18 | AGGY | ETF | 42.39 | 42.39 | 42.26 | 42.26 | 47200.0 |
| 2024-04-18 | AGNG | ETF | 28.35 | 28.404 | 28.17 | 28.18 | 1700.0 |
| 2024-04-18 | AGOX | ETF | 24.22 | 24.349 | 24.02 | 24.02 | 22300.0 |
| 2024-04-18 | AGQ | ETF | 37.57 | 37.69 | 36.53 | 36.85 | 939300.0 |
| 2024-04-18 | AGQI | ETF | 13.51 | 13.585 | 13.47 | 13.4905 | 27575.0 |
| 2024-04-18 | AGRH | ETF | 25.8911 | 25.93 | 25.8701 | 25.8701 | 8962.0 |
> showing 50 of 3,321 rows — these rows as CSV