PREVIEW / stock_daily / 2024-11-22
file: by_date/stock_daily/2024/2024-11-22.parquet size: 247 KB rows: 7,138 symbols: 641
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-11-22 | AAPL | Stock | 228.06 | 230.7199 | 228.06 | 229.87 | 35489280.0 |
| 2024-11-22 | MSFT | Stock | 411.365 | 417.4 | 411.06 | 417.0 | 22789746.0 |
| 2024-11-22 | NVDA | Stock | 145.93 | 147.16 | 141.1 | 141.95 | 232286433.0 |
| 2024-11-22 | AMZN | Stock | 198.25 | 199.2599 | 196.75 | 197.12 | 30202429.0 |
| 2024-11-22 | GOOGL | Stock | 165.85 | 166.46 | 163.9 | 164.76 | 38604587.0 |
| 2024-11-22 | META | Stock | 563.55 | 563.8273 | 554.59 | 559.14 | 8938457.0 |
| 2024-11-22 | TSLA | Stock | 341.085 | 361.53 | 337.7 | 352.56 | 88092436.0 |
| 2024-11-22 | TLT | Stock | 90.51 | 90.7 | 90.15 | 90.39 | 21547548.0 |
| 2024-11-22 | ES | Stock | 62.83 | 63.75 | 62.65 | 63.38 | 1351449.0 |
| 2024-11-22 | CL | Stock | 94.99 | 95.425 | 94.49 | 94.92 | 3370670.0 |
| 2024-11-22 | A | Stock | 132.1 | 134.32 | 131.5 | 133.84 | 2016233.0 |
| 2024-11-22 | AA | Stock | 46.04 | 46.3399 | 45.33 | 45.47 | 3141651.0 |
| 2024-11-22 | AACG | Stock | 1.0 | 1.02 | 0.9801 | 1.02 | 51023.0 |
| 2024-11-22 | AACT | Stock | 10.91 | 10.92 | 10.9 | 10.9 | 75446.0 |
| 2024-11-22 | AAGR-DELISTED | Stock | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 4467.0 |
| 2024-11-22 | AAL | Stock | 14.22 | 14.44 | 14.085 | 14.38 | 19935561.0 |
| 2024-11-22 | AAM | Stock | 10.06 | 10.06 | 10.05 | 10.06 | 8623.0 |
| 2024-11-22 | AAME | Stock | 1.6399 | 1.6399 | 1.6399 | 1.6399 | 1589.0 |
| 2024-11-22 | AAMI | Stock | 30.53 | 31.1 | 30.53 | 30.97 | 147114.0 |
| 2024-11-22 | AAOI | Stock | 35.8216 | 38.94 | 35.1738 | 37.99 | 4772525.0 |
| 2024-11-22 | AAON | Stock | 136.14 | 137.765 | 134.0 | 137.42 | 558543.0 |
| 2024-11-22 | AAP | Stock | 38.7 | 40.88 | 38.68 | 40.79 | 2541691.0 |
| 2024-11-22 | AAT | Stock | 27.9 | 28.35 | 27.9 | 28.08 | 243897.0 |
| 2024-11-22 | AATC | Stock | 8.0 | 8.03 | 8.0 | 8.0 | 1848.0 |
| 2024-11-22 | AAUAF-DELISTED | Stock | 0.035 | 0.0376 | 0.035 | 0.03755 | 16611.0 |
| 2024-11-22 | AAXJ | Stock | 73.84 | 74.03 | 73.74 | 74.0 | 202287.0 |
| 2024-11-22 | AB | Stock | 36.8 | 36.98 | 35.26 | 35.58 | 733249.0 |
| 2024-11-22 | ABAT | Stock | 0.76 | 0.922 | 0.76 | 0.8899 | 1368197.0 |
| 2024-11-22 | ABBV | Stock | 174.34 | 178.864 | 173.5 | 176.95 | 9127148.0 |
| 2024-11-22 | ABCB | Stock | 70.2 | 72.01 | 69.95 | 71.79 | 315079.0 |
| 2024-11-22 | ABCL | Stock | 2.74 | 2.8299 | 2.71 | 2.76 | 1802735.0 |
| 2024-11-22 | ABEO | Stock | 5.8 | 6.17 | 5.76 | 5.98 | 387423.0 |
| 2024-11-22 | ABEV | Stock | 2.17 | 2.2 | 2.16 | 2.19 | 12269173.0 |
| 2024-11-22 | ABG | Stock | 258.98 | 264.46 | 258.98 | 261.3 | 180664.0 |
| 2024-11-22 | ABLLW | Stock | 1.23 | 1.2757 | 1.04 | 1.15 | 93336.0 |
| 2024-11-22 | ABLV | Stock | 0.81 | 0.9005 | 0.7985 | 0.9 | 23652.0 |
| 2024-11-22 | ABM | Stock | 56.77 | 57.63 | 56.38 | 56.79 | 221863.0 |
| 2024-11-22 | ABNB | Stock | 133.3 | 140.76 | 133.3 | 137.34 | 5739963.0 |
| 2024-11-22 | ABOS | Stock | 2.3 | 2.38 | 2.26 | 2.37 | 180921.0 |
| 2024-11-22 | ABPWW | Stock | 0.0506 | 0.07 | 0.044 | 0.06 | 19551.0 |
| 2024-11-22 | ABR | Stock | 14.5 | 14.725 | 14.5 | 14.58 | 1445377.0 |
| 2024-11-22 | ABR.D | Stock | 18.45 | 18.8 | 18.45 | 18.7 | 29607.0 |
| 2024-11-22 | ABR.E | Stock | 18.32 | 19.1562 | 18.3 | 18.3 | 5207.0 |
| 2024-11-22 | ABR.F | Stock | 20.62 | 20.94 | 20.4 | 20.4 | 21385.0 |
| 2024-11-22 | ABSI | Stock | 2.58 | 2.64 | 2.52 | 2.56 | 1085972.0 |
| 2024-11-22 | ABT | Stock | 117.224 | 118.0 | 116.38 | 117.76 | 4877075.0 |
| 2024-11-22 | ABTC | Stock | 48.0 | 52.0575 | 46.4025 | 51.5475 | 17224.066666666666 |
| 2024-11-22 | ABTS | Stock | 9.6 | 10.05 | 9.3218 | 9.45 | 4952.0 |
| 2024-11-22 | ABUS | Stock | 3.47 | 3.525 | 3.45 | 3.51 | 701637.0 |
| 2024-11-22 | ABVC | Stock | 0.569 | 0.5732 | 0.531 | 0.5488 | 48550.0 |
> showing 50 of 7,138 rows — these rows as CSV