PREVIEW / stock_daily / 2004-10-19
file: by_date/stock_daily/2004/2004-10-19.parquet size: 128 KB rows: 3,842 symbols: 2,402
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-19 | AAPL | Stock | 0.8589 | 0.8634 | 0.8448 | 0.8468 | 801992800.0 |
| 2004-10-19 | MSFT | Stock | 28.53 | 28.59 | 28.17 | 28.18 | 57026500.0 |
| 2004-10-19 | NVDA | Stock | 0.1164 | 0.1176 | 0.1122 | 0.1131 | 618480000.0 |
| 2004-10-19 | AMZN | Stock | 1.987 | 1.9925 | 1.9085 | 1.9165 | 176052000.0 |
| 2004-10-19 | CL | Stock | 21.96 | 21.965 | 21.445 | 21.53 | 10983800.0 |
| 2004-10-19 | A | Stock | 16.5737 | 16.7954 | 16.2518 | 16.2518 | 4647371.0 |
| 2004-10-19 | AABA-DELISTED | Stock | 35.439998626709 | 35.689998626709 | 34.5299987792969 | 34.6399993896484 | 22291600.0 |
| 2004-10-19 | AACC-DELISTED | Stock | 18.53 | 18.6 | 18.15 | 18.42 | 44235.0 |
| 2004-10-19 | AAI-DELISTED | Stock | 10.0 | 10.12 | 9.59 | 9.79 | 1559400.0 |
| 2004-10-19 | AAIC-DELISTED | Stock | 392.0 | 394.6 | 383.6 | 384.0 | 858300.0 |
| 2004-10-19 | AAME | Stock | 3.04 | 3.15 | 3.04 | 3.15 | 2500.0 |
| 2004-10-19 | AAON | Stock | 2.1807 | 2.2387 | 2.1531 | 2.1531 | 309066.0 |
| 2004-10-19 | AAP | Stock | 22.5067 | 23.1333 | 22.5067 | 22.64 | 1555500.0 |
| 2004-10-19 | AAV-DELISTED | Stock | 16.71 | 16.71 | 16.63 | 16.71 | 18400.0 |
| 2004-10-19 | AAXN-DELISTED | Stock | 20.2549991607666 | 20.9150009155273 | 19.6949996948242 | 20.125 | 36995200.0 |
| 2004-10-19 | ABAX-DELISTED | Stock | 12.38 | 12.72 | 12.08 | 12.51 | 249529.0 |
| 2004-10-19 | ABB-DELISTED | Stock | 6.41 | 6.5 | 6.35 | 6.4 | 401100.0 |
| 2004-10-19 | ABC-DELISTED | Stock | 13.25 | 13.25 | 13.01 | 13.05 | 5038400.0 |
| 2004-10-19 | ABCB | Stock | 16.3161 | 16.3161 | 15.8216 | 15.8621 | 14805.0 |
| 2004-10-19 | ABCO-DELISTED | Stock | 15.51 | 15.635 | 15.3 | 15.375 | 144568.0 |
| 2004-10-19 | ABCW-DELISTED | Stock | 25.93 | 26.05 | 25.8 | 25.83 | 62010.0 |
| 2004-10-19 | ABE-DELISTED | Stock | 8.37 | 8.65 | 8.37 | 8.4 | 71500.0 |
| 2004-10-19 | ABFS-DELISTED | Stock | 39.0 | 40.0 | 39.0 | 39.53 | 517975.0 |
| 2004-10-19 | ABG | Stock | 12.86 | 13.27 | 12.86 | 12.96 | 19800.0 |
| 2004-10-19 | ABK-DELISTED | Stock | 76.14 | 76.15 | 74.05 | 74.57 | 859600.0 |
| 2004-10-19 | ABM | Stock | 19.93 | 20.17 | 19.8 | 19.86 | 55400.0 |
| 2004-10-19 | ABMD-DELISTED | Stock | 9.2 | 9.2 | 8.94 | 9.0 | 39891.0 |
| 2004-10-19 | ABP-DELISTED | Stock | 2.14 | 2.2 | 2.06 | 2.13 | 67000.0 |
| 2004-10-19 | ABR | Stock | 21.5 | 21.5 | 21.11 | 21.23 | 30700.0 |
| 2004-10-19 | ABT | Stock | 19.7965 | 19.9933 | 19.7582 | 19.8541 | 9269070.0 |
| 2004-10-19 | ABTL-DELISTED | Stock | 46.45 | 46.45 | 43.2 | 44.25 | 69500.0 |
| 2004-10-19 | ABV-DELISTED | Stock | 23.99 | 23.99 | 23.3 | 23.33 | 283800.0 |
| 2004-10-19 | ABVA-DELISTED | Stock | 15.01 | 15.15 | 15.01 | 15.05 | 950.0 |
| 2004-10-19 | ABVT-DELISTED | Stock | 24.15 | 24.15 | 24.15 | 24.15 | 57700.0 |
| 2004-10-19 | ABX-DELISTED | Stock | 20.52 | 20.92 | 20.47 | 20.81 | 2049300.0 |
| 2004-10-19 | ACAD | Stock | 7.47 | 7.47 | 7.21 | 7.43 | 4800.0 |
| 2004-10-19 | ACAP-DELISTED | Stock | 32.02 | 32.02 | 31.0 | 31.37 | 62085.0 |
| 2004-10-19 | ACAS-DELISTED | Stock | 30.72 | 30.78 | 29.23 | 29.99 | 1166519.0 |
| 2004-10-19 | ACAT-DELISTED | Stock | 25.33 | 25.74 | 24.3 | 24.5 | 41365.0 |
| 2004-10-19 | ACC-DELISTED | Stock | 19.68 | 19.7 | 19.59 | 19.68 | 26200.0 |
| 2004-10-19 | ACCL-DELISTED | Stock | 6.0 | 6.1 | 5.92 | 5.98 | 77995.0 |
| 2004-10-19 | ACE-DELISTED | Stock | 35.0 | 35.01 | 31.8 | 33.11 | 8891900.0 |
| 2004-10-19 | ACF-DELISTED | Stock | 19.39 | 19.75 | 18.93 | 19.07 | 1299700.0 |
| 2004-10-19 | ACFC-DELISTED | Stock | 64.03 | 64.28 | 63.57 | 63.98 | 1531.0 |
| 2004-10-19 | ACG-DELISTED | Stock | 8.12 | 8.13 | 8.11 | 8.12 | 345000.0 |
| 2004-10-19 | ACGL | Stock | 4.05 | 4.0567 | 3.9389 | 3.9644 | 2213100.0 |
| 2004-10-19 | ACGN-DELISTED | Stock | 634.6712 | 646.0 | 600.6712 | 634.6712 | 141600.0 |
| 2004-10-19 | ACH | Stock | 16.6667 | 17.1267 | 16.6667 | 16.84 | 332700.0 |
| 2004-10-19 | ACH-DELISTED | Stock | 14.671 | 14.878 | 14.291 | 14.333 | 812752.0 |
| 2004-10-19 | ACLS | Stock | 31.8 | 32.52 | 31.4 | 31.72 | 180525.0 |
> showing 50 of 3,842 rows — these rows as CSV