PREVIEW / stock_daily / 2005-03-14
file: by_date/stock_daily/2005/2005-03-14.parquet size: 135 KB rows: 4,029 symbols: 2,522
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-14 | AAPL | Stock | 1.4471 | 1.4568 | 1.4114 | 1.44 | 605385200.0 |
| 2005-03-14 | MSFT | Stock | 25.08 | 25.15 | 24.96 | 25.11 | 65550500.0 |
| 2005-03-14 | NVDA | Stock | 0.214 | 0.2165 | 0.2125 | 0.2156 | 572148000.0 |
| 2005-03-14 | AMZN | Stock | 1.7335 | 1.7375 | 1.7 | 1.73 | 108670000.0 |
| 2005-03-14 | CL | Stock | 26.17 | 26.29 | 26.055 | 26.29 | 2828200.0 |
| 2005-03-14 | A | Stock | 16.6667 | 16.9957 | 16.6309 | 16.9313 | 3095172.0 |
| 2005-03-14 | AABA-DELISTED | Stock | 31.7399997711182 | 31.8299999237061 | 30.6499996185303 | 31.3199996948242 | 19762000.0 |
| 2005-03-14 | AACC-DELISTED | Stock | 18.74 | 19.62 | 18.71 | 19.59 | 91713.0 |
| 2005-03-14 | AAI-DELISTED | Stock | 8.04 | 8.58 | 8.03 | 8.52 | 1595800.0 |
| 2005-03-14 | AAIC-DELISTED | Stock | 368.4 | 369.0 | 355.0 | 358.6 | 2803400.0 |
| 2005-03-14 | AAME | Stock | 3.05 | 3.05 | 3.05 | 3.05 | 100.0 |
| 2005-03-14 | AAON | Stock | 1.9964 | 2.0148 | 1.9964 | 2.0016 | 72141.0 |
| 2005-03-14 | AAP | Stock | 33.92 | 33.9267 | 33.0133 | 33.0867 | 2594250.0 |
| 2005-03-14 | AAV-DELISTED | Stock | 16.53 | 16.76 | 16.34 | 16.53 | 61400.0 |
| 2005-03-14 | AAXN-DELISTED | Stock | 13.539999961853 | 13.6499996185303 | 13.1999998092651 | 13.4099998474121 | 1991400.0 |
| 2005-03-14 | ABAX-DELISTED | Stock | 9.9 | 9.9 | 9.42 | 9.69 | 324272.0 |
| 2005-03-14 | ABB-DELISTED | Stock | 6.3 | 6.33 | 6.23 | 6.3 | 173100.0 |
| 2005-03-14 | ABBC-DELISTED | Stock | 13.5 | 13.69 | 13.3 | 13.64 | 14258.0 |
| 2005-03-14 | ABC-DELISTED | Stock | 15.1 | 15.4 | 15.1 | 15.27 | 4298000.0 |
| 2005-03-14 | ABCB | Stock | 17.955 | 18.1982 | 17.9355 | 18.1885 | 15833.0 |
| 2005-03-14 | ABCO-DELISTED | Stock | 19.915 | 19.915 | 19.435 | 19.725 | 142292.0 |
| 2005-03-14 | ABCW-DELISTED | Stock | 27.83 | 28.02 | 27.53 | 27.74 | 55060.0 |
| 2005-03-14 | ABE-DELISTED | Stock | 10.18 | 10.2 | 9.99 | 10.1 | 38600.0 |
| 2005-03-14 | ABFS-DELISTED | Stock | 44.46 | 44.74 | 44.22 | 44.67 | 224595.0 |
| 2005-03-14 | ABG | Stock | 15.3 | 15.42 | 15.2 | 15.23 | 40500.0 |
| 2005-03-14 | ABK-DELISTED | Stock | 77.9 | 79.12 | 77.84 | 78.79 | 242900.0 |
| 2005-03-14 | ABM | Stock | 19.05 | 19.54 | 19.05 | 19.51 | 174700.0 |
| 2005-03-14 | ABMD-DELISTED | Stock | 10.94 | 11.52 | 10.94 | 11.3 | 127269.0 |
| 2005-03-14 | ABP-DELISTED | Stock | 2.71 | 2.74 | 2.45 | 2.57 | 200000.0 |
| 2005-03-14 | ABR | Stock | 26.0 | 26.02 | 25.9 | 25.95 | 165600.0 |
| 2005-03-14 | ABT | Stock | 22.0708 | 22.2435 | 21.9844 | 22.1284 | 5765319.0 |
| 2005-03-14 | ABTL-DELISTED | Stock | 29.95 | 30.5 | 29.25 | 29.45 | 64300.0 |
| 2005-03-14 | ABV-DELISTED | Stock | 29.0 | 29.01 | 28.75 | 28.85 | 645100.0 |
| 2005-03-14 | ABVA-DELISTED | Stock | 16.4 | 16.4 | 16.4 | 16.4 | 1500.0 |
| 2005-03-14 | ABX-DELISTED | Stock | 25.7 | 25.7 | 25.3 | 25.56 | 1185500.0 |
| 2005-03-14 | ACAD | Stock | 7.3 | 7.3 | 6.98 | 7.09 | 4000.0 |
| 2005-03-14 | ACAP-DELISTED | Stock | 34.98 | 34.98 | 34.29 | 34.6 | 104307.0 |
| 2005-03-14 | ACAS-DELISTED | Stock | 34.0 | 34.47 | 34.0 | 34.37 | 428552.0 |
| 2005-03-14 | ACAT-DELISTED | Stock | 27.1 | 28.33 | 27.1 | 28.28 | 51342.0 |
| 2005-03-14 | ACC-DELISTED | Stock | 22.09 | 22.2 | 22.0 | 22.2 | 19500.0 |
| 2005-03-14 | ACCL-DELISTED | Stock | 5.13 | 5.55 | 5.13 | 5.4 | 826659.0 |
| 2005-03-14 | ACE-DELISTED | Stock | 45.55 | 45.7 | 44.95 | 45.41 | 1403400.0 |
| 2005-03-14 | ACF-DELISTED | Stock | 24.95 | 25.49 | 24.95 | 25.01 | 1022600.0 |
| 2005-03-14 | ACFC-DELISTED | Stock | 67.91 | 68.27 | 67.35 | 67.35 | 977.0 |
| 2005-03-14 | ACG-DELISTED | Stock | 8.24 | 8.26 | 8.22 | 8.24 | 363300.0 |
| 2005-03-14 | ACGL | Stock | 4.5333 | 4.55 | 4.5267 | 4.5389 | 806400.0 |
| 2005-03-14 | ACGN-DELISTED | Stock | 668.6712 | 680.0 | 623.3288 | 657.3288 | 102300.0 |
| 2005-03-14 | ACH | Stock | 18.0933 | 18.3867 | 18.02 | 18.2333 | 231600.0 |
| 2005-03-14 | ACH-DELISTED | Stock | 15.487 | 15.497 | 15.2 | 15.3 | 184400.0 |
| 2005-03-14 | ACLS | Stock | 31.8 | 32.2 | 31.32 | 31.92 | 141975.0 |
> showing 50 of 4,029 rows — these rows as CSV