PREVIEW / stock_daily / 2024-09-23
file: by_date/stock_daily/2024/2024-09-23.parquet size: 244 KB rows: 7,099 symbols: 723
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-23 | AAPL | Stock | 227.34 | 229.45 | 225.81 | 226.47 | 50776109.0 |
| 2024-09-23 | MSFT | Stock | 434.28 | 436.46 | 430.3889 | 433.51 | 14496579.0 |
| 2024-09-23 | NVDA | Stock | 116.55 | 116.99 | 114.86 | 116.26 | 203385406.0 |
| 2024-09-23 | AMZN | Stock | 191.64 | 194.45 | 190.57 | 193.88 | 35860570.0 |
| 2024-09-23 | GOOGL | Stock | 164.35 | 165.49 | 161.67 | 161.85 | 24150852.0 |
| 2024-09-23 | META | Stock | 569.5 | 573.9799 | 562.41 | 564.41 | 11972522.0 |
| 2024-09-23 | TSLA | Stock | 242.61 | 250.0 | 241.92 | 250.0 | 86056290.0 |
| 2024-09-23 | TLT | Stock | 98.5 | 99.09 | 98.02 | 98.67 | 35703932.0 |
| 2024-09-23 | ES | Stock | 66.93 | 66.96 | 66.325 | 66.53 | 2018427.0 |
| 2024-09-23 | CL | Stock | 102.68 | 104.155 | 102.475 | 103.31 | 3743449.0 |
| 2024-09-23 | A | Stock | 141.15 | 141.15 | 138.6007 | 139.79 | 1947685.0 |
| 2024-09-23 | AA | Stock | 34.13 | 34.45 | 33.78 | 34.23 | 4128625.0 |
| 2024-09-23 | AACG | Stock | 0.527 | 0.65 | 0.527 | 0.63241 | 191292.0 |
| 2024-09-23 | AACT | Stock | 10.84 | 10.84 | 10.8 | 10.8 | 47752.0 |
| 2024-09-23 | AAGR-DELISTED | Stock | 0.1501 | 0.1597 | 0.1456 | 0.1495 | 620431.0 |
| 2024-09-23 | AAGRW-DELISTED | Stock | 0.0065 | 0.0091 | 0.0065 | 0.0065 | 5096.0 |
| 2024-09-23 | AAL | Stock | 11.0 | 11.03 | 10.76 | 10.98 | 30692318.0 |
| 2024-09-23 | AAM | Stock | 9.99 | 10.0 | 9.99 | 9.99 | 159709.0 |
| 2024-09-23 | AAME | Stock | 1.43 | 1.6 | 1.43 | 1.58 | 8395.0 |
| 2024-09-23 | AAMI | Stock | 25.74 | 25.945 | 25.5 | 25.53 | 124951.0 |
| 2024-09-23 | AAN-DELISTED | Stock | 10.07 | 10.07 | 10.04 | 10.06 | 1163264.0 |
| 2024-09-23 | AAOI | Stock | 14.02 | 14.718 | 13.81 | 14.06 | 1764386.0 |
| 2024-09-23 | AAON | Stock | 104.59 | 108.02 | 103.6 | 107.82 | 520774.0 |
| 2024-09-23 | AAP | Stock | 41.01 | 41.0542 | 39.96 | 40.57 | 1875564.0 |
| 2024-09-23 | AAT | Stock | 27.15 | 27.35 | 26.98 | 27.12 | 224174.0 |
| 2024-09-23 | AATC | Stock | 7.815 | 7.905 | 7.79 | 7.9 | 5864.0 |
| 2024-09-23 | AAUAF-DELISTED | Stock | 0.036 | 0.0579 | 0.036 | 0.05645 | 31958.0 |
| 2024-09-23 | AAXJ | Stock | 74.46 | 74.88 | 74.37 | 74.69 | 243622.0 |
| 2024-09-23 | AB | Stock | 35.0 | 35.14 | 34.57 | 34.75 | 319884.0 |
| 2024-09-23 | ABAT | Stock | 1.01 | 1.01 | 0.85 | 0.8902 | 4251157.0 |
| 2024-09-23 | ABBV | Stock | 193.7 | 194.3 | 192.2 | 193.83 | 3099604.0 |
| 2024-09-23 | ABCB | Stock | 64.26 | 64.56 | 63.26 | 63.71 | 382906.0 |
| 2024-09-23 | ABCL | Stock | 2.62 | 2.625 | 2.48 | 2.48 | 1577671.0 |
| 2024-09-23 | ABEO | Stock | 6.03 | 6.18 | 5.8 | 5.86 | 309798.0 |
| 2024-09-23 | ABEV | Stock | 2.31 | 2.32 | 2.29 | 2.31 | 14533755.0 |
| 2024-09-23 | ABG | Stock | 226.78 | 229.37 | 224.75 | 227.95 | 199406.0 |
| 2024-09-23 | ABLLW | Stock | 1.57 | 1.7 | 1.535 | 1.69 | 48141.0 |
| 2024-09-23 | ABLV | Stock | 0.94 | 0.94 | 0.9162 | 0.9162 | 86169.0 |
| 2024-09-23 | ABM | Stock | 52.6 | 52.88 | 51.08 | 51.1 | 774175.0 |
| 2024-09-23 | ABNB | Stock | 131.5 | 131.64 | 128.9 | 129.03 | 3643519.0 |
| 2024-09-23 | ABOS | Stock | 2.51 | 2.51 | 2.36 | 2.37 | 153589.0 |
| 2024-09-23 | ABR | Stock | 15.0 | 15.195 | 14.9136 | 15.19 | 2137048.0 |
| 2024-09-23 | ABR.D | Stock | 19.31 | 19.31 | 19.0 | 19.0 | 23980.0 |
| 2024-09-23 | ABR.E | Stock | 19.55 | 19.55 | 19.25 | 19.25 | 2455.0 |
| 2024-09-23 | ABR.F | Stock | 19.05 | 19.23 | 18.94 | 18.95 | 62898.0 |
| 2024-09-23 | ABSI | Stock | 4.32 | 4.36 | 3.98 | 4.03 | 851341.0 |
| 2024-09-23 | ABT | Stock | 113.79 | 114.9 | 112.96 | 114.81 | 4294094.0 |
| 2024-09-23 | ABTC | Stock | 38.85 | 41.4615 | 38.2575 | 40.6725 | 2059.5333333333333 |
| 2024-09-23 | ABTS | Stock | 7.2 | 7.8 | 7.2 | 7.35 | 785.0 |
| 2024-09-23 | ABUS | Stock | 4.05 | 4.105 | 4.0 | 4.04 | 1498703.0 |
> showing 50 of 7,099 rows — these rows as CSV