PREVIEW / stock_daily / 2013-10-25
file: by_date/stock_daily/2013/2013-10-25.parquet size: 214 KB rows: 6,430 symbols: 3,549
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-10-25 | AAPL | Stock | 18.9757 | 19.0439 | 18.7539 | 18.7843 | 337792000.0 |
| 2013-10-25 | MSFT | Stock | 35.88 | 36.29 | 35.47 | 35.73 | 113494000.0 |
| 2013-10-25 | NVDA | Stock | 0.3868 | 0.387 | 0.3798 | 0.381 | 330492000.0 |
| 2013-10-25 | AMZN | Stock | 17.93 | 18.42 | 17.631 | 18.1695 | 240736000.0 |
| 2013-10-25 | META | Stock | 53.18 | 53.24 | 51.88 | 51.95 | 45085000.0 |
| 2013-10-25 | TSLA | Stock | 11.614 | 11.6333 | 11.12 | 11.3107 | 113932500.0 |
| 2013-10-25 | TLT | Stock | 108.13 | 108.45 | 108.08 | 108.29 | 4429545.0 |
| 2013-10-25 | ES | Stock | 42.77 | 43.43 | 42.61 | 43.41 | 1166400.0 |
| 2013-10-25 | CL | Stock | 63.24 | 63.72 | 63.08 | 63.6 | 4429800.0 |
| 2013-10-25 | A | Stock | 36.7239 | 37.1316 | 36.5451 | 37.103 | 3352823.0 |
| 2013-10-25 | AABA-DELISTED | Stock | 32.25 | 32.95 | 32.0 | 32.265 | 21949441.0 |
| 2013-10-25 | AACG | Stock | 4.76 | 4.76 | 4.09 | 4.27 | 43800.0 |
| 2013-10-25 | AAIC-DELISTED | Stock | 25.6 | 25.67 | 25.11 | 25.37 | 100667.0 |
| 2013-10-25 | AAMC-DELISTED | Stock | 191.1794 | 191.1794 | 182.3529 | 190.3794 | 7174.0 |
| 2013-10-25 | AAME | Stock | 4.0 | 4.04 | 4.0 | 4.04 | 2800.0 |
| 2013-10-25 | AAMRQ-DELISTED | Stock | 7.01 | 7.19 | 5.15 | 6.22 | 23420688.0 |
| 2013-10-25 | AAOI | Stock | 12.45 | 12.8 | 12.26 | 12.36 | 130200.0 |
| 2013-10-25 | AAON | Stock | 12.6089 | 12.8667 | 12.4889 | 12.7733 | 136800.0 |
| 2013-10-25 | AAP | Stock | 101.32 | 102.74 | 101.02 | 102.67 | 826700.0 |
| 2013-10-25 | AAT | Stock | 34.13 | 34.61 | 33.69 | 33.96 | 185500.0 |
| 2013-10-25 | AAU-DELISTED | Stock | 1.45 | 1.45 | 1.37 | 1.42 | 112288.0 |
| 2013-10-25 | AAUAF-DELISTED | Stock | 1.44 | 1.44 | 1.37 | 1.43 | 112876.0 |
| 2013-10-25 | AAV-DELISTED | Stock | 4.02 | 4.05 | 3.98 | 4.05 | 182508.0 |
| 2013-10-25 | AAWW-DELISTED | Stock | 48.78 | 48.78 | 47.89 | 48.36 | 175617.0 |
| 2013-10-25 | AAXJ | Stock | 59.92 | 60.25 | 59.9 | 60.21 | 418854.0 |
| 2013-10-25 | AAXN-DELISTED | Stock | 15.4 | 15.58 | 14.93 | 15.08 | 834478.0 |
| 2013-10-25 | AB | Stock | 21.26 | 22.05 | 21.24 | 21.78 | 367400.0 |
| 2013-10-25 | ABAC-DELISTED | Stock | 1.57 | 1.66 | 1.5501 | 1.56 | 68986.0 |
| 2013-10-25 | ABAX-DELISTED | Stock | 34.69 | 34.73 | 34.13 | 34.63 | 161957.0 |
| 2013-10-25 | ABB-DELISTED | Stock | 25.84 | 25.91 | 25.75 | 25.84 | 1898010.0 |
| 2013-10-25 | ABBNY-DELISTED | Stock | 25.84 | 25.91 | 25.75 | 25.84 | 2266888.0 |
| 2013-10-25 | ABBV | Stock | 49.1 | 49.83 | 48.56 | 49.3 | 6956800.0 |
| 2013-10-25 | ABC-DELISTED | Stock | 64.84 | 65.31 | 64.55 | 65.25 | 1069544.0 |
| 2013-10-25 | ABCB | Stock | 17.95 | 18.03 | 17.83 | 17.9 | 379500.0 |
| 2013-10-25 | ABCD-DELISTED | Stock | 1.311 | 1.34 | 1.31 | 1.34 | 8934.0 |
| 2013-10-25 | ABCO-DELISTED | Stock | 69.59 | 69.63 | 68.58 | 69.26 | 69403.0 |
| 2013-10-25 | ABE-DELISTED | Stock | 20.19 | 20.36 | 20.19 | 20.33 | 1942.0 |
| 2013-10-25 | ABEO | Stock | 425.0 | 425.0 | 400.0 | 412.5 | 5.0 |
| 2013-10-25 | ABFS-DELISTED | Stock | 27.35 | 28.225 | 27.332 | 27.65 | 322818.0 |
| 2013-10-25 | ABG | Stock | 48.91 | 48.96 | 47.77 | 48.61 | 358300.0 |
| 2013-10-25 | ABGB-DELISTED | Stock | 11.6 | 11.9 | 11.5701 | 11.8 | 375330.0 |
| 2013-10-25 | ABM | Stock | 28.65 | 28.65 | 28.3 | 28.52 | 142200.0 |
| 2013-10-25 | ABMD-DELISTED | Stock | 21.06 | 21.58 | 21.045 | 21.42 | 304285.0 |
| 2013-10-25 | ABR | Stock | 6.98 | 7.04 | 6.96 | 7.02 | 111800.0 |
| 2013-10-25 | ABR.A-DELISTED | Stock | 24.99 | 25.1 | 24.94 | 25.09 | 5400.0 |
| 2013-10-25 | ABR.B-DELISTED | Stock | 23.5 | 23.5 | 23.4682 | 23.4682 | 400.0 |
| 2013-10-25 | ABT | Stock | 37.24 | 37.37 | 36.98 | 37.25 | 6310200.0 |
| 2013-10-25 | ABTL-DELISTED | Stock | 8.6 | 8.68 | 8.1 | 8.53 | 191085.0 |
| 2013-10-25 | ABUS | Stock | 9.27 | 9.76 | 9.22 | 9.54 | 305700.0 |
| 2013-10-25 | ABV-DELISTED | Stock | 38.45 | 39.24 | 38.45 | 39.09 | 4284171.0 |
> showing 50 of 6,430 rows — these rows as CSV