PREVIEW / stock_daily / 2009-05-06
file: by_date/stock_daily/2009/2009-05-06.parquet size: 180 KB rows: 5,806 symbols: 3,472
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-05-06 | AAPL | Stock | 4.7618 | 4.7679 | 4.6507 | 4.7321 | 473538800.0 |
| 2009-05-06 | MSFT | Stock | 20.06 | 20.07 | 19.61 | 19.79 | 59639100.0 |
| 2009-05-06 | NVDA | Stock | 0.2982 | 0.301 | 0.2832 | 0.289 | 935088000.0 |
| 2009-05-06 | AMZN | Stock | 4.144 | 4.18 | 3.983 | 4.0995 | 172080000.0 |
| 2009-05-06 | TLT | Stock | 97.12 | 98.0 | 97.0 | 97.08 | 2045866.0 |
| 2009-05-06 | ES | Stock | 22.0 | 22.01 | 21.31 | 21.48 | 1661200.0 |
| 2009-05-06 | CL | Stock | 31.065 | 31.15 | 30.425 | 30.675 | 8936400.0 |
| 2009-05-06 | A | Stock | 13.5622 | 13.7983 | 13.4263 | 13.7554 | 4313529.0 |
| 2009-05-06 | AABA-DELISTED | Stock | 14.8 | 15.0 | 14.52 | 14.85 | 17453402.0 |
| 2009-05-06 | AACC-DELISTED | Stock | 8.88 | 9.52 | 8.88 | 9.28 | 89807.0 |
| 2009-05-06 | AACG | Stock | 6.03 | 6.04 | 5.55 | 5.65 | 32900.0 |
| 2009-05-06 | AAI-DELISTED | Stock | 8.34 | 8.5 | 7.78 | 7.96 | 2569005.0 |
| 2009-05-06 | AAIC-DELISTED | Stock | 6.0 | 7.8 | 5.6 | 7.2 | 2056245.0 |
| 2009-05-06 | AAME | Stock | 0.64 | 0.64 | 0.64 | 0.64 | 500.0 |
| 2009-05-06 | AAON | Stock | 3.9091 | 4.1481 | 3.9032 | 4.0573 | 1246894.0 |
| 2009-05-06 | AAP | Stock | 42.32 | 43.28 | 41.29 | 42.27 | 2622000.0 |
| 2009-05-06 | AATI-DELISTED | Stock | 4.8 | 4.85 | 4.51 | 4.53 | 501741.0 |
| 2009-05-06 | AAU-DELISTED | Stock | 0.66 | 0.66 | 0.61 | 0.61 | 140651.0 |
| 2009-05-06 | AAUAF-DELISTED | Stock | 0.66 | 0.66 | 0.61 | 0.61 | 147877.0 |
| 2009-05-06 | AAV-DELISTED | Stock | 3.06 | 3.32 | 3.06 | 3.27 | 1580434.0 |
| 2009-05-06 | AAWW-DELISTED | Stock | 31.4 | 32.81 | 31.21 | 32.81 | 284107.0 |
| 2009-05-06 | AAXJ | Stock | 42.65 | 42.99 | 41.88 | 42.51 | 349952.0 |
| 2009-05-06 | AAXN-DELISTED | Stock | 4.88 | 4.88 | 4.6 | 4.71 | 769415.0 |
| 2009-05-06 | AB | Stock | 19.45 | 19.65 | 18.81 | 19.08 | 538100.0 |
| 2009-05-06 | ABAX-DELISTED | Stock | 16.27 | 16.6 | 15.64 | 16.02 | 268869.0 |
| 2009-05-06 | ABB-DELISTED | Stock | 16.2 | 16.3799 | 15.95 | 16.28 | 5921755.0 |
| 2009-05-06 | ABBC-DELISTED | Stock | 8.59 | 8.69 | 8.42 | 8.61 | 44212.0 |
| 2009-05-06 | ABBNY-DELISTED | Stock | 16.2 | 16.3799 | 15.95 | 16.29 | 5927805.0 |
| 2009-05-06 | ABC-DELISTED | Stock | 17.57 | 17.755 | 17.52 | 17.59 | 3413936.0 |
| 2009-05-06 | ABCB | Stock | 6.4195 | 6.6918 | 6.0303 | 6.0888 | 19637.0 |
| 2009-05-06 | ABCO-DELISTED | Stock | 8.795 | 9.785 | 8.795 | 9.595 | 599450.0 |
| 2009-05-06 | ABCW-DELISTED | Stock | 1.645 | 1.6949 | 1.5952 | 1.655 | 78980.0 |
| 2009-05-06 | ABD-DELISTED | Stock | 3.6 | 3.6 | 2.75 | 3.31 | 943210.0 |
| 2009-05-06 | ABE-DELISTED | Stock | 14.95 | 15.1 | 14.77 | 15.0 | 43188.0 |
| 2009-05-06 | ABEO | Stock | 1875.0 | 1875.0 | 1500.0 | 1875.0 | 6.0 |
| 2009-05-06 | ABFS-DELISTED | Stock | 25.72 | 26.48 | 24.99 | 26.37 | 792344.0 |
| 2009-05-06 | ABG | Stock | 11.13 | 11.22 | 9.95 | 10.4 | 558100.0 |
| 2009-05-06 | ABII-DELISTED | Stock | 51.26 | 51.31 | 44.66 | 45.66 | 20595.0 |
| 2009-05-06 | ABK-DELISTED | Stock | 1.52 | 1.55 | 1.38 | 1.43 | 36619067.0 |
| 2009-05-06 | ABM | Stock | 17.22 | 17.4 | 16.9 | 17.32 | 174800.0 |
| 2009-05-06 | ABMD-DELISTED | Stock | 6.61 | 6.9 | 6.46 | 6.84 | 424664.0 |
| 2009-05-06 | ABR | Stock | 3.55 | 3.69 | 3.0 | 3.2 | 455100.0 |
| 2009-05-06 | ABT | Stock | 20.9337 | 21.1112 | 20.3339 | 20.5978 | 20822426.0 |
| 2009-05-06 | ABTL-DELISTED | Stock | 2.25 | 2.5 | 2.25 | 2.5 | 11328.0 |
| 2009-05-06 | ABV-DELISTED | Stock | 59.47 | 59.65 | 58.6 | 58.8 | 1071130.0 |
| 2009-05-06 | ABVA-DELISTED | Stock | 2.33 | 2.33 | 2.265 | 2.265 | 4531.0 |
| 2009-05-06 | ABVT-DELISTED | Stock | 58.0 | 58.0 | 53.0 | 57.0 | 113050.0 |
| 2009-05-06 | ABX-DELISTED | Stock | 31.94 | 32.91 | 31.92 | 32.91 | 10674005.0 |
| 2009-05-06 | ACAD | Stock | 2.34 | 2.34 | 1.81 | 1.91 | 688300.0 |
| 2009-05-06 | ACAP-DELISTED | Stock | 40.99 | 41.33 | 39.48 | 40.51 | 30588.0 |
> showing 50 of 5,806 rows — these rows as CSV