PREVIEW / stock_daily / 2024-07-19
file: by_date/stock_daily/2024/2024-07-19.parquet size: 243 KB rows: 7,103 symbols: 886
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-19 | AAPL | Stock | 224.82 | 226.8 | 223.275 | 224.31 | 48005407.0 |
| 2024-07-19 | MSFT | Stock | 433.1 | 441.14 | 432.0 | 437.11 | 20329762.0 |
| 2024-07-19 | NVDA | Stock | 120.35 | 121.6 | 117.37 | 117.93 | 211622962.0 |
| 2024-07-19 | AMZN | Stock | 181.14 | 184.93 | 180.11 | 183.13 | 42251690.0 |
| 2024-07-19 | GOOGL | Stock | 178.88 | 180.29 | 177.13 | 177.66 | 18881885.0 |
| 2024-07-19 | META | Stock | 476.06 | 486.71 | 475.71 | 476.79 | 14876155.0 |
| 2024-07-19 | TSLA | Stock | 247.79 | 249.01 | 236.83 | 239.2 | 86702102.0 |
| 2024-07-19 | TLT | Stock | 93.04 | 93.16 | 92.82 | 92.92 | 32164669.0 |
| 2024-07-19 | ES | Stock | 61.61 | 61.61 | 60.63 | 61.1 | 1642483.0 |
| 2024-07-19 | CL | Stock | 99.03 | 99.07 | 97.65 | 98.08 | 4049770.0 |
| 2024-07-19 | A | Stock | 131.96 | 132.78 | 130.29 | 131.78 | 1687883.0 |
| 2024-07-19 | AA | Stock | 35.26 | 35.26 | 34.55 | 34.92 | 5310240.0 |
| 2024-07-19 | AACG | Stock | 0.659 | 0.71 | 0.6507 | 0.6507 | 153860.0 |
| 2024-07-19 | AACIW-DELISTED | Stock | 0.1001 | 0.12 | 0.1001 | 0.12 | 4400.0 |
| 2024-07-19 | AACT | Stock | 10.75 | 10.75 | 10.7 | 10.7 | 10975.0 |
| 2024-07-19 | AAGR-DELISTED | Stock | 0.17 | 0.171 | 0.15294 | 0.1651 | 851251.0 |
| 2024-07-19 | AAL | Stock | 10.63 | 10.65 | 10.43 | 10.58 | 25097856.0 |
| 2024-07-19 | AAME | Stock | 1.6001 | 1.69 | 1.6001 | 1.63 | 970.0 |
| 2024-07-19 | AAMI | Stock | 24.69 | 24.94 | 24.53 | 24.75 | 134881.0 |
| 2024-07-19 | AAN-DELISTED | Stock | 9.95 | 9.96 | 9.94 | 9.94 | 634126.0 |
| 2024-07-19 | AAOI | Stock | 10.41 | 10.47 | 9.59 | 9.675 | 2009774.0 |
| 2024-07-19 | AAON | Stock | 87.68 | 87.68 | 86.34 | 86.94 | 561548.0 |
| 2024-07-19 | AAP | Stock | 61.2 | 61.35 | 59.35 | 59.62 | 1249217.0 |
| 2024-07-19 | AAT | Stock | 24.16 | 24.39 | 23.86 | 23.91 | 184763.0 |
| 2024-07-19 | AATC | Stock | 6.57 | 6.57 | 6.55 | 6.55 | 249.0 |
| 2024-07-19 | AAUAF-DELISTED | Stock | 0.051 | 0.0544 | 0.05 | 0.0544 | 12239.0 |
| 2024-07-19 | AAXJ | Stock | 72.38 | 72.485 | 71.905 | 71.97 | 1441538.0 |
| 2024-07-19 | AB | Stock | 33.61 | 34.027 | 33.51 | 33.82 | 251954.0 |
| 2024-07-19 | ABAT | Stock | 1.06 | 1.09 | 1.02 | 1.04 | 484916.0 |
| 2024-07-19 | ABBV | Stock | 173.67 | 173.845 | 171.22 | 172.32 | 4106598.0 |
| 2024-07-19 | ABCB | Stock | 59.05 | 59.59 | 58.44 | 58.62 | 275136.0 |
| 2024-07-19 | ABCL | Stock | 3.04 | 3.07 | 2.96 | 2.97 | 995725.0 |
| 2024-07-19 | ABEO | Stock | 5.06 | 5.26 | 5.03 | 5.11 | 249135.0 |
| 2024-07-19 | ABEV | Stock | 2.13 | 2.14 | 2.11 | 2.11 | 16084189.0 |
| 2024-07-19 | ABG | Stock | 250.93 | 251.54 | 244.38 | 245.86 | 159572.0 |
| 2024-07-19 | ABLLW | Stock | 0.71 | 0.9275 | 0.71 | 0.8 | 304384.0 |
| 2024-07-19 | ABLV | Stock | 1.45 | 1.45 | 1.09 | 1.1 | 19003.0 |
| 2024-07-19 | ABM | Stock | 53.7 | 54.09 | 53.541 | 53.59 | 394675.0 |
| 2024-07-19 | ABNB | Stock | 147.03 | 149.16 | 147.03 | 147.99 | 3074181.0 |
| 2024-07-19 | ABOS | Stock | 2.95 | 2.955 | 2.79 | 2.87 | 261926.0 |
| 2024-07-19 | ABR | Stock | 13.07 | 13.2199 | 12.97 | 13.11 | 2493071.0 |
| 2024-07-19 | ABR.D | Stock | 17.845 | 17.85 | 17.7299 | 17.75 | 5858.0 |
| 2024-07-19 | ABR.E | Stock | 17.2201 | 17.5 | 17.2201 | 17.5 | 1551.0 |
| 2024-07-19 | ABR.F | Stock | 18.45 | 18.67 | 18.45 | 18.56 | 9369.0 |
| 2024-07-19 | ABSI | Stock | 4.15 | 4.2 | 3.94 | 3.97 | 1490110.0 |
| 2024-07-19 | ABT | Stock | 100.61 | 102.4 | 100.08 | 102.03 | 11659884.0 |
| 2024-07-19 | ABTC | Stock | 79.5 | 84.0 | 78.78750000000001 | 81.0 | 2037.8666666666666 |
| 2024-07-19 | ABTS | Stock | 7.5 | 7.635 | 6.825 | 6.8265 | 844.0 |
| 2024-07-19 | ABUS | Stock | 3.7 | 3.735 | 3.625 | 3.69 | 552737.0 |
| 2024-07-19 | ABVC | Stock | 0.894 | 0.894 | 0.82 | 0.826 | 88494.0 |
> showing 50 of 7,103 rows — these rows as CSV