PREVIEW / stock_daily / 2002-01-07
file: by_date/stock_daily/2002/2002-01-07.parquet size: 105 KB rows: 3,066 symbols: 1,909
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-07 | AAPL | Stock | 0.4236 | 0.4286 | 0.4063 | 0.4089 | 444584000.0 |
| 2002-01-07 | MSFT | Stock | 34.875 | 35.01 | 34.175 | 34.28 | 58508800.0 |
| 2002-01-07 | NVDA | Stock | 0.5825 | 0.5833 | 0.5567 | 0.5646 | 973068000.0 |
| 2002-01-07 | AMZN | Stock | 0.604 | 0.6255 | 0.604 | 0.617 | 243658000.0 |
| 2002-01-07 | CL | Stock | 27.875 | 28.025 | 27.7 | 27.825 | 3746800.0 |
| 2002-01-07 | A | Stock | 23.3763 | 23.5265 | 23.0329 | 23.3548 | 5325262.0 |
| 2002-01-07 | AABA-DELISTED | Stock | 9.35000038146973 | 9.97000026702881 | 9.32499980926514 | 9.86499977111816 | 29516400.0 |
| 2002-01-07 | AAI-DELISTED | Stock | 6.7 | 6.95 | 6.65 | 6.82 | 253200.0 |
| 2002-01-07 | AAIC-DELISTED | Stock | 119.6 | 120.6 | 117.0 | 117.0 | 97000.0 |
| 2002-01-07 | AAME | Stock | 2.27 | 2.5 | 2.26 | 2.29 | 10100.0 |
| 2002-01-07 | AAON | Stock | 1.8226 | 1.848 | 1.8217 | 1.8427 | 107072.0 |
| 2002-01-07 | AAP | Stock | 14.1667 | 14.3667 | 13.2833 | 13.9333 | 601500.0 |
| 2002-01-07 | AAXN-DELISTED | Stock | 1.11333334445953 | 1.11333334445953 | 1.0900000333786 | 1.0900000333786 | 244800.0 |
| 2002-01-07 | ABAX-DELISTED | Stock | 5.61 | 5.75 | 5.5 | 5.73 | 29100.0 |
| 2002-01-07 | ABB-DELISTED | Stock | 10.8 | 10.95 | 10.7 | 10.7 | 17200.0 |
| 2002-01-07 | ABC-DELISTED | Stock | 15.1 | 15.21 | 14.49 | 14.52 | 8564400.0 |
| 2002-01-07 | ABCB | Stock | 11.1449 | 11.3475 | 10.8936 | 11.3475 | 4565.0 |
| 2002-01-07 | ABCO-DELISTED | Stock | 14.99 | 15.15 | 14.26 | 14.98 | 94800.0 |
| 2002-01-07 | ABCW-DELISTED | Stock | 17.65 | 17.92 | 17.55 | 17.74 | 87400.0 |
| 2002-01-07 | ABE-DELISTED | Stock | 7.19 | 7.25 | 7.18 | 7.24 | 9900.0 |
| 2002-01-07 | ABFS-DELISTED | Stock | 31.2 | 31.49 | 30.24 | 30.56 | 152000.0 |
| 2002-01-07 | ABK-DELISTED | Stock | 58.55 | 58.55 | 57.8 | 57.9 | 353300.0 |
| 2002-01-07 | ABM | Stock | 15.605 | 15.605 | 15.3 | 15.3 | 95400.0 |
| 2002-01-07 | ABMD-DELISTED | Stock | 16.2 | 16.63 | 15.75 | 15.82 | 151100.0 |
| 2002-01-07 | ABP-DELISTED | Stock | 1.5 | 1.7 | 1.45 | 1.7 | 155300.0 |
| 2002-01-07 | ABT | Stock | 25.0936 | 25.0936 | 24.6716 | 24.8691 | 4962565.0 |
| 2002-01-07 | ABTL-DELISTED | Stock | 9.1 | 10.0 | 8.55 | 9.0 | 28700.0 |
| 2002-01-07 | ABV-DELISTED | Stock | 21.49 | 21.6 | 21.3 | 21.46 | 197300.0 |
| 2002-01-07 | ABX-DELISTED | Stock | 16.66 | 17.05 | 16.66 | 16.88 | 2247037.0 |
| 2002-01-07 | ACAP-DELISTED | Stock | 21.32 | 21.48 | 21.11 | 21.11 | 20800.0 |
| 2002-01-07 | ACAS-DELISTED | Stock | 28.8 | 29.23 | 28.41 | 28.63 | 225900.0 |
| 2002-01-07 | ACAT-DELISTED | Stock | 17.6932 | 17.7 | 17.24 | 17.26 | 48305.0 |
| 2002-01-07 | ACCL-DELISTED | Stock | 10.4200000762939 | 10.6660003662109 | 10.0649995803833 | 10.0649995803833 | 287400.0 |
| 2002-01-07 | ACE-DELISTED | Stock | 38.85 | 38.85 | 38.0 | 38.1 | 944400.0 |
| 2002-01-07 | ACF-DELISTED | Stock | 30.95 | 31.4 | 29.25 | 29.61 | 2397400.0 |
| 2002-01-07 | ACG-DELISTED | Stock | 7.39 | 7.42 | 7.37 | 7.41 | 916700.0 |
| 2002-01-07 | ACGL | Stock | 3.0267 | 3.0556 | 2.9833 | 2.9978 | 43200.0 |
| 2002-01-07 | ACGN-DELISTED | Stock | 1870.0 | 2028.6712 | 1870.0 | 1983.3288 | 81900.0 |
| 2002-01-07 | ACH | Stock | 12.1333 | 12.3533 | 12.0067 | 12.1 | 439500.0 |
| 2002-01-07 | ACH-DELISTED | Stock | 5.0255 | 5.0255 | 4.838 | 4.988 | 1061502.0 |
| 2002-01-07 | ACLS | Stock | 62.64 | 64.32 | 60.76 | 60.96 | 296200.0 |
| 2002-01-07 | ACO-DELISTED | Stock | 7.06 | 7.23 | 7.0 | 7.1 | 28000.0 |
| 2002-01-07 | ACPW-DELISTED | Stock | 32.1 | 33.4 | 31.0 | 31.5 | 42660.0 |
| 2002-01-07 | ACS-DELISTED | Stock | 52.5 | 52.5 | 51.74 | 52.0 | 334000.0 |
| 2002-01-07 | ACTA-DELISTED | Stock | 30.0 | 31.6 | 26.4 | 26.6 | 322300.0 |
| 2002-01-07 | ACTT-DELISTED | Stock | 8.12 | 8.68 | 8.1 | 8.15 | 185100.0 |
| 2002-01-07 | ACTU-DELISTED | Stock | 5.72 | 5.88 | 5.53 | 5.65 | 1022200.0 |
| 2002-01-07 | ACXM-DELISTED | Stock | 18.62 | 18.62 | 18.05 | 18.21 | 837100.0 |
| 2002-01-07 | ACY-DELISTED | Stock | 4.95 | 4.95 | 4.9 | 4.9 | 2000.0 |
| 2002-01-07 | AD | Stock | 29.2667 | 29.4667 | 28.7333 | 28.7333 | 265350.0 |
> showing 50 of 3,066 rows — these rows as CSV