PREVIEW / stock_daily / 2005-09-16
file: by_date/stock_daily/2005/2005-09-16.parquet size: 141 KB rows: 4,179 symbols: 2,627
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-16 | AAPL | Stock | 1.7939 | 1.8289 | 1.7839 | 1.8289 | 591004400.0 |
| 2005-09-16 | MSFT | Stock | 26.34 | 26.4 | 25.97 | 26.07 | 187384300.0 |
| 2005-09-16 | NVDA | Stock | 0.2792 | 0.2807 | 0.2748 | 0.2771 | 519828000.0 |
| 2005-09-16 | AMZN | Stock | 2.14 | 2.146 | 2.106 | 2.14 | 82234000.0 |
| 2005-09-16 | CL | Stock | 26.6 | 26.855 | 26.375 | 26.81 | 4585600.0 |
| 2005-09-16 | A | Stock | 23.7983 | 24.3205 | 23.6552 | 24.2561 | 11215735.0 |
| 2005-09-16 | AABA-DELISTED | Stock | 33.7400016784668 | 33.7700004577637 | 33.0499992370605 | 33.1699981689453 | 20858300.0 |
| 2005-09-16 | AACC-DELISTED | Stock | 30.14 | 30.14 | 29.89 | 30.0 | 127577.0 |
| 2005-09-16 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 13000.0 |
| 2005-09-16 | AACQU-DELISTED | Stock | 6.25 | 6.3 | 6.25 | 6.3 | 6000.0 |
| 2005-09-16 | AACQW-DELISTED | Stock | 0.61 | 0.63 | 0.61 | 0.63 | 67500.0 |
| 2005-09-16 | AAI-DELISTED | Stock | 10.79 | 11.06 | 10.59 | 11.05 | 1656300.0 |
| 2005-09-16 | AAIC-DELISTED | Stock | 232.4 | 234.0 | 220.6 | 223.0 | 2844600.0 |
| 2005-09-16 | AAME | Stock | 2.6 | 3.02 | 2.6 | 2.69 | 72100.0 |
| 2005-09-16 | AAON | Stock | 2.3743 | 2.3822 | 2.3493 | 2.3822 | 558141.0 |
| 2005-09-16 | AAP | Stock | 40.6333 | 40.7 | 40.1333 | 40.3867 | 1059450.0 |
| 2005-09-16 | AATI-DELISTED | Stock | 13.23 | 13.23 | 12.77 | 12.9 | 162304.0 |
| 2005-09-16 | AAV-DELISTED | Stock | 17.23 | 17.5 | 17.07 | 17.23 | 72800.0 |
| 2005-09-16 | AAXN-DELISTED | Stock | 7.76999998092651 | 7.8600001335144 | 7.59999990463257 | 7.67000007629395 | 2044100.0 |
| 2005-09-16 | ABAX-DELISTED | Stock | 13.07 | 13.07 | 12.7 | 13.04 | 120252.0 |
| 2005-09-16 | ABB-DELISTED | Stock | 7.38 | 7.39 | 7.334 | 7.36 | 467200.0 |
| 2005-09-16 | ABBC-DELISTED | Stock | 12.7 | 12.71 | 12.61 | 12.61 | 559.0 |
| 2005-09-16 | ABC-DELISTED | Stock | 19.67 | 19.68 | 19.51 | 19.58 | 3450400.0 |
| 2005-09-16 | ABCB | Stock | 17.809 | 18.4024 | 17.809 | 18.2662 | 61893.0 |
| 2005-09-16 | ABCO-DELISTED | Stock | 26.43 | 26.77 | 26.31 | 26.5 | 358374.0 |
| 2005-09-16 | ABCW-DELISTED | Stock | 30.11 | 30.28 | 29.9 | 30.06 | 228830.0 |
| 2005-09-16 | ABD-DELISTED | Stock | 27.89 | 28.4 | 27.8 | 28.08 | 394890.0 |
| 2005-09-16 | ABE-DELISTED | Stock | 10.88 | 10.9 | 10.84 | 10.88 | 8100.0 |
| 2005-09-16 | ABFS-DELISTED | Stock | 33.3 | 33.742 | 32.93 | 33.68 | 336011.0 |
| 2005-09-16 | ABG | Stock | 17.04 | 17.2 | 16.9 | 17.07 | 85700.0 |
| 2005-09-16 | ABK-DELISTED | Stock | 69.02 | 69.48 | 68.56 | 69.45 | 1122800.0 |
| 2005-09-16 | ABM | Stock | 20.6 | 20.95 | 20.32 | 20.82 | 602100.0 |
| 2005-09-16 | ABMD-DELISTED | Stock | 10.52 | 10.74 | 10.46 | 10.7 | 157936.0 |
| 2005-09-16 | ABP-DELISTED | Stock | 5.0 | 5.18 | 4.96 | 5.09 | 320700.0 |
| 2005-09-16 | ABR | Stock | 28.8 | 28.8 | 28.7 | 28.77 | 107900.0 |
| 2005-09-16 | ABT | Stock | 20.9912 | 21.1016 | 20.8473 | 20.9865 | 19156524.0 |
| 2005-09-16 | ABTL-DELISTED | Stock | 25.37 | 26.03 | 24.77 | 25.93 | 61320.0 |
| 2005-09-16 | ABV-DELISTED | Stock | 35.89 | 36.03 | 35.4 | 35.63 | 269400.0 |
| 2005-09-16 | ABVA-DELISTED | Stock | 16.2 | 16.2 | 16.2 | 16.2 | 1100.0 |
| 2005-09-16 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 1800.0 |
| 2005-09-16 | ABX-DELISTED | Stock | 28.48 | 29.03 | 28.48 | 29.0 | 4916858.0 |
| 2005-09-16 | ACAD | Stock | 11.15 | 11.21 | 10.98 | 11.02 | 426600.0 |
| 2005-09-16 | ACAP-DELISTED | Stock | 44.84 | 45.4 | 44.63 | 45.4 | 236885.0 |
| 2005-09-16 | ACAS-DELISTED | Stock | 37.02 | 37.22 | 36.93 | 37.18 | 936197.0 |
| 2005-09-16 | ACAT-DELISTED | Stock | 20.43 | 20.86 | 20.35 | 20.62 | 260915.0 |
| 2005-09-16 | ACC-DELISTED | Stock | 22.8 | 23.15 | 22.35 | 23.0 | 262700.0 |
| 2005-09-16 | ACCL-DELISTED | Stock | 6.67 | 6.71 | 6.31 | 6.39 | 151318.0 |
| 2005-09-16 | ACCO | Stock | 27.89 | 28.4 | 27.8 | 28.08 | 397900.0 |
| 2005-09-16 | ACE-DELISTED | Stock | 46.12 | 47.37 | 45.77 | 47.3 | 3023200.0 |
| 2005-09-16 | ACF-DELISTED | Stock | 25.03 | 25.04 | 24.89 | 24.99 | 1419100.0 |
> showing 50 of 4,179 rows — these rows as CSV