PREVIEW / etf_daily / 2024-06-28
file: by_date/etf_daily/2024/2024-06-28.parquet size: 123 KB rows: 3,431
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-06-28 | SPY | ETF | 547.16 | 550.28 | 542.95 | 544.22 | 76144500.0 |
| 2024-06-28 | QQQ | ETF | 482.41 | 487.2 | 478.46 | 479.11 | 34881581.0 |
| 2024-06-28 | IWM | ETF | 203.88 | 204.64 | 201.32 | 202.89 | 35026000.0 |
| 2024-06-28 | DIA | ETF | 391.37 | 394.32 | 389.2 | 391.13 | 3623700.0 |
| 2024-06-28 | GLD | ETF | 215.64 | 215.81 | 214.82 | 215.01 | 3955100.0 |
| 2024-06-28 | TLT | ETF | 93.73 | 93.77 | 91.78 | 91.78 | 55119600.0 |
| 2024-06-28 | AAA | ETF | 25.0 | 25.07 | 25.0 | 25.032 | 4000.0 |
| 2024-06-28 | AAAU | ETF | 23.07 | 23.08 | 22.98 | 23.01 | 1080900.0 |
| 2024-06-28 | AADR | ETF | 62.185 | 62.045 | 62.045 | 62.045 | 355.0 |
| 2024-06-28 | AAPB | ETF | 26.61 | 26.63 | 25.26 | 25.34 | 225309.0 |
| 2024-06-28 | AAPD | ETF | 17.81 | 18.26 | 17.78 | 18.26 | 241430.0 |
| 2024-06-28 | AAPR | ETF | 25.305 | 25.37 | 25.23 | 25.29 | 41699.0 |
| 2024-06-28 | AAPU | ETF | 34.17 | 34.24 | 32.4502 | 32.56 | 1117611.0 |
| 2024-06-28 | AAPX | ETF | 30.97 | 30.97 | 29.57 | 29.57 | 19570.0 |
| 2024-06-28 | AAPY | ETF | 26.435 | 26.4695 | 26.435 | 26.4695 | 300.0 |
| 2024-06-28 | AAXJ | ETF | 72.33 | 72.42 | 71.83 | 71.98 | 694600.0 |
| 2024-06-28 | ABCS | ETF | 26.1 | 26.1 | 25.915 | 25.9909 | 2803.0 |
| 2024-06-28 | ABEQ | ETF | 30.15 | 30.0802 | 29.971 | 29.971 | 92.0 |
| 2024-06-28 | ABNY | ETF | 101.675 | 102.65 | 101.65 | 102.4365 | 775.0 |
| 2024-06-28 | ACES | ETF | 29.28 | 29.28 | 27.95 | 28.16 | 101100.0 |
| 2024-06-28 | ACIO | ETF | 37.86 | 38.04 | 37.63 | 37.63 | 75300.0 |
| 2024-06-28 | ACSI | ETF | 55.242 | 55.242 | 55.242 | 55.242 | 100.0 |
| 2024-06-28 | ACT | ETF | 30.59 | 30.95 | 30.46 | 30.66 | 726652.0 |
| 2024-06-28 | ACTV | ETF | 31.96 | 32.05 | 31.81 | 32.05 | 5500.0 |
| 2024-06-28 | ACTX | ETF | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 683.0 |
| 2024-06-28 | ACVF | ETF | 41.38 | 41.422 | 41.268 | 41.268 | 5000.0 |
| 2024-06-28 | ACWF | ETF | 42.47 | 42.76 | 42.38 | 42.3844 | 1572.0 |
| 2024-06-28 | ACWI | ETF | 112.87 | 113.32 | 112.08 | 112.4 | 3997400.0 |
| 2024-06-28 | ACWV | ETF | 104.76 | 105.11 | 104.42 | 104.64 | 242700.0 |
| 2024-06-28 | ACWX | ETF | 53.13 | 53.32 | 52.94 | 53.13 | 1538000.0 |
| 2024-06-28 | ADFI | ETF | 8.48 | 8.54 | 8.46 | 8.49 | 31900.0 |
| 2024-06-28 | ADIV | ETF | 14.69 | 14.69 | 14.62 | 14.62 | 200.0 |
| 2024-06-28 | ADME | ETF | 44.03 | 44.15 | 43.735 | 43.74 | 3700.0 |
| 2024-06-28 | ADPV | ETF | 30.49 | 30.49 | 30.155 | 30.2528 | 2801.0 |
| 2024-06-28 | AEMB | ETF | 38.38 | 38.38 | 38.2435 | 38.2435 | 52.0 |
| 2024-06-28 | AESR | ETF | 16.46 | 16.47 | 16.35 | 16.359 | 40100.0 |
| 2024-06-28 | AETH | ETF | 45.2 | 45.2 | 44.0395 | 44.0395 | 5198.0 |
| 2024-06-28 | AFIF | ETF | 9.12 | 9.13 | 9.1 | 9.11 | 27000.0 |
| 2024-06-28 | AFK | ETF | 15.75 | 15.96 | 15.53 | 15.74 | 26200.0 |
| 2024-06-28 | AFLG | ETF | 31.63 | 31.63 | 31.603 | 31.603 | 153.0 |
| 2024-06-28 | AFMC | ETF | 29.16 | 29.16 | 29.16 | 29.16 | 200.0 |
| 2024-06-28 | AFSM | ETF | 28.3144 | 28.3144 | 28.27 | 28.2919 | 31.0 |
| 2024-06-28 | AFTY | ETF | 13.939 | 13.939 | 13.939 | 13.939 | 100.0 |
| 2024-06-28 | AGG | ETF | 97.77 | 97.8 | 97.07 | 97.07 | 12781500.0 |
| 2024-06-28 | AGGH | ETF | 20.96 | 20.96 | 20.76 | 20.76 | 41737.0 |
| 2024-06-28 | AGGY | ETF | 43.18 | 43.207 | 42.94 | 42.96 | 111300.0 |
| 2024-06-28 | AGMI | ETF | 25.9 | 25.9 | 25.5294 | 25.5294 | 400.0 |
| 2024-06-28 | AGNG | ETF | 30.1589 | 30.1061 | 30.1061 | 30.1061 | 231.0 |
| 2024-06-28 | AGOX | ETF | 28.02 | 28.34 | 27.877 | 27.877 | 40400.0 |
| 2024-06-28 | AGQ | ETF | 37.92 | 37.97 | 36.97 | 37.09 | 965700.0 |
> showing 50 of 3,431 rows — these rows as CSV