PREVIEW / stock_daily / 2024-09-19
file: by_date/stock_daily/2024/2024-09-19.parquet size: 246 KB rows: 7,155 symbols: 741
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-19 | AAPL | Stock | 224.99 | 229.82 | 224.63 | 228.87 | 64947702.0 |
| 2024-09-19 | MSFT | Stock | 441.225 | 441.5 | 436.9 | 438.69 | 20456853.0 |
| 2024-09-19 | NVDA | Stock | 117.35 | 119.66 | 117.25 | 117.87 | 290315159.0 |
| 2024-09-19 | AMZN | Stock | 190.04 | 190.99 | 188.47 | 189.87 | 38107723.0 |
| 2024-09-19 | GOOGL | Stock | 163.71 | 163.79 | 161.34 | 162.14 | 26587733.0 |
| 2024-09-19 | META | Stock | 550.0 | 562.07 | 546.52 | 559.1 | 15330619.0 |
| 2024-09-19 | TSLA | Stock | 234.0 | 244.24 | 232.13 | 243.92 | 101332534.0 |
| 2024-09-19 | TLT | Stock | 98.92 | 99.31 | 98.77 | 99.26 | 39979816.0 |
| 2024-09-19 | ES | Stock | 67.06 | 67.385 | 66.47 | 67.2 | 2299845.0 |
| 2024-09-19 | CL | Stock | 103.1 | 103.1 | 101.89 | 102.01 | 4830549.0 |
| 2024-09-19 | A | Stock | 141.85 | 143.44 | 141.455 | 141.95 | 1202293.0 |
| 2024-09-19 | AA | Stock | 35.4 | 35.76 | 34.8 | 34.92 | 6369939.0 |
| 2024-09-19 | AACG | Stock | 0.53 | 0.5454 | 0.51 | 0.53 | 60815.0 |
| 2024-09-19 | AACT | Stock | 10.82 | 10.82 | 10.8 | 10.815 | 338041.0 |
| 2024-09-19 | AAGR-DELISTED | Stock | 0.158 | 0.175 | 0.1375 | 0.158 | 6855195.0 |
| 2024-09-19 | AAGRW-DELISTED | Stock | 0.0069 | 0.0099 | 0.0069 | 0.0071 | 247109.0 |
| 2024-09-19 | AAL | Stock | 11.32 | 11.39 | 11.06 | 11.11 | 34370224.0 |
| 2024-09-19 | AAM | Stock | 9.99 | 9.99 | 9.98 | 9.98 | 319188.0 |
| 2024-09-19 | AAME | Stock | 1.635 | 1.635 | 1.635 | 1.635 | 1127.0 |
| 2024-09-19 | AAMI | Stock | 25.74 | 25.83 | 25.14 | 25.83 | 219982.0 |
| 2024-09-19 | AAN-DELISTED | Stock | 10.07 | 10.07 | 10.03 | 10.04 | 1052805.0 |
| 2024-09-19 | AAOI | Stock | 14.09 | 14.39 | 13.64 | 14.2 | 1797969.0 |
| 2024-09-19 | AAON | Stock | 99.35 | 102.75 | 98.885 | 102.45 | 559659.0 |
| 2024-09-19 | AAP | Stock | 43.05 | 43.39 | 41.88 | 42.43 | 1832515.0 |
| 2024-09-19 | AAT | Stock | 27.51 | 27.79 | 26.855 | 27.37 | 375483.0 |
| 2024-09-19 | AATC | Stock | 7.8725 | 7.89 | 7.79 | 7.8 | 1926.0 |
| 2024-09-19 | AAUAF-DELISTED | Stock | 0.0521 | 0.0565 | 0.0521 | 0.0565 | 43121.0 |
| 2024-09-19 | AAXJ | Stock | 73.54 | 74.07 | 73.22 | 73.92 | 333807.0 |
| 2024-09-19 | AB | Stock | 34.98 | 35.3 | 34.83 | 35.15 | 272943.0 |
| 2024-09-19 | ABAT | Stock | 1.0 | 1.01549 | 0.99 | 1.01 | 237085.0 |
| 2024-09-19 | ABBV | Stock | 193.425 | 194.16 | 191.96 | 193.62 | 3771240.0 |
| 2024-09-19 | ABCB | Stock | 64.3 | 65.4 | 63.13 | 65.14 | 565986.0 |
| 2024-09-19 | ABCL | Stock | 2.81 | 2.855 | 2.725 | 2.74 | 1473352.0 |
| 2024-09-19 | ABEO | Stock | 5.59 | 5.97 | 5.57 | 5.8 | 516826.0 |
| 2024-09-19 | ABEV | Stock | 2.43 | 2.43 | 2.37 | 2.39 | 28603548.0 |
| 2024-09-19 | ABG | Stock | 226.86 | 227.57 | 221.925 | 227.34 | 219133.0 |
| 2024-09-19 | ABLLW | Stock | 1.46 | 1.57 | 1.41 | 1.45 | 995324.0 |
| 2024-09-19 | ABLV | Stock | 1.02 | 1.02 | 0.907 | 0.93 | 25586.0 |
| 2024-09-19 | ABM | Stock | 51.73 | 52.11 | 50.75 | 51.83 | 638576.0 |
| 2024-09-19 | ABNB | Stock | 127.93 | 131.35 | 127.44 | 128.75 | 7654639.0 |
| 2024-09-19 | ABOS | Stock | 2.55 | 2.66 | 2.5 | 2.58 | 217181.0 |
| 2024-09-19 | ABR | Stock | 15.3 | 15.3 | 15.06 | 15.16 | 3196919.0 |
| 2024-09-19 | ABR.D | Stock | 19.27 | 19.7191 | 19.24 | 19.48 | 36670.0 |
| 2024-09-19 | ABR.E | Stock | 19.3325 | 19.8 | 19.3325 | 19.4501 | 6886.0 |
| 2024-09-19 | ABR.F | Stock | 19.5 | 19.66 | 19.405 | 19.56 | 21320.0 |
| 2024-09-19 | ABSI | Stock | 4.1 | 4.32 | 4.0399 | 4.31 | 1231135.0 |
| 2024-09-19 | ABT | Stock | 115.49 | 115.66 | 113.25 | 114.15 | 7779154.0 |
| 2024-09-19 | ABTC | Stock | 41.1 | 44.2425 | 37.635 | 39.404999999999994 | 6169.8 |
| 2024-09-19 | ABTS | Stock | 7.935 | 8.1 | 7.725 | 7.833 | 417.0 |
| 2024-09-19 | ABUS | Stock | 4.21 | 4.24 | 4.105 | 4.14 | 710317.0 |
> showing 50 of 7,155 rows — these rows as CSV