PREVIEW / stock_daily / 2024-02-27
file: by_date/stock_daily/2024/2024-02-27.parquet size: 236 KB rows: 7,326 symbols: 1,123
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-02-27 | AAPL | Stock | 181.1 | 183.92 | 179.56 | 182.63 | 54318900.0 |
| 2024-02-27 | MSFT | Stock | 407.99 | 408.32 | 403.85 | 407.48 | 14835800.0 |
| 2024-02-27 | NVDA | Stock | 79.381 | 79.48 | 77.162 | 78.701 | 391705000.0 |
| 2024-02-27 | AMZN | Stock | 174.08 | 174.62 | 172.86 | 173.54 | 31141700.0 |
| 2024-02-27 | GOOGL | Stock | 138.02 | 139.25 | 137.09 | 138.88 | 33099190.0 |
| 2024-02-27 | META | Stock | 479.98 | 487.27 | 479.92 | 487.05 | 10809600.0 |
| 2024-02-27 | TSLA | Stock | 204.04 | 205.6 | 198.26 | 199.73 | 108645400.0 |
| 2024-02-27 | TLT | Stock | 93.24 | 93.47 | 92.845 | 92.93 | 30241953.0 |
| 2024-02-27 | ES | Stock | 58.12 | 59.48 | 57.89 | 59.27 | 2677400.0 |
| 2024-02-27 | CL | Stock | 85.81 | 86.51 | 85.67 | 86.41 | 2638800.0 |
| 2024-02-27 | A | Stock | 131.45 | 133.18 | 130.87 | 132.55 | 1772700.0 |
| 2024-02-27 | AA | Stock | 25.91 | 27.0 | 25.2 | 26.7 | 6822600.0 |
| 2024-02-27 | AACG | Stock | 1.22 | 1.26 | 1.19 | 1.24 | 5800.0 |
| 2024-02-27 | AACT | Stock | 10.53 | 10.55 | 10.53 | 10.55 | 15600.0 |
| 2024-02-27 | AAGR-DELISTED | Stock | 0.75 | 0.75 | 0.7 | 0.746 | 86153.0 |
| 2024-02-27 | AAGRW-DELISTED | Stock | 0.0116 | 0.02 | 0.0116 | 0.0118 | 6829.0 |
| 2024-02-27 | AAL | Stock | 15.55 | 15.67 | 15.38 | 15.54 | 25223400.0 |
| 2024-02-27 | AAMC-DELISTED | Stock | 4.21 | 4.35 | 4.13 | 4.13 | 5200.0 |
| 2024-02-27 | AAME | Stock | 2.71 | 2.75 | 2.71 | 2.72 | 2900.0 |
| 2024-02-27 | AAMI | Stock | 22.6 | 22.65 | 22.4 | 22.63 | 343900.0 |
| 2024-02-27 | AAN-DELISTED | Stock | 8.84 | 9.16 | 8.0 | 8.52 | 962100.0 |
| 2024-02-27 | AAOI | Stock | 15.15 | 15.98 | 14.65 | 15.42 | 3206600.0 |
| 2024-02-27 | AAON | Stock | 86.04 | 86.5 | 85.19 | 85.82 | 332500.0 |
| 2024-02-27 | AAP | Stock | 62.03 | 64.81 | 61.56 | 64.75 | 2981400.0 |
| 2024-02-27 | AAT | Stock | 21.22 | 21.43 | 21.19 | 21.25 | 188100.0 |
| 2024-02-27 | AATC | Stock | 7.4 | 7.48 | 7.4 | 7.4 | 30935.0 |
| 2024-02-27 | AAU-DELISTED | Stock | 0.135 | 0.1355 | 0.135 | 0.135 | 266006.0 |
| 2024-02-27 | AAUAF-DELISTED | Stock | 0.135 | 0.1355 | 0.135 | 0.1353 | 267586.0 |
| 2024-02-27 | AAXJ | Stock | 66.7 | 66.79 | 66.63 | 66.67 | 688690.0 |
| 2024-02-27 | AB | Stock | 33.5 | 34.0 | 33.4 | 33.75 | 233200.0 |
| 2024-02-27 | ABAT | Stock | 2.25 | 2.27 | 2.1322 | 2.19 | 487686.0 |
| 2024-02-27 | ABBV | Stock | 178.77 | 179.53 | 176.98 | 178.99 | 3888500.0 |
| 2024-02-27 | ABCB | Stock | 45.89 | 46.15 | 45.08 | 45.43 | 315900.0 |
| 2024-02-27 | ABCL | Stock | 4.97 | 5.21 | 4.96 | 5.12 | 2588600.0 |
| 2024-02-27 | ABEO | Stock | 7.54 | 7.87 | 7.08 | 7.35 | 623200.0 |
| 2024-02-27 | ABEV | Stock | 2.65 | 2.68 | 2.64 | 2.66 | 13832800.0 |
| 2024-02-27 | ABG | Stock | 213.53 | 215.86 | 211.48 | 212.0 | 194900.0 |
| 2024-02-27 | ABLLW | Stock | 0.72556 | 0.749 | 0.6786 | 0.695 | 69087.0 |
| 2024-02-27 | ABLV | Stock | 2.88 | 3.05 | 2.88 | 3.02 | 26300.0 |
| 2024-02-27 | ABLVW | Stock | 0.0221 | 0.0221 | 0.0221 | 0.0221 | 2800.0 |
| 2024-02-27 | ABM | Stock | 41.0 | 41.19 | 40.79 | 41.06 | 563300.0 |
| 2024-02-27 | ABNB | Stock | 150.0 | 152.47 | 149.23 | 152.06 | 4623700.0 |
| 2024-02-27 | ABOS | Stock | 3.72 | 4.12 | 3.72 | 4.07 | 733000.0 |
| 2024-02-27 | ABR | Stock | 13.15 | 13.41 | 13.02 | 13.24 | 3790500.0 |
| 2024-02-27 | ABR.D | Stock | 18.1 | 18.22 | 18.05 | 18.07 | 17588.0 |
| 2024-02-27 | ABR.E | Stock | 18.25 | 18.4 | 18.25 | 18.26 | 5488.0 |
| 2024-02-27 | ABR.F | Stock | 18.86 | 18.98 | 18.8 | 18.9 | 16684.0 |
| 2024-02-27 | ABSI | Stock | 5.0 | 5.07 | 4.84 | 4.92 | 1048500.0 |
| 2024-02-27 | ABT | Stock | 118.16 | 119.5 | 117.83 | 119.4 | 3203300.0 |
| 2024-02-27 | ABTC | Stock | 199.5 | 212.25 | 180.75 | 195.0 | 7220.0 |
> showing 50 of 7,326 rows — these rows as CSV