PREVIEW / stock_daily / 2004-09-20
file: by_date/stock_daily/2004/2004-09-20.parquet size: 128 KB rows: 3,830 symbols: 2,389
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-20 | AAPL | Stock | 0.6586 | 0.6782 | 0.6584 | 0.6734 | 245000000.0 |
| 2004-09-20 | MSFT | Stock | 27.44 | 27.65 | 27.33 | 27.51 | 51513600.0 |
| 2004-09-20 | NVDA | Stock | 0.12 | 0.1257 | 0.1185 | 0.1222 | 794628000.0 |
| 2004-09-20 | AMZN | Stock | 2.1355 | 2.1995 | 2.1305 | 2.1635 | 184448000.0 |
| 2004-09-20 | CL | Stock | 24.76 | 24.76 | 24.045 | 24.115 | 31664800.0 |
| 2004-09-20 | A | Stock | 16.3305 | 16.8813 | 16.0944 | 16.6237 | 4229789.0 |
| 2004-09-20 | AABA-DELISTED | Stock | 32.8499984741211 | 34.0400009155273 | 32.8499984741211 | 33.2599983215332 | 18702200.0 |
| 2004-09-20 | AACC-DELISTED | Stock | 16.97 | 17.5 | 16.77 | 17.31 | 29716.0 |
| 2004-09-20 | AAI-DELISTED | Stock | 11.26 | 11.42 | 11.168 | 11.2 | 542000.0 |
| 2004-09-20 | AAIC-DELISTED | Stock | 404.0 | 404.0 | 396.0 | 402.2 | 1124900.0 |
| 2004-09-20 | AAME | Stock | 3.01 | 3.01 | 2.88 | 2.95 | 28300.0 |
| 2004-09-20 | AAON | Stock | 2.4415 | 2.4494 | 2.4415 | 2.4415 | 56953.0 |
| 2004-09-20 | AAP | Stock | 23.9 | 23.9467 | 23.5867 | 23.6267 | 682800.0 |
| 2004-09-20 | AAV-DELISTED | Stock | 15.83 | 15.86 | 15.58 | 15.83 | 19000.0 |
| 2004-09-20 | AAXN-DELISTED | Stock | 20.4500007629395 | 20.7250003814697 | 18.7250003814697 | 18.9449996948242 | 24628800.0 |
| 2004-09-20 | ABAX-DELISTED | Stock | 14.65 | 15.0 | 14.58 | 14.79 | 71612.0 |
| 2004-09-20 | ABB-DELISTED | Stock | 6.05 | 6.09 | 6.01 | 6.04 | 248000.0 |
| 2004-09-20 | ABC-DELISTED | Stock | 13.75 | 13.8 | 13.6 | 13.64 | 4586800.0 |
| 2004-09-20 | ABCB | Stock | 15.7568 | 15.773 | 15.4488 | 15.4488 | 8883.0 |
| 2004-09-20 | ABCO-DELISTED | Stock | 16.928 | 17.063 | 16.712 | 16.717 | 291381.0 |
| 2004-09-20 | ABCW-DELISTED | Stock | 26.0 | 26.0 | 25.59 | 25.6 | 20910.0 |
| 2004-09-20 | ABE-DELISTED | Stock | 8.0 | 8.01 | 7.92 | 7.98 | 20300.0 |
| 2004-09-20 | ABFS-DELISTED | Stock | 35.75 | 36.21 | 35.65 | 35.94 | 178473.0 |
| 2004-09-20 | ABG | Stock | 14.35 | 14.45 | 14.0 | 14.05 | 14500.0 |
| 2004-09-20 | ABK-DELISTED | Stock | 79.15 | 79.15 | 78.38 | 78.72 | 398200.0 |
| 2004-09-20 | ABM | Stock | 20.01 | 20.39 | 19.93 | 20.05 | 429000.0 |
| 2004-09-20 | ABMD-DELISTED | Stock | 10.55 | 10.69 | 10.45 | 10.55 | 71440.0 |
| 2004-09-20 | ABP-DELISTED | Stock | 1.82 | 1.85 | 1.82 | 1.83 | 49400.0 |
| 2004-09-20 | ABR | Stock | 21.14 | 21.25 | 20.95 | 21.0 | 14500.0 |
| 2004-09-20 | ABT | Stock | 20.5114 | 20.5978 | 20.3723 | 20.4347 | 5192997.0 |
| 2004-09-20 | ABTL-DELISTED | Stock | 42.3 | 43.2 | 41.7 | 42.8 | 57800.0 |
| 2004-09-20 | ABV-DELISTED | Stock | 22.5 | 22.64 | 22.15 | 22.24 | 819000.0 |
| 2004-09-20 | ABX-DELISTED | Stock | 19.24 | 19.52 | 19.24 | 19.35 | 975800.0 |
| 2004-09-20 | ACAD | Stock | 7.8 | 7.8 | 7.3 | 7.49 | 6900.0 |
| 2004-09-20 | ACAP-DELISTED | Stock | 30.69 | 31.08 | 30.1 | 30.25 | 42292.0 |
| 2004-09-20 | ACAS-DELISTED | Stock | 32.17 | 32.17 | 31.68 | 31.7 | 1170956.0 |
| 2004-09-20 | ACAT-DELISTED | Stock | 26.58 | 26.58 | 26.06 | 26.27 | 14544.0 |
| 2004-09-20 | ACC-DELISTED | Stock | 18.43 | 18.78 | 18.25 | 18.7 | 100400.0 |
| 2004-09-20 | ACCL-DELISTED | Stock | 6.38 | 6.5 | 6.25 | 6.3 | 56577.0 |
| 2004-09-20 | ACE-DELISTED | Stock | 39.96 | 40.05 | 39.59 | 39.83 | 804900.0 |
| 2004-09-20 | ACF-DELISTED | Stock | 20.9 | 21.46 | 20.83 | 21.46 | 999500.0 |
| 2004-09-20 | ACG-DELISTED | Stock | 8.14 | 8.17 | 8.13 | 8.14 | 443400.0 |
| 2004-09-20 | ACGL | Stock | 4.4389 | 4.4522 | 4.3978 | 4.4111 | 1254600.0 |
| 2004-09-20 | ACGN-DELISTED | Stock | 600.6712 | 600.6712 | 566.6712 | 578.0 | 46200.0 |
| 2004-09-20 | ACH | Stock | 16.8333 | 17.0267 | 16.7733 | 16.7733 | 73050.0 |
| 2004-09-20 | ACH-DELISTED | Stock | 15.5 | 15.623 | 15.288 | 15.623 | 1368782.0 |
| 2004-09-20 | ACLS | Stock | 33.76 | 35.12 | 32.8 | 34.52 | 273125.0 |
| 2004-09-20 | ACO-DELISTED | Stock | 18.2 | 18.5 | 18.05 | 18.23 | 169100.0 |
| 2004-09-20 | ACPW-DELISTED | Stock | 16.25 | 16.25 | 15.3 | 15.45 | 3753.0 |
| 2004-09-20 | ACS-DELISTED | Stock | 55.06 | 56.86 | 55.06 | 56.77 | 1273800.0 |
> showing 50 of 3,830 rows — these rows as CSV