PREVIEW / stock_daily / 2024-10-31
file: by_date/stock_daily/2024/2024-10-31.parquet size: 243 KB rows: 7,094 symbols: 674
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-10-31 | AAPL | Stock | 229.34 | 229.83 | 225.37 | 225.91 | 59565957.0 |
| 2024-10-31 | MSFT | Stock | 415.36 | 416.16 | 406.3 | 406.35 | 52805889.0 |
| 2024-10-31 | NVDA | Stock | 137.6 | 137.61 | 132.1106 | 132.76 | 263383906.0 |
| 2024-10-31 | AMZN | Stock | 190.51 | 190.6 | 185.23 | 186.4 | 70706202.0 |
| 2024-10-31 | GOOGL | Stock | 173.13 | 176.82 | 171.0 | 171.11 | 44768981.0 |
| 2024-10-31 | META | Stock | 585.0 | 589.9 | 563.01 | 567.58 | 26288434.0 |
| 2024-10-31 | TSLA | Stock | 257.99 | 259.75 | 249.25 | 249.85 | 65819726.0 |
| 2024-10-31 | TLT | Stock | 92.2 | 92.94 | 91.87 | 92.45 | 52173754.0 |
| 2024-10-31 | ES | Stock | 65.55 | 66.62 | 65.49 | 65.85 | 3520501.0 |
| 2024-10-31 | CL | Stock | 94.55 | 95.3 | 93.65 | 93.71 | 4729949.0 |
| 2024-10-31 | A | Stock | 130.67 | 131.44 | 129.86 | 130.31 | 1508298.0 |
| 2024-10-31 | AA | Stock | 40.34 | 40.556 | 39.4444 | 40.09 | 3872531.0 |
| 2024-10-31 | AACG | Stock | 0.9588 | 0.97 | 0.9249 | 0.9324 | 18187.0 |
| 2024-10-31 | AACT | Stock | 10.9 | 10.9 | 10.88 | 10.88 | 53203.0 |
| 2024-10-31 | AAGR-DELISTED | Stock | 0.0004 | 0.0004 | 0.0004 | 0.0004 | 47660.0 |
| 2024-10-31 | AAL | Stock | 13.79 | 13.89 | 13.38 | 13.4 | 26214213.0 |
| 2024-10-31 | AAM | Stock | 10.03 | 10.05 | 10.03 | 10.04 | 116813.0 |
| 2024-10-31 | AAME | Stock | 1.5606 | 1.6601 | 1.5606 | 1.59 | 3428.0 |
| 2024-10-31 | AAMI | Stock | 27.51 | 27.58 | 26.2 | 26.39 | 155487.0 |
| 2024-10-31 | AAOI | Stock | 16.01 | 16.22 | 15.5 | 15.62 | 1728894.0 |
| 2024-10-31 | AAON | Stock | 114.3 | 116.0125 | 113.13 | 114.22 | 202569.0 |
| 2024-10-31 | AAP | Stock | 36.0 | 36.15 | 35.59 | 35.69 | 2323423.0 |
| 2024-10-31 | AAT | Stock | 27.62 | 27.765 | 26.89 | 26.95 | 216760.0 |
| 2024-10-31 | AATC | Stock | 7.46 | 7.497 | 7.46 | 7.497 | 2109.0 |
| 2024-10-31 | AAUAF-DELISTED | Stock | 0.05055 | 0.0525 | 0.046 | 0.05 | 59975.0 |
| 2024-10-31 | AAXJ | Stock | 76.02 | 76.02 | 75.37 | 75.94 | 198143.0 |
| 2024-10-31 | AB | Stock | 37.17 | 37.4399 | 36.92 | 37.05 | 204065.0 |
| 2024-10-31 | ABAT | Stock | 1.01 | 1.01 | 0.96 | 0.9967 | 351110.0 |
| 2024-10-31 | ABBV | Stock | 201.97 | 207.32 | 201.42 | 203.87 | 8246661.0 |
| 2024-10-31 | ABCB | Stock | 63.39 | 63.55 | 61.75 | 61.99 | 309619.0 |
| 2024-10-31 | ABCL | Stock | 2.76 | 2.78 | 2.7 | 2.73 | 954941.0 |
| 2024-10-31 | ABEO | Stock | 6.32 | 6.425 | 6.04 | 6.41 | 253506.0 |
| 2024-10-31 | ABEV | Stock | 2.22 | 2.24 | 2.18 | 2.18 | 18693215.0 |
| 2024-10-31 | ABG | Stock | 235.36 | 235.36 | 227.83 | 227.84 | 146676.0 |
| 2024-10-31 | ABLLW | Stock | 1.38 | 1.49 | 1.37 | 1.4326 | 19615.0 |
| 2024-10-31 | ABLV | Stock | 0.8993 | 0.92 | 0.86 | 0.92 | 13402.0 |
| 2024-10-31 | ABM | Stock | 53.62 | 53.84 | 52.97 | 53.06 | 380145.0 |
| 2024-10-31 | ABNB | Stock | 137.7 | 138.06 | 134.26 | 134.79 | 4942741.0 |
| 2024-10-31 | ABOS | Stock | 3.04 | 3.04 | 2.85 | 2.88 | 157658.0 |
| 2024-10-31 | ABR | Stock | 15.12 | 15.13 | 14.725 | 14.74 | 3633928.0 |
| 2024-10-31 | ABR.D | Stock | 19.92 | 19.93 | 19.3456 | 19.79 | 17935.0 |
| 2024-10-31 | ABR.E | Stock | 19.6 | 19.6 | 19.41 | 19.55 | 9554.0 |
| 2024-10-31 | ABR.F | Stock | 20.47 | 20.9 | 20.22 | 20.69 | 32449.0 |
| 2024-10-31 | ABSI | Stock | 4.1 | 4.1 | 3.83 | 3.84 | 1355383.0 |
| 2024-10-31 | ABT | Stock | 113.57 | 114.47 | 113.27 | 113.37 | 4905087.0 |
| 2024-10-31 | ABTC | Stock | 53.25 | 53.25 | 45.825 | 47.04 | 7489.933333333333 |
| 2024-10-31 | ABTS | Stock | 9.3 | 9.3 | 7.71 | 8.1165 | 2462.0 |
| 2024-10-31 | ABUS | Stock | 3.94 | 3.96 | 3.825 | 3.845 | 716477.0 |
| 2024-10-31 | ABVC | Stock | 0.7 | 0.72 | 0.6804 | 0.691 | 88225.0 |
| 2024-10-31 | ABVE | Stock | 0.4673 | 0.4673 | 0.34 | 0.3904 | 177139.0 |
> showing 50 of 7,094 rows — these rows as CSV