PREVIEW / stock_daily / 2024-10-02
file: by_date/stock_daily/2024/2024-10-02.parquet size: 244 KB rows: 7,044 symbols: 687
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-10-02 | AAPL | Stock | 225.89 | 227.37 | 223.02 | 226.78 | 31868517.0 |
| 2024-10-02 | MSFT | Stock | 422.58 | 422.82 | 416.71 | 417.13 | 16002251.0 |
| 2024-10-02 | NVDA | Stock | 116.44 | 119.38 | 115.14 | 118.85 | 219093907.0 |
| 2024-10-02 | AMZN | Stock | 184.44 | 186.6 | 184.04 | 184.76 | 22798787.0 |
| 2024-10-02 | GOOGL | Stock | 166.42 | 167.52 | 164.73 | 165.86 | 17760179.0 |
| 2024-10-02 | META | Stock | 574.86 | 576.0 | 569.34 | 572.81 | 6366778.0 |
| 2024-10-02 | TSLA | Stock | 247.55 | 251.1585 | 241.5 | 249.02 | 93524733.0 |
| 2024-10-02 | TLT | Stock | 97.36 | 97.73 | 97.06 | 97.66 | 35810763.0 |
| 2024-10-02 | ES | Stock | 67.17 | 67.97 | 66.14 | 66.68 | 2658615.0 |
| 2024-10-02 | CL | Stock | 102.06 | 102.36 | 101.59 | 102.06 | 4056343.0 |
| 2024-10-02 | A | Stock | 146.27 | 147.65 | 145.11 | 146.54 | 1173471.0 |
| 2024-10-02 | AA | Stock | 39.41 | 39.97 | 38.845 | 39.17 | 2891445.0 |
| 2024-10-02 | AACG | Stock | 0.8495 | 0.9 | 0.8004 | 0.8955 | 57658.0 |
| 2024-10-02 | AACT | Stock | 10.84 | 10.84 | 10.8201 | 10.825 | 2532.0 |
| 2024-10-02 | AAGR-DELISTED | Stock | 0.0176 | 0.024 | 0.0175 | 0.024 | 125301.0 |
| 2024-10-02 | AAGRW-DELISTED | Stock | 0.002 | 0.0049 | 0.0007 | 0.0007 | 263469.0 |
| 2024-10-02 | AAL | Stock | 10.73 | 10.86 | 10.605 | 10.74 | 28727922.0 |
| 2024-10-02 | AAM | Stock | 10.02 | 10.03 | 10.01 | 10.01 | 1112075.0 |
| 2024-10-02 | AAME | Stock | 1.68 | 1.68 | 1.61 | 1.65 | 1183.0 |
| 2024-10-02 | AAMI | Stock | 24.17 | 24.63 | 23.645 | 23.9 | 192661.0 |
| 2024-10-02 | AAN-DELISTED | Stock | 9.95 | 10.02 | 9.925 | 9.99 | 517269.0 |
| 2024-10-02 | AAOI | Stock | 13.25 | 13.78 | 12.42 | 13.75 | 2083210.0 |
| 2024-10-02 | AAON | Stock | 105.8 | 107.9 | 105.44 | 107.32 | 216634.0 |
| 2024-10-02 | AAP | Stock | 37.81 | 38.32 | 37.0775 | 37.17 | 2478569.0 |
| 2024-10-02 | AAT | Stock | 26.25 | 26.32 | 25.96 | 26.17 | 150692.0 |
| 2024-10-02 | AATC | Stock | 7.71 | 7.71 | 7.61 | 7.65 | 6625.0 |
| 2024-10-02 | AAUAF-DELISTED | Stock | 0.0504 | 0.06 | 0.046 | 0.051 | 7062.0 |
| 2024-10-02 | AAXJ | Stock | 80.87 | 81.24 | 80.29 | 81.24 | 854239.0 |
| 2024-10-02 | AB | Stock | 34.6 | 34.915 | 34.5 | 34.77 | 86137.0 |
| 2024-10-02 | ABAT | Stock | 1.01 | 1.03 | 0.9744 | 1.03 | 241259.0 |
| 2024-10-02 | ABBV | Stock | 195.66 | 197.0 | 194.45 | 196.82 | 2823361.0 |
| 2024-10-02 | ABCB | Stock | 59.8 | 61.06 | 59.66 | 60.0 | 398318.0 |
| 2024-10-02 | ABCL | Stock | 2.55 | 2.58 | 2.45 | 2.48 | 1610454.0 |
| 2024-10-02 | ABEO | Stock | 6.45 | 6.45 | 6.06 | 6.23 | 302273.0 |
| 2024-10-02 | ABEV | Stock | 2.54 | 2.56 | 2.52 | 2.56 | 84386007.0 |
| 2024-10-02 | ABG | Stock | 231.52 | 233.14 | 228.48 | 228.65 | 109918.0 |
| 2024-10-02 | ABLLW | Stock | 1.68 | 1.69 | 1.5 | 1.51 | 17022.0 |
| 2024-10-02 | ABLV | Stock | 0.91 | 0.938 | 0.89 | 0.926 | 13133.0 |
| 2024-10-02 | ABM | Stock | 51.45 | 51.98 | 51.2 | 51.55 | 270272.0 |
| 2024-10-02 | ABNB | Stock | 125.33 | 126.44 | 124.55 | 126.18 | 2680716.0 |
| 2024-10-02 | ABOS | Stock | 2.44 | 2.52 | 2.35 | 2.5 | 306026.0 |
| 2024-10-02 | ABR | Stock | 15.5 | 15.535 | 14.99 | 15.04 | 2597884.0 |
| 2024-10-02 | ABR.D | Stock | 19.55 | 19.64 | 19.3901 | 19.51 | 27963.0 |
| 2024-10-02 | ABR.E | Stock | 19.8 | 20.505 | 19.76 | 19.98 | 4443.0 |
| 2024-10-02 | ABR.F | Stock | 19.6 | 19.63 | 19.34 | 19.4 | 45279.0 |
| 2024-10-02 | ABSI | Stock | 3.75 | 3.805 | 3.62 | 3.8 | 881616.0 |
| 2024-10-02 | ABT | Stock | 113.375 | 113.79 | 112.03 | 113.64 | 3248119.0 |
| 2024-10-02 | ABTC | Stock | 48.75 | 48.75 | 45.75 | 46.5075 | 779.0 |
| 2024-10-02 | ABTS | Stock | 6.9 | 7.485 | 6.693 | 7.05 | 1912.0 |
| 2024-10-02 | ABUS | Stock | 3.79 | 3.91 | 3.75 | 3.9 | 924531.0 |
> showing 50 of 7,044 rows — these rows as CSV