PREVIEW / stock_daily / 2009-04-02
file: by_date/stock_daily/2009/2009-04-02.parquet size: 177 KB rows: 5,765 symbols: 3,435
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-02 | AAPL | Stock | 3.9336 | 4.0982 | 3.9207 | 4.0254 | 812366800.0 |
| 2009-04-02 | MSFT | Stock | 19.5 | 19.89 | 19.0 | 19.29 | 99082300.0 |
| 2009-04-02 | NVDA | Stock | 0.2623 | 0.2692 | 0.2585 | 0.2645 | 1002860000.0 |
| 2009-04-02 | AMZN | Stock | 3.6815 | 3.862 | 3.672 | 3.817 | 221338000.0 |
| 2009-04-02 | TLT | Stock | 105.89 | 106.07 | 104.84 | 105.07 | 1766293.0 |
| 2009-04-02 | ES | Stock | 21.66 | 21.83 | 21.11 | 21.2 | 2841700.0 |
| 2009-04-02 | CL | Stock | 29.575 | 30.925 | 29.575 | 30.615 | 11422400.0 |
| 2009-04-02 | A | Stock | 11.7239 | 11.9957 | 11.5737 | 11.6738 | 5987774.0 |
| 2009-04-02 | AABA-DELISTED | Stock | 13.02 | 13.14 | 12.8 | 12.96 | 28621671.0 |
| 2009-04-02 | AACC-DELISTED | Stock | 5.97 | 6.25 | 5.91 | 5.95 | 68064.0 |
| 2009-04-02 | AACG | Stock | 4.5 | 4.85 | 4.27 | 4.38 | 91800.0 |
| 2009-04-02 | AAI-DELISTED | Stock | 4.75 | 5.13 | 4.75 | 5.05 | 2657392.0 |
| 2009-04-02 | AAIC-DELISTED | Stock | 4.2 | 5.2 | 4.0 | 5.2 | 1562457.0 |
| 2009-04-02 | AAME | Stock | 0.52 | 0.53 | 0.45 | 0.51 | 17300.0 |
| 2009-04-02 | AAON | Stock | 3.7353 | 3.7807 | 3.6504 | 3.682 | 589781.0 |
| 2009-04-02 | AAP | Stock | 41.05 | 41.66 | 39.61 | 39.77 | 4266500.0 |
| 2009-04-02 | AATI-DELISTED | Stock | 3.8 | 3.93 | 3.73 | 3.83 | 334929.0 |
| 2009-04-02 | AAU-DELISTED | Stock | 0.78 | 0.78 | 0.75 | 0.77 | 66346.0 |
| 2009-04-02 | AAUAF-DELISTED | Stock | 0.78 | 0.78 | 0.75 | 0.77 | 66446.0 |
| 2009-04-02 | AAV-DELISTED | Stock | 2.52 | 2.65 | 2.48 | 2.62 | 1145900.0 |
| 2009-04-02 | AAWW-DELISTED | Stock | 18.63 | 20.37 | 18.3701 | 19.57 | 281719.0 |
| 2009-04-02 | AAXJ | Stock | 35.1 | 36.68 | 34.52 | 36.18 | 76963.0 |
| 2009-04-02 | AAXN-DELISTED | Stock | 4.78 | 4.99 | 4.7678 | 4.91 | 854032.0 |
| 2009-04-02 | AB | Stock | 15.87 | 17.28 | 15.86 | 16.33 | 933400.0 |
| 2009-04-02 | ABAX-DELISTED | Stock | 17.74 | 19.17 | 17.63 | 18.56 | 292367.0 |
| 2009-04-02 | ABB-DELISTED | Stock | 14.54 | 15.19 | 14.51 | 14.79 | 5546228.0 |
| 2009-04-02 | ABBC-DELISTED | Stock | 8.45 | 8.67 | 8.33 | 8.52 | 67924.0 |
| 2009-04-02 | ABBNY-DELISTED | Stock | 14.54 | 15.19 | 14.51 | 14.78 | 5546228.0 |
| 2009-04-02 | ABC-DELISTED | Stock | 16.645 | 16.942 | 16.582 | 16.78 | 3189008.0 |
| 2009-04-02 | ABCB | Stock | 5.3203 | 5.8359 | 5.0577 | 5.8359 | 49042.0 |
| 2009-04-02 | ABCO-DELISTED | Stock | 8.652 | 8.913 | 8.452 | 8.768 | 270675.0 |
| 2009-04-02 | ABCW-DELISTED | Stock | 1.4 | 1.5 | 1.39 | 1.5 | 143350.0 |
| 2009-04-02 | ABD-DELISTED | Stock | 1.337 | 1.8184 | 1.3156 | 1.69 | 408350.0 |
| 2009-04-02 | ABE-DELISTED | Stock | 12.86 | 13.19 | 12.79 | 12.82 | 23579.0 |
| 2009-04-02 | ABEO | Stock | 1875.0 | 1887.5 | 1875.0 | 1887.5 | 3.0 |
| 2009-04-02 | ABFS-DELISTED | Stock | 19.57 | 21.35 | 19.57 | 20.5 | 980088.0 |
| 2009-04-02 | ABG | Stock | 4.99 | 6.12 | 4.9 | 5.59 | 694600.0 |
| 2009-04-02 | ABII-DELISTED | Stock | 48.38 | 49.6 | 46.0 | 47.94 | 14433.0 |
| 2009-04-02 | ABK-DELISTED | Stock | 0.9 | 0.95 | 0.85 | 0.875 | 9411700.0 |
| 2009-04-02 | ABM | Stock | 16.08 | 16.4 | 15.61 | 16.27 | 504800.0 |
| 2009-04-02 | ABMD-DELISTED | Stock | 5.08 | 5.41 | 4.99 | 5.35 | 386588.0 |
| 2009-04-02 | ABR | Stock | 0.78 | 0.84 | 0.75 | 0.84 | 258200.0 |
| 2009-04-02 | ABT | Stock | 22.7809 | 22.7809 | 21.7589 | 21.7733 | 36582534.0 |
| 2009-04-02 | ABTL-DELISTED | Stock | 1.3366 | 1.4356 | 1.2376 | 1.35 | 21272.0 |
| 2009-04-02 | ABV-DELISTED | Stock | 51.08 | 52.31 | 50.47 | 50.99 | 659448.0 |
| 2009-04-02 | ABVT-DELISTED | Stock | 46.0 | 47.0 | 46.0 | 47.0 | 21775.0 |
| 2009-04-02 | ABX-DELISTED | Stock | 33.12 | 33.24 | 32.14 | 32.31 | 13595598.0 |
| 2009-04-02 | ACAD | Stock | 1.13 | 1.2 | 0.98 | 1.06 | 254200.0 |
| 2009-04-02 | ACAP-DELISTED | Stock | 42.36 | 42.95 | 41.65 | 42.49 | 46691.0 |
| 2009-04-02 | ACAS-DELISTED | Stock | 2.56 | 2.82 | 2.42 | 2.62 | 9569358.0 |
> showing 50 of 5,765 rows — these rows as CSV