PREVIEW / stock_daily / 2005-06-22
file: by_date/stock_daily/2005/2005-06-22.parquet size: 137 KB rows: 4,104 symbols: 2,572
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-22 | AAPL | Stock | 1.3664 | 1.3786 | 1.3621 | 1.3768 | 424925200.0 |
| 2005-06-22 | MSFT | Stock | 25.11 | 25.26 | 25.03 | 25.07 | 60492700.0 |
| 2005-06-22 | NVDA | Stock | 0.2322 | 0.2338 | 0.2267 | 0.2296 | 700668000.0 |
| 2005-06-22 | AMZN | Stock | 1.775 | 1.7925 | 1.757 | 1.761 | 50146000.0 |
| 2005-06-22 | CL | Stock | 25.625 | 25.68 | 25.415 | 25.6 | 4416400.0 |
| 2005-06-22 | A | Stock | 17.7253 | 17.8112 | 17.5179 | 17.618 | 1993408.0 |
| 2005-06-22 | AABA-DELISTED | Stock | 36.9099998474121 | 37.3199996948242 | 36.8400001525879 | 36.9000015258789 | 12148100.0 |
| 2005-06-22 | AACC-DELISTED | Stock | 25.16 | 25.16 | 24.61 | 24.75 | 175485.0 |
| 2005-06-22 | AACQ-DELISTED | Stock | 5.03 | 5.03 | 5.03 | 5.03 | 1500.0 |
| 2005-06-22 | AAI-DELISTED | Stock | 9.62 | 9.83 | 9.55 | 9.72 | 633200.0 |
| 2005-06-22 | AAIC-DELISTED | Stock | 283.4 | 284.4 | 282.0 | 283.4 | 1100100.0 |
| 2005-06-22 | AAME | Stock | 3.01 | 3.01 | 3.01 | 3.01 | 3000.0 |
| 2005-06-22 | AAON | Stock | 2.3993 | 2.5007 | 2.3993 | 2.5007 | 219459.0 |
| 2005-06-22 | AAP | Stock | 43.3333 | 43.58 | 43.0267 | 43.3533 | 750000.0 |
| 2005-06-22 | AAV-DELISTED | Stock | 14.58 | 14.64 | 14.45 | 14.58 | 111200.0 |
| 2005-06-22 | AAXN-DELISTED | Stock | 10.8800001144409 | 10.8999996185303 | 10.6300001144409 | 10.6300001144409 | 1813700.0 |
| 2005-06-22 | ABAX-DELISTED | Stock | 11.16 | 11.24 | 11.03 | 11.21 | 31472.0 |
| 2005-06-22 | ABB-DELISTED | Stock | 6.96 | 7.0 | 6.95 | 6.99 | 1033400.0 |
| 2005-06-22 | ABBC-DELISTED | Stock | 11.356 | 11.49 | 11.23 | 11.41 | 14952.0 |
| 2005-06-22 | ABC-DELISTED | Stock | 16.97 | 16.97 | 16.8 | 16.85 | 3934800.0 |
| 2005-06-22 | ABCB | Stock | 17.8285 | 17.8285 | 17.2644 | 17.6146 | 11515.0 |
| 2005-06-22 | ABCO-DELISTED | Stock | 24.5 | 24.95 | 24.49 | 24.55 | 222506.0 |
| 2005-06-22 | ABCW-DELISTED | Stock | 29.95 | 30.29 | 29.88 | 30.13 | 295520.0 |
| 2005-06-22 | ABE-DELISTED | Stock | 10.13 | 10.35 | 10.1 | 10.1 | 32000.0 |
| 2005-06-22 | ABFS-DELISTED | Stock | 31.62 | 32.42 | 31.62 | 32.29 | 243486.0 |
| 2005-06-22 | ABG | Stock | 15.3 | 15.58 | 15.27 | 15.54 | 66900.0 |
| 2005-06-22 | ABK-DELISTED | Stock | 71.05 | 71.35 | 70.55 | 70.88 | 356600.0 |
| 2005-06-22 | ABM | Stock | 19.46 | 19.67 | 19.27 | 19.52 | 190700.0 |
| 2005-06-22 | ABMD-DELISTED | Stock | 10.5 | 10.72 | 9.8 | 9.89 | 278160.0 |
| 2005-06-22 | ABP-DELISTED | Stock | 2.82 | 2.88 | 2.75 | 2.84 | 90300.0 |
| 2005-06-22 | ABR | Stock | 28.85 | 28.96 | 28.44 | 28.82 | 113700.0 |
| 2005-06-22 | ABT | Stock | 23.7597 | 23.8557 | 23.6541 | 23.8557 | 6343476.0 |
| 2005-06-22 | ABTL-DELISTED | Stock | 24.5 | 25.25 | 23.65 | 23.85 | 32911.0 |
| 2005-06-22 | ABV-DELISTED | Stock | 30.49 | 30.63 | 30.07 | 30.54 | 225000.0 |
| 2005-06-22 | ABVA-DELISTED | Stock | 14.4 | 14.6 | 14.4 | 14.4 | 2800.0 |
| 2005-06-22 | ABX-DELISTED | Stock | 24.22 | 24.58 | 24.16 | 24.44 | 1180000.0 |
| 2005-06-22 | ACAD | Stock | 9.0 | 9.13 | 8.67 | 9.02 | 25600.0 |
| 2005-06-22 | ACAP-DELISTED | Stock | 36.17 | 36.84 | 36.0 | 36.23 | 141963.0 |
| 2005-06-22 | ACAS-DELISTED | Stock | 35.85 | 36.02 | 35.81 | 35.87 | 384303.0 |
| 2005-06-22 | ACAT-DELISTED | Stock | 22.03 | 22.06 | 21.5 | 21.6 | 71738.0 |
| 2005-06-22 | ACC-DELISTED | Stock | 21.55 | 21.55 | 20.934 | 21.08 | 63700.0 |
| 2005-06-22 | ACCL-DELISTED | Stock | 5.15 | 5.2 | 4.97 | 4.99 | 162943.0 |
| 2005-06-22 | ACE-DELISTED | Stock | 45.82 | 46.13 | 45.28 | 45.37 | 788714.0 |
| 2005-06-22 | ACF-DELISTED | Stock | 25.35 | 25.49 | 25.09 | 25.3 | 757500.0 |
| 2005-06-22 | ACFC-DELISTED | Stock | 63.11 | 63.72 | 61.99 | 62.35 | 5460.0 |
| 2005-06-22 | ACG-DELISTED | Stock | 8.24 | 8.28 | 8.24 | 8.27 | 617600.0 |
| 2005-06-22 | ACGL | Stock | 4.8189 | 4.8378 | 4.7944 | 4.8278 | 1183500.0 |
| 2005-06-22 | ACGN-DELISTED | Stock | 668.6712 | 680.0 | 646.0 | 646.0 | 121700.0 |
| 2005-06-22 | ACH | Stock | 21.22 | 21.5267 | 21.0667 | 21.2267 | 137250.0 |
| 2005-06-22 | ACH-DELISTED | Stock | 13.686 | 13.851 | 13.686 | 13.739 | 166795.0 |
> showing 50 of 4,104 rows — these rows as CSV