PREVIEW / stock_daily / 2005-06-23
file: by_date/stock_daily/2005/2005-06-23.parquet size: 137 KB rows: 4,092 symbols: 2,560
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-06-23 | AAPL | Stock | 1.3868 | 1.4207 | 1.3804 | 1.3889 | 674254000.0 |
| 2005-06-23 | MSFT | Stock | 25.17 | 25.62 | 25.15 | 25.31 | 105159800.0 |
| 2005-06-23 | NVDA | Stock | 0.2292 | 0.236 | 0.2283 | 0.2332 | 836976000.0 |
| 2005-06-23 | AMZN | Stock | 1.757 | 1.778 | 1.755 | 1.7715 | 106044000.0 |
| 2005-06-23 | CL | Stock | 25.7 | 25.735 | 25.565 | 25.675 | 4745400.0 |
| 2005-06-23 | A | Stock | 17.618 | 17.9185 | 17.5966 | 17.7539 | 3662620.0 |
| 2005-06-23 | AABA-DELISTED | Stock | 36.8499984741211 | 37.310001373291 | 36.2000007629395 | 36.2000007629395 | 15547700.0 |
| 2005-06-23 | AACC-DELISTED | Stock | 24.63 | 25.012 | 24.55 | 24.94 | 91535.0 |
| 2005-06-23 | AAI-DELISTED | Stock | 9.65 | 9.71 | 9.36 | 9.41 | 1179100.0 |
| 2005-06-23 | AAIC-DELISTED | Stock | 284.2 | 287.0 | 282.4 | 287.0 | 1019200.0 |
| 2005-06-23 | AAON | Stock | 2.4705 | 2.5007 | 2.4705 | 2.4889 | 110109.0 |
| 2005-06-23 | AAP | Stock | 43.3333 | 43.36 | 42.86 | 43.0 | 1238550.0 |
| 2005-06-23 | AAV-DELISTED | Stock | 14.41 | 14.58 | 13.78 | 14.41 | 121200.0 |
| 2005-06-23 | AAXN-DELISTED | Stock | 10.6499996185303 | 10.8500003814697 | 10.3299999237061 | 10.4099998474121 | 3455900.0 |
| 2005-06-23 | ABAX-DELISTED | Stock | 11.15 | 11.32 | 10.71 | 10.72 | 118052.0 |
| 2005-06-23 | ABB-DELISTED | Stock | 6.97 | 7.1 | 6.96 | 7.01 | 1275700.0 |
| 2005-06-23 | ABBC-DELISTED | Stock | 11.3 | 11.66 | 11.3 | 11.59 | 19497.0 |
| 2005-06-23 | ABC-DELISTED | Stock | 16.84 | 17.0 | 16.71 | 16.72 | 4106000.0 |
| 2005-06-23 | ABCB | Stock | 17.3131 | 17.4784 | 17.1477 | 17.1866 | 13057.0 |
| 2005-06-23 | ABCO-DELISTED | Stock | 24.74 | 24.74 | 23.34 | 23.39 | 375724.0 |
| 2005-06-23 | ABCW-DELISTED | Stock | 30.08 | 30.24 | 29.65 | 30.21 | 113680.0 |
| 2005-06-23 | ABE-DELISTED | Stock | 10.1 | 10.12 | 10.02 | 10.03 | 18600.0 |
| 2005-06-23 | ABFS-DELISTED | Stock | 32.03 | 32.12 | 31.3899 | 31.51 | 553377.0 |
| 2005-06-23 | ABG | Stock | 15.54 | 15.83 | 15.5 | 15.54 | 57400.0 |
| 2005-06-23 | ABK-DELISTED | Stock | 71.0 | 71.34 | 70.46 | 70.52 | 549400.0 |
| 2005-06-23 | ABM | Stock | 19.4 | 19.59 | 19.12 | 19.37 | 197200.0 |
| 2005-06-23 | ABP-DELISTED | Stock | 2.81 | 2.85 | 2.76 | 2.79 | 79000.0 |
| 2005-06-23 | ABR | Stock | 28.76 | 29.05 | 28.58 | 28.7 | 90700.0 |
| 2005-06-23 | ABT | Stock | 23.8557 | 23.9132 | 23.515 | 23.5486 | 5168820.0 |
| 2005-06-23 | ABTL-DELISTED | Stock | 23.87 | 24.12 | 23.08 | 23.18 | 26288.0 |
| 2005-06-23 | ABV-DELISTED | Stock | 31.24 | 31.27 | 30.55 | 30.61 | 466300.0 |
| 2005-06-23 | ABVA-DELISTED | Stock | 14.5 | 14.52 | 14.5 | 14.52 | 5100.0 |
| 2005-06-23 | ABX-DELISTED | Stock | 24.7 | 25.08 | 24.65 | 24.75 | 2120400.0 |
| 2005-06-23 | ACAD | Stock | 9.12 | 9.15 | 8.89 | 9.02 | 30400.0 |
| 2005-06-23 | ACAP-DELISTED | Stock | 36.15 | 36.15 | 35.91 | 36.01 | 76023.0 |
| 2005-06-23 | ACAS-DELISTED | Stock | 35.92 | 36.49 | 35.7 | 35.75 | 752697.0 |
| 2005-06-23 | ACAT-DELISTED | Stock | 21.47 | 21.66 | 20.97 | 21.1 | 70291.0 |
| 2005-06-23 | ACC-DELISTED | Stock | 21.0 | 21.33 | 20.95 | 21.15 | 86400.0 |
| 2005-06-23 | ACCL-DELISTED | Stock | 4.99 | 5.11 | 4.98 | 5.04 | 150056.0 |
| 2005-06-23 | ACE-DELISTED | Stock | 45.37 | 45.44 | 44.47 | 44.52 | 1010826.0 |
| 2005-06-23 | ACF-DELISTED | Stock | 25.5 | 25.5 | 24.97 | 24.99 | 791400.0 |
| 2005-06-23 | ACFC-DELISTED | Stock | 62.35 | 63.06 | 60.82 | 61.12 | 2888.0 |
| 2005-06-23 | ACG-DELISTED | Stock | 8.26 | 8.29 | 8.26 | 8.26 | 366300.0 |
| 2005-06-23 | ACGL | Stock | 4.8156 | 4.8367 | 4.8 | 4.8267 | 943200.0 |
| 2005-06-23 | ACGN-DELISTED | Stock | 612.0 | 668.6712 | 612.0 | 646.0 | 64200.0 |
| 2005-06-23 | ACH | Stock | 21.1933 | 21.3867 | 20.96 | 20.9733 | 187050.0 |
| 2005-06-23 | ACH-DELISTED | Stock | 13.743 | 13.766 | 13.62 | 13.69 | 214371.0 |
| 2005-06-23 | ACLS | Stock | 29.0 | 30.36 | 28.68 | 29.08 | 411250.0 |
| 2005-06-23 | ACO-DELISTED | Stock | 19.32 | 19.35 | 19.0 | 19.0 | 71100.0 |
| 2005-06-23 | ACPW-DELISTED | Stock | 15.916 | 17.97 | 15.865 | 17.2 | 133392.0 |
> showing 50 of 4,092 rows — these rows as CSV