PREVIEW / stock_daily / 2009-07-02
file: by_date/stock_daily/2009/2009-07-02.parquet size: 179 KB rows: 5,731 symbols: 3,408
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-07-02 | AAPL | Stock | 5.0446 | 5.1011 | 4.9925 | 5.0007 | 370479200.0 |
| 2009-07-02 | MSFT | Stock | 23.76 | 24.04 | 23.21 | 23.37 | 65422200.0 |
| 2009-07-02 | NVDA | Stock | 0.2743 | 0.2778 | 0.2688 | 0.2725 | 552312000.0 |
| 2009-07-02 | AMZN | Stock | 4.0555 | 4.0685 | 3.9255 | 3.966 | 144372000.0 |
| 2009-07-02 | TLT | Stock | 94.33 | 94.61 | 94.0 | 94.3 | 2645005.0 |
| 2009-07-02 | ES | Stock | 22.7 | 22.72 | 22.08 | 22.34 | 1051100.0 |
| 2009-07-02 | CL | Stock | 35.845 | 36.22 | 35.725 | 36.04 | 5853200.0 |
| 2009-07-02 | A | Stock | 14.4492 | 14.4492 | 13.7983 | 14.1059 | 6138898.0 |
| 2009-07-02 | AABA-DELISTED | Stock | 15.24 | 15.28 | 14.88 | 14.99 | 16640343.0 |
| 2009-07-02 | AACC-DELISTED | Stock | 7.33 | 7.51 | 7.185 | 7.48 | 42671.0 |
| 2009-07-02 | AACG | Stock | 8.75 | 9.41 | 8.75 | 8.92 | 8600.0 |
| 2009-07-02 | AAI-DELISTED | Stock | 6.37 | 6.4 | 6.13 | 6.27 | 1812245.0 |
| 2009-07-02 | AAIC-DELISTED | Stock | 8.0 | 8.0 | 7.41 | 7.64 | 122282.0 |
| 2009-07-02 | AAME | Stock | 0.8 | 0.8 | 0.8 | 0.8 | 500.0 |
| 2009-07-02 | AAON | Stock | 4.2193 | 4.2212 | 3.9348 | 3.9506 | 248569.0 |
| 2009-07-02 | AAP | Stock | 41.69 | 42.62 | 41.67 | 42.24 | 1672700.0 |
| 2009-07-02 | AATI-DELISTED | Stock | 4.53 | 4.6 | 4.48 | 4.48 | 223980.0 |
| 2009-07-02 | AAU-DELISTED | Stock | 0.66 | 0.67 | 0.62 | 0.67 | 37412.0 |
| 2009-07-02 | AAUAF-DELISTED | Stock | 0.66 | 0.67 | 0.62 | 0.67 | 37512.0 |
| 2009-07-02 | AAV-DELISTED | Stock | 4.04 | 4.22 | 3.9 | 4.1 | 942358.0 |
| 2009-07-02 | AAWW-DELISTED | Stock | 23.41 | 23.57 | 22.13 | 22.28 | 215609.0 |
| 2009-07-02 | AAXJ | Stock | 44.11 | 44.2 | 43.39 | 43.68 | 213178.0 |
| 2009-07-02 | AAXN-DELISTED | Stock | 4.56 | 4.69 | 4.47 | 4.5 | 355716.0 |
| 2009-07-02 | AB | Stock | 19.88 | 20.21 | 19.48 | 20.21 | 319200.0 |
| 2009-07-02 | ABAX-DELISTED | Stock | 19.76 | 20.1 | 19.15 | 19.4 | 190900.0 |
| 2009-07-02 | ABB-DELISTED | Stock | 15.75 | 15.75 | 15.48 | 15.55 | 3484094.0 |
| 2009-07-02 | ABBC-DELISTED | Stock | 8.05 | 8.05 | 7.9 | 7.9 | 57723.0 |
| 2009-07-02 | ABBNY-DELISTED | Stock | 15.75 | 15.75 | 15.48 | 15.56 | 3517164.0 |
| 2009-07-02 | ABC-DELISTED | Stock | 18.16 | 18.16 | 17.75 | 17.78 | 2506011.0 |
| 2009-07-02 | ABCB | Stock | 6.2249 | 6.5264 | 6.1374 | 6.293 | 35779.0 |
| 2009-07-02 | ABCO-DELISTED | Stock | 12.752 | 12.752 | 12.433 | 12.528 | 145556.0 |
| 2009-07-02 | ABCW-DELISTED | Stock | 1.3494 | 1.4238 | 1.3494 | 1.36 | 257450.0 |
| 2009-07-02 | ABD-DELISTED | Stock | 2.7904 | 2.877 | 2.7038 | 2.8 | 295610.0 |
| 2009-07-02 | ABE-DELISTED | Stock | 15.29 | 15.29 | 15.0 | 15.17 | 7918.0 |
| 2009-07-02 | ABEO | Stock | 2587.5 | 2762.5 | 2587.5 | 2750.0 | 5.0 |
| 2009-07-02 | ABFS-DELISTED | Stock | 27.36 | 27.83 | 27.07 | 27.2 | 781286.0 |
| 2009-07-02 | ABG | Stock | 9.93 | 10.0 | 9.53 | 9.85 | 440400.0 |
| 2009-07-02 | ABII-DELISTED | Stock | 37.5 | 37.5 | 35.91 | 36.18 | 19858.0 |
| 2009-07-02 | ABK-DELISTED | Stock | 0.92 | 0.9207 | 0.89 | 0.89 | 3331655.0 |
| 2009-07-02 | ABM | Stock | 18.37 | 18.37 | 17.77 | 17.77 | 174400.0 |
| 2009-07-02 | ABMD-DELISTED | Stock | 8.75 | 8.82 | 8.66 | 8.76 | 442289.0 |
| 2009-07-02 | ABR | Stock | 1.91 | 1.91 | 1.7 | 1.73 | 213400.0 |
| 2009-07-02 | ABT | Stock | 22.2147 | 22.3779 | 21.9508 | 22.2051 | 15738224.0 |
| 2009-07-02 | ABTL-DELISTED | Stock | 2.15 | 2.15 | 2.075 | 2.1 | 6553.0 |
| 2009-07-02 | ABV-DELISTED | Stock | 64.77 | 64.79 | 63.6 | 64.01 | 642741.0 |
| 2009-07-02 | ABVT-DELISTED | Stock | 80.9 | 80.9 | 76.31 | 78.75 | 38817.0 |
| 2009-07-02 | ABX-DELISTED | Stock | 34.2 | 34.24 | 33.55 | 34.09 | 5723677.0 |
| 2009-07-02 | ACAD | Stock | 2.04 | 2.09 | 2.0 | 2.01 | 74500.0 |
| 2009-07-02 | ACAP-DELISTED | Stock | 40.06 | 40.44 | 39.17 | 39.36 | 55973.0 |
| 2009-07-02 | ACAS-DELISTED | Stock | 3.08 | 3.12 | 3.0 | 3.08 | 2397357.0 |
> showing 50 of 5,731 rows — these rows as CSV