PREVIEW / stock_daily / 2006-04-21
file: by_date/stock_daily/2006/2006-04-21.parquet size: 148 KB rows: 4,417 symbols: 2,793
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-21 | AAPL | Stock | 2.4354 | 2.4514 | 2.3739 | 2.3943 | 788986800.0 |
| 2006-04-21 | MSFT | Stock | 27.05 | 27.39 | 27.0 | 27.15 | 58528000.0 |
| 2006-04-21 | NVDA | Stock | 0.4868 | 0.4888 | 0.4622 | 0.4678 | 770016000.0 |
| 2006-04-21 | AMZN | Stock | 1.831 | 1.839 | 1.786 | 1.8015 | 88470000.0 |
| 2006-04-21 | CL | Stock | 28.65 | 28.67 | 28.275 | 28.43 | 3435600.0 |
| 2006-04-21 | A | Stock | 27.9328 | 27.9971 | 27.5823 | 27.7682 | 3201280.0 |
| 2006-04-21 | AABA-DELISTED | Stock | 33.3600006103516 | 34.0900001525879 | 32.7000007629395 | 32.8899993896484 | 25215000.0 |
| 2006-04-21 | AACC-DELISTED | Stock | 21.1 | 21.1 | 20.1 | 20.46 | 136693.0 |
| 2006-04-21 | AACQ-DELISTED | Stock | 5.36 | 5.36 | 5.34 | 5.36 | 32500.0 |
| 2006-04-21 | AACQU-DELISTED | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 2000.0 |
| 2006-04-21 | AACQW-DELISTED | Stock | 0.72 | 0.77 | 0.71 | 0.77 | 98700.0 |
| 2006-04-21 | AAI-DELISTED | Stock | 15.15 | 15.2 | 14.5 | 14.6 | 2071300.0 |
| 2006-04-21 | AAIC-DELISTED | Stock | 186.6 | 188.0 | 185.0 | 187.0 | 420900.0 |
| 2006-04-21 | AAME | Stock | 2.82 | 2.83 | 2.8 | 2.83 | 10800.0 |
| 2006-04-21 | AAON | Stock | 3.254 | 3.254 | 3.1605 | 3.1802 | 191362.0 |
| 2006-04-21 | AAP | Stock | 39.55 | 39.63 | 38.72 | 38.92 | 978100.0 |
| 2006-04-21 | AATI-DELISTED | Stock | 12.05 | 12.1 | 11.75 | 11.8299 | 574552.0 |
| 2006-04-21 | AAU-DELISTED | Stock | 2.71 | 2.82 | 2.71 | 2.75 | 156400.0 |
| 2006-04-21 | AAUAF-DELISTED | Stock | 2.71 | 2.82 | 2.71 | 2.75 | 156400.0 |
| 2006-04-21 | AAV-DELISTED | Stock | 20.12 | 20.43 | 20.0401 | 20.2 | 369400.0 |
| 2006-04-21 | AAWW-DELISTED | Stock | 46.0 | 46.0 | 45.5 | 46.0 | 2000.0 |
| 2006-04-21 | AAXN-DELISTED | Stock | 10.789999961853 | 10.9499998092651 | 10.3000001907349 | 10.3400001525879 | 1310000.0 |
| 2006-04-21 | AB | Stock | 72.0 | 72.0 | 69.85 | 70.06 | 235800.0 |
| 2006-04-21 | ABAX-DELISTED | Stock | 26.12 | 26.16 | 25.05 | 25.52 | 224782.0 |
| 2006-04-21 | ABB-DELISTED | Stock | 13.69 | 13.88 | 13.6 | 13.7801 | 1546200.0 |
| 2006-04-21 | ABBC-DELISTED | Stock | 13.4 | 13.4 | 13.36 | 13.36 | 5060.0 |
| 2006-04-21 | ABC-DELISTED | Stock | 23.93 | 23.94 | 23.38 | 23.44 | 2170800.0 |
| 2006-04-21 | ABCB | Stock | 22.4291 | 22.6626 | 21.8455 | 22.2638 | 14599.0 |
| 2006-04-21 | ABCO-DELISTED | Stock | 28.1 | 28.1 | 27.34 | 27.55 | 85732.0 |
| 2006-04-21 | ABCW-DELISTED | Stock | 29.24 | 29.33 | 28.6 | 28.75 | 49450.0 |
| 2006-04-21 | ABD-DELISTED | Stock | 21.52 | 22.17 | 21.52 | 21.7 | 155570.0 |
| 2006-04-21 | ABE-DELISTED | Stock | 13.19 | 13.44 | 13.19 | 13.44 | 17600.0 |
| 2006-04-21 | ABFS-DELISTED | Stock | 43.08 | 43.53 | 42.35 | 42.79 | 500249.0 |
| 2006-04-21 | ABG | Stock | 18.8 | 19.09 | 18.42 | 18.8 | 158900.0 |
| 2006-04-21 | ABK-DELISTED | Stock | 79.03 | 79.03 | 78.43 | 78.61 | 526000.0 |
| 2006-04-21 | ABM | Stock | 17.7 | 17.7 | 17.22 | 17.41 | 199400.0 |
| 2006-04-21 | ABMD-DELISTED | Stock | 14.05 | 14.08 | 13.62 | 13.79 | 124962.0 |
| 2006-04-21 | ABP-DELISTED | Stock | 6.11 | 6.5 | 5.96 | 6.48 | 819600.0 |
| 2006-04-21 | ABR | Stock | 25.85 | 26.36 | 25.8 | 26.0 | 176000.0 |
| 2006-04-21 | ABT | Stock | 20.1756 | 20.1996 | 20.0125 | 20.1516 | 12847853.0 |
| 2006-04-21 | ABTL-DELISTED | Stock | 22.95 | 23.25 | 22.25 | 22.55 | 24238.0 |
| 2006-04-21 | ABV-DELISTED | Stock | 47.35 | 48.74 | 47.35 | 48.5 | 163500.0 |
| 2006-04-21 | ABVA-DELISTED | Stock | 18.752 | 18.81 | 18.716 | 18.718 | 13796.0 |
| 2006-04-21 | ABX-DELISTED | Stock | 29.96 | 30.46 | 29.7 | 30.1 | 5278700.0 |
| 2006-04-21 | ACAD | Stock | 15.25 | 15.31 | 15.05 | 15.16 | 195300.0 |
| 2006-04-21 | ACAP-DELISTED | Stock | 48.5 | 49.86 | 48.28 | 49.34 | 44833.0 |
| 2006-04-21 | ACAS-DELISTED | Stock | 34.44 | 34.63 | 34.17 | 34.38 | 864882.0 |
| 2006-04-21 | ACAT-DELISTED | Stock | 21.34 | 21.34 | 20.83 | 21.3 | 81311.0 |
| 2006-04-21 | ACC-DELISTED | Stock | 25.75 | 25.91 | 24.9 | 24.9 | 104500.0 |
| 2006-04-21 | ACCL-DELISTED | Stock | 7.34 | 7.4 | 7.25 | 7.27 | 35908.0 |
> showing 50 of 4,417 rows — these rows as CSV