PREVIEW / stock_daily / 2005-01-24
file: by_date/stock_daily/2005/2005-01-24.parquet size: 133 KB rows: 3,970 symbols: 2,480
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-01-24 | AAPL | Stock | 1.2675 | 1.2818 | 1.2598 | 1.2636 | 841629600.0 |
| 2005-01-24 | MSFT | Stock | 25.76 | 26.0 | 25.64 | 25.67 | 69010900.0 |
| 2005-01-24 | NVDA | Stock | 0.1777 | 0.1802 | 0.1705 | 0.1715 | 463704000.0 |
| 2005-01-24 | AMZN | Stock | 2.072 | 2.0975 | 2.0155 | 2.019 | 193918000.0 |
| 2005-01-24 | CL | Stock | 24.9 | 24.95 | 24.56 | 24.63 | 3898600.0 |
| 2005-01-24 | A | Stock | 15.608 | 15.6366 | 15.329 | 15.3362 | 4936757.0 |
| 2005-01-24 | AABA-DELISTED | Stock | 35.4799995422363 | 35.5200004577637 | 33.75 | 33.9300003051758 | 31477400.0 |
| 2005-01-24 | AACC-DELISTED | Stock | 21.25 | 21.25 | 19.66 | 20.45 | 91206.0 |
| 2005-01-24 | AAI-DELISTED | Stock | 7.9 | 7.95 | 7.4 | 7.51 | 1894600.0 |
| 2005-01-24 | AAIC-DELISTED | Stock | 393.4 | 393.6 | 384.0 | 389.0 | 895900.0 |
| 2005-01-24 | AAME | Stock | 3.14 | 3.14 | 3.0 | 3.03 | 6600.0 |
| 2005-01-24 | AAON | Stock | 1.8305 | 1.8581 | 1.8305 | 1.8449 | 88847.0 |
| 2005-01-24 | AAP | Stock | 28.5467 | 28.7733 | 28.16 | 28.1733 | 686400.0 |
| 2005-01-24 | AAV-DELISTED | Stock | 17.95 | 17.99 | 17.86 | 17.95 | 45300.0 |
| 2005-01-24 | AAXN-DELISTED | Stock | 17.2700004577637 | 17.7399997711182 | 15.5699996948242 | 15.9499998092651 | 9702500.0 |
| 2005-01-24 | ABAX-DELISTED | Stock | 12.95 | 13.05 | 12.5 | 12.65 | 115997.0 |
| 2005-01-24 | ABB-DELISTED | Stock | 5.56 | 5.56 | 5.5 | 5.51 | 761200.0 |
| 2005-01-24 | ABBC-DELISTED | Stock | 13.0 | 13.12 | 12.79 | 13.05 | 49415.0 |
| 2005-01-24 | ABC-DELISTED | Stock | 14.26 | 14.54 | 14.16 | 14.39 | 7221200.0 |
| 2005-01-24 | ABCB | Stock | 15.6433 | 15.8703 | 15.6028 | 15.6839 | 7156.0 |
| 2005-01-24 | ABCO-DELISTED | Stock | 17.852 | 17.852 | 17.428 | 17.478 | 147433.0 |
| 2005-01-24 | ABCW-DELISTED | Stock | 27.41 | 27.41 | 26.96 | 27.04 | 12830.0 |
| 2005-01-24 | ABE-DELISTED | Stock | 9.31 | 9.48 | 9.31 | 9.45 | 61600.0 |
| 2005-01-24 | ABFS-DELISTED | Stock | 38.8 | 39.86 | 38.8 | 38.92 | 271088.0 |
| 2005-01-24 | ABG | Stock | 16.85 | 17.35 | 16.85 | 17.22 | 154400.0 |
| 2005-01-24 | ABK-DELISTED | Stock | 79.6 | 79.86 | 78.73 | 79.0 | 557200.0 |
| 2005-01-24 | ABM | Stock | 18.07 | 18.24 | 17.83 | 17.99 | 195200.0 |
| 2005-01-24 | ABMD-DELISTED | Stock | 11.04 | 11.48 | 11.01 | 11.06 | 120544.0 |
| 2005-01-24 | ABP-DELISTED | Stock | 2.25 | 2.3 | 2.24 | 2.24 | 98300.0 |
| 2005-01-24 | ABR | Stock | 24.12 | 24.58 | 23.99 | 24.57 | 32700.0 |
| 2005-01-24 | ABT | Stock | 22.066 | 22.2339 | 21.9988 | 22.0372 | 8083576.0 |
| 2005-01-24 | ABTL-DELISTED | Stock | 28.1 | 28.25 | 26.15 | 26.65 | 40200.0 |
| 2005-01-24 | ABV-DELISTED | Stock | 25.4 | 25.5 | 25.2 | 25.47 | 189700.0 |
| 2005-01-24 | ABVA-DELISTED | Stock | 15.8 | 15.8 | 15.8 | 15.8 | 300.0 |
| 2005-01-24 | ABX-DELISTED | Stock | 22.73 | 22.9 | 22.62 | 22.82 | 1403800.0 |
| 2005-01-24 | ACAD | Stock | 6.74 | 6.78 | 6.25 | 6.42 | 10200.0 |
| 2005-01-24 | ACAP-DELISTED | Stock | 35.19 | 35.21 | 34.59 | 34.63 | 30137.0 |
| 2005-01-24 | ACAS-DELISTED | Stock | 32.99 | 33.24 | 32.8 | 32.94 | 599281.0 |
| 2005-01-24 | ACAT-DELISTED | Stock | 25.35 | 25.5 | 25.01 | 25.03 | 31578.0 |
| 2005-01-24 | ACC-DELISTED | Stock | 21.89 | 21.89 | 21.55 | 21.56 | 17700.0 |
| 2005-01-24 | ACCL-DELISTED | Stock | 5.8 | 5.9 | 5.1 | 5.16 | 181083.0 |
| 2005-01-24 | ACE-DELISTED | Stock | 42.4 | 42.84 | 41.75 | 42.27 | 1110600.0 |
| 2005-01-24 | ACF-DELISTED | Stock | 23.1 | 23.1 | 22.55 | 22.8 | 1947300.0 |
| 2005-01-24 | ACFC-DELISTED | Stock | 65.82 | 65.82 | 64.8 | 65.31 | 2045.0 |
| 2005-01-24 | ACG-DELISTED | Stock | 8.18 | 8.23 | 8.17 | 8.2 | 736300.0 |
| 2005-01-24 | ACGL | Stock | 4.16 | 4.1811 | 4.1456 | 4.1544 | 568800.0 |
| 2005-01-24 | ACGN-DELISTED | Stock | 589.3288 | 736.6712 | 589.3288 | 646.0 | 1035300.0 |
| 2005-01-24 | ACH | Stock | 18.4667 | 18.5867 | 18.2667 | 18.3533 | 284400.0 |
| 2005-01-24 | ACH-DELISTED | Stock | 13.12 | 13.282 | 13.115 | 13.18 | 137242.0 |
| 2005-01-24 | ACLS | Stock | 28.28 | 28.6 | 27.2 | 27.72 | 181175.0 |
> showing 50 of 3,970 rows — these rows as CSV