PREVIEW / etf_daily / 2024-04-05
file: by_date/etf_daily/2024/2024-04-05.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-05 | SPY | ETF | 514.46 | 520.44 | 514.01 | 518.43 | 74482100.0 |
| 2024-04-05 | QQQ | ETF | 436.78 | 443.17 | 435.96 | 440.47 | 54744634.0 |
| 2024-04-05 | IWM | ETF | 203.14 | 205.7 | 202.88 | 204.45 | 27561000.0 |
| 2024-04-05 | DIA | ETF | 386.35 | 390.45 | 386.08 | 388.86 | 4422700.0 |
| 2024-04-05 | GLD | ETF | 212.49 | 215.74 | 212.22 | 215.14 | 13363400.0 |
| 2024-04-05 | TLT | ETF | 91.69 | 92.18 | 91.38 | 91.39 | 42466800.0 |
| 2024-04-05 | AAA | ETF | 25.136 | 25.136 | 25.07 | 25.11 | 4900.0 |
| 2024-04-05 | AAAU | ETF | 22.73 | 23.07 | 22.7 | 23.0 | 3101700.0 |
| 2024-04-05 | AADR | ETF | 61.19 | 62.12 | 61.19 | 62.12 | 1100.0 |
| 2024-04-05 | AAPB | ETF | 17.11 | 17.27 | 17.02 | 17.14 | 55164.0 |
| 2024-04-05 | AAPD | ETF | 22.98 | 23.04 | 22.85 | 22.97 | 201814.0 |
| 2024-04-05 | AAPR | ETF | 24.72 | 24.8 | 24.65 | 24.7316 | 74916.0 |
| 2024-04-05 | AAPU | ETF | 22.07 | 22.25 | 21.91 | 22.07 | 152490.0 |
| 2024-04-05 | AAPX | ETF | 19.9 | 20.13 | 19.85 | 20.0117 | 19042.0 |
| 2024-04-05 | AAPY | ETF | 23.44 | 23.4857 | 23.44 | 23.4857 | 318.0 |
| 2024-04-05 | AAXJ | ETF | 67.8 | 68.14 | 67.6 | 67.97 | 706700.0 |
| 2024-04-05 | ABCS | ETF | 26.5074 | 26.6692 | 26.46 | 26.6509 | 5038.0 |
| 2024-04-05 | ABEQ | ETF | 30.032 | 30.19 | 30.032 | 30.176 | 11800.0 |
| 2024-04-05 | ACES | ETF | 28.42 | 28.585 | 28.15 | 28.34 | 70500.0 |
| 2024-04-05 | ACIO | ETF | 35.51 | 35.89 | 35.51 | 35.818 | 86300.0 |
| 2024-04-05 | ACSI | ETF | 51.076 | 51.076 | 51.076 | 51.076 | 100.0 |
| 2024-04-05 | ACT | ETF | 30.61 | 31.02 | 30.54 | 30.72 | 204047.0 |
| 2024-04-05 | ACTV | ETF | 33.9 | 34.12 | 33.9 | 34.02 | 11900.0 |
| 2024-04-05 | ACVF | ETF | 39.44 | 39.91 | 39.44 | 39.841 | 23100.0 |
| 2024-04-05 | ACWF | ETF | 41.0582 | 41.0781 | 41.0238 | 41.0238 | 1499.0 |
| 2024-04-05 | ACWI | ETF | 108.55 | 109.57 | 108.4 | 109.23 | 4344700.0 |
| 2024-04-05 | ACWV | ETF | 103.46 | 103.97 | 103.37 | 103.74 | 103200.0 |
| 2024-04-05 | ACWX | ETF | 52.88 | 53.2 | 52.76 | 53.1 | 1150800.0 |
| 2024-04-05 | ADFI | ETF | 8.457 | 8.49 | 8.457 | 8.475 | 4700.0 |
| 2024-04-05 | ADIV | ETF | 14.024 | 14.024 | 14.024 | 14.024 | 100.0 |
| 2024-04-05 | ADME | ETF | 41.468 | 41.817 | 41.468 | 41.748 | 9100.0 |
| 2024-04-05 | ADPV | ETF | 29.69 | 30.3 | 29.56 | 30.2753 | 6978.0 |
| 2024-04-05 | AEMB | ETF | 38.46 | 38.48 | 38.46 | 38.48 | 800.0 |
| 2024-04-05 | AESR | ETF | 15.32 | 15.45 | 15.32 | 15.42 | 15300.0 |
| 2024-04-05 | AETH | ETF | 43.49 | 44.21 | 43.49 | 44.0875 | 4640.0 |
| 2024-04-05 | AFIF | ETF | 9.13 | 9.13 | 9.11 | 9.12 | 40100.0 |
| 2024-04-05 | AFK | ETF | 15.0 | 15.2 | 14.99 | 15.15 | 6000.0 |
| 2024-04-05 | AFLG | ETF | 30.7 | 30.75 | 30.7 | 30.733 | 300.0 |
| 2024-04-05 | AFMC | ETF | 29.655 | 29.655 | 29.655 | 29.655 | 300.0 |
| 2024-04-05 | AFSM | ETF | 28.53 | 28.61 | 28.525 | 28.56 | 3300.0 |
| 2024-04-05 | AFTY | ETF | 14.09 | 14.104 | 14.08 | 14.091 | 2600.0 |
| 2024-04-05 | AGG | ETF | 96.76 | 97.0 | 96.68 | 96.68 | 12343600.0 |
| 2024-04-05 | AGGH | ETF | 21.17 | 21.17 | 21.0365 | 21.11 | 252756.0 |
| 2024-04-05 | AGGY | ETF | 42.94 | 43.058 | 42.94 | 42.945 | 77400.0 |
| 2024-04-05 | AGNG | ETF | 29.26 | 29.505 | 29.26 | 29.49 | 2700.0 |
| 2024-04-05 | AGOX | ETF | 25.21 | 25.21 | 25.01 | 25.15 | 22800.0 |
| 2024-04-05 | AGQ | ETF | 33.13 | 34.92 | 32.88 | 34.62 | 1942100.0 |
| 2024-04-05 | AGQI | ETF | 13.8121 | 13.92 | 13.8121 | 13.89 | 30888.0 |
| 2024-04-05 | AGRH | ETF | 25.8951 | 25.8951 | 25.885 | 25.885 | 866.0 |
| 2024-04-05 | AGZ | ETF | 107.25 | 107.36 | 107.22 | 107.22 | 231000.0 |
> showing 50 of 3,328 rows — these rows as CSV