PREVIEW / stock_daily / 2024-09-25
file: by_date/stock_daily/2024/2024-09-25.parquet size: 245 KB rows: 7,120 symbols: 733
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-09-25 | AAPL | Stock | 224.93 | 227.29 | 224.02 | 226.37 | 39904420.0 |
| 2024-09-25 | MSFT | Stock | 429.83 | 433.119 | 428.57 | 432.11 | 12497484.0 |
| 2024-09-25 | NVDA | Stock | 122.02 | 124.94 | 121.61 | 123.51 | 279479269.0 |
| 2024-09-25 | AMZN | Stock | 193.75 | 193.9498 | 192.16 | 192.53 | 25066639.0 |
| 2024-09-25 | GOOGL | Stock | 161.47 | 162.81 | 161.3 | 161.49 | 18869199.0 |
| 2024-09-25 | META | Stock | 564.05 | 576.88 | 563.72 | 568.31 | 15953535.0 |
| 2024-09-25 | TSLA | Stock | 252.54 | 257.05 | 252.28 | 257.02 | 64685423.0 |
| 2024-09-25 | TLT | Stock | 98.26 | 98.32 | 97.79 | 97.83 | 36738236.0 |
| 2024-09-25 | ES | Stock | 66.84 | 66.88 | 65.98 | 66.13 | 1466532.0 |
| 2024-09-25 | CL | Stock | 104.14 | 104.49 | 103.45 | 103.75 | 2790115.0 |
| 2024-09-25 | A | Stock | 141.97 | 142.835 | 139.21 | 139.44 | 1391167.0 |
| 2024-09-25 | AA | Stock | 35.42 | 36.65 | 35.42 | 36.01 | 5319024.0 |
| 2024-09-25 | AACG | Stock | 0.6762 | 0.7769 | 0.652 | 0.7299 | 61928.0 |
| 2024-09-25 | AACT | Stock | 10.84 | 10.84 | 10.8 | 10.8 | 263068.0 |
| 2024-09-25 | AAGR-DELISTED | Stock | 0.1431 | 0.1463 | 0.1313 | 0.1326 | 3565953.0 |
| 2024-09-25 | AAGRW-DELISTED | Stock | 0.009 | 0.0091 | 0.0055 | 0.0058 | 51710.0 |
| 2024-09-25 | AAL | Stock | 11.06 | 11.175 | 10.97 | 11.0 | 28945430.0 |
| 2024-09-25 | AAM | Stock | 10.01 | 10.01 | 9.99 | 9.995 | 250636.0 |
| 2024-09-25 | AAME | Stock | 1.67 | 1.78 | 1.56 | 1.56 | 5451.0 |
| 2024-09-25 | AAMI | Stock | 25.8 | 25.85 | 25.51 | 25.67 | 115930.0 |
| 2024-09-25 | AAN-DELISTED | Stock | 10.06 | 10.06 | 10.03 | 10.03 | 1475641.0 |
| 2024-09-25 | AAOI | Stock | 16.0 | 16.1 | 15.15 | 15.38 | 2117083.0 |
| 2024-09-25 | AAON | Stock | 107.57 | 108.53 | 106.65 | 107.3 | 253639.0 |
| 2024-09-25 | AAP | Stock | 40.96 | 40.96 | 39.17 | 39.6 | 2132912.0 |
| 2024-09-25 | AAT | Stock | 27.26 | 27.31 | 26.99 | 27.04 | 168369.0 |
| 2024-09-25 | AATC | Stock | 7.97 | 7.97 | 7.78 | 7.81 | 3103.0 |
| 2024-09-25 | AAUAF-DELISTED | Stock | 0.0495 | 0.06 | 0.0495 | 0.0552 | 27214.0 |
| 2024-09-25 | AAXJ | Stock | 76.84 | 76.99 | 76.435 | 76.47 | 470752.0 |
| 2024-09-25 | AB | Stock | 35.03 | 35.11 | 34.71 | 34.78 | 202444.0 |
| 2024-09-25 | ABAT | Stock | 0.875 | 0.88 | 0.8 | 0.81 | 1579971.0 |
| 2024-09-25 | ABBV | Stock | 194.0 | 194.57 | 190.96 | 191.26 | 4684965.0 |
| 2024-09-25 | ABCB | Stock | 62.46 | 62.46 | 60.95 | 61.24 | 287786.0 |
| 2024-09-25 | ABCL | Stock | 2.51 | 2.535 | 2.43 | 2.44 | 1442725.0 |
| 2024-09-25 | ABEO | Stock | 5.76 | 6.05 | 5.76 | 5.93 | 301749.0 |
| 2024-09-25 | ABEV | Stock | 2.36 | 2.38 | 2.31 | 2.33 | 28399917.0 |
| 2024-09-25 | ABG | Stock | 236.02 | 239.03 | 231.29 | 231.7 | 423824.0 |
| 2024-09-25 | ABLLW | Stock | 1.72 | 1.87 | 1.66 | 1.77 | 43682.0 |
| 2024-09-25 | ABLV | Stock | 0.8554 | 0.99 | 0.84 | 0.84005 | 16915.0 |
| 2024-09-25 | ABM | Stock | 50.47 | 50.86 | 49.9 | 50.75 | 840391.0 |
| 2024-09-25 | ABNB | Stock | 131.31 | 131.9 | 130.3 | 130.71 | 2268365.0 |
| 2024-09-25 | ABOS | Stock | 2.41 | 2.4268 | 2.33 | 2.34 | 98908.0 |
| 2024-09-25 | ABR | Stock | 15.51 | 15.54 | 15.22 | 15.23 | 1762882.0 |
| 2024-09-25 | ABR.D | Stock | 19.11 | 19.25 | 19.11 | 19.2098 | 9514.0 |
| 2024-09-25 | ABR.E | Stock | 19.31 | 19.62 | 19.12 | 19.45 | 5720.0 |
| 2024-09-25 | ABR.F | Stock | 19.09 | 19.25 | 19.0632 | 19.19 | 44765.0 |
| 2024-09-25 | ABSI | Stock | 3.95 | 3.99 | 3.83 | 3.88 | 728836.0 |
| 2024-09-25 | ABT | Stock | 113.82 | 114.19 | 111.85 | 112.61 | 5038882.0 |
| 2024-09-25 | ABTC | Stock | 42.66 | 42.66 | 41.25 | 41.6325 | 493.59999999999997 |
| 2024-09-25 | ABTS | Stock | 7.4985 | 7.7925 | 7.4985 | 7.5 | 294.0 |
| 2024-09-25 | ABUS | Stock | 4.01 | 4.025 | 3.89 | 3.91 | 782407.0 |
> showing 50 of 7,120 rows — these rows as CSV