PREVIEW / etf_daily / 2024-12-19
file: by_date/etf_daily/2024/2024-12-19.parquet size: 146 KB rows: 3,850
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-12-19 | SPY | ETF | 591.36 | 593.0 | 585.85 | 586.1 | 83958656.0 |
| 2024-12-19 | QQQ | ETF | 521.19 | 521.7599 | 513.83 | 514.17 | 46441754.0 |
| 2024-12-19 | IWM | ETF | 223.25 | 224.43 | 219.3299 | 219.86 | 51579494.0 |
| 2024-12-19 | DIA | ETF | 427.51 | 428.97 | 424.45 | 424.53 | 4817477.0 |
| 2024-12-19 | GLD | ETF | 239.67 | 240.05 | 238.73 | 239.6 | 8304143.0 |
| 2024-12-19 | TLT | ETF | 88.07 | 88.385 | 87.505 | 87.81 | 96180118.0 |
| 2024-12-19 | AAA | ETF | 25.1802 | 25.1802 | 25.0601 | 25.1291 | 4762.0 |
| 2024-12-19 | AAAU | ETF | 25.68 | 25.7051 | 25.56 | 25.665 | 2426920.0 |
| 2024-12-19 | AADR | ETF | 69.37 | 69.3999 | 68.72 | 68.72 | 1338.0 |
| 2024-12-19 | AAPB | ETF | 33.07 | 34.29 | 33.06 | 33.76 | 93435.0 |
| 2024-12-19 | AAPD | ETF | 15.59 | 15.605 | 15.32 | 15.46 | 994757.0 |
| 2024-12-19 | AAPR | ETF | 26.35 | 26.35 | 26.2301 | 26.2714 | 23069.0 |
| 2024-12-19 | AAPU | ETF | 37.2 | 38.5497 | 37.15 | 37.93 | 469533.0 |
| 2024-12-19 | AAPX | ETF | 38.05 | 39.2 | 38.0 | 38.73 | 29032.0 |
| 2024-12-19 | AAPY | ETF | 28.5 | 28.85 | 28.4999 | 28.6921 | 4867.0 |
| 2024-12-19 | AAXJ | ETF | 72.81 | 72.96 | 72.48 | 72.48 | 525882.0 |
| 2024-12-19 | ABCS | ETF | 28.6 | 28.61 | 28.4102 | 28.4102 | 1609.0 |
| 2024-12-19 | ABEQ | ETF | 31.55 | 31.63 | 31.461 | 31.461 | 2041.0 |
| 2024-12-19 | ABFL | ETF | 67.08 | 67.3487 | 66.56 | 66.56 | 11673.0 |
| 2024-12-19 | ABHY | ETF | 21.16 | 21.16 | 21.108 | 21.108 | 2776.0 |
| 2024-12-19 | ABLD | ETF | 29.64 | 29.6601 | 29.5593 | 29.5593 | 1518.0 |
| 2024-12-19 | ABLG | ETF | 28.791 | 28.9152 | 28.79 | 28.8567 | 11871.0 |
| 2024-12-19 | ABNY | ETF | 73.85 | 74.2355 | 73.05 | 73.95 | 1775.0 |
| 2024-12-19 | ABOT | ETF | 36.75 | 36.9 | 36.75 | 36.759 | 13322.0 |
| 2024-12-19 | ACES | ETF | 26.24 | 26.42 | 25.613 | 25.645 | 147315.0 |
| 2024-12-19 | ACGR | ETF | 58.1 | 58.1016 | 58.1 | 58.1016 | 238.0 |
| 2024-12-19 | ACIO | ETF | 40.47 | 40.47 | 40.11 | 40.11 | 488188.0 |
| 2024-12-19 | ACLC | ETF | 71.12 | 71.12 | 70.5974 | 70.5974 | 11106.0 |
| 2024-12-19 | ACSI | ETF | 61.3288 | 61.3288 | 61.3288 | 61.3288 | 98.0 |
| 2024-12-19 | ACT | ETF | 32.77 | 33.085 | 32.57 | 32.6 | 285782.0 |
| 2024-12-19 | ACTV | ETF | 32.28 | 32.4 | 32.0 | 32.1977 | 6146.0 |
| 2024-12-19 | ACVF | ETF | 44.23 | 44.23 | 43.68 | 43.69 | 12889.0 |
| 2024-12-19 | ACWI | ETF | 118.22 | 118.42 | 117.16 | 117.2 | 4804787.0 |
| 2024-12-19 | ACWV | ETF | 109.28 | 109.44 | 108.32 | 108.82 | 386721.0 |
| 2024-12-19 | ACWX | ETF | 52.51 | 52.51 | 52.09 | 52.12 | 2409621.0 |
| 2024-12-19 | ADFI | ETF | 8.36 | 8.38 | 8.3354 | 8.365 | 16440.0 |
| 2024-12-19 | ADIV | ETF | 15.1395 | 15.1395 | 15.1395 | 15.1395 | 2.0 |
| 2024-12-19 | ADME | ETF | 47.22 | 47.31 | 46.9528 | 46.9528 | 16250.0 |
| 2024-12-19 | ADPV | ETF | 35.305 | 35.7738 | 35.305 | 35.4428 | 3714.0 |
| 2024-12-19 | ADVE | ETF | 32.07 | 32.07 | 31.9506 | 31.9506 | 130.0 |
| 2024-12-19 | AESR | ETF | 17.39 | 17.44 | 17.2579 | 17.2579 | 22275.0 |
| 2024-12-19 | AETH | ETF | 46.56 | 46.56 | 42.467 | 42.467 | 10243.0 |
| 2024-12-19 | AFIF | ETF | 9.11 | 9.17 | 9.1 | 9.16 | 77713.0 |
| 2024-12-19 | AFIX | ETF | 24.5759 | 24.5759 | 24.5759 | 24.5759 | 6.0 |
| 2024-12-19 | AFK | ETF | 15.81 | 15.835 | 15.45 | 15.65 | 5808.0 |
| 2024-12-19 | AFLG | ETF | 34.758 | 34.758 | 34.42 | 34.42 | 740494.0 |
| 2024-12-19 | AFMC | ETF | 31.75 | 31.759 | 31.5674 | 31.5674 | 3764.0 |
| 2024-12-19 | AFSM | ETF | 30.58 | 30.58 | 30.2301 | 30.2477 | 12062.0 |
| 2024-12-19 | AGG | ETF | 96.76 | 96.82 | 96.5045 | 96.7 | 15475204.0 |
| 2024-12-19 | AGGH | ETF | 20.72 | 20.72 | 20.5001 | 20.67 | 148043.0 |
> showing 50 of 3,850 rows — these rows as CSV