PREVIEW / stock_daily / 2005-07-22
file: by_date/stock_daily/2005/2005-07-22.parquet size: 137 KB rows: 4,111 symbols: 2,582
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-07-22 | AAPL | Stock | 1.5514 | 1.5714 | 1.5496 | 1.5714 | 301106400.0 |
| 2005-07-22 | MSFT | Stock | 25.99 | 26.34 | 25.63 | 25.68 | 97558900.0 |
| 2005-07-22 | NVDA | Stock | 0.2221 | 0.2252 | 0.2137 | 0.2152 | 699264000.0 |
| 2005-07-22 | AMZN | Stock | 1.8945 | 1.9115 | 1.862 | 1.8975 | 117422000.0 |
| 2005-07-22 | CL | Stock | 25.81 | 26.01 | 25.65 | 25.99 | 3528800.0 |
| 2005-07-22 | A | Stock | 18.4406 | 18.4549 | 18.1474 | 18.3047 | 2015217.0 |
| 2005-07-22 | AABA-DELISTED | Stock | 33.3499984741211 | 33.7700004577637 | 33.1699981689453 | 33.5299987792969 | 27561500.0 |
| 2005-07-22 | AACC-DELISTED | Stock | 24.65 | 24.65 | 23.12 | 23.9 | 139008.0 |
| 2005-07-22 | AAI-DELISTED | Stock | 10.61 | 10.72 | 10.25 | 10.42 | 1299000.0 |
| 2005-07-22 | AAIC-DELISTED | Stock | 289.4 | 293.8 | 287.8 | 291.4 | 672300.0 |
| 2005-07-22 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 1900.0 |
| 2005-07-22 | AAON | Stock | 2.4454 | 2.535 | 2.4428 | 2.535 | 120741.0 |
| 2005-07-22 | AAP | Stock | 44.3333 | 44.7067 | 43.9867 | 44.2 | 420150.0 |
| 2005-07-22 | AAV-DELISTED | Stock | 14.94 | 14.99 | 14.8 | 14.94 | 18200.0 |
| 2005-07-22 | AAXN-DELISTED | Stock | 9.69999980926514 | 9.80000019073486 | 9.5600004196167 | 9.59000015258789 | 1269600.0 |
| 2005-07-22 | ABAX-DELISTED | Stock | 12.22 | 12.25 | 12.0 | 12.2 | 123572.0 |
| 2005-07-22 | ABB-DELISTED | Stock | 6.52 | 6.53 | 6.46 | 6.49 | 767100.0 |
| 2005-07-22 | ABBC-DELISTED | Stock | 12.25 | 12.47 | 12.2 | 12.34 | 19378.0 |
| 2005-07-22 | ABC-DELISTED | Stock | 17.71 | 17.73 | 17.18 | 17.34 | 6866400.0 |
| 2005-07-22 | ABCB | Stock | 19.0249 | 19.3167 | 18.986 | 19.3167 | 5449.0 |
| 2005-07-22 | ABCO-DELISTED | Stock | 23.72 | 24.65 | 23.42 | 24.64 | 297676.0 |
| 2005-07-22 | ABCW-DELISTED | Stock | 30.05 | 31.21 | 30.05 | 31.16 | 75720.0 |
| 2005-07-22 | ABE-DELISTED | Stock | 10.39 | 10.43 | 10.35 | 10.42 | 5000.0 |
| 2005-07-22 | ABFS-DELISTED | Stock | 36.28 | 36.79 | 35.22 | 35.93 | 625183.0 |
| 2005-07-22 | ABG | Stock | 16.85 | 17.12 | 16.75 | 17.12 | 81900.0 |
| 2005-07-22 | ABK-DELISTED | Stock | 70.75 | 71.54 | 70.5 | 71.36 | 740900.0 |
| 2005-07-22 | ABM | Stock | 19.47 | 19.9 | 19.41 | 19.9 | 159200.0 |
| 2005-07-22 | ABMD-DELISTED | Stock | 9.11 | 9.75 | 9.11 | 9.7 | 77283.0 |
| 2005-07-22 | ABP-DELISTED | Stock | 3.7 | 3.99 | 3.65 | 3.95 | 621500.0 |
| 2005-07-22 | ABR | Stock | 30.08 | 30.08 | 29.83 | 29.9 | 139800.0 |
| 2005-07-22 | ABT | Stock | 22.2627 | 22.2867 | 22.0324 | 22.09 | 10948937.0 |
| 2005-07-22 | ABTL-DELISTED | Stock | 24.05 | 24.5 | 23.8 | 24.5 | 15499.0 |
| 2005-07-22 | ABV-DELISTED | Stock | 31.05 | 31.17 | 30.62 | 30.85 | 361600.0 |
| 2005-07-22 | ABVA-DELISTED | Stock | 15.55 | 15.946 | 15.55 | 15.74 | 2437.0 |
| 2005-07-22 | ABX-DELISTED | Stock | 24.79 | 24.84 | 24.48 | 24.73 | 1267300.0 |
| 2005-07-22 | ACAD | Stock | 9.19 | 9.46 | 9.15 | 9.33 | 18800.0 |
| 2005-07-22 | ACAP-DELISTED | Stock | 38.76 | 39.35 | 38.3 | 39.29 | 46962.0 |
| 2005-07-22 | ACAS-DELISTED | Stock | 37.5 | 37.78 | 37.48 | 37.74 | 350296.0 |
| 2005-07-22 | ACAT-DELISTED | Stock | 22.01 | 22.32 | 21.59 | 21.87 | 117144.0 |
| 2005-07-22 | ACC-DELISTED | Stock | 23.57 | 23.85 | 23.37 | 23.85 | 65100.0 |
| 2005-07-22 | ACCL-DELISTED | Stock | 5.63 | 5.64 | 5.5 | 5.56 | 50190.0 |
| 2005-07-22 | ACE-DELISTED | Stock | 46.16 | 46.65 | 45.94 | 46.54 | 726600.0 |
| 2005-07-22 | ACF-DELISTED | Stock | 26.9 | 27.15 | 26.89 | 27.13 | 692300.0 |
| 2005-07-22 | ACFC-DELISTED | Stock | 68.37 | 68.37 | 67.35 | 68.06 | 1610.0 |
| 2005-07-22 | ACG-DELISTED | Stock | 8.35 | 8.36 | 8.32 | 8.33 | 350500.0 |
| 2005-07-22 | ACGL | Stock | 4.8989 | 4.9133 | 4.8444 | 4.8611 | 1441800.0 |
| 2005-07-22 | ACGN-DELISTED | Stock | 600.6712 | 600.6712 | 544.0 | 578.0 | 181200.0 |
| 2005-07-22 | ACH | Stock | 19.8933 | 19.8933 | 18.9733 | 19.66 | 826350.0 |
| 2005-07-22 | ACH-DELISTED | Stock | 14.892 | 15.142 | 14.842 | 15.142 | 200201.0 |
| 2005-07-22 | ACLS | Stock | 28.72 | 29.68 | 28.4 | 29.68 | 170000.0 |
> showing 50 of 4,111 rows — these rows as CSV