PREVIEW / stock_daily / 2024-10-04
file: by_date/stock_daily/2024/2024-10-04.parquet size: 244 KB rows: 7,086 symbols: 690
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-04 | AAPL | Stock | 227.9 | 228.0 | 224.13 | 226.8 | 35599242.0 |
| 2024-10-04 | MSFT | Stock | 418.24 | 419.75 | 414.97 | 416.06 | 17300652.0 |
| 2024-10-04 | NVDA | Stock | 124.94 | 125.04 | 121.83 | 124.92 | 242564740.0 |
| 2024-10-04 | AMZN | Stock | 185.75 | 187.6 | 183.6 | 186.51 | 38190495.0 |
| 2024-10-04 | GOOGL | Stock | 168.06 | 168.23 | 165.48 | 167.06 | 19093724.0 |
| 2024-10-04 | META | Stock | 583.73 | 596.85 | 581.43 | 595.94 | 14067783.0 |
| 2024-10-04 | TSLA | Stock | 246.69 | 250.96 | 244.58 | 250.08 | 85513926.0 |
| 2024-10-04 | TLT | Stock | 95.44 | 95.96 | 95.4 | 95.55 | 56970281.0 |
| 2024-10-04 | ES | Stock | 65.07 | 65.59 | 64.68 | 65.38 | 1563689.0 |
| 2024-10-04 | CL | Stock | 99.25 | 99.85 | 98.44 | 99.04 | 5981322.0 |
| 2024-10-04 | A | Stock | 146.2 | 146.56 | 144.2 | 144.97 | 986437.0 |
| 2024-10-04 | AA | Stock | 39.0 | 39.62 | 38.64 | 39.12 | 4141186.0 |
| 2024-10-04 | AACG | Stock | 0.92 | 0.92 | 0.8325 | 0.855 | 25062.0 |
| 2024-10-04 | AACT | Stock | 10.82 | 10.835 | 10.82 | 10.835 | 24842.0 |
| 2024-10-04 | AAGR-DELISTED | Stock | 0.04734 | 0.055 | 0.0331 | 0.0336 | 206364.0 |
| 2024-10-04 | AAGRW-DELISTED | Stock | 0.0012 | 0.0012 | 0.001 | 0.001 | 42376.0 |
| 2024-10-04 | AAL | Stock | 11.3602 | 11.97 | 11.29 | 11.51 | 53638322.0 |
| 2024-10-04 | AAM | Stock | 10.02 | 10.02 | 10.015 | 10.015 | 51210.0 |
| 2024-10-04 | AAME | Stock | 1.625 | 1.65 | 1.625 | 1.625 | 1951.0 |
| 2024-10-04 | AAMI | Stock | 23.18 | 23.71 | 23.015 | 23.69 | 236354.0 |
| 2024-10-04 | AAOI | Stock | 14.55 | 15.73 | 14.3 | 15.36 | 2481200.0 |
| 2024-10-04 | AAON | Stock | 108.63 | 109.0 | 106.8001 | 107.705 | 210419.0 |
| 2024-10-04 | AAP | Stock | 39.4 | 39.85 | 37.05 | 38.69 | 5117429.0 |
| 2024-10-04 | AAT | Stock | 26.23 | 26.52 | 26.09 | 26.47 | 179006.0 |
| 2024-10-04 | AATC | Stock | 7.61 | 7.75 | 7.61 | 7.67 | 2477.0 |
| 2024-10-04 | AAUAF-DELISTED | Stock | 0.0498 | 0.0498 | 0.046 | 0.049 | 22061.0 |
| 2024-10-04 | AAXJ | Stock | 80.85 | 81.105 | 80.47 | 81.05 | 751792.0 |
| 2024-10-04 | AB | Stock | 35.0 | 35.3328 | 34.66 | 34.71 | 178080.0 |
| 2024-10-04 | ABAT | Stock | 1.0 | 1.04 | 0.9724 | 1.03 | 637348.0 |
| 2024-10-04 | ABBV | Stock | 195.1 | 195.64 | 193.045 | 194.29 | 4680345.0 |
| 2024-10-04 | ABCB | Stock | 61.96 | 62.16 | 61.14 | 61.71 | 212369.0 |
| 2024-10-04 | ABCL | Stock | 2.51 | 2.5499 | 2.445 | 2.5 | 1077372.0 |
| 2024-10-04 | ABEO | Stock | 6.42 | 6.6 | 6.42 | 6.46 | 184583.0 |
| 2024-10-04 | ABEV | Stock | 2.44 | 2.49 | 2.44 | 2.47 | 43086222.0 |
| 2024-10-04 | ABG | Stock | 229.16 | 232.43 | 228.46 | 231.82 | 134824.0 |
| 2024-10-04 | ABLLW | Stock | 1.57 | 1.6 | 1.43 | 1.6 | 3836.0 |
| 2024-10-04 | ABLV | Stock | 0.88 | 0.9488 | 0.88 | 0.908 | 13842.0 |
| 2024-10-04 | ABM | Stock | 51.74 | 51.99 | 51.155 | 51.3 | 255037.0 |
| 2024-10-04 | ABNB | Stock | 128.42 | 129.93 | 127.27 | 129.85 | 2965426.0 |
| 2024-10-04 | ABOS | Stock | 2.42 | 2.42 | 2.31 | 2.37 | 175042.0 |
| 2024-10-04 | ABR | Stock | 15.27 | 15.33 | 14.96 | 14.98 | 1883928.0 |
| 2024-10-04 | ABR.D | Stock | 19.6 | 19.77 | 19.56 | 19.77 | 16783.0 |
| 2024-10-04 | ABR.E | Stock | 20.04 | 20.04 | 20.04 | 20.04 | 454.0 |
| 2024-10-04 | ABR.F | Stock | 19.5 | 19.64 | 19.5 | 19.56 | 23692.0 |
| 2024-10-04 | ABSI | Stock | 3.9 | 4.01 | 3.85 | 3.88 | 831621.0 |
| 2024-10-04 | ABT | Stock | 112.13 | 112.75 | 111.68 | 112.64 | 4270153.0 |
| 2024-10-04 | ABTC | Stock | 45.0 | 45.0 | 40.215 | 43.5075 | 3128.2 |
| 2024-10-04 | ABTS | Stock | 7.032 | 7.05 | 6.9 | 7.05 | 428.0 |
| 2024-10-04 | ABUS | Stock | 3.91 | 3.92 | 3.81 | 3.84 | 629096.0 |
| 2024-10-04 | ABVC | Stock | 0.64 | 0.655 | 0.605 | 0.62 | 75946.0 |
> showing 50 of 7,086 rows — these rows as CSV