PREVIEW / stock_daily / 2004-12-06
file: by_date/stock_daily/2004/2004-12-06.parquet size: 133 KB rows: 3,928 symbols: 2,459
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-12-06 | AAPL | Stock | 1.1473 | 1.1829 | 1.1241 | 1.1746 | 1247920800.0 |
| 2004-12-06 | MSFT | Stock | 27.1 | 27.44 | 27.07 | 27.33 | 55297400.0 |
| 2004-12-06 | NVDA | Stock | 0.1736 | 0.1824 | 0.1705 | 0.181 | 970500000.0 |
| 2004-12-06 | AMZN | Stock | 1.9865 | 1.999 | 1.9575 | 1.9745 | 121760000.0 |
| 2004-12-06 | CL | Stock | 23.425 | 23.45 | 23.065 | 23.145 | 4780200.0 |
| 2004-12-06 | A | Stock | 17.2747 | 17.4678 | 17.1459 | 17.3891 | 1868567.0 |
| 2004-12-06 | AABA-DELISTED | Stock | 38.7099990844727 | 39.0 | 38.5099983215332 | 38.8400001525879 | 12007500.0 |
| 2004-12-06 | AACC-DELISTED | Stock | 20.5 | 20.6 | 19.79 | 20.05 | 41429.0 |
| 2004-12-06 | AAI-DELISTED | Stock | 12.3 | 12.3 | 11.83 | 11.93 | 1278700.0 |
| 2004-12-06 | AAIC-DELISTED | Stock | 400.2 | 401.6 | 396.0 | 400.4 | 1832000.0 |
| 2004-12-06 | AAME | Stock | 3.0 | 3.05 | 3.0 | 3.05 | 2200.0 |
| 2004-12-06 | AAON | Stock | 2.0372 | 2.0464 | 2.0267 | 2.0267 | 107072.0 |
| 2004-12-06 | AAP | Stock | 27.98 | 27.98 | 27.8333 | 27.8333 | 550200.0 |
| 2004-12-06 | AAV-DELISTED | Stock | 17.82 | 18.09 | 17.75 | 17.82 | 21400.0 |
| 2004-12-06 | AAXN-DELISTED | Stock | 27.7000007629395 | 28.2299995422363 | 27.5200004577637 | 27.6599998474121 | 6496100.0 |
| 2004-12-06 | ABAX-DELISTED | Stock | 13.85 | 13.99 | 13.5 | 13.68 | 239449.0 |
| 2004-12-06 | ABB-DELISTED | Stock | 5.46 | 5.55 | 5.45 | 5.52 | 719500.0 |
| 2004-12-06 | ABC-DELISTED | Stock | 15.01 | 15.46 | 15.01 | 15.37 | 8447600.0 |
| 2004-12-06 | ABCB | Stock | 16.8024 | 17.0213 | 16.616 | 17.0213 | 21098.0 |
| 2004-12-06 | ABCO-DELISTED | Stock | 18.53 | 18.53 | 18.065 | 18.33 | 567532.0 |
| 2004-12-06 | ABCW-DELISTED | Stock | 29.09 | 29.17 | 28.45 | 28.45 | 87560.0 |
| 2004-12-06 | ABE-DELISTED | Stock | 9.34 | 9.47 | 9.15 | 9.33 | 30300.0 |
| 2004-12-06 | ABFS-DELISTED | Stock | 44.12 | 44.2 | 43.18 | 43.65 | 134467.0 |
| 2004-12-06 | ABG | Stock | 13.83 | 13.99 | 13.41 | 13.9 | 89600.0 |
| 2004-12-06 | ABK-DELISTED | Stock | 81.61 | 82.39 | 81.35 | 82.3 | 245300.0 |
| 2004-12-06 | ABM | Stock | 21.65 | 21.83 | 21.57 | 21.6 | 160900.0 |
| 2004-12-06 | ABMD-DELISTED | Stock | 14.76 | 14.94 | 14.51 | 14.78 | 77391.0 |
| 2004-12-06 | ABP-DELISTED | Stock | 2.42 | 2.5 | 2.4 | 2.45 | 135300.0 |
| 2004-12-06 | ABR | Stock | 23.81 | 23.85 | 23.7 | 23.84 | 37200.0 |
| 2004-12-06 | ABT | Stock | 20.7609 | 21.0008 | 20.5546 | 20.9145 | 6205085.0 |
| 2004-12-06 | ABTL-DELISTED | Stock | 36.75 | 39.55 | 36.2 | 38.6 | 82600.0 |
| 2004-12-06 | ABV-DELISTED | Stock | 26.6 | 27.7 | 26.35 | 27.5 | 584400.0 |
| 2004-12-06 | ABVA-DELISTED | Stock | 14.7 | 14.75 | 14.7 | 14.75 | 1600.0 |
| 2004-12-06 | ABVT-DELISTED | Stock | 29.0 | 30.0 | 29.0 | 30.0 | 21700.0 |
| 2004-12-06 | ABX-DELISTED | Stock | 24.06 | 24.07 | 23.61 | 23.77 | 2235200.0 |
| 2004-12-06 | ACAD | Stock | 6.9 | 6.92 | 6.79 | 6.79 | 22000.0 |
| 2004-12-06 | ACAP-DELISTED | Stock | 33.37 | 34.0 | 33.24 | 33.86 | 84215.0 |
| 2004-12-06 | ACAS-DELISTED | Stock | 32.04 | 32.1 | 31.9 | 31.9 | 619705.0 |
| 2004-12-06 | ACAT-DELISTED | Stock | 26.23 | 26.46 | 25.92 | 26.0 | 40859.0 |
| 2004-12-06 | ACC-DELISTED | Stock | 21.52 | 21.79 | 21.45 | 21.64 | 54900.0 |
| 2004-12-06 | ACCL-DELISTED | Stock | 7.55 | 7.55 | 7.1 | 7.26 | 127201.0 |
| 2004-12-06 | ACE-DELISTED | Stock | 40.82 | 40.87 | 40.47 | 40.72 | 961866.0 |
| 2004-12-06 | ACF-DELISTED | Stock | 21.7 | 21.74 | 21.4 | 21.65 | 633800.0 |
| 2004-12-06 | ACFC-DELISTED | Stock | 76.02 | 76.02 | 74.34 | 75.0 | 3821.0 |
| 2004-12-06 | ACG-DELISTED | Stock | 8.11 | 8.13 | 8.08 | 8.08 | 406800.0 |
| 2004-12-06 | ACGL | Stock | 4.3178 | 4.3911 | 4.3178 | 4.3911 | 1177200.0 |
| 2004-12-06 | ACGN-DELISTED | Stock | 578.0 | 578.0 | 532.6712 | 555.3288 | 184100.0 |
| 2004-12-06 | ACH | Stock | 19.0333 | 19.1667 | 19.0 | 19.08 | 435900.0 |
| 2004-12-06 | ACH-DELISTED | Stock | 15.805 | 15.805 | 15.525 | 15.615 | 247532.0 |
| 2004-12-06 | ACLS | Stock | 31.8 | 32.68 | 31.6 | 32.68 | 310325.0 |
> showing 50 of 3,928 rows — these rows as CSV