PREVIEW / stock_daily / 2024-04-26
file: by_date/stock_daily/2024/2024-04-26.parquet size: 229 KB rows: 7,134 symbols: 964
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-04-26 | AAPL | Stock | 169.88 | 171.34 | 169.18 | 169.3 | 44838400.0 |
| 2024-04-26 | MSFT | Stock | 412.17 | 413.0 | 405.76 | 406.32 | 29694700.0 |
| 2024-04-26 | NVDA | Stock | 83.818 | 88.331 | 83.387 | 87.735 | 551011000.0 |
| 2024-04-26 | AMZN | Stock | 177.8 | 180.82 | 176.13 | 179.62 | 43919800.0 |
| 2024-04-26 | GOOGL | Stock | 174.37 | 174.71 | 169.65 | 171.95 | 64665299.0 |
| 2024-04-26 | META | Stock | 441.46 | 446.44 | 431.96 | 443.29 | 32691400.0 |
| 2024-04-26 | TSLA | Stock | 168.85 | 172.12 | 166.37 | 168.29 | 109815700.0 |
| 2024-04-26 | TLT | Stock | 88.245 | 88.605 | 88.05 | 88.24 | 31589821.0 |
| 2024-04-26 | ES | Stock | 60.57 | 60.75 | 59.43 | 59.46 | 1590700.0 |
| 2024-04-26 | CL | Stock | 91.0 | 92.25 | 89.19 | 91.01 | 7541500.0 |
| 2024-04-26 | A | Stock | 136.45 | 138.36 | 135.0 | 137.74 | 754900.0 |
| 2024-04-26 | AA | Stock | 36.51 | 37.39 | 36.23 | 36.88 | 5653300.0 |
| 2024-04-26 | AACG | Stock | 0.89 | 0.9 | 0.86 | 0.87 | 8600.0 |
| 2024-04-26 | AACIW-DELISTED | Stock | 0.145 | 0.1499 | 0.1356 | 0.1499 | 20077.0 |
| 2024-04-26 | AACT | Stock | 10.61 | 10.62 | 10.61 | 10.615 | 59200.0 |
| 2024-04-26 | AAGR-DELISTED | Stock | 0.365 | 0.3699 | 0.3 | 0.33 | 213526.0 |
| 2024-04-26 | AAL | Stock | 14.07 | 14.09 | 13.64 | 13.88 | 36527800.0 |
| 2024-04-26 | AAMC-DELISTED | Stock | 3.15 | 3.15 | 2.875 | 2.91 | 1800.0 |
| 2024-04-26 | AAME | Stock | 1.87 | 1.99 | 1.86 | 1.96 | 4700.0 |
| 2024-04-26 | AAMI | Stock | 22.93 | 23.105 | 22.59 | 22.61 | 136000.0 |
| 2024-04-26 | AAN-DELISTED | Stock | 7.33 | 7.38 | 7.07 | 7.07 | 183000.0 |
| 2024-04-26 | AAOI | Stock | 10.98 | 11.48 | 10.8 | 10.85 | 1510800.0 |
| 2024-04-26 | AAON | Stock | 90.48 | 91.72 | 89.86 | 91.15 | 367800.0 |
| 2024-04-26 | AAP | Stock | 74.82 | 75.95 | 74.15 | 75.14 | 721700.0 |
| 2024-04-26 | AAT | Stock | 21.33 | 21.57 | 21.21 | 21.23 | 189100.0 |
| 2024-04-26 | AATC | Stock | 6.33 | 6.68 | 6.33 | 6.35 | 7252.0 |
| 2024-04-26 | AAUAF-DELISTED | Stock | 0.119 | 0.125 | 0.118 | 0.125 | 46170.0 |
| 2024-04-26 | AAXJ | Stock | 68.22 | 68.4 | 68.13 | 68.36 | 137022.0 |
| 2024-04-26 | AB | Stock | 33.49 | 34.18 | 32.8 | 33.56 | 609300.0 |
| 2024-04-26 | ABAT | Stock | 1.4 | 1.4 | 1.29 | 1.34 | 397427.0 |
| 2024-04-26 | ABBV | Stock | 167.09 | 167.46 | 157.65 | 159.62 | 10721700.0 |
| 2024-04-26 | ABCB | Stock | 48.33 | 48.87 | 47.7 | 47.88 | 475000.0 |
| 2024-04-26 | ABCL | Stock | 3.69 | 3.8 | 3.64 | 3.76 | 1369600.0 |
| 2024-04-26 | ABEO | Stock | 3.27 | 3.38 | 3.2 | 3.26 | 1210900.0 |
| 2024-04-26 | ABEV | Stock | 2.33 | 2.35 | 2.32 | 2.33 | 5890800.0 |
| 2024-04-26 | ABG | Stock | 217.12 | 226.47 | 217.12 | 221.97 | 170300.0 |
| 2024-04-26 | ABLLW | Stock | 0.5542 | 0.58 | 0.5011 | 0.5394 | 17225.0 |
| 2024-04-26 | ABLV | Stock | 1.64 | 1.65 | 1.56 | 1.59 | 51600.0 |
| 2024-04-26 | ABM | Stock | 44.34 | 44.66 | 43.87 | 44.04 | 364000.0 |
| 2024-04-26 | ABNB | Stock | 163.68 | 165.16 | 162.77 | 164.23 | 2821100.0 |
| 2024-04-26 | ABOS | Stock | 3.19 | 3.21 | 3.134 | 3.17 | 140700.0 |
| 2024-04-26 | ABR | Stock | 12.63 | 12.96 | 12.57 | 12.82 | 2857700.0 |
| 2024-04-26 | ABR.D | Stock | 17.9009 | 18.2668 | 17.8001 | 17.94 | 6050.0 |
| 2024-04-26 | ABR.E | Stock | 17.76 | 17.8528 | 17.71 | 17.8528 | 2821.0 |
| 2024-04-26 | ABR.F | Stock | 18.67 | 18.77 | 18.51 | 18.56 | 9766.0 |
| 2024-04-26 | ABSI | Stock | 4.5 | 4.68 | 4.469 | 4.58 | 640100.0 |
| 2024-04-26 | ABT | Stock | 106.51 | 107.86 | 106.39 | 107.53 | 3575600.0 |
| 2024-04-26 | ABTC | Stock | 111.75 | 131.25 | 110.625 | 122.25 | 6637.333333333333 |
| 2024-04-26 | ABTS | Stock | 11.4 | 11.775 | 11.37 | 11.775 | 873.0 |
| 2024-04-26 | ABUS | Stock | 2.73 | 2.78 | 2.7 | 2.73 | 406700.0 |
> showing 50 of 7,134 rows — these rows as CSV