PREVIEW / stock_daily / 2005-07-25
file: by_date/stock_daily/2005/2005-07-25.parquet size: 138 KB rows: 4,151 symbols: 2,615
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-25 | AAPL | Stock | 1.5711 | 1.5814 | 1.5618 | 1.5646 | 294627200.0 |
| 2005-07-25 | MSFT | Stock | 25.69 | 25.9 | 25.65 | 25.69 | 45174600.0 |
| 2005-07-25 | NVDA | Stock | 0.2127 | 0.2232 | 0.2118 | 0.2165 | 974952000.0 |
| 2005-07-25 | AMZN | Stock | 1.9 | 1.952 | 1.8925 | 1.8975 | 109400000.0 |
| 2005-07-25 | CL | Stock | 25.995 | 25.995 | 25.83 | 25.93 | 2773000.0 |
| 2005-07-25 | A | Stock | 18.2618 | 18.4549 | 18.226 | 18.3119 | 1645586.0 |
| 2005-07-25 | AABA-DELISTED | Stock | 33.8800010681152 | 34.0800018310547 | 33.5900001525879 | 33.8499984741211 | 23252600.0 |
| 2005-07-25 | AACC-DELISTED | Stock | 23.68 | 24.89 | 23.68 | 24.59 | 118244.0 |
| 2005-07-25 | AACQ-DELISTED | Stock | 5.0 | 5.0 | 5.0 | 5.0 | 10700.0 |
| 2005-07-25 | AACQU-DELISTED | Stock | 5.85 | 5.85 | 5.75 | 5.8 | 7000.0 |
| 2005-07-25 | AAI-DELISTED | Stock | 10.4 | 10.5 | 10.3 | 10.5 | 1273600.0 |
| 2005-07-25 | AAIC-DELISTED | Stock | 292.6 | 293.0 | 290.8 | 291.2 | 571200.0 |
| 2005-07-25 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 3000.0 |
| 2005-07-25 | AAON | Stock | 2.535 | 2.535 | 2.4454 | 2.4744 | 136687.0 |
| 2005-07-25 | AAP | Stock | 44.2133 | 44.32 | 43.5533 | 43.86 | 621300.0 |
| 2005-07-25 | AAV-DELISTED | Stock | 14.96 | 15.06 | 14.92 | 14.96 | 32600.0 |
| 2005-07-25 | AAXN-DELISTED | Stock | 9.69999980926514 | 9.72000026702881 | 9.55000019073486 | 9.65999984741211 | 1361600.0 |
| 2005-07-25 | ABAX-DELISTED | Stock | 12.22 | 12.5 | 12.12 | 12.28 | 124309.0 |
| 2005-07-25 | ABB-DELISTED | Stock | 6.48 | 6.51 | 6.46 | 6.46 | 408800.0 |
| 2005-07-25 | ABBC-DELISTED | Stock | 12.25 | 12.67 | 12.25 | 12.67 | 25541.0 |
| 2005-07-25 | ABC-DELISTED | Stock | 17.38 | 17.43 | 17.27 | 17.3 | 4238800.0 |
| 2005-07-25 | ABCB | Stock | 19.4529 | 19.4529 | 18.986 | 18.986 | 6580.0 |
| 2005-07-25 | ABCO-DELISTED | Stock | 24.63 | 24.91 | 24.57 | 24.59 | 151613.0 |
| 2005-07-25 | ABCW-DELISTED | Stock | 31.27 | 31.97 | 31.27 | 31.73 | 42060.0 |
| 2005-07-25 | ABE-DELISTED | Stock | 10.35 | 10.42 | 10.35 | 10.35 | 18200.0 |
| 2005-07-25 | ABFS-DELISTED | Stock | 35.86 | 36.1 | 34.75 | 34.75 | 412428.0 |
| 2005-07-25 | ABG | Stock | 17.1 | 17.24 | 16.8 | 16.81 | 69400.0 |
| 2005-07-25 | ABK-DELISTED | Stock | 71.1 | 71.55 | 70.75 | 70.98 | 851000.0 |
| 2005-07-25 | ABM | Stock | 19.8 | 19.97 | 19.65 | 19.75 | 145500.0 |
| 2005-07-25 | ABMD-DELISTED | Stock | 9.56 | 9.81 | 9.51 | 9.59 | 36158.0 |
| 2005-07-25 | ABP-DELISTED | Stock | 4.01 | 4.45 | 4.0 | 4.2 | 1054400.0 |
| 2005-07-25 | ABR | Stock | 29.95 | 30.16 | 29.63 | 29.87 | 92700.0 |
| 2005-07-25 | ABT | Stock | 22.1572 | 22.2339 | 21.687 | 21.8261 | 12144435.0 |
| 2005-07-25 | ABTL-DELISTED | Stock | 24.33 | 25.03 | 23.62 | 23.62 | 20052.0 |
| 2005-07-25 | ABV-DELISTED | Stock | 30.65 | 30.65 | 29.39 | 29.39 | 471900.0 |
| 2005-07-25 | ABVA-DELISTED | Stock | 15.69 | 15.92 | 15.55 | 15.55 | 3900.0 |
| 2005-07-25 | ABX-DELISTED | Stock | 24.75 | 24.77 | 24.55 | 24.67 | 1241800.0 |
| 2005-07-25 | ACAD | Stock | 9.17 | 9.65 | 9.17 | 9.45 | 87200.0 |
| 2005-07-25 | ACAP-DELISTED | Stock | 39.15 | 39.34 | 38.5 | 38.76 | 28924.0 |
| 2005-07-25 | ACAS-DELISTED | Stock | 37.75 | 37.8 | 37.34 | 37.48 | 444249.0 |
| 2005-07-25 | ACAT-DELISTED | Stock | 21.89 | 22.09 | 21.3 | 21.51 | 109403.0 |
| 2005-07-25 | ACC-DELISTED | Stock | 23.9 | 24.09 | 23.77 | 23.85 | 71400.0 |
| 2005-07-25 | ACCL-DELISTED | Stock | 5.49 | 5.59 | 5.49 | 5.58 | 78895.0 |
| 2005-07-25 | ACE-DELISTED | Stock | 46.34 | 46.53 | 46.19 | 46.27 | 848764.0 |
| 2005-07-25 | ACF-DELISTED | Stock | 26.96 | 27.05 | 26.57 | 26.74 | 944400.0 |
| 2005-07-25 | ACFC-DELISTED | Stock | 68.88 | 68.88 | 67.86 | 68.16 | 3332.0 |
| 2005-07-25 | ACG-DELISTED | Stock | 8.34 | 8.35 | 8.31 | 8.35 | 549500.0 |
| 2005-07-25 | ACGL | Stock | 4.8611 | 4.9622 | 4.8544 | 4.9256 | 834300.0 |
| 2005-07-25 | ACGN-DELISTED | Stock | 578.0 | 589.3288 | 544.0 | 578.0 | 160400.0 |
| 2005-07-25 | ACH | Stock | 19.6333 | 19.7333 | 18.74 | 19.08 | 425250.0 |
> showing 50 of 4,151 rows — these rows as CSV