PREVIEW / stock_daily / 2024-07-26
file: by_date/stock_daily/2024/2024-07-26.parquet size: 246 KB rows: 7,189 symbols: 884
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-26 | AAPL | Stock | 218.7 | 219.49 | 216.01 | 217.96 | 39800448.0 |
| 2024-07-26 | MSFT | Stock | 418.2 | 428.915 | 417.27 | 425.27 | 20684235.0 |
| 2024-07-26 | NVDA | Stock | 116.19 | 116.2 | 111.58 | 113.06 | 283357905.0 |
| 2024-07-26 | AMZN | Stock | 180.39 | 183.19 | 180.24 | 182.5 | 27609567.0 |
| 2024-07-26 | GOOGL | Stock | 167.15 | 168.09 | 164.06 | 167.0 | 41336886.0 |
| 2024-07-26 | META | Stock | 464.195 | 469.77 | 459.42 | 465.7 | 13840820.0 |
| 2024-07-26 | TSLA | Stock | 221.19 | 222.2799 | 215.33 | 219.8 | 94072629.0 |
| 2024-07-26 | TLT | Stock | 92.95 | 93.15 | 92.71 | 92.99 | 34423772.0 |
| 2024-07-26 | ES | Stock | 63.69 | 64.57 | 63.34 | 64.5 | 3048726.0 |
| 2024-07-26 | CL | Stock | 99.0 | 100.61 | 98.32 | 99.39 | 6277156.0 |
| 2024-07-26 | A | Stock | 136.69 | 140.29 | 136.08 | 137.32 | 1696998.0 |
| 2024-07-26 | AA | Stock | 33.75 | 34.18 | 32.92 | 33.43 | 5772309.0 |
| 2024-07-26 | AACG | Stock | 0.66 | 0.6999 | 0.652 | 0.6521 | 9537.0 |
| 2024-07-26 | AACIW-DELISTED | Stock | 0.111 | 0.13025 | 0.111 | 0.13025 | 2061.0 |
| 2024-07-26 | AACT | Stock | 10.72 | 10.74 | 10.72 | 10.72 | 232667.0 |
| 2024-07-26 | AAGR-DELISTED | Stock | 0.153 | 0.1638 | 0.1501 | 0.1588 | 607325.0 |
| 2024-07-26 | AAGRW-DELISTED | Stock | 0.0118 | 0.0118 | 0.0097 | 0.0097 | 2330.0 |
| 2024-07-26 | AAL | Stock | 10.7 | 10.755 | 10.2147 | 10.62 | 45206854.0 |
| 2024-07-26 | AAMC-DELISTED | Stock | 2.87 | 2.87 | 2.85 | 2.87 | 2619.0 |
| 2024-07-26 | AAME | Stock | 1.605 | 1.63 | 1.51 | 1.583 | 12145.0 |
| 2024-07-26 | AAMI | Stock | 26.14 | 26.28 | 25.65 | 26.0 | 172006.0 |
| 2024-07-26 | AAN-DELISTED | Stock | 9.95 | 9.97 | 9.94 | 9.96 | 587564.0 |
| 2024-07-26 | AAOI | Stock | 9.02 | 9.24 | 8.625 | 8.67 | 1347864.0 |
| 2024-07-26 | AAON | Stock | 86.73 | 89.19 | 86.61 | 87.59 | 357676.0 |
| 2024-07-26 | AAP | Stock | 60.78 | 61.71 | 60.33 | 60.76 | 1370392.0 |
| 2024-07-26 | AAT | Stock | 24.93 | 25.32 | 24.74 | 25.22 | 168031.0 |
| 2024-07-26 | AATC | Stock | 6.8 | 6.8 | 6.73 | 6.73 | 2204.0 |
| 2024-07-26 | AAUAF-DELISTED | Stock | 0.05 | 0.0542 | 0.05 | 0.053 | 13449.0 |
| 2024-07-26 | AAXJ | Stock | 71.07 | 71.4 | 70.91 | 71.23 | 331902.0 |
| 2024-07-26 | AB | Stock | 34.44 | 35.45 | 34.3657 | 34.97 | 691183.0 |
| 2024-07-26 | ABAT | Stock | 1.02 | 1.03 | 0.99 | 1.01 | 228960.0 |
| 2024-07-26 | ABBV | Stock | 183.45 | 186.85 | 182.11 | 185.16 | 6746452.0 |
| 2024-07-26 | ABCB | Stock | 62.45 | 63.8 | 58.7221 | 61.71 | 467974.0 |
| 2024-07-26 | ABCL | Stock | 3.21 | 3.28 | 3.145 | 3.26 | 687266.0 |
| 2024-07-26 | ABEO | Stock | 5.17 | 5.25 | 5.03 | 5.1 | 241065.0 |
| 2024-07-26 | ABEV | Stock | 2.11 | 2.12 | 2.09 | 2.11 | 11035001.0 |
| 2024-07-26 | ABG | Stock | 252.2 | 255.625 | 249.44 | 254.21 | 165731.0 |
| 2024-07-26 | ABLLW | Stock | 1.05 | 1.07 | 1.01 | 1.07 | 13739.0 |
| 2024-07-26 | ABLV | Stock | 1.2 | 1.2 | 1.18 | 1.18 | 11914.0 |
| 2024-07-26 | ABM | Stock | 55.25 | 55.45 | 54.75 | 55.08 | 384733.0 |
| 2024-07-26 | ABNB | Stock | 141.9 | 141.91 | 139.03 | 140.1 | 5083039.0 |
| 2024-07-26 | ABOS | Stock | 3.55 | 3.57 | 3.395 | 3.48 | 441725.0 |
| 2024-07-26 | ABR | Stock | 13.25 | 13.655 | 13.161 | 13.62 | 2698485.0 |
| 2024-07-26 | ABR.D | Stock | 17.25 | 17.8187 | 17.25 | 17.47 | 34493.0 |
| 2024-07-26 | ABR.E | Stock | 17.33 | 17.45 | 17.33 | 17.45 | 3135.0 |
| 2024-07-26 | ABR.F | Stock | 18.8399 | 18.95 | 18.685 | 18.7 | 16612.0 |
| 2024-07-26 | ABSI | Stock | 4.5 | 4.54 | 4.38 | 4.48 | 728215.0 |
| 2024-07-26 | ABT | Stock | 106.46 | 107.14 | 104.66 | 105.24 | 7797198.0 |
| 2024-07-26 | ABTC | Stock | 68.33250000000001 | 70.5 | 68.25 | 68.8575 | 1143.6 |
| 2024-07-26 | ABTS | Stock | 8.25 | 8.55 | 8.049 | 8.295 | 12128.0 |
> showing 50 of 7,189 rows — these rows as CSV