PREVIEW / stock_daily / 2002-08-12
file: by_date/stock_daily/2002/2002-08-12.parquet size: 106 KB rows: 3,147 symbols: 1,952
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-08-12 | AAPL | Stock | 0.2661 | 0.2682 | 0.2623 | 0.2677 | 179765600.0 |
| 2002-08-12 | MSFT | Stock | 23.805 | 24.375 | 23.8 | 24.235 | 56866600.0 |
| 2002-08-12 | NVDA | Stock | 0.0758 | 0.0796 | 0.0738 | 0.0767 | 592800000.0 |
| 2002-08-12 | AMZN | Stock | 0.707 | 0.7245 | 0.6975 | 0.723 | 70066000.0 |
| 2002-08-12 | CL | Stock | 26.75 | 26.975 | 26.605 | 26.855 | 2191200.0 |
| 2002-08-12 | A | Stock | 11.6595 | 11.9313 | 11.4449 | 11.774 | 1577224.0 |
| 2002-08-12 | AABA-DELISTED | Stock | 5.84000015258789 | 5.98999977111816 | 5.74499988555908 | 5.9850001335144 | 9145000.0 |
| 2002-08-12 | AAI-DELISTED | Stock | 3.88 | 3.88 | 3.57 | 3.6 | 134200.0 |
| 2002-08-12 | AAIC-DELISTED | Stock | 197.4 | 200.0 | 194.2 | 198.2 | 76900.0 |
| 2002-08-12 | AAME | Stock | 1.77 | 2.0 | 1.77 | 2.0 | 4300.0 |
| 2002-08-12 | AAON | Stock | 2.1202 | 2.2255 | 2.1202 | 2.2058 | 59991.0 |
| 2002-08-12 | AAP | Stock | 16.1833 | 16.2967 | 15.9 | 16.2667 | 1080300.0 |
| 2002-08-12 | AAXN-DELISTED | Stock | 0.57833331823349 | 0.60916668176651 | 0.5625 | 0.608333349227905 | 346800.0 |
| 2002-08-12 | ABAX-DELISTED | Stock | 3.18 | 3.32 | 3.18 | 3.32 | 16000.0 |
| 2002-08-12 | ABB-DELISTED | Stock | 4.55 | 4.55 | 4.4 | 4.45 | 19200.0 |
| 2002-08-12 | ABC-DELISTED | Stock | 17.2 | 17.2 | 17.0 | 17.08 | 2811200.0 |
| 2002-08-12 | ABCB | Stock | 11.4123 | 11.7122 | 11.1043 | 11.6312 | 11967.0 |
| 2002-08-12 | ABCO-DELISTED | Stock | 16.66 | 16.85 | 16.41 | 16.41 | 27800.0 |
| 2002-08-12 | ABCW-DELISTED | Stock | 21.15 | 21.58 | 20.85 | 21.37 | 15600.0 |
| 2002-08-12 | ABE-DELISTED | Stock | 6.25 | 6.25 | 6.06 | 6.06 | 7200.0 |
| 2002-08-12 | ABFS-DELISTED | Stock | 20.9 | 21.1 | 20.45 | 21.02 | 162400.0 |
| 2002-08-12 | ABG | Stock | 10.1 | 10.3 | 9.52 | 9.62 | 54700.0 |
| 2002-08-12 | ABK-DELISTED | Stock | 61.25 | 61.63 | 60.53 | 61.51 | 438800.0 |
| 2002-08-12 | ABM | Stock | 16.25 | 16.6 | 16.25 | 16.56 | 42800.0 |
| 2002-08-12 | ABMD-DELISTED | Stock | 5.75 | 5.93 | 5.51 | 5.93 | 22700.0 |
| 2002-08-12 | ABP-DELISTED | Stock | 0.46 | 0.57 | 0.41 | 0.56 | 55800.0 |
| 2002-08-12 | ABT | Stock | 18.1042 | 18.3825 | 17.8528 | 18.2882 | 6061695.0 |
| 2002-08-12 | ABTL-DELISTED | Stock | 12.25 | 12.4 | 10.95 | 12.25 | 10900.0 |
| 2002-08-12 | ABV-DELISTED | Stock | 14.5 | 14.55 | 14.25 | 14.44 | 977900.0 |
| 2002-08-12 | ABVA-DELISTED | Stock | 8.8 | 8.8 | 8.8 | 8.8 | 800.0 |
| 2002-08-12 | ABX-DELISTED | Stock | 16.4 | 16.4 | 15.71 | 15.82 | 2267800.0 |
| 2002-08-12 | ACAP-DELISTED | Stock | 16.68 | 18.14 | 16.54 | 18.09 | 62000.0 |
| 2002-08-12 | ACAS-DELISTED | Stock | 25.15 | 25.64 | 25.09 | 25.39 | 589048.0 |
| 2002-08-12 | ACAT-DELISTED | Stock | 15.19 | 15.74 | 15.1 | 15.499 | 3300.0 |
| 2002-08-12 | ACCL-DELISTED | Stock | 4.59812021255493 | 4.65605020523071 | 4.59812021255493 | 4.65605020523071 | 143100.0 |
| 2002-08-12 | ACE-DELISTED | Stock | 31.1 | 32.59 | 31.1 | 32.25 | 855500.0 |
| 2002-08-12 | ACF-DELISTED | Stock | 11.5 | 12.26 | 11.11 | 12.23 | 3293700.0 |
| 2002-08-12 | ACG-DELISTED | Stock | 7.96 | 7.98 | 7.94 | 7.95 | 318000.0 |
| 2002-08-12 | ACGL | Stock | 3.0 | 3.0211 | 2.9444 | 2.9822 | 73800.0 |
| 2002-08-12 | ACGN-DELISTED | Stock | 906.6712 | 918.0 | 827.3288 | 906.6712 | 44700.0 |
| 2002-08-12 | ACH | Stock | 9.8067 | 9.9 | 9.62 | 9.86 | 202500.0 |
| 2002-08-12 | ACH-DELISTED | Stock | 3.5375 | 3.5625 | 3.5175 | 3.55 | 23200.0 |
| 2002-08-12 | ACLS | Stock | 31.64 | 31.64 | 30.04 | 30.6 | 138975.0 |
| 2002-08-12 | ACO-DELISTED | Stock | 5.3 | 5.33 | 5.25 | 5.29 | 3600.0 |
| 2002-08-12 | ACPW-DELISTED | Stock | 11.295 | 11.954 | 11.245 | 11.65 | 6632.0 |
| 2002-08-12 | ACS-DELISTED | Stock | 46.75 | 48.4 | 46.15 | 48.1 | 806200.0 |
| 2002-08-12 | ACTA-DELISTED | Stock | 4.4 | 4.6 | 4.4 | 4.4 | 16000.0 |
| 2002-08-12 | ACTT-DELISTED | Stock | 1.6 | 1.65 | 1.11 | 1.11 | 87400.0 |
| 2002-08-12 | ACTU-DELISTED | Stock | 1.73 | 1.9 | 1.68 | 1.9 | 95055.0 |
| 2002-08-12 | ACXM-DELISTED | Stock | 16.28 | 16.54 | 16.12 | 16.46 | 349403.0 |
> showing 50 of 3,147 rows — these rows as CSV