PREVIEW / stock_daily / 2004-09-29
file: by_date/stock_daily/2004/2004-09-29.parquet size: 128 KB rows: 3,824 symbols: 2,383
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-29 | AAPL | Stock | 0.6773 | 0.6939 | 0.6754 | 0.6907 | 273509600.0 |
| 2004-09-29 | MSFT | Stock | 27.26 | 27.69 | 27.23 | 27.58 | 61529300.0 |
| 2004-09-29 | NVDA | Stock | 0.1166 | 0.1228 | 0.1151 | 0.1195 | 537228000.0 |
| 2004-09-29 | AMZN | Stock | 1.9725 | 2.046 | 1.968 | 2.042 | 198376000.0 |
| 2004-09-29 | CL | Stock | 22.69 | 22.855 | 22.64 | 22.75 | 8136600.0 |
| 2004-09-29 | A | Stock | 15.1645 | 15.794 | 15.1645 | 15.4578 | 3012410.0 |
| 2004-09-29 | AABA-DELISTED | Stock | 32.7799987792969 | 34.1500015258789 | 32.7700004577637 | 34.0 | 30183700.0 |
| 2004-09-29 | AACC-DELISTED | Stock | 16.99 | 17.05 | 16.85 | 17.01 | 40304.0 |
| 2004-09-29 | AAI-DELISTED | Stock | 10.06 | 10.42 | 9.85 | 10.38 | 1246500.0 |
| 2004-09-29 | AAIC-DELISTED | Stock | 383.0 | 389.8 | 381.6 | 384.0 | 860500.0 |
| 2004-09-29 | AAME | Stock | 3.15 | 3.15 | 3.05 | 3.1 | 1900.0 |
| 2004-09-29 | AAON | Stock | 2.2953 | 2.3506 | 2.2519 | 2.3072 | 97200.0 |
| 2004-09-29 | AAP | Stock | 23.3667 | 23.3933 | 23.1333 | 23.2667 | 1402050.0 |
| 2004-09-29 | AAV-DELISTED | Stock | 16.88 | 16.9 | 16.7 | 16.88 | 30200.0 |
| 2004-09-29 | AAXN-DELISTED | Stock | 17.9150009155273 | 18.9799995422363 | 17.3799991607666 | 18.2399997711182 | 13854400.0 |
| 2004-09-29 | ABAX-DELISTED | Stock | 13.11 | 13.55 | 13.1 | 13.43 | 268457.0 |
| 2004-09-29 | ABB-DELISTED | Stock | 6.13 | 6.18 | 6.1 | 6.16 | 177500.0 |
| 2004-09-29 | ABC-DELISTED | Stock | 13.6 | 13.62 | 13.5 | 13.57 | 3810400.0 |
| 2004-09-29 | ABCB | Stock | 16.0567 | 16.4133 | 16.0486 | 16.4133 | 18013.0 |
| 2004-09-29 | ABCO-DELISTED | Stock | 16.765 | 17.485 | 16.72 | 16.995 | 248197.0 |
| 2004-09-29 | ABCW-DELISTED | Stock | 25.73 | 25.95 | 25.56 | 25.95 | 59190.0 |
| 2004-09-29 | ABE-DELISTED | Stock | 7.93 | 7.99 | 7.89 | 7.95 | 14500.0 |
| 2004-09-29 | ABFS-DELISTED | Stock | 36.15 | 36.55 | 35.84 | 36.51 | 280548.0 |
| 2004-09-29 | ABG | Stock | 12.98 | 13.35 | 12.98 | 13.26 | 27300.0 |
| 2004-09-29 | ABK-DELISTED | Stock | 76.5 | 78.36 | 76.37 | 78.24 | 443900.0 |
| 2004-09-29 | ABM | Stock | 20.01 | 20.4 | 20.01 | 20.35 | 70200.0 |
| 2004-09-29 | ABMD-DELISTED | Stock | 9.19 | 9.25 | 9.02 | 9.24 | 90896.0 |
| 2004-09-29 | ABP-DELISTED | Stock | 2.37 | 2.37 | 2.02 | 2.2 | 174100.0 |
| 2004-09-29 | ABR | Stock | 21.1 | 22.15 | 21.1 | 21.99 | 50600.0 |
| 2004-09-29 | ABT | Stock | 20.3435 | 20.3483 | 20.1612 | 20.3003 | 5858900.0 |
| 2004-09-29 | ABTL-DELISTED | Stock | 44.85 | 44.85 | 43.1 | 44.3 | 37900.0 |
| 2004-09-29 | ABV-DELISTED | Stock | 22.5 | 22.5 | 22.15 | 22.41 | 148300.0 |
| 2004-09-29 | ABVA-DELISTED | Stock | 14.99 | 15.02 | 14.98 | 15.02 | 1000.0 |
| 2004-09-29 | ABVT-DELISTED | Stock | 24.0 | 24.0 | 23.0 | 24.0 | 1300.0 |
| 2004-09-29 | ABX-DELISTED | Stock | 20.35 | 20.53 | 20.22 | 20.5 | 2439914.0 |
| 2004-09-29 | ACAD | Stock | 7.98 | 8.0 | 7.6 | 7.8 | 87900.0 |
| 2004-09-29 | ACAP-DELISTED | Stock | 29.75 | 30.28 | 29.7 | 30.1 | 91381.0 |
| 2004-09-29 | ACAS-DELISTED | Stock | 31.57 | 31.67 | 31.37 | 31.39 | 686079.0 |
| 2004-09-29 | ACAT-DELISTED | Stock | 26.17 | 26.52 | 25.92 | 26.15 | 58841.0 |
| 2004-09-29 | ACC-DELISTED | Stock | 18.7 | 18.75 | 18.33 | 18.5 | 354700.0 |
| 2004-09-29 | ACCL-DELISTED | Stock | 6.21 | 6.72 | 6.05 | 6.6 | 510495.0 |
| 2004-09-29 | ACE-DELISTED | Stock | 38.78 | 38.95 | 38.12 | 38.85 | 1707300.0 |
| 2004-09-29 | ACF-DELISTED | Stock | 21.3 | 21.39 | 21.01 | 21.06 | 506400.0 |
| 2004-09-29 | ACG-DELISTED | Stock | 8.16 | 8.17 | 8.14 | 8.16 | 288300.0 |
| 2004-09-29 | ACGL | Stock | 4.1922 | 4.2022 | 4.1611 | 4.1667 | 5207400.0 |
| 2004-09-29 | ACGN-DELISTED | Stock | 736.6712 | 748.0 | 668.6712 | 702.6712 | 196200.0 |
| 2004-09-29 | ACH | Stock | 16.3333 | 16.7667 | 16.3267 | 16.7667 | 183450.0 |
| 2004-09-29 | ACH-DELISTED | Stock | 15.861 | 15.861 | 15.504 | 15.674 | 798505.0 |
| 2004-09-29 | ACLS | Stock | 32.0 | 33.4 | 31.64 | 33.2 | 152675.0 |
| 2004-09-29 | ACO-DELISTED | Stock | 18.89 | 19.28 | 18.74 | 18.91 | 110900.0 |
> showing 50 of 3,824 rows — these rows as CSV