PREVIEW / stock_daily / 2011-05-13
file: by_date/stock_daily/2011/2011-05-13.parquet size: 199 KB rows: 6,140 symbols: 3,580
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-05-13 | AAPL | Stock | 12.345 | 12.3661 | 12.1554 | 12.1607 | 326116000.0 |
| 2011-05-13 | MSFT | Stock | 25.28 | 25.32 | 24.95 | 25.03 | 66812300.0 |
| 2011-05-13 | NVDA | Stock | 0.48 | 0.4812 | 0.453 | 0.4565 | 2025192000.0 |
| 2011-05-13 | AMZN | Stock | 10.285 | 10.3195 | 10.118 | 10.128 | 82474000.0 |
| 2011-05-13 | TSLA | Stock | 1.8667 | 1.8793 | 1.82 | 1.8367 | 9922500.0 |
| 2011-05-13 | TLT | Stock | 94.65 | 95.49 | 94.53 | 95.08 | 8382610.0 |
| 2011-05-13 | ES | Stock | 36.11 | 36.18 | 35.58 | 35.93 | 1153700.0 |
| 2011-05-13 | CL | Stock | 43.44 | 43.57 | 43.15 | 43.275 | 5354600.0 |
| 2011-05-13 | A | Stock | 38.6767 | 39.578 | 36.9957 | 37.6109 | 14105680.0 |
| 2011-05-13 | AABA-DELISTED | Stock | 16.14 | 16.84 | 15.96 | 16.56 | 116918420.0 |
| 2011-05-13 | AACC-DELISTED | Stock | 4.52 | 4.6899 | 4.4 | 4.43 | 30237.0 |
| 2011-05-13 | AACG | Stock | 8.9 | 9.49 | 8.85 | 9.22 | 33700.0 |
| 2011-05-13 | AAIC-DELISTED | Stock | 29.51 | 29.51 | 27.53 | 28.0 | 149917.0 |
| 2011-05-13 | AAME | Stock | 2.07 | 2.07 | 2.07 | 2.07 | 200.0 |
| 2011-05-13 | AAON | Stock | 6.6173 | 6.6311 | 6.3842 | 6.3921 | 126562.0 |
| 2011-05-13 | AAP | Stock | 69.43 | 72.32 | 69.41 | 72.16 | 2243900.0 |
| 2011-05-13 | AAT | Stock | 22.05 | 22.05 | 21.59 | 21.8 | 155600.0 |
| 2011-05-13 | AATI-DELISTED | Stock | 4.03 | 4.07 | 3.905 | 3.95 | 138205.0 |
| 2011-05-13 | AAU-DELISTED | Stock | 4.13 | 4.16 | 3.92 | 4.01 | 316348.0 |
| 2011-05-13 | AAUAF-DELISTED | Stock | 4.13 | 4.16 | 3.92 | 3.99 | 316648.0 |
| 2011-05-13 | AAV-DELISTED | Stock | 7.75 | 7.81 | 7.62 | 7.75 | 289291.0 |
| 2011-05-13 | AAWW-DELISTED | Stock | 64.9 | 65.47 | 63.82 | 64.76 | 219334.0 |
| 2011-05-13 | AAXJ | Stock | 63.46 | 63.46 | 62.36 | 62.57 | 318380.0 |
| 2011-05-13 | AAXN-DELISTED | Stock | 4.68 | 4.68 | 4.52 | 4.53 | 293259.0 |
| 2011-05-13 | AB | Stock | 22.07 | 22.21 | 21.71 | 21.81 | 358100.0 |
| 2011-05-13 | ABAC-DELISTED | Stock | 3.2 | 3.2 | 3.0 | 3.01 | 33628.0 |
| 2011-05-13 | ABAX-DELISTED | Stock | 28.12 | 28.24 | 27.34 | 27.93 | 44090.0 |
| 2011-05-13 | ABB-DELISTED | Stock | 26.28 | 26.365 | 25.72 | 25.86 | 2782339.0 |
| 2011-05-13 | ABBC-DELISTED | Stock | 11.78 | 11.84 | 11.25 | 11.44 | 28720.0 |
| 2011-05-13 | ABBNY-DELISTED | Stock | 26.28 | 26.365 | 25.72 | 25.86 | 2784568.0 |
| 2011-05-13 | ABC-DELISTED | Stock | 42.39 | 42.5 | 41.8 | 42.01 | 1345411.0 |
| 2011-05-13 | ABCB | Stock | 9.36 | 9.36 | 9.15 | 9.21 | 23000.0 |
| 2011-05-13 | ABCD-DELISTED | Stock | 3.14 | 3.16 | 3.1 | 3.1 | 19837.0 |
| 2011-05-13 | ABCO-DELISTED | Stock | 25.9 | 25.91 | 25.37 | 25.57 | 73394.0 |
| 2011-05-13 | ABCW-DELISTED | Stock | 0.87 | 0.9 | 0.82 | 0.88 | 17060.0 |
| 2011-05-13 | ABD-DELISTED | Stock | 9.57 | 9.63 | 9.15 | 9.25 | 206650.0 |
| 2011-05-13 | ABE-DELISTED | Stock | 18.76 | 19.0 | 18.531 | 18.622 | 16973.0 |
| 2011-05-13 | ABEO | Stock | 2550.0 | 2812.5 | 2550.0 | 2812.5 | 24.0 |
| 2011-05-13 | ABFS-DELISTED | Stock | 24.09 | 24.12 | 23.43 | 23.51 | 201156.0 |
| 2011-05-13 | ABG | Stock | 17.1 | 17.35 | 16.78 | 16.86 | 585600.0 |
| 2011-05-13 | ABH-DELISTED | Stock | 25.97 | 26.0 | 25.55 | 25.75 | 490249.0 |
| 2011-05-13 | ABM | Stock | 24.46 | 24.46 | 23.83 | 23.99 | 294700.0 |
| 2011-05-13 | ABMD-DELISTED | Stock | 17.64 | 18.11 | 17.44 | 17.665 | 401113.0 |
| 2011-05-13 | ABR | Stock | 5.38 | 5.39 | 5.01 | 5.12 | 71800.0 |
| 2011-05-13 | ABT | Stock | 25.6357 | 26.0244 | 25.5446 | 25.6645 | 16772197.0 |
| 2011-05-13 | ABTL-DELISTED | Stock | 6.25 | 6.6 | 6.25 | 6.3 | 61590.0 |
| 2011-05-13 | ABUS | Stock | 2.74 | 2.99 | 2.74 | 2.93 | 5900.0 |
| 2011-05-13 | ABV-DELISTED | Stock | 31.58 | 31.82 | 30.89 | 31.2 | 2289672.0 |
| 2011-05-13 | ABVA-DELISTED | Stock | 6.88 | 6.95 | 6.79 | 6.8 | 12170.0 |
| 2011-05-13 | ABVT-DELISTED | Stock | 65.5 | 65.5 | 63.54 | 64.34 | 133244.0 |
> showing 50 of 6,140 rows — these rows as CSV