PREVIEW / etf_daily / 2024-04-17
file: by_date/etf_daily/2024/2024-04-17.parquet size: 119 KB rows: 3,328
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-17 | SPY | ETF | 506.05 | 506.22 | 499.12 | 500.55 | 75910300.0 |
| 2024-04-17 | QQQ | ETF | 433.1 | 433.12 | 424.9 | 425.84 | 56880536.0 |
| 2024-04-17 | IWM | ETF | 196.47 | 196.62 | 192.99 | 193.0 | 38589500.0 |
| 2024-04-17 | DIA | ETF | 379.21 | 380.19 | 376.14 | 377.45 | 4584900.0 |
| 2024-04-17 | GLD | ETF | 221.05 | 221.76 | 218.52 | 219.59 | 11521100.0 |
| 2024-04-17 | TLT | ETF | 88.87 | 89.38 | 88.46 | 89.28 | 57947000.0 |
| 2024-04-17 | AAA | ETF | 25.1 | 25.15 | 25.1 | 25.1 | 4200.0 |
| 2024-04-17 | AAAU | ETF | 23.65 | 23.72 | 23.37 | 23.49 | 5193000.0 |
| 2024-04-17 | AADR | ETF | 59.77 | 59.77 | 59.77 | 59.77 | 200.0 |
| 2024-04-17 | AAPB | ETF | 17.03 | 17.2 | 16.7 | 16.7 | 132979.0 |
| 2024-04-17 | AAPD | ETF | 22.95 | 23.14 | 22.81 | 23.14 | 116695.0 |
| 2024-04-17 | AAPR | ETF | 24.44 | 24.48 | 24.35 | 24.35 | 60885.0 |
| 2024-04-17 | AAPU | ETF | 21.94 | 22.1889 | 21.52 | 21.53 | 297217.0 |
| 2024-04-17 | AAPX | ETF | 19.83 | 20.1 | 19.48 | 19.54 | 27726.0 |
| 2024-04-17 | AAPY | ETF | 23.3897 | 23.3897 | 23.3133 | 23.3133 | 349.0 |
| 2024-04-17 | AAXJ | ETF | 65.89 | 66.01 | 65.41 | 65.56 | 415600.0 |
| 2024-04-17 | ABCS | ETF | 25.5831 | 25.5831 | 25.29 | 25.29 | 1515.0 |
| 2024-04-17 | ABEQ | ETF | 29.21 | 29.27 | 29.14 | 29.205 | 3100.0 |
| 2024-04-17 | ACES | ETF | 26.31 | 26.6 | 26.13 | 26.25 | 15400.0 |
| 2024-04-17 | ACIO | ETF | 35.19 | 35.19 | 34.943 | 35.0 | 126000.0 |
| 2024-04-17 | ACSI | ETF | 49.946 | 49.946 | 49.946 | 49.946 | 100.0 |
| 2024-04-17 | ACT | ETF | 29.37 | 29.64 | 29.245 | 29.28 | 173351.0 |
| 2024-04-17 | ACTV | ETF | 32.63 | 32.71 | 32.3 | 32.333 | 9200.0 |
| 2024-04-17 | ACVF | ETF | 38.67 | 38.67 | 38.279 | 38.279 | 4000.0 |
| 2024-04-17 | ACWF | ETF | 39.9232 | 39.9232 | 39.7732 | 39.7732 | 1579.0 |
| 2024-04-17 | ACWI | ETF | 106.28 | 106.31 | 104.99 | 105.34 | 2289800.0 |
| 2024-04-17 | ACWV | ETF | 101.16 | 101.32 | 100.89 | 101.1 | 318100.0 |
| 2024-04-17 | ACWX | ETF | 51.49 | 51.5 | 51.0 | 51.2 | 2157200.0 |
| 2024-04-17 | ADFI | ETF | 8.34 | 8.37 | 8.33 | 8.35 | 5100.0 |
| 2024-04-17 | ADIV | ETF | 13.52 | 13.53 | 13.52 | 13.52 | 300.0 |
| 2024-04-17 | ADME | ETF | 40.82 | 40.82 | 40.4 | 40.45 | 6700.0 |
| 2024-04-17 | ADPV | ETF | 28.621 | 28.621 | 28.2797 | 28.2797 | 1048.0 |
| 2024-04-17 | ADVE | ETF | 30.935 | 30.9896 | 30.865 | 30.945 | 606.0 |
| 2024-04-17 | AEMB | ETF | 37.75 | 37.874 | 37.75 | 37.874 | 16800.0 |
| 2024-04-17 | AESR | ETF | 15.0 | 15.0 | 14.761 | 14.822 | 10600.0 |
| 2024-04-17 | AETH | ETF | 40.25 | 40.5 | 38.61 | 39.7515 | 6381.0 |
| 2024-04-17 | AFIF | ETF | 9.13 | 9.13 | 9.09 | 9.1 | 20300.0 |
| 2024-04-17 | AFK | ETF | 14.75 | 14.84 | 14.6 | 14.7 | 6200.0 |
| 2024-04-17 | AFLG | ETF | 29.464 | 29.464 | 29.464 | 29.464 | 100.0 |
| 2024-04-17 | AFMC | ETF | 28.19 | 28.23 | 28.04 | 28.051 | 8600.0 |
| 2024-04-17 | AFSM | ETF | 27.53 | 27.58 | 27.225 | 27.225 | 1100.0 |
| 2024-04-17 | AFTY | ETF | 14.091 | 14.12 | 14.091 | 14.12 | 700.0 |
| 2024-04-17 | AGG | ETF | 95.4 | 95.61 | 95.25 | 95.55 | 7567800.0 |
| 2024-04-17 | AGGH | ETF | 20.64 | 20.73 | 20.5001 | 20.665 | 25580.0 |
| 2024-04-17 | AGGY | ETF | 42.34 | 42.425 | 42.3 | 42.4 | 108700.0 |
| 2024-04-17 | AGNG | ETF | 28.36 | 28.36 | 28.29 | 28.339 | 900.0 |
| 2024-04-17 | AGOX | ETF | 24.49 | 24.49 | 24.12 | 24.34 | 53000.0 |
| 2024-04-17 | AGQ | ETF | 37.68 | 38.24 | 36.47 | 36.87 | 1676000.0 |
| 2024-04-17 | AGQI | ETF | 13.54 | 13.54 | 13.4401 | 13.495 | 38887.0 |
| 2024-04-17 | AGRH | ETF | 25.87 | 25.88 | 25.83 | 25.86 | 633.0 |
> showing 50 of 3,328 rows — these rows as CSV