PREVIEW / stock_daily / 2005-06-24
file: by_date/stock_daily/2005/2005-06-24.parquet size: 137 KB rows: 4,072 symbols: 2,538
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-06-24 | AAPL | Stock | 1.3961 | 1.3971 | 1.3457 | 1.3486 | 410709600.0 |
| 2005-06-24 | MSFT | Stock | 25.22 | 25.4 | 25.04 | 25.04 | 57970700.0 |
| 2005-06-24 | NVDA | Stock | 0.2327 | 0.2328 | 0.2245 | 0.2257 | 475632000.0 |
| 2005-06-24 | AMZN | Stock | 1.765 | 1.772 | 1.744 | 1.751 | 73510000.0 |
| 2005-06-24 | CL | Stock | 25.7 | 25.745 | 25.155 | 25.3 | 6054600.0 |
| 2005-06-24 | A | Stock | 17.7253 | 17.7325 | 17.2532 | 17.2604 | 2575535.0 |
| 2005-06-24 | AABA-DELISTED | Stock | 36.2599983215332 | 36.4000015258789 | 35.5999984741211 | 36.0900001525879 | 13468200.0 |
| 2005-06-24 | AACC-DELISTED | Stock | 24.98 | 25.49 | 24.32 | 24.96 | 180244.0 |
| 2005-06-24 | AACQ-DELISTED | Stock | 5.03 | 5.05 | 5.03 | 5.05 | 9000.0 |
| 2005-06-24 | AAI-DELISTED | Stock | 9.4 | 9.41 | 9.0 | 9.03 | 1005200.0 |
| 2005-06-24 | AAIC-DELISTED | Stock | 287.0 | 287.8 | 279.52 | 281.6 | 984100.0 |
| 2005-06-24 | AAME | Stock | 3.05 | 3.05 | 3.05 | 3.05 | 1000.0 |
| 2005-06-24 | AAON | Stock | 2.4639 | 2.5021 | 2.3638 | 2.3638 | 288562.0 |
| 2005-06-24 | AAP | Stock | 42.9667 | 42.9867 | 42.0 | 42.2333 | 1219650.0 |
| 2005-06-24 | AAV-DELISTED | Stock | 14.4 | 14.46 | 14.32 | 14.4 | 105300.0 |
| 2005-06-24 | AAXN-DELISTED | Stock | 10.4499998092651 | 10.5100002288818 | 10.1000003814697 | 10.3500003814697 | 2274800.0 |
| 2005-06-24 | ABAX-DELISTED | Stock | 10.73 | 10.87 | 10.54 | 10.6 | 210678.0 |
| 2005-06-24 | ABB-DELISTED | Stock | 7.05 | 7.07 | 6.99 | 7.01 | 2263500.0 |
| 2005-06-24 | ABBC-DELISTED | Stock | 11.95 | 12.32 | 11.7 | 11.99 | 355450.0 |
| 2005-06-24 | ABC-DELISTED | Stock | 16.76 | 16.84 | 16.71 | 16.78 | 3634800.0 |
| 2005-06-24 | ABCB | Stock | 17.1185 | 17.3908 | 17.0213 | 17.3908 | 31769.0 |
| 2005-06-24 | ABCO-DELISTED | Stock | 23.39 | 23.98 | 23.24 | 23.51 | 258729.0 |
| 2005-06-24 | ABCW-DELISTED | Stock | 30.22 | 30.22 | 29.39 | 29.57 | 185630.0 |
| 2005-06-24 | ABE-DELISTED | Stock | 10.03 | 10.19 | 10.03 | 10.1 | 6600.0 |
| 2005-06-24 | ABFS-DELISTED | Stock | 31.54 | 32.12 | 30.95 | 30.95 | 617093.0 |
| 2005-06-24 | ABG | Stock | 15.53 | 15.63 | 15.18 | 15.26 | 86200.0 |
| 2005-06-24 | ABK-DELISTED | Stock | 70.31 | 70.35 | 69.19 | 69.62 | 552300.0 |
| 2005-06-24 | ABM | Stock | 19.3 | 19.41 | 18.97 | 19.0 | 175400.0 |
| 2005-06-24 | ABMD-DELISTED | Stock | 7.8 | 9.17 | 7.75 | 8.66 | 959869.0 |
| 2005-06-24 | ABP-DELISTED | Stock | 2.8 | 2.85 | 2.7 | 2.74 | 53800.0 |
| 2005-06-24 | ABR | Stock | 28.7 | 28.85 | 28.04 | 28.35 | 430300.0 |
| 2005-06-24 | ABT | Stock | 23.491 | 23.6254 | 23.3471 | 23.5198 | 8520217.0 |
| 2005-06-24 | ABTL-DELISTED | Stock | 23.34 | 24.15 | 22.34 | 23.95 | 256512.0 |
| 2005-06-24 | ABV-DELISTED | Stock | 30.3 | 30.45 | 29.97 | 30.13 | 307700.0 |
| 2005-06-24 | ABVA-DELISTED | Stock | 14.5 | 14.5 | 14.5 | 14.5 | 900.0 |
| 2005-06-24 | ABX-DELISTED | Stock | 24.76 | 25.17 | 24.74 | 24.89 | 1729200.0 |
| 2005-06-24 | ACAD | Stock | 9.1 | 9.34 | 8.96 | 9.2 | 662200.0 |
| 2005-06-24 | ACAP-DELISTED | Stock | 36.1 | 36.2 | 36.0 | 36.05 | 119837.0 |
| 2005-06-24 | ACAS-DELISTED | Stock | 35.82 | 36.2 | 35.74 | 36.01 | 823350.0 |
| 2005-06-24 | ACAT-DELISTED | Stock | 21.04 | 21.39 | 20.49 | 20.49 | 208680.0 |
| 2005-06-24 | ACC-DELISTED | Stock | 21.2 | 21.56 | 21.2 | 21.39 | 193400.0 |
| 2005-06-24 | ACCL-DELISTED | Stock | 5.07 | 5.14 | 4.9 | 4.96 | 1818324.0 |
| 2005-06-24 | ACE-DELISTED | Stock | 44.53 | 44.54 | 43.88 | 43.88 | 1375900.0 |
| 2005-06-24 | ACF-DELISTED | Stock | 25.03 | 25.17 | 24.68 | 24.79 | 821400.0 |
| 2005-06-24 | ACFC-DELISTED | Stock | 63.56 | 64.62 | 62.29 | 63.78 | 64301.0 |
| 2005-06-24 | ACG-DELISTED | Stock | 8.27 | 8.3 | 8.27 | 8.29 | 274800.0 |
| 2005-06-24 | ACGL | Stock | 4.8289 | 4.8956 | 4.8056 | 4.8778 | 873900.0 |
| 2005-06-24 | ACGN-DELISTED | Stock | 657.3288 | 668.6712 | 634.6712 | 668.6712 | 30300.0 |
| 2005-06-24 | ACH | Stock | 20.98 | 21.0333 | 20.6733 | 20.88 | 186000.0 |
| 2005-06-24 | ACH-DELISTED | Stock | 13.631 | 13.631 | 13.353 | 13.376 | 184397.0 |
> showing 50 of 4,072 rows — these rows as CSV