PREVIEW / stock_daily / 2011-02-15
file: by_date/stock_daily/2011/2011-02-15.parquet size: 198 KB rows: 6,103 symbols: 3,570
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-15 | AAPL | Stock | 12.8282 | 12.8561 | 12.7696 | 12.8536 | 284174800.0 |
| 2011-02-15 | MSFT | Stock | 27.04 | 27.33 | 26.95 | 26.96 | 44116500.0 |
| 2011-02-15 | NVDA | Stock | 0.5788 | 0.5808 | 0.5612 | 0.5638 | 886980000.0 |
| 2011-02-15 | AMZN | Stock | 9.4365 | 9.5245 | 9.4125 | 9.4515 | 77818000.0 |
| 2011-02-15 | TSLA | Stock | 1.534 | 1.5447 | 1.504 | 1.5227 | 14305500.0 |
| 2011-02-15 | TLT | Stock | 89.56 | 89.97 | 89.37 | 89.92 | 7300325.0 |
| 2011-02-15 | ES | Stock | 33.32 | 33.54 | 33.19 | 33.49 | 1029200.0 |
| 2011-02-15 | CL | Stock | 39.485 | 39.5 | 39.035 | 39.12 | 5812800.0 |
| 2011-02-15 | A | Stock | 32.0386 | 32.1888 | 30.5007 | 30.5079 | 10243286.0 |
| 2011-02-15 | AABA-DELISTED | Stock | 16.83 | 17.39 | 16.78 | 17.2 | 30624812.0 |
| 2011-02-15 | AACC-DELISTED | Stock | 6.01 | 6.02 | 5.76 | 5.86 | 24698.0 |
| 2011-02-15 | AACG | Stock | 4.06 | 4.25 | 4.06 | 4.25 | 6600.0 |
| 2011-02-15 | AAI-DELISTED | Stock | 7.4 | 7.42 | 7.39 | 7.42 | 1065631.0 |
| 2011-02-15 | AAIC-DELISTED | Stock | 26.39 | 26.91 | 26.35 | 26.69 | 26871.0 |
| 2011-02-15 | AAME | Stock | 2.14 | 2.17 | 2.13 | 2.14 | 4700.0 |
| 2011-02-15 | AAON | Stock | 5.7225 | 5.924 | 5.7225 | 5.8805 | 609525.0 |
| 2011-02-15 | AAP | Stock | 63.45 | 64.16 | 63.25 | 63.53 | 1067400.0 |
| 2011-02-15 | AAT | Stock | 21.15 | 21.4 | 21.1 | 21.28 | 183800.0 |
| 2011-02-15 | AATI-DELISTED | Stock | 4.27 | 4.27 | 4.16 | 4.23 | 163024.0 |
| 2011-02-15 | AAU-DELISTED | Stock | 4.46 | 4.5201 | 4.21 | 4.35 | 762735.0 |
| 2011-02-15 | AAUAF-DELISTED | Stock | 4.46 | 4.5201 | 4.21 | 4.35 | 763635.0 |
| 2011-02-15 | AAV-DELISTED | Stock | 7.8 | 7.82 | 7.71 | 7.8 | 282011.0 |
| 2011-02-15 | AAWW-DELISTED | Stock | 64.0 | 68.45 | 63.79 | 68.44 | 1152565.0 |
| 2011-02-15 | AAXJ | Stock | 60.72 | 60.77 | 60.461 | 60.67 | 230582.0 |
| 2011-02-15 | AAXN-DELISTED | Stock | 4.1 | 4.17 | 4.06 | 4.08 | 336606.0 |
| 2011-02-15 | AB | Stock | 22.61 | 22.9 | 22.5 | 22.57 | 409900.0 |
| 2011-02-15 | ABAC-DELISTED | Stock | 4.06 | 4.06 | 4.01 | 4.03 | 97498.0 |
| 2011-02-15 | ABAX-DELISTED | Stock | 26.91 | 27.285 | 26.91 | 27.09 | 114232.0 |
| 2011-02-15 | ABB-DELISTED | Stock | 23.53 | 23.86 | 23.47 | 23.8 | 1818488.0 |
| 2011-02-15 | ABBC-DELISTED | Stock | 13.06 | 13.23 | 12.86 | 12.88 | 143481.0 |
| 2011-02-15 | ABBNY-DELISTED | Stock | 23.55 | 23.86 | 23.47 | 23.82 | 1818865.0 |
| 2011-02-15 | ABC-DELISTED | Stock | 36.68 | 36.88 | 36.42 | 36.58 | 1607508.0 |
| 2011-02-15 | ABCB | Stock | 9.98 | 10.09 | 9.87 | 9.96 | 15700.0 |
| 2011-02-15 | ABCD-DELISTED | Stock | 3.84 | 3.84 | 3.8 | 3.8 | 9170.0 |
| 2011-02-15 | ABCO-DELISTED | Stock | 25.95 | 26.35 | 25.83 | 25.97 | 244344.0 |
| 2011-02-15 | ABCW-DELISTED | Stock | 1.3 | 1.3 | 1.25 | 1.26 | 86290.0 |
| 2011-02-15 | ABD-DELISTED | Stock | 8.95 | 9.01 | 8.89 | 9.0 | 314720.0 |
| 2011-02-15 | ABE-DELISTED | Stock | 18.0 | 18.07 | 17.74 | 18.0 | 70605.0 |
| 2011-02-15 | ABEO | Stock | 2937.5 | 3062.5 | 2937.5 | 3062.5 | 4.0 |
| 2011-02-15 | ABFS-DELISTED | Stock | 24.85 | 25.56 | 24.85 | 25.46 | 177923.0 |
| 2011-02-15 | ABG | Stock | 19.46 | 19.65 | 18.98 | 19.07 | 485300.0 |
| 2011-02-15 | ABH-DELISTED | Stock | 30.01 | 30.02 | 29.06 | 29.23 | 835270.0 |
| 2011-02-15 | ABM | Stock | 26.76 | 27.07 | 26.41 | 26.44 | 222100.0 |
| 2011-02-15 | ABMD-DELISTED | Stock | 13.44 | 13.5 | 13.3 | 13.35 | 138782.0 |
| 2011-02-15 | ABR | Stock | 6.6 | 6.61 | 6.47 | 6.56 | 19100.0 |
| 2011-02-15 | ABT | Stock | 22.09 | 22.4546 | 21.9221 | 22.4306 | 25261567.0 |
| 2011-02-15 | ABTL-DELISTED | Stock | 4.75 | 5.0 | 4.749 | 4.95 | 30335.0 |
| 2011-02-15 | ABUS | Stock | 5.25 | 5.25 | 5.16 | 5.2 | 12600.0 |
| 2011-02-15 | ABV-DELISTED | Stock | 26.59 | 27.06 | 26.5 | 26.77 | 2564811.0 |
| 2011-02-15 | ABVA-DELISTED | Stock | 4.52 | 4.6 | 4.52 | 4.6 | 700.0 |
> showing 50 of 6,103 rows — these rows as CSV