PREVIEW / etf_daily / 2024-05-20
file: by_date/etf_daily/2024/2024-05-20.parquet size: 120 KB rows: 3,359
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-20 | SPY | ETF | 529.57 | 531.56 | 529.17 | 530.06 | 37764200.0 |
| 2024-05-20 | QQQ | ETF | 451.98 | 455.58 | 451.785 | 454.91 | 24474226.0 |
| 2024-05-20 | IWM | ETF | 208.02 | 209.48 | 207.78 | 208.54 | 15695900.0 |
| 2024-05-20 | DIA | ETF | 399.77 | 400.72 | 397.84 | 398.1 | 2094800.0 |
| 2024-05-20 | GLD | ETF | 223.79 | 225.66 | 223.02 | 224.56 | 5990900.0 |
| 2024-05-20 | TLT | ETF | 91.08 | 91.32 | 91.01 | 91.12 | 17922800.0 |
| 2024-05-20 | AAA | ETF | 25.15 | 25.23 | 25.095 | 25.158 | 3400.0 |
| 2024-05-20 | AAAU | ETF | 23.95 | 24.13 | 23.86 | 24.02 | 2784800.0 |
| 2024-05-20 | AADR | ETF | 65.0 | 65.23 | 65.0 | 65.14 | 1000.0 |
| 2024-05-20 | AAPB | ETF | 20.91 | 21.4686 | 20.89 | 21.31 | 129696.0 |
| 2024-05-20 | AAPD | ETF | 20.54 | 20.5611 | 20.26 | 20.35 | 99126.0 |
| 2024-05-20 | AAPR | ETF | 24.88 | 24.92 | 24.84 | 24.9 | 40609.0 |
| 2024-05-20 | AAPU | ETF | 26.98 | 27.72 | 26.93 | 27.5 | 254256.0 |
| 2024-05-20 | AAPX | ETF | 24.44 | 25.04 | 24.3 | 24.86 | 14228.0 |
| 2024-05-20 | AAPY | ETF | 25.48 | 25.48 | 25.4302 | 25.4302 | 1406.0 |
| 2024-05-20 | AAXJ | ETF | 73.05 | 73.25 | 72.97 | 73.11 | 348000.0 |
| 2024-05-20 | ABCS | ETF | 26.8167 | 26.86 | 26.8 | 26.8053 | 2821.0 |
| 2024-05-20 | ABEQ | ETF | 30.99 | 30.99 | 30.86 | 30.86 | 5400.0 |
| 2024-05-20 | ACES | ETF | 29.67 | 29.67 | 29.385 | 29.6 | 23800.0 |
| 2024-05-20 | ACIO | ETF | 36.56 | 36.67 | 36.535 | 36.57 | 104100.0 |
| 2024-05-20 | ACSI | ETF | 53.812 | 53.812 | 53.812 | 53.812 | 100.0 |
| 2024-05-20 | ACT | ETF | 31.51 | 31.61 | 31.07 | 31.07 | 147792.0 |
| 2024-05-20 | ACTV | ETF | 34.2 | 34.2 | 34.01 | 34.01 | 2800.0 |
| 2024-05-20 | ACVF | ETF | 40.19 | 40.3 | 40.19 | 40.223 | 4000.0 |
| 2024-05-20 | ACWF | ETF | 42.34 | 42.475 | 42.34 | 42.4051 | 922.0 |
| 2024-05-20 | ACWI | ETF | 112.18 | 112.49 | 112.08 | 112.23 | 3488600.0 |
| 2024-05-20 | ACWV | ETF | 106.07 | 106.2 | 105.88 | 105.97 | 75100.0 |
| 2024-05-20 | ACWX | ETF | 55.05 | 55.21 | 55.04 | 55.09 | 490100.0 |
| 2024-05-20 | ADFI | ETF | 8.46 | 8.51 | 8.45 | 8.461 | 22800.0 |
| 2024-05-20 | ADIV | ETF | 15.07 | 15.07 | 15.053 | 15.053 | 200.0 |
| 2024-05-20 | ADME | ETF | 42.486 | 42.486 | 42.34 | 42.355 | 5100.0 |
| 2024-05-20 | ADPV | ETF | 31.53 | 31.57 | 31.3899 | 31.4929 | 9387.0 |
| 2024-05-20 | AEMB | ETF | 38.642 | 38.642 | 38.58 | 38.58 | 1600.0 |
| 2024-05-20 | AESR | ETF | 15.795 | 15.81 | 15.76 | 15.77 | 27400.0 |
| 2024-05-20 | AETH | ETF | 40.48 | 45.47 | 40.48 | 45.4 | 30852.0 |
| 2024-05-20 | AFIF | ETF | 9.1 | 9.1 | 9.08 | 9.09 | 4400.0 |
| 2024-05-20 | AFK | ETF | 15.96 | 16.1 | 15.96 | 16.07 | 7200.0 |
| 2024-05-20 | AFLG | ETF | 31.1 | 31.1 | 31.1 | 31.1 | 100.0 |
| 2024-05-20 | AFMC | ETF | 30.16 | 30.16 | 30.079 | 30.079 | 500.0 |
| 2024-05-20 | AFSM | ETF | 29.06 | 29.32 | 29.06 | 29.253 | 900.0 |
| 2024-05-20 | AFTY | ETF | 14.83 | 14.84 | 14.83 | 14.83 | 1000.0 |
| 2024-05-20 | AGG | ETF | 96.71 | 96.76 | 96.67 | 96.68 | 5263000.0 |
| 2024-05-20 | AGGH | ETF | 21.07 | 21.07 | 20.88 | 20.92 | 31302.0 |
| 2024-05-20 | AGGY | ETF | 42.93 | 42.96 | 42.925 | 42.935 | 34000.0 |
| 2024-05-20 | AGMI | ETF | 29.63 | 29.7716 | 29.4 | 29.7716 | 1074.0 |
| 2024-05-20 | AGNG | ETF | 30.33 | 30.33 | 30.23 | 30.29 | 1000.0 |
| 2024-05-20 | AGOX | ETF | 25.93 | 26.13 | 25.88 | 25.994 | 16900.0 |
| 2024-05-20 | AGQ | ETF | 45.41 | 47.28 | 43.77 | 45.56 | 3962900.0 |
| 2024-05-20 | AGQI | ETF | 14.38 | 14.44 | 14.38 | 14.4064 | 19480.0 |
| 2024-05-20 | AGZ | ETF | 107.37 | 107.39 | 107.27 | 107.39 | 8100.0 |
> showing 50 of 3,359 rows — these rows as CSV