PREVIEW / stock_daily / 2024-11-25
file: by_date/stock_daily/2024/2024-11-25.parquet size: 248 KB rows: 7,189 symbols: 642
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-25 | AAPL | Stock | 231.46 | 233.245 | 229.74 | 232.87 | 79800676.0 |
| 2024-11-25 | MSFT | Stock | 418.38 | 421.08 | 414.85 | 418.79 | 24403976.0 |
| 2024-11-25 | NVDA | Stock | 141.99 | 142.05 | 135.82 | 136.02 | 312434017.0 |
| 2024-11-25 | AMZN | Stock | 199.28 | 201.9499 | 199.0 | 201.45 | 38296359.0 |
| 2024-11-25 | GOOGL | Stock | 166.09 | 168.63 | 165.6072 | 167.65 | 33135263.0 |
| 2024-11-25 | META | Stock | 562.1 | 572.5915 | 556.39 | 565.11 | 12900400.0 |
| 2024-11-25 | TSLA | Stock | 360.14 | 361.93 | 338.2 | 338.59 | 90664060.0 |
| 2024-11-25 | TLT | Stock | 92.2 | 92.78 | 91.985 | 92.73 | 56858036.0 |
| 2024-11-25 | ES | Stock | 63.77 | 64.07 | 63.37 | 63.98 | 2551350.0 |
| 2024-11-25 | CL | Stock | 95.54 | 95.75 | 94.93 | 95.34 | 4191891.0 |
| 2024-11-25 | A | Stock | 134.53 | 135.61 | 133.76 | 134.49 | 3141830.0 |
| 2024-11-25 | AA | Stock | 45.99 | 47.44 | 45.915 | 47.22 | 5369989.0 |
| 2024-11-25 | AACG | Stock | 0.9999 | 1.02 | 0.9703 | 1.02 | 56437.0 |
| 2024-11-25 | AACT | Stock | 10.88 | 10.91 | 10.88 | 10.9 | 11309.0 |
| 2024-11-25 | AAGR-DELISTED | Stock | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 24858.0 |
| 2024-11-25 | AAL | Stock | 14.65 | 15.125 | 14.555 | 14.92 | 31301455.0 |
| 2024-11-25 | AAM | Stock | 10.05 | 10.06 | 10.05 | 10.05 | 57756.0 |
| 2024-11-25 | AAME | Stock | 1.68 | 1.76 | 1.26 | 1.58 | 43293.0 |
| 2024-11-25 | AAMI | Stock | 31.1 | 31.49 | 30.99 | 31.0 | 143719.0 |
| 2024-11-25 | AAOI | Stock | 38.445 | 39.61 | 35.82 | 37.91 | 3440416.0 |
| 2024-11-25 | AAON | Stock | 139.39 | 142.2 | 137.23 | 137.59 | 594008.0 |
| 2024-11-25 | AAP | Stock | 41.76 | 43.74 | 41.3975 | 43.42 | 3043945.0 |
| 2024-11-25 | AAT | Stock | 28.4 | 28.67 | 28.18 | 28.29 | 270868.0 |
| 2024-11-25 | AATC | Stock | 7.98 | 7.99 | 7.92 | 7.975 | 9334.0 |
| 2024-11-25 | AAUAF-DELISTED | Stock | 0.0355 | 0.043 | 0.0355 | 0.0355 | 238790.0 |
| 2024-11-25 | AAXJ | Stock | 74.31 | 74.38 | 73.865 | 74.11 | 700450.0 |
| 2024-11-25 | AB | Stock | 35.73 | 36.3 | 35.22 | 35.3 | 457671.0 |
| 2024-11-25 | ABAT | Stock | 0.91 | 1.04 | 0.891 | 0.9452 | 1020253.0 |
| 2024-11-25 | ABBV | Stock | 177.02 | 180.19 | 176.75 | 177.06 | 11958606.0 |
| 2024-11-25 | ABCB | Stock | 72.85 | 74.56 | 72.34 | 72.37 | 347636.0 |
| 2024-11-25 | ABCL | Stock | 2.8 | 3.02 | 2.8 | 2.95 | 2517628.0 |
| 2024-11-25 | ABEO | Stock | 6.06 | 6.19 | 5.94 | 5.94 | 191262.0 |
| 2024-11-25 | ABEV | Stock | 2.2 | 2.21 | 2.17 | 2.17 | 14506251.0 |
| 2024-11-25 | ABG | Stock | 264.7 | 276.575 | 263.99 | 266.82 | 245848.0 |
| 2024-11-25 | ABLLW | Stock | 1.2 | 1.2118 | 1.06 | 1.15 | 31890.0 |
| 2024-11-25 | ABLV | Stock | 0.835 | 0.88 | 0.835 | 0.88 | 5125.0 |
| 2024-11-25 | ABM | Stock | 57.26 | 58.18 | 56.84 | 57.36 | 273921.0 |
| 2024-11-25 | ABNB | Stock | 138.01 | 141.0 | 137.75 | 140.93 | 6847202.0 |
| 2024-11-25 | ABOS | Stock | 2.4 | 2.47 | 2.31 | 2.36 | 175022.0 |
| 2024-11-25 | ABR | Stock | 14.7 | 14.98 | 14.69 | 14.76 | 1805845.0 |
| 2024-11-25 | ABR.D | Stock | 18.83 | 19.3968 | 18.7969 | 19.27 | 32747.0 |
| 2024-11-25 | ABR.E | Stock | 19.07 | 19.25 | 19.02 | 19.25 | 2492.0 |
| 2024-11-25 | ABR.F | Stock | 20.51 | 21.1 | 20.51 | 20.84 | 37827.0 |
| 2024-11-25 | ABSI | Stock | 2.76 | 2.98 | 2.715 | 2.83 | 1696481.0 |
| 2024-11-25 | ABT | Stock | 118.28 | 118.65 | 117.58 | 118.13 | 6476616.0 |
| 2024-11-25 | ABTC | Stock | 51.75 | 59.475 | 48.9525 | 51.84 | 15525.333333333334 |
| 2024-11-25 | ABTS | Stock | 9.735 | 10.2 | 9.3 | 9.945 | 6406.0 |
| 2024-11-25 | ABUS | Stock | 3.52 | 3.58 | 3.41 | 3.42 | 2375161.0 |
| 2024-11-25 | ABVC | Stock | 0.55 | 0.55 | 0.52 | 0.522 | 108534.0 |
| 2024-11-25 | ABVE | Stock | 0.6595 | 0.92 | 0.641 | 0.814 | 3542039.0 |
> showing 50 of 7,189 rows — these rows as CSV