PREVIEW / stock_daily / 2003-03-20
file: by_date/stock_daily/2003/2003-03-20.parquet size: 111 KB rows: 3,286 symbols: 2,009
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-03-20 | AAPL | Stock | 0.2666 | 0.2677 | 0.2607 | 0.2663 | 163178400.0 |
| 2003-03-20 | MSFT | Stock | 26.02 | 26.52 | 25.67 | 26.25 | 71798500.0 |
| 2003-03-20 | NVDA | Stock | 0.118 | 0.1216 | 0.1149 | 0.1191 | 780060000.0 |
| 2003-03-20 | AMZN | Stock | 1.317 | 1.3815 | 1.3065 | 1.3725 | 187524000.0 |
| 2003-03-20 | CL | Stock | 27.1 | 27.385 | 26.88 | 27.295 | 4027200.0 |
| 2003-03-20 | A | Stock | 10.3362 | 10.7296 | 10.1216 | 10.608 | 2893301.0 |
| 2003-03-20 | AABA-DELISTED | Stock | 11.0150003433228 | 11.6300001144409 | 10.8999996185303 | 11.4250001907349 | 29435600.0 |
| 2003-03-20 | AAI-DELISTED | Stock | 6.0 | 6.15 | 5.98 | 6.13 | 544200.0 |
| 2003-03-20 | AAIC-DELISTED | Stock | 180.0 | 184.2 | 179.8 | 183.0 | 260600.0 |
| 2003-03-20 | AAME | Stock | 1.36 | 1.45 | 1.15 | 1.45 | 6900.0 |
| 2003-03-20 | AAON | Stock | 1.8436 | 1.8647 | 1.8291 | 1.8634 | 58472.0 |
| 2003-03-20 | AAP | Stock | 14.9833 | 14.9967 | 14.77 | 14.89 | 1762200.0 |
| 2003-03-20 | AAXN-DELISTED | Stock | 0.375 | 0.375 | 0.347499996423721 | 0.358333319425583 | 148800.0 |
| 2003-03-20 | ABAX-DELISTED | Stock | 3.51 | 3.66 | 3.4 | 3.6 | 17900.0 |
| 2003-03-20 | ABB-DELISTED | Stock | 2.65 | 2.75 | 2.61 | 2.69 | 160200.0 |
| 2003-03-20 | ABC-DELISTED | Stock | 13.1 | 13.1 | 12.66 | 12.96 | 4926000.0 |
| 2003-03-20 | ABCB | Stock | 11.153 | 11.469 | 11.1449 | 11.4204 | 13817.0 |
| 2003-03-20 | ABCO-DELISTED | Stock | 16.875 | 16.915 | 16.695 | 16.865 | 96432.0 |
| 2003-03-20 | ABCW-DELISTED | Stock | 22.59 | 22.75 | 22.12 | 22.67 | 22000.0 |
| 2003-03-20 | ABE-DELISTED | Stock | 5.33 | 5.41 | 5.33 | 5.4 | 54300.0 |
| 2003-03-20 | ABFS-DELISTED | Stock | 26.23 | 26.65 | 25.83 | 26.33 | 178883.0 |
| 2003-03-20 | ABG | Stock | 6.55 | 6.8 | 6.5 | 6.67 | 44300.0 |
| 2003-03-20 | ABK-DELISTED | Stock | 50.43 | 50.62 | 49.59 | 50.53 | 729900.0 |
| 2003-03-20 | ABM | Stock | 13.33 | 13.75 | 13.25 | 13.75 | 104900.0 |
| 2003-03-20 | ABMD-DELISTED | Stock | 3.78 | 4.0 | 3.78 | 4.0 | 44352.0 |
| 2003-03-20 | ABP-DELISTED | Stock | 0.8 | 0.8 | 0.75 | 0.79 | 62600.0 |
| 2003-03-20 | ABT | Stock | 16.8652 | 17.1076 | 16.6812 | 16.937 | 8093992.0 |
| 2003-03-20 | ABTL-DELISTED | Stock | 15.0 | 17.55 | 15.0 | 17.05 | 78600.0 |
| 2003-03-20 | ABV-DELISTED | Stock | 15.6 | 15.65 | 15.3 | 15.62 | 463900.0 |
| 2003-03-20 | ABVA-DELISTED | Stock | 13.1 | 13.1 | 13.1 | 13.1 | 1000.0 |
| 2003-03-20 | ABX-DELISTED | Stock | 15.24 | 15.28 | 14.96 | 15.01 | 1637300.0 |
| 2003-03-20 | ACAP-DELISTED | Stock | 20.31 | 20.5 | 19.68 | 20.5 | 51022.0 |
| 2003-03-20 | ACAS-DELISTED | Stock | 23.93 | 24.15 | 23.55 | 23.97 | 497129.0 |
| 2003-03-20 | ACAT-DELISTED | Stock | 15.04 | 15.75 | 15.0 | 15.68 | 32200.0 |
| 2003-03-20 | ACCL-DELISTED | Stock | 5.65000009536743 | 6.16900014877319 | 5.48199987411499 | 6.16200017929077 | 106900.0 |
| 2003-03-20 | ACE-DELISTED | Stock | 28.4 | 28.88 | 27.9 | 28.48 | 1203600.0 |
| 2003-03-20 | ACF-DELISTED | Stock | 3.07 | 3.27 | 2.77 | 3.16 | 3443000.0 |
| 2003-03-20 | ACG-DELISTED | Stock | 8.36 | 8.43 | 8.35 | 8.39 | 614500.0 |
| 2003-03-20 | ACGL | Stock | 3.6444 | 3.6778 | 3.5878 | 3.6667 | 1311300.0 |
| 2003-03-20 | ACGN-DELISTED | Stock | 816.0 | 906.6712 | 816.0 | 850.0 | 16600.0 |
| 2003-03-20 | ACH | Stock | 11.2667 | 11.3667 | 11.1 | 11.12 | 468750.0 |
| 2003-03-20 | ACH-DELISTED | Stock | 4.4545 | 4.4545 | 4.387 | 4.387 | 10400.0 |
| 2003-03-20 | ACLS | Stock | 20.2 | 21.4 | 19.76 | 21.12 | 359500.0 |
| 2003-03-20 | ACO-DELISTED | Stock | 5.75 | 5.95 | 5.55 | 5.94 | 26700.0 |
| 2003-03-20 | ACPW-DELISTED | Stock | 5.25 | 5.9 | 5.25 | 5.55 | 19288.0 |
| 2003-03-20 | ACS-DELISTED | Stock | 45.5 | 46.85 | 44.56 | 46.65 | 1212000.0 |
| 2003-03-20 | ACTA-DELISTED | Stock | 6.6 | 6.6 | 6.0 | 6.4 | 63900.0 |
| 2003-03-20 | ACTG | Stock | 1.28 | 1.37 | 1.16 | 1.17 | 72900.0 |
| 2003-03-20 | ACTI-DELISTED | Stock | 9.15 | 9.35 | 8.95 | 9.28 | 134845.0 |
| 2003-03-20 | ACTT-DELISTED | Stock | 1.15 | 1.25 | 1.1 | 1.23 | 16900.0 |
> showing 50 of 3,286 rows — these rows as CSV