PREVIEW / etf_daily / 2024-11-13
file: by_date/etf_daily/2024/2024-11-13.parquet size: 145 KB rows: 3,780
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-13 | SPY | ETF | 597.37 | 599.23 | 594.96 | 597.19 | 46354890.0 |
| 2024-11-13 | QQQ | ETF | 512.4 | 514.98 | 509.95 | 512.25 | 24567416.0 |
| 2024-11-13 | IWM | ETF | 238.95 | 239.88 | 234.83298 | 235.11 | 25857868.0 |
| 2024-11-13 | DIA | ETF | 439.91 | 441.55 | 438.44 | 439.81 | 2464930.0 |
| 2024-11-13 | GLD | ETF | 241.31 | 241.47 | 237.59 | 237.63 | 8283434.0 |
| 2024-11-13 | TLT | ETF | 91.515 | 91.54 | 89.72 | 89.8 | 49065701.0 |
| 2024-11-13 | AAA | ETF | 25.08 | 25.0968 | 25.0501 | 25.09 | 3102.0 |
| 2024-11-13 | AAAU | ETF | 25.83 | 25.85 | 25.44 | 25.445 | 2358022.0 |
| 2024-11-13 | AADR | ETF | 65.2405 | 65.2405 | 65.2405 | 65.2405 | 23.0 |
| 2024-11-13 | AAPB | ETF | 27.5 | 28.02 | 27.12 | 27.71 | 85998.0 |
| 2024-11-13 | AAPD | ETF | 17.16 | 17.2421 | 16.9502 | 17.05 | 161802.0 |
| 2024-11-13 | AAPR | ETF | 26.33 | 26.3723 | 26.32 | 26.3673 | 12661.0 |
| 2024-11-13 | AAPU | ETF | 34.7 | 35.48 | 34.3 | 34.98 | 357401.0 |
| 2024-11-13 | AAPX | ETF | 31.6496 | 32.1587 | 31.4355 | 31.84 | 8639.0 |
| 2024-11-13 | AAPY | ETF | 26.8193 | 26.975 | 26.8193 | 26.975 | 1504.0 |
| 2024-11-13 | AAXJ | ETF | 74.52 | 74.52 | 73.705 | 73.85 | 315833.0 |
| 2024-11-13 | ABCS | ETF | 29.87 | 29.87 | 29.6476 | 29.6476 | 1605.0 |
| 2024-11-13 | ABEQ | ETF | 32.375 | 32.4999 | 32.36 | 32.459 | 3883.0 |
| 2024-11-13 | ABNY | ETF | 83.7 | 83.7 | 81.265 | 82.35 | 13289.0 |
| 2024-11-13 | ACES | ETF | 27.16 | 27.6104 | 26.94 | 27.08 | 84244.0 |
| 2024-11-13 | ACIO | ETF | 40.97 | 41.09 | 40.8716 | 40.955 | 187719.0 |
| 2024-11-13 | ACSI | ETF | 61.167 | 61.167 | 61.167 | 61.167 | 9.0 |
| 2024-11-13 | ACT | ETF | 34.69 | 34.85 | 34.24 | 34.3 | 408960.0 |
| 2024-11-13 | ACTV | ETF | 33.85 | 33.99 | 33.5801 | 33.5846 | 11566.0 |
| 2024-11-13 | ACVF | ETF | 45.66 | 45.7 | 45.495 | 45.57 | 19720.0 |
| 2024-11-13 | ACWI | ETF | 120.45 | 120.66 | 119.875 | 120.31 | 2615139.0 |
| 2024-11-13 | ACWV | ETF | 113.71 | 113.745 | 113.4 | 113.56 | 88514.0 |
| 2024-11-13 | ACWX | ETF | 53.68 | 53.68 | 53.24 | 53.48 | 807127.0 |
| 2024-11-13 | ADFI | ETF | 8.55 | 8.58 | 8.4706 | 8.4942 | 18569.0 |
| 2024-11-13 | ADIV | ETF | 15.5301 | 15.5301 | 15.5104 | 15.5104 | 873.0 |
| 2024-11-13 | ADME | ETF | 47.72 | 47.95 | 47.6766 | 47.72 | 12656.0 |
| 2024-11-13 | ADPV | ETF | 36.5555 | 36.5555 | 35.9922 | 35.9922 | 2360.0 |
| 2024-11-13 | ADVE | ETF | 34.02 | 34.02 | 33.86 | 33.86 | 354.0 |
| 2024-11-13 | AESR | ETF | 17.76 | 17.78 | 17.695 | 17.695 | 43110.0 |
| 2024-11-13 | AETH | ETF | 41.38 | 42.62 | 40.05 | 40.5 | 34223.0 |
| 2024-11-13 | AFIF | ETF | 9.17 | 9.185 | 9.15 | 9.185 | 31121.0 |
| 2024-11-13 | AFK | ETF | 15.85 | 16.0154 | 15.63 | 15.69 | 7779.0 |
| 2024-11-13 | AFLG | ETF | 35.49 | 35.54 | 35.36 | 35.4 | 23862.0 |
| 2024-11-13 | AFMC | ETF | 34.19 | 34.21 | 33.76 | 33.81 | 11223.0 |
| 2024-11-13 | AFSM | ETF | 32.9 | 32.91 | 32.27 | 32.27 | 56535.0 |
| 2024-11-13 | AGG | ETF | 98.17 | 98.2 | 97.57 | 97.69 | 15871087.0 |
| 2024-11-13 | AGGH | ETF | 20.8499 | 20.8499 | 20.69 | 20.69 | 35815.0 |
| 2024-11-13 | AGGS | ETF | 41.05 | 41.08 | 41.05 | 41.05 | 1620.0 |
| 2024-11-13 | AGGY | ETF | 43.57 | 43.58 | 43.2808 | 43.32 | 59348.0 |
| 2024-11-13 | AGIH | ETF | 24.5627 | 24.5627 | 24.5627 | 24.5627 | 2.0 |
| 2024-11-13 | AGIX | ETF | 27.98 | 28.289 | 27.98 | 28.03 | 24689.0 |
| 2024-11-13 | AGMI | ETF | 27.599 | 27.599 | 27.32 | 27.32 | 631.0 |
| 2024-11-13 | AGNG | ETF | 31.79 | 31.79 | 31.55 | 31.6 | 6764.0 |
| 2024-11-13 | AGOX | ETF | 29.3624 | 29.55 | 29.33 | 29.4 | 23958.0 |
| 2024-11-13 | AGQ | ETF | 39.22 | 39.3 | 37.4702 | 37.5 | 1394723.0 |
> showing 50 of 3,780 rows — these rows as CSV