PREVIEW / stock_daily / 2016-08-15

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-15.parquet
  size:    221 KB
  rows:    6,583
  symbols: 3,263

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-08-15	AAPL	Stock	27.035	27.385	27.02	27.37	103472800.0
2016-08-15	MSFT	Stock	58.01	58.5	57.96	58.12	19283900.0
2016-08-15	NVDA	Stock	1.5778	1.5875	1.5533	1.5745	573304000.0
2016-08-15	AMZN	Stock	38.595	38.602	38.3855	38.4245	42370000.0
2016-08-15	GOOGL	Stock	40.3605	40.568	40.2015	40.298	18601480.0
2016-08-15	META	Stock	124.91	124.92	123.7	123.9	19295100.0
2016-08-15	TSLA	Stock	15.068	15.3	14.9953	15.0393	30514500.0
2016-08-15	TLT	Stock	139.34	139.63	138.75	138.76	5108563.0
2016-08-15	ES	Stock	57.37	57.37	56.34	56.37	1176200.0
2016-08-15	CL	Stock	75.0	75.24	74.64	74.71	2375800.0
2016-08-15	A	Stock	48.17	48.62	48.12	48.44	2323500.0
2016-08-15	AA.B-DELISTED	Stock	35.3	36.25	35.2901	36.11	19846.0
2016-08-15	AAAP-DELISTED	Stock	32.06	32.09	31.72	31.88	13919.0
2016-08-15	AABA-DELISTED	Stock	43.18	43.29	42.43	42.67	12904120.0
2016-08-15	AAC-DELISTED	Stock	19.04	21.45	18.41	18.54	573490.0
2016-08-15	AACG	Stock	4.3	4.3	3.87	4.07	1500.0
2016-08-15	AAIC-DELISTED	Stock	14.71	14.82	14.69	14.7	167457.0
2016-08-15	AAL	Stock	34.96	36.05	34.9	35.87	7137200.0
2016-08-15	AAMC-DELISTED	Stock	3.9676	4.0441	3.7971	4.0224	32647.0
2016-08-15	AAME	Stock	4.01	4.01	3.75	3.75	3700.0
2016-08-15	AAMI	Stock	13.48	13.645	13.48	13.51	85500.0
2016-08-15	AAOI	Stock	14.05	14.18	13.85	14.03	240200.0
2016-08-15	AAON	Stock	18.0267	18.36	18.0267	18.2133	123900.0
2016-08-15	AAP	Stock	166.75	169.9	165.55	167.76	1854500.0
2016-08-15	AAT	Stock	45.37	45.47	44.78	44.84	240700.0
2016-08-15	AAU-DELISTED	Stock	1.65	1.67	1.61	1.63	313175.0
2016-08-15	AAUAF-DELISTED	Stock	1.65	1.67	1.61	1.63	316796.0
2016-08-15	AAV-DELISTED	Stock	6.94	7.0	6.88	7.0	119024.0
2016-08-15	AAWW-DELISTED	Stock	34.75	35.8	34.75	35.45	353992.0
2016-08-15	AAXJ	Stock	59.68	60.07	59.68	60.02	3588813.0
2016-08-15	AAXN-DELISTED	Stock	29.12	29.53	28.91	29.43	629919.0
2016-08-15	AB	Stock	22.06	22.39	22.0	22.2	198600.0
2016-08-15	ABAC-DELISTED	Stock	0.88	0.9728	0.7603	0.8229	93347.0
2016-08-15	ABAX-DELISTED	Stock	49.49	50.61	49.49	49.88	72145.0
2016-08-15	ABB-DELISTED	Stock	22.05	22.16	22.05	22.14	1210546.0
2016-08-15	ABBNY-DELISTED	Stock	22.05	22.16	22.05	22.13	1253869.0
2016-08-15	ABBV	Stock	67.47	68.12	67.32	67.39	5215400.0
2016-08-15	ABC-DELISTED	Stock	88.95	89.41	88.64	89.37	1633912.0
2016-08-15	ABCB	Stock	33.18	33.63	33.18	33.48	78000.0
2016-08-15	ABCD-DELISTED	Stock	4.79	4.82	4.65	4.75	18581.0
2016-08-15	ABCO-DELISTED	Stock	41.5	41.83	41.27	41.39	121076.0
2016-08-15	ABDC-DELISTED	Stock	12.5	12.5	12.33	12.38	33054.0
2016-08-15	ABE-DELISTED	Stock	12.55	12.89	12.55	12.83	7656.0
2016-08-15	ABEO	Stock	90.5	98.75	89.75	97.75	2888.0
2016-08-15	ABEOW-DELISTED	Stock	1.8	1.8	1.4652	1.6501	3291.0
2016-08-15	ABEV	Stock	6.23	6.3	6.2	6.27	12867900.0
2016-08-15	ABG	Stock	55.9	56.8	55.84	56.71	194000.0
2016-08-15	ABIL-DELISTED	Stock	4.51	4.65	4.35	4.52	157489.0
2016-08-15	ABM	Stock	37.65	38.12	37.65	38.12	108900.0
2016-08-15	ABMD-DELISTED	Stock	123.81	124.43	123.22	123.4	261457.0

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

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