PREVIEW / etf_daily / 2024-03-12
file: by_date/etf_daily/2024/2024-03-12.parquet size: 117 KB rows: 3,267
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-03-12 | SPY | ETF | 513.45 | 517.38 | 510.86 | 516.78 | 73114400.0 |
| 2024-03-12 | QQQ | ETF | 439.73 | 444.02 | 436.46 | 443.66 | 55300909.0 |
| 2024-03-12 | IWM | ETF | 205.15 | 205.92 | 203.39 | 204.91 | 34958900.0 |
| 2024-03-12 | DIA | ETF | 389.24 | 391.44 | 387.84 | 390.79 | 3275800.0 |
| 2024-03-12 | GLD | ETF | 200.42 | 200.63 | 199.16 | 199.79 | 9436600.0 |
| 2024-03-12 | TLT | ETF | 95.04 | 95.21 | 94.69 | 94.88 | 29566000.0 |
| 2024-03-12 | AAA | ETF | 25.06 | 25.12 | 25.06 | 25.06 | 10900.0 |
| 2024-03-12 | AAAU | ETF | 21.44 | 21.45 | 21.29 | 21.36 | 2245700.0 |
| 2024-03-12 | AADR | ETF | 59.8 | 60.5 | 59.8 | 60.5 | 3100.0 |
| 2024-03-12 | AAPB | ETF | 18.08 | 18.23 | 17.6501 | 18.11 | 399580.0 |
| 2024-03-12 | AAPD | ETF | 22.6 | 22.87 | 22.49 | 22.6 | 190119.0 |
| 2024-03-12 | AAPU | ETF | 23.02 | 23.2068 | 22.601 | 23.04 | 432845.0 |
| 2024-03-12 | AAPX | ETF | 21.19 | 21.329 | 20.66 | 21.1325 | 13609.0 |
| 2024-03-12 | AAXJ | ETF | 68.44 | 68.74 | 68.21 | 68.66 | 1757500.0 |
| 2024-03-12 | ABCS | ETF | 26.31 | 26.43 | 26.29 | 26.42 | 3543.0 |
| 2024-03-12 | ABEQ | ETF | 29.49 | 29.54 | 29.39 | 29.499 | 2700.0 |
| 2024-03-12 | ACES | ETF | 29.81 | 29.81 | 28.92 | 29.0 | 22100.0 |
| 2024-03-12 | ACIO | ETF | 35.38 | 35.66 | 35.27 | 35.65 | 81100.0 |
| 2024-03-12 | ACSI | ETF | 50.096 | 50.25 | 50.096 | 50.25 | 400.0 |
| 2024-03-12 | ACT | ETF | 29.46 | 29.87 | 29.31 | 29.87 | 277582.0 |
| 2024-03-12 | ACTV | ETF | 33.85 | 33.92 | 33.57 | 33.88 | 3800.0 |
| 2024-03-12 | ACVF | ETF | 39.65 | 39.941 | 39.51 | 39.941 | 18700.0 |
| 2024-03-12 | ACWF | ETF | 40.69 | 40.8962 | 40.6801 | 40.8962 | 4168.0 |
| 2024-03-12 | ACWI | ETF | 108.31 | 109.0 | 107.77 | 108.94 | 2195700.0 |
| 2024-03-12 | ACWV | ETF | 104.82 | 104.92 | 104.49 | 104.83 | 82400.0 |
| 2024-03-12 | ACWX | ETF | 52.99 | 53.29 | 52.8 | 53.29 | 1094700.0 |
| 2024-03-12 | ADFI | ETF | 8.51 | 8.54 | 8.51 | 8.52 | 9900.0 |
| 2024-03-12 | ADIV | ETF | 14.51 | 14.51 | 14.38 | 14.419 | 600.0 |
| 2024-03-12 | ADME | ETF | 41.41 | 41.57 | 41.31 | 41.557 | 10900.0 |
| 2024-03-12 | ADPV | ETF | 28.24 | 28.4592 | 28.24 | 28.4592 | 10301.0 |
| 2024-03-12 | AEMB | ETF | 38.51 | 38.519 | 38.38 | 38.38 | 1900.0 |
| 2024-03-12 | AESR | ETF | 15.25 | 15.46 | 15.25 | 15.45 | 16200.0 |
| 2024-03-12 | AETH | ETF | 54.84 | 54.84 | 52.375 | 53.98 | 14702.0 |
| 2024-03-12 | AFIF | ETF | 9.13 | 9.16 | 9.12 | 9.15 | 41300.0 |
| 2024-03-12 | AFK | ETF | 13.88 | 13.95 | 13.77 | 13.77 | 8300.0 |
| 2024-03-12 | AFLG | ETF | 30.157 | 30.157 | 30.157 | 30.157 | 100.0 |
| 2024-03-12 | AFMC | ETF | 29.0 | 29.089 | 28.949 | 29.068 | 1300.0 |
| 2024-03-12 | AFSM | ETF | 28.28 | 28.288 | 28.28 | 28.288 | 400.0 |
| 2024-03-12 | AFTY | ETF | 14.22 | 14.24 | 14.22 | 14.22 | 400.0 |
| 2024-03-12 | AGG | ETF | 98.02 | 98.04 | 97.8 | 97.91 | 7471900.0 |
| 2024-03-12 | AGGH | ETF | 21.7 | 21.7 | 21.5312 | 21.61 | 87329.0 |
| 2024-03-12 | AGGY | ETF | 43.52 | 43.53 | 43.44 | 43.465 | 65500.0 |
| 2024-03-12 | AGNG | ETF | 30.2 | 30.369 | 30.15 | 30.315 | 11200.0 |
| 2024-03-12 | AGOX | ETF | 25.62 | 26.03 | 25.53 | 26.03 | 46900.0 |
| 2024-03-12 | AGQ | ETF | 27.59 | 27.6 | 26.96 | 27.23 | 830900.0 |
| 2024-03-12 | AGQI | ETF | 13.81 | 13.9 | 13.79 | 13.9 | 18105.0 |
| 2024-03-12 | AGZ | ETF | 108.04 | 108.11 | 107.98 | 108.0 | 16100.0 |
| 2024-03-12 | AGZD | ETF | 22.12 | 22.16 | 21.95 | 22.12 | 67500.0 |
| 2024-03-12 | AHLT | ETF | 23.0463 | 23.09 | 23.0463 | 23.09 | 3028.0 |
| 2024-03-12 | AHYB | ETF | 45.388 | 45.43 | 45.32 | 45.383 | 3600.0 |
> showing 50 of 3,267 rows — these rows as CSV