PREVIEW / stock_daily / 2010-05-14
file: by_date/stock_daily/2010/2010-05-14.parquet size: 191 KB rows: 5,967 symbols: 3,520
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-14 | AAPL | Stock | 9.1129 | 9.16 | 8.9107 | 9.065 | 759362800.0 |
| 2010-05-14 | MSFT | Stock | 29.2 | 29.21 | 28.64 | 28.93 | 63334000.0 |
| 2010-05-14 | NVDA | Stock | 0.3415 | 0.3425 | 0.315 | 0.324 | 2493068000.0 |
| 2010-05-14 | AMZN | Stock | 6.518 | 6.55 | 6.338 | 6.4265 | 105556000.0 |
| 2010-05-14 | TLT | Stock | 94.12 | 95.5 | 94.09 | 94.88 | 9796599.0 |
| 2010-05-14 | ES | Stock | 26.5 | 26.78 | 26.33 | 26.6 | 1619000.0 |
| 2010-05-14 | CL | Stock | 41.7 | 41.875 | 41.23 | 41.38 | 5933600.0 |
| 2010-05-14 | A | Stock | 24.5994 | 24.8283 | 23.9199 | 24.2203 | 4725659.0 |
| 2010-05-14 | AABA-DELISTED | Stock | 16.51 | 16.655 | 16.14 | 16.39 | 27762195.0 |
| 2010-05-14 | AACC-DELISTED | Stock | 7.64 | 7.95 | 7.32 | 7.77 | 65351.0 |
| 2010-05-14 | AACG | Stock | 3.43 | 3.61 | 3.35 | 3.61 | 1000.0 |
| 2010-05-14 | AAI-DELISTED | Stock | 5.31 | 5.34 | 5.14 | 5.26 | 3166097.0 |
| 2010-05-14 | AAIC-DELISTED | Stock | 19.79 | 20.53 | 19.61 | 20.33 | 94937.0 |
| 2010-05-14 | AAME | Stock | 1.61 | 1.61 | 1.6 | 1.6 | 1100.0 |
| 2010-05-14 | AAON | Stock | 4.7467 | 4.7723 | 4.6756 | 4.7664 | 733050.0 |
| 2010-05-14 | AAP | Stock | 44.99 | 45.1 | 44.35 | 44.9 | 1442600.0 |
| 2010-05-14 | AATI-DELISTED | Stock | 3.77 | 3.77 | 3.6 | 3.63 | 438958.0 |
| 2010-05-14 | AAU-DELISTED | Stock | 1.27 | 1.27 | 1.14 | 1.16 | 239047.0 |
| 2010-05-14 | AAUAF-DELISTED | Stock | 1.28 | 1.28 | 1.15 | 1.16 | 242100.0 |
| 2010-05-14 | AAV-DELISTED | Stock | 6.48 | 6.5 | 6.3 | 6.5 | 526119.0 |
| 2010-05-14 | AAWW-DELISTED | Stock | 53.59 | 53.59 | 50.55 | 51.69 | 352102.0 |
| 2010-05-14 | AAXJ | Stock | 54.6 | 54.8 | 53.65 | 54.18 | 1700069.0 |
| 2010-05-14 | AAXN-DELISTED | Stock | 5.11 | 5.12 | 4.89 | 5.05 | 1103905.0 |
| 2010-05-14 | AB | Stock | 30.25 | 30.35 | 29.33 | 29.64 | 467700.0 |
| 2010-05-14 | ABAX-DELISTED | Stock | 24.75 | 24.75 | 24.15 | 24.57 | 138268.0 |
| 2010-05-14 | ABB-DELISTED | Stock | 18.34 | 18.43 | 17.84 | 18.03 | 3568810.0 |
| 2010-05-14 | ABBC-DELISTED | Stock | 9.93 | 9.96 | 9.8 | 9.95 | 35404.0 |
| 2010-05-14 | ABBNY-DELISTED | Stock | 18.35 | 18.43 | 17.84 | 18.02 | 3583380.0 |
| 2010-05-14 | ABC-DELISTED | Stock | 31.49 | 31.56 | 31.05 | 31.29 | 3536326.0 |
| 2010-05-14 | ABCB | Stock | 11.0673 | 11.1867 | 10.6991 | 10.8384 | 97361.0 |
| 2010-05-14 | ABCD-DELISTED | Stock | 5.17 | 5.17 | 5.05 | 5.09 | 55810.0 |
| 2010-05-14 | ABCO-DELISTED | Stock | 19.485 | 19.545 | 19.015 | 19.3 | 80027.0 |
| 2010-05-14 | ABCW-DELISTED | Stock | 0.91 | 0.9293 | 0.8907 | 0.91 | 29240.0 |
| 2010-05-14 | ABD-DELISTED | Stock | 7.93 | 8.0 | 7.51 | 7.64 | 433320.0 |
| 2010-05-14 | ABE-DELISTED | Stock | 16.01 | 16.01 | 15.5 | 15.65 | 14998.0 |
| 2010-05-14 | ABEO | Stock | 2987.5 | 3000.0 | 2875.0 | 2875.0 | 18.0 |
| 2010-05-14 | ABFS-DELISTED | Stock | 29.03 | 29.09 | 27.9 | 28.36 | 489659.0 |
| 2010-05-14 | ABG | Stock | 14.48 | 14.55 | 13.97 | 14.11 | 249100.0 |
| 2010-05-14 | ABII-DELISTED | Stock | 45.65 | 47.67 | 45.65 | 47.19 | 44038.0 |
| 2010-05-14 | ABK-DELISTED | Stock | 1.32 | 1.33 | 1.28 | 1.32 | 12420246.0 |
| 2010-05-14 | ABM | Stock | 22.32 | 22.33 | 21.82 | 22.08 | 117800.0 |
| 2010-05-14 | ABMD-DELISTED | Stock | 9.82 | 9.82 | 9.33 | 9.61 | 139464.0 |
| 2010-05-14 | ABR | Stock | 4.17 | 4.2 | 3.92 | 4.02 | 104800.0 |
| 2010-05-14 | ABT | Stock | 23.2367 | 23.3231 | 22.9248 | 23.2703 | 20860567.0 |
| 2010-05-14 | ABTL-DELISTED | Stock | 5.4 | 5.45 | 5.1505 | 5.25 | 24962.0 |
| 2010-05-14 | ABV-DELISTED | Stock | 99.91 | 99.91 | 96.96 | 98.27 | 510539.0 |
| 2010-05-14 | ABVA-DELISTED | Stock | 2.92 | 2.92 | 2.91 | 2.91 | 400.0 |
| 2010-05-14 | ABVT-DELISTED | Stock | 48.64 | 48.86 | 47.12 | 47.88 | 93056.0 |
| 2010-05-14 | ABX-DELISTED | Stock | 45.34 | 46.05 | 44.11 | 45.61 | 15569265.0 |
| 2010-05-14 | ACAD | Stock | 1.48 | 1.49 | 1.45 | 1.45 | 207900.0 |
> showing 50 of 5,967 rows — these rows as CSV