PREVIEW / stock_daily / 2011-04-11
file: by_date/stock_daily/2011/2011-04-11.parquet size: 200 KB rows: 6,114 symbols: 3,565
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-04-11 | AAPL | Stock | 11.9307 | 11.9882 | 11.7864 | 11.8143 | 398946800.0 |
| 2011-04-11 | MSFT | Stock | 26.19 | 26.25 | 25.8 | 25.98 | 34286300.0 |
| 2011-04-11 | NVDA | Stock | 0.4405 | 0.4428 | 0.4282 | 0.433 | 546208000.0 |
| 2011-04-11 | AMZN | Stock | 9.243 | 9.3245 | 9.0925 | 9.202 | 65942000.0 |
| 2011-04-11 | TSLA | Stock | 1.7647 | 1.7687 | 1.668 | 1.6847 | 20541000.0 |
| 2011-04-11 | TLT | Stock | 89.83 | 90.22 | 89.65 | 89.96 | 5735731.0 |
| 2011-04-11 | ES | Stock | 34.55 | 34.56 | 34.1 | 34.19 | 1352300.0 |
| 2011-04-11 | CL | Stock | 40.55 | 40.86 | 40.55 | 40.805 | 4217200.0 |
| 2011-04-11 | A | Stock | 32.0458 | 32.4464 | 31.9385 | 32.1817 | 2207162.0 |
| 2011-04-11 | AABA-DELISTED | Stock | 16.89 | 16.96 | 16.37 | 16.59 | 34771595.0 |
| 2011-04-11 | AACC-DELISTED | Stock | 5.22 | 5.2828 | 5.11 | 5.24 | 38283.0 |
| 2011-04-11 | AACG | Stock | 7.78 | 7.86 | 7.78 | 7.85 | 1800.0 |
| 2011-04-11 | AAI-DELISTED | Stock | 7.36 | 7.41 | 7.31 | 7.38 | 4179211.0 |
| 2011-04-11 | AAIC-DELISTED | Stock | 29.85 | 29.999 | 29.28 | 29.29 | 17427.0 |
| 2011-04-11 | AAME | Stock | 2.16 | 2.16 | 2.08 | 2.12 | 6100.0 |
| 2011-04-11 | AAON | Stock | 6.2716 | 6.3072 | 6.2716 | 6.2973 | 137700.0 |
| 2011-04-11 | AAP | Stock | 65.15 | 65.93 | 64.56 | 65.65 | 1418100.0 |
| 2011-04-11 | AAT | Stock | 21.34 | 21.46 | 21.16 | 21.25 | 163100.0 |
| 2011-04-11 | AATI-DELISTED | Stock | 3.93 | 4.15 | 3.93 | 4.02 | 256371.0 |
| 2011-04-11 | AAU-DELISTED | Stock | 4.66 | 4.66 | 4.25 | 4.37 | 870031.0 |
| 2011-04-11 | AAUAF-DELISTED | Stock | 4.66 | 4.66 | 4.25 | 4.35 | 870903.0 |
| 2011-04-11 | AAV-DELISTED | Stock | 8.97 | 8.97 | 8.61 | 8.66 | 446370.0 |
| 2011-04-11 | AAWW-DELISTED | Stock | 66.38 | 66.5 | 64.36 | 64.58 | 104947.0 |
| 2011-04-11 | AAXJ | Stock | 64.46 | 64.5 | 63.69 | 63.85 | 513963.0 |
| 2011-04-11 | AAXN-DELISTED | Stock | 3.88 | 3.97 | 3.88 | 3.89 | 241165.0 |
| 2011-04-11 | AB | Stock | 22.41 | 22.54 | 21.84 | 21.93 | 482400.0 |
| 2011-04-11 | ABAC-DELISTED | Stock | 3.7 | 3.92 | 3.68 | 3.77 | 61926.0 |
| 2011-04-11 | ABAX-DELISTED | Stock | 29.4 | 29.89 | 29.22 | 29.29 | 110146.0 |
| 2011-04-11 | ABB-DELISTED | Stock | 24.38 | 24.47 | 24.25 | 24.37 | 1289160.0 |
| 2011-04-11 | ABBC-DELISTED | Stock | 12.37 | 12.41 | 12.17 | 12.29 | 34296.0 |
| 2011-04-11 | ABBNY-DELISTED | Stock | 24.38 | 24.47 | 24.25 | 24.38 | 1289769.0 |
| 2011-04-11 | ABC-DELISTED | Stock | 40.29 | 40.46 | 40.04 | 40.15 | 2094922.0 |
| 2011-04-11 | ABCB | Stock | 9.77 | 9.84 | 9.67 | 9.78 | 34900.0 |
| 2011-04-11 | ABCD-DELISTED | Stock | 3.3 | 3.31 | 3.28 | 3.3001 | 35544.0 |
| 2011-04-11 | ABCO-DELISTED | Stock | 24.52 | 24.52 | 24.13 | 24.31 | 62798.0 |
| 2011-04-11 | ABCW-DELISTED | Stock | 0.9 | 0.93 | 0.88 | 0.9 | 35370.0 |
| 2011-04-11 | ABD-DELISTED | Stock | 9.56 | 9.67 | 9.36 | 9.5 | 151080.0 |
| 2011-04-11 | ABE-DELISTED | Stock | 19.13 | 19.13 | 18.954 | 19.022 | 9306.0 |
| 2011-04-11 | ABEO | Stock | 2437.5 | 2737.5 | 2437.5 | 2737.5 | 1.0 |
| 2011-04-11 | ABFS-DELISTED | Stock | 25.15 | 25.35 | 24.97 | 25.02 | 161263.0 |
| 2011-04-11 | ABG | Stock | 18.28 | 18.51 | 17.92 | 18.09 | 146200.0 |
| 2011-04-11 | ABH-DELISTED | Stock | 27.13 | 27.13 | 26.45 | 26.57 | 140303.0 |
| 2011-04-11 | ABM | Stock | 25.03 | 25.17 | 24.7 | 24.8 | 111500.0 |
| 2011-04-11 | ABMD-DELISTED | Stock | 15.22 | 16.23 | 15.22 | 16.04 | 738027.0 |
| 2011-04-11 | ABR | Stock | 5.48 | 5.52 | 5.43 | 5.46 | 50200.0 |
| 2011-04-11 | ABT | Stock | 24.2299 | 24.489 | 24.1819 | 24.4266 | 15596915.0 |
| 2011-04-11 | ABTL-DELISTED | Stock | 6.7751 | 6.7751 | 6.3234 | 6.7249 | 40110.0 |
| 2011-04-11 | ABUS | Stock | 2.99 | 3.1 | 2.99 | 3.1 | 2800.0 |
| 2011-04-11 | ABV-DELISTED | Stock | 29.4 | 29.53 | 29.1 | 29.26 | 1480735.0 |
| 2011-04-11 | ABVA-DELISTED | Stock | 5.3 | 5.3 | 5.16 | 5.271 | 947.0 |
> showing 50 of 6,114 rows — these rows as CSV