PREVIEW / stock_daily / 2009-04-08
file: by_date/stock_daily/2009/2009-04-08.parquet size: 174 KB rows: 5,695 symbols: 3,407
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-08 | AAPL | Stock | 4.1225 | 4.1711 | 4.0921 | 4.1543 | 455630000.0 |
| 2009-04-08 | MSFT | Stock | 18.97 | 19.62 | 18.96 | 19.19 | 56408900.0 |
| 2009-04-08 | NVDA | Stock | 0.277 | 0.286 | 0.2748 | 0.2852 | 731652000.0 |
| 2009-04-08 | AMZN | Stock | 3.7965 | 3.8555 | 3.7285 | 3.849 | 113060000.0 |
| 2009-04-08 | TLT | Stock | 103.07 | 103.86 | 102.95 | 103.65 | 1007779.0 |
| 2009-04-08 | ES | Stock | 21.58 | 21.58 | 21.09 | 21.52 | 2295300.0 |
| 2009-04-08 | CL | Stock | 30.195 | 30.46 | 29.875 | 30.31 | 6959600.0 |
| 2009-04-08 | A | Stock | 11.0515 | 11.6953 | 11.0515 | 11.588 | 4806883.0 |
| 2009-04-08 | AABA-DELISTED | Stock | 12.9 | 13.01 | 12.75 | 12.92 | 8051170.0 |
| 2009-04-08 | AACC-DELISTED | Stock | 6.01 | 6.5 | 6.01 | 6.47 | 49399.0 |
| 2009-04-08 | AACG | Stock | 4.15 | 4.3 | 4.13 | 4.3 | 32700.0 |
| 2009-04-08 | AAI-DELISTED | Stock | 5.04 | 5.18 | 4.97 | 5.12 | 1293722.0 |
| 2009-04-08 | AAIC-DELISTED | Stock | 6.2 | 7.6 | 6.0 | 6.2 | 935581.0 |
| 2009-04-08 | AAME | Stock | 0.56 | 0.67 | 0.56 | 0.6 | 3800.0 |
| 2009-04-08 | AAON | Stock | 3.4015 | 3.4015 | 3.281 | 3.3956 | 383737.0 |
| 2009-04-08 | AAP | Stock | 40.04 | 41.04 | 39.31 | 40.68 | 1872200.0 |
| 2009-04-08 | AATI-DELISTED | Stock | 3.79 | 4.0425 | 3.79 | 4.01 | 157560.0 |
| 2009-04-08 | AAU-DELISTED | Stock | 0.72 | 0.72 | 0.64 | 0.64 | 168204.0 |
| 2009-04-08 | AAUAF-DELISTED | Stock | 0.72 | 0.72 | 0.64 | 0.64 | 168304.0 |
| 2009-04-08 | AAV-DELISTED | Stock | 2.38 | 2.59 | 2.37 | 2.54 | 1081671.0 |
| 2009-04-08 | AAWW-DELISTED | Stock | 17.56 | 18.28 | 16.85 | 18.14 | 466474.0 |
| 2009-04-08 | AAXJ | Stock | 35.6 | 35.6872 | 35.1 | 35.64 | 49117.0 |
| 2009-04-08 | AAXN-DELISTED | Stock | 4.78 | 5.0 | 4.76 | 4.82 | 877213.0 |
| 2009-04-08 | AB | Stock | 16.55 | 16.87 | 15.84 | 16.57 | 533600.0 |
| 2009-04-08 | ABAX-DELISTED | Stock | 15.52 | 15.98 | 15.1 | 15.95 | 503176.0 |
| 2009-04-08 | ABB-DELISTED | Stock | 14.2 | 14.48 | 14.01 | 14.38 | 3005833.0 |
| 2009-04-08 | ABBC-DELISTED | Stock | 8.35 | 8.72 | 8.3 | 8.59 | 31826.0 |
| 2009-04-08 | ABBNY-DELISTED | Stock | 14.2 | 14.48 | 14.01 | 14.38 | 3009333.0 |
| 2009-04-08 | ABC-DELISTED | Stock | 16.24 | 16.46 | 16.06 | 16.29 | 2003622.0 |
| 2009-04-08 | ABCB | Stock | 5.7385 | 6.6626 | 5.7385 | 6.0012 | 9767.0 |
| 2009-04-08 | ABCO-DELISTED | Stock | 8.325 | 8.51 | 8.32 | 8.48 | 60958.0 |
| 2009-04-08 | ABCW-DELISTED | Stock | 1.35 | 1.52 | 1.35 | 1.5 | 139520.0 |
| 2009-04-08 | ABD-DELISTED | Stock | 1.13 | 1.45 | 1.13 | 1.22 | 472690.0 |
| 2009-04-08 | ABE-DELISTED | Stock | 12.3709 | 12.5879 | 12.292 | 12.46 | 5368.0 |
| 2009-04-08 | ABEO | Stock | 2012.5 | 2125.0 | 2012.5 | 2125.0 | 5.0 |
| 2009-04-08 | ABFS-DELISTED | Stock | 18.3 | 19.39 | 18.21 | 19.29 | 584314.0 |
| 2009-04-08 | ABG | Stock | 4.92 | 5.51 | 4.92 | 5.38 | 730300.0 |
| 2009-04-08 | ABII-DELISTED | Stock | 44.1 | 44.65 | 43.02 | 44.53 | 13476.0 |
| 2009-04-08 | ABK-DELISTED | Stock | 0.92 | 0.925 | 0.85 | 0.86 | 5790177.0 |
| 2009-04-08 | ABM | Stock | 16.73 | 16.82 | 16.24 | 16.7 | 538300.0 |
| 2009-04-08 | ABMD-DELISTED | Stock | 5.2 | 5.31 | 5.03 | 5.23 | 247480.0 |
| 2009-04-08 | ABR | Stock | 0.8 | 0.89 | 0.79 | 0.81 | 120300.0 |
| 2009-04-08 | ABT | Stock | 20.7657 | 21.3511 | 20.665 | 20.9529 | 32478116.0 |
| 2009-04-08 | ABTL-DELISTED | Stock | 1.4259 | 1.4259 | 1.3481 | 1.4 | 9182.0 |
| 2009-04-08 | ABV-DELISTED | Stock | 52.0 | 52.0 | 48.89 | 49.18 | 1599298.0 |
| 2009-04-08 | ABVA-DELISTED | Stock | 2.0 | 2.0 | 1.98 | 1.98 | 21400.0 |
| 2009-04-08 | ABVT-DELISTED | Stock | 49.0 | 49.0 | 47.0 | 47.5 | 9150.0 |
| 2009-04-08 | ABX-DELISTED | Stock | 29.45 | 29.5 | 28.27 | 28.84 | 10441610.0 |
| 2009-04-08 | ACAD | Stock | 1.05 | 1.13 | 1.05 | 1.13 | 79000.0 |
| 2009-04-08 | ACAP-DELISTED | Stock | 41.71 | 42.0 | 41.2425 | 41.84 | 22251.0 |
> showing 50 of 5,695 rows — these rows as CSV