PREVIEW / stock_daily / 2004-03-18
file: by_date/stock_daily/2004/2004-03-18.parquet size: 124 KB rows: 3,667 symbols: 2,289
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-03-18 | AAPL | Stock | 0.4632 | 0.4654 | 0.457 | 0.4584 | 321081600.0 |
| 2004-03-18 | MSFT | Stock | 24.96 | 25.03 | 24.58 | 24.89 | 123231000.0 |
| 2004-03-18 | NVDA | Stock | 0.1838 | 0.1892 | 0.1833 | 0.1869 | 528048000.0 |
| 2004-03-18 | AMZN | Stock | 2.1265 | 2.16 | 2.1105 | 2.1505 | 114486000.0 |
| 2004-03-18 | CL | Stock | 27.5 | 27.73 | 27.355 | 27.5 | 3092400.0 |
| 2004-03-18 | A | Stock | 22.3176 | 22.382 | 21.7954 | 21.8884 | 4859308.0 |
| 2004-03-18 | AABA-DELISTED | Stock | 22.3950004577637 | 22.6450004577637 | 22.1800003051758 | 22.5249996185303 | 20207200.0 |
| 2004-03-18 | AACC-DELISTED | Stock | 17.601 | 18.36 | 17.4 | 18.12 | 91506.0 |
| 2004-03-18 | AAI-DELISTED | Stock | 11.15 | 11.29 | 11.01 | 11.13 | 665400.0 |
| 2004-03-18 | AAIC-DELISTED | Stock | 542.0 | 555.0 | 541.0 | 553.0 | 1232800.0 |
| 2004-03-18 | AAME | Stock | 3.25 | 3.25 | 3.02 | 3.06 | 29200.0 |
| 2004-03-18 | AAON | Stock | 2.6588 | 2.6851 | 2.6403 | 2.643 | 30375.0 |
| 2004-03-18 | AAP | Stock | 26.6333 | 26.6733 | 26.3733 | 26.5333 | 548100.0 |
| 2004-03-18 | AAXN-DELISTED | Stock | 14.25 | 15.625 | 14.0749998092651 | 15.6000003814697 | 42148400.0 |
| 2004-03-18 | ABAX-DELISTED | Stock | 19.55 | 20.2 | 19.31 | 19.87 | 293460.0 |
| 2004-03-18 | ABB-DELISTED | Stock | 5.81 | 5.81 | 5.71 | 5.75 | 180600.0 |
| 2004-03-18 | ABC-DELISTED | Stock | 13.69 | 13.8 | 13.458 | 13.74 | 3986800.0 |
| 2004-03-18 | ABCB | Stock | 15.2462 | 15.3596 | 14.9949 | 15.1976 | 10486.0 |
| 2004-03-18 | ABCO-DELISTED | Stock | 17.005 | 17.1 | 16.965 | 16.985 | 176136.0 |
| 2004-03-18 | ABCW-DELISTED | Stock | 25.33 | 25.68 | 24.92 | 25.25 | 45080.0 |
| 2004-03-18 | ABE-DELISTED | Stock | 8.09 | 8.16 | 8.03 | 8.1 | 17500.0 |
| 2004-03-18 | ABFS-DELISTED | Stock | 26.925 | 27.0 | 26.54 | 26.87 | 165345.0 |
| 2004-03-18 | ABG | Stock | 17.1 | 17.19 | 17.0 | 17.05 | 18300.0 |
| 2004-03-18 | ABK-DELISTED | Stock | 73.85 | 75.09 | 73.37 | 74.9 | 501800.0 |
| 2004-03-18 | ABM | Stock | 18.05 | 18.1 | 17.65 | 17.9 | 88200.0 |
| 2004-03-18 | ABMD-DELISTED | Stock | 7.57 | 7.82 | 7.42 | 7.55 | 100940.0 |
| 2004-03-18 | ABP-DELISTED | Stock | 2.73 | 2.82 | 2.7 | 2.81 | 130700.0 |
| 2004-03-18 | ABT | Stock | 18.1266 | 18.2433 | 17.8752 | 17.9964 | 20121146.0 |
| 2004-03-18 | ABTL-DELISTED | Stock | 65.65 | 65.75 | 62.7 | 65.1 | 84600.0 |
| 2004-03-18 | ABV-DELISTED | Stock | 19.25 | 19.25 | 18.74 | 18.98 | 1142000.0 |
| 2004-03-18 | ABX-DELISTED | Stock | 22.0 | 22.5 | 22.0 | 22.18 | 3804600.0 |
| 2004-03-18 | ACAP-DELISTED | Stock | 21.26 | 21.41 | 21.08 | 21.25 | 7602.0 |
| 2004-03-18 | ACAS-DELISTED | Stock | 33.52 | 33.74 | 33.0 | 33.12 | 383797.0 |
| 2004-03-18 | ACAT-DELISTED | Stock | 25.2 | 25.65 | 23.88 | 24.0 | 42792.0 |
| 2004-03-18 | ACCL-DELISTED | Stock | 20.22 | 20.22 | 19.16 | 19.88 | 96241.0 |
| 2004-03-18 | ACE-DELISTED | Stock | 43.3 | 43.3 | 42.18 | 42.81 | 1519500.0 |
| 2004-03-18 | ACF-DELISTED | Stock | 18.33 | 18.59 | 17.93 | 18.17 | 842900.0 |
| 2004-03-18 | ACG-DELISTED | Stock | 8.71 | 8.74 | 8.69 | 8.71 | 552000.0 |
| 2004-03-18 | ACGL | Stock | 4.6556 | 4.7378 | 4.65 | 4.7322 | 495000.0 |
| 2004-03-18 | ACGN-DELISTED | Stock | 1246.6712 | 1269.3288 | 1224.0 | 1258.0 | 52500.0 |
| 2004-03-18 | ACH | Stock | 16.5333 | 16.5333 | 16.1667 | 16.3 | 278850.0 |
| 2004-03-18 | ACH-DELISTED | Stock | 20.75 | 20.87 | 20.31 | 20.38 | 345200.0 |
| 2004-03-18 | ACLS | Stock | 41.64 | 43.0 | 41.32 | 41.6 | 442625.0 |
| 2004-03-18 | ACO-DELISTED | Stock | 18.12 | 18.12 | 16.8 | 16.94 | 326900.0 |
| 2004-03-18 | ACPW-DELISTED | Stock | 17.35 | 17.45 | 16.3 | 16.35 | 19322.0 |
| 2004-03-18 | ACS-DELISTED | Stock | 49.93 | 50.36 | 49.8 | 50.14 | 1432300.0 |
| 2004-03-18 | ACTA-DELISTED | Stock | 7.6 | 7.8 | 7.4 | 7.8 | 553500.0 |
| 2004-03-18 | ACTG | Stock | 6.73 | 7.33 | 6.72 | 7.02 | 315300.0 |
| 2004-03-18 | ACTI-DELISTED | Stock | 6.19 | 6.45 | 6.19 | 6.34 | 175788.0 |
| 2004-03-18 | ACTT-DELISTED | Stock | 2.62 | 2.78 | 2.56 | 2.7 | 85964.0 |
> showing 50 of 3,667 rows — these rows as CSV