PREVIEW / stock_daily / 2004-04-28
file: by_date/stock_daily/2004/2004-04-28.parquet size: 126 KB rows: 3,706 symbols: 2,307
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-04-28 | AAPL | Stock | 0.4789 | 0.4823 | 0.4704 | 0.4723 | 231168000.0 |
| 2004-04-28 | MSFT | Stock | 27.01 | 27.05 | 26.47 | 26.56 | 72842200.0 |
| 2004-04-28 | NVDA | Stock | 0.1846 | 0.1874 | 0.1823 | 0.1837 | 468768000.0 |
| 2004-04-28 | AMZN | Stock | 2.381 | 2.4175 | 2.332 | 2.3485 | 122552000.0 |
| 2004-04-28 | CL | Stock | 28.435 | 28.435 | 28.125 | 28.2 | 3497800.0 |
| 2004-04-28 | A | Stock | 20.4578 | 20.5293 | 20.1216 | 20.2432 | 3082450.0 |
| 2004-04-28 | AABA-DELISTED | Stock | 28.8850002288818 | 29.1599998474121 | 27.875 | 27.9150009155273 | 20569400.0 |
| 2004-04-28 | AACC-DELISTED | Stock | 18.98 | 18.98 | 18.0 | 18.14 | 49120.0 |
| 2004-04-28 | AAI-DELISTED | Stock | 12.74 | 13.07 | 12.67 | 12.97 | 2495300.0 |
| 2004-04-28 | AAIC-DELISTED | Stock | 440.0 | 440.0 | 396.0 | 398.0 | 3936800.0 |
| 2004-04-28 | AAME | Stock | 2.86 | 2.86 | 2.83 | 2.83 | 8000.0 |
| 2004-04-28 | AAON | Stock | 2.6482 | 2.6838 | 2.6482 | 2.6614 | 82772.0 |
| 2004-04-28 | AAP | Stock | 29.3667 | 29.5933 | 28.9667 | 28.9867 | 720750.0 |
| 2004-04-28 | AAV-DELISTED | Stock | 14.29 | 14.45 | 14.22 | 14.29 | 51500.0 |
| 2004-04-28 | AAXN-DELISTED | Stock | 17.1424999237061 | 19.4375 | 16.8525009155273 | 17.1200008392334 | 44952800.0 |
| 2004-04-28 | ABAX-DELISTED | Stock | 22.32 | 22.33 | 21.36 | 21.56 | 249150.0 |
| 2004-04-28 | ABB-DELISTED | Stock | 6.28 | 6.28 | 5.97 | 5.98 | 481500.0 |
| 2004-04-28 | ABC-DELISTED | Stock | 14.59 | 14.66 | 14.41 | 14.42 | 3615600.0 |
| 2004-04-28 | ABCB | Stock | 15.7082 | 15.7163 | 15.538 | 15.5785 | 21221.0 |
| 2004-04-28 | ABCO-DELISTED | Stock | 17.335 | 17.385 | 17.16 | 17.355 | 721034.0 |
| 2004-04-28 | ABCW-DELISTED | Stock | 24.56 | 24.72 | 24.0 | 24.0 | 106590.0 |
| 2004-04-28 | ABE-DELISTED | Stock | 8.3 | 8.3 | 7.93 | 8.1 | 34000.0 |
| 2004-04-28 | ABFS-DELISTED | Stock | 27.75 | 27.75 | 26.9 | 27.0 | 112362.0 |
| 2004-04-28 | ABG | Stock | 16.65 | 16.65 | 16.18 | 16.39 | 25900.0 |
| 2004-04-28 | ABK-DELISTED | Stock | 71.2 | 71.3 | 69.97 | 70.07 | 364800.0 |
| 2004-04-28 | ABM | Stock | 18.4 | 18.47 | 18.18 | 18.25 | 96500.0 |
| 2004-04-28 | ABMD-DELISTED | Stock | 13.47 | 13.47 | 13.0 | 13.15 | 141995.0 |
| 2004-04-28 | ABP-DELISTED | Stock | 2.61 | 2.65 | 2.5 | 2.54 | 137400.0 |
| 2004-04-28 | ABT | Stock | 19.8369 | 19.8908 | 19.6888 | 19.819 | 10475587.0 |
| 2004-04-28 | ABTL-DELISTED | Stock | 48.25 | 49.5 | 46.3 | 47.0 | 201500.0 |
| 2004-04-28 | ABV-DELISTED | Stock | 18.9 | 19.02 | 18.6 | 18.7 | 1857000.0 |
| 2004-04-28 | ABVA-DELISTED | Stock | 15.51 | 15.55 | 15.08 | 15.28 | 13830.0 |
| 2004-04-28 | ABVT-DELISTED | Stock | 38.0 | 38.0 | 37.0 | 38.0 | 2800.0 |
| 2004-04-28 | ABX-DELISTED | Stock | 19.49 | 19.61 | 19.05 | 19.05 | 4082900.0 |
| 2004-04-28 | ACAP-DELISTED | Stock | 21.5 | 21.63 | 21.08 | 21.26 | 12187.0 |
| 2004-04-28 | ACAS-DELISTED | Stock | 27.34 | 27.54 | 26.79 | 27.04 | 709489.0 |
| 2004-04-28 | ACAT-DELISTED | Stock | 26.24 | 26.59 | 24.71 | 24.71 | 32736.0 |
| 2004-04-28 | ACCL-DELISTED | Stock | 18.67 | 18.98 | 17.6 | 18.0 | 176922.0 |
| 2004-04-28 | ACE-DELISTED | Stock | 43.22 | 44.6 | 43.2 | 44.39 | 2159400.0 |
| 2004-04-28 | ACF-DELISTED | Stock | 17.1 | 17.25 | 16.66 | 16.92 | 1339500.0 |
| 2004-04-28 | ACG-DELISTED | Stock | 7.83 | 7.95 | 7.83 | 7.92 | 693600.0 |
| 2004-04-28 | ACGL | Stock | 4.5656 | 4.5667 | 4.4856 | 4.5167 | 902700.0 |
| 2004-04-28 | ACGN-DELISTED | Stock | 952.0 | 997.3288 | 895.3288 | 952.0 | 451600.0 |
| 2004-04-28 | ACH | Stock | 17.0267 | 17.1067 | 16.3667 | 16.4267 | 306450.0 |
| 2004-04-28 | ACH-DELISTED | Stock | 15.786 | 15.786 | 14.785 | 14.853 | 1640473.0 |
| 2004-04-28 | ACLS | Stock | 42.0 | 44.32 | 39.48 | 43.36 | 1334625.0 |
| 2004-04-28 | ACO-DELISTED | Stock | 18.7 | 18.7 | 16.85 | 17.1 | 570700.0 |
| 2004-04-28 | ACPW-DELISTED | Stock | 17.45 | 17.7 | 15.0 | 16.3 | 110213.0 |
| 2004-04-28 | ACS-DELISTED | Stock | 49.0 | 49.28 | 48.21 | 48.4 | 1642200.0 |
| 2004-04-28 | ACTA-DELISTED | Stock | 6.0 | 6.4 | 5.6 | 5.8 | 724500.0 |
> showing 50 of 3,706 rows — these rows as CSV