PREVIEW / stock_daily / 2024-05-28
file: by_date/stock_daily/2024/2024-05-28.parquet size: 232 KB rows: 7,247 symbols: 977
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-28 | AAPL | Stock | 191.51 | 193.0 | 189.1 | 189.99 | 52280100.0 |
| 2024-05-28 | MSFT | Stock | 429.63 | 430.82 | 426.6 | 430.32 | 15718000.0 |
| 2024-05-28 | NVDA | Stock | 110.244 | 114.939 | 109.883 | 113.901 | 652728000.0 |
| 2024-05-28 | AMZN | Stock | 179.93 | 182.24 | 179.49 | 182.15 | 29927000.0 |
| 2024-05-28 | GOOGL | Stock | 174.45 | 177.27 | 174.365 | 176.4 | 20572157.0 |
| 2024-05-28 | META | Stock | 476.58 | 480.86 | 474.84 | 479.92 | 10175800.0 |
| 2024-05-28 | TSLA | Stock | 176.4 | 178.25 | 173.16 | 176.75 | 59736600.0 |
| 2024-05-28 | TLT | Stock | 91.33 | 91.36 | 90.03 | 90.07 | 45973742.0 |
| 2024-05-28 | ES | Stock | 57.68 | 58.39 | 56.76 | 56.8 | 1506200.0 |
| 2024-05-28 | CL | Stock | 92.87 | 93.59 | 91.73 | 91.94 | 4276900.0 |
| 2024-05-28 | A | Stock | 150.82 | 151.19 | 147.7 | 148.21 | 1366900.0 |
| 2024-05-28 | AA | Stock | 42.8 | 43.6 | 42.436 | 43.2 | 7888500.0 |
| 2024-05-28 | AACG | Stock | 0.78 | 0.85 | 0.78 | 0.84 | 30200.0 |
| 2024-05-28 | AACT | Stock | 10.63 | 10.66 | 10.63 | 10.65 | 1342600.0 |
| 2024-05-28 | AAGR-DELISTED | Stock | 0.38 | 0.4 | 0.3595 | 0.3991 | 120949.0 |
| 2024-05-28 | AAGRW-DELISTED | Stock | 0.0121 | 0.0121 | 0.012 | 0.0121 | 2316.0 |
| 2024-05-28 | AAL | Stock | 13.85 | 13.91 | 13.42 | 13.44 | 32710300.0 |
| 2024-05-28 | AAMC-DELISTED | Stock | 2.51 | 2.52 | 2.48 | 2.48 | 7100.0 |
| 2024-05-28 | AAME | Stock | 1.72 | 1.72 | 1.62 | 1.63 | 4600.0 |
| 2024-05-28 | AAMI | Stock | 22.62 | 22.72 | 22.36 | 22.71 | 209100.0 |
| 2024-05-28 | AAN-DELISTED | Stock | 7.21 | 7.31 | 7.08 | 7.09 | 126000.0 |
| 2024-05-28 | AAOI | Stock | 12.75 | 12.8 | 12.1 | 12.38 | 1505800.0 |
| 2024-05-28 | AAON | Stock | 78.25 | 78.63 | 76.95 | 77.68 | 587500.0 |
| 2024-05-28 | AAP | Stock | 69.89 | 71.62 | 69.75 | 70.18 | 2559600.0 |
| 2024-05-28 | AAT | Stock | 21.31 | 21.41 | 20.88 | 20.91 | 297300.0 |
| 2024-05-28 | AATC | Stock | 6.1 | 6.2 | 6.0 | 6.05 | 13219.0 |
| 2024-05-28 | AAUAF-DELISTED | Stock | 0.125 | 0.125 | 0.1219 | 0.1219 | 13536.0 |
| 2024-05-28 | AAXJ | Stock | 72.44 | 72.54 | 72.01 | 72.17 | 647734.0 |
| 2024-05-28 | AB | Stock | 33.77 | 34.1 | 33.25 | 33.5 | 182900.0 |
| 2024-05-28 | ABAT | Stock | 1.45 | 1.46 | 1.37 | 1.39 | 401052.0 |
| 2024-05-28 | ABBV | Stock | 156.35 | 156.35 | 153.95 | 155.34 | 5533500.0 |
| 2024-05-28 | ABCB | Stock | 48.02 | 48.11 | 47.24 | 47.47 | 165000.0 |
| 2024-05-28 | ABCL | Stock | 3.88 | 4.34 | 3.88 | 4.08 | 2888200.0 |
| 2024-05-28 | ABEO | Stock | 4.13 | 4.21 | 4.02 | 4.1 | 461700.0 |
| 2024-05-28 | ABEV | Stock | 2.27 | 2.27 | 2.22 | 2.23 | 15593000.0 |
| 2024-05-28 | ABG | Stock | 232.22 | 234.75 | 231.4 | 232.44 | 135100.0 |
| 2024-05-28 | ABLLW | Stock | 0.32 | 0.46 | 0.32 | 0.36 | 213833.0 |
| 2024-05-28 | ABLV | Stock | 1.6 | 1.64 | 1.38 | 1.38 | 37800.0 |
| 2024-05-28 | ABM | Stock | 47.18 | 47.21 | 46.44 | 46.55 | 274700.0 |
| 2024-05-28 | ABNB | Stock | 146.0 | 147.87 | 145.11 | 147.01 | 5741600.0 |
| 2024-05-28 | ABOS | Stock | 3.45 | 3.45 | 3.22 | 3.25 | 243700.0 |
| 2024-05-28 | ABR | Stock | 13.34 | 13.52 | 13.23 | 13.26 | 2500700.0 |
| 2024-05-28 | ABR.D | Stock | 18.2 | 18.49 | 18.1 | 18.35 | 13333.0 |
| 2024-05-28 | ABR.E | Stock | 17.95 | 18.25 | 17.95 | 18.1355 | 6267.0 |
| 2024-05-28 | ABR.F | Stock | 19.7 | 19.88 | 19.7 | 19.88 | 7463.0 |
| 2024-05-28 | ABSI | Stock | 4.29 | 4.43 | 4.195 | 4.27 | 1757500.0 |
| 2024-05-28 | ABT | Stock | 103.57 | 103.59 | 101.56 | 101.95 | 4771100.0 |
| 2024-05-28 | ABTC | Stock | 99.75 | 99.75 | 93.75 | 97.5 | 3848.0 |
| 2024-05-28 | ABTS | Stock | 9.825 | 10.2 | 8.85 | 10.005 | 8700.0 |
| 2024-05-28 | ABUS | Stock | 3.35 | 3.37 | 3.25 | 3.35 | 1066500.0 |
> showing 50 of 7,247 rows — these rows as CSV