PREVIEW / stock_daily / 2024-10-30
file: by_date/stock_daily/2024/2024-10-30.parquet size: 245 KB rows: 7,126 symbols: 680
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-30 | AAPL | Stock | 232.61 | 233.2299 | 229.55 | 230.1 | 44114012.0 |
| 2024-10-30 | MSFT | Stock | 437.435 | 438.5 | 432.1 | 432.53 | 27550735.0 |
| 2024-10-30 | NVDA | Stock | 139.54 | 140.33 | 136.81 | 139.335 | 170963620.0 |
| 2024-10-30 | AMZN | Stock | 194.695 | 195.61 | 192.42 | 192.73 | 35860494.0 |
| 2024-10-30 | GOOGL | Stock | 180.68 | 182.02 | 174.0599 | 174.46 | 68890787.0 |
| 2024-10-30 | META | Stock | 600.98 | 601.2 | 589.38 | 591.8 | 25998308.0 |
| 2024-10-30 | TSLA | Stock | 258.035 | 263.35 | 255.8201 | 257.55 | 53308946.0 |
| 2024-10-30 | TLT | Stock | 92.84 | 93.285 | 92.16 | 92.3 | 41951068.0 |
| 2024-10-30 | ES | Stock | 64.95 | 65.64 | 64.68 | 65.49 | 2111570.0 |
| 2024-10-30 | CL | Stock | 94.56 | 95.165 | 94.02 | 94.66 | 4368285.0 |
| 2024-10-30 | A | Stock | 131.66 | 134.11 | 131.14 | 131.49 | 1381637.0 |
| 2024-10-30 | AA | Stock | 40.64 | 41.19 | 39.83 | 40.56 | 3977100.0 |
| 2024-10-30 | AACG | Stock | 0.97 | 1.0 | 0.94 | 0.96 | 29658.0 |
| 2024-10-30 | AACT | Stock | 10.88 | 10.9 | 10.88 | 10.88 | 28043.0 |
| 2024-10-30 | AAGR-DELISTED | Stock | 0.0002 | 0.0008 | 0.0002 | 0.0002 | 63339.0 |
| 2024-10-30 | AAL | Stock | 13.655 | 13.99 | 13.61 | 13.94 | 22299798.0 |
| 2024-10-30 | AAM | Stock | 10.04 | 10.04 | 10.02 | 10.02 | 24238.0 |
| 2024-10-30 | AAME | Stock | 1.71 | 1.7199 | 1.6361 | 1.6361 | 2788.0 |
| 2024-10-30 | AAMI | Stock | 26.38 | 26.77 | 26.35 | 26.37 | 152765.0 |
| 2024-10-30 | AAOI | Stock | 15.29 | 16.49 | 15.0 | 16.35 | 2284294.0 |
| 2024-10-30 | AAON | Stock | 118.15 | 119.08 | 114.58 | 115.11 | 308280.0 |
| 2024-10-30 | AAP | Stock | 36.08 | 37.105 | 35.77 | 35.95 | 2692272.0 |
| 2024-10-30 | AAT | Stock | 27.87 | 28.44 | 27.57 | 27.79 | 244965.0 |
| 2024-10-30 | AATC | Stock | 7.52 | 7.55 | 7.43 | 7.43 | 15700.0 |
| 2024-10-30 | AAUAF-DELISTED | Stock | 0.051 | 0.0528 | 0.051 | 0.051 | 101013.0 |
| 2024-10-30 | AAXJ | Stock | 76.27 | 76.68 | 76.14 | 76.29 | 338173.0 |
| 2024-10-30 | AB | Stock | 37.65 | 37.9389 | 37.16 | 37.29 | 163472.0 |
| 2024-10-30 | ABAT | Stock | 1.01 | 1.01 | 1.0 | 1.0 | 227478.0 |
| 2024-10-30 | ABBV | Stock | 191.62 | 202.3499 | 188.545 | 201.5 | 9815313.0 |
| 2024-10-30 | ABCB | Stock | 62.21 | 64.175 | 62.21 | 63.01 | 238698.0 |
| 2024-10-30 | ABCL | Stock | 2.83 | 2.89 | 2.78 | 2.78 | 1229793.0 |
| 2024-10-30 | ABEO | Stock | 6.49 | 6.64 | 6.29 | 6.36 | 243107.0 |
| 2024-10-30 | ABEV | Stock | 2.27 | 2.28 | 2.24 | 2.27 | 16601800.0 |
| 2024-10-30 | ABG | Stock | 228.02 | 237.72 | 228.02 | 233.03 | 147954.0 |
| 2024-10-30 | ABLLW | Stock | 1.47 | 1.5299 | 1.38 | 1.42 | 256141.0 |
| 2024-10-30 | ABLV | Stock | 0.9 | 0.92 | 0.845 | 0.9 | 16306.0 |
| 2024-10-30 | ABLVW | Stock | 0.011 | 0.02 | 0.011 | 0.012 | 3124.0 |
| 2024-10-30 | ABM | Stock | 53.57 | 54.26 | 53.57 | 53.68 | 294983.0 |
| 2024-10-30 | ABNB | Stock | 136.47 | 138.66 | 136.31 | 136.5 | 2951226.0 |
| 2024-10-30 | ABOS | Stock | 2.9 | 3.14 | 2.84 | 3.03 | 239926.0 |
| 2024-10-30 | ABR | Stock | 15.12 | 15.32 | 15.0534 | 15.07 | 1534179.0 |
| 2024-10-30 | ABR.D | Stock | 19.76 | 19.92 | 19.7236 | 19.86 | 8578.0 |
| 2024-10-30 | ABR.E | Stock | 20.0 | 20.0 | 19.64 | 19.64 | 1671.0 |
| 2024-10-30 | ABR.F | Stock | 20.49 | 20.54 | 20.2862 | 20.4836 | 17682.0 |
| 2024-10-30 | ABSI | Stock | 4.2 | 4.265 | 4.105 | 4.14 | 1526704.0 |
| 2024-10-30 | ABT | Stock | 112.64 | 114.735 | 112.5 | 114.45 | 4949654.0 |
| 2024-10-30 | ABTC | Stock | 56.775000000000006 | 59.58 | 51.0 | 51.75 | 10093.0 |
| 2024-10-30 | ABTS | Stock | 7.7085 | 8.64 | 7.7085 | 8.3025 | 11703.0 |
| 2024-10-30 | ABUS | Stock | 4.01 | 4.03 | 3.93 | 3.94 | 432201.0 |
| 2024-10-30 | ABVC | Stock | 0.714 | 0.77 | 0.695 | 0.72 | 260755.0 |
> showing 50 of 7,126 rows — these rows as CSV