PREVIEW / stock_daily / 2013-06-20
file: by_date/stock_daily/2013/2013-06-20.parquet size: 209 KB rows: 6,329 symbols: 3,519
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-06-20 | AAPL | Stock | 14.975 | 15.2136 | 14.8275 | 14.8871 | 357310800.0 |
| 2013-06-20 | MSFT | Stock | 34.26 | 34.33 | 33.37 | 33.49 | 54493700.0 |
| 2013-06-20 | NVDA | Stock | 0.368 | 0.3685 | 0.3585 | 0.361 | 628696000.0 |
| 2013-06-20 | AMZN | Stock | 13.757 | 13.93 | 13.6195 | 13.672 | 59680000.0 |
| 2013-06-20 | META | Stock | 24.28 | 24.75 | 23.65 | 23.9 | 42765600.0 |
| 2013-06-20 | TSLA | Stock | 6.9767 | 7.142 | 6.63 | 6.71 | 151597500.0 |
| 2013-06-20 | TLT | Stock | 110.75 | 111.209 | 109.28 | 110.27 | 27901249.0 |
| 2013-06-20 | ES | Stock | 41.05 | 41.05 | 39.43 | 39.61 | 2884900.0 |
| 2013-06-20 | CL | Stock | 57.6 | 57.72 | 55.69 | 55.87 | 7546900.0 |
| 2013-06-20 | A | Stock | 30.8369 | 30.8369 | 29.9356 | 30.2718 | 8818444.0 |
| 2013-06-20 | AABA-DELISTED | Stock | 26.03 | 26.05 | 25.23 | 25.32 | 18960580.0 |
| 2013-06-20 | AAIC-DELISTED | Stock | 27.51 | 27.56 | 26.61 | 26.92 | 344276.0 |
| 2013-06-20 | AAMC-DELISTED | Stock | 78.6765 | 79.4118 | 78.5294 | 79.4118 | 7174.0 |
| 2013-06-20 | AAME | Stock | 3.91 | 3.92 | 3.9 | 3.92 | 4400.0 |
| 2013-06-20 | AAMRQ-DELISTED | Stock | 4.55 | 4.58 | 4.25 | 4.26 | 5385976.0 |
| 2013-06-20 | AAON | Stock | 9.52 | 9.6533 | 9.3333 | 9.5259 | 365513.0 |
| 2013-06-20 | AAP | Stock | 83.69 | 83.8 | 82.73 | 82.88 | 704100.0 |
| 2013-06-20 | AAT | Stock | 30.76 | 30.81 | 29.72 | 29.88 | 118500.0 |
| 2013-06-20 | AAU-DELISTED | Stock | 1.51 | 1.54 | 1.31 | 1.36 | 483631.0 |
| 2013-06-20 | AAUAF-DELISTED | Stock | 1.51 | 1.54 | 1.31 | 1.35 | 490322.0 |
| 2013-06-20 | AAV-DELISTED | Stock | 4.2 | 4.2 | 3.99 | 4.04 | 434416.0 |
| 2013-06-20 | AAWW-DELISTED | Stock | 45.61 | 46.0 | 44.69 | 45.15 | 232079.0 |
| 2013-06-20 | AAXJ | Stock | 53.82 | 53.94 | 52.1201 | 52.49 | 1364407.0 |
| 2013-06-20 | AAXN-DELISTED | Stock | 9.1 | 9.1155 | 8.82 | 8.86 | 367485.0 |
| 2013-06-20 | AB | Stock | 23.62 | 23.71 | 22.34 | 22.87 | 766900.0 |
| 2013-06-20 | ABAC-DELISTED | Stock | 0.63 | 0.71 | 0.601 | 0.62 | 51527.0 |
| 2013-06-20 | ABAX-DELISTED | Stock | 45.3 | 46.39 | 44.85 | 45.44 | 109902.0 |
| 2013-06-20 | ABB-DELISTED | Stock | 21.87 | 21.8799 | 21.41 | 21.51 | 2434346.0 |
| 2013-06-20 | ABBNY-DELISTED | Stock | 21.87 | 21.8799 | 21.41 | 21.5 | 2475915.0 |
| 2013-06-20 | ABBV | Stock | 42.65 | 42.78 | 40.91 | 41.06 | 7474900.0 |
| 2013-06-20 | ABC-DELISTED | Stock | 55.47 | 55.61 | 54.01 | 54.16 | 2984093.0 |
| 2013-06-20 | ABCB | Stock | 15.89 | 16.12 | 15.73 | 15.78 | 32400.0 |
| 2013-06-20 | ABCD-DELISTED | Stock | 1.28 | 1.379 | 1.28 | 1.28 | 7058.0 |
| 2013-06-20 | ABCO-DELISTED | Stock | 53.28 | 54.57 | 52.84 | 53.19 | 175910.0 |
| 2013-06-20 | ABCW-DELISTED | Stock | 0.564 | 0.564 | 0.56 | 0.56 | 6245.0 |
| 2013-06-20 | ABE-DELISTED | Stock | 19.56 | 19.5601 | 18.54 | 19.1 | 17151.0 |
| 2013-06-20 | ABEO | Stock | 625.0 | 625.0 | 525.0 | 600.0 | 34.0 |
| 2013-06-20 | ABFS-DELISTED | Stock | 19.28 | 19.35 | 18.77 | 18.81 | 395917.0 |
| 2013-06-20 | ABG | Stock | 39.36 | 39.36 | 38.28 | 38.7 | 277700.0 |
| 2013-06-20 | ABM | Stock | 24.05 | 24.38 | 23.84 | 24.19 | 198300.0 |
| 2013-06-20 | ABMD-DELISTED | Stock | 21.85 | 22.12 | 21.41 | 21.6 | 357504.0 |
| 2013-06-20 | ABR | Stock | 6.42 | 6.48 | 6.16 | 6.26 | 238600.0 |
| 2013-06-20 | ABR.A-DELISTED | Stock | 24.65 | 24.67 | 24.51 | 24.67 | 1500.0 |
| 2013-06-20 | ABR.B-DELISTED | Stock | 24.3825 | 24.3825 | 24.22 | 24.22 | 2020.0 |
| 2013-06-20 | ABT | Stock | 36.07 | 36.09 | 35.07 | 35.17 | 8336800.0 |
| 2013-06-20 | ABTL-DELISTED | Stock | 4.76 | 4.79 | 4.74 | 4.76 | 36436.0 |
| 2013-06-20 | ABUS | Stock | 4.85 | 4.85 | 4.63 | 4.7 | 23200.0 |
| 2013-06-20 | ABV-DELISTED | Stock | 34.27 | 34.47 | 33.45 | 33.71 | 8323288.0 |
| 2013-06-20 | ABX-DELISTED | Stock | 17.22 | 17.25 | 16.31 | 16.6 | 32355385.0 |
| 2013-06-20 | ACAD | Stock | 17.77 | 18.2 | 17.49 | 17.77 | 2997700.0 |
> showing 50 of 6,329 rows — these rows as CSV