PREVIEW / stock_daily / 2001-07-02
file: by_date/stock_daily/2001/2001-07-02.parquet size: 101 KB rows: 2,931 symbols: 1,816
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-07-02 | AAPL | Stock | 0.4221 | 0.4327 | 0.4132 | 0.4268 | 230048000.0 |
| 2001-07-02 | MSFT | Stock | 36.025 | 36.575 | 35.075 | 35.3 | 72810200.0 |
| 2001-07-02 | NVDA | Stock | 0.3712 | 0.3743 | 0.3638 | 0.3693 | 1040016000.0 |
| 2001-07-02 | AMZN | Stock | 0.705 | 0.7355 | 0.6925 | 0.7265 | 126690000.0 |
| 2001-07-02 | CL | Stock | 29.495 | 30.105 | 29.495 | 29.99 | 4171000.0 |
| 2001-07-02 | A | Stock | 23.2475 | 23.9628 | 22.9041 | 23.6695 | 2152361.0 |
| 2001-07-02 | AABA-DELISTED | Stock | 9.82999992370605 | 10.2749996185303 | 9.72999954223633 | 10.0200004577637 | 14062400.0 |
| 2001-07-02 | AAI-DELISTED | Stock | 10.5 | 10.5 | 9.6 | 9.6 | 251900.0 |
| 2001-07-02 | AAIC-DELISTED | Stock | 140.0 | 144.8 | 139.0 | 139.8 | 134300.0 |
| 2001-07-02 | AAME | Stock | 1.62 | 1.62 | 1.56 | 1.56 | 2000.0 |
| 2001-07-02 | AAON | Stock | 1.4983 | 1.5188 | 1.4632 | 1.4813 | 1023448.0 |
| 2001-07-02 | AAXN-DELISTED | Stock | 0.533333361148834 | 0.537500023841858 | 0.529166638851166 | 0.533333361148834 | 292800.0 |
| 2001-07-02 | ABAX-DELISTED | Stock | 5.25 | 5.29 | 5.0 | 5.05 | 23400.0 |
| 2001-07-02 | ABB-DELISTED | Stock | 14.92 | 15.23 | 14.85 | 15.2 | 10100.0 |
| 2001-07-02 | ABC-DELISTED | Stock | 13.8249998092651 | 14.0474996566772 | 13.6750001907349 | 13.9250001907349 | 4537200.0 |
| 2001-07-02 | ABCB | Stock | 8.9645 | 9.0375 | 8.9645 | 9.0375 | 370.0 |
| 2001-07-02 | ABCW-DELISTED | Stock | 15.5 | 15.5 | 15.35 | 15.39 | 31800.0 |
| 2001-07-02 | ABE-DELISTED | Stock | 8.19 | 8.19 | 8.02 | 8.12 | 13400.0 |
| 2001-07-02 | ABFS-DELISTED | Stock | 22.55 | 23.05 | 22.55 | 22.95 | 451500.0 |
| 2001-07-02 | ABK-DELISTED | Stock | 58.2 | 59.66 | 57.4 | 59.1 | 404800.0 |
| 2001-07-02 | ABM | Stock | 18.575 | 18.6 | 18.25 | 18.49 | 262800.0 |
| 2001-07-02 | ABMD-DELISTED | Stock | 23.58 | 25.0 | 23.0 | 23.48 | 122400.0 |
| 2001-07-02 | ABP-DELISTED | Stock | 3.16 | 3.2 | 3.07 | 3.15 | 86500.0 |
| 2001-07-02 | ABT | Stock | 22.0186 | 22.3553 | 21.8839 | 22.1622 | 8117159.0 |
| 2001-07-02 | ABTL-DELISTED | Stock | 7.35 | 7.85 | 7.1 | 7.1 | 27700.0 |
| 2001-07-02 | ABV-DELISTED | Stock | 22.76 | 23.51 | 22.76 | 23.17 | 208300.0 |
| 2001-07-02 | ABX-DELISTED | Stock | 15.08 | 15.08 | 14.22 | 14.3 | 3216400.0 |
| 2001-07-02 | ACAP-DELISTED | Stock | 19.5 | 19.75 | 19.23 | 19.5 | 91600.0 |
| 2001-07-02 | ACAS-DELISTED | Stock | 27.61 | 27.95 | 27.19 | 27.2 | 309400.0 |
| 2001-07-02 | ACAT-DELISTED | Stock | 14.93 | 15.04 | 14.93 | 14.95 | 31300.0 |
| 2001-07-02 | ACCL-DELISTED | Stock | 15.0622997283936 | 15.1621999740601 | 14.5546998977661 | 15.1621999740601 | 229700.0 |
| 2001-07-02 | ACE-DELISTED | Stock | 39.09 | 39.32 | 38.3 | 38.71 | 448300.0 |
| 2001-07-02 | ACF-DELISTED | Stock | 52.1 | 53.95 | 52.03 | 53.21 | 643600.0 |
| 2001-07-02 | ACG-DELISTED | Stock | 8.72 | 8.8 | 8.68 | 8.74 | 368600.0 |
| 2001-07-02 | ACGL | Stock | 1.7167 | 1.8722 | 1.7167 | 1.8722 | 146700.0 |
| 2001-07-02 | ACGN-DELISTED | Stock | 1337.3288 | 1416.6712 | 1303.3288 | 1337.3288 | 57200.0 |
| 2001-07-02 | ACH | Stock | 12.8 | 12.8 | 12.14 | 12.4867 | 132300.0 |
| 2001-07-02 | ACLS | Stock | 59.6 | 60.0 | 55.96 | 56.36 | 361550.0 |
| 2001-07-02 | ACO-DELISTED | Stock | 6.0 | 6.1 | 5.65 | 5.65 | 49900.0 |
| 2001-07-02 | ACPW-DELISTED | Stock | 81.4 | 84.5 | 80.55 | 80.55 | 68580.0 |
| 2001-07-02 | ACS-DELISTED | Stock | 36.075 | 36.425 | 35.6 | 36.325 | 373100.0 |
| 2001-07-02 | ACTA-DELISTED | Stock | 39.2 | 42.0 | 38.4 | 41.8 | 68400.0 |
| 2001-07-02 | ACTT-DELISTED | Stock | 6.25 | 6.48 | 6.25 | 6.48 | 11500.0 |
| 2001-07-02 | ACTU-DELISTED | Stock | 8.57 | 8.86 | 7.92 | 8.0 | 560900.0 |
| 2001-07-02 | ACXM-DELISTED | Stock | 12.69 | 12.69 | 12.25 | 12.41 | 1384200.0 |
| 2001-07-02 | ACY-DELISTED | Stock | 4.87 | 4.95 | 4.87 | 4.95 | 2000.0 |
| 2001-07-02 | AD | Stock | 38.4667 | 38.5 | 38.1667 | 38.4 | 54750.0 |
| 2001-07-02 | ADAT-DELISTED | Stock | 80.28 | 83.34 | 80.28 | 82.62 | 2169.0 |
| 2001-07-02 | ADBE | Stock | 23.45 | 23.92 | 23.165 | 23.475 | 6476800.0 |
| 2001-07-02 | ADC | Stock | 19.01 | 19.01 | 18.51 | 18.75 | 14500.0 |
> showing 50 of 2,931 rows — these rows as CSV