PREVIEW / stock_daily / 2005-04-28
file: by_date/stock_daily/2005/2005-04-28.parquet size: 134 KB rows: 4,026 symbols: 2,513
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-04-28 | AAPL | Stock | 1.2961 | 1.2979 | 1.2586 | 1.2693 | 575106000.0 |
| 2005-04-28 | MSFT | Stock | 24.82 | 24.92 | 24.44 | 24.45 | 83623100.0 |
| 2005-04-28 | NVDA | Stock | 0.1797 | 0.1832 | 0.1779 | 0.1808 | 372948000.0 |
| 2005-04-28 | AMZN | Stock | 1.583 | 1.646 | 1.5815 | 1.626 | 289456000.0 |
| 2005-04-28 | CL | Stock | 25.315 | 25.54 | 25.165 | 25.21 | 4446000.0 |
| 2005-04-28 | A | Stock | 15.093 | 15.1502 | 14.7711 | 14.7711 | 2629358.0 |
| 2005-04-28 | AABA-DELISTED | Stock | 34.7000007629395 | 34.9300003051758 | 34.0200004577637 | 34.3300018310547 | 16159300.0 |
| 2005-04-28 | AACC-DELISTED | Stock | 20.36 | 20.65 | 19.88 | 20.18 | 104418.0 |
| 2005-04-28 | AACQ-DELISTED | Stock | 5.14 | 5.15 | 5.14 | 5.15 | 8000.0 |
| 2005-04-28 | AAI-DELISTED | Stock | 8.08 | 8.27 | 8.02 | 8.03 | 1312200.0 |
| 2005-04-28 | AAIC-DELISTED | Stock | 252.0 | 253.0 | 242.0 | 247.6 | 2227100.0 |
| 2005-04-28 | AAME | Stock | 3.07 | 3.07 | 3.0 | 3.07 | 2400.0 |
| 2005-04-28 | AAON | Stock | 2.3941 | 2.4349 | 2.373 | 2.4112 | 220219.0 |
| 2005-04-28 | AAP | Stock | 35.4667 | 35.72 | 35.2867 | 35.6533 | 1833000.0 |
| 2005-04-28 | AAV-DELISTED | Stock | 15.13 | 15.36 | 15.05 | 15.13 | 46000.0 |
| 2005-04-28 | AAXN-DELISTED | Stock | 9.10999965667725 | 9.31999969482422 | 8.73999977111816 | 8.8100004196167 | 2991400.0 |
| 2005-04-28 | ABAX-DELISTED | Stock | 7.61 | 8.34 | 7.46 | 8.01 | 214615.0 |
| 2005-04-28 | ABB-DELISTED | Stock | 6.21 | 6.21 | 6.07 | 6.1 | 767300.0 |
| 2005-04-28 | ABBC-DELISTED | Stock | 11.38 | 11.45 | 11.15 | 11.16 | 66774.0 |
| 2005-04-28 | ABC-DELISTED | Stock | 15.1 | 15.26 | 15.02 | 15.08 | 3706000.0 |
| 2005-04-28 | ABCB | Stock | 17.4589 | 17.5562 | 17.0213 | 17.0504 | 8945.0 |
| 2005-04-28 | ABCO-DELISTED | Stock | 21.04 | 21.04 | 20.35 | 20.47 | 200317.0 |
| 2005-04-28 | ABCW-DELISTED | Stock | 26.64 | 26.7 | 26.29 | 26.34 | 50800.0 |
| 2005-04-28 | ABE-DELISTED | Stock | 9.4 | 9.4 | 9.35 | 9.38 | 2200.0 |
| 2005-04-28 | ABFS-DELISTED | Stock | 31.6 | 31.93 | 31.29 | 31.3 | 422123.0 |
| 2005-04-28 | ABG | Stock | 14.0 | 14.0 | 13.77 | 13.8 | 58900.0 |
| 2005-04-28 | ABK-DELISTED | Stock | 66.73 | 66.9 | 65.61 | 65.93 | 1147000.0 |
| 2005-04-28 | ABM | Stock | 18.27 | 18.41 | 18.18 | 18.35 | 131600.0 |
| 2005-04-28 | ABMD-DELISTED | Stock | 10.7 | 10.7 | 10.15 | 10.15 | 75492.0 |
| 2005-04-28 | ABP-DELISTED | Stock | 2.45 | 2.47 | 2.29 | 2.31 | 168100.0 |
| 2005-04-28 | ABR | Stock | 25.44 | 25.44 | 25.15 | 25.15 | 38200.0 |
| 2005-04-28 | ABT | Stock | 23.1072 | 23.2991 | 23.0736 | 23.0736 | 7940600.0 |
| 2005-04-28 | ABTL-DELISTED | Stock | 23.6 | 24.65 | 23.25 | 23.7 | 52500.0 |
| 2005-04-28 | ABV-DELISTED | Stock | 27.76 | 27.91 | 27.21 | 27.23 | 428900.0 |
| 2005-04-28 | ABVA-DELISTED | Stock | 14.99 | 15.0 | 14.99 | 15.0 | 1996.0 |
| 2005-04-28 | ABVT-DELISTED | Stock | 29.0 | 29.75 | 29.0 | 29.75 | 4900.0 |
| 2005-04-28 | ABX-DELISTED | Stock | 21.93 | 22.03 | 21.51 | 21.81 | 2269500.0 |
| 2005-04-28 | ACAD | Stock | 7.95 | 7.95 | 7.51 | 7.51 | 6000.0 |
| 2005-04-28 | ACAP-DELISTED | Stock | 30.67 | 30.89 | 29.17 | 29.55 | 100434.0 |
| 2005-04-28 | ACAS-DELISTED | Stock | 32.35 | 32.36 | 31.86 | 31.89 | 462474.0 |
| 2005-04-28 | ACAT-DELISTED | Stock | 23.86 | 24.14 | 23.36 | 23.7 | 108166.0 |
| 2005-04-28 | ACC-DELISTED | Stock | 20.65 | 21.3 | 20.55 | 21.1 | 52500.0 |
| 2005-04-28 | ACCL-DELISTED | Stock | 5.4 | 5.46 | 5.04 | 5.04 | 220851.0 |
| 2005-04-28 | ACE-DELISTED | Stock | 41.66 | 42.31 | 41.4 | 41.66 | 1549146.0 |
| 2005-04-28 | ACF-DELISTED | Stock | 23.52 | 23.85 | 23.22 | 23.57 | 1444900.0 |
| 2005-04-28 | ACFC-DELISTED | Stock | 56.38 | 56.38 | 55.51 | 55.51 | 1849.0 |
| 2005-04-28 | ACG-DELISTED | Stock | 8.14 | 8.15 | 8.11 | 8.13 | 396400.0 |
| 2005-04-28 | ACGL | Stock | 4.4844 | 4.4844 | 4.41 | 4.4444 | 792000.0 |
| 2005-04-28 | ACGN-DELISTED | Stock | 623.3288 | 646.0 | 600.6712 | 634.6712 | 25800.0 |
| 2005-04-28 | ACH | Stock | 19.5467 | 19.9867 | 19.1933 | 19.72 | 748200.0 |
> showing 50 of 4,026 rows — these rows as CSV