PREVIEW / stock_daily / 2005-05-27
file: by_date/stock_daily/2005/2005-05-27.parquet size: 135 KB rows: 4,036 symbols: 2,519
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-05-27 | AAPL | Stock | 1.4514 | 1.4568 | 1.4289 | 1.4486 | 316008000.0 |
| 2005-05-27 | MSFT | Stock | 25.83 | 26.09 | 25.81 | 26.07 | 54978000.0 |
| 2005-05-27 | NVDA | Stock | 0.2315 | 0.2315 | 0.2269 | 0.2293 | 322740000.0 |
| 2005-05-27 | AMZN | Stock | 1.761 | 1.7775 | 1.7575 | 1.775 | 65742000.0 |
| 2005-05-27 | CL | Stock | 25.11 | 25.235 | 25.01 | 25.03 | 2411400.0 |
| 2005-05-27 | A | Stock | 16.9886 | 17.1388 | 16.9313 | 17.103 | 1156286.0 |
| 2005-05-27 | AABA-DELISTED | Stock | 36.9799995422363 | 37.4700012207031 | 36.9500007629395 | 37.2700004577637 | 10256600.0 |
| 2005-05-27 | AACC-DELISTED | Stock | 23.32 | 23.44 | 22.88 | 23.0 | 158199.0 |
| 2005-05-27 | AAI-DELISTED | Stock | 10.01 | 10.02 | 9.85 | 9.95 | 1489100.0 |
| 2005-05-27 | AAIC-DELISTED | Stock | 256.2 | 258.4 | 251.0 | 257.4 | 1598800.0 |
| 2005-05-27 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 1000.0 |
| 2005-05-27 | AAON | Stock | 2.3546 | 2.3704 | 2.3388 | 2.3572 | 69103.0 |
| 2005-05-27 | AAP | Stock | 39.5333 | 39.5667 | 39.0333 | 39.2733 | 758100.0 |
| 2005-05-27 | AAV-DELISTED | Stock | 13.94 | 13.94 | 13.74 | 13.94 | 50500.0 |
| 2005-05-27 | AAXN-DELISTED | Stock | 11.1700000762939 | 11.2600002288818 | 10.9099998474121 | 10.9700002670288 | 3216400.0 |
| 2005-05-27 | ABAX-DELISTED | Stock | 10.61 | 10.9 | 10.52 | 10.65 | 55903.0 |
| 2005-05-27 | ABB-DELISTED | Stock | 6.59 | 6.75 | 6.59 | 6.72 | 1708200.0 |
| 2005-05-27 | ABBC-DELISTED | Stock | 10.52 | 10.91 | 10.52 | 10.91 | 27692.0 |
| 2005-05-27 | ABC-DELISTED | Stock | 16.36 | 16.36 | 16.23 | 16.25 | 3330000.0 |
| 2005-05-27 | ABCB | Stock | 17.0115 | 17.3325 | 17.0115 | 17.3325 | 6477.0 |
| 2005-05-27 | ABCO-DELISTED | Stock | 22.69 | 22.93 | 22.23 | 22.57 | 210390.0 |
| 2005-05-27 | ABCW-DELISTED | Stock | 27.56 | 27.86 | 27.5 | 27.77 | 34390.0 |
| 2005-05-27 | ABE-DELISTED | Stock | 9.65 | 9.66 | 9.63 | 9.66 | 8000.0 |
| 2005-05-27 | ABFS-DELISTED | Stock | 33.66 | 33.68 | 33.01 | 33.07 | 98876.0 |
| 2005-05-27 | ABG | Stock | 14.88 | 14.88 | 14.29 | 14.31 | 35300.0 |
| 2005-05-27 | ABK-DELISTED | Stock | 72.55 | 72.95 | 72.28 | 72.44 | 348400.0 |
| 2005-05-27 | ABM | Stock | 19.05 | 19.25 | 18.91 | 19.22 | 76600.0 |
| 2005-05-27 | ABMD-DELISTED | Stock | 10.29 | 10.32 | 10.18 | 10.25 | 49511.0 |
| 2005-05-27 | ABP-DELISTED | Stock | 2.55 | 2.65 | 2.5 | 2.55 | 108800.0 |
| 2005-05-27 | ABR | Stock | 26.64 | 26.65 | 26.55 | 26.65 | 19600.0 |
| 2005-05-27 | ABT | Stock | 23.2223 | 23.3183 | 22.9968 | 23.0304 | 4114006.0 |
| 2005-05-27 | ABTL-DELISTED | Stock | 20.4 | 20.75 | 20.25 | 20.5 | 52200.0 |
| 2005-05-27 | ABV-DELISTED | Stock | 29.98 | 30.46 | 29.93 | 30.45 | 508400.0 |
| 2005-05-27 | ABX-DELISTED | Stock | 22.3 | 23.1 | 22.3 | 23.01 | 2040000.0 |
| 2005-05-27 | ACAD | Stock | 9.02 | 9.02 | 8.4 | 8.65 | 51300.0 |
| 2005-05-27 | ACAP-DELISTED | Stock | 34.0 | 34.08 | 33.63 | 33.93 | 25556.0 |
| 2005-05-27 | ACAS-DELISTED | Stock | 34.79 | 34.95 | 34.52 | 34.71 | 558298.0 |
| 2005-05-27 | ACAT-DELISTED | Stock | 21.85 | 23.19 | 21.66 | 22.4 | 64429.0 |
| 2005-05-27 | ACC-DELISTED | Stock | 20.3 | 20.5 | 20.3 | 20.5 | 1900.0 |
| 2005-05-27 | ACCL-DELISTED | Stock | 5.31 | 5.35 | 5.24 | 5.32 | 120692.0 |
| 2005-05-27 | ACE-DELISTED | Stock | 43.36 | 43.53 | 43.11 | 43.39 | 475776.0 |
| 2005-05-27 | ACF-DELISTED | Stock | 24.88 | 25.09 | 24.61 | 24.95 | 820600.0 |
| 2005-05-27 | ACFC-DELISTED | Stock | 58.06 | 59.49 | 58.06 | 59.18 | 959.0 |
| 2005-05-27 | ACG-DELISTED | Stock | 8.22 | 8.25 | 8.22 | 8.24 | 254000.0 |
| 2005-05-27 | ACGL | Stock | 4.8344 | 4.8778 | 4.8344 | 4.8533 | 243900.0 |
| 2005-05-27 | ACGN-DELISTED | Stock | 759.3288 | 793.3288 | 759.3288 | 793.3288 | 227300.0 |
| 2005-05-27 | ACH | Stock | 20.6333 | 20.8533 | 20.44 | 20.7 | 108300.0 |
| 2005-05-27 | ACH-DELISTED | Stock | 12.725 | 12.748 | 12.66 | 12.745 | 122000.0 |
| 2005-05-27 | ACLS | Stock | 26.4 | 26.4 | 25.68 | 26.2 | 147025.0 |
| 2005-05-27 | ACO-DELISTED | Stock | 19.23 | 19.52 | 19.12 | 19.48 | 61600.0 |
> showing 50 of 4,036 rows — these rows as CSV