PREVIEW / stock_daily / 2024-09-16
file: by_date/stock_daily/2024/2024-09-16.parquet size: 244 KB rows: 7,151 symbols: 761
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-16 | AAPL | Stock | 216.54 | 217.22 | 213.92 | 216.32 | 58226184.0 |
| 2024-09-16 | MSFT | Stock | 430.6 | 433.53 | 428.22 | 431.34 | 13094513.0 |
| 2024-09-16 | NVDA | Stock | 116.79 | 118.18 | 114.36 | 116.78 | 242824092.0 |
| 2024-09-16 | AMZN | Stock | 185.29 | 185.81 | 183.36 | 184.89 | 25146789.0 |
| 2024-09-16 | GOOGL | Stock | 157.31 | 158.25 | 156.6 | 158.06 | 18379775.0 |
| 2024-09-16 | META | Stock | 524.54 | 534.1 | 517.4 | 533.28 | 9191667.0 |
| 2024-09-16 | TSLA | Stock | 229.3 | 229.96 | 223.53 | 226.78 | 53861170.0 |
| 2024-09-16 | TLT | Stock | 100.63 | 101.37 | 100.41 | 101.33 | 30866261.0 |
| 2024-09-16 | ES | Stock | 68.3 | 68.73 | 68.03 | 68.4 | 1814743.0 |
| 2024-09-16 | CL | Stock | 105.18 | 105.92 | 105.14 | 105.43 | 4011137.0 |
| 2024-09-16 | A | Stock | 138.28 | 139.78 | 137.495 | 138.31 | 859780.0 |
| 2024-09-16 | AA | Stock | 34.26 | 35.6 | 33.64 | 34.5 | 10669274.0 |
| 2024-09-16 | AACG | Stock | 0.53 | 0.53 | 0.5013 | 0.5025 | 25032.0 |
| 2024-09-16 | AACT | Stock | 10.79 | 10.81 | 10.79 | 10.8 | 35074.0 |
| 2024-09-16 | AAGR-DELISTED | Stock | 0.1287 | 0.132 | 0.1257 | 0.1287 | 35430.0 |
| 2024-09-16 | AAGRW-DELISTED | Stock | 0.0086 | 0.0092 | 0.0086 | 0.0086 | 14755.0 |
| 2024-09-16 | AAL | Stock | 10.649 | 10.87 | 10.62 | 10.81 | 30902716.0 |
| 2024-09-16 | AAM | Stock | 9.98 | 9.98 | 9.96 | 9.98 | 929248.0 |
| 2024-09-16 | AAMC-DELISTED | Stock | 1.33 | 1.338 | 1.2103 | 1.25 | 20176.0 |
| 2024-09-16 | AAME | Stock | 1.68 | 1.69 | 1.66 | 1.69 | 2611.0 |
| 2024-09-16 | AAMI | Stock | 24.63 | 25.09 | 24.5 | 25.03 | 113023.0 |
| 2024-09-16 | AAN-DELISTED | Stock | 10.06 | 10.06 | 10.045 | 10.06 | 572517.0 |
| 2024-09-16 | AAOI | Stock | 14.67 | 14.71 | 13.16 | 13.19 | 2937728.0 |
| 2024-09-16 | AAON | Stock | 94.51 | 96.61 | 94.0 | 96.16 | 284485.0 |
| 2024-09-16 | AAP | Stock | 41.8 | 41.98 | 40.365 | 41.14 | 2467171.0 |
| 2024-09-16 | AAT | Stock | 26.77 | 27.06 | 26.56 | 26.86 | 200504.0 |
| 2024-09-16 | AATC | Stock | 7.54 | 7.6 | 7.5 | 7.5208 | 9651.0 |
| 2024-09-16 | AAUAF-DELISTED | Stock | 0.04 | 0.052 | 0.04 | 0.052 | 70147.0 |
| 2024-09-16 | AAXJ | Stock | 72.43 | 72.5 | 72.125 | 72.42 | 89450.0 |
| 2024-09-16 | AB | Stock | 34.12 | 34.65 | 34.11 | 34.52 | 184557.0 |
| 2024-09-16 | ABAT | Stock | 0.9745 | 1.04 | 0.9745 | 0.9992 | 391393.0 |
| 2024-09-16 | ABBV | Stock | 195.82 | 196.16 | 194.46 | 195.73 | 3116248.0 |
| 2024-09-16 | ABCB | Stock | 61.29 | 62.58 | 60.325 | 61.63 | 250071.0 |
| 2024-09-16 | ABCL | Stock | 2.75 | 2.77 | 2.5909 | 2.68 | 2440226.0 |
| 2024-09-16 | ABEO | Stock | 5.59 | 5.69 | 5.32 | 5.33 | 167332.0 |
| 2024-09-16 | ABEV | Stock | 2.32 | 2.3499 | 2.31 | 2.33 | 20167679.0 |
| 2024-09-16 | ABG | Stock | 223.88 | 224.655 | 219.67 | 219.81 | 125686.0 |
| 2024-09-16 | ABLLW | Stock | 1.4499 | 1.4499 | 1.39 | 1.39 | 5487.0 |
| 2024-09-16 | ABLV | Stock | 1.08 | 1.22 | 1.08 | 1.15 | 5359.0 |
| 2024-09-16 | ABLVW | Stock | 0.0327 | 0.0327 | 0.02 | 0.02 | 36853.0 |
| 2024-09-16 | ABM | Stock | 51.91 | 53.06 | 51.57 | 51.99 | 463877.0 |
| 2024-09-16 | ABNB | Stock | 117.99 | 118.3 | 116.16 | 117.55 | 3191031.0 |
| 2024-09-16 | ABOS | Stock | 2.62 | 2.65 | 2.52 | 2.54 | 119992.0 |
| 2024-09-16 | ABR | Stock | 14.5 | 14.64 | 14.4201 | 14.56 | 2189005.0 |
| 2024-09-16 | ABR.D | Stock | 19.1 | 19.1 | 18.82 | 18.9 | 29540.0 |
| 2024-09-16 | ABR.E | Stock | 19.01 | 19.2 | 19.01 | 19.2 | 6495.0 |
| 2024-09-16 | ABR.F | Stock | 19.42 | 19.45 | 19.16 | 19.28 | 31706.0 |
| 2024-09-16 | ABSI | Stock | 3.91 | 3.91 | 3.74 | 3.85 | 765324.0 |
| 2024-09-16 | ABT | Stock | 117.0 | 117.68 | 116.42 | 117.63 | 3173061.0 |
| 2024-09-16 | ABTC | Stock | 38.4975 | 40.5 | 38.4 | 39.225 | 1495.3333333333333 |
> showing 50 of 7,151 rows — these rows as CSV