PREVIEW / stock_daily / 2024-10-29
file: by_date/stock_daily/2024/2024-10-29.parquet size: 245 KB rows: 7,114 symbols: 684
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-29 | AAPL | Stock | 233.1 | 234.325 | 232.32 | 233.67 | 31798841.0 |
| 2024-10-29 | MSFT | Stock | 428.0 | 433.17 | 425.8001 | 431.95 | 16487474.0 |
| 2024-10-29 | NVDA | Stock | 140.285 | 142.2598 | 138.9 | 141.25 | 150850081.0 |
| 2024-10-29 | AMZN | Stock | 188.58 | 191.4599 | 187.815 | 190.83 | 29973916.0 |
| 2024-10-29 | GOOGL | Stock | 167.73 | 170.38 | 167.0896 | 169.68 | 42169025.0 |
| 2024-10-29 | META | Stock | 580.145 | 593.67 | 575.398 | 593.28 | 12048849.0 |
| 2024-10-29 | TSLA | Stock | 264.51 | 264.98 | 255.51 | 259.52 | 78977708.0 |
| 2024-10-29 | TLT | Stock | 91.17 | 92.06 | 90.9837 | 92.03 | 46545204.0 |
| 2024-10-29 | ES | Stock | 66.06 | 66.21 | 64.34 | 64.55 | 1818815.0 |
| 2024-10-29 | CL | Stock | 95.02 | 95.52 | 94.43 | 94.72 | 5280718.0 |
| 2024-10-29 | A | Stock | 131.14 | 132.29 | 130.56 | 131.23 | 828958.0 |
| 2024-10-29 | AA | Stock | 41.67 | 41.94 | 40.825 | 40.96 | 3279221.0 |
| 2024-10-29 | AACG | Stock | 0.97 | 1.0 | 0.9248 | 0.9705 | 183264.0 |
| 2024-10-29 | AACT | Stock | 10.8832 | 10.9 | 10.88 | 10.88 | 62462.0 |
| 2024-10-29 | AAGR-DELISTED | Stock | 0.0002 | 0.0086 | 0.0002 | 0.0086 | 5598.0 |
| 2024-10-29 | AAL | Stock | 13.38 | 13.86 | 13.28 | 13.82 | 28604530.0 |
| 2024-10-29 | AAM | Stock | 10.04 | 10.04 | 10.04 | 10.04 | 293967.0 |
| 2024-10-29 | AAME | Stock | 1.55 | 1.71 | 1.55 | 1.7 | 1379.0 |
| 2024-10-29 | AAMI | Stock | 26.19 | 26.625 | 26.19 | 26.33 | 103230.0 |
| 2024-10-29 | AAOI | Stock | 16.35 | 16.67 | 15.19 | 15.67 | 4007500.0 |
| 2024-10-29 | AAON | Stock | 121.0 | 121.93 | 118.96 | 119.21 | 587056.0 |
| 2024-10-29 | AAP | Stock | 36.83 | 37.09 | 35.83 | 35.85 | 3059637.0 |
| 2024-10-29 | AAT | Stock | 27.23 | 27.415 | 27.1 | 27.34 | 149414.0 |
| 2024-10-29 | AATC | Stock | 7.52 | 7.6 | 7.5 | 7.51 | 7056.0 |
| 2024-10-29 | AAUAF-DELISTED | Stock | 0.0442 | 0.0558 | 0.0442 | 0.0529 | 45906.0 |
| 2024-10-29 | AAXJ | Stock | 77.29 | 77.42 | 77.12 | 77.18 | 563004.0 |
| 2024-10-29 | AB | Stock | 38.0 | 38.27 | 37.59 | 37.59 | 193592.0 |
| 2024-10-29 | ABAT | Stock | 1.0 | 1.02 | 0.995 | 1.0 | 327404.0 |
| 2024-10-29 | ABBV | Stock | 190.49 | 191.16 | 188.515 | 189.45 | 5808678.0 |
| 2024-10-29 | ABCB | Stock | 62.77 | 62.835 | 61.96 | 62.29 | 207419.0 |
| 2024-10-29 | ABCL | Stock | 2.86 | 2.8899 | 2.77 | 2.83 | 1152042.0 |
| 2024-10-29 | ABEO | Stock | 6.78 | 6.78 | 6.35 | 6.57 | 500333.0 |
| 2024-10-29 | ABEV | Stock | 2.28 | 2.3 | 2.25 | 2.28 | 20107702.0 |
| 2024-10-29 | ABG | Stock | 231.06 | 233.115 | 223.17 | 231.42 | 349698.0 |
| 2024-10-29 | ABLLW | Stock | 1.58 | 1.58 | 1.38 | 1.43 | 73862.0 |
| 2024-10-29 | ABLV | Stock | 0.9 | 0.92 | 0.9 | 0.91 | 12230.0 |
| 2024-10-29 | ABLVW | Stock | 0.0198 | 0.02 | 0.0105 | 0.011 | 8584.0 |
| 2024-10-29 | ABM | Stock | 53.47 | 53.795 | 53.16 | 53.65 | 224769.0 |
| 2024-10-29 | ABNB | Stock | 135.33 | 138.35 | 135.2438 | 137.78 | 2724355.0 |
| 2024-10-29 | ABOS | Stock | 2.95 | 2.95 | 2.75 | 2.905 | 201070.0 |
| 2024-10-29 | ABR | Stock | 15.1 | 15.18 | 14.93 | 15.12 | 1211140.0 |
| 2024-10-29 | ABR.D | Stock | 19.6623 | 19.81 | 19.6517 | 19.81 | 7862.0 |
| 2024-10-29 | ABR.E | Stock | 19.92 | 20.0 | 19.8 | 20.0 | 5028.0 |
| 2024-10-29 | ABR.F | Stock | 20.36 | 20.49 | 20.2 | 20.49 | 15877.0 |
| 2024-10-29 | ABSI | Stock | 4.33 | 4.35 | 4.135 | 4.17 | 1094275.0 |
| 2024-10-29 | ABT | Stock | 114.14 | 114.74 | 113.35 | 113.4 | 3594892.0 |
| 2024-10-29 | ABTC | Stock | 56.324999999999996 | 59.58 | 53.4525 | 56.1 | 20398.13333333333 |
| 2024-10-29 | ABTS | Stock | 6.984 | 9.1515 | 6.732 | 8.7 | 26305.0 |
| 2024-10-29 | ABUS | Stock | 4.05 | 4.05 | 3.97 | 4.04 | 536572.0 |
| 2024-10-29 | ABVC | Stock | 0.71 | 0.77 | 0.69 | 0.7027 | 187723.0 |
> showing 50 of 7,114 rows — these rows as CSV