PREVIEW / stock_daily / 2016-04-22

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-22.parquet
  size:    219 KB
  rows:    6,554
  symbols: 3,306

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
2016-04-22	AAPL	Stock	26.2525	26.62	26.155	26.42	134732400.0
2016-04-22	MSFT	Stock	51.91	52.43	50.77	51.78	126834100.0
2016-04-22	NVDA	Stock	0.9133	0.9195	0.9038	0.9068	223540000.0
2016-04-22	AMZN	Stock	31.2235	31.4125	30.578	31.025	101678000.0
2016-04-22	GOOGL	Stock	37.1955	37.696	36.5185	36.8885	140798960.0
2016-04-22	META	Stock	111.21	111.75	109.01	110.56	38458200.0
2016-04-22	TSLA	Stock	16.5927	16.9333	16.3807	16.9167	56794500.0
2016-04-22	TLT	Stock	128.85	128.91	128.24	128.36	5826383.0
2016-04-22	ES	Stock	55.19	55.52	55.17	55.4	1693600.0
2016-04-22	CL	Stock	68.76	69.09	68.24	69.06	3228600.0
2016-04-22	A	Stock	41.98	41.98	41.55	41.8	1396300.0
2016-04-22	AA.B-DELISTED	Stock	37.0	37.0	36.0	36.1425	26885.0
2016-04-22	AAAP-DELISTED	Stock	35.11	35.11	34.06	34.1	111531.0
2016-04-22	AABA-DELISTED	Stock	37.5	38.09	37.16	37.48	8626181.0
2016-04-22	AAC-DELISTED	Stock	20.19	20.95	20.19	20.6175	113643.0
2016-04-22	AACG	Stock	5.89	6.04	5.86	5.86	11300.0
2016-04-22	AAIC-DELISTED	Stock	13.03	13.16	12.85	12.97	205183.0
2016-04-22	AAL	Stock	37.68	38.49	37.01	38.21	20939500.0
2016-04-22	AAMC-DELISTED	Stock	4.8794	5.0353	4.6441	4.7088	59442.0
2016-04-22	AAME	Stock	4.46	4.62	4.42	4.62	1400.0
2016-04-22	AAMI	Stock	13.7	13.97	13.635	13.89	120400.0
2016-04-22	AAOI	Stock	11.05	11.6	11.05	11.59	515800.0
2016-04-22	AAON	Stock	18.0267	18.5	18.0267	18.36	237450.0
2016-04-22	AAP	Stock	157.38	158.96	155.18	158.4	540300.0
2016-04-22	AAT	Stock	37.69	38.16	37.69	37.9	312600.0
2016-04-22	AAU-DELISTED	Stock	1.2	1.2	1.11	1.1501	346945.0
2016-04-22	AAUAF-DELISTED	Stock	1.2	1.2	1.11	1.1501	348022.0
2016-04-22	AAV-DELISTED	Stock	5.47	5.7	5.47	5.53	81321.0
2016-04-22	AAVL-DELISTED	Stock	6.14	6.27	5.99	6.25	184984.0
2016-04-22	AAWW-DELISTED	Stock	40.39	41.2	39.1405	41.01	92668.0
2016-04-22	AAXJ	Stock	55.03	55.37	54.84	54.95	602819.0
2016-04-22	AAXN-DELISTED	Stock	18.54	18.8	18.45	18.67	581164.0
2016-04-22	AB	Stock	24.11	24.42	24.04	24.33	162200.0
2016-04-22	ABAC-DELISTED	Stock	0.6001	0.6919	0.6001	0.67	6976.0
2016-04-22	ABAX-DELISTED	Stock	45.61	46.48	45.55	46.45	187161.0
2016-04-22	ABB-DELISTED	Stock	20.74	20.81	20.69	20.79	1235747.0
2016-04-22	ABBNY-DELISTED	Stock	20.74	20.81	20.69	20.78	1294987.0
2016-04-22	ABBV	Stock	61.3	61.99	60.96	61.42	5103000.0
2016-04-22	ABC-DELISTED	Stock	92.03	92.42	91.15	91.91	1753119.0
2016-04-22	ABCB	Stock	31.32	32.76	31.22	32.39	435000.0
2016-04-22	ABCD-DELISTED	Stock	4.4	4.51	4.4	4.44	24138.0
2016-04-22	ABCO-DELISTED	Stock	31.62	32.21	31.62	31.885	308294.0
2016-04-22	ABCW-DELISTED	Stock	47.02	47.255	46.89	47.16	29573.0
2016-04-22	ABDC-DELISTED	Stock	11.8	11.8	11.5101	11.74	8846.0
2016-04-22	ABE-DELISTED	Stock	11.2536	12.1	11.2536	11.98	32443.0
2016-04-22	ABEO	Stock	68.75	70.0	67.5	69.25	1560.0
2016-04-22	ABEV	Stock	5.28	5.4	5.27	5.33	11574600.0
2016-04-22	ABG	Stock	56.62	58.98	56.1	58.72	373000.0
2016-04-22	ABGB-DELISTED	Stock	1.39	1.43	1.33	1.35	27563.0
2016-04-22	ABIL-DELISTED	Stock	7.4757	7.55	7.2	7.2	4133.0

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

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