PREVIEW / stock_daily / 2010-05-07
file: by_date/stock_daily/2010/2010-05-07.parquet size: 191 KB rows: 5,957 symbols: 3,504
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-07 | AAPL | Stock | 8.7039 | 8.8061 | 8.0432 | 8.4236 | 1676018400.0 |
| 2010-05-07 | MSFT | Stock | 28.93 | 28.95 | 27.32 | 28.21 | 173718100.0 |
| 2010-05-07 | NVDA | Stock | 0.3582 | 0.3582 | 0.3365 | 0.349 | 1153712000.0 |
| 2010-05-07 | AMZN | Stock | 6.3985 | 6.559 | 6.188 | 6.249 | 238552000.0 |
| 2010-05-07 | TLT | Stock | 95.88 | 98.09 | 95.27 | 95.58 | 18740522.0 |
| 2010-05-07 | ES | Stock | 25.95 | 26.08 | 25.17 | 25.53 | 2970700.0 |
| 2010-05-07 | CL | Stock | 40.8 | 40.96 | 39.85 | 40.105 | 8095800.0 |
| 2010-05-07 | A | Stock | 23.6695 | 23.8054 | 22.5322 | 22.7969 | 11155061.0 |
| 2010-05-07 | AABA-DELISTED | Stock | 15.8 | 15.95 | 15.25 | 15.27 | 42156861.0 |
| 2010-05-07 | AACC-DELISTED | Stock | 7.17 | 7.19 | 6.47 | 6.54 | 64509.0 |
| 2010-05-07 | AACG | Stock | 3.5 | 3.52 | 3.32 | 3.37 | 4600.0 |
| 2010-05-07 | AAI-DELISTED | Stock | 5.0 | 5.24 | 4.87 | 5.02 | 6083432.0 |
| 2010-05-07 | AAIC-DELISTED | Stock | 19.05 | 19.78 | 18.1 | 19.55 | 67495.0 |
| 2010-05-07 | AAME | Stock | 1.68 | 1.84 | 1.63 | 1.82 | 5200.0 |
| 2010-05-07 | AAON | Stock | 4.3319 | 4.4089 | 4.2469 | 4.2548 | 757350.0 |
| 2010-05-07 | AAP | Stock | 44.17 | 44.55 | 42.89 | 43.76 | 1562800.0 |
| 2010-05-07 | AATI-DELISTED | Stock | 3.55 | 3.65 | 3.51 | 3.55 | 466052.0 |
| 2010-05-07 | AAU-DELISTED | Stock | 1.13 | 1.13 | 1.05 | 1.0799 | 143872.0 |
| 2010-05-07 | AAUAF-DELISTED | Stock | 1.13 | 1.13 | 1.05 | 1.0799 | 132072.0 |
| 2010-05-07 | AAV-DELISTED | Stock | 6.15 | 6.24 | 5.78 | 6.1 | 968284.0 |
| 2010-05-07 | AAWW-DELISTED | Stock | 52.26 | 52.96 | 48.65 | 49.45 | 666675.0 |
| 2010-05-07 | AAXJ | Stock | 52.46 | 53.66 | 51.9 | 52.9 | 1437581.0 |
| 2010-05-07 | AAXN-DELISTED | Stock | 4.55 | 4.65 | 4.4 | 4.41 | 1772798.0 |
| 2010-05-07 | AB | Stock | 29.34 | 29.75 | 28.38 | 29.37 | 681000.0 |
| 2010-05-07 | ABAX-DELISTED | Stock | 24.05 | 24.16 | 22.95 | 23.76 | 282841.0 |
| 2010-05-07 | ABB-DELISTED | Stock | 18.08 | 18.23 | 17.28 | 17.47 | 12829163.0 |
| 2010-05-07 | ABBC-DELISTED | Stock | 9.75 | 9.82 | 9.12 | 9.12 | 84676.0 |
| 2010-05-07 | ABBNY-DELISTED | Stock | 18.07 | 18.23 | 17.28 | 17.44 | 12946538.0 |
| 2010-05-07 | ABC-DELISTED | Stock | 30.56 | 30.61 | 29.39 | 29.95 | 6242253.0 |
| 2010-05-07 | ABCB | Stock | 10.4801 | 10.6891 | 10.2014 | 10.4502 | 231899.0 |
| 2010-05-07 | ABCD-DELISTED | Stock | 4.82 | 5.1 | 4.75 | 5.05 | 22133.0 |
| 2010-05-07 | ABCO-DELISTED | Stock | 18.618 | 19.837 | 18.618 | 19.047 | 264962.0 |
| 2010-05-07 | ABCW-DELISTED | Stock | 1.0 | 1.0 | 0.9 | 0.95 | 91080.0 |
| 2010-05-07 | ABD-DELISTED | Stock | 7.71 | 7.73 | 7.009 | 7.08 | 958930.0 |
| 2010-05-07 | ABE-DELISTED | Stock | 15.53 | 15.85 | 15.35 | 15.66 | 11942.0 |
| 2010-05-07 | ABEO | Stock | 3000.0 | 3000.0 | 2812.5 | 2812.5 | 24.0 |
| 2010-05-07 | ABFS-DELISTED | Stock | 28.15 | 28.55 | 26.76 | 27.1 | 821722.0 |
| 2010-05-07 | ABG | Stock | 13.81 | 14.05 | 13.03 | 13.31 | 617000.0 |
| 2010-05-07 | ABII-DELISTED | Stock | 48.0 | 48.32 | 46.21 | 46.76 | 29270.0 |
| 2010-05-07 | ABK-DELISTED | Stock | 1.46 | 1.47 | 1.36 | 1.39 | 24754532.0 |
| 2010-05-07 | ABM | Stock | 21.16 | 21.3 | 20.56 | 20.6 | 360700.0 |
| 2010-05-07 | ABMD-DELISTED | Stock | 8.93 | 8.97 | 8.5 | 8.61 | 332265.0 |
| 2010-05-07 | ABR | Stock | 4.05 | 4.19 | 3.7 | 3.79 | 325900.0 |
| 2010-05-07 | ABT | Stock | 23.5198 | 23.587 | 23.0304 | 23.3759 | 25126928.0 |
| 2010-05-07 | ABTL-DELISTED | Stock | 5.46 | 5.565 | 5.1975 | 5.25 | 61791.0 |
| 2010-05-07 | ABV-DELISTED | Stock | 93.33 | 95.09 | 91.45 | 93.13 | 1039934.0 |
| 2010-05-07 | ABVA-DELISTED | Stock | 2.75 | 2.858 | 2.75 | 2.858 | 2500.0 |
| 2010-05-07 | ABVT-DELISTED | Stock | 51.01 | 51.95 | 48.55 | 49.07 | 270606.0 |
| 2010-05-07 | ABX-DELISTED | Stock | 43.28 | 44.24 | 42.46 | 42.79 | 22500651.0 |
| 2010-05-07 | ACAD | Stock | 1.5 | 1.51 | 1.34 | 1.39 | 493400.0 |
> showing 50 of 5,957 rows — these rows as CSV