PREVIEW / stock_daily / 2009-12-08
file: by_date/stock_daily/2009/2009-12-08.parquet size: 186 KB rows: 5,863 symbols: 3,473
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-12-08 | AAPL | Stock | 6.7629 | 6.8696 | 6.7393 | 6.7811 | 690398800.0 |
| 2009-12-08 | MSFT | Stock | 29.52 | 29.74 | 29.38 | 29.57 | 37402200.0 |
| 2009-12-08 | NVDA | Stock | 0.3958 | 0.3975 | 0.3805 | 0.3828 | 1075512000.0 |
| 2009-12-08 | AMZN | Stock | 6.715 | 6.804 | 6.6435 | 6.7055 | 160056000.0 |
| 2009-12-08 | TLT | Stock | 94.05 | 94.37 | 93.37 | 93.6 | 2378629.0 |
| 2009-12-08 | ES | Stock | 24.66 | 24.87 | 24.43 | 24.74 | 993000.0 |
| 2009-12-08 | CL | Stock | 41.29 | 41.31 | 40.89 | 41.0 | 6224600.0 |
| 2009-12-08 | A | Stock | 21.1445 | 21.2947 | 20.9013 | 21.166 | 2677729.0 |
| 2009-12-08 | AABA-DELISTED | Stock | 15.47 | 15.9 | 15.23 | 15.46 | 30441469.0 |
| 2009-12-08 | AACC-DELISTED | Stock | 6.08 | 6.1501 | 5.94 | 6.02 | 38613.0 |
| 2009-12-08 | AACG | Stock | 5.0 | 5.04 | 4.99 | 4.99 | 2500.0 |
| 2009-12-08 | AAI-DELISTED | Stock | 5.02 | 5.15 | 4.96 | 5.07 | 2564364.0 |
| 2009-12-08 | AAIC-DELISTED | Stock | 14.74 | 14.75 | 14.52 | 14.61 | 46604.0 |
| 2009-12-08 | AAME | Stock | 1.3 | 1.36 | 1.29 | 1.36 | 2400.0 |
| 2009-12-08 | AAON | Stock | 3.7649 | 3.8123 | 3.68 | 3.7096 | 464737.0 |
| 2009-12-08 | AAP | Stock | 40.33 | 40.91 | 39.84 | 40.44 | 1639500.0 |
| 2009-12-08 | AATI-DELISTED | Stock | 3.66 | 3.7 | 3.605 | 3.68 | 414755.0 |
| 2009-12-08 | AAU-DELISTED | Stock | 1.1 | 1.1 | 1.0 | 1.0264 | 170224.0 |
| 2009-12-08 | AAUAF-DELISTED | Stock | 1.1 | 1.1 | 1.0 | 1.0264 | 173524.0 |
| 2009-12-08 | AAV-DELISTED | Stock | 5.61 | 5.78 | 5.5295 | 5.74 | 944458.0 |
| 2009-12-08 | AAWW-DELISTED | Stock | 34.29 | 35.68 | 34.0 | 35.56 | 693464.0 |
| 2009-12-08 | AAXJ | Stock | 55.7 | 55.7 | 55.08 | 55.27 | 1636859.0 |
| 2009-12-08 | AAXN-DELISTED | Stock | 4.32 | 4.38 | 4.249 | 4.37 | 330348.0 |
| 2009-12-08 | AB | Stock | 26.64 | 26.78 | 25.87 | 26.05 | 300400.0 |
| 2009-12-08 | ABAX-DELISTED | Stock | 23.75 | 24.08 | 23.47 | 23.81 | 81782.0 |
| 2009-12-08 | ABB-DELISTED | Stock | 18.05 | 18.15 | 17.9 | 18.04 | 5462075.0 |
| 2009-12-08 | ABBC-DELISTED | Stock | 6.95 | 7.06 | 6.84 | 6.88 | 41920.0 |
| 2009-12-08 | ABBNY-DELISTED | Stock | 18.05 | 18.15 | 17.9 | 18.04 | 5464625.0 |
| 2009-12-08 | ABC-DELISTED | Stock | 24.63 | 24.68 | 24.2 | 24.21 | 3555503.0 |
| 2009-12-08 | ABCB | Stock | 6.7138 | 6.8119 | 6.508 | 6.5178 | 26017.0 |
| 2009-12-08 | ABCO-DELISTED | Stock | 13.135 | 13.275 | 13.07 | 13.115 | 58126.0 |
| 2009-12-08 | ABCW-DELISTED | Stock | 0.72 | 0.72 | 0.65 | 0.65 | 178610.0 |
| 2009-12-08 | ABD-DELISTED | Stock | 6.95 | 7.06 | 6.75 | 6.96 | 282230.0 |
| 2009-12-08 | ABE-DELISTED | Stock | 16.63 | 16.9 | 16.52 | 16.54 | 22741.0 |
| 2009-12-08 | ABEO | Stock | 3475.0 | 3625.0 | 3437.5 | 3500.0 | 16.0 |
| 2009-12-08 | ABFS-DELISTED | Stock | 26.83 | 28.94 | 26.78 | 28.73 | 763141.0 |
| 2009-12-08 | ABG | Stock | 11.8 | 11.9 | 11.42 | 11.57 | 353300.0 |
| 2009-12-08 | ABII-DELISTED | Stock | 36.26 | 37.57 | 36.26 | 37.57 | 34688.0 |
| 2009-12-08 | ABK-DELISTED | Stock | 0.84 | 0.84 | 0.8 | 0.82 | 5457981.0 |
| 2009-12-08 | ABM | Stock | 20.6 | 20.82 | 19.87 | 20.0 | 310400.0 |
| 2009-12-08 | ABMD-DELISTED | Stock | 9.14 | 9.23 | 8.99 | 9.1 | 80520.0 |
| 2009-12-08 | ABR | Stock | 1.74 | 1.86 | 1.73 | 1.77 | 137100.0 |
| 2009-12-08 | ABT | Stock | 25.6789 | 25.7365 | 25.4006 | 25.5446 | 12060025.0 |
| 2009-12-08 | ABTL-DELISTED | Stock | 5.5 | 5.6 | 5.1 | 5.35 | 13176.0 |
| 2009-12-08 | ABV-DELISTED | Stock | 98.54 | 99.52 | 96.29 | 96.96 | 535756.0 |
| 2009-12-08 | ABVA-DELISTED | Stock | 2.69 | 2.74 | 2.45 | 2.45 | 2833.0 |
| 2009-12-08 | ABVT-DELISTED | Stock | 57.74 | 57.8 | 57.1 | 57.58 | 94928.0 |
| 2009-12-08 | ABX-DELISTED | Stock | 41.67 | 41.73 | 40.33 | 40.52 | 19989523.0 |
| 2009-12-08 | ACAD | Stock | 1.2 | 1.21 | 1.18 | 1.19 | 209300.0 |
| 2009-12-08 | ACAP-DELISTED | Stock | 28.04 | 28.5775 | 27.69 | 28.19 | 60940.0 |
> showing 50 of 5,863 rows — these rows as CSV