PREVIEW / etf_daily / 2024-12-12
file: by_date/etf_daily/2024/2024-12-12.parquet size: 145 KB rows: 3,814
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-12 | SPY | ETF | 606.58 | 607.16 | 604.33 | 604.33 | 31188406.0 |
| 2024-12-12 | QQQ | ETF | 527.68 | 528.96 | 526.02 | 526.5 | 23577504.0 |
| 2024-12-12 | IWM | ETF | 237.16 | 237.65 | 234.35 | 234.68 | 21313336.0 |
| 2024-12-12 | DIA | ETF | 442.49 | 443.12 | 440.0549 | 440.27 | 3301137.0 |
| 2024-12-12 | GLD | ETF | 247.81 | 248.24 | 246.87 | 247.28 | 9945619.0 |
| 2024-12-12 | TLT | ETF | 91.64 | 91.746 | 91.0 | 91.08 | 43337904.0 |
| 2024-12-12 | AAA | ETF | 25.1123 | 25.1537 | 25.08 | 25.13 | 2704.0 |
| 2024-12-12 | AAAU | ETF | 26.55 | 26.58 | 26.4185 | 26.48 | 2667945.0 |
| 2024-12-12 | AADR | ETF | 70.01 | 70.61 | 69.92 | 70.13 | 3657.0 |
| 2024-12-12 | AAPB | ETF | 33.03 | 33.5031 | 32.74 | 33.31 | 80364.0 |
| 2024-12-12 | AAPD | ETF | 15.61 | 15.7 | 15.5079 | 15.56 | 215626.0 |
| 2024-12-12 | AAPR | ETF | 26.51 | 26.515 | 26.48 | 26.5035 | 5881.0 |
| 2024-12-12 | AAPU | ETF | 37.16 | 37.74 | 36.74 | 37.49 | 537922.0 |
| 2024-12-12 | AAPX | ETF | 37.68 | 38.5 | 37.68 | 38.32 | 28914.0 |
| 2024-12-12 | AAPY | ETF | 28.41 | 28.68 | 28.41 | 28.5891 | 2012.0 |
| 2024-12-12 | AAXJ | ETF | 75.22 | 75.57 | 75.15 | 75.27 | 478917.0 |
| 2024-12-12 | ABCS | ETF | 29.99 | 30.055 | 29.9249 | 29.9249 | 2834.0 |
| 2024-12-12 | ABEQ | ETF | 32.64 | 32.6465 | 32.52 | 32.52 | 3753.0 |
| 2024-12-12 | ABNY | ETF | 77.5 | 78.3 | 76.4 | 77.55 | 4328.0 |
| 2024-12-12 | ACES | ETF | 27.72 | 27.72 | 27.35 | 27.36 | 427358.0 |
| 2024-12-12 | ACGR | ETF | 59.76 | 59.9 | 59.7384 | 59.7384 | 13423.0 |
| 2024-12-12 | ACIO | ETF | 41.19 | 41.19 | 41.0001 | 41.03 | 131538.0 |
| 2024-12-12 | ACLC | ETF | 73.21 | 73.51 | 73.09 | 73.09 | 57467.0 |
| 2024-12-12 | ACSI | ETF | 63.4638 | 63.4638 | 63.4638 | 63.4638 | 105.0 |
| 2024-12-12 | ACT | ETF | 34.51 | 34.95 | 34.48 | 34.61 | 177327.0 |
| 2024-12-12 | ACTV | ETF | 33.9256 | 33.9256 | 33.7209 | 33.76 | 8714.0 |
| 2024-12-12 | ACVF | ETF | 45.51 | 45.51 | 45.22 | 45.2228 | 5419.0 |
| 2024-12-12 | ACWI | ETF | 122.71 | 122.9 | 122.175 | 122.2 | 2531955.0 |
| 2024-12-12 | ACWV | ETF | 113.7 | 113.943 | 113.49 | 113.55 | 92724.0 |
| 2024-12-12 | ACWX | ETF | 54.94 | 55.05 | 54.6548 | 54.67 | 1236618.0 |
| 2024-12-12 | ADFI | ETF | 8.52 | 8.54 | 8.4993 | 8.4993 | 16103.0 |
| 2024-12-12 | ADIV | ETF | 15.88 | 15.88 | 15.825 | 15.825 | 393.0 |
| 2024-12-12 | ADME | ETF | 48.2208 | 48.3081 | 48.1004 | 48.1482 | 11987.0 |
| 2024-12-12 | ADPV | ETF | 37.27 | 37.27 | 37.01 | 37.0633 | 3140.0 |
| 2024-12-12 | ADVE | ETF | 34.2221 | 34.2221 | 34.2221 | 34.2221 | 21.0 |
| 2024-12-12 | AESR | ETF | 17.89 | 17.929 | 17.86 | 17.86 | 42922.0 |
| 2024-12-12 | AETH | ETF | 50.17 | 50.36 | 48.68 | 48.9669 | 8290.0 |
| 2024-12-12 | AFIF | ETF | 9.19 | 9.19 | 9.1509 | 9.155 | 50992.0 |
| 2024-12-12 | AFK | ETF | 16.69 | 16.715 | 16.48 | 16.5 | 7838.0 |
| 2024-12-12 | AFLG | ETF | 35.88 | 35.89 | 35.72 | 35.73 | 12668.0 |
| 2024-12-12 | AFMC | ETF | 33.6 | 33.6 | 33.4932 | 33.4932 | 2004.0 |
| 2024-12-12 | AFSM | ETF | 32.17 | 32.2159 | 32.01 | 32.01 | 3218.0 |
| 2024-12-12 | AGG | ETF | 98.53 | 98.58 | 98.25 | 98.29 | 11871146.0 |
| 2024-12-12 | AGGH | ETF | 21.16 | 21.16 | 20.9 | 20.99 | 65723.0 |
| 2024-12-12 | AGGS | ETF | 41.2853 | 41.2853 | 41.2853 | 41.2853 | 23.0 |
| 2024-12-12 | AGGY | ETF | 43.74 | 43.7409 | 43.63 | 43.63 | 94009.0 |
| 2024-12-12 | AGIH | ETF | 24.6053 | 24.6053 | 24.6053 | 24.6053 | 29.0 |
| 2024-12-12 | AGIX | ETF | 29.85 | 29.95 | 29.79 | 29.79 | 4333.0 |
| 2024-12-12 | AGMI | ETF | 28.76 | 28.76 | 28.0838 | 28.0838 | 981.0 |
| 2024-12-12 | AGNG | ETF | 31.21 | 31.245 | 30.94 | 30.94 | 1755.0 |
> showing 50 of 3,814 rows — these rows as CSV