PREVIEW / stock_daily / 2024-08-28
file: by_date/stock_daily/2024/2024-08-28.parquet size: 244 KB rows: 7,083 symbols: 762
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-08-28 | AAPL | Stock | 227.92 | 229.86 | 225.68 | 226.49 | 38357450.0 |
| 2024-08-28 | MSFT | Stock | 414.88 | 415.0 | 407.31 | 410.6 | 14423804.0 |
| 2024-08-28 | NVDA | Stock | 128.12 | 128.33 | 122.64 | 125.61 | 431388832.0 |
| 2024-08-28 | AMZN | Stock | 173.69 | 173.69 | 168.92 | 170.8 | 28337707.0 |
| 2024-08-28 | GOOGL | Stock | 165.035 | 165.6 | 161.5284 | 162.85 | 16407444.0 |
| 2024-08-28 | META | Stock | 517.675 | 521.085 | 512.45 | 516.78 | 8926066.0 |
| 2024-08-28 | TSLA | Stock | 209.72 | 211.84 | 202.59 | 205.75 | 64103035.0 |
| 2024-08-28 | TLT | Stock | 98.01 | 98.2 | 97.725 | 97.85 | 18501411.0 |
| 2024-08-28 | ES | Stock | 66.54 | 67.33 | 66.46 | 67.04 | 1306523.0 |
| 2024-08-28 | CL | Stock | 106.41 | 106.72 | 105.23 | 105.79 | 3071474.0 |
| 2024-08-28 | A | Stock | 141.53 | 142.31 | 140.29 | 141.06 | 1015219.0 |
| 2024-08-28 | AA | Stock | 33.19 | 33.305 | 32.0 | 32.09 | 7327093.0 |
| 2024-08-28 | AACG | Stock | 0.59 | 0.6354 | 0.59 | 0.6001 | 6363.0 |
| 2024-08-28 | AACT | Stock | 10.76 | 10.77 | 10.75 | 10.75 | 68201.0 |
| 2024-08-28 | AAGR-DELISTED | Stock | 0.1389 | 0.1461 | 0.13 | 0.13 | 132835.0 |
| 2024-08-28 | AAGRW-DELISTED | Stock | 0.01 | 0.01 | 0.009 | 0.009 | 367201.0 |
| 2024-08-28 | AAL | Stock | 10.17 | 10.21 | 10.04 | 10.15 | 20289811.0 |
| 2024-08-28 | AAMC-DELISTED | Stock | 1.41 | 1.47 | 1.1 | 1.22 | 91377.0 |
| 2024-08-28 | AAME | Stock | 1.55 | 1.6199 | 1.55 | 1.56 | 808.0 |
| 2024-08-28 | AAMI | Stock | 23.48 | 23.69 | 23.425 | 23.54 | 176234.0 |
| 2024-08-28 | AAN-DELISTED | Stock | 10.09 | 10.11 | 10.08 | 10.09 | 727812.0 |
| 2024-08-28 | AAOI | Stock | 9.2 | 9.27 | 8.5503 | 9.12 | 1674201.0 |
| 2024-08-28 | AAON | Stock | 93.06 | 93.33 | 92.37 | 92.77 | 231480.0 |
| 2024-08-28 | AAP | Stock | 47.38 | 48.299 | 46.4752 | 46.64 | 2761098.0 |
| 2024-08-28 | AAT | Stock | 26.72 | 27.12 | 26.7 | 26.96 | 179880.0 |
| 2024-08-28 | AATC | Stock | 7.45 | 7.49 | 7.375 | 7.49 | 6356.0 |
| 2024-08-28 | AAUAF-DELISTED | Stock | 0.04964 | 0.04964 | 0.0402 | 0.0404 | 125714.0 |
| 2024-08-28 | AAXJ | Stock | 72.99 | 73.02 | 72.39 | 72.61 | 96543.0 |
| 2024-08-28 | AB | Stock | 34.75 | 34.8059 | 34.22 | 34.34 | 142580.0 |
| 2024-08-28 | ABAT | Stock | 1.12 | 1.15 | 1.03 | 1.09 | 313869.0 |
| 2024-08-28 | ABBV | Stock | 195.52 | 196.23 | 194.03 | 195.4 | 3686538.0 |
| 2024-08-28 | ABCB | Stock | 60.19 | 61.36 | 60.19 | 61.06 | 302962.0 |
| 2024-08-28 | ABCL | Stock | 2.61 | 2.67 | 2.54 | 2.56 | 1899352.0 |
| 2024-08-28 | ABEO | Stock | 5.57 | 5.66 | 5.37 | 5.54 | 203653.0 |
| 2024-08-28 | ABEV | Stock | 2.35 | 2.357 | 2.3 | 2.34 | 24903669.0 |
| 2024-08-28 | ABG | Stock | 238.54 | 241.83 | 237.4075 | 241.68 | 268099.0 |
| 2024-08-28 | ABLLW | Stock | 1.35 | 1.4 | 1.29 | 1.4 | 23297.0 |
| 2024-08-28 | ABLV | Stock | 1.65 | 1.68 | 1.62 | 1.62 | 1906.0 |
| 2024-08-28 | ABLVW | Stock | 0.0252 | 0.0374 | 0.025 | 0.0254 | 18100.0 |
| 2024-08-28 | ABM | Stock | 56.05 | 56.46 | 55.62 | 56.0 | 231505.0 |
| 2024-08-28 | ABNB | Stock | 116.0 | 117.73 | 115.76 | 117.53 | 3402608.0 |
| 2024-08-28 | ABOS | Stock | 2.78 | 2.83 | 2.725 | 2.77 | 104463.0 |
| 2024-08-28 | ABR | Stock | 13.53 | 13.66 | 13.51 | 13.55 | 1810956.0 |
| 2024-08-28 | ABR.D | Stock | 17.88 | 17.88 | 17.65 | 17.68 | 37363.0 |
| 2024-08-28 | ABR.E | Stock | 17.71 | 17.78 | 17.5 | 17.61 | 11658.0 |
| 2024-08-28 | ABR.F | Stock | 18.4 | 18.5 | 18.355 | 18.46 | 11437.0 |
| 2024-08-28 | ABSI | Stock | 4.45 | 4.49 | 4.19 | 4.39 | 899125.0 |
| 2024-08-28 | ABT | Stock | 113.1 | 113.42 | 112.37 | 112.9 | 3618248.0 |
| 2024-08-28 | ABTC | Stock | 57.3375 | 57.432 | 53.25 | 53.4975 | 915.2666666666667 |
| 2024-08-28 | ABTS | Stock | 7.65 | 7.65 | 7.05 | 7.3245 | 933.0 |
> showing 50 of 7,083 rows — these rows as CSV