PREVIEW / stock_daily / 2024-07-09
file: by_date/stock_daily/2024/2024-07-09.parquet size: 245 KB rows: 7,186 symbols: 916
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-07-09 | AAPL | Stock | 227.93 | 229.4 | 226.3721 | 228.68 | 47576851.0 |
| 2024-07-09 | MSFT | Stock | 467.0 | 467.33 | 458.0 | 459.54 | 16916480.0 |
| 2024-07-09 | NVDA | Stock | 130.35 | 133.82 | 128.65 | 131.38 | 281896722.0 |
| 2024-07-09 | AMZN | Stock | 199.4 | 200.57 | 199.045 | 199.34 | 30687346.0 |
| 2024-07-09 | GOOGL | Stock | 190.31 | 191.36 | 188.72 | 188.98 | 15141312.0 |
| 2024-07-09 | META | Stock | 533.75 | 537.48 | 528.1901 | 530.0 | 8667009.0 |
| 2024-07-09 | TSLA | Stock | 251.0 | 265.61 | 250.3 | 262.33 | 159971884.0 |
| 2024-07-09 | TLT | Stock | 92.47 | 92.675 | 91.87 | 92.35 | 30304136.0 |
| 2024-07-09 | ES | Stock | 57.24 | 57.91 | 56.88 | 57.84 | 1834054.0 |
| 2024-07-09 | CL | Stock | 97.53 | 97.64 | 96.49 | 97.04 | 2871796.0 |
| 2024-07-09 | A | Stock | 126.24 | 126.24 | 124.16 | 125.42 | 1491616.0 |
| 2024-07-09 | AA | Stock | 41.52 | 42.0896 | 40.3 | 40.33 | 2906790.0 |
| 2024-07-09 | AACG | Stock | 0.83 | 0.84 | 0.8247 | 0.8373 | 3228.0 |
| 2024-07-09 | AACIW-DELISTED | Stock | 0.1287 | 0.1287 | 0.1287 | 0.1287 | 125.0 |
| 2024-07-09 | AACT | Stock | 10.685 | 10.685 | 10.68 | 10.685 | 6925.0 |
| 2024-07-09 | AAGR-DELISTED | Stock | 0.1697 | 0.1747 | 0.162 | 0.1666 | 598346.0 |
| 2024-07-09 | AAL | Stock | 10.96 | 11.09 | 10.87 | 10.98 | 26489018.0 |
| 2024-07-09 | AAMC-DELISTED | Stock | 2.14 | 2.14 | 2.1 | 2.1 | 3806.0 |
| 2024-07-09 | AAME | Stock | 1.52 | 1.63 | 1.52 | 1.56 | 5957.0 |
| 2024-07-09 | AAMI | Stock | 22.61 | 22.65 | 22.05 | 22.06 | 155475.0 |
| 2024-07-09 | AAN-DELISTED | Stock | 9.98 | 10.0 | 9.97 | 9.98 | 691471.0 |
| 2024-07-09 | AAOI | Stock | 8.5 | 8.97 | 8.175 | 8.49 | 2004044.0 |
| 2024-07-09 | AAON | Stock | 85.9 | 86.44 | 83.43 | 83.98 | 560073.0 |
| 2024-07-09 | AAP | Stock | 59.04 | 59.13 | 57.83 | 57.91 | 1218760.0 |
| 2024-07-09 | AAT | Stock | 21.87 | 22.085 | 21.82 | 22.04 | 272537.0 |
| 2024-07-09 | AATC | Stock | 6.35 | 6.35 | 6.25 | 6.31 | 2171.0 |
| 2024-07-09 | AAUAF-DELISTED | Stock | 0.06 | 0.06 | 0.0537 | 0.0537 | 76863.0 |
| 2024-07-09 | AAXJ | Stock | 73.85 | 74.08 | 73.75 | 74.01 | 151644.0 |
| 2024-07-09 | AB | Stock | 33.68 | 34.22 | 33.62 | 34.01 | 336444.0 |
| 2024-07-09 | ABAT | Stock | 1.18 | 1.1899 | 1.09 | 1.12 | 559981.0 |
| 2024-07-09 | ABBV | Stock | 167.02 | 168.53 | 164.86 | 168.05 | 3536645.0 |
| 2024-07-09 | ABCB | Stock | 48.63 | 51.25 | 48.2118 | 50.87 | 531512.0 |
| 2024-07-09 | ABCL | Stock | 2.8 | 2.87 | 2.65 | 2.82 | 4644650.0 |
| 2024-07-09 | ABEO | Stock | 4.79 | 5.1942 | 4.79 | 5.0 | 639082.0 |
| 2024-07-09 | ABEV | Stock | 2.07 | 2.09 | 2.06 | 2.08 | 10866179.0 |
| 2024-07-09 | ABG | Stock | 225.12 | 226.305 | 222.35 | 222.6 | 202561.0 |
| 2024-07-09 | ABLLW | Stock | 0.6 | 0.63 | 0.4601 | 0.6 | 49369.0 |
| 2024-07-09 | ABLV | Stock | 1.13 | 1.13 | 1.13 | 1.13 | 1431.0 |
| 2024-07-09 | ABM | Stock | 49.39 | 49.62 | 48.88 | 48.97 | 661018.0 |
| 2024-07-09 | ABNB | Stock | 152.92 | 155.66 | 151.965 | 152.45 | 4310928.0 |
| 2024-07-09 | ABOS | Stock | 2.31 | 2.35 | 2.255 | 2.27 | 260042.0 |
| 2024-07-09 | ABR | Stock | 14.89 | 15.02 | 14.76 | 14.85 | 1976095.0 |
| 2024-07-09 | ABR.D | Stock | 19.345 | 19.41 | 19.2 | 19.37 | 10497.0 |
| 2024-07-09 | ABR.E | Stock | 18.79 | 18.79 | 18.77 | 18.77 | 1313.0 |
| 2024-07-09 | ABR.F | Stock | 20.06 | 20.35 | 20.0 | 20.0 | 10658.0 |
| 2024-07-09 | ABSI | Stock | 3.33 | 3.68 | 3.2622 | 3.64 | 2163204.0 |
| 2024-07-09 | ABT | Stock | 102.39 | 102.59 | 100.75 | 101.64 | 6127743.0 |
| 2024-07-09 | ABTC | Stock | 83.25 | 86.25 | 81.0 | 83.25 | 2231.2666666666664 |
| 2024-07-09 | ABTS | Stock | 6.7515 | 6.8625 | 6.7515 | 6.8625 | 204.0 |
| 2024-07-09 | ABUS | Stock | 3.24 | 3.41 | 3.24 | 3.4 | 1012125.0 |
> showing 50 of 7,186 rows — these rows as CSV