PREVIEW / stock_daily / 2004-10-01
file: by_date/stock_daily/2004/2004-10-01.parquet size: 129 KB rows: 3,821 symbols: 2,378
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-01 | AAPL | Stock | 0.6986 | 0.6998 | 0.6889 | 0.6905 | 465404800.0 |
| 2004-10-01 | MSFT | Stock | 27.82 | 28.32 | 27.78 | 28.25 | 66302800.0 |
| 2004-10-01 | NVDA | Stock | 0.1216 | 0.1267 | 0.121 | 0.126 | 590412000.0 |
| 2004-10-01 | AMZN | Stock | 2.0645 | 2.065 | 2.0195 | 2.0235 | 225378000.0 |
| 2004-10-01 | CL | Stock | 22.6 | 22.875 | 22.55 | 22.56 | 10333200.0 |
| 2004-10-01 | A | Stock | 15.5222 | 16.4735 | 15.5222 | 16.4449 | 4416142.0 |
| 2004-10-01 | AABA-DELISTED | Stock | 34.3499984741211 | 35.1399993896484 | 34.1199989318848 | 35.0299987792969 | 22100300.0 |
| 2004-10-01 | AACC-DELISTED | Stock | 17.0 | 17.22 | 16.95 | 17.05 | 199050.0 |
| 2004-10-01 | AAI-DELISTED | Stock | 10.0 | 10.24 | 10.0 | 10.2 | 943500.0 |
| 2004-10-01 | AAIC-DELISTED | Stock | 382.0 | 388.4 | 378.6 | 386.0 | 1147500.0 |
| 2004-10-01 | AAME | Stock | 3.05 | 3.06 | 3.05 | 3.06 | 1300.0 |
| 2004-10-01 | AAON | Stock | 2.2821 | 2.3822 | 2.2821 | 2.3111 | 113906.0 |
| 2004-10-01 | AAP | Stock | 23.0 | 23.6267 | 22.9933 | 23.34 | 1937400.0 |
| 2004-10-01 | AAV-DELISTED | Stock | 17.08 | 17.15 | 16.95 | 17.08 | 16900.0 |
| 2004-10-01 | AAXN-DELISTED | Stock | 19.0450000762939 | 19.4400005340576 | 18.9050006866455 | 19.1100006103516 | 9455400.0 |
| 2004-10-01 | ABAX-DELISTED | Stock | 12.88 | 13.22 | 12.59 | 12.67 | 164511.0 |
| 2004-10-01 | ABB-DELISTED | Stock | 6.25 | 6.29 | 6.24 | 6.28 | 180400.0 |
| 2004-10-01 | ABC-DELISTED | Stock | 13.5 | 13.76 | 13.48 | 13.75 | 4751004.0 |
| 2004-10-01 | ABCB | Stock | 16.616 | 16.9888 | 16.3485 | 16.9807 | 17273.0 |
| 2004-10-01 | ABCO-DELISTED | Stock | 16.658 | 16.987 | 16.588 | 16.987 | 76026.0 |
| 2004-10-01 | ABCW-DELISTED | Stock | 25.74 | 26.24 | 25.74 | 25.99 | 108010.0 |
| 2004-10-01 | ABE-DELISTED | Stock | 7.97 | 8.24 | 7.97 | 8.23 | 31100.0 |
| 2004-10-01 | ABFS-DELISTED | Stock | 36.81 | 38.42 | 36.79 | 38.18 | 384076.0 |
| 2004-10-01 | ABG | Stock | 13.55 | 14.18 | 13.45 | 14.1 | 21500.0 |
| 2004-10-01 | ABK-DELISTED | Stock | 79.98 | 79.98 | 79.49 | 79.69 | 443200.0 |
| 2004-10-01 | ABM | Stock | 20.15 | 20.7 | 20.1 | 20.66 | 130100.0 |
| 2004-10-01 | ABMD-DELISTED | Stock | 9.17 | 9.34 | 8.96 | 9.32 | 123598.0 |
| 2004-10-01 | ABP-DELISTED | Stock | 2.08 | 2.18 | 1.95 | 2.02 | 266300.0 |
| 2004-10-01 | ABR | Stock | 22.35 | 22.86 | 22.35 | 22.86 | 87300.0 |
| 2004-10-01 | ABT | Stock | 20.3675 | 20.5642 | 20.214 | 20.2428 | 9799708.0 |
| 2004-10-01 | ABTL-DELISTED | Stock | 45.6 | 46.2 | 44.45 | 45.55 | 42500.0 |
| 2004-10-01 | ABV-DELISTED | Stock | 22.5 | 22.85 | 22.49 | 22.8 | 386000.0 |
| 2004-10-01 | ABVA-DELISTED | Stock | 15.18 | 15.2 | 15.18 | 15.18 | 2695.0 |
| 2004-10-01 | ABVT-DELISTED | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 900.0 |
| 2004-10-01 | ABX-DELISTED | Stock | 21.05 | 21.05 | 20.78 | 21.05 | 1539500.0 |
| 2004-10-01 | ACAD | Stock | 7.8 | 7.8 | 7.65 | 7.8 | 47000.0 |
| 2004-10-01 | ACAP-DELISTED | Stock | 31.17 | 32.0 | 31.17 | 31.68 | 76656.0 |
| 2004-10-01 | ACAS-DELISTED | Stock | 31.43 | 31.69 | 31.3 | 31.52 | 599399.0 |
| 2004-10-01 | ACAT-DELISTED | Stock | 25.54 | 26.32 | 25.54 | 26.0 | 67702.0 |
| 2004-10-01 | ACC-DELISTED | Stock | 18.62 | 18.9 | 18.5 | 18.9 | 79100.0 |
| 2004-10-01 | ACCL-DELISTED | Stock | 6.58 | 6.72 | 6.54 | 6.65 | 96563.0 |
| 2004-10-01 | ACE-DELISTED | Stock | 40.35 | 41.14 | 40.23 | 41.12 | 1619290.0 |
| 2004-10-01 | ACF-DELISTED | Stock | 20.95 | 21.44 | 20.73 | 20.99 | 1024500.0 |
| 2004-10-01 | ACG-DELISTED | Stock | 8.15 | 8.15 | 8.11 | 8.12 | 270500.0 |
| 2004-10-01 | ACGL | Stock | 4.3211 | 4.3444 | 4.2678 | 4.2833 | 1242000.0 |
| 2004-10-01 | ACGN-DELISTED | Stock | 714.0 | 748.0 | 691.3288 | 714.0 | 86200.0 |
| 2004-10-01 | ACH | Stock | 17.0667 | 17.4933 | 17.0533 | 17.38 | 208350.0 |
| 2004-10-01 | ACH-DELISTED | Stock | 17.0 | 17.185 | 16.788 | 16.875 | 698000.0 |
| 2004-10-01 | ACLS | Stock | 33.6 | 35.8 | 33.52 | 35.8 | 246850.0 |
| 2004-10-01 | ACO-DELISTED | Stock | 19.18 | 19.25 | 18.7 | 19.16 | 132000.0 |
> showing 50 of 3,821 rows — these rows as CSV