PREVIEW / stock_daily / 2024-10-28
file: by_date/stock_daily/2024/2024-10-28.parquet size: 244 KB rows: 7,141 symbols: 683
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-10-28 | AAPL | Stock | 233.32 | 234.73 | 232.55 | 233.4 | 32893429.0 |
| 2024-10-28 | MSFT | Stock | 431.655 | 431.94 | 426.3 | 426.59 | 13330966.0 |
| 2024-10-28 | NVDA | Stock | 143.0 | 143.14 | 140.05 | 140.52 | 166920098.0 |
| 2024-10-28 | AMZN | Stock | 189.565 | 190.21 | 188.21 | 188.39 | 22943660.0 |
| 2024-10-28 | GOOGL | Stock | 168.75 | 168.75 | 163.95 | 166.72 | 32138641.0 |
| 2024-10-28 | META | Stock | 582.0 | 583.7499 | 574.12 | 578.16 | 9862737.0 |
| 2024-10-28 | TSLA | Stock | 270.0 | 273.536 | 262.24 | 262.51 | 103502708.0 |
| 2024-10-28 | TLT | Stock | 92.27 | 92.29 | 91.415 | 91.89 | 33156461.0 |
| 2024-10-28 | ES | Stock | 66.19 | 66.84 | 66.0 | 66.49 | 1483580.0 |
| 2024-10-28 | CL | Stock | 95.22 | 96.61 | 95.22 | 95.74 | 4460501.0 |
| 2024-10-28 | A | Stock | 131.75 | 132.23 | 130.34 | 131.54 | 1599303.0 |
| 2024-10-28 | AA | Stock | 41.05 | 41.52 | 40.03 | 41.41 | 4210826.0 |
| 2024-10-28 | AACG | Stock | 1.0 | 1.01 | 0.96 | 1.005 | 67806.0 |
| 2024-10-28 | AACT | Stock | 10.88 | 10.8953 | 10.86 | 10.8953 | 33360.0 |
| 2024-10-28 | AAGR-DELISTED | Stock | 0.0002 | 0.0003 | 0.0002 | 0.0002 | 1771.0 |
| 2024-10-28 | AAL | Stock | 13.66 | 13.85 | 13.56 | 13.6 | 36903766.0 |
| 2024-10-28 | AAM | Stock | 10.04 | 10.045 | 10.03 | 10.045 | 116924.0 |
| 2024-10-28 | AAME | Stock | 1.6581 | 1.6799 | 1.58 | 1.6799 | 1482.0 |
| 2024-10-28 | AAMI | Stock | 26.04 | 26.525 | 26.01 | 26.44 | 109516.0 |
| 2024-10-28 | AAOI | Stock | 17.63 | 17.8 | 16.59 | 16.6 | 2566002.0 |
| 2024-10-28 | AAON | Stock | 114.99 | 122.97 | 113.9 | 121.33 | 747381.0 |
| 2024-10-28 | AAP | Stock | 36.86 | 37.82 | 36.75 | 37.09 | 2687163.0 |
| 2024-10-28 | AAT | Stock | 27.73 | 28.055 | 27.43 | 27.45 | 229463.0 |
| 2024-10-28 | AATC | Stock | 7.41 | 7.69 | 7.41 | 7.65 | 2811.0 |
| 2024-10-28 | AAUAF-DELISTED | Stock | 0.05 | 0.0579 | 0.046 | 0.0461 | 78212.0 |
| 2024-10-28 | AAXJ | Stock | 77.18 | 77.6 | 77.05 | 77.4 | 1193802.0 |
| 2024-10-28 | AB | Stock | 38.45 | 38.73 | 37.89 | 37.99 | 373025.0 |
| 2024-10-28 | ABAT | Stock | 1.0 | 1.02 | 0.99 | 0.998 | 356102.0 |
| 2024-10-28 | ABBV | Stock | 188.09 | 190.14 | 187.52 | 189.68 | 5242029.0 |
| 2024-10-28 | ABCB | Stock | 62.01 | 63.57 | 62.01 | 63.18 | 378077.0 |
| 2024-10-28 | ABCL | Stock | 2.75 | 2.905 | 2.74 | 2.89 | 2850093.0 |
| 2024-10-28 | ABEO | Stock | 6.52 | 6.68 | 6.3391 | 6.39 | 224453.0 |
| 2024-10-28 | ABEV | Stock | 2.29 | 2.3 | 2.27 | 2.28 | 17374146.0 |
| 2024-10-28 | ABG | Stock | 225.1 | 228.51 | 221.25 | 225.58 | 798340.0 |
| 2024-10-28 | ABLLW | Stock | 1.53 | 1.56 | 1.4604 | 1.51 | 12814.0 |
| 2024-10-28 | ABLV | Stock | 0.91 | 0.91 | 0.88375 | 0.898 | 24098.0 |
| 2024-10-28 | ABM | Stock | 53.34 | 53.955 | 53.21 | 53.71 | 346071.0 |
| 2024-10-28 | ABNB | Stock | 136.3 | 137.3 | 135.4 | 135.78 | 3042598.0 |
| 2024-10-28 | ABOS | Stock | 3.0 | 3.14 | 2.87 | 2.89 | 273530.0 |
| 2024-10-28 | ABR | Stock | 15.2 | 15.3041 | 15.12 | 15.19 | 1267168.0 |
| 2024-10-28 | ABR.D | Stock | 19.67 | 19.8179 | 19.6001 | 19.73 | 22953.0 |
| 2024-10-28 | ABR.E | Stock | 19.96 | 20.0953 | 19.96 | 19.97 | 4291.0 |
| 2024-10-28 | ABR.F | Stock | 20.39 | 20.4 | 20.15 | 20.36 | 18049.0 |
| 2024-10-28 | ABSI | Stock | 4.06 | 4.4 | 4.06 | 4.29 | 1726550.0 |
| 2024-10-28 | ABT | Stock | 114.769 | 114.83 | 113.5501 | 114.07 | 3837471.0 |
| 2024-10-28 | ABTC | Stock | 47.24250000000001 | 53.625 | 44.2575 | 53.3175 | 26652.0 |
| 2024-10-28 | ABTS | Stock | 6.585 | 7.35 | 5.9655 | 7.2 | 21322.0 |
| 2024-10-28 | ABUS | Stock | 4.01 | 4.1 | 4.005 | 4.05 | 484426.0 |
| 2024-10-28 | ABVC | Stock | 0.685 | 0.746 | 0.64 | 0.74 | 330082.0 |
| 2024-10-28 | ABVE | Stock | 0.6 | 0.65 | 0.55 | 0.5801 | 74027.0 |
> showing 50 of 7,141 rows — these rows as CSV