PREVIEW / etf_daily / 2024-05-01
file: by_date/etf_daily/2024/2024-05-01.parquet size: 120 KB rows: 3,352
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-05-01 | SPY | ETF | 501.38 | 508.19 | 499.87 | 500.35 | 80242800.0 |
| 2024-05-01 | QQQ | ETF | 423.15 | 430.14 | 420.66 | 421.52 | 52251707.0 |
| 2024-05-01 | IWM | ETF | 195.88 | 200.32 | 195.03 | 196.31 | 38782100.0 |
| 2024-05-01 | DIA | ETF | 378.38 | 383.48 | 377.98 | 378.89 | 5731600.0 |
| 2024-05-01 | GLD | ETF | 212.96 | 215.5 | 212.41 | 213.79 | 10373900.0 |
| 2024-05-01 | TLT | ETF | 88.6 | 89.21 | 88.24 | 88.56 | 59679500.0 |
| 2024-05-01 | AAA | ETF | 25.11 | 25.12 | 25.06 | 25.06 | 2900.0 |
| 2024-05-01 | AAAU | ETF | 22.76 | 23.04 | 22.73 | 22.86 | 3694200.0 |
| 2024-05-01 | AADR | ETF | 60.83 | 60.83 | 60.83 | 60.83 | 100.0 |
| 2024-05-01 | AAPB | ETF | 16.91 | 17.53 | 16.811 | 16.85 | 148337.0 |
| 2024-05-01 | AAPD | ETF | 22.97 | 23.03 | 22.57 | 23.03 | 198821.0 |
| 2024-05-01 | AAPR | ETF | 24.37 | 24.46 | 24.2701 | 24.36 | 111594.0 |
| 2024-05-01 | AAPU | ETF | 21.83 | 22.5997 | 21.6802 | 21.77 | 437228.0 |
| 2024-05-01 | AAPX | ETF | 19.84 | 20.38 | 19.62 | 19.63 | 23537.0 |
| 2024-05-01 | AAPY | ETF | 23.2901 | 23.2901 | 23.2649 | 23.2649 | 165.0 |
| 2024-05-01 | AAXJ | ETF | 68.1 | 68.88 | 68.08 | 68.14 | 186300.0 |
| 2024-05-01 | ABCS | ETF | 25.55 | 25.84 | 25.49 | 25.49 | 2379.0 |
| 2024-05-01 | ABEQ | ETF | 29.81 | 29.89 | 29.497 | 29.497 | 1400.0 |
| 2024-05-01 | ACES | ETF | 26.93 | 27.96 | 26.93 | 27.11 | 978900.0 |
| 2024-05-01 | ACIO | ETF | 34.98 | 35.28 | 34.857 | 34.86 | 133900.0 |
| 2024-05-01 | ACSI | ETF | 51.15 | 51.15 | 51.15 | 51.15 | 100.0 |
| 2024-05-01 | ACT | ETF | 29.69 | 30.14 | 29.63 | 30.0 | 248100.0 |
| 2024-05-01 | ACTV | ETF | 32.86 | 33.385 | 32.84 | 32.992 | 5600.0 |
| 2024-05-01 | ACVF | ETF | 38.4 | 38.68 | 38.23 | 38.252 | 9400.0 |
| 2024-05-01 | ACWF | ETF | 39.96 | 39.96 | 39.78 | 39.8482 | 1746.0 |
| 2024-05-01 | ACWI | ETF | 106.22 | 107.46 | 105.8 | 105.94 | 2208200.0 |
| 2024-05-01 | ACWV | ETF | 102.0 | 102.91 | 101.82 | 102.14 | 74100.0 |
| 2024-05-01 | ACWX | ETF | 52.12 | 52.63 | 51.92 | 52.03 | 1180100.0 |
| 2024-05-01 | ADFI | ETF | 8.13 | 8.48 | 8.13 | 8.35 | 19400.0 |
| 2024-05-01 | ADIV | ETF | 14.058 | 14.058 | 14.058 | 14.058 | 100.0 |
| 2024-05-01 | ADME | ETF | 40.29 | 40.77 | 40.25 | 40.258 | 9800.0 |
| 2024-05-01 | ADPV | ETF | 28.43 | 28.84 | 28.43 | 28.6073 | 923.0 |
| 2024-05-01 | AEMB | ETF | 37.817 | 37.817 | 37.817 | 37.817 | 100.0 |
| 2024-05-01 | AESR | ETF | 14.74 | 14.96 | 14.72 | 14.72 | 23600.0 |
| 2024-05-01 | AETH | ETF | 38.19 | 39.21 | 37.75 | 38.39 | 8006.0 |
| 2024-05-01 | AFIF | ETF | 9.05 | 9.07 | 8.95 | 9.06 | 24000.0 |
| 2024-05-01 | AFK | ETF | 15.01 | 15.12 | 14.95 | 14.97 | 6300.0 |
| 2024-05-01 | AFLG | ETF | 29.21 | 29.256 | 29.21 | 29.256 | 100.0 |
| 2024-05-01 | AFMC | ETF | 28.43 | 28.43 | 28.43 | 28.43 | 200.0 |
| 2024-05-01 | AFSM | ETF | 27.665 | 27.746 | 27.665 | 27.746 | 300.0 |
| 2024-05-01 | AFTY | ETF | 14.408 | 14.408 | 14.408 | 14.408 | 100.0 |
| 2024-05-01 | AGG | ETF | 95.2 | 95.58 | 94.99 | 95.27 | 11017700.0 |
| 2024-05-01 | AGGH | ETF | 20.51 | 20.6699 | 20.5001 | 20.5572 | 97778.0 |
| 2024-05-01 | AGGY | ETF | 42.22 | 42.4 | 42.185 | 42.31 | 74500.0 |
| 2024-05-01 | AGNG | ETF | 28.71 | 29.06 | 28.7 | 28.85 | 1600.0 |
| 2024-05-01 | AGOX | ETF | 24.42 | 24.8 | 24.4 | 24.571 | 45800.0 |
| 2024-05-01 | AGQ | ETF | 31.89 | 33.22 | 31.75 | 32.16 | 1538800.0 |
| 2024-05-01 | AGQI | ETF | 13.68 | 13.83 | 13.65 | 13.6791 | 6812.0 |
| 2024-05-01 | AGZ | ETF | 106.17 | 106.67 | 106.17 | 106.48 | 14300.0 |
| 2024-05-01 | AGZD | ETF | 22.07 | 22.32 | 22.07 | 22.16 | 199700.0 |
> showing 50 of 3,352 rows — these rows as CSV