PREVIEW / stock_daily / 2004-08-16
file: by_date/stock_daily/2004/2004-08-16.parquet size: 127 KB rows: 3,803 symbols: 2,373
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-08-16 | AAPL | Stock | 0.5536 | 0.5664 | 0.5471 | 0.5496 | 435674400.0 |
| 2004-08-16 | MSFT | Stock | 27.03 | 27.2 | 26.96 | 27.09 | 54347200.0 |
| 2004-08-16 | NVDA | Stock | 0.0865 | 0.0888 | 0.086 | 0.0867 | 531732000.0 |
| 2004-08-16 | AMZN | Stock | 1.807 | 1.92 | 1.799 | 1.8975 | 163286000.0 |
| 2004-08-16 | CL | Stock | 25.93 | 26.24 | 25.795 | 25.975 | 2628800.0 |
| 2004-08-16 | A | Stock | 14.5565 | 14.9142 | 14.5494 | 14.8212 | 3200162.0 |
| 2004-08-16 | AABA-DELISTED | Stock | 27.3899993896484 | 28.7700004577637 | 27.2999992370605 | 28.25 | 15923600.0 |
| 2004-08-16 | AACC-DELISTED | Stock | 16.62 | 17.63 | 16.62 | 17.63 | 22577.0 |
| 2004-08-16 | AAI-DELISTED | Stock | 10.25 | 10.7 | 10.25 | 10.6 | 1126500.0 |
| 2004-08-16 | AAIC-DELISTED | Stock | 323.0 | 332.0 | 320.2 | 331.2 | 1507800.0 |
| 2004-08-16 | AAME | Stock | 2.89 | 3.02 | 2.88 | 3.0 | 14000.0 |
| 2004-08-16 | AAON | Stock | 2.2255 | 2.2808 | 2.1821 | 2.2374 | 213384.0 |
| 2004-08-16 | AAP | Stock | 22.3333 | 22.8267 | 22.24 | 22.76 | 1708950.0 |
| 2004-08-16 | AAV-DELISTED | Stock | 14.42 | 14.42 | 14.25 | 14.42 | 30200.0 |
| 2004-08-16 | AAXN-DELISTED | Stock | 13.1300001144409 | 13.3599996566772 | 12.8800001144409 | 12.9499998092651 | 4834200.0 |
| 2004-08-16 | ABAX-DELISTED | Stock | 13.68 | 13.69 | 13.0 | 13.35 | 65845.0 |
| 2004-08-16 | ABB-DELISTED | Stock | 5.34 | 5.48 | 5.34 | 5.43 | 165000.0 |
| 2004-08-16 | ABC-DELISTED | Stock | 12.48 | 12.93 | 12.4 | 12.88 | 5954400.0 |
| 2004-08-16 | ABCB | Stock | 14.0141 | 14.1114 | 13.9655 | 14.1114 | 5675.0 |
| 2004-08-16 | ABCO-DELISTED | Stock | 15.255 | 15.49 | 15.075 | 15.3 | 88828.0 |
| 2004-08-16 | ABCW-DELISTED | Stock | 24.95 | 25.32 | 24.7 | 25.11 | 51590.0 |
| 2004-08-16 | ABE-DELISTED | Stock | 7.4 | 7.5 | 7.4 | 7.5 | 9600.0 |
| 2004-08-16 | ABFS-DELISTED | Stock | 35.2 | 36.23 | 35.03 | 36.23 | 220319.0 |
| 2004-08-16 | ABG | Stock | 13.26 | 13.34 | 13.13 | 13.2 | 18100.0 |
| 2004-08-16 | ABK-DELISTED | Stock | 70.4 | 71.28 | 70.36 | 71.0 | 275200.0 |
| 2004-08-16 | ABM | Stock | 16.9 | 17.65 | 16.9 | 17.65 | 85700.0 |
| 2004-08-16 | ABMD-DELISTED | Stock | 9.85 | 9.95 | 9.52 | 9.75 | 62629.0 |
| 2004-08-16 | ABP-DELISTED | Stock | 1.67 | 1.67 | 1.59 | 1.6 | 98200.0 |
| 2004-08-16 | ABR | Stock | 19.4 | 19.5 | 19.29 | 19.37 | 14100.0 |
| 2004-08-16 | ABT | Stock | 19.0481 | 19.288 | 18.9377 | 19.192 | 7235306.0 |
| 2004-08-16 | ABTL-DELISTED | Stock | 31.45 | 35.8 | 31.4 | 35.55 | 50500.0 |
| 2004-08-16 | ABV-DELISTED | Stock | 21.73 | 22.13 | 21.7 | 22.06 | 517300.0 |
| 2004-08-16 | ABVA-DELISTED | Stock | 15.0 | 15.01 | 15.0 | 15.01 | 3500.0 |
| 2004-08-16 | ABVT-DELISTED | Stock | 23.0 | 27.5 | 23.0 | 27.5 | 400.0 |
| 2004-08-16 | ABX-DELISTED | Stock | 18.85 | 19.08 | 18.82 | 19.07 | 1112944.0 |
| 2004-08-16 | ACAD | Stock | 5.16 | 5.47 | 5.14 | 5.28 | 3600.0 |
| 2004-08-16 | ACAP-DELISTED | Stock | 27.1 | 27.63 | 26.96 | 27.25 | 44242.0 |
| 2004-08-16 | ACAS-DELISTED | Stock | 30.81 | 31.05 | 30.7 | 31.0 | 420061.0 |
| 2004-08-16 | ACAT-DELISTED | Stock | 26.29 | 26.34 | 25.91 | 26.06 | 44493.0 |
| 2004-08-16 | ACC-DELISTED | Stock | 17.54 | 17.54 | 17.5 | 17.5 | 677100.0 |
| 2004-08-16 | ACCL-DELISTED | Stock | 5.55 | 6.16 | 5.54 | 6.0 | 142523.0 |
| 2004-08-16 | ACE-DELISTED | Stock | 38.25 | 39.19 | 38.25 | 39.08 | 1233308.0 |
| 2004-08-16 | ACF-DELISTED | Stock | 19.65 | 20.45 | 19.57 | 20.3 | 1139000.0 |
| 2004-08-16 | ACG-DELISTED | Stock | 8.29 | 8.32 | 8.26 | 8.32 | 445800.0 |
| 2004-08-16 | ACGL | Stock | 4.1756 | 4.2244 | 4.1667 | 4.2078 | 950400.0 |
| 2004-08-16 | ACGN-DELISTED | Stock | 612.0 | 612.0 | 612.0 | 612.0 | 7000.0 |
| 2004-08-16 | ACH | Stock | 15.8733 | 16.42 | 15.8733 | 16.2667 | 179100.0 |
| 2004-08-16 | ACH-DELISTED | Stock | 10.615 | 10.838 | 10.602 | 10.823 | 581093.0 |
| 2004-08-16 | ACLS | Stock | 31.48 | 32.4 | 30.88 | 32.0 | 167200.0 |
| 2004-08-16 | ACO-DELISTED | Stock | 17.7 | 18.07 | 17.4 | 17.93 | 141400.0 |
> showing 50 of 3,803 rows — these rows as CSV