PREVIEW / stock_daily / 2004-07-16
file: by_date/stock_daily/2004/2004-07-16.parquet size: 127 KB rows: 3,766 symbols: 2,347
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-16 | AAPL | Stock | 0.5857 | 0.5879 | 0.5736 | 0.575 | 488381600.0 |
| 2004-07-16 | MSFT | Stock | 28.18 | 28.2 | 27.25 | 27.48 | 66406300.0 |
| 2004-07-16 | NVDA | Stock | 0.1343 | 0.1345 | 0.1265 | 0.1265 | 464700000.0 |
| 2004-07-16 | AMZN | Stock | 2.4495 | 2.453 | 2.339 | 2.355 | 185738000.0 |
| 2004-07-16 | CL | Stock | 28.45 | 28.45 | 27.95 | 28.16 | 3262800.0 |
| 2004-07-16 | A | Stock | 18.5622 | 18.6695 | 18.0615 | 18.1044 | 2537230.0 |
| 2004-07-16 | AABA-DELISTED | Stock | 30.7199993133545 | 30.75 | 29.1499996185303 | 29.1900005340576 | 18654300.0 |
| 2004-07-16 | AACC-DELISTED | Stock | 16.38 | 16.48 | 15.57 | 15.87 | 62121.0 |
| 2004-07-16 | AAI-DELISTED | Stock | 12.3 | 12.37 | 11.85 | 11.85 | 1171500.0 |
| 2004-07-16 | AAIC-DELISTED | Stock | 352.8 | 358.0 | 344.0 | 344.0 | 1402100.0 |
| 2004-07-16 | AAME | Stock | 2.79 | 2.9 | 2.73 | 2.9 | 5100.0 |
| 2004-07-16 | AAON | Stock | 2.5376 | 2.5455 | 2.4678 | 2.4691 | 239203.0 |
| 2004-07-16 | AAP | Stock | 25.3467 | 25.5733 | 24.8267 | 24.9533 | 1311900.0 |
| 2004-07-16 | AAV-DELISTED | Stock | 14.7 | 14.86 | 14.66 | 14.7 | 15900.0 |
| 2004-07-16 | AAXN-DELISTED | Stock | 20.2950000762939 | 20.5249996185303 | 20.0699996948242 | 20.1200008392334 | 6696600.0 |
| 2004-07-16 | ABAX-DELISTED | Stock | 15.65 | 15.86 | 14.758 | 15.13 | 598985.0 |
| 2004-07-16 | ABB-DELISTED | Stock | 5.34 | 5.39 | 5.32 | 5.32 | 144700.0 |
| 2004-07-16 | ABC-DELISTED | Stock | 13.6 | 13.61 | 13.2 | 13.22 | 6296400.0 |
| 2004-07-16 | ABCB | Stock | 15.4245 | 15.4407 | 15.1002 | 15.1327 | 15052.0 |
| 2004-07-16 | ABCO-DELISTED | Stock | 16.383 | 16.478 | 15.677 | 15.717 | 161312.0 |
| 2004-07-16 | ABCW-DELISTED | Stock | 25.94 | 26.3 | 25.43 | 25.59 | 31850.0 |
| 2004-07-16 | ABE-DELISTED | Stock | 7.71 | 7.85 | 7.71 | 7.83 | 12300.0 |
| 2004-07-16 | ABFS-DELISTED | Stock | 31.9 | 32.4 | 31.63 | 31.76 | 293004.0 |
| 2004-07-16 | ABG | Stock | 13.2 | 13.2 | 12.6 | 12.63 | 38600.0 |
| 2004-07-16 | ABK-DELISTED | Stock | 71.62 | 71.87 | 71.03 | 71.04 | 458600.0 |
| 2004-07-16 | ABM | Stock | 18.67 | 18.79 | 18.45 | 18.51 | 83600.0 |
| 2004-07-16 | ABMD-DELISTED | Stock | 10.65 | 10.65 | 10.1 | 10.34 | 81641.0 |
| 2004-07-16 | ABP-DELISTED | Stock | 1.3 | 1.39 | 1.3 | 1.32 | 54700.0 |
| 2004-07-16 | ABR | Stock | 19.5 | 19.61 | 19.25 | 19.36 | 27800.0 |
| 2004-07-16 | ABT | Stock | 19.2304 | 19.2304 | 18.7314 | 18.7602 | 7990830.0 |
| 2004-07-16 | ABTL-DELISTED | Stock | 35.65 | 36.15 | 34.5 | 34.55 | 122200.0 |
| 2004-07-16 | ABV-DELISTED | Stock | 21.85 | 21.85 | 21.65 | 21.73 | 386200.0 |
| 2004-07-16 | ABVA-DELISTED | Stock | 15.479 | 15.48 | 15.35 | 15.48 | 4334.0 |
| 2004-07-16 | ABVT-DELISTED | Stock | 21.0 | 28.99 | 21.0 | 22.0 | 7100.0 |
| 2004-07-16 | ABX-DELISTED | Stock | 20.79 | 20.92 | 20.53 | 20.65 | 1390720.0 |
| 2004-07-16 | ACAD | Stock | 6.35 | 6.35 | 6.05 | 6.3 | 900.0 |
| 2004-07-16 | ACAP-DELISTED | Stock | 23.98 | 24.16 | 23.5 | 23.56 | 8519.0 |
| 2004-07-16 | ACAS-DELISTED | Stock | 28.84 | 29.05 | 28.71 | 28.81 | 467392.0 |
| 2004-07-16 | ACAT-DELISTED | Stock | 25.6 | 26.47 | 24.88 | 25.36 | 68295.0 |
| 2004-07-16 | ACCL-DELISTED | Stock | 8.56 | 8.87 | 7.99 | 8.01 | 102673.0 |
| 2004-07-16 | ACE-DELISTED | Stock | 42.86 | 42.86 | 42.21 | 42.29 | 952000.0 |
| 2004-07-16 | ACF-DELISTED | Stock | 19.53 | 19.7 | 19.17 | 19.25 | 973100.0 |
| 2004-07-16 | ACG-DELISTED | Stock | 8.07 | 8.12 | 8.07 | 8.11 | 466400.0 |
| 2004-07-16 | ACGL | Stock | 4.4456 | 4.4456 | 4.4111 | 4.4189 | 1277100.0 |
| 2004-07-16 | ACGN-DELISTED | Stock | 634.6712 | 657.3288 | 589.3288 | 634.6712 | 109800.0 |
| 2004-07-16 | ACH | Stock | 16.7733 | 16.7733 | 16.2 | 16.2933 | 194700.0 |
| 2004-07-16 | ACH-DELISTED | Stock | 13.008 | 13.163 | 13.008 | 13.085 | 545661.0 |
| 2004-07-16 | ACLS | Stock | 39.44 | 39.64 | 37.44 | 37.92 | 386125.0 |
| 2004-07-16 | ACO-DELISTED | Stock | 18.88 | 19.05 | 18.73 | 19.0 | 103400.0 |
| 2004-07-16 | ACPW-DELISTED | Stock | 14.5 | 15.0 | 14.5 | 14.6 | 9213.0 |
> showing 50 of 3,766 rows — these rows as CSV