PREVIEW / stock_daily / 2024-07-24
file: by_date/stock_daily/2024/2024-07-24.parquet size: 244 KB rows: 7,145 symbols: 886
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-07-24 | AAPL | Stock | 224.0 | 224.8 | 217.13 | 218.54 | 59520291.0 |
| 2024-07-24 | MSFT | Stock | 440.45 | 441.48 | 427.585 | 428.9 | 25856125.0 |
| 2024-07-24 | NVDA | Stock | 119.17 | 119.95 | 113.44 | 114.25 | 322470256.0 |
| 2024-07-24 | AMZN | Stock | 183.2 | 185.45 | 180.41 | 180.83 | 40721793.0 |
| 2024-07-24 | GOOGL | Stock | 173.6 | 176.19 | 171.82 | 172.63 | 49585203.0 |
| 2024-07-24 | META | Stock | 472.305 | 476.3 | 460.58 | 461.27 | 17499009.0 |
| 2024-07-24 | TSLA | Stock | 225.42 | 225.99 | 214.71 | 215.99 | 165134997.0 |
| 2024-07-24 | TLT | Stock | 92.59 | 92.85 | 91.47 | 91.52 | 50757116.0 |
| 2024-07-24 | ES | Stock | 61.64 | 63.12 | 61.29 | 63.03 | 2367757.0 |
| 2024-07-24 | CL | Stock | 95.42 | 97.08 | 95.42 | 96.6 | 4604874.0 |
| 2024-07-24 | A | Stock | 130.87 | 134.43 | 130.18 | 134.16 | 2021805.0 |
| 2024-07-24 | AA | Stock | 33.78 | 34.1796 | 32.665 | 32.84 | 6322058.0 |
| 2024-07-24 | AACG | Stock | 0.6802 | 0.7151 | 0.653 | 0.68 | 32642.0 |
| 2024-07-24 | AACIU | Stock | 11.09 | 11.09 | 11.09 | 11.09 | 300.0 |
| 2024-07-24 | AACIW-DELISTED | Stock | 0.111 | 0.12395 | 0.1109 | 0.12395 | 13800.0 |
| 2024-07-24 | AACT | Stock | 10.75 | 10.75 | 10.72 | 10.72 | 5257.0 |
| 2024-07-24 | AAGR-DELISTED | Stock | 0.154 | 0.1599 | 0.1411 | 0.148 | 1204985.0 |
| 2024-07-24 | AAGRW-DELISTED | Stock | 0.0118 | 0.0118 | 0.0118 | 0.0118 | 128.0 |
| 2024-07-24 | AAL | Stock | 10.45 | 10.54 | 10.12 | 10.17 | 46856475.0 |
| 2024-07-24 | AAMC-DELISTED | Stock | 2.78 | 2.85 | 2.5 | 2.85 | 2381.0 |
| 2024-07-24 | AAME | Stock | 1.62 | 1.64 | 1.5601 | 1.5758 | 4500.0 |
| 2024-07-24 | AAMI | Stock | 25.04 | 25.44 | 24.71 | 24.8 | 101620.0 |
| 2024-07-24 | AAN-DELISTED | Stock | 9.97 | 9.97 | 9.93 | 9.93 | 1494009.0 |
| 2024-07-24 | AAOI | Stock | 9.65 | 9.83 | 8.94 | 8.96 | 1984669.0 |
| 2024-07-24 | AAON | Stock | 88.15 | 89.04 | 84.54 | 84.78 | 488448.0 |
| 2024-07-24 | AAP | Stock | 59.5 | 60.22 | 58.45 | 58.94 | 1280409.0 |
| 2024-07-24 | AAT | Stock | 24.8 | 25.1 | 24.26 | 24.27 | 233559.0 |
| 2024-07-24 | AATC | Stock | 6.815 | 6.815 | 6.61 | 6.61 | 6089.0 |
| 2024-07-24 | AAUAF-DELISTED | Stock | 0.05 | 0.055 | 0.05 | 0.053 | 25701.0 |
| 2024-07-24 | AAXJ | Stock | 71.41 | 71.56 | 70.71 | 70.72 | 491807.0 |
| 2024-07-24 | AB | Stock | 34.8 | 35.32 | 34.03 | 34.05 | 606300.0 |
| 2024-07-24 | ABAT | Stock | 1.02 | 1.0299 | 0.9526 | 0.975 | 680078.0 |
| 2024-07-24 | ABBV | Stock | 173.2 | 176.6 | 172.95 | 176.21 | 5090464.0 |
| 2024-07-24 | ABCB | Stock | 60.5 | 61.92 | 59.51 | 59.56 | 615212.0 |
| 2024-07-24 | ABCL | Stock | 3.09 | 3.15 | 2.9911 | 3.01 | 1070465.0 |
| 2024-07-24 | ABEO | Stock | 5.09 | 5.17 | 4.97 | 5.05 | 157432.0 |
| 2024-07-24 | ABEV | Stock | 2.1 | 2.13 | 2.1 | 2.1 | 15424033.0 |
| 2024-07-24 | ABG | Stock | 247.25 | 254.02 | 244.505 | 245.02 | 216326.0 |
| 2024-07-24 | ABLLW | Stock | 0.86 | 1.15 | 0.8301 | 1.1 | 321250.0 |
| 2024-07-24 | ABLV | Stock | 1.2 | 1.21 | 1.15 | 1.2 | 38791.0 |
| 2024-07-24 | ABLVW | Stock | 0.05 | 0.05 | 0.035 | 0.035 | 16010.0 |
| 2024-07-24 | ABM | Stock | 54.29 | 55.24 | 54.145 | 54.53 | 401801.0 |
| 2024-07-24 | ABNB | Stock | 146.73 | 147.11 | 142.98 | 144.23 | 5000558.0 |
| 2024-07-24 | ABOS | Stock | 3.55 | 3.59 | 3.2 | 3.22 | 445903.0 |
| 2024-07-24 | ABR | Stock | 13.17 | 13.275 | 13.03 | 13.03 | 2437088.0 |
| 2024-07-24 | ABR.D | Stock | 17.7 | 17.745 | 17.2 | 17.28 | 31974.0 |
| 2024-07-24 | ABR.E | Stock | 17.4 | 17.42 | 17.29 | 17.39 | 5837.0 |
| 2024-07-24 | ABR.F | Stock | 18.6 | 18.69 | 18.5 | 18.5 | 14017.0 |
| 2024-07-24 | ABSI | Stock | 4.39 | 4.49 | 4.22 | 4.22 | 950057.0 |
| 2024-07-24 | ABT | Stock | 104.22 | 107.31 | 103.54 | 107.26 | 8530717.0 |
> showing 50 of 7,145 rows — these rows as CSV