PREVIEW / etf_daily / 2024-04-12
file: by_date/etf_daily/2024/2024-04-12.parquet size: 119 KB rows: 3,325
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-12 | SPY | ETF | 514.37 | 515.82 | 509.08 | 510.85 | 92469100.0 |
| 2024-04-12 | QQQ | ETF | 441.1 | 442.24 | 436.88 | 438.27 | 53664995.0 |
| 2024-04-12 | IWM | ETF | 201.23 | 201.91 | 197.68 | 198.69 | 35367400.0 |
| 2024-04-12 | DIA | ETF | 382.31 | 382.93 | 378.81 | 379.87 | 5303800.0 |
| 2024-04-12 | GLD | ETF | 221.87 | 225.09 | 216.02 | 216.89 | 30876600.0 |
| 2024-04-12 | TLT | ETF | 90.64 | 90.95 | 90.28 | 90.29 | 47869400.0 |
| 2024-04-12 | AAA | ETF | 25.08 | 25.14 | 25.08 | 25.091 | 2300.0 |
| 2024-04-12 | AAAU | ETF | 23.73 | 24.07 | 23.11 | 23.19 | 5015800.0 |
| 2024-04-12 | AADR | ETF | 61.24 | 61.24 | 61.04 | 61.15 | 600.0 |
| 2024-04-12 | AAPB | ETF | 18.04 | 18.8457 | 18.0105 | 18.47 | 389126.0 |
| 2024-04-12 | AAPD | ETF | 22.31 | 22.33 | 21.83 | 22.03 | 306789.0 |
| 2024-04-12 | AAPR | ETF | 24.63 | 24.63 | 24.5161 | 24.5502 | 39115.0 |
| 2024-04-12 | AAPU | ETF | 23.2 | 24.31 | 23.2 | 23.82 | 1172197.0 |
| 2024-04-12 | AAPX | ETF | 21.1 | 22.02 | 21.1 | 21.56 | 80874.0 |
| 2024-04-12 | AAPY | ETF | 24.13 | 24.158 | 24.01 | 24.158 | 1155.0 |
| 2024-04-12 | AAXJ | ETF | 67.29 | 67.41 | 66.68 | 66.79 | 514300.0 |
| 2024-04-12 | ABCS | ETF | 26.23 | 26.23 | 25.85 | 25.85 | 5856.0 |
| 2024-04-12 | ABEQ | ETF | 29.36 | 29.48 | 29.36 | 29.432 | 700.0 |
| 2024-04-12 | ACES | ETF | 28.39 | 28.436 | 27.45 | 27.58 | 42600.0 |
| 2024-04-12 | ACIO | ETF | 35.66 | 35.68 | 35.39 | 35.46 | 178900.0 |
| 2024-04-12 | ACSI | ETF | 50.177 | 50.177 | 50.177 | 50.177 | 100.0 |
| 2024-04-12 | ACT | ETF | 29.91 | 29.91 | 29.46 | 29.59 | 157213.0 |
| 2024-04-12 | ACTV | ETF | 33.48 | 33.48 | 32.96 | 33.068 | 18700.0 |
| 2024-04-12 | ACVF | ETF | 39.2 | 39.2 | 38.89 | 38.954 | 5400.0 |
| 2024-04-12 | ACWF | ETF | 40.67 | 40.68 | 40.4022 | 40.4022 | 1564.0 |
| 2024-04-12 | ACWI | ETF | 108.09 | 108.41 | 107.03 | 107.33 | 3319500.0 |
| 2024-04-12 | ACWV | ETF | 102.49 | 102.6 | 101.75 | 101.83 | 136400.0 |
| 2024-04-12 | ACWX | ETF | 52.42 | 52.52 | 51.88 | 51.97 | 926800.0 |
| 2024-04-12 | ADFI | ETF | 8.39 | 8.42 | 8.39 | 8.394 | 18100.0 |
| 2024-04-12 | ADIV | ETF | 13.79 | 13.79 | 13.65 | 13.67 | 1400.0 |
| 2024-04-12 | ADME | ETF | 41.29 | 41.4 | 41.11 | 41.193 | 7600.0 |
| 2024-04-12 | ADPV | ETF | 29.65 | 29.65 | 29.2 | 29.2981 | 10407.0 |
| 2024-04-12 | ADVE | ETF | 31.6033 | 31.62 | 31.4624 | 31.4624 | 677.0 |
| 2024-04-12 | AEMB | ETF | 38.2 | 38.36 | 38.2 | 38.23 | 700.0 |
| 2024-04-12 | AESR | ETF | 15.16 | 15.16 | 15.09 | 15.12 | 32400.0 |
| 2024-04-12 | AETH | ETF | 46.12 | 46.17 | 41.02 | 42.47 | 35968.0 |
| 2024-04-12 | AFIF | ETF | 9.11 | 9.12 | 9.09 | 9.1 | 523500.0 |
| 2024-04-12 | AFK | ETF | 15.4 | 15.42 | 15.1 | 15.22 | 7900.0 |
| 2024-04-12 | AFLG | ETF | 30.014 | 30.014 | 30.014 | 30.014 | 100.0 |
| 2024-04-12 | AFMC | ETF | 28.591 | 28.7 | 28.591 | 28.599 | 1500.0 |
| 2024-04-12 | AFSM | ETF | 28.19 | 28.19 | 27.62 | 27.703 | 2100.0 |
| 2024-04-12 | AFTY | ETF | 13.627 | 13.627 | 13.627 | 13.627 | 100.0 |
| 2024-04-12 | AGG | ETF | 96.08 | 96.2 | 95.96 | 95.96 | 17284600.0 |
| 2024-04-12 | AGGH | ETF | 20.74 | 20.81 | 20.6444 | 20.765 | 41020.0 |
| 2024-04-12 | AGGY | ETF | 42.65 | 42.695 | 42.61 | 42.63 | 72100.0 |
| 2024-04-12 | AGNG | ETF | 28.98 | 28.98 | 28.67 | 28.74 | 2900.0 |
| 2024-04-12 | AGOX | ETF | 24.8 | 24.93 | 24.56 | 24.598 | 17500.0 |
| 2024-04-12 | AGQ | ETF | 39.61 | 40.83 | 35.95 | 36.24 | 4567500.0 |
| 2024-04-12 | AGQI | ETF | 13.72 | 13.75 | 13.61 | 13.635 | 21121.0 |
| 2024-04-12 | AGRH | ETF | 25.85 | 25.865 | 25.82 | 25.865 | 2894.0 |
> showing 50 of 3,325 rows — these rows as CSV