PREVIEW / stock_daily / 2009-05-11
file: by_date/stock_daily/2009/2009-05-11.parquet size: 180 KB rows: 5,787 symbols: 3,451
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-11 | AAPL | Stock | 4.5489 | 4.6771 | 4.54 | 4.6275 | 404658800.0 |
| 2009-05-11 | MSFT | Stock | 19.2 | 19.73 | 19.01 | 19.32 | 63762600.0 |
| 2009-05-11 | NVDA | Stock | 0.2275 | 0.2415 | 0.2255 | 0.2358 | 1038596000.0 |
| 2009-05-11 | AMZN | Stock | 3.84 | 3.9925 | 3.8005 | 3.9305 | 137446000.0 |
| 2009-05-11 | TLT | Stock | 96.05 | 96.45 | 95.79 | 96.29 | 2169932.0 |
| 2009-05-11 | ES | Stock | 21.05 | 21.48 | 20.98 | 21.18 | 2517000.0 |
| 2009-05-11 | CL | Stock | 30.61 | 31.195 | 30.5 | 31.095 | 7236000.0 |
| 2009-05-11 | A | Stock | 13.6409 | 13.7124 | 13.2833 | 13.4764 | 2973686.0 |
| 2009-05-11 | AABA-DELISTED | Stock | 14.9 | 15.83 | 14.81 | 15.56 | 35314695.0 |
| 2009-05-11 | AACC-DELISTED | Stock | 9.61 | 9.81 | 9.4 | 9.6 | 78059.0 |
| 2009-05-11 | AACG | Stock | 5.14 | 5.15 | 4.85 | 5.0 | 44500.0 |
| 2009-05-11 | AAI-DELISTED | Stock | 7.04 | 7.3 | 6.81 | 7.04 | 3164743.0 |
| 2009-05-11 | AAIC-DELISTED | Stock | 8.4 | 10.8 | 7.8 | 9.8 | 2941710.0 |
| 2009-05-11 | AAME | Stock | 0.8 | 0.81 | 0.79 | 0.79 | 500.0 |
| 2009-05-11 | AAON | Stock | 4.079 | 4.0968 | 4.0 | 4.0119 | 536119.0 |
| 2009-05-11 | AAP | Stock | 41.15 | 41.92 | 40.2 | 41.27 | 1066700.0 |
| 2009-05-11 | AATI-DELISTED | Stock | 4.41 | 4.84 | 4.27 | 4.69 | 498285.0 |
| 2009-05-11 | AAU-DELISTED | Stock | 0.65 | 0.65 | 0.62 | 0.64 | 72529.0 |
| 2009-05-11 | AAUAF-DELISTED | Stock | 0.65 | 0.65 | 0.62 | 0.64 | 72729.0 |
| 2009-05-11 | AAV-DELISTED | Stock | 3.44 | 3.52 | 3.3 | 3.4 | 1258237.0 |
| 2009-05-11 | AAWW-DELISTED | Stock | 28.69 | 29.98 | 28.69 | 29.32 | 283770.0 |
| 2009-05-11 | AAXJ | Stock | 42.4 | 42.4 | 41.13 | 41.41 | 208610.0 |
| 2009-05-11 | AAXN-DELISTED | Stock | 4.63 | 4.63 | 4.42 | 4.49 | 373601.0 |
| 2009-05-11 | AB | Stock | 18.01 | 19.0 | 18.01 | 18.59 | 619400.0 |
| 2009-05-11 | ABAX-DELISTED | Stock | 16.64 | 17.06 | 16.53 | 16.99 | 189194.0 |
| 2009-05-11 | ABB-DELISTED | Stock | 15.98 | 16.17 | 15.91 | 16.01 | 3307040.0 |
| 2009-05-11 | ABBC-DELISTED | Stock | 8.82 | 8.959 | 8.48 | 8.5 | 98093.0 |
| 2009-05-11 | ABBNY-DELISTED | Stock | 15.99 | 16.17 | 15.91 | 16.02 | 3314281.0 |
| 2009-05-11 | ABC-DELISTED | Stock | 17.88 | 18.02 | 17.8 | 17.83 | 3549608.0 |
| 2009-05-11 | ABCB | Stock | 6.4195 | 6.6626 | 6.0303 | 6.0888 | 16758.0 |
| 2009-05-11 | ABCO-DELISTED | Stock | 10.795 | 11.025 | 10.54 | 10.78 | 313714.0 |
| 2009-05-11 | ABCW-DELISTED | Stock | 1.75 | 1.95 | 1.7 | 1.88 | 178260.0 |
| 2009-05-11 | ABD-DELISTED | Stock | 3.12 | 3.3 | 2.91 | 3.25 | 200100.0 |
| 2009-05-11 | ABE-DELISTED | Stock | 14.85 | 14.85 | 14.12 | 14.4 | 19607.0 |
| 2009-05-11 | ABEO | Stock | 2000.0 | 2037.5 | 1862.5 | 2012.5 | 19.0 |
| 2009-05-11 | ABFS-DELISTED | Stock | 25.31 | 25.52 | 24.35 | 24.72 | 657477.0 |
| 2009-05-11 | ABG | Stock | 9.4 | 9.98 | 9.03 | 9.47 | 429800.0 |
| 2009-05-11 | ABII-DELISTED | Stock | 49.5 | 49.5 | 47.01 | 48.9 | 25762.0 |
| 2009-05-11 | ABK-DELISTED | Stock | 1.58 | 2.09 | 1.4 | 1.749 | 65888711.0 |
| 2009-05-11 | ABM | Stock | 16.71 | 16.87 | 16.38 | 16.67 | 181000.0 |
| 2009-05-11 | ABMD-DELISTED | Stock | 6.87 | 6.94 | 6.78 | 6.86 | 170521.0 |
| 2009-05-11 | ABR | Stock | 2.39 | 2.59 | 2.2 | 2.49 | 359700.0 |
| 2009-05-11 | ABT | Stock | 21.5718 | 21.7973 | 21.3607 | 21.5286 | 13486661.0 |
| 2009-05-11 | ABTL-DELISTED | Stock | 2.5021 | 2.5021 | 2.3944 | 2.4 | 2020.0 |
| 2009-05-11 | ABV-DELISTED | Stock | 60.26 | 61.29 | 60.17 | 60.56 | 723114.0 |
| 2009-05-11 | ABVA-DELISTED | Stock | 2.1299 | 2.13 | 2.1299 | 2.13 | 540.0 |
| 2009-05-11 | ABVT-DELISTED | Stock | 57.25 | 58.0 | 55.5 | 58.0 | 15216.0 |
| 2009-05-11 | ABX-DELISTED | Stock | 33.38 | 34.3 | 33.07 | 33.63 | 8302958.0 |
| 2009-05-11 | ACAD | Stock | 1.81 | 1.94 | 1.81 | 1.93 | 282300.0 |
| 2009-05-11 | ACAP-DELISTED | Stock | 41.46 | 42.95 | 41.0 | 41.16 | 34534.0 |
> showing 50 of 5,787 rows — these rows as CSV