PREVIEW / stock_daily / 2017-03-13

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-13.parquet
  size:    215 KB
  rows:    6,465
  symbols: 3,045

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-03-13	AAPL	Stock	34.7125	34.8575	34.705	34.8	69686800.0
2017-03-13	MSFT	Stock	65.01	65.19	64.57	64.71	20100000.0
2017-03-13	NVDA	Stock	2.4885	2.5563	2.4878	2.5462	774136000.0
2017-03-13	AMZN	Stock	42.5885	42.7845	42.5855	42.7295	38194000.0
2017-03-13	GOOGL	Stock	43.0415	43.3565	43.041	43.229	23332100.0
2017-03-13	META	Stock	138.71	139.68	138.67	139.6	10955500.0
2017-03-13	TSLA	Stock	16.3213	16.4567	16.1853	16.4113	45339000.0
2017-03-13	TLT	Stock	116.83	117.09	116.49	116.51	6993071.0
2017-03-13	ES	Stock	57.68	58.17	57.63	58.04	2299300.0
2017-03-13	CL	Stock	73.92	74.27	73.75	73.9	3024500.0
2017-03-13	A	Stock	52.14	52.46	51.99	52.45	1376200.0
2017-03-13	AA	Stock	35.21	35.52	34.53	34.7	2491400.0
2017-03-13	AAAP-DELISTED	Stock	37.66	37.8	36.865	37.47	105840.0
2017-03-13	AABA-DELISTED	Stock	46.1	47.0	46.1	46.57	4362951.0
2017-03-13	AAC-DELISTED	Stock	8.69	9.1	8.68	8.73	146350.0
2017-03-13	AACG	Stock	3.7	3.7	3.6	3.65	3500.0
2017-03-13	AAIC-DELISTED	Stock	13.78	13.84	13.59	13.61	258047.0
2017-03-13	AAL	Stock	43.73	44.12	42.26	42.37	8882300.0
2017-03-13	AAM.A-DELISTED	Stock	24.73	24.73	24.55	24.63	257061.0
2017-03-13	AAMC-DELISTED	Stock	22.6471	23.2203	21.2132	21.8971	18156.0
2017-03-13	AAME	Stock	3.7	3.75	3.65	3.65	2500.0
2017-03-13	AAMI	Stock	15.07	15.16	14.93	15.06	531400.0
2017-03-13	AAOI	Stock	51.15	51.55	49.81	51.06	766500.0
2017-03-13	AAON	Stock	23.5333	23.78	23.52	23.5667	209400.0
2017-03-13	AAP	Stock	152.76	154.96	151.99	154.35	978900.0
2017-03-13	AAT	Stock	41.52	42.04	41.39	41.8	375200.0
2017-03-13	AAU-DELISTED	Stock	0.989	1.0299	0.975	1.01	202692.0
2017-03-13	AAUAF-DELISTED	Stock	0.989	1.0299	0.975	1.01	203749.0
2017-03-13	AAV-DELISTED	Stock	5.85	6.025	5.85	6.0	108467.0
2017-03-13	AAWW-DELISTED	Stock	54.35	54.95	53.65	53.9	117918.0
2017-03-13	AAXJ	Stock	61.2	61.39	61.19	61.31	636447.0
2017-03-13	AAXN-DELISTED	Stock	22.57	22.84	22.5	22.82	684275.0
2017-03-13	AB	Stock	22.75	22.85	22.6	22.75	259400.0
2017-03-13	ABAC-DELISTED	Stock	2.5	2.78	2.5	2.51	15501.0
2017-03-13	ABAX-DELISTED	Stock	48.74	49.54	48.74	49.18	43894.0
2017-03-13	ABB-DELISTED	Stock	22.66	22.78	22.55	22.64	1578457.0
2017-03-13	ABBNY-DELISTED	Stock	22.66	22.78	22.55	22.64	1629611.0
2017-03-13	ABBV	Stock	65.87	65.94	65.3	65.85	7577400.0
2017-03-13	ABC-DELISTED	Stock	88.76	89.25	88.22	89.14	1264994.0
2017-03-13	ABCB	Stock	45.6	46.8	45.5	46.45	255700.0
2017-03-13	ABCD-DELISTED	Stock	4.59	4.68	4.5501	4.56	12316.0
2017-03-13	ABCO-DELISTED	Stock	45.1	45.725	44.975	45.5	220644.0
2017-03-13	ABDC-DELISTED	Stock	12.96	13.59	12.75	13.55	109859.0
2017-03-13	ABE-DELISTED	Stock	12.18	12.28	12.17	12.26	22448.0
2017-03-13	ABEO	Stock	127.5	140.0	126.25	138.75	9936.0
2017-03-13	ABEV	Stock	5.48	5.51	5.46	5.48	6659300.0
2017-03-13	ABG	Stock	61.55	62.4	61.05	62.15	217500.0
2017-03-13	ABIL-DELISTED	Stock	2.23	2.3465	2.23	2.31	9961.0
2017-03-13	ABM	Stock	43.24	43.71	43.08	43.62	309700.0
2017-03-13	ABMD-DELISTED	Stock	120.95	121.86	120.39	121.66	210990.0

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

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