PREVIEW / stock_daily / 2024-09-24
file: by_date/stock_daily/2024/2024-09-24.parquet size: 247 KB rows: 7,139 symbols: 739
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-24 | AAPL | Stock | 228.645 | 229.35 | 225.73 | 227.37 | 41481700.0 |
| 2024-09-24 | MSFT | Stock | 433.0 | 433.35 | 426.1 | 429.17 | 16085839.0 |
| 2024-09-24 | NVDA | Stock | 116.515 | 121.8 | 115.38 | 120.87 | 349573550.0 |
| 2024-09-24 | AMZN | Stock | 194.27 | 195.37 | 190.13 | 193.96 | 42377480.0 |
| 2024-09-24 | GOOGL | Stock | 163.03 | 163.2158 | 160.69 | 162.29 | 23332147.0 |
| 2024-09-24 | META | Stock | 566.68 | 567.745 | 554.19 | 563.33 | 11746000.0 |
| 2024-09-24 | TSLA | Stock | 254.08 | 257.19 | 249.0501 | 254.27 | 87909087.0 |
| 2024-09-24 | TLT | Stock | 98.0 | 98.89 | 97.85 | 98.65 | 31005351.0 |
| 2024-09-24 | ES | Stock | 66.18 | 67.38 | 66.0 | 66.52 | 1963907.0 |
| 2024-09-24 | CL | Stock | 103.49 | 104.14 | 102.71 | 103.79 | 2821071.0 |
| 2024-09-24 | A | Stock | 140.1 | 143.27 | 139.31 | 141.87 | 1702204.0 |
| 2024-09-24 | AA | Stock | 36.5 | 37.375 | 36.2101 | 36.78 | 9723418.0 |
| 2024-09-24 | AACG | Stock | 0.625 | 0.7309 | 0.625 | 0.6796 | 99137.0 |
| 2024-09-24 | AACT | Stock | 10.81 | 10.82 | 10.8 | 10.81 | 47110.0 |
| 2024-09-24 | AAGR-DELISTED | Stock | 0.146 | 0.1489 | 0.142 | 0.1458 | 224344.0 |
| 2024-09-24 | AAGRW-DELISTED | Stock | 0.009 | 0.0091 | 0.0063 | 0.0063 | 12600.0 |
| 2024-09-24 | AAL | Stock | 11.02 | 11.19 | 10.92 | 11.04 | 29390556.0 |
| 2024-09-24 | AAM | Stock | 10.01 | 10.01 | 9.99 | 10.005 | 15351.0 |
| 2024-09-24 | AAME | Stock | 1.56 | 1.6799 | 1.5525 | 1.59 | 2811.0 |
| 2024-09-24 | AAMI | Stock | 25.68 | 25.95 | 25.51 | 25.89 | 137352.0 |
| 2024-09-24 | AAN-DELISTED | Stock | 10.05 | 10.06 | 10.04 | 10.06 | 1275493.0 |
| 2024-09-24 | AAOI | Stock | 14.36 | 16.99 | 14.3 | 15.98 | 5519912.0 |
| 2024-09-24 | AAON | Stock | 107.9 | 109.07 | 106.7451 | 107.39 | 605104.0 |
| 2024-09-24 | AAP | Stock | 40.6 | 41.26 | 40.25 | 40.91 | 1986223.0 |
| 2024-09-24 | AAT | Stock | 27.07 | 27.5 | 27.045 | 27.32 | 173278.0 |
| 2024-09-24 | AATC | Stock | 7.9 | 7.93 | 7.85 | 7.85 | 3473.0 |
| 2024-09-24 | AAUAF-DELISTED | Stock | 0.05745 | 0.06 | 0.046 | 0.05616 | 21725.0 |
| 2024-09-24 | AAXJ | Stock | 76.71 | 77.6 | 76.37 | 77.46 | 368132.0 |
| 2024-09-24 | AB | Stock | 34.66 | 35.06 | 34.58 | 34.9 | 157920.0 |
| 2024-09-24 | ABAT | Stock | 0.8675 | 0.9 | 0.85 | 0.8701 | 1521339.0 |
| 2024-09-24 | ABBV | Stock | 192.95 | 195.21 | 191.5872 | 193.51 | 4120386.0 |
| 2024-09-24 | ABCB | Stock | 63.73 | 63.875 | 62.25 | 62.34 | 306545.0 |
| 2024-09-24 | ABCL | Stock | 2.48 | 2.56 | 2.4601 | 2.52 | 1675493.0 |
| 2024-09-24 | ABEO | Stock | 5.94 | 5.94 | 5.69 | 5.76 | 180890.0 |
| 2024-09-24 | ABEV | Stock | 2.36 | 2.37 | 2.3201 | 2.33 | 26743302.0 |
| 2024-09-24 | ABG | Stock | 229.97 | 231.715 | 226.875 | 230.24 | 417494.0 |
| 2024-09-24 | ABLLW | Stock | 1.7 | 1.73 | 1.59 | 1.72 | 22568.0 |
| 2024-09-24 | ABLV | Stock | 1.0 | 1.0 | 0.91 | 0.91 | 2536.0 |
| 2024-09-24 | ABLVW | Stock | 0.0252 | 0.0252 | 0.02 | 0.02 | 217748.0 |
| 2024-09-24 | ABM | Stock | 51.35 | 51.46 | 49.745 | 50.27 | 1040842.0 |
| 2024-09-24 | ABNB | Stock | 130.58 | 131.67 | 129.59 | 131.48 | 4163839.0 |
| 2024-09-24 | ABOS | Stock | 2.39 | 2.49 | 2.37 | 2.44 | 85609.0 |
| 2024-09-24 | ABR | Stock | 15.24 | 15.59 | 15.21 | 15.5 | 2851524.0 |
| 2024-09-24 | ABR.D | Stock | 19.0217 | 19.1999 | 19.0002 | 19.15 | 15387.0 |
| 2024-09-24 | ABR.E | Stock | 19.25 | 19.5494 | 19.25 | 19.4 | 6170.0 |
| 2024-09-24 | ABR.F | Stock | 18.98 | 19.1 | 18.82 | 19.05 | 60432.0 |
| 2024-09-24 | ABSI | Stock | 4.06 | 4.06 | 3.8709 | 3.96 | 597068.0 |
| 2024-09-24 | ABT | Stock | 114.21 | 114.41 | 113.18 | 113.34 | 4804799.0 |
| 2024-09-24 | ABTC | Stock | 39.449999999999996 | 42.667500000000004 | 39.449999999999996 | 42.36 | 1528.5333333333333 |
| 2024-09-24 | ABTS | Stock | 7.5 | 7.575 | 7.5 | 7.5 | 177.0 |
> showing 50 of 7,139 rows — these rows as CSV