PREVIEW / stock_daily / 2004-06-28
file: by_date/stock_daily/2004/2004-06-28.parquet size: 127 KB rows: 3,754 symbols: 2,335
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-28 | AAPL | Stock | 0.6104 | 0.6105 | 0.5752 | 0.5802 | 521096800.0 |
| 2004-06-28 | MSFT | Stock | 28.6 | 28.75 | 28.17 | 28.28 | 77024100.0 |
| 2004-06-28 | NVDA | Stock | 0.1712 | 0.1717 | 0.1667 | 0.1673 | 299376000.0 |
| 2004-06-28 | AMZN | Stock | 2.619 | 2.702 | 2.61 | 2.6695 | 230078000.0 |
| 2004-06-28 | CL | Stock | 28.85 | 28.97 | 28.8 | 28.88 | 2393200.0 |
| 2004-06-28 | A | Stock | 21.1087 | 21.1087 | 20.6795 | 20.7082 | 4594387.0 |
| 2004-06-28 | AABA-DELISTED | Stock | 35.0800018310547 | 36.2700004577637 | 34.9799995422363 | 35.4799995422363 | 24739200.0 |
| 2004-06-28 | AACC-DELISTED | Stock | 16.6 | 16.86 | 14.72 | 15.87 | 386502.0 |
| 2004-06-28 | AAI-DELISTED | Stock | 15.17 | 15.56 | 13.8 | 13.9 | 4194900.0 |
| 2004-06-28 | AAIC-DELISTED | Stock | 413.2 | 418.6 | 399.8 | 401.4 | 1775200.0 |
| 2004-06-28 | AAME | Stock | 2.67 | 2.79 | 2.64 | 2.7 | 11700.0 |
| 2004-06-28 | AAON | Stock | 2.5916 | 2.6127 | 2.5455 | 2.61 | 141244.0 |
| 2004-06-28 | AAP | Stock | 30.7333 | 30.78 | 30.4267 | 30.6067 | 778050.0 |
| 2004-06-28 | AAV-DELISTED | Stock | 13.83 | 13.92 | 13.8 | 13.83 | 17500.0 |
| 2004-06-28 | AAXN-DELISTED | Stock | 22.9850006103516 | 24.2450008392334 | 21.0249996185303 | 21.4699993133545 | 126567200.0 |
| 2004-06-28 | ABAX-DELISTED | Stock | 19.65 | 19.67 | 18.5 | 18.55 | 221969.0 |
| 2004-06-28 | ABB-DELISTED | Stock | 5.69 | 5.69 | 5.56 | 5.63 | 1199000.0 |
| 2004-06-28 | ABC-DELISTED | Stock | 14.67 | 14.82 | 14.56 | 14.59 | 3532000.0 |
| 2004-06-28 | ABCB | Stock | 16.2026 | 16.4539 | 16.0567 | 16.2837 | 81180.0 |
| 2004-06-28 | ABCO-DELISTED | Stock | 17.963 | 18.013 | 17.692 | 17.837 | 165317.0 |
| 2004-06-28 | ABCW-DELISTED | Stock | 25.39 | 25.9 | 25.39 | 25.7 | 34660.0 |
| 2004-06-28 | ABE-DELISTED | Stock | 7.72 | 7.8 | 7.61 | 7.72 | 15100.0 |
| 2004-06-28 | ABFS-DELISTED | Stock | 32.06 | 32.1994 | 31.93 | 32.05 | 417028.0 |
| 2004-06-28 | ABG | Stock | 14.79 | 14.99 | 14.51 | 14.85 | 140600.0 |
| 2004-06-28 | ABK-DELISTED | Stock | 72.2 | 72.62 | 71.86 | 72.11 | 582100.0 |
| 2004-06-28 | ABM | Stock | 19.4 | 19.59 | 19.12 | 19.35 | 184300.0 |
| 2004-06-28 | ABMD-DELISTED | Stock | 14.0 | 14.63 | 13.88 | 14.06 | 270243.0 |
| 2004-06-28 | ABP-DELISTED | Stock | 1.66 | 1.69 | 1.63 | 1.67 | 72500.0 |
| 2004-06-28 | ABR | Stock | 20.05 | 20.05 | 19.65 | 19.74 | 18100.0 |
| 2004-06-28 | ABT | Stock | 19.5758 | 19.7438 | 19.4799 | 19.5662 | 9677157.0 |
| 2004-06-28 | ABTL-DELISTED | Stock | 46.4 | 46.4 | 44.25 | 44.55 | 56000.0 |
| 2004-06-28 | ABV-DELISTED | Stock | 19.8 | 19.82 | 19.63 | 19.7 | 529500.0 |
| 2004-06-28 | ABVA-DELISTED | Stock | 15.3 | 15.3 | 15.14 | 15.24 | 5150.0 |
| 2004-06-28 | ABVT-DELISTED | Stock | 29.0 | 29.0 | 29.0 | 29.0 | 100.0 |
| 2004-06-28 | ABX-DELISTED | Stock | 20.75 | 20.83 | 19.91 | 19.91 | 1442300.0 |
| 2004-06-28 | ACAD | Stock | 6.44 | 6.44 | 5.99 | 6.15 | 8100.0 |
| 2004-06-28 | ACAP-DELISTED | Stock | 23.74 | 23.81 | 23.5 | 23.52 | 70479.0 |
| 2004-06-28 | ACAS-DELISTED | Stock | 27.6 | 27.79 | 27.28 | 27.47 | 628491.0 |
| 2004-06-28 | ACAT-DELISTED | Stock | 25.64 | 26.66 | 25.55 | 26.28 | 85988.0 |
| 2004-06-28 | ACCL-DELISTED | Stock | 9.68 | 9.68 | 8.99 | 9.12 | 156213.0 |
| 2004-06-28 | ACE-DELISTED | Stock | 43.15 | 43.23 | 42.25 | 42.35 | 896600.0 |
| 2004-06-28 | ACF-DELISTED | Stock | 20.31 | 20.44 | 19.9 | 19.95 | 1308200.0 |
| 2004-06-28 | ACG-DELISTED | Stock | 7.89 | 7.91 | 7.87 | 7.9 | 428000.0 |
| 2004-06-28 | ACGL | Stock | 4.4211 | 4.4711 | 4.4033 | 4.4556 | 963000.0 |
| 2004-06-28 | ACGN-DELISTED | Stock | 702.6712 | 714.0 | 680.0 | 680.0 | 107400.0 |
| 2004-06-28 | ACH | Stock | 17.0 | 17.0267 | 16.8667 | 16.9267 | 195750.0 |
| 2004-06-28 | ACH-DELISTED | Stock | 13.443 | 13.445 | 13.205 | 13.245 | 1518654.0 |
| 2004-06-28 | ACLS | Stock | 48.2 | 48.64 | 46.84 | 47.04 | 134600.0 |
| 2004-06-28 | ACO-DELISTED | Stock | 18.48 | 18.71 | 17.99 | 18.12 | 133300.0 |
| 2004-06-28 | ACPW-DELISTED | Stock | 16.5 | 16.65 | 15.9 | 16.1 | 5710.0 |
> showing 50 of 3,754 rows — these rows as CSV