PREVIEW / stock_daily / 2004-06-14
file: by_date/stock_daily/2004/2004-06-14.parquet size: 127 KB rows: 3,762 symbols: 2,347
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-06-14 | AAPL | Stock | 0.5473 | 0.5479 | 0.5268 | 0.5379 | 243986400.0 |
| 2004-06-14 | MSFT | Stock | 26.55 | 26.9 | 26.53 | 26.9 | 67377500.0 |
| 2004-06-14 | NVDA | Stock | 0.1724 | 0.1724 | 0.1666 | 0.1679 | 424752000.0 |
| 2004-06-14 | AMZN | Stock | 2.467 | 2.4995 | 2.452 | 2.4625 | 103618000.0 |
| 2004-06-14 | CL | Stock | 28.9 | 29.06 | 28.885 | 29.05 | 2415200.0 |
| 2004-06-14 | A | Stock | 18.7768 | 18.7768 | 18.4192 | 18.4621 | 3486332.0 |
| 2004-06-14 | AABA-DELISTED | Stock | 32.1800003051758 | 32.2400016784668 | 31.4400005340576 | 31.6499996185303 | 11766900.0 |
| 2004-06-14 | AACC-DELISTED | Stock | 19.15 | 19.21 | 18.4 | 18.65 | 48548.0 |
| 2004-06-14 | AAI-DELISTED | Stock | 13.7 | 13.84 | 13.55 | 13.69 | 1008700.0 |
| 2004-06-14 | AAIC-DELISTED | Stock | 385.0 | 385.0 | 376.0 | 376.8 | 1340900.0 |
| 2004-06-14 | AAME | Stock | 2.75 | 2.81 | 2.71 | 2.71 | 1800.0 |
| 2004-06-14 | AAON | Stock | 2.6311 | 2.6311 | 2.5442 | 2.5442 | 229331.0 |
| 2004-06-14 | AAP | Stock | 28.66 | 28.9333 | 28.4667 | 28.9067 | 574350.0 |
| 2004-06-14 | AAV-DELISTED | Stock | 13.27 | 13.36 | 13.13 | 13.27 | 36500.0 |
| 2004-06-14 | AAXN-DELISTED | Stock | 12.8999996185303 | 13.5649995803833 | 12.7849998474121 | 12.8850002288818 | 6053600.0 |
| 2004-06-14 | ABAX-DELISTED | Stock | 19.31 | 19.58 | 18.52 | 19.11 | 125922.0 |
| 2004-06-14 | ABB-DELISTED | Stock | 5.4 | 5.5 | 5.35 | 5.44 | 286200.0 |
| 2004-06-14 | ABC-DELISTED | Stock | 15.17 | 15.21 | 14.99 | 15.06 | 3478400.0 |
| 2004-06-14 | ABCB | Stock | 16.162 | 16.162 | 15.9838 | 15.9838 | 17643.0 |
| 2004-06-14 | ABCO-DELISTED | Stock | 17.43 | 17.475 | 17.18 | 17.34 | 179566.0 |
| 2004-06-14 | ABCW-DELISTED | Stock | 25.54 | 25.54 | 24.65 | 24.65 | 65870.0 |
| 2004-06-14 | ABE-DELISTED | Stock | 7.64 | 7.67 | 7.6 | 7.67 | 10400.0 |
| 2004-06-14 | ABFS-DELISTED | Stock | 30.65 | 31.08 | 30.3 | 30.54 | 147376.0 |
| 2004-06-14 | ABG | Stock | 14.4 | 15.09 | 14.04 | 14.6 | 134800.0 |
| 2004-06-14 | ABK-DELISTED | Stock | 69.25 | 70.19 | 69.22 | 69.52 | 528100.0 |
| 2004-06-14 | ABM | Stock | 18.3 | 18.3 | 17.98 | 18.0 | 322500.0 |
| 2004-06-14 | ABMD-DELISTED | Stock | 13.15 | 13.17 | 12.3 | 12.94 | 99458.0 |
| 2004-06-14 | ABP-DELISTED | Stock | 1.51 | 1.6 | 1.5 | 1.57 | 85600.0 |
| 2004-06-14 | ABR | Stock | 19.6 | 20.0 | 19.49 | 20.0 | 268500.0 |
| 2004-06-14 | ABT | Stock | 20.3435 | 20.5594 | 20.2859 | 20.4347 | 6905377.0 |
| 2004-06-14 | ABTL-DELISTED | Stock | 45.95 | 46.05 | 43.65 | 43.65 | 124800.0 |
| 2004-06-14 | ABV-DELISTED | Stock | 18.88 | 18.97 | 18.75 | 18.77 | 636400.0 |
| 2004-06-14 | ABVA-DELISTED | Stock | 15.05 | 15.15 | 15.05 | 15.06 | 5860.0 |
| 2004-06-14 | ABX-DELISTED | Stock | 18.95 | 19.09 | 18.64 | 18.76 | 1883100.0 |
| 2004-06-14 | ACAD | Stock | 6.15 | 6.23 | 6.05 | 6.2 | 45600.0 |
| 2004-06-14 | ACAP-DELISTED | Stock | 23.03 | 23.3 | 22.82 | 22.95 | 21321.0 |
| 2004-06-14 | ACAS-DELISTED | Stock | 27.0 | 27.0 | 26.28 | 26.45 | 465319.0 |
| 2004-06-14 | ACAT-DELISTED | Stock | 23.58 | 23.58 | 22.89 | 23.0 | 80248.0 |
| 2004-06-14 | ACCL-DELISTED | Stock | 8.65 | 8.9 | 8.32 | 8.34 | 90154.0 |
| 2004-06-14 | ACE-DELISTED | Stock | 41.65 | 41.95 | 41.53 | 41.72 | 931500.0 |
| 2004-06-14 | ACF-DELISTED | Stock | 17.74 | 17.76 | 17.41 | 17.45 | 851700.0 |
| 2004-06-14 | ACG-DELISTED | Stock | 7.81 | 7.83 | 7.65 | 7.66 | 387000.0 |
| 2004-06-14 | ACGL | Stock | 4.3778 | 4.3978 | 4.32 | 4.3611 | 484200.0 |
| 2004-06-14 | ACGN-DELISTED | Stock | 770.6712 | 782.0 | 725.3288 | 725.3288 | 24400.0 |
| 2004-06-14 | ACH | Stock | 16.3 | 16.42 | 16.0667 | 16.1067 | 264750.0 |
| 2004-06-14 | ACH-DELISTED | Stock | 13.15 | 13.185 | 12.76 | 12.775 | 444073.0 |
| 2004-06-14 | ACLS | Stock | 46.8 | 47.12 | 44.0 | 44.56 | 303225.0 |
| 2004-06-14 | ACO-DELISTED | Stock | 16.75 | 16.75 | 16.06 | 16.31 | 74500.0 |
| 2004-06-14 | ACPW-DELISTED | Stock | 16.5 | 17.0 | 15.85 | 16.1 | 23729.0 |
| 2004-06-14 | ACS-DELISTED | Stock | 49.52 | 49.6 | 48.76 | 48.91 | 1022800.0 |
> showing 50 of 3,762 rows — these rows as CSV