PREVIEW / stock_daily / 2009-05-01
file: by_date/stock_daily/2009/2009-05-01.parquet size: 178 KB rows: 5,733 symbols: 3,428
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-05-01 | AAPL | Stock | 4.4929 | 4.5696 | 4.4929 | 4.5443 | 397516000.0 |
| 2009-05-01 | MSFT | Stock | 20.19 | 20.35 | 19.86 | 20.24 | 63224500.0 |
| 2009-05-01 | NVDA | Stock | 0.2862 | 0.2985 | 0.286 | 0.2918 | 840548000.0 |
| 2009-05-01 | AMZN | Stock | 4.019 | 4.019 | 3.8925 | 3.948 | 122434000.0 |
| 2009-05-01 | TLT | Stock | 97.12 | 97.29 | 96.57 | 97.11 | 2772133.0 |
| 2009-05-01 | ES | Stock | 21.11 | 21.92 | 21.11 | 21.58 | 2616000.0 |
| 2009-05-01 | CL | Stock | 29.56 | 30.99 | 29.415 | 30.7 | 14063000.0 |
| 2009-05-01 | A | Stock | 13.0258 | 13.5908 | 13.0043 | 13.4549 | 4039241.0 |
| 2009-05-01 | AABA-DELISTED | Stock | 14.48 | 14.5 | 13.91 | 14.13 | 22968843.0 |
| 2009-05-01 | AACC-DELISTED | Stock | 8.24 | 8.9 | 8.08 | 8.12 | 51390.0 |
| 2009-05-01 | AACG | Stock | 4.9 | 5.12 | 4.9 | 5.01 | 5800.0 |
| 2009-05-01 | AAI-DELISTED | Stock | 6.89 | 7.25 | 6.85 | 7.12 | 2534745.0 |
| 2009-05-01 | AAIC-DELISTED | Stock | 5.6 | 6.6 | 5.2 | 5.4 | 891083.0 |
| 2009-05-01 | AAON | Stock | 3.8479 | 3.8598 | 3.68 | 3.7314 | 456131.0 |
| 2009-05-01 | AAP | Stock | 43.78 | 43.78 | 42.1 | 42.43 | 1513800.0 |
| 2009-05-01 | AATI-DELISTED | Stock | 4.84 | 4.9 | 4.73 | 4.75 | 426368.0 |
| 2009-05-01 | AAU-DELISTED | Stock | 0.64 | 0.66 | 0.63 | 0.65 | 53150.0 |
| 2009-05-01 | AAUAF-DELISTED | Stock | 0.64 | 0.66 | 0.63 | 0.65 | 54050.0 |
| 2009-05-01 | AAV-DELISTED | Stock | 2.72 | 2.88 | 2.62 | 2.8 | 585669.0 |
| 2009-05-01 | AAWW-DELISTED | Stock | 26.55 | 28.72 | 26.06 | 28.05 | 377309.0 |
| 2009-05-01 | AAXJ | Stock | 35.88 | 39.36 | 35.88 | 39.15 | 86675.0 |
| 2009-05-01 | AAXN-DELISTED | Stock | 4.73 | 4.9 | 4.72 | 4.79 | 354408.0 |
| 2009-05-01 | AB | Stock | 17.71 | 18.1 | 17.12 | 18.03 | 643100.0 |
| 2009-05-01 | ABAX-DELISTED | Stock | 15.05 | 15.16 | 14.78 | 15.15 | 439326.0 |
| 2009-05-01 | ABB-DELISTED | Stock | 14.18 | 14.64 | 14.11 | 14.39 | 4728267.0 |
| 2009-05-01 | ABBC-DELISTED | Stock | 8.79 | 8.92 | 8.56 | 8.64 | 73560.0 |
| 2009-05-01 | ABBNY-DELISTED | Stock | 14.18 | 14.64 | 14.11 | 14.38 | 4772198.0 |
| 2009-05-01 | ABC-DELISTED | Stock | 16.84 | 17.25 | 16.8 | 17.18 | 3923862.0 |
| 2009-05-01 | ABCB | Stock | 6.3513 | 6.7599 | 6.186 | 6.4292 | 17067.0 |
| 2009-05-01 | ABCO-DELISTED | Stock | 9.24 | 9.5 | 9.165 | 9.39 | 320894.0 |
| 2009-05-01 | ABCW-DELISTED | Stock | 1.62 | 1.66 | 1.6 | 1.61 | 19720.0 |
| 2009-05-01 | ABD-DELISTED | Stock | 2.09 | 2.33 | 2.01 | 2.24 | 371450.0 |
| 2009-05-01 | ABE-DELISTED | Stock | 13.83 | 14.13 | 13.32 | 13.94 | 19520.0 |
| 2009-05-01 | ABEO | Stock | 1875.0 | 1875.0 | 1675.0 | 1862.5 | 4.0 |
| 2009-05-01 | ABFS-DELISTED | Stock | 23.11 | 24.0 | 22.32 | 23.27 | 609657.0 |
| 2009-05-01 | ABG | Stock | 9.67 | 10.82 | 9.64 | 10.27 | 941100.0 |
| 2009-05-01 | ABII-DELISTED | Stock | 49.25 | 49.25 | 45.87 | 47.07 | 5959.0 |
| 2009-05-01 | ABK-DELISTED | Stock | 0.901 | 0.97 | 0.9 | 0.91 | 4217835.0 |
| 2009-05-01 | ABM | Stock | 17.46 | 17.79 | 17.4 | 17.59 | 203100.0 |
| 2009-05-01 | ABMD-DELISTED | Stock | 6.66 | 6.68 | 6.3 | 6.4 | 253976.0 |
| 2009-05-01 | ABR | Stock | 2.76 | 3.37 | 2.74 | 3.24 | 627500.0 |
| 2009-05-01 | ABT | Stock | 20.1228 | 20.1708 | 19.8013 | 19.9213 | 18498124.0 |
| 2009-05-01 | ABTL-DELISTED | Stock | 2.7 | 2.7 | 2.55 | 2.55 | 7663.0 |
| 2009-05-01 | ABV-DELISTED | Stock | 56.99 | 58.49 | 56.31 | 58.23 | 458594.0 |
| 2009-05-01 | ABVT-DELISTED | Stock | 49.0 | 49.0 | 49.0 | 49.0 | 6000.0 |
| 2009-05-01 | ABX-DELISTED | Stock | 28.99 | 29.45 | 28.7601 | 29.01 | 6018379.0 |
| 2009-05-01 | ACAD | Stock | 0.98 | 1.03 | 0.98 | 1.0 | 65600.0 |
| 2009-05-01 | ACAP-DELISTED | Stock | 41.69 | 41.83 | 40.25 | 40.68 | 38468.0 |
| 2009-05-01 | ACAS-DELISTED | Stock | 3.14 | 3.95 | 3.03 | 3.77 | 8166040.0 |
| 2009-05-01 | ACAT-DELISTED | Stock | 4.0508 | 4.0508 | 3.93 | 3.99 | 43320.0 |
> showing 50 of 5,733 rows — these rows as CSV