PREVIEW / stock_daily / 2002-03-27
file: by_date/stock_daily/2002/2002-03-27.parquet size: 106 KB rows: 3,089 symbols: 1,923
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-03-27 | AAPL | Stock | 0.417 | 0.4236 | 0.4154 | 0.4191 | 127702400.0 |
| 2002-03-27 | MSFT | Stock | 29.4 | 29.94 | 29.295 | 29.72 | 47318400.0 |
| 2002-03-27 | NVDA | Stock | 0.3857 | 0.3935 | 0.3725 | 0.3792 | 1068012000.0 |
| 2002-03-27 | AMZN | Stock | 0.695 | 0.7175 | 0.685 | 0.7125 | 162926000.0 |
| 2002-03-27 | CL | Stock | 28.425 | 28.75 | 28.3 | 28.655 | 2991600.0 |
| 2002-03-27 | A | Stock | 24.2489 | 24.3777 | 23.6338 | 23.784 | 5377966.0 |
| 2002-03-27 | AABA-DELISTED | Stock | 8.85499954223633 | 8.97500038146973 | 8.64500045776367 | 8.92500019073486 | 11252400.0 |
| 2002-03-27 | AAI-DELISTED | Stock | 5.8 | 5.85 | 5.56 | 5.65 | 252600.0 |
| 2002-03-27 | AAIC-DELISTED | Stock | 152.4 | 160.0 | 152.4 | 158.0 | 52000.0 |
| 2002-03-27 | AAME | Stock | 2.25 | 2.67 | 2.16 | 2.16 | 3000.0 |
| 2002-03-27 | AAON | Stock | 2.3923 | 2.4573 | 2.2606 | 2.2826 | 539916.0 |
| 2002-03-27 | AAP | Stock | 15.0 | 15.0333 | 14.9833 | 15.0167 | 357600.0 |
| 2002-03-27 | AAXN-DELISTED | Stock | 1.6341667175293 | 1.69166672229767 | 1.5625 | 1.64166665077209 | 1827600.0 |
| 2002-03-27 | ABAX-DELISTED | Stock | 6.5 | 6.5 | 6.27 | 6.45 | 8700.0 |
| 2002-03-27 | ABB-DELISTED | Stock | 7.46 | 7.75 | 7.46 | 7.65 | 10300.0 |
| 2002-03-27 | ABC-DELISTED | Stock | 16.83 | 17.23 | 16.8 | 17.15 | 3396400.0 |
| 2002-03-27 | ABCB | Stock | 11.3475 | 11.7527 | 11.307 | 11.5502 | 23318.0 |
| 2002-03-27 | ABCO-DELISTED | Stock | 15.795 | 15.81 | 15.77 | 15.81 | 21200.0 |
| 2002-03-27 | ABCW-DELISTED | Stock | 20.96 | 21.45 | 20.18 | 20.43 | 32700.0 |
| 2002-03-27 | ABE-DELISTED | Stock | 7.39 | 7.5 | 7.39 | 7.44 | 15500.0 |
| 2002-03-27 | ABFS-DELISTED | Stock | 26.3 | 27.9 | 26.25 | 27.63 | 192400.0 |
| 2002-03-27 | ABK-DELISTED | Stock | 56.5 | 59.24 | 55.96 | 58.07 | 1142500.0 |
| 2002-03-27 | ABM | Stock | 18.7 | 18.92 | 18.425 | 18.75 | 800800.0 |
| 2002-03-27 | ABMD-DELISTED | Stock | 10.79 | 11.1 | 10.5 | 10.68 | 148100.0 |
| 2002-03-27 | ABP-DELISTED | Stock | 1.4 | 1.44 | 1.33 | 1.4 | 122900.0 |
| 2002-03-27 | ABT | Stock | 23.6077 | 23.7469 | 23.1453 | 23.3024 | 9347721.0 |
| 2002-03-27 | ABTL-DELISTED | Stock | 19.0 | 19.2 | 17.85 | 18.15 | 29500.0 |
| 2002-03-27 | ABV-DELISTED | Stock | 19.52 | 19.56 | 19.45 | 19.5 | 158000.0 |
| 2002-03-27 | ABX-DELISTED | Stock | 18.25 | 18.94 | 18.25 | 18.87 | 3516900.0 |
| 2002-03-27 | ACAP-DELISTED | Stock | 18.95 | 19.48 | 18.95 | 19.35 | 76400.0 |
| 2002-03-27 | ACAS-DELISTED | Stock | 30.93 | 31.38 | 30.76 | 31.06 | 259300.0 |
| 2002-03-27 | ACAT-DELISTED | Stock | 19.65 | 19.77 | 19.3 | 19.6 | 123200.0 |
| 2002-03-27 | ACCL-DELISTED | Stock | 9.68863010406494 | 9.94931030273438 | 9.68863010406494 | 9.94931030273438 | 175700.0 |
| 2002-03-27 | ACE-DELISTED | Stock | 40.28 | 41.14 | 40.1 | 40.99 | 1982200.0 |
| 2002-03-27 | ACF-DELISTED | Stock | 37.84 | 38.74 | 37.01 | 37.36 | 1797600.0 |
| 2002-03-27 | ACG-DELISTED | Stock | 7.73 | 7.74 | 7.69 | 7.7 | 769600.0 |
| 2002-03-27 | ACGL | Stock | 2.8889 | 2.8889 | 2.8444 | 2.8611 | 23400.0 |
| 2002-03-27 | ACGN-DELISTED | Stock | 1643.3288 | 1677.3288 | 1632.0 | 1632.0 | 41600.0 |
| 2002-03-27 | ACH | Stock | 13.32 | 13.3333 | 13.1667 | 13.32 | 332700.0 |
| 2002-03-27 | ACH-DELISTED | Stock | 5.5255 | 5.5255 | 5.493 | 5.523 | 97992.0 |
| 2002-03-27 | ACLS | Stock | 54.24 | 54.68 | 53.2 | 54.36 | 137200.0 |
| 2002-03-27 | ACO-DELISTED | Stock | 6.15 | 6.17 | 6.11 | 6.17 | 37900.0 |
| 2002-03-27 | ACPW-DELISTED | Stock | 24.8 | 27.2 | 24.46 | 26.1 | 59920.0 |
| 2002-03-27 | ACS-DELISTED | Stock | 53.95 | 55.7 | 53.8 | 55.45 | 848600.0 |
| 2002-03-27 | ACTA-DELISTED | Stock | 13.6 | 14.0 | 13.0 | 13.0 | 58000.0 |
| 2002-03-27 | ACTT-DELISTED | Stock | 5.24 | 5.24 | 5.2 | 5.2287 | 1500.0 |
| 2002-03-27 | ACTU-DELISTED | Stock | 6.85 | 6.99 | 6.74 | 6.81 | 206500.0 |
| 2002-03-27 | ACXM-DELISTED | Stock | 17.05 | 17.25 | 16.95 | 17.091 | 916700.0 |
| 2002-03-27 | ACY-DELISTED | Stock | 4.65 | 4.65 | 4.6 | 4.6 | 900.0 |
| 2002-03-27 | AD | Stock | 25.9333 | 26.4667 | 25.7733 | 26.1067 | 107850.0 |
> showing 50 of 3,089 rows — these rows as CSV