PREVIEW / etf_daily / 2026-05-27
file: by_date/etf_daily/2026/2026-05-27.parquet size: 157 KB rows: 4,158
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 |
|---|---|---|---|---|---|---|---|
| 2026-05-27 | SPY | ETF | 750.88 | 751.38 | 748.22 | 750.46 | 42106285.0 |
| 2026-05-27 | QQQ | ETF | 732.96 | 733.32 | 725.44 | 729.45 | 35148674.0 |
| 2026-05-27 | IWM | ETF | 291.16 | 291.72 | 289.31 | 290.37 | 24519854.0 |
| 2026-05-27 | DIA | ETF | 505.93 | 508.7 | 505.81 | 506.88 | 4247835.0 |
| 2026-05-27 | GLD | ETF | 404.335 | 409.25 | 404.3 | 408.49 | 6624575.0 |
| 2026-05-27 | TLT | ETF | 85.25 | 85.48 | 85.15 | 85.3 | 23589557.0 |
| 2026-05-27 | AAA | ETF | 24.96 | 25.0 | 24.85 | 24.95 | 33970.0 |
| 2026-05-27 | AAAU | ETF | 43.44 | 43.95 | 43.42 | 43.88 | 1302699.0 |
| 2026-05-27 | AADR | ETF | 87.07 | 87.07 | 86.7 | 86.705 | 1713.0 |
| 2026-05-27 | AAPB | ETF | 39.31 | 40.6599 | 39.31 | 39.94 | 47584.0 |
| 2026-05-27 | AAPD | ETF | 11.5 | 11.5 | 11.3101 | 11.402 | 7862209.0 |
| 2026-05-27 | AAPR | ETF | 29.54 | 29.54 | 29.47 | 29.515 | 2467.0 |
| 2026-05-27 | AAPU | ETF | 40.66 | 41.955 | 40.63 | 41.33 | 1673959.0 |
| 2026-05-27 | AAPW | ETF | 41.51 | 42.15 | 41.51 | 41.7742 | 10924.0 |
| 2026-05-27 | AAPX | ETF | 36.48 | 37.8 | 36.48 | 37.425 | 50696.0 |
| 2026-05-27 | AAPY | ETF | 27.0899 | 27.16 | 26.9801 | 27.0051 | 3689.0 |
| 2026-05-27 | AAVM | ETF | 34.74 | 34.74 | 34.63 | 34.63 | 205.0 |
| 2026-05-27 | AAXJ | ETF | 119.15 | 119.45 | 117.6 | 118.5 | 394941.0 |
| 2026-05-27 | ABCS | ETF | 32.45 | 32.45 | 32.2501 | 32.2501 | 1182.0 |
| 2026-05-27 | ABEQ | ETF | 37.53 | 37.53 | 37.22 | 37.2221 | 6418.0 |
| 2026-05-27 | ABFL | ETF | 81.87 | 82.45 | 81.87 | 82.05 | 9059.0 |
| 2026-05-27 | ABLD | ETF | 31.395 | 31.395 | 31.1553 | 31.1553 | 4091.0 |
| 2026-05-27 | ABLG | ETF | 32.48 | 32.5816 | 32.48 | 32.5816 | 287.0 |
| 2026-05-27 | ABNY | ETF | 40.08 | 40.08 | 39.8662 | 39.8662 | 706.0 |
| 2026-05-27 | ABOT | ETF | 38.76 | 38.76 | 38.7116 | 38.7116 | 511.0 |
| 2026-05-27 | ACES | ETF | 40.41 | 41.5 | 40.11 | 41.15 | 29591.0 |
| 2026-05-27 | ACIO | ETF | 46.6072 | 46.7032 | 46.5201 | 46.668 | 59452.0 |
| 2026-05-27 | ACLC | ETF | 84.04 | 84.04 | 83.79 | 83.9898 | 4224.0 |
| 2026-05-27 | ACSG | ETF | 47.38 | 47.38 | 47.135 | 47.138 | 708.0 |
| 2026-05-27 | ACT | ETF | 42.94 | 43.34 | 42.405 | 42.63 | 282644.0 |
| 2026-05-27 | ACVF | ETF | 53.73 | 53.73 | 53.49 | 53.5425 | 3421.0 |
| 2026-05-27 | ACVT | ETF | 27.71 | 27.71 | 27.6 | 27.6241 | 8913.0 |
| 2026-05-27 | ACWI | ETF | 157.89 | 158.0 | 157.185 | 157.64 | 1877595.0 |
| 2026-05-27 | ACWV | ETF | 122.13 | 122.66 | 122.02 | 122.08 | 58619.0 |
| 2026-05-27 | ACWX | ETF | 76.65 | 76.69 | 76.08 | 76.34 | 1726823.0 |
| 2026-05-27 | ADBG | ETF | 4.19 | 4.43 | 4.19 | 4.21 | 3653857.0 |
| 2026-05-27 | ADFI | ETF | 8.48 | 8.49 | 8.4749 | 8.4749 | 15063.0 |
| 2026-05-27 | ADIV | ETF | 19.07 | 19.14 | 19.07 | 19.1229 | 1736.0 |
| 2026-05-27 | ADME | ETF | 55.9601 | 56.09 | 55.915 | 56.0224 | 9585.0 |
| 2026-05-27 | ADPV | ETF | 46.135 | 46.39 | 46.0 | 46.2128 | 25822.0 |
| 2026-05-27 | ADVE | ETF | 46.58 | 46.58 | 46.17 | 46.3382 | 1318.0 |
| 2026-05-27 | AESR | ETF | 20.3 | 20.3 | 20.065 | 20.11 | 20944.0 |
| 2026-05-27 | AETH | ETF | 32.595 | 32.595 | 32.595 | 32.595 | 398.0 |
| 2026-05-27 | AFIF | ETF | 9.38 | 9.4174 | 9.38 | 9.39 | 23718.0 |
| 2026-05-27 | AFIX | ETF | 24.75 | 24.76 | 24.735 | 24.735 | 1939.0 |
| 2026-05-27 | AFK | ETF | 27.31 | 27.604 | 27.16 | 27.42 | 146044.0 |
| 2026-05-27 | AFLG | ETF | 43.91 | 43.91 | 43.73 | 43.76 | 50439.0 |
| 2026-05-27 | AFMC | ETF | 40.2 | 40.2 | 39.81 | 39.85 | 84160.0 |
| 2026-05-27 | AFSC | ETF | 35.9329 | 35.9329 | 35.9329 | 35.9329 | 45.0 |
| 2026-05-27 | AFSM | ETF | 38.57 | 38.6198 | 38.3705 | 38.44 | 13911.0 |
> showing 50 of 4,158 rows — these rows as CSV