PREVIEW / stock_daily / 2009-09-30
file: by_date/stock_daily/2009/2009-09-30.parquet size: 188 KB rows: 5,871 symbols: 3,493
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-09-30 | AAPL | Stock | 6.6475 | 6.6589 | 6.5218 | 6.6196 | 539585200.0 |
| 2009-09-30 | MSFT | Stock | 25.76 | 25.99 | 25.38 | 25.72 | 63533400.0 |
| 2009-09-30 | NVDA | Stock | 0.3715 | 0.3803 | 0.3632 | 0.3758 | 875956000.0 |
| 2009-09-30 | AMZN | Stock | 4.613 | 4.7085 | 4.5715 | 4.668 | 170784000.0 |
| 2009-09-30 | TLT | Stock | 98.56 | 99.13 | 98.36 | 98.66 | 2744798.0 |
| 2009-09-30 | ES | Stock | 24.03 | 24.09 | 23.66 | 23.74 | 1881000.0 |
| 2009-09-30 | CL | Stock | 38.28 | 38.35 | 37.96 | 38.14 | 5721200.0 |
| 2009-09-30 | A | Stock | 20.0286 | 20.0787 | 19.6781 | 19.907 | 6334058.0 |
| 2009-09-30 | AABA-DELISTED | Stock | 17.49 | 17.94 | 17.24 | 17.84 | 39308686.0 |
| 2009-09-30 | AACC-DELISTED | Stock | 7.53 | 7.59 | 7.25 | 7.25 | 62328.0 |
| 2009-09-30 | AACG | Stock | 5.65 | 5.74 | 5.61 | 5.61 | 12000.0 |
| 2009-09-30 | AAI-DELISTED | Stock | 6.3 | 6.31 | 6.06 | 6.25 | 2122756.0 |
| 2009-09-30 | AAIC-DELISTED | Stock | 10.0 | 10.0 | 9.6 | 9.8 | 1151023.0 |
| 2009-09-30 | AAME | Stock | 1.15 | 1.2 | 1.03 | 1.05 | 51000.0 |
| 2009-09-30 | AAON | Stock | 4.0296 | 4.0593 | 3.9506 | 3.9664 | 766969.0 |
| 2009-09-30 | AAP | Stock | 39.11 | 39.67 | 38.62 | 39.28 | 2196300.0 |
| 2009-09-30 | AATI-DELISTED | Stock | 4.07 | 4.099 | 3.91 | 3.97 | 381000.0 |
| 2009-09-30 | AAU-DELISTED | Stock | 0.68 | 0.715 | 0.67 | 0.71 | 117945.0 |
| 2009-09-30 | AAUAF-DELISTED | Stock | 0.68 | 0.715 | 0.67 | 0.71 | 127545.0 |
| 2009-09-30 | AAV-DELISTED | Stock | 6.89 | 7.13 | 6.73 | 7.04 | 977811.0 |
| 2009-09-30 | AAWW-DELISTED | Stock | 32.22 | 32.84 | 31.0 | 31.95 | 217635.0 |
| 2009-09-30 | AAXJ | Stock | 52.25 | 53.21 | 51.89 | 53.02 | 420603.0 |
| 2009-09-30 | AAXN-DELISTED | Stock | 4.85 | 4.8795 | 4.63 | 4.72 | 419603.0 |
| 2009-09-30 | AB | Stock | 27.11 | 27.64 | 26.53 | 27.28 | 488000.0 |
| 2009-09-30 | ABAX-DELISTED | Stock | 26.95 | 27.24 | 26.5 | 26.75 | 134601.0 |
| 2009-09-30 | ABB-DELISTED | Stock | 20.15 | 20.32 | 19.73 | 20.05 | 3232571.0 |
| 2009-09-30 | ABBC-DELISTED | Stock | 7.98 | 7.98 | 7.7 | 7.72 | 63020.0 |
| 2009-09-30 | ABBNY-DELISTED | Stock | 20.15 | 20.32 | 19.73 | 20.04 | 3240946.0 |
| 2009-09-30 | ABC-DELISTED | Stock | 22.74 | 22.84 | 22.0 | 22.36 | 4910987.0 |
| 2009-09-30 | ABCB | Stock | 6.9589 | 7.1059 | 6.5962 | 7.0078 | 65196.0 |
| 2009-09-30 | ABCO-DELISTED | Stock | 12.61 | 12.67 | 12.395 | 12.57 | 277258.0 |
| 2009-09-30 | ABCW-DELISTED | Stock | 1.2508 | 1.3295 | 1.2311 | 1.3 | 43600.0 |
| 2009-09-30 | ABD-DELISTED | Stock | 7.215 | 7.395 | 7.045 | 7.215 | 399060.0 |
| 2009-09-30 | ABE-DELISTED | Stock | 17.7 | 17.71 | 17.409 | 17.64 | 24065.0 |
| 2009-09-30 | ABEO | Stock | 3750.0 | 4300.0 | 3562.5 | 3562.5 | 227.0 |
| 2009-09-30 | ABFS-DELISTED | Stock | 30.13 | 30.49 | 28.81 | 29.94 | 395023.0 |
| 2009-09-30 | ABG | Stock | 13.24 | 13.33 | 12.55 | 12.68 | 259000.0 |
| 2009-09-30 | ABII-DELISTED | Stock | 36.24 | 36.67 | 35.37 | 36.4 | 104229.0 |
| 2009-09-30 | ABK-DELISTED | Stock | 1.82 | 1.82 | 1.65 | 1.68 | 15394811.0 |
| 2009-09-30 | ABM | Stock | 21.28 | 21.38 | 20.62 | 21.04 | 275300.0 |
| 2009-09-30 | ABMD-DELISTED | Stock | 9.99 | 9.99 | 9.6 | 9.71 | 355333.0 |
| 2009-09-30 | ABR | Stock | 3.0 | 3.0 | 2.77 | 2.84 | 199200.0 |
| 2009-09-30 | ABT | Stock | 23.5822 | 23.7645 | 23.3567 | 23.7357 | 21834306.0 |
| 2009-09-30 | ABTL-DELISTED | Stock | 3.1912 | 3.5 | 3.0882 | 3.5 | 25718.0 |
| 2009-09-30 | ABV-DELISTED | Stock | 81.15 | 82.53 | 79.75 | 82.33 | 562507.0 |
| 2009-09-30 | ABVA-DELISTED | Stock | 2.27 | 2.6212 | 2.15 | 2.6 | 5712.0 |
| 2009-09-30 | ABVT-DELISTED | Stock | 48.64 | 49.4899 | 48.28 | 48.75 | 97677.0 |
| 2009-09-30 | ABX-DELISTED | Stock | 38.04 | 38.33 | 37.07 | 37.88 | 13619772.0 |
| 2009-09-30 | ACAD | Stock | 1.72 | 1.74 | 1.66 | 1.71 | 688000.0 |
| 2009-09-30 | ACAP-DELISTED | Stock | 29.19 | 29.19 | 28.65 | 28.79 | 52737.0 |
> showing 50 of 5,871 rows — these rows as CSV