PREVIEW / stock_daily / 2004-06-18
file: by_date/stock_daily/2004/2004-06-18.parquet size: 127 KB rows: 3,741 symbols: 2,328
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-06-18 | AAPL | Stock | 0.5832 | 0.5966 | 0.5791 | 0.5877 | 406252000.0 |
| 2004-06-18 | MSFT | Stock | 27.77 | 28.5 | 27.7 | 28.35 | 134218700.0 |
| 2004-06-18 | NVDA | Stock | 0.1653 | 0.1692 | 0.1625 | 0.1647 | 534336000.0 |
| 2004-06-18 | AMZN | Stock | 2.472 | 2.514 | 2.47 | 2.48 | 88334000.0 |
| 2004-06-18 | CL | Stock | 29.18 | 29.36 | 29.075 | 29.19 | 1694600.0 |
| 2004-06-18 | A | Stock | 18.2904 | 18.7053 | 18.1545 | 18.5193 | 3634520.0 |
| 2004-06-18 | AABA-DELISTED | Stock | 32.1100006103516 | 32.8699989318848 | 31.9500007629395 | 32.0699996948242 | 15809400.0 |
| 2004-06-18 | AACC-DELISTED | Stock | 18.45 | 18.7 | 18.16 | 18.65 | 23086.0 |
| 2004-06-18 | AAI-DELISTED | Stock | 13.95 | 14.12 | 13.95 | 14.08 | 541700.0 |
| 2004-06-18 | AAIC-DELISTED | Stock | 405.0 | 406.0 | 399.0 | 402.0 | 1515600.0 |
| 2004-06-18 | AAME | Stock | 2.65 | 2.75 | 2.61 | 2.61 | 10100.0 |
| 2004-06-18 | AAON | Stock | 2.4994 | 2.5455 | 2.477 | 2.5034 | 337922.0 |
| 2004-06-18 | AAP | Stock | 29.5333 | 29.94 | 29.5 | 29.68 | 430800.0 |
| 2004-06-18 | AAV-DELISTED | Stock | 13.51 | 13.61 | 13.35 | 13.51 | 12700.0 |
| 2004-06-18 | AAXN-DELISTED | Stock | 12.4499998092651 | 13.2449998855591 | 12.375 | 12.8850002288818 | 8314600.0 |
| 2004-06-18 | ABAX-DELISTED | Stock | 19.75 | 19.81 | 19.49 | 19.75 | 269384.0 |
| 2004-06-18 | ABB-DELISTED | Stock | 5.51 | 5.58 | 5.46 | 5.52 | 469600.0 |
| 2004-06-18 | ABC-DELISTED | Stock | 15.02 | 15.02 | 14.9 | 14.93 | 3684000.0 |
| 2004-06-18 | ABCB | Stock | 16.0486 | 16.2269 | 15.8054 | 15.9595 | 42071.0 |
| 2004-06-18 | ABCO-DELISTED | Stock | 17.12 | 17.655 | 17.12 | 17.425 | 67814.0 |
| 2004-06-18 | ABCW-DELISTED | Stock | 25.04 | 25.49 | 24.85 | 25.39 | 68060.0 |
| 2004-06-18 | ABE-DELISTED | Stock | 7.6 | 7.67 | 7.55 | 7.66 | 12000.0 |
| 2004-06-18 | ABFS-DELISTED | Stock | 31.65 | 32.05 | 31.53 | 31.84 | 104223.0 |
| 2004-06-18 | ABG | Stock | 14.9 | 14.9 | 14.51 | 14.59 | 63600.0 |
| 2004-06-18 | ABK-DELISTED | Stock | 69.65 | 71.67 | 69.5 | 70.75 | 676500.0 |
| 2004-06-18 | ABM | Stock | 18.41 | 18.6 | 18.21 | 18.36 | 209100.0 |
| 2004-06-18 | ABMD-DELISTED | Stock | 12.99 | 13.0 | 12.71 | 12.79 | 131347.0 |
| 2004-06-18 | ABP-DELISTED | Stock | 1.83 | 1.83 | 1.67 | 1.69 | 92600.0 |
| 2004-06-18 | ABR | Stock | 20.45 | 20.95 | 20.45 | 20.95 | 21200.0 |
| 2004-06-18 | ABT | Stock | 20.7178 | 20.7561 | 20.5258 | 20.6314 | 8812005.0 |
| 2004-06-18 | ABTL-DELISTED | Stock | 43.75 | 44.25 | 42.7 | 43.85 | 68200.0 |
| 2004-06-18 | ABV-DELISTED | Stock | 19.11 | 19.42 | 18.98 | 19.42 | 351600.0 |
| 2004-06-18 | ABVA-DELISTED | Stock | 15.23 | 15.37 | 15.17 | 15.37 | 1150.0 |
| 2004-06-18 | ABVT-DELISTED | Stock | 27.0 | 28.99 | 24.0 | 28.99 | 1000.0 |
| 2004-06-18 | ABX-DELISTED | Stock | 20.02 | 20.18 | 19.64 | 19.82 | 2202500.0 |
| 2004-06-18 | ACAD | Stock | 6.95 | 6.95 | 6.51 | 6.62 | 15400.0 |
| 2004-06-18 | ACAP-DELISTED | Stock | 22.57 | 23.29 | 22.44 | 22.84 | 16121.0 |
| 2004-06-18 | ACAS-DELISTED | Stock | 26.85 | 27.05 | 26.66 | 26.96 | 461054.0 |
| 2004-06-18 | ACAT-DELISTED | Stock | 23.02 | 23.33 | 23.0 | 23.0 | 87939.0 |
| 2004-06-18 | ACCL-DELISTED | Stock | 8.58 | 8.75 | 8.28 | 8.49 | 570027.0 |
| 2004-06-18 | ACE-DELISTED | Stock | 42.56 | 43.27 | 42.36 | 42.44 | 1470976.0 |
| 2004-06-18 | ACF-DELISTED | Stock | 17.88 | 18.18 | 17.88 | 18.06 | 701300.0 |
| 2004-06-18 | ACG-DELISTED | Stock | 7.85 | 7.87 | 7.81 | 7.84 | 326000.0 |
| 2004-06-18 | ACGL | Stock | 4.3733 | 4.4522 | 4.3678 | 4.44 | 1089900.0 |
| 2004-06-18 | ACGN-DELISTED | Stock | 736.6712 | 759.3288 | 725.3288 | 748.0 | 87000.0 |
| 2004-06-18 | ACH | Stock | 16.4867 | 16.6933 | 16.46 | 16.6267 | 186900.0 |
| 2004-06-18 | ACH-DELISTED | Stock | 11.684 | 12.072 | 11.676 | 11.942 | 1526006.0 |
| 2004-06-18 | ACLS | Stock | 42.68 | 44.96 | 41.88 | 44.12 | 302025.0 |
| 2004-06-18 | ACO-DELISTED | Stock | 17.73 | 17.8 | 17.43 | 17.7 | 156400.0 |
| 2004-06-18 | ACPW-DELISTED | Stock | 15.75 | 15.9 | 15.5 | 15.6 | 6325.0 |
> showing 50 of 3,741 rows — these rows as CSV