PREVIEW / stock_daily / 2013-05-06
file: by_date/stock_daily/2013/2013-05-06.parquet size: 209 KB rows: 6,300 symbols: 3,500
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 |
|---|---|---|---|---|---|---|---|
| 2013-05-06 | AAPL | Stock | 16.2754 | 16.5071 | 16.2254 | 16.4539 | 496641600.0 |
| 2013-05-06 | MSFT | Stock | 33.42 | 33.91 | 33.25 | 33.75 | 40978300.0 |
| 2013-05-06 | NVDA | Stock | 0.3468 | 0.3488 | 0.3438 | 0.3458 | 217116000.0 |
| 2013-05-06 | AMZN | Stock | 12.9045 | 12.975 | 12.671 | 12.786 | 46956000.0 |
| 2013-05-06 | META | Stock | 28.33 | 28.46 | 27.48 | 27.57 | 43939400.0 |
| 2013-05-06 | TSLA | Stock | 3.7593 | 3.9773 | 3.7 | 3.9667 | 65500500.0 |
| 2013-05-06 | TLT | Stock | 121.15 | 121.255 | 120.32 | 120.63 | 5121954.0 |
| 2013-05-06 | ES | Stock | 45.08 | 45.2 | 44.47 | 44.6 | 1560300.0 |
| 2013-05-06 | CL | Stock | 60.575 | 60.635 | 60.005 | 60.1 | 1797200.0 |
| 2013-05-06 | A | Stock | 29.6423 | 30.1288 | 29.6066 | 30.0429 | 3941521.0 |
| 2013-05-06 | AABA-DELISTED | Stock | 25.04 | 25.34 | 24.92 | 25.17 | 11984657.0 |
| 2013-05-06 | AACC-DELISTED | Stock | 6.5 | 6.52 | 6.46 | 6.51 | 57892.0 |
| 2013-05-06 | AACG | Stock | 3.98 | 3.98 | 3.98 | 3.98 | 2300.0 |
| 2013-05-06 | AAIC-DELISTED | Stock | 26.89 | 27.42 | 26.89 | 27.26 | 174866.0 |
| 2013-05-06 | AAMC-DELISTED | Stock | 60.2941 | 64.7059 | 60.2941 | 64.7059 | 221969.0 |
| 2013-05-06 | AAME | Stock | 3.55 | 3.55 | 3.55 | 3.55 | 100.0 |
| 2013-05-06 | AAMRQ-DELISTED | Stock | 4.34 | 4.46 | 4.29 | 4.42 | 3739301.0 |
| 2013-05-06 | AAON | Stock | 8.3881 | 8.3881 | 8.2815 | 8.3437 | 131963.0 |
| 2013-05-06 | AAP | Stock | 84.71 | 85.05 | 84.03 | 84.91 | 394100.0 |
| 2013-05-06 | AAT | Stock | 35.48 | 35.48 | 35.15 | 35.19 | 128700.0 |
| 2013-05-06 | AAU-DELISTED | Stock | 1.59 | 1.6 | 1.56 | 1.6 | 37768.0 |
| 2013-05-06 | AAUAF-DELISTED | Stock | 1.61 | 1.619 | 1.58 | 1.58 | 37396.0 |
| 2013-05-06 | AAV-DELISTED | Stock | 3.85 | 3.89 | 3.76 | 3.79 | 131081.0 |
| 2013-05-06 | AAWW-DELISTED | Stock | 43.99 | 45.34 | 43.5601 | 44.09 | 908415.0 |
| 2013-05-06 | AAXJ | Stock | 60.43 | 60.7 | 60.38 | 60.65 | 351174.0 |
| 2013-05-06 | AAXN-DELISTED | Stock | 8.8 | 9.0 | 8.69 | 9.0 | 528762.0 |
| 2013-05-06 | AB | Stock | 24.4 | 24.97 | 24.4 | 24.88 | 308200.0 |
| 2013-05-06 | ABAC-DELISTED | Stock | 0.71 | 0.735 | 0.7 | 0.7314 | 10465.0 |
| 2013-05-06 | ABAX-DELISTED | Stock | 42.85 | 43.79 | 42.63 | 43.44 | 113333.0 |
| 2013-05-06 | ABB-DELISTED | Stock | 22.72 | 22.75 | 22.63 | 22.69 | 655406.0 |
| 2013-05-06 | ABBNY-DELISTED | Stock | 22.72 | 22.75 | 22.63 | 22.7 | 802756.0 |
| 2013-05-06 | ABBV | Stock | 44.95 | 44.95 | 44.15 | 44.59 | 4085700.0 |
| 2013-05-06 | ABC-DELISTED | Stock | 54.49 | 54.71 | 54.34 | 54.38 | 1391463.0 |
| 2013-05-06 | ABCB | Stock | 14.95 | 15.38 | 14.93 | 15.16 | 83200.0 |
| 2013-05-06 | ABCD-DELISTED | Stock | 0.95 | 0.98 | 0.95 | 0.98 | 438.0 |
| 2013-05-06 | ABCO-DELISTED | Stock | 48.01 | 48.39 | 45.74 | 45.995 | 1207366.0 |
| 2013-05-06 | ABCW-DELISTED | Stock | 0.63 | 0.64 | 0.621 | 0.621 | 17200.0 |
| 2013-05-06 | ABE-DELISTED | Stock | 21.64 | 21.768 | 21.514 | 21.6799 | 9577.0 |
| 2013-05-06 | ABFS-DELISTED | Stock | 13.11 | 14.77 | 12.85 | 14.72 | 4381587.0 |
| 2013-05-06 | ABG | Stock | 40.78 | 41.84 | 40.6 | 41.17 | 186900.0 |
| 2013-05-06 | ABM | Stock | 22.61 | 22.66 | 22.26 | 22.41 | 259600.0 |
| 2013-05-06 | ABMD-DELISTED | Stock | 19.48 | 20.05 | 19.462 | 19.99 | 242921.0 |
| 2013-05-06 | ABR | Stock | 7.58 | 7.63 | 7.44 | 7.58 | 171700.0 |
| 2013-05-06 | ABR.A-DELISTED | Stock | 26.05 | 26.1257 | 26.0 | 26.08 | 32910.0 |
| 2013-05-06 | ABT | Stock | 36.75 | 36.78 | 35.8 | 35.85 | 8604900.0 |
| 2013-05-06 | ABTL-DELISTED | Stock | 4.33 | 4.34 | 4.17 | 4.2852 | 39579.0 |
| 2013-05-06 | ABUS | Stock | 4.7 | 4.79 | 4.62 | 4.73 | 37000.0 |
| 2013-05-06 | ABV-DELISTED | Stock | 41.48 | 41.55 | 41.05 | 41.22 | 2195135.0 |
| 2013-05-06 | ABX-DELISTED | Stock | 20.35 | 20.475 | 20.15 | 20.35 | 19724445.0 |
| 2013-05-06 | ACAD | Stock | 12.4 | 12.55 | 12.03 | 12.18 | 1248800.0 |
> showing 50 of 6,300 rows — these rows as CSV