PREVIEW / etf_daily / 2024-11-15
file: by_date/etf_daily/2024/2024-11-15.parquet size: 144 KB rows: 3,774
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-11-15 | SPY | ETF | 589.72 | 590.2 | 583.86 | 585.75 | 75837459.0 |
| 2024-11-15 | QQQ | ETF | 502.94 | 503.33 | 494.49 | 496.57 | 51461054.0 |
| 2024-11-15 | IWM | ETF | 232.22 | 232.29 | 227.81 | 228.48 | 37743863.0 |
| 2024-11-15 | DIA | ETF | 435.84 | 436.51 | 433.52 | 434.51 | 3239582.0 |
| 2024-11-15 | GLD | ETF | 237.57 | 237.88 | 236.33 | 236.59 | 6967664.0 |
| 2024-11-15 | TLT | ETF | 89.915 | 90.65 | 89.51 | 90.08 | 73553732.0 |
| 2024-11-15 | AAA | ETF | 25.0666 | 25.14 | 25.0666 | 25.14 | 4784.0 |
| 2024-11-15 | AAAU | ETF | 25.44 | 25.465 | 25.3 | 25.33 | 1529357.0 |
| 2024-11-15 | AADR | ETF | 64.6 | 64.881 | 64.6 | 64.84 | 889.0 |
| 2024-11-15 | AAPB | ETF | 27.88 | 28.07 | 27.44 | 27.61 | 76207.0 |
| 2024-11-15 | AAPD | ETF | 16.99 | 17.13 | 16.9478 | 17.08 | 247639.0 |
| 2024-11-15 | AAPR | ETF | 26.23 | 26.2419 | 26.2 | 26.2399 | 2853.0 |
| 2024-11-15 | AAPU | ETF | 35.26 | 35.47 | 34.71 | 34.92 | 248923.0 |
| 2024-11-15 | AAPX | ETF | 32.1 | 32.1 | 31.63 | 31.79 | 5509.0 |
| 2024-11-15 | AAPY | ETF | 27.0922 | 27.0922 | 27.0199 | 27.0373 | 2259.0 |
| 2024-11-15 | AAXJ | ETF | 73.74 | 73.74 | 73.275 | 73.44 | 711198.0 |
| 2024-11-15 | ABCS | ETF | 29.45 | 29.515 | 29.3127 | 29.3127 | 701.0 |
| 2024-11-15 | ABEQ | ETF | 32.4199 | 32.4199 | 32.28 | 32.315 | 2464.0 |
| 2024-11-15 | ABNY | ETF | 78.75 | 78.95 | 76.981 | 77.5 | 5339.0 |
| 2024-11-15 | ACES | ETF | 26.9 | 27.03 | 26.37 | 26.37 | 311050.0 |
| 2024-11-15 | ACIO | ETF | 40.56 | 40.56 | 40.21 | 40.27 | 159544.0 |
| 2024-11-15 | ACSI | ETF | 60.4644 | 60.4644 | 60.4644 | 60.4644 | 30.0 |
| 2024-11-15 | ACT | ETF | 34.36 | 34.41 | 33.91 | 34.03 | 287379.0 |
| 2024-11-15 | ACTV | ETF | 33.19 | 33.19 | 32.59 | 32.65 | 6666.0 |
| 2024-11-15 | ACVF | ETF | 45.03 | 45.03 | 44.5824 | 44.63 | 10379.0 |
| 2024-11-15 | ACWI | ETF | 119.34 | 119.34 | 118.32 | 118.64 | 2121404.0 |
| 2024-11-15 | ACWV | ETF | 112.66 | 112.66 | 111.838 | 111.89 | 121265.0 |
| 2024-11-15 | ACWX | ETF | 53.5 | 53.5 | 53.2001 | 53.35 | 914042.0 |
| 2024-11-15 | ADFI | ETF | 8.47 | 8.4899 | 8.4532 | 8.4759 | 10199.0 |
| 2024-11-15 | ADIV | ETF | 15.4 | 15.43 | 15.4 | 15.4283 | 3423.0 |
| 2024-11-15 | ADME | ETF | 47.09 | 47.09 | 46.77 | 46.82 | 15863.0 |
| 2024-11-15 | ADPV | ETF | 35.63 | 36.0721 | 35.63 | 36.0721 | 7270.0 |
| 2024-11-15 | ADVE | ETF | 33.7875 | 33.7875 | 33.7875 | 33.7875 | 3.0 |
| 2024-11-15 | AESR | ETF | 17.36 | 17.36 | 17.25 | 17.3 | 12224.0 |
| 2024-11-15 | AETH | ETF | 39.21 | 39.4406 | 38.51 | 39.4406 | 15380.0 |
| 2024-11-15 | AFIF | ETF | 9.15 | 9.16 | 9.14 | 9.1452 | 13445.0 |
| 2024-11-15 | AFK | ETF | 15.82 | 15.82 | 15.56 | 15.66 | 5288.0 |
| 2024-11-15 | AFLG | ETF | 34.99 | 34.99 | 34.82 | 34.8475 | 5327.0 |
| 2024-11-15 | AFMC | ETF | 33.52 | 33.52 | 33.13 | 33.1308 | 5604.0 |
| 2024-11-15 | AFSM | ETF | 32.1 | 32.1 | 31.33 | 31.4013 | 4729.0 |
| 2024-11-15 | AGG | ETF | 97.44 | 97.88 | 97.26 | 97.66 | 11595182.0 |
| 2024-11-15 | AGGH | ETF | 20.84 | 20.84 | 20.66 | 20.69 | 291611.0 |
| 2024-11-15 | AGGS | ETF | 40.97 | 41.08 | 40.97 | 41.0251 | 2200.0 |
| 2024-11-15 | AGGY | ETF | 43.22 | 43.4 | 43.12 | 43.32 | 67522.0 |
| 2024-11-15 | AGIH | ETF | 24.545 | 24.57 | 24.5382 | 24.5382 | 319.0 |
| 2024-11-15 | AGIX | ETF | 28.12 | 28.12 | 26.985 | 27.14 | 2386.0 |
| 2024-11-15 | AGMI | ETF | 27.5499 | 27.5499 | 27.5066 | 27.5066 | 105.0 |
| 2024-11-15 | AGNG | ETF | 30.857 | 30.92 | 30.72 | 30.815 | 2191.0 |
| 2024-11-15 | AGOX | ETF | 29.0 | 29.0 | 28.4709 | 28.89 | 101433.0 |
| 2024-11-15 | AGQ | ETF | 38.67 | 38.705 | 37.16 | 37.34 | 1571989.0 |
> showing 50 of 3,774 rows — these rows as CSV