PREVIEW / etf_daily / 2024-12-27
file: by_date/etf_daily/2024/2024-12-27.parquet size: 146 KB rows: 3,850
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-27 | SPY | ETF | 597.54 | 597.7761 | 590.7647 | 595.01 | 64296929.0 |
| 2024-12-27 | QQQ | ETF | 526.01 | 526.45 | 517.86 | 522.56 | 33839555.0 |
| 2024-12-27 | IWM | ETF | 224.29 | 225.44 | 220.2 | 222.39 | 26859427.0 |
| 2024-12-27 | DIA | ETF | 430.58 | 432.29 | 427.43 | 430.0 | 2411456.0 |
| 2024-12-27 | GLD | ETF | 241.2 | 241.95 | 241.05 | 241.4 | 4704543.0 |
| 2024-12-27 | TLT | ETF | 87.48 | 87.775 | 87.06 | 87.1 | 27149627.0 |
| 2024-12-27 | AAA | ETF | 25.05 | 25.0699 | 25.05 | 25.05 | 16982.0 |
| 2024-12-27 | AAAU | ETF | 25.86 | 25.915 | 25.815 | 25.855 | 1432829.0 |
| 2024-12-27 | AADR | ETF | 70.2 | 70.2 | 69.73 | 69.73 | 519.0 |
| 2024-12-27 | AAPB | ETF | 35.84 | 36.0 | 34.57 | 35.24 | 78691.0 |
| 2024-12-27 | AAPD | ETF | 14.83 | 15.095 | 14.79 | 14.96 | 895144.0 |
| 2024-12-27 | AAPR | ETF | 26.4392 | 26.455 | 26.4392 | 26.455 | 743.0 |
| 2024-12-27 | AAPU | ETF | 40.04 | 40.19 | 38.56 | 39.3 | 365967.0 |
| 2024-12-27 | AAPX | ETF | 34.32 | 34.32 | 33.0653 | 33.64 | 46461.0 |
| 2024-12-27 | AAPY | ETF | 27.72 | 27.72 | 27.4 | 27.5187 | 6158.0 |
| 2024-12-27 | AAXJ | ETF | 72.83 | 72.99 | 72.61 | 72.99 | 225020.0 |
| 2024-12-27 | ABCS | ETF | 29.1009 | 29.1009 | 28.7617 | 28.8577 | 1805.0 |
| 2024-12-27 | ABEQ | ETF | 32.06 | 32.06 | 31.84 | 31.9084 | 7305.0 |
| 2024-12-27 | ABFL | ETF | 67.88 | 67.88 | 67.4 | 67.4602 | 3103.0 |
| 2024-12-27 | ABHY | ETF | 21.0965 | 21.1 | 21.0965 | 21.1 | 2877.0 |
| 2024-12-27 | ABLD | ETF | 29.95 | 29.95 | 29.7908 | 29.8388 | 3496.0 |
| 2024-12-27 | ABLG | ETF | 28.9204 | 28.93 | 28.913 | 28.913 | 1631.0 |
| 2024-12-27 | ABNY | ETF | 75.75 | 75.85 | 75.05 | 75.85 | 1378.0 |
| 2024-12-27 | ABOT | ETF | 37.135 | 37.3301 | 37.135 | 37.33 | 5609.0 |
| 2024-12-27 | ACES | ETF | 26.81 | 27.11 | 26.3891 | 26.68 | 135424.0 |
| 2024-12-27 | ACGR | ETF | 58.6513 | 58.9792 | 58.6513 | 58.9792 | 950.0 |
| 2024-12-27 | ACIO | ETF | 40.8 | 40.8 | 40.4114 | 40.66 | 67969.0 |
| 2024-12-27 | ACLC | ETF | 71.55 | 71.73 | 71.55 | 71.6869 | 3364.0 |
| 2024-12-27 | ACSI | ETF | 61.6891 | 61.6891 | 61.6891 | 61.6891 | 225.0 |
| 2024-12-27 | ACT | ETF | 32.68 | 32.9 | 32.35 | 32.36 | 135386.0 |
| 2024-12-27 | ACTV | ETF | 32.6899 | 32.6899 | 32.6899 | 32.6899 | 536.0 |
| 2024-12-27 | ACVF | ETF | 44.66 | 44.66 | 44.09 | 44.3 | 3189.0 |
| 2024-12-27 | ACWI | ETF | 119.4 | 119.42 | 118.36 | 119.04 | 3466665.0 |
| 2024-12-27 | ACWV | ETF | 109.99 | 110.35 | 109.6065 | 110.0 | 66935.0 |
| 2024-12-27 | ACWX | ETF | 52.54 | 52.645 | 52.39 | 52.59 | 1640217.0 |
| 2024-12-27 | ADFI | ETF | 8.42 | 8.43 | 8.38 | 8.3836 | 8631.0 |
| 2024-12-27 | ADIV | ETF | 15.48 | 15.48 | 15.48 | 15.48 | 8.0 |
| 2024-12-27 | ADME | ETF | 47.45 | 47.57 | 47.28 | 47.57 | 10008.0 |
| 2024-12-27 | ADPV | ETF | 36.4131 | 36.5 | 35.98 | 36.2097 | 7258.0 |
| 2024-12-27 | ADVE | ETF | 32.25 | 32.25 | 32.2095 | 32.2384 | 574.0 |
| 2024-12-27 | AESR | ETF | 17.58 | 17.5801 | 17.45 | 17.5736 | 10761.0 |
| 2024-12-27 | AETH | ETF | 36.99 | 37.09 | 36.99 | 37.0698 | 17428.0 |
| 2024-12-27 | AFIF | ETF | 9.04 | 9.14 | 9.04 | 9.13 | 34755.0 |
| 2024-12-27 | AFK | ETF | 15.79 | 15.79 | 15.46 | 15.71 | 11306.0 |
| 2024-12-27 | AFLG | ETF | 34.9088 | 35.01 | 34.7601 | 34.99 | 8286.0 |
| 2024-12-27 | AFMC | ETF | 31.67 | 31.7931 | 31.63 | 31.7931 | 1491.0 |
| 2024-12-27 | AFSM | ETF | 30.6478 | 30.6478 | 30.15 | 30.29 | 3905.0 |
| 2024-12-27 | AGG | ETF | 96.79 | 96.89 | 96.61 | 96.64 | 8572087.0 |
| 2024-12-27 | AGGH | ETF | 20.65 | 20.65 | 20.38 | 20.52 | 89311.0 |
| 2024-12-27 | AGGS | ETF | 40.42 | 40.42 | 40.42 | 40.42 | 4.0 |
> showing 50 of 3,850 rows — these rows as CSV