PREVIEW / stock_daily / 2009-05-05
file: by_date/stock_daily/2009/2009-05-05.parquet size: 180 KB rows: 5,788 symbols: 3,463
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-05 | AAPL | Stock | 4.7054 | 4.745 | 4.6829 | 4.7396 | 398255200.0 |
| 2009-05-05 | MSFT | Stock | 20.14 | 20.24 | 19.64 | 19.79 | 66835500.0 |
| 2009-05-05 | NVDA | Stock | 0.3008 | 0.3028 | 0.2888 | 0.295 | 837076000.0 |
| 2009-05-05 | AMZN | Stock | 4.0505 | 4.1 | 4.0095 | 4.095 | 117406000.0 |
| 2009-05-05 | TLT | Stock | 97.46 | 97.83 | 96.76 | 97.31 | 1368959.0 |
| 2009-05-05 | ES | Stock | 21.53 | 21.8 | 21.53 | 21.75 | 1266500.0 |
| 2009-05-05 | CL | Stock | 31.29 | 31.29 | 30.51 | 30.78 | 8345800.0 |
| 2009-05-05 | A | Stock | 13.8484 | 13.877 | 13.2833 | 13.3977 | 4895656.0 |
| 2009-05-05 | AABA-DELISTED | Stock | 14.56 | 14.99 | 14.18 | 14.82 | 34746122.0 |
| 2009-05-05 | AACC-DELISTED | Stock | 8.81 | 8.81 | 8.16 | 8.63 | 40951.0 |
| 2009-05-05 | AACG | Stock | 5.52 | 6.76 | 5.18 | 6.29 | 143500.0 |
| 2009-05-05 | AAI-DELISTED | Stock | 7.64 | 8.68 | 7.64 | 8.14 | 6264920.0 |
| 2009-05-05 | AAIC-DELISTED | Stock | 5.6 | 6.0 | 5.6 | 5.8 | 708117.0 |
| 2009-05-05 | AAME | Stock | 0.63 | 0.66 | 0.6 | 0.61 | 2200.0 |
| 2009-05-05 | AAON | Stock | 3.7867 | 3.8756 | 3.7531 | 3.8301 | 444487.0 |
| 2009-05-05 | AAP | Stock | 42.43 | 43.27 | 41.98 | 42.06 | 2809400.0 |
| 2009-05-05 | AATI-DELISTED | Stock | 4.87 | 4.95 | 4.78 | 4.87 | 290547.0 |
| 2009-05-05 | AAU-DELISTED | Stock | 0.65 | 0.65 | 0.63 | 0.63 | 63800.0 |
| 2009-05-05 | AAUAF-DELISTED | Stock | 0.65 | 0.65 | 0.63 | 0.63 | 63881.0 |
| 2009-05-05 | AAV-DELISTED | Stock | 3.03 | 3.11 | 2.97 | 3.06 | 939687.0 |
| 2009-05-05 | AAWW-DELISTED | Stock | 32.27 | 33.63 | 30.01 | 31.11 | 500728.0 |
| 2009-05-05 | AAXJ | Stock | 41.87 | 42.318 | 41.24 | 41.64 | 116132.0 |
| 2009-05-05 | AAXN-DELISTED | Stock | 4.85 | 4.8848 | 4.6804 | 4.76 | 902128.0 |
| 2009-05-05 | AB | Stock | 19.33 | 19.95 | 18.9 | 19.14 | 1103400.0 |
| 2009-05-05 | ABAX-DELISTED | Stock | 15.87 | 16.46 | 15.775 | 16.12 | 340771.0 |
| 2009-05-05 | ABB-DELISTED | Stock | 15.9 | 15.965 | 15.59 | 15.87 | 3958681.0 |
| 2009-05-05 | ABBC-DELISTED | Stock | 8.81 | 8.88 | 8.36 | 8.5 | 54855.0 |
| 2009-05-05 | ABBNY-DELISTED | Stock | 15.89 | 15.965 | 15.59 | 15.87 | 4066981.0 |
| 2009-05-05 | ABC-DELISTED | Stock | 17.57 | 17.86 | 17.485 | 17.54 | 4655330.0 |
| 2009-05-05 | ABCB | Stock | 6.5945 | 6.5945 | 6.0303 | 6.3221 | 21282.0 |
| 2009-05-05 | ABCO-DELISTED | Stock | 9.265 | 9.455 | 8.625 | 8.695 | 316160.0 |
| 2009-05-05 | ABCW-DELISTED | Stock | 1.77 | 1.77 | 1.64 | 1.68 | 51540.0 |
| 2009-05-05 | ABD-DELISTED | Stock | 2.925 | 4.0607 | 2.8393 | 3.6 | 1011720.0 |
| 2009-05-05 | ABE-DELISTED | Stock | 14.56 | 14.852 | 14.52 | 14.71 | 17268.0 |
| 2009-05-05 | ABEO | Stock | 1762.5 | 1762.5 | 1562.5 | 1562.5 | 8.0 |
| 2009-05-05 | ABFS-DELISTED | Stock | 25.02 | 26.16 | 24.77 | 25.5 | 621962.0 |
| 2009-05-05 | ABG | Stock | 10.04 | 10.89 | 9.88 | 10.81 | 743500.0 |
| 2009-05-05 | ABII-DELISTED | Stock | 48.6 | 49.8 | 46.14 | 49.34 | 15051.0 |
| 2009-05-05 | ABK-DELISTED | Stock | 1.03 | 1.43 | 1.01 | 1.379 | 49638532.0 |
| 2009-05-05 | ABM | Stock | 17.3 | 17.42 | 16.93 | 17.15 | 269700.0 |
| 2009-05-05 | ABMD-DELISTED | Stock | 6.55 | 6.79 | 6.27 | 6.56 | 237086.0 |
| 2009-05-05 | ABR | Stock | 4.03 | 4.05 | 3.01 | 3.57 | 1396400.0 |
| 2009-05-05 | ABT | Stock | 20.7274 | 21.1112 | 20.6938 | 20.9817 | 19547937.0 |
| 2009-05-05 | ABTL-DELISTED | Stock | 2.2541 | 2.35 | 2.0622 | 2.35 | 11001.0 |
| 2009-05-05 | ABV-DELISTED | Stock | 60.39 | 60.48 | 58.12 | 58.59 | 882427.0 |
| 2009-05-05 | ABVA-DELISTED | Stock | 2.3 | 2.35 | 2.3 | 2.3 | 6984.0 |
| 2009-05-05 | ABVT-DELISTED | Stock | 48.5 | 54.0 | 48.5 | 54.0 | 52955.0 |
| 2009-05-05 | ABX-DELISTED | Stock | 31.56 | 31.97 | 31.14 | 31.57 | 10606695.0 |
| 2009-05-05 | ACAD | Stock | 2.69 | 2.69 | 2.08 | 2.3 | 1662500.0 |
| 2009-05-05 | ACAP-DELISTED | Stock | 42.18 | 42.18 | 40.12 | 40.57 | 48247.0 |
> showing 50 of 5,788 rows — these rows as CSV