PREVIEW / etf_daily / 2024-11-12
file: by_date/etf_daily/2024/2024-11-12.parquet size: 144 KB rows: 3,774
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-11-12 | SPY | ETF | 598.68 | 599.29 | 594.37 | 596.9 | 42716237.0 |
| 2024-11-12 | QQQ | ETF | 513.77 | 514.66 | 509.83 | 512.91 | 25835288.0 |
| 2024-11-12 | IWM | ETF | 239.96 | 241.79 | 236.56 | 237.46 | 35828852.0 |
| 2024-11-12 | DIA | ETF | 443.58 | 444.22 | 439.0501 | 439.39 | 3446670.0 |
| 2024-11-12 | GLD | ETF | 241.29 | 241.66 | 239.39 | 240.05 | 9947616.0 |
| 2024-11-12 | TLT | ETF | 91.37 | 91.85 | 90.51 | 90.66 | 57736096.0 |
| 2024-11-12 | AAA | ETF | 25.09 | 25.09 | 25.06 | 25.065 | 6666.0 |
| 2024-11-12 | AAAU | ETF | 25.83 | 25.87 | 25.63 | 25.705 | 1720573.0 |
| 2024-11-12 | AADR | ETF | 65.36 | 65.61 | 65.23 | 65.61 | 448.0 |
| 2024-11-12 | AAPB | ETF | 27.57 | 27.7405 | 27.34 | 27.44 | 45347.0 |
| 2024-11-12 | AAPD | ETF | 17.09 | 17.19 | 17.03 | 17.14 | 116240.0 |
| 2024-11-12 | AAPR | ETF | 26.34 | 26.37 | 26.34 | 26.3554 | 501.0 |
| 2024-11-12 | AAPU | ETF | 34.84 | 35.17 | 34.51 | 34.79 | 276139.0 |
| 2024-11-12 | AAPX | ETF | 31.75 | 31.8812 | 31.45 | 31.69 | 13846.0 |
| 2024-11-12 | AAPY | ETF | 26.99 | 26.99 | 26.86 | 26.9496 | 2429.0 |
| 2024-11-12 | AAXJ | ETF | 74.72 | 74.8 | 74.1 | 74.34 | 613208.0 |
| 2024-11-12 | ABCS | ETF | 29.935 | 29.99 | 29.7484 | 29.7484 | 1803.0 |
| 2024-11-12 | ABEQ | ETF | 32.57 | 32.57 | 32.3505 | 32.4 | 6483.0 |
| 2024-11-12 | ABNY | ETF | 83.795 | 83.8 | 82.5 | 82.5065 | 7076.0 |
| 2024-11-12 | ACES | ETF | 27.76 | 27.76 | 26.8201 | 26.9 | 76031.0 |
| 2024-11-12 | ACIO | ETF | 41.11 | 41.11 | 40.86 | 41.01 | 137147.0 |
| 2024-11-12 | ACSI | ETF | 60.8476 | 60.8476 | 60.8476 | 60.8476 | 7.0 |
| 2024-11-12 | ACT | ETF | 34.47 | 34.895 | 34.35 | 34.62 | 456692.0 |
| 2024-11-12 | ACTV | ETF | 33.9108 | 33.95 | 33.55 | 33.6214 | 13145.0 |
| 2024-11-12 | ACVF | ETF | 45.8 | 45.8 | 45.4157 | 45.55 | 6884.0 |
| 2024-11-12 | ACWI | ETF | 121.09 | 121.12 | 120.01 | 120.55 | 1440838.0 |
| 2024-11-12 | ACWV | ETF | 113.97 | 114.14 | 113.52 | 113.59 | 63308.0 |
| 2024-11-12 | ACWX | ETF | 54.27 | 54.27 | 53.53 | 53.8 | 656263.0 |
| 2024-11-12 | ADFI | ETF | 8.48 | 8.5 | 8.48 | 8.5 | 11821.0 |
| 2024-11-12 | ADIV | ETF | 15.4925 | 15.4925 | 15.4925 | 15.4925 | 123.0 |
| 2024-11-12 | ADME | ETF | 47.7879 | 47.92 | 47.67 | 47.78 | 17925.0 |
| 2024-11-12 | ADPV | ETF | 36.41 | 36.47 | 35.96 | 36.2404 | 3712.0 |
| 2024-11-12 | ADVE | ETF | 34.1378 | 34.1378 | 34.1378 | 34.1378 | 4.0 |
| 2024-11-12 | AESR | ETF | 17.7726 | 17.7726 | 17.685 | 17.7448 | 20690.0 |
| 2024-11-12 | AETH | ETF | 41.9 | 42.2484 | 41.3 | 42.0 | 18904.0 |
| 2024-11-12 | AFIF | ETF | 9.1848 | 9.21 | 9.17 | 9.175 | 27569.0 |
| 2024-11-12 | AFK | ETF | 15.98 | 16.0 | 15.67 | 15.78 | 7483.0 |
| 2024-11-12 | AFLG | ETF | 35.5 | 35.5 | 35.3049 | 35.42 | 8963.0 |
| 2024-11-12 | AFMC | ETF | 34.378 | 34.378 | 33.92 | 33.96 | 5039.0 |
| 2024-11-12 | AFSM | ETF | 33.02 | 33.02 | 32.67 | 32.6749 | 7498.0 |
| 2024-11-12 | AGG | ETF | 97.98 | 98.14 | 97.6501 | 97.71 | 16771625.0 |
| 2024-11-12 | AGGH | ETF | 20.75 | 20.8414 | 20.69 | 20.7 | 48753.0 |
| 2024-11-12 | AGGS | ETF | 41.17 | 41.17 | 41.045 | 41.045 | 404.0 |
| 2024-11-12 | AGGY | ETF | 43.53 | 43.6 | 43.3523 | 43.39 | 126609.0 |
| 2024-11-12 | AGIH | ETF | 24.57 | 24.57 | 24.57 | 24.57 | 1.0 |
| 2024-11-12 | AGIX | ETF | 27.96 | 28.06 | 27.85 | 27.93 | 3141.0 |
| 2024-11-12 | AGMI | ETF | 27.96 | 27.96 | 27.7955 | 27.7955 | 118.0 |
| 2024-11-12 | AGNG | ETF | 32.18 | 32.18 | 31.76 | 31.78 | 3926.0 |
| 2024-11-12 | AGOX | ETF | 29.495 | 29.58 | 29.2686 | 29.4 | 17561.0 |
| 2024-11-12 | AGQ | ETF | 38.59 | 38.82 | 37.96 | 38.78 | 1037476.0 |
> showing 50 of 3,774 rows — these rows as CSV