PREVIEW / stock_daily / 2004-01-28
file: by_date/stock_daily/2004/2004-01-28.parquet size: 124 KB rows: 3,642 symbols: 2,273
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-01-28 | AAPL | Stock | 0.4079 | 0.4175 | 0.4002 | 0.4021 | 275402400.0 |
| 2004-01-28 | MSFT | Stock | 28.3 | 28.44 | 27.47 | 27.71 | 71336000.0 |
| 2004-01-28 | NVDA | Stock | 0.191 | 0.194 | 0.1871 | 0.1881 | 615204000.0 |
| 2004-01-28 | AMZN | Stock | 2.682 | 2.7225 | 2.581 | 2.598 | 431626000.0 |
| 2004-01-28 | CL | Stock | 25.525 | 25.6 | 25.395 | 25.425 | 7475800.0 |
| 2004-01-28 | A | Stock | 25.9871 | 26.2947 | 25.7153 | 25.7153 | 7704378.0 |
| 2004-01-28 | AABA-DELISTED | Stock | 23.5200004577637 | 23.6499996185303 | 22.7950000762939 | 23.0949993133545 | 16625200.0 |
| 2004-01-28 | AAI-DELISTED | Stock | 12.75 | 12.94 | 12.46 | 12.5 | 1852900.0 |
| 2004-01-28 | AAIC-DELISTED | Stock | 505.0 | 505.0 | 479.0 | 479.0 | 1092000.0 |
| 2004-01-28 | AAME | Stock | 3.15 | 3.25 | 3.14 | 3.16 | 31700.0 |
| 2004-01-28 | AAON | Stock | 2.6653 | 2.8168 | 2.6653 | 2.7549 | 107831.0 |
| 2004-01-28 | AAP | Stock | 27.3 | 27.3667 | 26.5267 | 26.5667 | 700800.0 |
| 2004-01-28 | AAXN-DELISTED | Stock | 11.1083335876465 | 11.6533336639404 | 10.5333337783813 | 10.8649997711182 | 17356800.0 |
| 2004-01-28 | ABAX-DELISTED | Stock | 20.77 | 22.85 | 19.55 | 19.89 | 1322389.0 |
| 2004-01-28 | ABB-DELISTED | Stock | 6.02 | 6.1 | 5.89 | 5.9 | 154300.0 |
| 2004-01-28 | ABC-DELISTED | Stock | 14.24 | 14.24 | 13.9 | 13.94 | 4250000.0 |
| 2004-01-28 | ABCB | Stock | 15.003 | 15.003 | 14.6058 | 14.6626 | 31954.0 |
| 2004-01-28 | ABCO-DELISTED | Stock | 18.28 | 18.49 | 17.945 | 17.945 | 363843.0 |
| 2004-01-28 | ABCW-DELISTED | Stock | 26.26 | 26.49 | 25.9 | 26.0 | 113600.0 |
| 2004-01-28 | ABE-DELISTED | Stock | 8.38 | 8.52 | 8.1 | 8.16 | 79900.0 |
| 2004-01-28 | ABFS-DELISTED | Stock | 29.98 | 29.98 | 29.0 | 29.1 | 176187.0 |
| 2004-01-28 | ABG | Stock | 18.7 | 18.71 | 17.5 | 17.7 | 25700.0 |
| 2004-01-28 | ABK-DELISTED | Stock | 73.11 | 74.5 | 72.03 | 72.15 | 826000.0 |
| 2004-01-28 | ABM | Stock | 18.29 | 18.53 | 18.29 | 18.32 | 76900.0 |
| 2004-01-28 | ABMD-DELISTED | Stock | 8.35 | 8.35 | 7.56 | 7.56 | 59967.0 |
| 2004-01-28 | ABP-DELISTED | Stock | 2.0 | 2.49 | 1.85 | 2.4 | 4280800.0 |
| 2004-01-28 | ABT | Stock | 19.5182 | 19.792 | 19.5182 | 19.6619 | 10579173.0 |
| 2004-01-28 | ABTL-DELISTED | Stock | 64.95 | 65.0 | 55.4 | 57.55 | 190000.0 |
| 2004-01-28 | ABV-DELISTED | Stock | 26.42 | 26.42 | 25.1 | 25.17 | 560200.0 |
| 2004-01-28 | ABVA-DELISTED | Stock | 18.36 | 18.5 | 18.15 | 18.15 | 1754.0 |
| 2004-01-28 | ABVT-DELISTED | Stock | 55.5 | 57.0 | 54.5 | 55.5 | 87900.0 |
| 2004-01-28 | ABX-DELISTED | Stock | 20.4 | 20.81 | 19.69 | 19.71 | 4257800.0 |
| 2004-01-28 | ACAP-DELISTED | Stock | 19.0 | 19.0 | 18.73 | 18.91 | 20600.0 |
| 2004-01-28 | ACAS-DELISTED | Stock | 32.98 | 33.25 | 32.68 | 32.68 | 821568.0 |
| 2004-01-28 | ACAT-DELISTED | Stock | 26.54 | 27.0 | 25.57 | 25.74 | 35357.0 |
| 2004-01-28 | ACCL-DELISTED | Stock | 14.5256996154785 | 15.1049995422363 | 13.3526000976563 | 15.1049995422363 | 526900.0 |
| 2004-01-28 | ACE-DELISTED | Stock | 43.43 | 43.82 | 42.6 | 42.9 | 1120800.0 |
| 2004-01-28 | ACF-DELISTED | Stock | 18.15 | 18.3 | 16.89 | 16.9 | 2871800.0 |
| 2004-01-28 | ACG-DELISTED | Stock | 8.85 | 8.89 | 8.8 | 8.84 | 630900.0 |
| 2004-01-28 | ACGL | Stock | 4.9844 | 5.0211 | 4.9611 | 5.0067 | 1424700.0 |
| 2004-01-28 | ACGN-DELISTED | Stock | 1314.6712 | 1348.6712 | 1258.0 | 1303.3288 | 129400.0 |
| 2004-01-28 | ACH | Stock | 16.0 | 16.0667 | 15.2333 | 15.34 | 280350.0 |
| 2004-01-28 | ACH-DELISTED | Stock | 17.414 | 17.552 | 16.884 | 16.949 | 410667.0 |
| 2004-01-28 | ACLS | Stock | 46.04 | 47.0 | 43.0 | 43.72 | 528675.0 |
| 2004-01-28 | ACO-DELISTED | Stock | 22.1 | 22.19 | 21.22 | 21.26 | 385400.0 |
| 2004-01-28 | ACPW-DELISTED | Stock | 19.167 | 19.849 | 16.891 | 17.7 | 78252.0 |
| 2004-01-28 | ACS-DELISTED | Stock | 54.16 | 54.98 | 53.93 | 54.16 | 2221500.0 |
| 2004-01-28 | ACTA-DELISTED | Stock | 9.6 | 9.8 | 9.2 | 9.4 | 1904700.0 |
| 2004-01-28 | ACTG | Stock | 6.7 | 6.74 | 6.0 | 6.16 | 105200.0 |
| 2004-01-28 | ACTI-DELISTED | Stock | 7.75 | 7.75 | 7.65 | 7.7 | 241916.0 |
> showing 50 of 3,642 rows — these rows as CSV