PREVIEW / stock_daily / 2015-03-20

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-20.parquet
  size:    224 KB
  rows:    6,660
  symbols: 3,527

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-20	AAPL	Stock	32.0625	32.1	31.29	31.475	274780400.0
2015-03-20	MSFT	Stock	42.56	42.98	42.49	42.88	71904500.0
2015-03-20	NVDA	Stock	0.5853	0.5903	0.5798	0.5868	462084000.0
2015-03-20	AMZN	Stock	18.8145	18.9685	18.796	18.9245	75272000.0
2015-03-20	GOOGL	Stock	28.3355	28.355	28.224	28.2475	44320760.0
2015-03-20	META	Stock	83.39	84.6	83.07	83.8	44466300.0
2015-03-20	TSLA	Stock	13.1633	13.266	13.0413	13.2053	64042500.0
2015-03-20	TLT	Stock	131.22	131.7	131.14	131.51	5953751.0
2015-03-20	ES	Stock	50.92	51.5	50.51	51.01	2288300.0
2015-03-20	CL	Stock	68.65	69.61	68.52	69.56	4508200.0
2015-03-20	A	Stock	42.39	42.53	42.2	42.21	2315500.0
2015-03-20	AA.B-DELISTED	Stock	44.05	44.3	43.87	44.1731	122328.0
2015-03-20	AABA-DELISTED	Stock	45.37	45.58	44.9138	45.03	13573483.0
2015-03-20	AAC-DELISTED	Stock	31.575	31.575	30.26	30.65	155766.0
2015-03-20	AACG	Stock	3.9	3.9	3.9	3.9	400.0
2015-03-20	AAIC-DELISTED	Stock	25.08	25.27	24.92	25.19	446450.0
2015-03-20	AAL	Stock	55.19	56.05	54.86	55.76	137767200.0
2015-03-20	AAMC-DELISTED	Stock	58.8382	61.1765	58.5294	60.5882	14277.0
2015-03-20	AAME	Stock	3.98	4.08	3.92	3.95	7500.0
2015-03-20	AAMI	Stock	18.46	19.0	18.063	18.78	261900.0
2015-03-20	AAOI	Stock	13.89	14.008	13.534	13.8	244200.0
2015-03-20	AAON	Stock	15.0067	15.7533	14.9267	15.62	943050.0
2015-03-20	AAP	Stock	149.4	152.29	148.48	151.91	1563000.0
2015-03-20	AAT	Stock	43.6	44.79	43.6	44.46	426400.0
2015-03-20	AAU-DELISTED	Stock	0.93	0.9449	0.9055	0.93	76628.0
2015-03-20	AAUAF-DELISTED	Stock	0.94	0.96	0.92	0.93	76040.0
2015-03-20	AAV-DELISTED	Stock	5.33	5.38	5.27	5.29	223565.0
2015-03-20	AAVL-DELISTED	Stock	45.0	45.1825	43.07	44.63	512954.0
2015-03-20	AAWW-DELISTED	Stock	47.14	47.56	46.86	47.21	355695.0
2015-03-20	AAXJ	Stock	63.51	63.89	63.5	63.76	1607396.0
2015-03-20	AAXN-DELISTED	Stock	24.59	24.6	24.0	24.09	1074205.0
2015-03-20	AB	Stock	30.74	31.0	30.7	30.93	447400.0
2015-03-20	ABAC-DELISTED	Stock	1.57	1.7644	1.4601	1.53	15167.0
2015-03-20	ABAX-DELISTED	Stock	65.0	65.84	64.896	65.62	186559.0
2015-03-20	ABB-DELISTED	Stock	21.34	21.48	21.23	21.4	3705536.0
2015-03-20	ABBNY-DELISTED	Stock	21.34	21.48	21.23	21.41	3796977.0
2015-03-20	ABBV	Stock	61.5	61.73	60.32	60.4	13313100.0
2015-03-20	ABC-DELISTED	Stock	112.98	114.5	112.84	113.52	4037424.0
2015-03-20	ABCB	Stock	26.2	26.59	25.86	25.9	490300.0
2015-03-20	ABCD-DELISTED	Stock	3.17	3.25	3.07	3.11	72300.0
2015-03-20	ABCO-DELISTED	Stock	52.86	53.66	51.86	52.91	382536.0
2015-03-20	ABCW-DELISTED	Stock	35.03	35.05	34.92	35.05	15505.0
2015-03-20	ABDC-DELISTED	Stock	13.79	14.44	13.7501	13.86	98816.0
2015-03-20	ABE-DELISTED	Stock	12.69	12.69	12.57	12.6	22832.0
2015-03-20	ABEO	Stock	85.5	87.0	72.75	72.75	7056.0
2015-03-20	ABEOW-DELISTED	Stock	0.93	0.93	0.93	0.93	400.0
2015-03-20	ABEV	Stock	5.75	5.88	5.72	5.82	11324400.0
2015-03-20	ABG	Stock	80.0	80.0	78.33	79.46	516700.0
2015-03-20	ABGB-DELISTED	Stock	17.06	17.38	17.06	17.16	38610.0
2015-03-20	ABIL-DELISTED	Stock	9.95	10.05	9.95	10.03	12000.0

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

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