PREVIEW / stock_daily / 2004-07-19
file: by_date/stock_daily/2004/2004-07-19.parquet size: 127 KB rows: 3,789 symbols: 2,377
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-07-19 | AAPL | Stock | 0.5716 | 0.5754 | 0.5654 | 0.5709 | 533170400.0 |
| 2004-07-19 | MSFT | Stock | 27.62 | 28.26 | 27.6 | 27.95 | 60354500.0 |
| 2004-07-19 | NVDA | Stock | 0.1268 | 0.1293 | 0.1251 | 0.1279 | 461088000.0 |
| 2004-07-19 | AMZN | Stock | 2.363 | 2.363 | 2.2575 | 2.301 | 196942000.0 |
| 2004-07-19 | CL | Stock | 28.21 | 28.31 | 28.005 | 28.065 | 1835200.0 |
| 2004-07-19 | A | Stock | 18.0329 | 18.3405 | 17.8898 | 18.0258 | 2576374.0 |
| 2004-07-19 | AABA-DELISTED | Stock | 28.8999996185303 | 29.0 | 27.5400009155273 | 28.1100006103516 | 32020300.0 |
| 2004-07-19 | AACC-DELISTED | Stock | 15.95 | 16.39 | 15.24 | 16.29 | 68519.0 |
| 2004-07-19 | AAI-DELISTED | Stock | 11.88 | 11.97 | 11.45 | 11.78 | 1316100.0 |
| 2004-07-19 | AAIC-DELISTED | Stock | 344.0 | 344.2 | 329.6 | 337.4 | 2104300.0 |
| 2004-07-19 | AAME | Stock | 2.84 | 2.98 | 2.84 | 2.9 | 5100.0 |
| 2004-07-19 | AAON | Stock | 2.3941 | 2.4494 | 2.3348 | 2.3967 | 290841.0 |
| 2004-07-19 | AAP | Stock | 25.1133 | 25.18 | 23.86 | 23.9 | 2466000.0 |
| 2004-07-19 | AAV-DELISTED | Stock | 14.77 | 14.84 | 14.68 | 14.77 | 11500.0 |
| 2004-07-19 | AAXN-DELISTED | Stock | 18.8199996948242 | 19.3050003051758 | 18.1399993896484 | 18.1599998474121 | 27454000.0 |
| 2004-07-19 | ABAX-DELISTED | Stock | 15.36 | 15.58 | 14.9 | 14.96 | 169817.0 |
| 2004-07-19 | ABB-DELISTED | Stock | 5.24 | 5.29 | 5.13 | 5.24 | 492700.0 |
| 2004-07-19 | ABC-DELISTED | Stock | 13.25 | 13.4 | 13.18 | 13.33 | 3134000.0 |
| 2004-07-19 | ABCB | Stock | 15.1002 | 15.1651 | 15.0192 | 15.0273 | 9377.0 |
| 2004-07-19 | ABCO-DELISTED | Stock | 15.645 | 15.92 | 15.515 | 15.68 | 211561.0 |
| 2004-07-19 | ABCW-DELISTED | Stock | 25.63 | 26.1 | 25.24 | 25.24 | 60490.0 |
| 2004-07-19 | ABE-DELISTED | Stock | 7.81 | 7.83 | 7.8 | 7.8 | 17300.0 |
| 2004-07-19 | ABFS-DELISTED | Stock | 31.82 | 32.1 | 31.51 | 31.51 | 148050.0 |
| 2004-07-19 | ABG | Stock | 12.7 | 13.15 | 12.54 | 12.82 | 40300.0 |
| 2004-07-19 | ABK-DELISTED | Stock | 71.12 | 71.3 | 70.6 | 70.72 | 590500.0 |
| 2004-07-19 | ABM | Stock | 18.4 | 18.59 | 18.29 | 18.47 | 111000.0 |
| 2004-07-19 | ABMD-DELISTED | Stock | 10.16 | 11.0 | 10.02 | 10.94 | 114581.0 |
| 2004-07-19 | ABP-DELISTED | Stock | 1.35 | 1.37 | 1.3 | 1.33 | 50000.0 |
| 2004-07-19 | ABR | Stock | 19.28 | 19.51 | 19.25 | 19.51 | 2400.0 |
| 2004-07-19 | ABT | Stock | 18.8609 | 18.9665 | 18.6594 | 18.7746 | 5950604.0 |
| 2004-07-19 | ABTL-DELISTED | Stock | 34.5 | 35.0 | 32.1 | 34.15 | 125400.0 |
| 2004-07-19 | ABV-DELISTED | Stock | 21.9 | 21.9 | 21.6 | 21.61 | 375900.0 |
| 2004-07-19 | ABVA-DELISTED | Stock | 15.27 | 15.27 | 15.14 | 15.2 | 2900.0 |
| 2004-07-19 | ABVT-DELISTED | Stock | 26.0 | 29.0 | 25.0 | 29.0 | 1600.0 |
| 2004-07-19 | ABX-DELISTED | Stock | 20.44 | 20.67 | 20.12 | 20.36 | 1107100.0 |
| 2004-07-19 | ACAD | Stock | 6.05 | 6.3 | 6.0 | 6.03 | 5400.0 |
| 2004-07-19 | ACAP-DELISTED | Stock | 24.14 | 24.14 | 23.26 | 23.65 | 24227.0 |
| 2004-07-19 | ACAS-DELISTED | Stock | 28.63 | 28.98 | 28.56 | 28.96 | 762624.0 |
| 2004-07-19 | ACAT-DELISTED | Stock | 25.05 | 26.23 | 24.88 | 25.77 | 61470.0 |
| 2004-07-19 | ACCL-DELISTED | Stock | 8.01 | 8.1 | 7.76 | 7.771 | 128382.0 |
| 2004-07-19 | ACE-DELISTED | Stock | 42.23 | 42.32 | 41.5 | 41.9 | 1121500.0 |
| 2004-07-19 | ACF-DELISTED | Stock | 19.29 | 19.91 | 19.28 | 19.63 | 1137000.0 |
| 2004-07-19 | ACG-DELISTED | Stock | 8.1 | 8.14 | 8.1 | 8.11 | 594600.0 |
| 2004-07-19 | ACGL | Stock | 4.4111 | 4.4478 | 4.4111 | 4.4122 | 519300.0 |
| 2004-07-19 | ACGN-DELISTED | Stock | 634.6712 | 657.3288 | 634.6712 | 657.3288 | 33900.0 |
| 2004-07-19 | ACH | Stock | 16.36 | 16.6867 | 16.2267 | 16.6867 | 175950.0 |
| 2004-07-19 | ACH-DELISTED | Stock | 13.262 | 13.545 | 13.262 | 13.395 | 644400.0 |
| 2004-07-19 | ACLS | Stock | 37.88 | 38.48 | 37.44 | 37.92 | 214875.0 |
| 2004-07-19 | ACO-DELISTED | Stock | 19.17 | 19.45 | 17.6 | 18.59 | 271000.0 |
| 2004-07-19 | ACPW-DELISTED | Stock | 14.251 | 14.547 | 13.807 | 14.3 | 22601.0 |
> showing 50 of 3,789 rows — these rows as CSV