PREVIEW / stock_daily / 2017-01-27

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-27.parquet
  size:    215 KB
  rows:    6,463
  symbols: 3,079

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
2017-01-27	AAPL	Stock	30.535	30.5875	30.4	30.4875	82251600.0
2017-01-27	MSFT	Stock	65.39	65.91	64.89	65.78	44818000.0
2017-01-27	NVDA	Stock	2.7483	2.7972	2.7212	2.7942	471996000.0
2017-01-27	AMZN	Stock	41.95	41.985	41.472	41.7885	59974000.0
2017-01-27	GOOGL	Stock	42.95	43.35	42.095	42.2515	75049940.0
2017-01-27	META	Stock	132.68	132.95	131.08	132.18	19539500.0
2017-01-27	TSLA	Stock	16.7587	16.8667	16.568	16.8633	47494500.0
2017-01-27	TLT	Stock	119.4	119.83	119.25	119.63	7197762.0
2017-01-27	ES	Stock	54.71	54.74	54.1	54.25	1319100.0
2017-01-27	CL	Stock	65.0	65.05	63.43	64.68	14874900.0
2017-01-27	A	Stock	48.32	48.83	48.3	48.65	1527800.0
2017-01-27	AA	Stock	36.3	37.39	36.27	36.67	3617600.0
2017-01-27	AAAP-DELISTED	Stock	30.92	31.7	30.67	31.5	48391.0
2017-01-27	AABA-DELISTED	Stock	44.54	44.71	44.23	44.42	4508398.0
2017-01-27	AAC-DELISTED	Stock	8.07	8.145	7.84	8.11	121410.0
2017-01-27	AACG	Stock	3.09	3.09	3.05	3.05	5400.0
2017-01-27	AAIC-DELISTED	Stock	15.3	15.3	15.02	15.17	134364.0
2017-01-27	AAL	Stock	50.0	50.0	46.72	46.95	19411100.0
2017-01-27	AAMC-DELISTED	Stock	17.3971	18.25	16.1765	18.2206	44278.0
2017-01-27	AAME	Stock	3.7	3.7	3.7	3.7	2700.0
2017-01-27	AAMI	Stock	14.25	14.25	13.98	13.99	216600.0
2017-01-27	AAOI	Stock	31.2	31.465	30.305	31.15	339800.0
2017-01-27	AAON	Stock	23.2333	23.3667	23.1333	23.3333	239250.0
2017-01-27	AAP	Stock	166.15	166.28	163.94	164.37	768500.0
2017-01-27	AAT	Stock	43.13	43.33	42.41	42.6	88500.0
2017-01-27	AAU-DELISTED	Stock	1.0	1.04	1.0	1.0234	178585.0
2017-01-27	AAUAF-DELISTED	Stock	1.0	1.04	1.0	1.0234	180236.0
2017-01-27	AAV-DELISTED	Stock	6.5	6.55	6.4	6.55	101646.0
2017-01-27	AAWW-DELISTED	Stock	54.15	54.8	53.3	54.75	170534.0
2017-01-27	AAXJ	Stock	58.95	59.08	58.745	58.97	1541964.0
2017-01-27	AAXN-DELISTED	Stock	24.88	24.96	24.65	24.84	352750.0
2017-01-27	AB	Stock	23.35	23.45	23.05	23.15	177100.0
2017-01-27	ABAC-DELISTED	Stock	3.76	3.817	3.69	3.69	4246.0
2017-01-27	ABAX-DELISTED	Stock	47.2	50.17	47.2	49.42	348818.0
2017-01-27	ABB-DELISTED	Stock	23.82	23.86	23.74	23.82	1544393.0
2017-01-27	ABBNY-DELISTED	Stock	23.82	23.86	23.74	23.83	4281134.0
2017-01-27	ABBV	Stock	60.0	61.25	59.52	60.0	14151200.0
2017-01-27	ABC-DELISTED	Stock	83.68	83.68	82.07	82.41	1605431.0
2017-01-27	ABCB	Stock	45.55	45.57	44.95	45.1	103100.0
2017-01-27	ABCD-DELISTED	Stock	5.24	5.24	5.095	5.2	12428.0
2017-01-27	ABCO-DELISTED	Stock	44.75	45.35	44.025	45.0	722784.0
2017-01-27	ABDC-DELISTED	Stock	12.26	12.26	12.01	12.15	41459.0
2017-01-27	ABE-DELISTED	Stock	11.561	11.8	11.561	11.74	1301.0
2017-01-27	ABEO	Stock	123.75	123.75	116.25	120.0	3188.0
2017-01-27	ABEV	Stock	5.44	5.48	5.35	5.45	14695100.0
2017-01-27	ABG	Stock	65.2	65.5	64.25	64.7	172600.0
2017-01-27	ABIL-DELISTED	Stock	3.19	3.34	3.19	3.34	10644.0
2017-01-27	ABM	Stock	40.99	41.37	40.77	41.37	559400.0
2017-01-27	ABMD-DELISTED	Stock	105.75	110.46	105.75	108.81	668235.0
2017-01-27	ABR	Stock	7.56	7.56	7.48	7.5	69700.0

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

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