PREVIEW / etf_daily / 2024-07-18
file: by_date/etf_daily/2024/2024-07-18.parquet size: 132 KB rows: 3,439
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-07-18 | SPY | ETF | 558.51 | 559.52 | 550.43 | 552.66 | 56884470.0 |
| 2024-07-18 | QQQ | ETF | 485.53 | 485.71 | 476.27 | 479.49 | 49347361.0 |
| 2024-07-18 | IWM | ETF | 221.41 | 224.78 | 216.98 | 217.95 | 52160533.0 |
| 2024-07-18 | DIA | ETF | 410.68 | 413.86 | 406.05 | 406.72 | 4915155.0 |
| 2024-07-18 | GLD | ETF | 227.71 | 228.32 | 225.57 | 225.78 | 5474845.0 |
| 2024-07-18 | TLT | ETF | 93.68 | 94.14 | 93.38 | 93.47 | 34525547.0 |
| 2024-07-18 | AAA | ETF | 25.15 | 25.16 | 25.11 | 25.1353 | 17019.0 |
| 2024-07-18 | AAAU | ETF | 24.35 | 24.425 | 24.1301 | 24.16 | 1970340.0 |
| 2024-07-18 | AADR | ETF | 62.47 | 62.47 | 61.12 | 61.6 | 2440.0 |
| 2024-07-18 | AAPB | ETF | 30.1 | 30.1 | 28.04 | 28.45 | 284733.0 |
| 2024-07-18 | AAPD | ETF | 16.7 | 17.26 | 16.69 | 17.14 | 494304.0 |
| 2024-07-18 | AAPR | ETF | 25.4946 | 25.51 | 25.43 | 25.43 | 12372.0 |
| 2024-07-18 | AAPU | ETF | 38.56 | 38.59 | 35.96 | 36.55 | 1227522.0 |
| 2024-07-18 | AAPX | ETF | 35.0 | 35.0 | 32.63 | 33.22 | 70435.0 |
| 2024-07-18 | AAPY | ETF | 27.71 | 27.71 | 27.2261 | 27.2261 | 491.0 |
| 2024-07-18 | AAXJ | ETF | 73.58 | 73.64 | 72.595 | 72.74 | 1742516.0 |
| 2024-07-18 | ABCS | ETF | 27.61 | 27.67 | 27.0916 | 27.0916 | 1900.0 |
| 2024-07-18 | ABEQ | ETF | 31.595 | 31.595 | 31.3652 | 31.3652 | 2957.0 |
| 2024-07-18 | ABNY | ETF | 103.9 | 103.9 | 101.3615 | 101.3615 | 475.0 |
| 2024-07-18 | ACES | ETF | 31.09 | 31.5 | 30.245 | 30.42 | 33996.0 |
| 2024-07-18 | ACIO | ETF | 38.56 | 38.61 | 38.1701 | 38.29 | 418832.0 |
| 2024-07-18 | ACSI | ETF | 55.8007 | 55.8007 | 55.8007 | 55.8007 | 62.0 |
| 2024-07-18 | ACT | ETF | 33.12 | 33.82 | 33.105 | 33.4 | 196624.0 |
| 2024-07-18 | ACTV | ETF | 33.86 | 34.11 | 33.13 | 33.16 | 12989.0 |
| 2024-07-18 | ACVF | ETF | 42.29 | 42.33 | 41.775 | 41.8371 | 2919.0 |
| 2024-07-18 | ACWI | ETF | 115.74 | 115.74 | 113.86 | 114.24 | 3432364.0 |
| 2024-07-18 | ACWV | ETF | 108.245 | 108.6 | 107.62 | 107.63 | 107219.0 |
| 2024-07-18 | ACWX | ETF | 54.87 | 54.9 | 54.06 | 54.17 | 895800.0 |
| 2024-07-18 | ADFI | ETF | 8.57 | 8.58 | 8.5 | 8.55 | 16136.0 |
| 2024-07-18 | ADIV | ETF | 14.65 | 14.67 | 14.65 | 14.67 | 1212.0 |
| 2024-07-18 | ADME | ETF | 44.86 | 44.86 | 44.39 | 44.42 | 6113.0 |
| 2024-07-18 | ADPV | ETF | 31.35 | 31.35 | 30.8379 | 30.8379 | 798.0 |
| 2024-07-18 | ADVE | ETF | 33.65 | 33.65 | 33.4028 | 33.4028 | 204.0 |
| 2024-07-18 | AEMB | ETF | 38.6816 | 38.6816 | 38.5848 | 38.5848 | 983.0 |
| 2024-07-18 | AESR | ETF | 16.45 | 16.48 | 16.32 | 16.36 | 5953.0 |
| 2024-07-18 | AETH | ETF | 45.2501 | 45.3583 | 44.329 | 44.5465 | 6033.0 |
| 2024-07-18 | AFIF | ETF | 9.12 | 9.16 | 9.12 | 9.125 | 59913.0 |
| 2024-07-18 | AFK | ETF | 16.3 | 16.425 | 16.09 | 16.09 | 14640.0 |
| 2024-07-18 | AFLG | ETF | 32.275 | 32.275 | 32.1754 | 32.1754 | 1010.0 |
| 2024-07-18 | AFMC | ETF | 31.055 | 31.055 | 30.4928 | 30.4928 | 1182.0 |
| 2024-07-18 | AFSM | ETF | 30.66 | 30.66 | 29.9 | 30.0472 | 16972.0 |
| 2024-07-18 | AFTY | ETF | 14.425 | 14.425 | 14.36 | 14.3783 | 1832.0 |
| 2024-07-18 | AGG | ETF | 98.37 | 98.56 | 98.21 | 98.25 | 10563176.0 |
| 2024-07-18 | AGGH | ETF | 21.21 | 21.21 | 21.04 | 21.04 | 82866.0 |
| 2024-07-18 | AGGY | ETF | 43.63 | 43.68 | 43.56 | 43.57 | 71011.0 |
| 2024-07-18 | AGIX | ETF | 25.36 | 28.1 | 24.63 | 24.8001 | 52967.0 |
| 2024-07-18 | AGMI | ETF | 28.85 | 28.85 | 27.7266 | 27.7266 | 502.0 |
| 2024-07-18 | AGNG | ETF | 31.16 | 31.25 | 30.61 | 30.735 | 14604.0 |
| 2024-07-18 | AGOX | ETF | 28.32 | 28.42 | 28.0479 | 28.1428 | 25967.0 |
| 2024-07-18 | AGQ | ETF | 40.01 | 40.0999 | 38.27 | 38.38 | 2050205.0 |
> showing 50 of 3,439 rows — these rows as CSV