PREVIEW / stock_daily / 2024-10-09
file: by_date/stock_daily/2024/2024-10-09.parquet size: 245 KB rows: 7,096 symbols: 701
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-09 | AAPL | Stock | 225.23 | 229.75 | 224.83 | 229.54 | 31534739.0 |
| 2024-10-09 | MSFT | Stock | 415.86 | 420.38 | 414.3 | 417.46 | 14400231.0 |
| 2024-10-09 | NVDA | Stock | 134.11 | 134.52 | 131.38 | 132.65 | 243017977.0 |
| 2024-10-09 | AMZN | Stock | 182.82 | 185.845 | 182.05 | 185.17 | 25703498.0 |
| 2024-10-09 | GOOGL | Stock | 163.45 | 164.84 | 159.74 | 161.86 | 31181774.0 |
| 2024-10-09 | META | Stock | 593.99 | 594.39 | 581.61 | 590.51 | 9478163.0 |
| 2024-10-09 | TSLA | Stock | 243.82 | 247.43 | 239.51 | 241.05 | 65868672.0 |
| 2024-10-09 | TLT | Stock | 94.67 | 94.905 | 94.23 | 94.45 | 35807681.0 |
| 2024-10-09 | ES | Stock | 63.75 | 64.62 | 63.1 | 63.39 | 1481023.0 |
| 2024-10-09 | CL | Stock | 100.58 | 101.3 | 100.28 | 101.0 | 3479317.0 |
| 2024-10-09 | A | Stock | 145.03 | 145.5899 | 144.18 | 144.8 | 614766.0 |
| 2024-10-09 | AA | Stock | 37.34 | 38.69 | 36.875 | 38.44 | 4330817.0 |
| 2024-10-09 | AACG | Stock | 0.87 | 0.91 | 0.8203 | 0.91 | 41636.0 |
| 2024-10-09 | AACT | Stock | 10.8 | 10.84 | 10.8 | 10.82 | 315549.0 |
| 2024-10-09 | AAGR-DELISTED | Stock | 0.02995 | 0.0385 | 0.0214 | 0.0234 | 174854.0 |
| 2024-10-09 | AAGRW-DELISTED | Stock | 0.0015 | 0.0015 | 0.0015 | 0.0015 | 411.0 |
| 2024-10-09 | AAL | Stock | 12.01 | 12.25 | 11.8732 | 11.93 | 34098334.0 |
| 2024-10-09 | AAM | Stock | 10.01 | 10.02 | 10.01 | 10.01 | 92484.0 |
| 2024-10-09 | AAME | Stock | 1.66 | 1.66 | 1.65 | 1.66 | 1204.0 |
| 2024-10-09 | AAMI | Stock | 23.72 | 24.305 | 23.51 | 24.25 | 172641.0 |
| 2024-10-09 | AAOI | Stock | 16.31 | 16.6 | 15.67 | 16.17 | 2078711.0 |
| 2024-10-09 | AAON | Stock | 109.15 | 110.5 | 108.87 | 109.48 | 155002.0 |
| 2024-10-09 | AAP | Stock | 39.02 | 39.45 | 38.01 | 38.44 | 3325957.0 |
| 2024-10-09 | AAT | Stock | 26.29 | 26.515 | 26.16 | 26.39 | 147202.0 |
| 2024-10-09 | AATC | Stock | 7.6625 | 7.67 | 7.6 | 7.6 | 5605.0 |
| 2024-10-09 | AAUAF-DELISTED | Stock | 0.0465 | 0.05 | 0.0465 | 0.04885 | 22853.0 |
| 2024-10-09 | AAXJ | Stock | 78.21 | 79.12 | 78.12 | 78.91 | 813316.0 |
| 2024-10-09 | AB | Stock | 34.6 | 34.93 | 34.56 | 34.73 | 126210.0 |
| 2024-10-09 | ABAT | Stock | 1.04 | 1.04 | 0.98 | 0.99 | 381739.0 |
| 2024-10-09 | ABBV | Stock | 192.85 | 194.885 | 191.95 | 194.75 | 4397694.0 |
| 2024-10-09 | ABCB | Stock | 59.84 | 61.58 | 59.72 | 60.79 | 353544.0 |
| 2024-10-09 | ABCL | Stock | 2.56 | 2.6093 | 2.4713 | 2.49 | 1103966.0 |
| 2024-10-09 | ABEO | Stock | 6.52 | 6.67 | 6.39 | 6.64 | 219697.0 |
| 2024-10-09 | ABEV | Stock | 2.35 | 2.38 | 2.33 | 2.36 | 26669758.0 |
| 2024-10-09 | ABG | Stock | 227.7 | 228.63 | 223.43 | 223.61 | 170385.0 |
| 2024-10-09 | ABLLW | Stock | 1.52 | 1.65 | 1.52 | 1.6 | 8605.0 |
| 2024-10-09 | ABLV | Stock | 0.96 | 0.99 | 0.96 | 0.96 | 30793.0 |
| 2024-10-09 | ABLVW | Stock | 0.0249 | 0.0249 | 0.0125 | 0.015 | 147961.0 |
| 2024-10-09 | ABM | Stock | 52.35 | 52.92 | 52.1487 | 52.54 | 510819.0 |
| 2024-10-09 | ABNB | Stock | 133.4 | 135.76 | 132.84 | 135.49 | 3709880.0 |
| 2024-10-09 | ABOS | Stock | 2.4 | 2.41 | 2.27 | 2.29 | 121874.0 |
| 2024-10-09 | ABR | Stock | 14.84 | 15.23 | 14.79 | 15.14 | 2143191.0 |
| 2024-10-09 | ABR.D | Stock | 19.64 | 19.9799 | 19.64 | 19.8238 | 7956.0 |
| 2024-10-09 | ABR.E | Stock | 19.7555 | 20.37 | 19.7555 | 20.01 | 1520.0 |
| 2024-10-09 | ABR.F | Stock | 19.7 | 19.8 | 19.62 | 19.6628 | 9345.0 |
| 2024-10-09 | ABSI | Stock | 3.94 | 4.0 | 3.77 | 3.81 | 712177.0 |
| 2024-10-09 | ABT | Stock | 114.98 | 116.27 | 114.56 | 115.95 | 4164921.0 |
| 2024-10-09 | ABTC | Stock | 39.3675 | 41.339999999999996 | 38.55 | 40.515 | 1324.9333333333334 |
| 2024-10-09 | ABTS | Stock | 6.45 | 6.45 | 6.225 | 6.4425 | 412.0 |
| 2024-10-09 | ABUS | Stock | 3.77 | 3.78 | 3.7 | 3.76 | 493508.0 |
> showing 50 of 7,096 rows — these rows as CSV