PREVIEW / stock_daily / 2009-02-05
file: by_date/stock_daily/2009/2009-02-05.parquet size: 175 KB rows: 5,702 symbols: 3,418
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-02-05 | AAPL | Stock | 3.3132 | 3.4732 | 3.3079 | 3.445 | 749246400.0 |
| 2009-02-05 | MSFT | Stock | 18.51 | 19.14 | 18.25 | 19.04 | 75195200.0 |
| 2009-02-05 | NVDA | Stock | 0.2122 | 0.2365 | 0.21 | 0.234 | 919192000.0 |
| 2009-02-05 | AMZN | Stock | 3.0575 | 3.1905 | 3.0315 | 3.159 | 203392000.0 |
| 2009-02-05 | TLT | Stock | 103.24 | 103.88 | 102.206 | 102.61 | 2279433.0 |
| 2009-02-05 | CL | Stock | 31.895 | 32.385 | 31.465 | 32.21 | 8184200.0 |
| 2009-02-05 | A | Stock | 13.0401 | 13.8484 | 12.7897 | 13.8197 | 8703808.0 |
| 2009-02-05 | AABA-DELISTED | Stock | 12.9 | 13.52 | 12.85 | 13.51 | 17308173.0 |
| 2009-02-05 | AACC-DELISTED | Stock | 4.66 | 4.81 | 4.61 | 4.73 | 42538.0 |
| 2009-02-05 | AACG | Stock | 3.7 | 4.25 | 3.6 | 4.11 | 22400.0 |
| 2009-02-05 | AAI-DELISTED | Stock | 4.06 | 4.55 | 3.99 | 4.42 | 2766389.0 |
| 2009-02-05 | AAIC-DELISTED | Stock | 4.0 | 4.8 | 4.0 | 4.4 | 391445.0 |
| 2009-02-05 | AAME | Stock | 0.97 | 0.97 | 0.96 | 0.96 | 1600.0 |
| 2009-02-05 | AAON | Stock | 3.6207 | 3.7669 | 3.5773 | 3.684 | 271856.0 |
| 2009-02-05 | AAP | Stock | 33.2 | 33.57 | 32.68 | 32.95 | 2399000.0 |
| 2009-02-05 | AATI-DELISTED | Stock | 3.2 | 3.48 | 3.1301 | 3.27 | 255097.0 |
| 2009-02-05 | AAU-DELISTED | Stock | 0.78 | 0.78 | 0.7299 | 0.74 | 43853.0 |
| 2009-02-05 | AAUAF-DELISTED | Stock | 0.78 | 0.78 | 0.7299 | 0.74 | 46353.0 |
| 2009-02-05 | AAV-DELISTED | Stock | 3.85 | 3.87 | 3.7 | 3.7 | 1328212.0 |
| 2009-02-05 | AAWW-DELISTED | Stock | 12.79 | 13.62 | 12.28 | 13.32 | 150916.0 |
| 2009-02-05 | AAXJ | Stock | 31.64 | 32.1199 | 30.95 | 31.83 | 20587.0 |
| 2009-02-05 | AAXN-DELISTED | Stock | 5.26 | 5.88 | 5.26 | 5.58 | 606723.0 |
| 2009-02-05 | AB | Stock | 16.2 | 17.35 | 16.2 | 16.84 | 341900.0 |
| 2009-02-05 | ABAX-DELISTED | Stock | 16.95 | 18.37 | 16.95 | 18.19 | 202369.0 |
| 2009-02-05 | ABB-DELISTED | Stock | 13.14 | 13.62 | 12.94 | 13.48 | 4817766.0 |
| 2009-02-05 | ABBC-DELISTED | Stock | 6.64 | 6.98 | 6.56 | 6.83 | 102698.0 |
| 2009-02-05 | ABBNY-DELISTED | Stock | 13.14 | 13.62 | 12.94 | 13.5 | 4825666.0 |
| 2009-02-05 | ABC-DELISTED | Stock | 18.96 | 19.4 | 18.81 | 19.18 | 3787418.0 |
| 2009-02-05 | ABCB | Stock | 7.7228 | 8.2188 | 7.5282 | 8.0632 | 30535.0 |
| 2009-02-05 | ABCO-DELISTED | Stock | 8.742 | 8.742 | 8.258 | 8.298 | 618996.0 |
| 2009-02-05 | ABCW-DELISTED | Stock | 1.68 | 1.9 | 1.67 | 1.83 | 123700.0 |
| 2009-02-05 | ABD-DELISTED | Stock | 1.73 | 1.98 | 1.44 | 1.81 | 308340.0 |
| 2009-02-05 | ABE-DELISTED | Stock | 12.45 | 12.63 | 12.27 | 12.63 | 50329.0 |
| 2009-02-05 | ABEO | Stock | 1012.5 | 1012.5 | 1012.5 | 1012.5 | 1.0 |
| 2009-02-05 | ABFS-DELISTED | Stock | 23.91 | 25.43 | 23.33 | 25.04 | 472278.0 |
| 2009-02-05 | ABG | Stock | 3.24 | 3.88 | 3.03 | 3.75 | 385000.0 |
| 2009-02-05 | ABII-DELISTED | Stock | 69.5 | 70.6 | 69.0 | 70.31 | 15526.0 |
| 2009-02-05 | ABK-DELISTED | Stock | 1.03 | 1.14 | 1.01 | 1.11 | 11928536.0 |
| 2009-02-05 | ABM | Stock | 14.26 | 14.65 | 14.04 | 14.24 | 302300.0 |
| 2009-02-05 | ABMD-DELISTED | Stock | 11.68 | 11.74 | 9.58 | 9.82 | 1828710.0 |
| 2009-02-05 | ABR | Stock | 1.61 | 1.61 | 1.47 | 1.51 | 119200.0 |
| 2009-02-05 | ABT | Stock | 26.792 | 27.2047 | 26.437 | 27.1231 | 17555023.0 |
| 2009-02-05 | ABTL-DELISTED | Stock | 1.9 | 2.05 | 1.8 | 1.8 | 4140.0 |
| 2009-02-05 | ABV-DELISTED | Stock | 42.32 | 43.43 | 41.85 | 43.12 | 468682.0 |
| 2009-02-05 | ABVA-DELISTED | Stock | 1.48 | 1.48 | 1.1596 | 1.47 | 837.0 |
| 2009-02-05 | ABVT-DELISTED | Stock | 35.0 | 35.0 | 35.0 | 35.0 | 68300.0 |
| 2009-02-05 | ABX-DELISTED | Stock | 38.25 | 38.9 | 37.6 | 38.59 | 13390929.0 |
| 2009-02-05 | ACAD | Stock | 1.0 | 1.02 | 0.97 | 1.0 | 48600.0 |
| 2009-02-05 | ACAP-DELISTED | Stock | 44.43 | 44.5 | 42.17 | 42.52 | 46894.0 |
| 2009-02-05 | ACAS-DELISTED | Stock | 2.62 | 2.62 | 2.24 | 2.48 | 4726103.0 |
> showing 50 of 5,702 rows — these rows as CSV