PREVIEW / stock_daily / 2024-07-18
file: by_date/stock_daily/2024/2024-07-18.parquet size: 248 KB rows: 7,216 symbols: 911
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-18 | AAPL | Stock | 230.28 | 230.44 | 222.27 | 224.18 | 64260988.0 |
| 2024-07-18 | MSFT | Stock | 444.34 | 444.65 | 434.4 | 440.37 | 20098803.0 |
| 2024-07-18 | NVDA | Stock | 121.85 | 122.4 | 116.56 | 121.09 | 316706686.0 |
| 2024-07-18 | AMZN | Stock | 189.59 | 189.68 | 181.448 | 183.75 | 51232355.0 |
| 2024-07-18 | GOOGL | Stock | 181.93 | 182.5 | 176.47 | 177.69 | 25315727.0 |
| 2024-07-18 | META | Stock | 475.0 | 479.2393 | 464.54 | 475.85 | 18816223.0 |
| 2024-07-18 | TSLA | Stock | 251.09 | 257.14 | 247.2 | 249.23 | 110234989.0 |
| 2024-07-18 | TLT | Stock | 93.68 | 94.14 | 93.38 | 93.47 | 34553075.0 |
| 2024-07-18 | ES | Stock | 61.12 | 62.38 | 61.02 | 61.39 | 1657659.0 |
| 2024-07-18 | CL | Stock | 99.22 | 99.62 | 98.38 | 98.51 | 3210454.0 |
| 2024-07-18 | A | Stock | 132.32 | 135.21 | 131.66 | 131.97 | 2756210.0 |
| 2024-07-18 | AA | Stock | 36.7 | 38.22 | 35.39 | 35.65 | 8880547.0 |
| 2024-07-18 | AACG | Stock | 0.6 | 0.6586 | 0.6 | 0.6451 | 76234.0 |
| 2024-07-18 | AACT | Stock | 10.7 | 10.72 | 10.7 | 10.72 | 63184.0 |
| 2024-07-18 | AAGR-DELISTED | Stock | 0.1819 | 0.1819 | 0.1712 | 0.1715 | 313983.0 |
| 2024-07-18 | AAGRW-DELISTED | Stock | 0.01 | 0.0101 | 0.0091 | 0.01 | 16720.0 |
| 2024-07-18 | AAL | Stock | 10.96 | 11.09 | 10.61 | 10.62 | 45966907.0 |
| 2024-07-18 | AAMC-DELISTED | Stock | 2.2401 | 2.5 | 2.2401 | 2.5 | 751.0 |
| 2024-07-18 | AAME | Stock | 1.72 | 1.77 | 1.62 | 1.6898 | 8745.0 |
| 2024-07-18 | AAMI | Stock | 24.83 | 25.29 | 24.515 | 24.65 | 166867.0 |
| 2024-07-18 | AAN-DELISTED | Stock | 9.98 | 9.98 | 9.94 | 9.95 | 981334.0 |
| 2024-07-18 | AAOI | Stock | 11.07 | 11.55 | 10.24 | 10.4 | 2815128.0 |
| 2024-07-18 | AAON | Stock | 88.37 | 89.4564 | 85.37 | 87.35 | 661197.0 |
| 2024-07-18 | AAP | Stock | 63.93 | 64.84 | 61.214 | 61.26 | 1291313.0 |
| 2024-07-18 | AAT | Stock | 24.36 | 24.9 | 23.995 | 24.17 | 214480.0 |
| 2024-07-18 | AATC | Stock | 6.65 | 6.88 | 6.5 | 6.55 | 18415.0 |
| 2024-07-18 | AAUAF-DELISTED | Stock | 0.05 | 0.0533 | 0.05 | 0.05 | 15863.0 |
| 2024-07-18 | AAXJ | Stock | 73.58 | 73.64 | 72.595 | 72.74 | 1742516.0 |
| 2024-07-18 | AB | Stock | 33.74 | 34.01 | 33.58 | 33.6 | 238116.0 |
| 2024-07-18 | ABAT | Stock | 1.08 | 1.12 | 1.07 | 1.09 | 253129.0 |
| 2024-07-18 | ABBV | Stock | 174.445 | 176.68 | 170.72 | 171.14 | 5867648.0 |
| 2024-07-18 | ABCB | Stock | 58.9 | 60.11 | 57.33 | 58.91 | 488391.0 |
| 2024-07-18 | ABCL | Stock | 3.39 | 3.4 | 3.04 | 3.06 | 1333998.0 |
| 2024-07-18 | ABEO | Stock | 5.41 | 5.54 | 4.81 | 5.04 | 1096185.0 |
| 2024-07-18 | ABEV | Stock | 2.15 | 2.16 | 2.09 | 2.1 | 24448990.0 |
| 2024-07-18 | ABG | Stock | 254.0 | 258.685 | 250.47 | 250.91 | 158158.0 |
| 2024-07-18 | ABLLW | Stock | 0.6701 | 0.67069 | 0.67 | 0.67069 | 1053.0 |
| 2024-07-18 | ABLV | Stock | 1.36 | 1.43 | 1.11 | 1.14 | 8058.0 |
| 2024-07-18 | ABM | Stock | 53.3 | 54.37 | 53.27 | 53.76 | 456074.0 |
| 2024-07-18 | ABNB | Stock | 148.17 | 150.145 | 146.75 | 146.88 | 3555977.0 |
| 2024-07-18 | ABOS | Stock | 3.09 | 3.17 | 2.905 | 2.93 | 267040.0 |
| 2024-07-18 | ABR | Stock | 13.4 | 13.54 | 12.87 | 13.05 | 3666047.0 |
| 2024-07-18 | ABR.D | Stock | 17.9 | 18.0134 | 17.35 | 17.76 | 45824.0 |
| 2024-07-18 | ABR.E | Stock | 17.5 | 17.6 | 17.11 | 17.4 | 19607.0 |
| 2024-07-18 | ABR.F | Stock | 18.91 | 18.91 | 18.1657 | 18.56 | 33089.0 |
| 2024-07-18 | ABSI | Stock | 4.4 | 4.505 | 4.005 | 4.11 | 2245065.0 |
| 2024-07-18 | ABT | Stock | 102.39 | 104.145 | 99.71 | 100.07 | 12888754.0 |
| 2024-07-18 | ABTC | Stock | 81.0 | 82.5 | 78.75 | 81.75 | 2615.0 |
| 2024-07-18 | ABTS | Stock | 7.65 | 7.875 | 7.65 | 7.656 | 336.0 |
| 2024-07-18 | ABUS | Stock | 3.76 | 3.845 | 3.645 | 3.69 | 822983.0 |
> showing 50 of 7,216 rows — these rows as CSV