PREVIEW / stock_daily / 2001-12-17
file: by_date/stock_daily/2001/2001-12-17.parquet size: 105 KB rows: 3,065 symbols: 1,908
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-17 | AAPL | Stock | 0.3643 | 0.375 | 0.3605 | 0.3682 | 173712000.0 |
| 2001-12-17 | MSFT | Stock | 33.585 | 34.555 | 33.58 | 34.49 | 57079800.0 |
| 2001-12-17 | NVDA | Stock | 0.5428 | 0.5746 | 0.5428 | 0.5667 | 1080960000.0 |
| 2001-12-17 | AMZN | Stock | 0.555 | 0.557 | 0.509 | 0.5405 | 171986000.0 |
| 2001-12-17 | CL | Stock | 28.275 | 28.45 | 28.07 | 28.175 | 1914600.0 |
| 2001-12-17 | A | Stock | 20.372 | 21.0801 | 20.2432 | 20.6795 | 4859448.0 |
| 2001-12-17 | AABA-DELISTED | Stock | 8.60000038146973 | 9.03499984741211 | 8.5649995803833 | 8.93000030517578 | 15448400.0 |
| 2001-12-17 | AAI-DELISTED | Stock | 6.5 | 6.79 | 6.4 | 6.55 | 175900.0 |
| 2001-12-17 | AAIC-DELISTED | Stock | 107.0 | 117.2 | 106.0 | 117.0 | 112000.0 |
| 2001-12-17 | AAME | Stock | 2.07 | 2.07 | 2.01 | 2.04 | 6000.0 |
| 2001-12-17 | AAON | Stock | 1.8103 | 1.8103 | 1.7743 | 1.7866 | 170859.0 |
| 2001-12-17 | AAP | Stock | 13.6633 | 14.0 | 13.6633 | 13.6667 | 106200.0 |
| 2001-12-17 | AAXN-DELISTED | Stock | 1.03333330154419 | 1.04166662693024 | 1.00833332538605 | 1.02083337306976 | 150000.0 |
| 2001-12-17 | ABAX-DELISTED | Stock | 5.48 | 5.6 | 5.2 | 5.4 | 46000.0 |
| 2001-12-17 | ABB-DELISTED | Stock | 10.15 | 10.35 | 10.05 | 10.35 | 22100.0 |
| 2001-12-17 | ABC-DELISTED | Stock | 14.86 | 14.91 | 14.66 | 14.72 | 3106000.0 |
| 2001-12-17 | ABCB | Stock | 10.537 | 10.537 | 10.537 | 10.537 | 2221.0 |
| 2001-12-17 | ABCO-DELISTED | Stock | 13.875 | 14.25 | 13.755 | 13.95 | 61800.0 |
| 2001-12-17 | ABCW-DELISTED | Stock | 18.04 | 18.04 | 17.6 | 17.6 | 104900.0 |
| 2001-12-17 | ABE-DELISTED | Stock | 6.95 | 7.03 | 6.95 | 7.0 | 15500.0 |
| 2001-12-17 | ABFS-DELISTED | Stock | 25.42 | 27.42 | 25.3 | 27.35 | 242900.0 |
| 2001-12-17 | ABK-DELISTED | Stock | 55.4 | 56.05 | 54.73 | 55.93 | 459500.0 |
| 2001-12-17 | ABM | Stock | 15.375 | 16.0 | 15.375 | 16.0 | 103000.0 |
| 2001-12-17 | ABMD-DELISTED | Stock | 16.26 | 16.77 | 15.95 | 16.75 | 196800.0 |
| 2001-12-17 | ABP-DELISTED | Stock | 0.99 | 1.1 | 0.99 | 1.02 | 163200.0 |
| 2001-12-17 | ABT | Stock | 24.2631 | 24.4651 | 24.1464 | 24.2406 | 7126072.0 |
| 2001-12-17 | ABTL-DELISTED | Stock | 8.5 | 8.65 | 8.0 | 8.0 | 19900.0 |
| 2001-12-17 | ABV-DELISTED | Stock | 20.05 | 20.3 | 19.9 | 20.02 | 291800.0 |
| 2001-12-17 | ABVA-DELISTED | Stock | 8.0 | 8.0 | 8.0 | 8.0 | 1000.0 |
| 2001-12-17 | ABX-DELISTED | Stock | 16.395 | 16.405 | 16.205 | 16.255 | 1626405.0 |
| 2001-12-17 | ACAP-DELISTED | Stock | 20.9 | 21.45 | 20.9 | 21.45 | 20000.0 |
| 2001-12-17 | ACAS-DELISTED | Stock | 27.13 | 28.05 | 27.1 | 27.9 | 423400.0 |
| 2001-12-17 | ACAT-DELISTED | Stock | 16.37 | 17.15 | 16.133 | 17.125 | 71400.0 |
| 2001-12-17 | ACCL-DELISTED | Stock | 10.4200000762939 | 10.7170000076294 | 10.03600025177 | 10.710000038147 | 258700.0 |
| 2001-12-17 | ACE-DELISTED | Stock | 37.75 | 38.18 | 37.3 | 37.92 | 2423500.0 |
| 2001-12-17 | ACF-DELISTED | Stock | 26.6 | 28.45 | 26.6 | 27.13 | 912000.0 |
| 2001-12-17 | ACG-DELISTED | Stock | 7.46 | 7.46 | 7.35 | 7.36 | 1523400.0 |
| 2001-12-17 | ACGL | Stock | 2.6856 | 2.6856 | 2.6667 | 2.6722 | 1016100.0 |
| 2001-12-17 | ACGN-DELISTED | Stock | 2119.3288 | 2119.3288 | 1796.3288 | 1926.6712 | 12300.0 |
| 2001-12-17 | ACH | Stock | 12.0667 | 12.1533 | 11.8 | 12.1333 | 185700.0 |
| 2001-12-17 | ACH-DELISTED | Stock | 4.3887 | 4.4488 | 4.3637 | 4.4488 | 646222.0 |
| 2001-12-17 | ACLS | Stock | 53.36 | 57.36 | 53.32 | 57.28 | 203000.0 |
| 2001-12-17 | ACO-DELISTED | Stock | 6.15 | 6.65 | 6.15 | 6.65 | 84300.0 |
| 2001-12-17 | ACPW-DELISTED | Stock | 28.25 | 29.0 | 27.2 | 27.5 | 135120.0 |
| 2001-12-17 | ACS-DELISTED | Stock | 49.325 | 50.825 | 49.235 | 50.255 | 973400.0 |
| 2001-12-17 | ACTA-DELISTED | Stock | 25.6 | 27.0 | 23.2 | 24.4 | 112700.0 |
| 2001-12-17 | ACTT-DELISTED | Stock | 8.51 | 8.73 | 8.51 | 8.7 | 22700.0 |
| 2001-12-17 | ACTU-DELISTED | Stock | 5.02 | 5.06 | 4.85 | 5.03 | 361600.0 |
| 2001-12-17 | ACXM-DELISTED | Stock | 15.9 | 17.24 | 15.85 | 17.14 | 2726900.0 |
| 2001-12-17 | ACY-DELISTED | Stock | 4.85 | 4.85 | 4.85 | 4.85 | 1200.0 |
> showing 50 of 3,065 rows — these rows as CSV