PREVIEW / etf_daily / 2024-11-18
file: by_date/etf_daily/2024/2024-11-18.parquet size: 143 KB rows: 3,782
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-18 | SPY | ETF | 586.22 | 589.49 | 585.34 | 588.15 | 35660489.0 |
| 2024-11-18 | QQQ | ETF | 498.13 | 502.14 | 496.73 | 500.02 | 27192662.0 |
| 2024-11-18 | IWM | ETF | 229.22 | 230.6 | 228.13 | 228.93 | 28120954.0 |
| 2024-11-18 | DIA | ETF | 434.17 | 435.33 | 433.19 | 434.19 | 2202166.0 |
| 2024-11-18 | GLD | ETF | 240.46 | 241.495 | 240.45 | 241.09 | 6312535.0 |
| 2024-11-18 | TLT | ETF | 89.66 | 90.59 | 89.424 | 90.24 | 36016776.0 |
| 2024-11-18 | AAA | ETF | 25.14 | 25.1494 | 25.0635 | 25.095 | 19222.0 |
| 2024-11-18 | AAAU | ETF | 25.75 | 25.855 | 25.7401 | 25.81 | 1209289.0 |
| 2024-11-18 | AADR | ETF | 65.51 | 66.53 | 65.51 | 66.53 | 1511.0 |
| 2024-11-18 | AAPB | ETF | 27.94 | 28.7653 | 27.94 | 28.33 | 40880.0 |
| 2024-11-18 | AAPD | ETF | 17.05 | 17.05 | 16.72 | 16.86 | 370145.0 |
| 2024-11-18 | AAPR | ETF | 26.21 | 26.265 | 26.2007 | 26.265 | 9222.0 |
| 2024-11-18 | AAPU | ETF | 34.96 | 36.39 | 34.96 | 35.83 | 358548.0 |
| 2024-11-18 | AAPX | ETF | 32.2 | 33.05 | 32.2 | 32.57 | 11785.0 |
| 2024-11-18 | AAPY | ETF | 27.2946 | 27.2946 | 27.2946 | 27.2946 | 234.0 |
| 2024-11-18 | AAXJ | ETF | 73.82 | 74.345 | 73.78 | 74.32 | 209506.0 |
| 2024-11-18 | ABCS | ETF | 29.324 | 29.4551 | 29.324 | 29.4233 | 1368.0 |
| 2024-11-18 | ABEQ | ETF | 32.48 | 32.5709 | 32.47 | 32.5709 | 3645.0 |
| 2024-11-18 | ABNY | ETF | 78.4 | 78.4 | 77.2 | 77.75 | 6617.0 |
| 2024-11-18 | ACES | ETF | 26.51 | 26.88 | 26.34 | 26.58 | 643997.0 |
| 2024-11-18 | ACIO | ETF | 40.33 | 40.45 | 40.2405 | 40.36 | 92323.0 |
| 2024-11-18 | ACSI | ETF | 60.7115 | 60.7115 | 60.7115 | 60.7115 | 28.0 |
| 2024-11-18 | ACT | ETF | 35.09 | 35.09 | 33.9 | 33.91 | 248089.0 |
| 2024-11-18 | ACTV | ETF | 32.74 | 32.74 | 32.39 | 32.42 | 3830.0 |
| 2024-11-18 | ACVF | ETF | 44.69 | 44.88 | 44.6399 | 44.77 | 11523.0 |
| 2024-11-18 | ACWI | ETF | 118.78 | 119.44 | 118.545 | 119.23 | 2145704.0 |
| 2024-11-18 | ACWV | ETF | 112.09 | 112.6899 | 112.03 | 112.62 | 233385.0 |
| 2024-11-18 | ACWX | ETF | 53.4 | 53.79 | 53.36 | 53.75 | 1052650.0 |
| 2024-11-18 | ADFI | ETF | 8.49 | 8.53 | 8.48 | 8.52 | 24116.0 |
| 2024-11-18 | ADIV | ETF | 15.46 | 15.5781 | 15.46 | 15.5781 | 2630.0 |
| 2024-11-18 | ADME | ETF | 46.79 | 47.06 | 46.79 | 47.02 | 10901.0 |
| 2024-11-18 | ADPV | ETF | 36.16 | 36.38 | 36.0711 | 36.2877 | 12647.0 |
| 2024-11-18 | ADVE | ETF | 33.8 | 33.9836 | 33.8 | 33.9836 | 382.0 |
| 2024-11-18 | AESR | ETF | 17.34 | 17.39 | 17.34 | 17.3554 | 23747.0 |
| 2024-11-18 | AETH | ETF | 40.315 | 40.7517 | 40.0145 | 40.2868 | 5641.0 |
| 2024-11-18 | AFIF | ETF | 9.15 | 9.16 | 9.14 | 9.145 | 8253.0 |
| 2024-11-18 | AFK | ETF | 15.75 | 15.89 | 15.73 | 15.89 | 10048.0 |
| 2024-11-18 | AFLG | ETF | 34.92 | 35.09 | 34.8472 | 35.03 | 27317.0 |
| 2024-11-18 | AFMC | ETF | 33.24 | 33.3 | 33.14 | 33.19 | 14229.0 |
| 2024-11-18 | AFSM | ETF | 31.4 | 31.69 | 31.39 | 31.49 | 3362.0 |
| 2024-11-18 | AGG | ETF | 97.55 | 97.82 | 97.465 | 97.75 | 5238633.0 |
| 2024-11-18 | AGGH | ETF | 20.79 | 20.8 | 20.6322 | 20.8 | 182435.0 |
| 2024-11-18 | AGGS | ETF | 40.98 | 41.1 | 40.98 | 41.0783 | 2117.0 |
| 2024-11-18 | AGGY | ETF | 43.26 | 43.4 | 43.235 | 43.38 | 115659.0 |
| 2024-11-18 | AGIH | ETF | 24.5605 | 24.5605 | 24.5605 | 24.5605 | 109.0 |
| 2024-11-18 | AGIX | ETF | 27.21 | 27.29 | 27.04 | 27.12 | 2696.0 |
| 2024-11-18 | AGMI | ETF | 28.09 | 28.51 | 28.09 | 28.51 | 1611.0 |
| 2024-11-18 | AGNG | ETF | 30.66 | 30.88 | 30.61 | 30.7 | 22092.0 |
| 2024-11-18 | AGOX | ETF | 28.9 | 29.4 | 28.9 | 28.95 | 37760.0 |
| 2024-11-18 | AGQ | ETF | 38.96 | 39.84 | 38.95 | 39.53 | 1764379.0 |
> showing 50 of 3,782 rows — these rows as CSV