PREVIEW / stock_daily / 2003-12-22
file: by_date/stock_daily/2003/2003-12-22.parquet size: 123 KB rows: 3,600 symbols: 2,242
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-22 | AAPL | Stock | 0.3509 | 0.3552 | 0.3438 | 0.3545 | 377064800.0 |
| 2003-12-22 | MSFT | Stock | 27.16 | 27.43 | 26.97 | 27.18 | 43894800.0 |
| 2003-12-22 | NVDA | Stock | 0.173 | 0.1762 | 0.1712 | 0.1758 | 371184000.0 |
| 2003-12-22 | AMZN | Stock | 2.449 | 2.505 | 2.435 | 2.4945 | 155994000.0 |
| 2003-12-22 | CL | Stock | 24.6 | 24.945 | 24.46 | 24.565 | 9572600.0 |
| 2003-12-22 | A | Stock | 20.0286 | 20.3863 | 19.9142 | 20.2933 | 2859469.0 |
| 2003-12-22 | AABA-DELISTED | Stock | 20.9150009155273 | 21.3050003051758 | 20.8850002288818 | 21.2999992370605 | 14952400.0 |
| 2003-12-22 | AAI-DELISTED | Stock | 11.11 | 11.58 | 11.1 | 11.35 | 2479400.0 |
| 2003-12-22 | AAIC-DELISTED | Stock | 444.0 | 458.4 | 443.2 | 457.0 | 745200.0 |
| 2003-12-22 | AAME | Stock | 2.89 | 2.97 | 2.88 | 2.9 | 15300.0 |
| 2003-12-22 | AAON | Stock | 2.4191 | 2.4283 | 2.3835 | 2.4283 | 14428.0 |
| 2003-12-22 | AAP | Stock | 26.45 | 26.4833 | 26.1167 | 26.26 | 456900.0 |
| 2003-12-22 | AAXN-DELISTED | Stock | 7.09749984741211 | 7.19833326339722 | 6.82916688919067 | 6.90000009536743 | 3770400.0 |
| 2003-12-22 | ABAX-DELISTED | Stock | 18.13 | 18.43 | 17.86 | 18.34 | 142623.0 |
| 2003-12-22 | ABB-DELISTED | Stock | 4.98 | 5.08 | 4.97 | 5.06 | 202100.0 |
| 2003-12-22 | ABC-DELISTED | Stock | 15.9 | 16.09 | 15.88 | 15.95 | 2541600.0 |
| 2003-12-22 | ABCB | Stock | 13.1226 | 13.3658 | 13.1226 | 13.3577 | 1727.0 |
| 2003-12-22 | ABCO-DELISTED | Stock | 16.2 | 16.78 | 16.2 | 16.63 | 417468.0 |
| 2003-12-22 | ABCW-DELISTED | Stock | 24.2 | 24.49 | 24.11 | 24.3 | 81260.0 |
| 2003-12-22 | ABE-DELISTED | Stock | 7.08 | 7.17 | 7.08 | 7.15 | 9900.0 |
| 2003-12-22 | ABFS-DELISTED | Stock | 31.42 | 31.67 | 31.26 | 31.6 | 69369.0 |
| 2003-12-22 | ABG | Stock | 17.25 | 17.58 | 17.25 | 17.57 | 12900.0 |
| 2003-12-22 | ABK-DELISTED | Stock | 69.14 | 69.5 | 68.85 | 69.05 | 526000.0 |
| 2003-12-22 | ABM | Stock | 17.2 | 17.6 | 17.05 | 17.35 | 274400.0 |
| 2003-12-22 | ABMD-DELISTED | Stock | 6.9 | 7.05 | 6.77 | 7.03 | 51261.0 |
| 2003-12-22 | ABP-DELISTED | Stock | 1.3 | 1.33 | 1.2 | 1.24 | 223200.0 |
| 2003-12-22 | ABT | Stock | 20.7751 | 20.8739 | 20.6719 | 20.7841 | 7930036.0 |
| 2003-12-22 | ABTL-DELISTED | Stock | 43.95 | 45.3 | 43.75 | 45.2 | 36200.0 |
| 2003-12-22 | ABV-DELISTED | Stock | 24.09 | 24.51 | 23.97 | 24.51 | 805000.0 |
| 2003-12-22 | ABVA-DELISTED | Stock | 18.7 | 19.0 | 18.699 | 19.0 | 1300.0 |
| 2003-12-22 | ABX-DELISTED | Stock | 22.05 | 22.22 | 21.7 | 21.78 | 2008300.0 |
| 2003-12-22 | ACAP-DELISTED | Stock | 16.61 | 16.82 | 16.61 | 16.82 | 18300.0 |
| 2003-12-22 | ACAS-DELISTED | Stock | 28.87 | 29.35 | 28.68 | 29.17 | 515399.0 |
| 2003-12-22 | ACAT-DELISTED | Stock | 23.45 | 24.14 | 23.45 | 24.14 | 44492.0 |
| 2003-12-22 | ACCL-DELISTED | Stock | 10.5502996444702 | 10.7892999649048 | 10.0724000930786 | 10.7892999649048 | 276400.0 |
| 2003-12-22 | ACE-DELISTED | Stock | 39.64 | 40.12 | 39.4 | 40.12 | 1462900.0 |
| 2003-12-22 | ACF-DELISTED | Stock | 13.91 | 14.61 | 13.9 | 14.57 | 1988000.0 |
| 2003-12-22 | ACG-DELISTED | Stock | 8.48 | 8.49 | 8.45 | 8.47 | 443600.0 |
| 2003-12-22 | ACGL | Stock | 4.3556 | 4.3778 | 4.3433 | 4.37 | 471600.0 |
| 2003-12-22 | ACGN-DELISTED | Stock | 1224.0 | 1246.6712 | 1224.0 | 1246.6712 | 71600.0 |
| 2003-12-22 | ACH | Stock | 14.5667 | 14.5667 | 14.1333 | 14.3667 | 259950.0 |
| 2003-12-22 | ACH-DELISTED | Stock | 18.477 | 19.036 | 18.352 | 18.926 | 1266280.0 |
| 2003-12-22 | ACLS | Stock | 38.72 | 40.2 | 37.92 | 39.16 | 190250.0 |
| 2003-12-22 | ACO-DELISTED | Stock | 18.2 | 18.99 | 17.54 | 17.55 | 410300.0 |
| 2003-12-22 | ACPW-DELISTED | Stock | 15.2 | 15.2 | 14.25 | 14.5 | 15998.0 |
| 2003-12-22 | ACS-DELISTED | Stock | 53.22 | 54.0 | 52.98 | 53.87 | 983700.0 |
| 2003-12-22 | ACTA-DELISTED | Stock | 6.0 | 6.2 | 6.0 | 6.0 | 313300.0 |
| 2003-12-22 | ACTG | Stock | 5.5 | 5.67 | 5.38 | 5.5 | 93700.0 |
| 2003-12-22 | ACTI-DELISTED | Stock | 7.95 | 8.05 | 7.95 | 8.01 | 158282.0 |
| 2003-12-22 | ACTT-DELISTED | Stock | 1.09 | 1.15 | 1.08 | 1.081 | 72552.0 |
> showing 50 of 3,600 rows — these rows as CSV