PREVIEW / stock_daily / 2009-06-02
file: by_date/stock_daily/2009/2009-06-02.parquet size: 181 KB rows: 5,773 symbols: 3,444
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-06-02 | AAPL | Stock | 4.9639 | 5.0479 | 4.9411 | 4.9818 | 456223600.0 |
| 2009-06-02 | MSFT | Stock | 21.36 | 21.98 | 21.2 | 21.4 | 48935700.0 |
| 2009-06-02 | NVDA | Stock | 0.2735 | 0.2795 | 0.2663 | 0.2712 | 907984000.0 |
| 2009-06-02 | AMZN | Stock | 4.121 | 4.2725 | 4.105 | 4.2465 | 187940000.0 |
| 2009-06-02 | TLT | Stock | 91.61 | 91.77 | 90.78 | 91.58 | 5064098.0 |
| 2009-06-02 | ES | Stock | 21.71 | 21.83 | 21.41 | 21.43 | 1066100.0 |
| 2009-06-02 | CL | Stock | 34.56 | 35.26 | 34.54 | 35.12 | 15511400.0 |
| 2009-06-02 | A | Stock | 13.4979 | 14.1631 | 13.4692 | 13.9843 | 5233693.0 |
| 2009-06-02 | AABA-DELISTED | Stock | 16.54 | 16.75 | 16.25 | 16.63 | 15030736.0 |
| 2009-06-02 | AACC-DELISTED | Stock | 8.92 | 8.92 | 8.35 | 8.77 | 47349.0 |
| 2009-06-02 | AACG | Stock | 5.76 | 6.0 | 5.76 | 5.91 | 36400.0 |
| 2009-06-02 | AAI-DELISTED | Stock | 5.28 | 6.14 | 5.24 | 5.69 | 4798042.0 |
| 2009-06-02 | AAIC-DELISTED | Stock | 8.0 | 9.0 | 8.0 | 8.2 | 1631803.0 |
| 2009-06-02 | AAME | Stock | 0.71 | 0.8 | 0.62 | 0.77 | 26200.0 |
| 2009-06-02 | AAON | Stock | 4.162 | 4.1877 | 4.0691 | 4.162 | 952256.0 |
| 2009-06-02 | AAP | Stock | 44.1 | 45.45 | 43.85 | 45.15 | 2473900.0 |
| 2009-06-02 | AATI-DELISTED | Stock | 4.8 | 4.88 | 4.7 | 4.82 | 123530.0 |
| 2009-06-02 | AAU-DELISTED | Stock | 0.86 | 0.92 | 0.85 | 0.91 | 212510.0 |
| 2009-06-02 | AAUAF-DELISTED | Stock | 0.86 | 0.92 | 0.85 | 0.91 | 213110.0 |
| 2009-06-02 | AAV-DELISTED | Stock | 4.59 | 4.6 | 4.4 | 4.58 | 736740.0 |
| 2009-06-02 | AAWW-DELISTED | Stock | 25.91 | 26.51 | 25.565 | 26.05 | 235309.0 |
| 2009-06-02 | AAXJ | Stock | 45.79 | 46.14 | 45.5 | 45.5 | 1174891.0 |
| 2009-06-02 | AAXN-DELISTED | Stock | 4.55 | 4.67 | 4.51 | 4.57 | 275562.0 |
| 2009-06-02 | AB | Stock | 20.4 | 20.71 | 20.11 | 20.17 | 698900.0 |
| 2009-06-02 | ABAX-DELISTED | Stock | 18.01 | 18.77 | 17.95 | 18.59 | 283570.0 |
| 2009-06-02 | ABB-DELISTED | Stock | 16.95 | 17.44 | 16.92 | 17.37 | 7758607.0 |
| 2009-06-02 | ABBC-DELISTED | Stock | 8.78 | 9.09 | 8.63 | 9.03 | 50304.0 |
| 2009-06-02 | ABBNY-DELISTED | Stock | 16.95 | 17.44 | 16.92 | 17.37 | 8073457.0 |
| 2009-06-02 | ABC-DELISTED | Stock | 18.76 | 18.99 | 18.18 | 18.92 | 5816324.0 |
| 2009-06-02 | ABCB | Stock | 6.3513 | 6.8571 | 6.186 | 6.8377 | 34134.0 |
| 2009-06-02 | ABCO-DELISTED | Stock | 12.077 | 12.798 | 11.967 | 12.698 | 331422.0 |
| 2009-06-02 | ABCW-DELISTED | Stock | 1.51 | 1.63 | 1.5 | 1.53 | 104640.0 |
| 2009-06-02 | ABD-DELISTED | Stock | 3.395 | 3.6047 | 3.2752 | 3.405 | 328270.0 |
| 2009-06-02 | ABE-DELISTED | Stock | 15.75 | 15.75 | 15.3601 | 15.65 | 12733.0 |
| 2009-06-02 | ABEO | Stock | 2687.5 | 3062.5 | 2437.5 | 2812.5 | 27.0 |
| 2009-06-02 | ABFS-DELISTED | Stock | 30.14 | 31.16 | 29.91 | 30.13 | 506810.0 |
| 2009-06-02 | ABG | Stock | 10.18 | 11.17 | 10.01 | 11.06 | 830700.0 |
| 2009-06-02 | ABII-DELISTED | Stock | 44.35 | 44.35 | 41.53 | 41.53 | 193522.0 |
| 2009-06-02 | ABK-DELISTED | Stock | 1.34 | 1.35 | 1.31 | 1.32 | 4963071.0 |
| 2009-06-02 | ABM | Stock | 16.85 | 17.3 | 16.81 | 17.2 | 192600.0 |
| 2009-06-02 | ABMD-DELISTED | Stock | 6.18 | 6.39 | 6.11 | 6.3 | 266147.0 |
| 2009-06-02 | ABR | Stock | 1.71 | 1.71 | 1.63 | 1.68 | 149200.0 |
| 2009-06-02 | ABT | Stock | 21.5046 | 21.8453 | 21.4758 | 21.663 | 11403293.0 |
| 2009-06-02 | ABTL-DELISTED | Stock | 2.3123 | 2.5231 | 1.9449 | 2.05 | 26816.0 |
| 2009-06-02 | ABV-DELISTED | Stock | 67.73 | 68.58 | 66.44 | 66.48 | 877508.0 |
| 2009-06-02 | ABVA-DELISTED | Stock | 3.02 | 3.4704 | 3.02 | 3.3 | 619.0 |
| 2009-06-02 | ABVT-DELISTED | Stock | 71.95 | 72.75 | 71.0 | 72.0 | 66924.0 |
| 2009-06-02 | ABX-DELISTED | Stock | 37.07 | 38.3 | 36.71 | 37.93 | 12161405.0 |
| 2009-06-02 | ACAD | Stock | 1.96 | 2.04 | 1.9 | 1.96 | 167800.0 |
| 2009-06-02 | ACAP-DELISTED | Stock | 40.24 | 42.19 | 39.13 | 41.71 | 71027.0 |
> showing 50 of 5,773 rows — these rows as CSV