PREVIEW / stock_daily / 2015-03-16

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-16.parquet
  size:    223 KB
  rows:    6,648
  symbols: 3,525

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-03-16	AAPL	Stock	30.97	31.2375	30.7175	31.2375	143497200.0
2015-03-16	MSFT	Stock	41.47	41.64	41.28	41.56	35273500.0
2015-03-16	NVDA	Stock	0.572	0.5778	0.5682	0.5742	236956000.0
2015-03-16	AMZN	Stock	18.519	18.697	18.336	18.6675	47082000.0
2015-03-16	GOOGL	Stock	27.8465	28.1875	27.566	28.082	36855080.0
2015-03-16	META	Stock	77.96	78.12	77.36	78.07	19305400.0
2015-03-16	TSLA	Stock	12.8	13.0607	12.6533	13.0467	84432000.0
2015-03-16	TLT	Stock	127.94	128.15	127.27	127.94	6374608.0
2015-03-16	ES	Stock	49.4	50.19	49.27	49.76	1180000.0
2015-03-16	CL	Stock	68.7	69.15	68.58	69.02	2969300.0
2015-03-16	A	Stock	41.16	41.83	41.11	41.81	2551400.0
2015-03-16	AA.B-DELISTED	Stock	46.09	46.09	44.16	44.53	55004.0
2015-03-16	AABA-DELISTED	Stock	42.96	43.88	42.75	43.52	10831792.0
2015-03-16	AAC-DELISTED	Stock	28.03	28.96	28.0	28.8	157911.0
2015-03-16	AACG	Stock	4.37	4.37	4.0	4.0	300.0
2015-03-16	AAIC-DELISTED	Stock	24.8	24.97	24.69	24.73	213214.0
2015-03-16	AAL	Stock	49.77	50.45	49.45	50.22	10897800.0
2015-03-16	AAMC-DELISTED	Stock	68.1765	68.1765	66.4706	66.4706	3937.0
2015-03-16	AAME	Stock	4.02	4.02	4.02	4.02	1000.0
2015-03-16	AAMI	Stock	17.23	17.44	16.84	17.41	196900.0
2015-03-16	AAOI	Stock	13.01	13.09	12.5	12.73	238900.0
2015-03-16	AAON	Stock	14.8933	15.0067	14.8067	14.9667	99450.0
2015-03-16	AAP	Stock	149.96	151.23	149.49	151.12	679900.0
2015-03-16	AAT	Stock	42.17	42.68	42.15	42.44	141000.0
2015-03-16	AAU-DELISTED	Stock	0.9	0.9104	0.89	0.89	121244.0
2015-03-16	AAUAF-DELISTED	Stock	0.9	0.9002	0.88	0.8851	123795.0
2015-03-16	AAV-DELISTED	Stock	4.87	5.0545	4.72	5.04	180033.0
2015-03-16	AAVL-DELISTED	Stock	43.47	44.428	41.56	41.74	325519.0
2015-03-16	AAWW-DELISTED	Stock	46.93	47.06	46.08	46.41	111745.0
2015-03-16	AAXJ	Stock	61.93	62.3201	61.92	62.255	787310.0
2015-03-16	AAXN-DELISTED	Stock	23.95	24.15	23.3835	23.535	1106162.0
2015-03-16	AB	Stock	28.7	29.5	28.52	29.47	404600.0
2015-03-16	ABAC-DELISTED	Stock	1.46	1.53	1.46	1.53	3916.0
2015-03-16	ABAX-DELISTED	Stock	63.42	64.92	63.25	63.87	81133.0
2015-03-16	ABB-DELISTED	Stock	20.26	20.41	20.25	20.39	1322582.0
2015-03-16	ABBNY-DELISTED	Stock	20.26	20.41	20.25	20.39	1400527.0
2015-03-16	ABBV	Stock	58.46	59.7	58.33	59.12	12098700.0
2015-03-16	ABC-DELISTED	Stock	108.13	110.2	106.971	110.12	3234786.0
2015-03-16	ABCB	Stock	26.6	26.6	26.18	26.38	103600.0
2015-03-16	ABCD-DELISTED	Stock	3.03	3.03	2.91	3.0	56676.0
2015-03-16	ABCO-DELISTED	Stock	53.55	54.08	52.81	53.9	235982.0
2015-03-16	ABCW-DELISTED	Stock	34.09	34.09	33.55	33.9	2048.0
2015-03-16	ABDC-DELISTED	Stock	13.75	14.0	13.7401	13.79	22143.0
2015-03-16	ABE-DELISTED	Stock	12.47	12.5497	12.44	12.44	9599.0
2015-03-16	ABEO	Stock	82.0	87.25	82.0	87.25	768.0
2015-03-16	ABEOW-DELISTED	Stock	0.94	0.94	0.94	0.94	1100.0
2015-03-16	ABEV	Stock	5.68	5.71	5.58	5.58	8035200.0
2015-03-16	ABG	Stock	76.6	78.76	76.59	77.9	374000.0
2015-03-16	ABGB-DELISTED	Stock	16.4	16.41	16.0701	16.14	11269.0
2015-03-16	ABM	Stock	29.91	30.38	29.62	30.19	217000.0

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

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