PREVIEW / etf_daily / 2024-05-06
file: by_date/etf_daily/2024/2024-05-06.parquet size: 119 KB rows: 3,327
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-05-06 | SPY | ETF | 513.75 | 516.61 | 513.3 | 516.57 | 47264700.0 |
| 2024-05-06 | QQQ | ETF | 437.3 | 440.34 | 436.52 | 440.25 | 30227200.0 |
| 2024-05-06 | IWM | ETF | 203.47 | 204.78 | 203.38 | 204.51 | 23129800.0 |
| 2024-05-06 | DIA | ETF | 388.32 | 388.74 | 386.83 | 388.45 | 2596100.0 |
| 2024-05-06 | GLD | ETF | 215.14 | 215.91 | 214.47 | 215.2 | 6840500.0 |
| 2024-05-06 | TLT | ETF | 89.87 | 90.25 | 89.67 | 90.19 | 23868200.0 |
| 2024-05-06 | AAA | ETF | 25.13 | 25.13 | 25.04 | 25.1 | 12200.0 |
| 2024-05-06 | AAAU | ETF | 23.01 | 23.08 | 22.95 | 23.02 | 2855800.0 |
| 2024-05-06 | AADR | ETF | 62.78 | 63.59 | 62.78 | 63.53 | 1100.0 |
| 2024-05-06 | AAPB | ETF | 19.47 | 19.82 | 19.05 | 19.3 | 250459.0 |
| 2024-05-06 | AAPD | ETF | 21.32 | 21.5227 | 21.11 | 21.38 | 322197.0 |
| 2024-05-06 | AAPR | ETF | 24.62 | 24.67 | 24.56 | 24.67 | 53450.0 |
| 2024-05-06 | AAPU | ETF | 25.11 | 25.585 | 24.56 | 24.91 | 675661.0 |
| 2024-05-06 | AAPX | ETF | 22.76 | 23.05 | 22.28 | 22.47 | 38363.0 |
| 2024-05-06 | AAPY | ETF | 24.8 | 24.8 | 24.59 | 24.6337 | 2758.0 |
| 2024-05-06 | AAXJ | ETF | 70.82 | 70.88 | 70.63 | 70.85 | 241400.0 |
| 2024-05-06 | ABCS | ETF | 26.16 | 26.33 | 26.16 | 26.3108 | 1400.0 |
| 2024-05-06 | ABEQ | ETF | 30.19 | 30.23 | 30.137 | 30.23 | 9800.0 |
| 2024-05-06 | ACES | ETF | 29.1 | 29.36 | 29.09 | 29.27 | 30000.0 |
| 2024-05-06 | ACIO | ETF | 35.585 | 35.75 | 35.57 | 35.73 | 144300.0 |
| 2024-05-06 | ACSI | ETF | 52.62 | 52.62 | 52.62 | 52.62 | 100.0 |
| 2024-05-06 | ACT | ETF | 30.77 | 31.36 | 30.77 | 31.31 | 199914.0 |
| 2024-05-06 | ACTV | ETF | 34.03 | 34.03 | 33.907 | 33.985 | 3500.0 |
| 2024-05-06 | ACVF | ETF | 38.96 | 39.229 | 38.96 | 39.229 | 5400.0 |
| 2024-05-06 | ACWF | ETF | 40.96 | 41.0956 | 40.9 | 41.0956 | 2372.0 |
| 2024-05-06 | ACWI | ETF | 108.93 | 109.41 | 108.85 | 109.41 | 1740500.0 |
| 2024-05-06 | ACWV | ETF | 103.51 | 103.71 | 103.35 | 103.68 | 197500.0 |
| 2024-05-06 | ACWX | ETF | 53.64 | 53.74 | 53.53 | 53.72 | 877800.0 |
| 2024-05-06 | ADFI | ETF | 8.39 | 8.46 | 8.39 | 8.44 | 12200.0 |
| 2024-05-06 | ADIV | ETF | 14.72 | 14.72 | 14.649 | 14.649 | 1300.0 |
| 2024-05-06 | ADME | ETF | 41.18 | 41.368 | 41.18 | 41.368 | 16900.0 |
| 2024-05-06 | ADPV | ETF | 29.79 | 30.184 | 29.79 | 30.184 | 16728.0 |
| 2024-05-06 | AEMB | ETF | 38.411 | 38.411 | 38.4 | 38.4 | 1300.0 |
| 2024-05-06 | AESR | ETF | 15.14 | 15.27 | 15.14 | 15.26 | 217700.0 |
| 2024-05-06 | AETH | ETF | 40.96 | 41.17 | 40.4492 | 40.4492 | 3529.0 |
| 2024-05-06 | AFIF | ETF | 9.1 | 9.1 | 9.09 | 9.1 | 65300.0 |
| 2024-05-06 | AFK | ETF | 15.21 | 15.5 | 15.21 | 15.5 | 32800.0 |
| 2024-05-06 | AFLG | ETF | 30.12 | 30.235 | 30.12 | 30.235 | 700.0 |
| 2024-05-06 | AFMC | ETF | 29.54 | 29.54 | 29.536 | 29.536 | 600.0 |
| 2024-05-06 | AFSM | ETF | 28.85 | 28.85 | 28.61 | 28.66 | 1000.0 |
| 2024-05-06 | AFTY | ETF | 14.753 | 14.753 | 14.753 | 14.753 | 100.0 |
| 2024-05-06 | AGG | ETF | 96.21 | 96.33 | 96.15 | 96.26 | 10155500.0 |
| 2024-05-06 | AGGH | ETF | 20.71 | 20.9 | 20.71 | 20.81 | 33223.0 |
| 2024-05-06 | AGGY | ETF | 42.67 | 42.77 | 42.61 | 42.61 | 55500.0 |
| 2024-05-06 | AGMI | ETF | 25.95 | 25.95 | 25.8745 | 25.8745 | 101.0 |
| 2024-05-06 | AGNG | ETF | 29.32 | 29.39 | 29.3 | 29.32 | 1200.0 |
| 2024-05-06 | AGOX | ETF | 25.18 | 25.25 | 25.05 | 25.2 | 17700.0 |
| 2024-05-06 | AGQ | ETF | 34.02 | 34.4 | 33.68 | 34.29 | 1244900.0 |
| 2024-05-06 | AGQI | ETF | 13.9398 | 13.9762 | 13.92 | 13.9762 | 20101.0 |
| 2024-05-06 | AGZ | ETF | 107.12 | 107.12 | 107.04 | 107.07 | 17000.0 |
> showing 50 of 3,327 rows — these rows as CSV