PREVIEW / stock_daily / 2005-09-09
file: by_date/stock_daily/2005/2005-09-09.parquet size: 140 KB rows: 4,170 symbols: 2,624
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-09 | AAPL | Stock | 1.7882 | 1.8339 | 1.7782 | 1.8325 | 615641600.0 |
| 2005-09-09 | MSFT | Stock | 26.62 | 26.82 | 26.53 | 26.58 | 41515800.0 |
| 2005-09-09 | NVDA | Stock | 0.2677 | 0.2688 | 0.2633 | 0.2682 | 454236000.0 |
| 2005-09-09 | AMZN | Stock | 2.1495 | 2.16 | 2.1405 | 2.1475 | 65774000.0 |
| 2005-09-09 | CL | Stock | 26.8 | 26.85 | 26.635 | 26.67 | 2615800.0 |
| 2005-09-09 | A | Stock | 23.0186 | 23.3763 | 22.9757 | 23.3333 | 3532327.0 |
| 2005-09-09 | AABA-DELISTED | Stock | 33.3499984741211 | 33.5999984741211 | 33.0200004577637 | 33.4599990844727 | 15247900.0 |
| 2005-09-09 | AACC-DELISTED | Stock | 30.01 | 30.389 | 29.77 | 30.06 | 117319.0 |
| 2005-09-09 | AACQ-DELISTED | Stock | 5.11 | 5.11 | 5.11 | 5.11 | 216.0 |
| 2005-09-09 | AACQW-DELISTED | Stock | 0.62 | 0.64 | 0.62 | 0.63 | 57500.0 |
| 2005-09-09 | AAI-DELISTED | Stock | 10.22 | 10.31 | 9.9 | 10.17 | 820100.0 |
| 2005-09-09 | AAIC-DELISTED | Stock | 233.2 | 236.0 | 230.0 | 234.8 | 1155400.0 |
| 2005-09-09 | AAME | Stock | 2.7 | 2.77 | 2.5 | 2.65 | 2400.0 |
| 2005-09-09 | AAON | Stock | 2.3533 | 2.3704 | 2.348 | 2.3704 | 85809.0 |
| 2005-09-09 | AAP | Stock | 40.1467 | 40.8 | 40.0933 | 40.5467 | 880350.0 |
| 2005-09-09 | AATI-DELISTED | Stock | 13.22 | 13.32 | 12.85 | 13.32 | 104598.0 |
| 2005-09-09 | AAV-DELISTED | Stock | 17.16 | 17.26 | 17.04 | 17.16 | 32800.0 |
| 2005-09-09 | AAXN-DELISTED | Stock | 8.36999988555908 | 8.39000034332275 | 8.10000038146973 | 8.11999988555908 | 1590600.0 |
| 2005-09-09 | ABAX-DELISTED | Stock | 12.35 | 12.67 | 12.3 | 12.6 | 72350.0 |
| 2005-09-09 | ABB-DELISTED | Stock | 7.51 | 7.53 | 7.48 | 7.53 | 297600.0 |
| 2005-09-09 | ABBC-DELISTED | Stock | 12.718 | 12.8 | 12.7 | 12.78 | 2100.0 |
| 2005-09-09 | ABC-DELISTED | Stock | 18.68 | 18.83 | 18.64 | 18.72 | 2061200.0 |
| 2005-09-09 | ABCB | Stock | 19.1805 | 19.2972 | 19.1805 | 19.2875 | 2983.0 |
| 2005-09-09 | ABCO-DELISTED | Stock | 26.26 | 26.28 | 25.83 | 26.05 | 213597.0 |
| 2005-09-09 | ABCW-DELISTED | Stock | 30.98 | 31.38 | 30.84 | 31.04 | 27570.0 |
| 2005-09-09 | ABD-DELISTED | Stock | 25.37 | 26.1 | 25.37 | 26.07 | 512910.0 |
| 2005-09-09 | ABE-DELISTED | Stock | 10.72 | 10.97 | 10.72 | 10.88 | 22000.0 |
| 2005-09-09 | ABFS-DELISTED | Stock | 34.28 | 34.28 | 33.26 | 33.67 | 297977.0 |
| 2005-09-09 | ABG | Stock | 16.93 | 17.36 | 16.93 | 17.15 | 68800.0 |
| 2005-09-09 | ABK-DELISTED | Stock | 66.5 | 67.53 | 66.45 | 67.09 | 724100.0 |
| 2005-09-09 | ABM | Stock | 19.99 | 20.78 | 19.88 | 20.67 | 210100.0 |
| 2005-09-09 | ABMD-DELISTED | Stock | 10.2 | 10.47 | 10.13 | 10.34 | 28401.0 |
| 2005-09-09 | ABP-DELISTED | Stock | 4.43 | 4.5 | 4.41 | 4.49 | 133500.0 |
| 2005-09-09 | ABR | Stock | 28.87 | 28.93 | 28.38 | 28.51 | 109200.0 |
| 2005-09-09 | ABT | Stock | 21.7829 | 21.9508 | 21.6966 | 21.8645 | 5663818.0 |
| 2005-09-09 | ABTL-DELISTED | Stock | 25.18 | 25.42 | 24.88 | 24.97 | 23893.0 |
| 2005-09-09 | ABV-DELISTED | Stock | 35.4 | 35.53 | 34.91 | 35.49 | 345900.0 |
| 2005-09-09 | ABVA-DELISTED | Stock | 16.49 | 16.7 | 16.2 | 16.2 | 4200.0 |
| 2005-09-09 | ABX-DELISTED | Stock | 27.77 | 27.98 | 27.77 | 27.88 | 3341600.0 |
| 2005-09-09 | ACAD | Stock | 11.21 | 11.28 | 10.96 | 11.01 | 55700.0 |
| 2005-09-09 | ACAP-DELISTED | Stock | 45.04 | 45.18 | 44.69 | 44.92 | 46284.0 |
| 2005-09-09 | ACAS-DELISTED | Stock | 37.55 | 37.73 | 37.39 | 37.55 | 392127.0 |
| 2005-09-09 | ACAT-DELISTED | Stock | 20.88 | 20.95 | 20.67 | 20.86 | 51499.0 |
| 2005-09-09 | ACC-DELISTED | Stock | 23.37 | 23.37 | 23.15 | 23.16 | 70800.0 |
| 2005-09-09 | ACCL-DELISTED | Stock | 5.5 | 5.67 | 5.5 | 5.67 | 176722.0 |
| 2005-09-09 | ACCO | Stock | 25.37 | 26.1 | 25.37 | 26.07 | 514800.0 |
| 2005-09-09 | ACE-DELISTED | Stock | 43.72 | 44.21 | 42.86 | 44.17 | 2456061.0 |
| 2005-09-09 | ACF-DELISTED | Stock | 25.05 | 25.27 | 24.98 | 25.15 | 563600.0 |
| 2005-09-09 | ACFC-DELISTED | Stock | 73.21 | 73.47 | 72.55 | 72.7 | 4039.0 |
| 2005-09-09 | ACG-DELISTED | Stock | 8.33 | 8.33 | 8.31 | 8.32 | 290400.0 |
> showing 50 of 4,170 rows — these rows as CSV