PREVIEW / etf_daily / 2024-07-11
file: by_date/etf_daily/2024/2024-07-11.parquet size: 131 KB rows: 3,430
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-07-11 | SPY | ETF | 561.44 | 562.33 | 555.83 | 556.48 | 53674687.0 |
| 2024-07-11 | QQQ | ETF | 503.07 | 503.28 | 490.725 | 491.93 | 49966590.0 |
| 2024-07-11 | IWM | ETF | 207.9 | 211.225 | 206.94 | 210.68 | 65516064.0 |
| 2024-07-11 | DIA | ETF | 397.5 | 398.89 | 396.31 | 397.63 | 4016943.0 |
| 2024-07-11 | GLD | ETF | 222.65 | 224.1489 | 221.48 | 223.25 | 9320228.0 |
| 2024-07-11 | TLT | ETF | 93.68 | 94.135 | 93.47 | 93.54 | 49301770.0 |
| 2024-07-11 | AAA | ETF | 25.0401 | 25.11 | 25.04 | 25.11 | 2788.0 |
| 2024-07-11 | AAAU | ETF | 23.825 | 23.975 | 23.7 | 23.87 | 1579889.0 |
| 2024-07-11 | AADR | ETF | 63.43 | 63.43 | 63.25 | 63.25 | 1628.0 |
| 2024-07-11 | AAPB | ETF | 30.48 | 30.64 | 29.0 | 29.46 | 324433.0 |
| 2024-07-11 | AAPD | ETF | 16.58 | 17.0001 | 16.55 | 16.87 | 301397.0 |
| 2024-07-11 | AAPR | ETF | 25.512 | 25.512 | 25.46 | 25.495 | 7926.0 |
| 2024-07-11 | AAPU | ETF | 39.26 | 39.38 | 37.17 | 37.79 | 1852141.0 |
| 2024-07-11 | AAPX | ETF | 35.54 | 35.64 | 33.82 | 34.28 | 75299.0 |
| 2024-07-11 | AAPY | ETF | 27.47 | 27.47 | 27.37 | 27.4376 | 1040.0 |
| 2024-07-11 | AAXJ | ETF | 75.33 | 75.47 | 74.83 | 75.0 | 239708.0 |
| 2024-07-11 | ABCS | ETF | 26.3848 | 26.46 | 26.3848 | 26.45 | 1702.0 |
| 2024-07-11 | ABEQ | ETF | 30.62 | 30.75 | 30.62 | 30.7419 | 1429.0 |
| 2024-07-11 | ABNY | ETF | 103.85 | 103.85 | 99.968 | 99.968 | 1706.0 |
| 2024-07-11 | ACES | ETF | 30.64 | 31.27 | 30.57 | 31.03 | 264391.0 |
| 2024-07-11 | ACIO | ETF | 38.77 | 38.77 | 38.34 | 38.39 | 74943.0 |
| 2024-07-11 | ACSI | ETF | 56.1238 | 56.1238 | 56.1238 | 56.1238 | 69.0 |
| 2024-07-11 | ACT | ETF | 30.74 | 31.38 | 30.74 | 31.3 | 247609.0 |
| 2024-07-11 | ACTV | ETF | 31.86 | 32.6333 | 31.86 | 32.6333 | 5442.0 |
| 2024-07-11 | ACVF | ETF | 42.29 | 42.29 | 41.935 | 41.9835 | 5177.0 |
| 2024-07-11 | ACWI | ETF | 116.09 | 116.38 | 115.225 | 115.35 | 3787400.0 |
| 2024-07-11 | ACWV | ETF | 105.99 | 106.66 | 105.99 | 106.47 | 112364.0 |
| 2024-07-11 | ACWX | ETF | 55.1 | 55.215 | 54.86 | 54.91 | 602251.0 |
| 2024-07-11 | ADFI | ETF | 8.56 | 8.5699 | 8.555 | 8.569 | 12029.0 |
| 2024-07-11 | ADIV | ETF | 15.11 | 15.11 | 15.015 | 15.015 | 508.0 |
| 2024-07-11 | ADME | ETF | 45.12 | 45.12 | 44.64 | 44.6789 | 4281.0 |
| 2024-07-11 | ADPV | ETF | 30.83 | 31.2272 | 30.83 | 31.2272 | 7002.0 |
| 2024-07-11 | AEMB | ETF | 38.795 | 38.795 | 38.795 | 38.795 | 0.0 |
| 2024-07-11 | AESR | ETF | 16.785 | 16.79 | 16.674 | 16.7 | 19167.0 |
| 2024-07-11 | AETH | ETF | 41.33 | 41.33 | 40.6237 | 40.6237 | 6388.0 |
| 2024-07-11 | AFIF | ETF | 9.1514 | 9.17 | 9.1514 | 9.16 | 30654.0 |
| 2024-07-11 | AFK | ETF | 16.35 | 16.75 | 16.35 | 16.5 | 24458.0 |
| 2024-07-11 | AFLG | ETF | 32.25 | 32.2797 | 32.25 | 32.2797 | 242.0 |
| 2024-07-11 | AFMC | ETF | 29.66 | 30.0 | 29.66 | 29.9509 | 1739.0 |
| 2024-07-11 | AFSM | ETF | 29.0689 | 29.12 | 28.92 | 29.0757 | 1078.0 |
| 2024-07-11 | AFTY | ETF | 14.1 | 14.19 | 14.1 | 14.18 | 1423.0 |
| 2024-07-11 | AGG | ETF | 98.18 | 98.31 | 98.09 | 98.12 | 3763534.0 |
| 2024-07-11 | AGGH | ETF | 21.02 | 21.1399 | 21.02 | 21.03 | 63643.0 |
| 2024-07-11 | AGGY | ETF | 43.5 | 43.5736 | 43.5 | 43.525 | 59514.0 |
| 2024-07-11 | AGMI | ETF | 28.89 | 29.1444 | 28.89 | 29.1444 | 4021.0 |
| 2024-07-11 | AGNG | ETF | 30.83 | 31.01 | 30.75 | 30.97 | 2491.0 |
| 2024-07-11 | AGOX | ETF | 29.07 | 29.07 | 28.53 | 28.6839 | 14653.0 |
| 2024-07-11 | AGQ | ETF | 43.08 | 43.5937 | 42.3 | 42.97 | 1581397.0 |
| 2024-07-11 | AGQI | ETF | 14.7 | 14.71 | 14.65 | 14.65 | 16405.0 |
| 2024-07-11 | AGZ | ETF | 108.36 | 108.4399 | 108.29 | 108.29 | 9943.0 |
> showing 50 of 3,430 rows — these rows as CSV