PREVIEW / stock_daily / 2004-12-23
file: by_date/stock_daily/2004/2004-12-23.parquet size: 132 KB rows: 3,937 symbols: 2,467
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-23 | AAPL | Stock | 1.1384 | 1.1473 | 1.1357 | 1.143 | 245929600.0 |
| 2004-12-23 | MSFT | Stock | 26.87 | 27.15 | 26.83 | 27.01 | 65801900.0 |
| 2004-12-23 | NVDA | Stock | 0.1907 | 0.1944 | 0.1897 | 0.1922 | 366972000.0 |
| 2004-12-23 | AMZN | Stock | 1.967 | 1.976 | 1.946 | 1.9465 | 64136000.0 |
| 2004-12-23 | CL | Stock | 25.25 | 25.515 | 25.25 | 25.365 | 2978400.0 |
| 2004-12-23 | A | Stock | 17.1102 | 17.2389 | 17.0243 | 17.1459 | 1678579.0 |
| 2004-12-23 | AABA-DELISTED | Stock | 37.4300003051758 | 37.5 | 37.2099990844727 | 37.25 | 6045500.0 |
| 2004-12-23 | AACC-DELISTED | Stock | 21.72 | 21.72 | 21.0 | 21.001 | 45759.0 |
| 2004-12-23 | AAI-DELISTED | Stock | 10.99 | 10.99 | 10.75 | 10.76 | 520300.0 |
| 2004-12-23 | AAIC-DELISTED | Stock | 402.0 | 403.0 | 397.4 | 397.8 | 694500.0 |
| 2004-12-23 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 12300.0 |
| 2004-12-23 | AAON | Stock | 1.92 | 1.9714 | 1.9095 | 1.9595 | 42525.0 |
| 2004-12-23 | AAP | Stock | 27.9667 | 28.0667 | 27.7733 | 27.8267 | 1051500.0 |
| 2004-12-23 | AAV-DELISTED | Stock | 18.17 | 18.25 | 18.07 | 18.17 | 31500.0 |
| 2004-12-23 | AAXN-DELISTED | Stock | 28.7700004577637 | 28.8500003814697 | 28.2800006866455 | 28.3400001525879 | 4445700.0 |
| 2004-12-23 | ABAX-DELISTED | Stock | 14.66 | 14.66 | 14.36 | 14.45 | 73700.0 |
| 2004-12-23 | ABB-DELISTED | Stock | 5.58 | 5.63 | 5.57 | 5.61 | 110300.0 |
| 2004-12-23 | ABBC-DELISTED | Stock | 13.35 | 13.35 | 13.18 | 13.3 | 176991.0 |
| 2004-12-23 | ABC-DELISTED | Stock | 14.33 | 14.37 | 14.158 | 14.21 | 6014000.0 |
| 2004-12-23 | ABCB | Stock | 17.7994 | 17.8075 | 17.7994 | 17.8075 | 1604.0 |
| 2004-12-23 | ABCO-DELISTED | Stock | 18.51 | 18.575 | 18.355 | 18.39 | 139180.0 |
| 2004-12-23 | ABCW-DELISTED | Stock | 29.24 | 29.43 | 28.84 | 29.12 | 16800.0 |
| 2004-12-23 | ABE-DELISTED | Stock | 9.65 | 10.15 | 9.45 | 10.15 | 106300.0 |
| 2004-12-23 | ABFS-DELISTED | Stock | 45.88 | 46.13 | 45.3 | 45.33 | 83644.0 |
| 2004-12-23 | ABG | Stock | 13.99 | 14.07 | 13.96 | 13.99 | 110000.0 |
| 2004-12-23 | ABK-DELISTED | Stock | 82.5 | 82.93 | 81.88 | 82.44 | 232500.0 |
| 2004-12-23 | ABM | Stock | 19.83 | 20.06 | 19.54 | 19.86 | 128100.0 |
| 2004-12-23 | ABMD-DELISTED | Stock | 13.55 | 13.83 | 13.5 | 13.68 | 110517.0 |
| 2004-12-23 | ABP-DELISTED | Stock | 2.46 | 2.5 | 2.46 | 2.46 | 93500.0 |
| 2004-12-23 | ABR | Stock | 24.15 | 24.4 | 24.07 | 24.35 | 23800.0 |
| 2004-12-23 | ABT | Stock | 22.3155 | 22.5458 | 22.2099 | 22.2723 | 4486036.0 |
| 2004-12-23 | ABTL-DELISTED | Stock | 27.45 | 27.9 | 26.6 | 27.1 | 83500.0 |
| 2004-12-23 | ABV-DELISTED | Stock | 27.4 | 27.4 | 27.09 | 27.15 | 91600.0 |
| 2004-12-23 | ABVA-DELISTED | Stock | 15.01 | 15.01 | 15.01 | 15.01 | 1000.0 |
| 2004-12-23 | ABX-DELISTED | Stock | 23.79 | 24.08 | 23.76 | 23.81 | 891362.0 |
| 2004-12-23 | ACAD | Stock | 6.75 | 6.75 | 5.79 | 6.31 | 183800.0 |
| 2004-12-23 | ACAP-DELISTED | Stock | 37.63 | 37.94 | 37.07 | 37.27 | 60752.0 |
| 2004-12-23 | ACAS-DELISTED | Stock | 33.05 | 33.55 | 32.96 | 33.3 | 584435.0 |
| 2004-12-23 | ACAT-DELISTED | Stock | 26.77 | 26.82 | 26.35 | 26.77 | 33398.0 |
| 2004-12-23 | ACC-DELISTED | Stock | 22.3 | 22.37 | 22.25 | 22.37 | 10800.0 |
| 2004-12-23 | ACCL-DELISTED | Stock | 7.86 | 7.99 | 7.74 | 7.88 | 73893.0 |
| 2004-12-23 | ACE-DELISTED | Stock | 42.4 | 42.48 | 42.03 | 42.14 | 403000.0 |
| 2004-12-23 | ACF-DELISTED | Stock | 23.75 | 23.92 | 23.61 | 23.84 | 446100.0 |
| 2004-12-23 | ACFC-DELISTED | Stock | 71.68 | 71.68 | 70.2 | 70.87 | 3776.0 |
| 2004-12-23 | ACG-DELISTED | Stock | 8.15 | 8.16 | 8.13 | 8.15 | 391900.0 |
| 2004-12-23 | ACGL | Stock | 4.2911 | 4.3633 | 4.2822 | 4.3267 | 1219500.0 |
| 2004-12-23 | ACGN-DELISTED | Stock | 555.3288 | 566.6712 | 544.0 | 566.6712 | 218100.0 |
| 2004-12-23 | ACH | Stock | 18.5333 | 18.7133 | 18.4 | 18.5667 | 170550.0 |
| 2004-12-23 | ACH-DELISTED | Stock | 14.474 | 14.507 | 14.382 | 14.427 | 170001.0 |
| 2004-12-23 | ACLS | Stock | 32.4 | 32.76 | 32.2 | 32.24 | 168725.0 |
> showing 50 of 3,937 rows — these rows as CSV