PREVIEW / stock_daily / 2010-02-18
file: by_date/stock_daily/2010/2010-02-18.parquet size: 189 KB rows: 5,898 symbols: 3,487
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-02-18 | AAPL | Stock | 7.2011 | 7.2818 | 7.1757 | 7.2475 | 422825200.0 |
| 2010-02-18 | MSFT | Stock | 28.59 | 29.03 | 28.51 | 28.97 | 42856500.0 |
| 2010-02-18 | NVDA | Stock | 0.4215 | 0.4238 | 0.4053 | 0.4168 | 1515508000.0 |
| 2010-02-18 | AMZN | Stock | 5.792 | 5.9255 | 5.741 | 5.904 | 196002000.0 |
| 2010-02-18 | TLT | Stock | 89.46 | 89.5 | 88.51 | 88.97 | 5121834.0 |
| 2010-02-18 | ES | Stock | 25.83 | 26.26 | 25.83 | 26.14 | 1946700.0 |
| 2010-02-18 | CL | Stock | 40.525 | 41.365 | 40.515 | 41.22 | 4855200.0 |
| 2010-02-18 | A | Stock | 21.867 | 22.1745 | 21.774 | 22.1602 | 3313959.0 |
| 2010-02-18 | AABA-DELISTED | Stock | 15.4 | 15.6 | 15.32 | 15.53 | 13259151.0 |
| 2010-02-18 | AACC-DELISTED | Stock | 5.65 | 5.73 | 5.65 | 5.7 | 51836.0 |
| 2010-02-18 | AACG | Stock | 3.3 | 3.68 | 3.17 | 3.45 | 27100.0 |
| 2010-02-18 | AAI-DELISTED | Stock | 4.94 | 4.965 | 4.85 | 4.9 | 1468930.0 |
| 2010-02-18 | AAIC-DELISTED | Stock | 17.44 | 17.79 | 17.29 | 17.6999 | 24655.0 |
| 2010-02-18 | AAME | Stock | 1.41 | 1.41 | 1.4 | 1.4 | 1600.0 |
| 2010-02-18 | AAON | Stock | 4.158 | 4.2844 | 4.1481 | 4.2844 | 222750.0 |
| 2010-02-18 | AAP | Stock | 39.88 | 40.35 | 39.08 | 40.15 | 7767100.0 |
| 2010-02-18 | AATI-DELISTED | Stock | 3.51 | 3.57 | 3.44 | 3.47 | 202839.0 |
| 2010-02-18 | AAU-DELISTED | Stock | 0.9541 | 0.96 | 0.9213 | 0.93 | 102453.0 |
| 2010-02-18 | AAUAF-DELISTED | Stock | 0.9541 | 0.96 | 0.9213 | 0.93 | 103253.0 |
| 2010-02-18 | AAV-DELISTED | Stock | 7.04 | 7.1601 | 7.04 | 7.0699 | 446148.0 |
| 2010-02-18 | AAWW-DELISTED | Stock | 40.27 | 40.44 | 39.39 | 39.62 | 628467.0 |
| 2010-02-18 | AAXJ | Stock | 53.24 | 53.6499 | 52.99 | 53.58 | 171038.0 |
| 2010-02-18 | AAXN-DELISTED | Stock | 6.4 | 6.61 | 6.32 | 6.58 | 1795978.0 |
| 2010-02-18 | AB | Stock | 26.77 | 26.77 | 26.08 | 26.11 | 604000.0 |
| 2010-02-18 | ABAX-DELISTED | Stock | 25.15 | 25.58 | 25.1 | 25.58 | 121977.0 |
| 2010-02-18 | ABB-DELISTED | Stock | 19.4 | 19.96 | 19.35 | 19.9 | 6025919.0 |
| 2010-02-18 | ABBC-DELISTED | Stock | 7.55 | 7.64 | 7.46 | 7.64 | 17322.0 |
| 2010-02-18 | ABBNY-DELISTED | Stock | 19.39 | 19.96 | 19.35 | 19.91 | 6326819.0 |
| 2010-02-18 | ABC-DELISTED | Stock | 27.58 | 27.9 | 27.5 | 27.87 | 2887605.0 |
| 2010-02-18 | ABCB | Stock | 9.4815 | 9.5013 | 9.3927 | 9.4914 | 14985.0 |
| 2010-02-18 | ABCD-DELISTED | Stock | 3.75 | 3.8 | 3.75 | 3.75 | 5065.0 |
| 2010-02-18 | ABCO-DELISTED | Stock | 16.29 | 16.375 | 16.205 | 16.345 | 49436.0 |
| 2010-02-18 | ABCW-DELISTED | Stock | 1.23 | 1.2602 | 1.23 | 1.23 | 92470.0 |
| 2010-02-18 | ABD-DELISTED | Stock | 7.5 | 7.56 | 7.4 | 7.5 | 226570.0 |
| 2010-02-18 | ABE-DELISTED | Stock | 16.17 | 16.196 | 16.11 | 16.18 | 6047.0 |
| 2010-02-18 | ABEO | Stock | 3437.5 | 3437.5 | 3312.5 | 3437.5 | 34.0 |
| 2010-02-18 | ABFS-DELISTED | Stock | 25.33 | 25.33 | 24.56 | 24.76 | 535122.0 |
| 2010-02-18 | ABG | Stock | 11.6 | 11.76 | 11.58 | 11.7 | 123000.0 |
| 2010-02-18 | ABII-DELISTED | Stock | 33.81 | 34.07 | 33.2 | 33.8 | 64412.0 |
| 2010-02-18 | ABK-DELISTED | Stock | 0.6999 | 0.6999 | 0.64 | 0.677 | 7829457.0 |
| 2010-02-18 | ABM | Stock | 19.95 | 20.42 | 19.81 | 20.37 | 104600.0 |
| 2010-02-18 | ABMD-DELISTED | Stock | 9.82 | 10.11 | 9.8 | 9.9925 | 325552.0 |
| 2010-02-18 | ABR | Stock | 2.44 | 2.47 | 2.42 | 2.47 | 109400.0 |
| 2010-02-18 | ABT | Stock | 26.2403 | 26.389 | 26.2307 | 26.3746 | 11171113.0 |
| 2010-02-18 | ABTL-DELISTED | Stock | 5.4502 | 5.5497 | 5.4498 | 5.4498 | 2700.0 |
| 2010-02-18 | ABV-DELISTED | Stock | 98.76 | 100.67 | 98.59 | 100.54 | 440018.0 |
| 2010-02-18 | ABVA-DELISTED | Stock | 2.57 | 2.57 | 2.35 | 2.432 | 7550.0 |
| 2010-02-18 | ABVT-DELISTED | Stock | 61.54 | 62.0 | 61.4 | 61.68 | 106055.0 |
| 2010-02-18 | ABX-DELISTED | Stock | 38.0 | 39.47 | 37.95 | 39.24 | 17697876.0 |
| 2010-02-18 | ACAD | Stock | 1.3 | 1.35 | 1.3 | 1.34 | 261300.0 |
> showing 50 of 5,898 rows — these rows as CSV