PREVIEW / stock_daily / 2024-09-30
file: by_date/stock_daily/2024/2024-09-30.parquet size: 245 KB rows: 7,150 symbols: 725
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-30 | AAPL | Stock | 230.04 | 233.0 | 229.65 | 233.0 | 51858049.0 |
| 2024-09-30 | MSFT | Stock | 428.21 | 430.42 | 425.37 | 430.3 | 15779054.0 |
| 2024-09-30 | NVDA | Stock | 118.31 | 121.5 | 118.15 | 121.44 | 222206866.0 |
| 2024-09-30 | AMZN | Stock | 187.14 | 188.49 | 184.65 | 186.33 | 40449148.0 |
| 2024-09-30 | GOOGL | Stock | 163.32 | 166.15 | 163.26 | 165.85 | 20481303.0 |
| 2024-09-30 | META | Stock | 567.7 | 574.68 | 564.8 | 572.44 | 12355016.0 |
| 2024-09-30 | TSLA | Stock | 259.04 | 264.86 | 255.77 | 261.63 | 80356292.0 |
| 2024-09-30 | TLT | Stock | 98.64 | 98.71 | 97.8839 | 98.1 | 34208260.0 |
| 2024-09-30 | ES | Stock | 67.44 | 68.165 | 67.44 | 68.05 | 1821257.0 |
| 2024-09-30 | CL | Stock | 104.1 | 104.16 | 103.45 | 103.81 | 4303447.0 |
| 2024-09-30 | A | Stock | 147.7 | 148.83 | 146.71 | 148.48 | 1321599.0 |
| 2024-09-30 | AA | Stock | 38.9 | 39.0304 | 38.27 | 38.58 | 3438147.0 |
| 2024-09-30 | AACG | Stock | 0.7302 | 0.7902 | 0.7302 | 0.7703 | 35362.0 |
| 2024-09-30 | AACT | Stock | 10.84 | 10.84 | 10.83 | 10.83 | 5799.0 |
| 2024-09-30 | AAGR-DELISTED | Stock | 0.014 | 0.029 | 0.013 | 0.024 | 2133951.0 |
| 2024-09-30 | AAGRW-DELISTED | Stock | 0.0031 | 0.0031 | 0.001 | 0.001 | 12526.0 |
| 2024-09-30 | AAL | Stock | 11.47 | 11.58 | 11.2 | 11.24 | 26455192.0 |
| 2024-09-30 | AAM | Stock | 10.02 | 10.02 | 10.01 | 10.02 | 191670.0 |
| 2024-09-30 | AAME | Stock | 1.78 | 1.79 | 1.66 | 1.7 | 11128.0 |
| 2024-09-30 | AAMI | Stock | 25.41 | 25.64 | 25.144 | 25.4 | 176047.0 |
| 2024-09-30 | AAN-DELISTED | Stock | 10.04 | 10.045 | 9.55 | 9.95 | 7165450.0 |
| 2024-09-30 | AAOI | Stock | 13.63 | 14.7 | 13.47 | 14.31 | 3393402.0 |
| 2024-09-30 | AAON | Stock | 106.91 | 109.46 | 106.4 | 107.84 | 498734.0 |
| 2024-09-30 | AAP | Stock | 41.0 | 41.18 | 38.89 | 38.99 | 3205338.0 |
| 2024-09-30 | AAT | Stock | 26.54 | 26.905 | 26.32 | 26.72 | 279975.0 |
| 2024-09-30 | AATC | Stock | 7.91 | 7.93 | 7.85 | 7.918 | 2256.0 |
| 2024-09-30 | AAUAF-DELISTED | Stock | 0.04525 | 0.054 | 0.04525 | 0.048 | 16984.0 |
| 2024-09-30 | AAXJ | Stock | 79.4 | 79.49 | 78.29 | 78.45 | 1208361.0 |
| 2024-09-30 | AB | Stock | 35.05 | 35.06 | 34.44 | 34.89 | 168389.0 |
| 2024-09-30 | ABAT | Stock | 0.98 | 1.09 | 0.95 | 1.07 | 1345225.0 |
| 2024-09-30 | ABBV | Stock | 194.85 | 197.62 | 194.3669 | 197.48 | 3573089.0 |
| 2024-09-30 | ABCB | Stock | 61.09 | 62.84 | 60.8294 | 62.39 | 327699.0 |
| 2024-09-30 | ABCL | Stock | 2.59 | 2.695 | 2.5845 | 2.6 | 1378281.0 |
| 2024-09-30 | ABEO | Stock | 5.89 | 6.4669 | 5.89 | 6.32 | 402442.0 |
| 2024-09-30 | ABEV | Stock | 2.39 | 2.44 | 2.385 | 2.44 | 37259485.0 |
| 2024-09-30 | ABG | Stock | 241.84 | 242.92 | 236.33 | 238.59 | 170910.0 |
| 2024-09-30 | ABLLW | Stock | 1.59 | 1.71 | 1.59 | 1.7 | 2133.0 |
| 2024-09-30 | ABLV | Stock | 1.25 | 1.25 | 0.86 | 0.95 | 52083.0 |
| 2024-09-30 | ABM | Stock | 51.45 | 52.94 | 51.44 | 52.76 | 533572.0 |
| 2024-09-30 | ABNB | Stock | 127.32 | 128.23 | 125.92 | 126.81 | 3776647.0 |
| 2024-09-30 | ABOS | Stock | 2.48 | 2.55 | 2.43 | 2.48 | 89496.0 |
| 2024-09-30 | ABR | Stock | 15.59 | 15.94 | 15.51 | 15.56 | 5213760.0 |
| 2024-09-30 | ABR.D | Stock | 19.4 | 19.55 | 19.2826 | 19.55 | 26655.0 |
| 2024-09-30 | ABR.E | Stock | 19.7 | 19.75 | 19.6 | 19.75 | 1230.0 |
| 2024-09-30 | ABR.F | Stock | 19.28 | 19.79 | 19.28 | 19.46 | 163679.0 |
| 2024-09-30 | ABSI | Stock | 3.94 | 4.015 | 3.75 | 3.82 | 523159.0 |
| 2024-09-30 | ABT | Stock | 112.57 | 114.09 | 112.1 | 114.01 | 4856425.0 |
| 2024-09-30 | ABTC | Stock | 53.4 | 53.625 | 47.25 | 51.105000000000004 | 2325.4 |
| 2024-09-30 | ABTS | Stock | 7.35 | 7.725 | 6.7815 | 7.0515 | 179.0 |
| 2024-09-30 | ABUS | Stock | 3.79 | 3.9 | 3.79 | 3.85 | 668859.0 |
> showing 50 of 7,150 rows — these rows as CSV