PREVIEW / etf_daily / 2024-12-24
file: by_date/etf_daily/2024/2024-12-24.parquet size: 146 KB rows: 3,831
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-24 | SPY | ETF | 596.06 | 601.34 | 595.47 | 601.3 | 31786391.0 |
| 2024-12-24 | QQQ | ETF | 524.83 | 530.05 | 524.19 | 529.96 | 17558215.0 |
| 2024-12-24 | IWM | ETF | 222.02 | 223.63 | 220.48 | 223.39 | 13312327.0 |
| 2024-12-24 | DIA | ETF | 428.89 | 432.63 | 428.28 | 432.5 | 1430934.0 |
| 2024-12-24 | GLD | ETF | 241.49 | 241.66 | 240.82 | 241.44 | 2346496.0 |
| 2024-12-24 | TLT | ETF | 87.04 | 87.89 | 86.98 | 87.87 | 21579278.0 |
| 2024-12-24 | AAA | ETF | 25.21 | 25.21 | 25.1401 | 25.195 | 24318.0 |
| 2024-12-24 | AAAU | ETF | 25.83 | 25.88 | 25.79 | 25.855 | 704304.0 |
| 2024-12-24 | AADR | ETF | 69.74 | 70.29 | 69.74 | 70.2201 | 5024.0 |
| 2024-12-24 | AAPB | ETF | 35.22 | 35.96 | 35.22 | 35.95 | 72178.0 |
| 2024-12-24 | AAPD | ETF | 14.97 | 14.97 | 14.8064 | 14.81 | 179419.0 |
| 2024-12-24 | AAPR | ETF | 26.52 | 26.52 | 26.4857 | 26.4857 | 153.0 |
| 2024-12-24 | AAPU | ETF | 39.36 | 40.135 | 39.3294 | 40.11 | 274873.0 |
| 2024-12-24 | AAPX | ETF | 33.57 | 34.41 | 33.41 | 34.41 | 61261.0 |
| 2024-12-24 | AAPY | ETF | 28.0 | 28.0 | 27.6 | 27.66 | 8218.0 |
| 2024-12-24 | AAXJ | ETF | 73.25 | 73.61 | 73.25 | 73.55 | 96118.0 |
| 2024-12-24 | ABCS | ETF | 28.8 | 28.9985 | 28.8 | 28.9985 | 1404.0 |
| 2024-12-24 | ABEQ | ETF | 31.87 | 31.9142 | 31.87 | 31.9142 | 686.0 |
| 2024-12-24 | ABFL | ETF | 67.65 | 68.15 | 67.65 | 68.15 | 3829.0 |
| 2024-12-24 | ABHY | ETF | 21.0863 | 21.1174 | 21.08 | 21.1174 | 3242.0 |
| 2024-12-24 | ABLD | ETF | 29.9267 | 30.0298 | 29.9267 | 30.0298 | 791.0 |
| 2024-12-24 | ABLG | ETF | 28.74 | 28.95 | 28.74 | 28.93 | 5231.0 |
| 2024-12-24 | ABNY | ETF | 76.1 | 76.2465 | 75.375 | 76.0775 | 1144.0 |
| 2024-12-24 | ABOT | ETF | 37.59 | 37.7509 | 37.59 | 37.7509 | 1988.0 |
| 2024-12-24 | ACES | ETF | 26.62 | 27.0196 | 26.45 | 26.9448 | 20801.0 |
| 2024-12-24 | ACGR | ETF | 59.6733 | 59.8081 | 59.6733 | 59.8081 | 611.0 |
| 2024-12-24 | ACIO | ETF | 40.68 | 40.96 | 40.61 | 40.96 | 67671.0 |
| 2024-12-24 | ACLC | ETF | 71.68 | 72.4267 | 71.68 | 72.4267 | 3909.0 |
| 2024-12-24 | ACSI | ETF | 62.3932 | 62.3932 | 62.3932 | 62.3932 | 9.0 |
| 2024-12-24 | ACT | ETF | 32.48 | 32.87 | 32.47 | 32.77 | 90009.0 |
| 2024-12-24 | ACTV | ETF | 32.47 | 32.6504 | 32.34 | 32.6504 | 8488.0 |
| 2024-12-24 | ACVF | ETF | 44.4 | 44.7691 | 44.4 | 44.7691 | 6886.0 |
| 2024-12-24 | ACWI | ETF | 118.95 | 119.87 | 118.9 | 119.85 | 800195.0 |
| 2024-12-24 | ACWV | ETF | 109.62 | 110.23 | 109.37 | 110.2 | 90929.0 |
| 2024-12-24 | ACWX | ETF | 52.64 | 52.64 | 52.335 | 52.6 | 576023.0 |
| 2024-12-24 | ADFI | ETF | 8.35 | 8.38 | 8.35 | 8.375 | 20849.0 |
| 2024-12-24 | ADIV | ETF | 15.485 | 15.4979 | 15.485 | 15.4979 | 108.0 |
| 2024-12-24 | ADME | ETF | 47.66 | 48.09 | 47.66 | 48.09 | 6494.0 |
| 2024-12-24 | ADPV | ETF | 36.64 | 36.9278 | 36.64 | 36.9278 | 3666.0 |
| 2024-12-24 | ADVE | ETF | 32.3434 | 32.3434 | 32.3434 | 32.3434 | 1.0 |
| 2024-12-24 | AESR | ETF | 17.72 | 17.77 | 17.72 | 17.7618 | 23176.0 |
| 2024-12-24 | AETH | ETF | 42.68 | 42.68 | 42.4 | 42.48 | 31037.0 |
| 2024-12-24 | AFIF | ETF | 9.1 | 9.1391 | 9.1 | 9.135 | 2794.0 |
| 2024-12-24 | AFK | ETF | 15.89 | 15.89 | 15.62 | 15.68 | 2112.0 |
| 2024-12-24 | AFLG | ETF | 35.0606 | 35.28 | 35.0606 | 35.28 | 7854.0 |
| 2024-12-24 | AFMC | ETF | 31.77 | 32.0121 | 31.67 | 32.0121 | 1829.0 |
| 2024-12-24 | AFSM | ETF | 30.31 | 30.4383 | 30.3024 | 30.4383 | 572.0 |
| 2024-12-24 | AGG | ETF | 96.5 | 96.78 | 96.47 | 96.77 | 4734659.0 |
| 2024-12-24 | AGGH | ETF | 20.48 | 20.48 | 20.3 | 20.38 | 42636.0 |
| 2024-12-24 | AGGS | ETF | 40.4714 | 40.4714 | 40.4714 | 40.4714 | 4.0 |
> showing 50 of 3,831 rows — these rows as CSV