PREVIEW / etf_daily / 2024-12-16
file: by_date/etf_daily/2024/2024-12-16.parquet size: 145 KB rows: 3,826
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-16 | SPY | ETF | 606.0 | 607.7795 | 605.21 | 606.79 | 42020403.0 |
| 2024-12-16 | QQQ | ETF | 533.08 | 539.15 | 533.0 | 538.17 | 31979863.0 |
| 2024-12-16 | IWM | ETF | 232.91 | 235.63 | 232.35 | 234.44 | 32073854.0 |
| 2024-12-16 | DIA | ETF | 439.65 | 440.67 | 437.95 | 438.37 | 1854409.0 |
| 2024-12-16 | GLD | ETF | 245.41 | 245.54 | 244.29 | 244.88 | 3455246.0 |
| 2024-12-16 | TLT | ETF | 90.55 | 90.6152 | 90.05 | 90.42 | 23126358.0 |
| 2024-12-16 | AAA | ETF | 25.04 | 25.1445 | 25.04 | 25.12 | 3570.0 |
| 2024-12-16 | AAAU | ETF | 26.27 | 26.29 | 26.1865 | 26.22 | 1352987.0 |
| 2024-12-16 | AADR | ETF | 70.61 | 71.69 | 70.61 | 71.69 | 5952.0 |
| 2024-12-16 | AAPB | ETF | 33.27 | 34.2 | 33.26 | 34.12 | 77696.0 |
| 2024-12-16 | AAPD | ETF | 15.4961 | 15.5299 | 15.35 | 15.37 | 175125.0 |
| 2024-12-16 | AAPR | ETF | 26.53 | 26.56 | 26.47 | 26.515 | 4377.0 |
| 2024-12-16 | AAPU | ETF | 37.39 | 38.47 | 37.39 | 38.39 | 496562.0 |
| 2024-12-16 | AAPX | ETF | 38.16 | 39.18 | 38.16 | 39.1185 | 36175.0 |
| 2024-12-16 | AAPY | ETF | 28.68 | 28.835 | 28.68 | 28.8 | 2373.0 |
| 2024-12-16 | AAXJ | ETF | 74.95 | 75.17 | 74.84 | 74.99 | 174232.0 |
| 2024-12-16 | ABCS | ETF | 29.8604 | 29.87 | 29.6873 | 29.6873 | 1651.0 |
| 2024-12-16 | ABEQ | ETF | 32.495 | 32.495 | 32.2995 | 32.2995 | 2845.0 |
| 2024-12-16 | ABFL | ETF | 69.203 | 69.47 | 69.19 | 69.2889 | 107475.0 |
| 2024-12-16 | ABHY | ETF | 21.37 | 21.4 | 21.3627 | 21.38 | 634.0 |
| 2024-12-16 | ABLD | ETF | 31.081 | 31.081 | 30.9152 | 30.9152 | 1957.0 |
| 2024-12-16 | ABLG | ETF | 29.68 | 29.69 | 29.51 | 29.562 | 98153.0 |
| 2024-12-16 | ABNY | ETF | 74.75 | 75.3 | 73.25 | 75.067 | 4666.0 |
| 2024-12-16 | ABOT | ETF | 37.955 | 38.5 | 37.955 | 38.42 | 256837.0 |
| 2024-12-16 | ACES | ETF | 27.33 | 27.67 | 27.2 | 27.53 | 133419.0 |
| 2024-12-16 | ACGR | ETF | 59.99 | 60.295 | 59.905 | 60.2112 | 2210.0 |
| 2024-12-16 | ACIO | ETF | 41.11 | 41.21 | 41.04 | 41.13 | 227087.0 |
| 2024-12-16 | ACLC | ETF | 73.02 | 73.32 | 73.02 | 73.13 | 55642.0 |
| 2024-12-16 | ACSI | ETF | 63.2348 | 63.2348 | 63.2348 | 63.2348 | 5.0 |
| 2024-12-16 | ACT | ETF | 34.36 | 34.63 | 34.261 | 34.28 | 162203.0 |
| 2024-12-16 | ACTV | ETF | 33.56 | 33.89 | 33.55 | 33.6903 | 5103.0 |
| 2024-12-16 | ACVF | ETF | 45.27 | 45.44 | 45.27 | 45.311 | 5412.0 |
| 2024-12-16 | ACWI | ETF | 122.2 | 122.58 | 122.11 | 122.31 | 5626358.0 |
| 2024-12-16 | ACWV | ETF | 113.23 | 113.315 | 112.595 | 112.71 | 101013.0 |
| 2024-12-16 | ACWX | ETF | 54.44 | 54.535 | 54.31 | 54.4 | 3648926.0 |
| 2024-12-16 | ADFI | ETF | 8.475 | 8.51 | 8.46 | 8.495 | 36727.0 |
| 2024-12-16 | ADIV | ETF | 15.445 | 15.445 | 15.445 | 15.445 | 144.0 |
| 2024-12-16 | ADME | ETF | 48.35 | 48.49 | 48.22 | 48.33 | 19366.0 |
| 2024-12-16 | ADPV | ETF | 36.97 | 37.64 | 36.97 | 37.5224 | 32148.0 |
| 2024-12-16 | ADVE | ETF | 34.0023 | 34.0023 | 34.0023 | 34.0023 | 11.0 |
| 2024-12-16 | AESR | ETF | 17.95 | 18.01 | 17.93 | 17.97 | 60211.0 |
| 2024-12-16 | AETH | ETF | 49.25 | 51.3004 | 49.25 | 51.07 | 5869.0 |
| 2024-12-16 | AFIF | ETF | 9.16 | 9.18 | 9.13 | 9.15 | 15570.0 |
| 2024-12-16 | AFIX | ETF | 24.8252 | 24.8252 | 24.8252 | 24.8252 | 2.0 |
| 2024-12-16 | AFK | ETF | 16.29 | 16.395 | 16.1 | 16.1 | 24357.0 |
| 2024-12-16 | AFLG | ETF | 35.68 | 35.73 | 35.5977 | 35.63 | 36289.0 |
| 2024-12-16 | AFMC | ETF | 33.23 | 33.39 | 33.2291 | 33.26 | 59446.0 |
| 2024-12-16 | AFSM | ETF | 31.96 | 32.03 | 31.79 | 31.88 | 10453.0 |
| 2024-12-16 | AGG | ETF | 98.07 | 98.0998 | 97.8841 | 98.01 | 7121876.0 |
| 2024-12-16 | AGGH | ETF | 20.98 | 20.98 | 20.8 | 20.88 | 41636.0 |
> showing 50 of 3,826 rows — these rows as CSV