PREVIEW / stock_daily / 2004-10-18
file: by_date/stock_daily/2004/2004-10-18.parquet size: 129 KB rows: 3,827 symbols: 2,388
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-10-18 | AAPL | Stock | 0.7982 | 0.8527 | 0.7982 | 0.8527 | 1200752000.0 |
| 2004-10-18 | MSFT | Stock | 28.07 | 28.45 | 27.98 | 28.41 | 50350700.0 |
| 2004-10-18 | NVDA | Stock | 0.1112 | 0.115 | 0.1102 | 0.1138 | 573972000.0 |
| 2004-10-18 | AMZN | Stock | 1.9115 | 1.9735 | 1.8945 | 1.9635 | 161864000.0 |
| 2004-10-18 | CL | Stock | 21.855 | 22.05 | 21.855 | 21.96 | 4985000.0 |
| 2004-10-18 | A | Stock | 16.309 | 16.4735 | 16.0229 | 16.4306 | 3285020.0 |
| 2004-10-18 | AABA-DELISTED | Stock | 34.3199996948242 | 35.4000015258789 | 34.1100006103516 | 35.2999992370605 | 19801400.0 |
| 2004-10-18 | AACC-DELISTED | Stock | 17.9 | 18.31 | 17.74 | 18.3 | 17304.0 |
| 2004-10-18 | AAI-DELISTED | Stock | 10.2 | 10.2 | 9.95 | 9.99 | 1049500.0 |
| 2004-10-18 | AAIC-DELISTED | Stock | 389.2 | 394.0 | 385.4 | 390.6 | 840500.0 |
| 2004-10-18 | AAON | Stock | 2.2387 | 2.2571 | 2.2255 | 2.2466 | 37209.0 |
| 2004-10-18 | AAP | Stock | 22.48 | 22.5733 | 22.28 | 22.5 | 1669050.0 |
| 2004-10-18 | AAV-DELISTED | Stock | 16.63 | 17.05 | 16.22 | 16.63 | 29400.0 |
| 2004-10-18 | AAXN-DELISTED | Stock | 19.4850006103516 | 19.9099998474121 | 18.8999996185303 | 19.0349998474121 | 16009000.0 |
| 2004-10-18 | ABAX-DELISTED | Stock | 12.82 | 12.96 | 12.41 | 12.73 | 214573.0 |
| 2004-10-18 | ABB-DELISTED | Stock | 6.2 | 6.29 | 6.18 | 6.25 | 103900.0 |
| 2004-10-18 | ABC-DELISTED | Stock | 13.2 | 13.27 | 13.089 | 13.25 | 4959200.0 |
| 2004-10-18 | ABCB | Stock | 15.927 | 16.3971 | 15.7082 | 16.2593 | 16656.0 |
| 2004-10-18 | ABCO-DELISTED | Stock | 15.518 | 15.588 | 15.352 | 15.467 | 99838.0 |
| 2004-10-18 | ABCW-DELISTED | Stock | 26.06 | 26.3 | 25.88 | 25.97 | 85780.0 |
| 2004-10-18 | ABE-DELISTED | Stock | 8.2 | 8.4 | 8.2 | 8.27 | 5200.0 |
| 2004-10-18 | ABFS-DELISTED | Stock | 38.54 | 39.27 | 38.43 | 39.14 | 343992.0 |
| 2004-10-18 | ABG | Stock | 12.85 | 13.0 | 12.8 | 12.87 | 26100.0 |
| 2004-10-18 | ABK-DELISTED | Stock | 76.68 | 77.11 | 76.0 | 76.14 | 590900.0 |
| 2004-10-18 | ABM | Stock | 20.19 | 20.19 | 19.5 | 19.93 | 129900.0 |
| 2004-10-18 | ABMD-DELISTED | Stock | 9.01 | 9.4 | 8.88 | 9.14 | 247072.0 |
| 2004-10-18 | ABP-DELISTED | Stock | 2.15 | 2.2 | 2.14 | 2.14 | 86100.0 |
| 2004-10-18 | ABR | Stock | 21.35 | 21.6 | 21.35 | 21.5 | 71100.0 |
| 2004-10-18 | ABT | Stock | 19.8877 | 20.0269 | 19.7918 | 19.8397 | 8833264.0 |
| 2004-10-18 | ABTL-DELISTED | Stock | 45.05 | 46.25 | 44.95 | 45.15 | 139700.0 |
| 2004-10-18 | ABV-DELISTED | Stock | 23.8 | 24.21 | 23.69 | 23.92 | 175500.0 |
| 2004-10-18 | ABVA-DELISTED | Stock | 15.1 | 15.28 | 15.04 | 15.04 | 5726.0 |
| 2004-10-18 | ABX-DELISTED | Stock | 20.78 | 20.94 | 20.25 | 20.33 | 1528700.0 |
| 2004-10-18 | ACAD | Stock | 7.46 | 7.5 | 7.21 | 7.47 | 3000.0 |
| 2004-10-18 | ACAP-DELISTED | Stock | 32.1 | 32.25 | 31.76 | 31.82 | 76123.0 |
| 2004-10-18 | ACAS-DELISTED | Stock | 30.8 | 30.89 | 30.13 | 30.6 | 592570.0 |
| 2004-10-18 | ACAT-DELISTED | Stock | 25.66 | 25.67 | 25.0 | 25.39 | 50053.0 |
| 2004-10-18 | ACC-DELISTED | Stock | 19.68 | 19.77 | 19.59 | 19.62 | 23317.0 |
| 2004-10-18 | ACCL-DELISTED | Stock | 5.89 | 6.04 | 5.75 | 6.04 | 85405.0 |
| 2004-10-18 | ACE-DELISTED | Stock | 34.98 | 35.74 | 34.64 | 35.4 | 3354300.0 |
| 2004-10-18 | ACF-DELISTED | Stock | 19.25 | 19.45 | 18.9 | 19.39 | 1557600.0 |
| 2004-10-18 | ACFC-DELISTED | Stock | 65.05 | 65.41 | 63.78 | 63.98 | 5118.0 |
| 2004-10-18 | ACG-DELISTED | Stock | 8.11 | 8.13 | 8.11 | 8.13 | 385400.0 |
| 2004-10-18 | ACGL | Stock | 4.0533 | 4.0956 | 4.0167 | 4.05 | 2449800.0 |
| 2004-10-18 | ACGN-DELISTED | Stock | 634.6712 | 634.6712 | 613.7 | 634.6712 | 27100.0 |
| 2004-10-18 | ACH | Stock | 16.4333 | 16.7867 | 16.16 | 16.6667 | 172800.0 |
| 2004-10-18 | ACH-DELISTED | Stock | 14.75 | 14.888 | 14.562 | 14.625 | 755200.0 |
| 2004-10-18 | ACLS | Stock | 31.04 | 31.8 | 30.76 | 31.44 | 210375.0 |
| 2004-10-18 | ACO-DELISTED | Stock | 17.65 | 17.66 | 17.1 | 17.53 | 137900.0 |
| 2004-10-18 | ACPW-DELISTED | Stock | 16.3 | 16.95 | 16.05 | 16.95 | 7133.0 |
> showing 50 of 3,827 rows — these rows as CSV