PREVIEW / stock_daily / 2015-04-09

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-09.parquet
  size:    223 KB
  rows:    6,611
  symbols: 3,496

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
2015-04-09	AAPL	Stock	31.4625	31.645	31.165	31.64	129936000.0
2015-04-09	MSFT	Stock	41.25	41.62	41.25	41.48	25723900.0
2015-04-09	NVDA	Stock	0.5462	0.565	0.546	0.5632	379432000.0
2015-04-09	AMZN	Stock	19.033	19.221	18.94	19.177	47846000.0
2015-04-09	GOOGL	Stock	27.4605	27.4685	27.0976	27.401	32365980.0
2015-04-09	META	Stock	82.5	82.8	81.71	82.17	15927300.0
2015-04-09	TSLA	Stock	13.8953	14.0247	13.7413	14.006	57003000.0
2015-04-09	TLT	Stock	130.87	130.92	129.1301	129.43	6484206.0
2015-04-09	ES	Stock	50.39	50.43	49.76	49.96	708100.0
2015-04-09	CL	Stock	69.8	70.06	69.28	69.96	1853100.0
2015-04-09	A	Stock	42.16	42.59	42.07	42.49	1332300.0
2015-04-09	AA.B-DELISTED	Stock	45.17	45.17	44.26	44.63	156946.0
2015-04-09	AABA-DELISTED	Stock	45.7	46.17	45.16	45.64	12916071.0
2015-04-09	AAC-DELISTED	Stock	31.68	32.68	31.285	31.89	78118.0
2015-04-09	AACG	Stock	4.22	4.55	4.22	4.55	5100.0
2015-04-09	AAIC-DELISTED	Stock	24.03	24.2	24.02	24.12	150356.0
2015-04-09	AAL	Stock	48.86	49.48	47.72	47.84	11576200.0
2015-04-09	AAMC-DELISTED	Stock	72.2265	73.4382	71.0294	72.6471	14066.0
2015-04-09	AAME	Stock	3.96	3.99	3.96	3.99	900.0
2015-04-09	AAMI	Stock	18.81	19.07	18.4	18.89	87400.0
2015-04-09	AAOI	Stock	13.3	13.72	13.3	13.7	300500.0
2015-04-09	AAON	Stock	15.88	16.0	15.38	15.6467	102300.0
2015-04-09	AAP	Stock	148.31	149.23	146.99	148.05	646900.0
2015-04-09	AAT	Stock	42.47	42.7	41.89	42.07	249700.0
2015-04-09	AAU-DELISTED	Stock	0.81	0.8176	0.7576	0.8176	207197.0
2015-04-09	AAUAF-DELISTED	Stock	0.81	0.82	0.7576	0.82	208769.0
2015-04-09	AAV-DELISTED	Stock	5.45	5.69	5.45	5.61	85806.0
2015-04-09	AAVL-DELISTED	Stock	40.23	40.56	39.08	39.33	210674.0
2015-04-09	AAWW-DELISTED	Stock	43.07	43.66	42.55	42.92	131054.0
2015-04-09	AAXJ	Stock	67.75	68.535	67.75	68.36	1723565.0
2015-04-09	AAXN-DELISTED	Stock	26.27	27.48	26.19	27.41	4993273.0
2015-04-09	AB	Stock	30.91	31.15	30.86	31.05	160400.0
2015-04-09	ABAC-DELISTED	Stock	1.6	1.75	1.6	1.7	37444.0
2015-04-09	ABAX-DELISTED	Stock	63.25	63.92	62.74	63.56	84058.0
2015-04-09	ABB-DELISTED	Stock	21.59	21.71	21.43	21.55	1114142.0
2015-04-09	ABBNY-DELISTED	Stock	21.59	21.71	21.43	21.57	1239031.0
2015-04-09	ABBV	Stock	59.2	60.43	59.05	60.32	12698000.0
2015-04-09	ABC-DELISTED	Stock	113.31	114.28	112.64	113.48	2091659.0
2015-04-09	ABCB	Stock	26.5	26.85	25.96	26.47	74000.0
2015-04-09	ABCD-DELISTED	Stock	3.06	3.09	3.0193	3.09	19439.0
2015-04-09	ABCO-DELISTED	Stock	51.15	52.01	50.16	52.0	262021.0
2015-04-09	ABCW-DELISTED	Stock	34.26	34.48	34.26	34.48	845.0
2015-04-09	ABDC-DELISTED	Stock	14.1	14.12	13.929	14.12	63627.0
2015-04-09	ABE-DELISTED	Stock	13.21	13.23	13.15	13.2	17192.0
2015-04-09	ABEO	Stock	80.5	92.75	78.25	87.75	9088.0
2015-04-09	ABEOW-DELISTED	Stock	1.01	1.1	1.01	1.1	621.0
2015-04-09	ABEV	Stock	6.38	6.45	6.29	6.32	16162400.0
2015-04-09	ABG	Stock	84.86	85.95	84.37	84.96	257300.0
2015-04-09	ABGB-DELISTED	Stock	17.95	18.32	17.86	18.18	590540.0
2015-04-09	ABIL-DELISTED	Stock	10.08	10.08	10.03	10.03	20570.0

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

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