PREVIEW / stock_daily / 2016-05-12

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-12.parquet
  size:    219 KB
  rows:    6,540
  symbols: 3,283

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
2016-05-12	AAPL	Stock	23.18	23.195	22.3675	22.585	305258800.0
2016-05-12	MSFT	Stock	51.2	51.81	50.92	51.51	24102800.0
2016-05-12	NVDA	Stock	0.908	0.912	0.8732	0.8893	670540000.0
2016-05-12	AMZN	Stock	35.869	36.1225	35.5755	35.8965	100964000.0
2016-05-12	GOOGL	Stock	36.6	36.7685	36.2135	36.4035	27094340.0
2016-05-12	META	Stock	119.98	120.84	118.9	120.28	22035500.0
2016-05-12	TSLA	Stock	14.096	14.1113	13.5773	13.8187	54757500.0
2016-05-12	TLT	Stock	130.66	131.17	130.59	131.01	6087364.0
2016-05-12	ES	Stock	57.3	58.07	57.17	57.63	2605800.0
2016-05-12	CL	Stock	72.29	72.72	71.92	72.65	2966100.0
2016-05-12	A	Stock	42.59	42.94	42.42	42.73	2504900.0
2016-05-12	AA.B-DELISTED	Stock	33.46	33.47	32.51	33.0	32839.0
2016-05-12	AAAP-DELISTED	Stock	33.4999	33.4999	30.0	30.24	309510.0
2016-05-12	AABA-DELISTED	Stock	37.38	37.51	36.79	37.03	10666150.0
2016-05-12	AAC-DELISTED	Stock	21.45	21.81	20.32	20.35	125122.0
2016-05-12	AACG	Stock	5.43	5.47	5.27	5.41	7200.0
2016-05-12	AAIC-DELISTED	Stock	12.95	13.0	12.32	12.5	484174.0
2016-05-12	AAL	Stock	33.01	33.02	31.29	31.33	14228200.0
2016-05-12	AAMC-DELISTED	Stock	3.8235	3.9353	3.5471	3.5882	60238.0
2016-05-12	AAMI	Stock	13.97	14.18	13.79	13.86	158300.0
2016-05-12	AAOI	Stock	9.08	9.34	8.74	8.84	801500.0
2016-05-12	AAON	Stock	18.4467	18.5933	18.18	18.2267	191700.0
2016-05-12	AAP	Stock	148.99	151.03	147.99	150.0	842500.0
2016-05-12	AAT	Stock	41.33	41.59	40.95	41.43	89000.0
2016-05-12	AAU-DELISTED	Stock	1.2	1.25	1.1277	1.19	339656.0
2016-05-12	AAUAF-DELISTED	Stock	1.2	1.25	1.1277	1.19	342849.0
2016-05-12	AAV-DELISTED	Stock	5.61	5.78	5.57	5.775	76424.0
2016-05-12	AAWW-DELISTED	Stock	46.92	47.33	44.86	45.58	384020.0
2016-05-12	AAXJ	Stock	52.33	52.391	51.85	51.92	503473.0
2016-05-12	AAXN-DELISTED	Stock	19.87	19.99	19.32	19.7	934755.0
2016-05-12	AB	Stock	23.0	23.28	22.85	22.94	153700.0
2016-05-12	ABAC-DELISTED	Stock	0.6742	0.7	0.6101	0.6298	17515.0
2016-05-12	ABAX-DELISTED	Stock	43.9	45.03	42.95	43.19	157704.0
2016-05-12	ABB-DELISTED	Stock	20.9	20.91	20.575	20.71	1571603.0
2016-05-12	ABBNY-DELISTED	Stock	20.9	20.91	20.575	20.71	1616750.0
2016-05-12	ABBV	Stock	62.86	63.07	62.39	62.49	9589500.0
2016-05-12	ABC-DELISTED	Stock	75.92	75.92	74.63	74.79	3035604.0
2016-05-12	ABCB	Stock	31.09	31.2	30.66	30.99	114400.0
2016-05-12	ABCD-DELISTED	Stock	4.22	4.29	4.2	4.2589	13398.0
2016-05-12	ABCO-DELISTED	Stock	33.77	33.93	33.16	33.59	211610.0
2016-05-12	ABDC-DELISTED	Stock	11.54	11.6	11.4	11.55	39269.0
2016-05-12	ABE-DELISTED	Stock	11.97	11.97	11.89	11.94	4104.0
2016-05-12	ABEO	Stock	58.75	59.5	56.75	56.75	1704.0
2016-05-12	ABEOW-DELISTED	Stock	0.65	0.65	0.65	0.65	1000.0
2016-05-12	ABEV	Stock	5.41	5.51	5.33	5.5	28161700.0
2016-05-12	ABG	Stock	55.29	55.73	54.47	55.37	290400.0
2016-05-12	ABIL-DELISTED	Stock	3.31	3.31	3.174	3.2001	44899.0
2016-05-12	ABM	Stock	32.99	33.21	32.72	32.99	176400.0
2016-05-12	ABMD-DELISTED	Stock	96.18	96.635	92.85	94.27	362496.0
2016-05-12	ABR	Stock	7.05	7.19	6.95	7.12	147900.0

> showing 50 of 6,540 rows — these rows as CSV

> unlock the full archive -- $79 one-time