PREVIEW / stock_daily / 2024-07-23
file: by_date/stock_daily/2024/2024-07-23.parquet size: 246 KB rows: 7,234 symbols: 905
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-23 | AAPL | Stock | 224.365 | 226.94 | 222.68 | 225.01 | 37919040.0 |
| 2024-07-23 | MSFT | Stock | 443.895 | 448.39 | 443.1 | 444.85 | 12333947.0 |
| 2024-07-23 | NVDA | Stock | 122.78 | 124.69 | 122.1 | 122.59 | 172565369.0 |
| 2024-07-23 | AMZN | Stock | 184.1 | 189.39 | 183.56 | 186.41 | 47168048.0 |
| 2024-07-23 | GOOGL | Stock | 182.05 | 183.61 | 181.54 | 181.79 | 36352714.0 |
| 2024-07-23 | META | Stock | 489.84 | 495.22 | 487.72 | 488.69 | 9152972.0 |
| 2024-07-23 | TSLA | Stock | 253.6 | 255.7594 | 245.63 | 246.38 | 111696967.0 |
| 2024-07-23 | TLT | Stock | 92.81 | 93.03 | 92.49 | 92.52 | 23497988.0 |
| 2024-07-23 | ES | Stock | 61.83 | 62.0 | 60.74 | 60.82 | 1167230.0 |
| 2024-07-23 | CL | Stock | 98.15 | 98.175 | 96.36 | 96.55 | 3544241.0 |
| 2024-07-23 | A | Stock | 137.61 | 137.66 | 130.49 | 130.65 | 1612630.0 |
| 2024-07-23 | AA | Stock | 33.95 | 34.2761 | 33.57 | 33.9 | 11832317.0 |
| 2024-07-23 | AACG | Stock | 0.6531 | 0.6901 | 0.6531 | 0.674 | 10862.0 |
| 2024-07-23 | AACIW-DELISTED | Stock | 0.1369 | 0.137 | 0.111 | 0.137 | 104724.0 |
| 2024-07-23 | AACT | Stock | 10.7 | 10.72 | 10.7 | 10.715 | 5757.0 |
| 2024-07-23 | AAGR-DELISTED | Stock | 0.17 | 0.1749 | 0.1457 | 0.1629 | 8199563.0 |
| 2024-07-23 | AAGRW-DELISTED | Stock | 0.0092 | 0.0119 | 0.0092 | 0.0119 | 714.0 |
| 2024-07-23 | AAL | Stock | 10.63 | 10.74 | 10.47 | 10.48 | 30483017.0 |
| 2024-07-23 | AAMC-DELISTED | Stock | 2.78 | 2.78 | 2.44 | 2.5 | 3372.0 |
| 2024-07-23 | AAME | Stock | 1.63 | 1.63 | 1.6 | 1.6 | 1409.0 |
| 2024-07-23 | AAMI | Stock | 24.76 | 25.47 | 24.76 | 25.22 | 123425.0 |
| 2024-07-23 | AAN-DELISTED | Stock | 9.98 | 9.98 | 9.96 | 9.96 | 528808.0 |
| 2024-07-23 | AAOI | Stock | 9.62 | 10.26 | 9.58 | 9.85 | 1294549.0 |
| 2024-07-23 | AAON | Stock | 88.86 | 90.965 | 88.27 | 90.05 | 405091.0 |
| 2024-07-23 | AAP | Stock | 58.66 | 59.84 | 58.33 | 59.64 | 1234598.0 |
| 2024-07-23 | AAT | Stock | 24.45 | 25.03 | 24.285 | 24.89 | 187271.0 |
| 2024-07-23 | AATC | Stock | 6.74 | 6.815 | 6.74 | 6.815 | 976.0 |
| 2024-07-23 | AAUAF-DELISTED | Stock | 0.0501 | 0.06 | 0.05 | 0.05 | 73542.0 |
| 2024-07-23 | AAXJ | Stock | 71.98 | 71.98 | 71.665 | 71.78 | 437876.0 |
| 2024-07-23 | AB | Stock | 34.19 | 34.92 | 34.19 | 34.8 | 236373.0 |
| 2024-07-23 | ABAT | Stock | 1.01 | 1.03 | 1.0 | 1.02 | 442333.0 |
| 2024-07-23 | ABBV | Stock | 173.32 | 174.59 | 172.77 | 173.15 | 2867992.0 |
| 2024-07-23 | ABCB | Stock | 60.0 | 61.8 | 59.66 | 61.05 | 530415.0 |
| 2024-07-23 | ABCL | Stock | 3.0 | 3.125 | 2.975 | 3.1 | 1107505.0 |
| 2024-07-23 | ABEO | Stock | 4.96 | 5.15 | 4.9101 | 5.13 | 263896.0 |
| 2024-07-23 | ABEV | Stock | 2.13 | 2.14 | 2.11 | 2.12 | 7979093.0 |
| 2024-07-23 | ABG | Stock | 251.05 | 251.38 | 245.74 | 247.38 | 155467.0 |
| 2024-07-23 | ABLLW | Stock | 0.88 | 0.965 | 0.825 | 0.9012 | 635339.0 |
| 2024-07-23 | ABLV | Stock | 1.25 | 1.28 | 1.16 | 1.16 | 81002.0 |
| 2024-07-23 | ABM | Stock | 54.3 | 54.7 | 54.2 | 54.33 | 300826.0 |
| 2024-07-23 | ABNB | Stock | 150.56 | 151.25 | 147.83 | 148.75 | 2602023.0 |
| 2024-07-23 | ABOS | Stock | 3.26 | 3.55 | 3.24 | 3.54 | 607757.0 |
| 2024-07-23 | ABR | Stock | 13.39 | 13.54 | 13.21 | 13.29 | 3014496.0 |
| 2024-07-23 | ABR.D | Stock | 17.8 | 17.88 | 17.5 | 17.5 | 75146.0 |
| 2024-07-23 | ABR.E | Stock | 17.41 | 17.49 | 17.2701 | 17.44 | 12568.0 |
| 2024-07-23 | ABR.F | Stock | 18.57 | 18.7399 | 18.56 | 18.6 | 19918.0 |
| 2024-07-23 | ABSI | Stock | 4.05 | 4.54 | 4.04 | 4.45 | 1056091.0 |
| 2024-07-23 | ABT | Stock | 104.01 | 104.33 | 103.37 | 103.92 | 5289727.0 |
| 2024-07-23 | ABTC | Stock | 78.0 | 81.0 | 75.75 | 76.5 | 2647.5333333333333 |
| 2024-07-23 | ABTS | Stock | 6.885 | 7.35 | 6.798 | 7.0515 | 10664.0 |
> showing 50 of 7,234 rows — these rows as CSV