PREVIEW / stock_daily / 2015-08-27

all stock daily files

  file:    by_date/stock_daily/2015/2015-08-27.parquet
  size:    222 KB
  rows:    6,686
  symbols: 3,483

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-08-27	AAPL	Stock	28.0575	28.31	27.505	28.23	338464400.0
2015-08-27	MSFT	Stock	43.23	43.95	42.93	43.9	50943200.0
2015-08-27	NVDA	Stock	0.551	0.566	0.5478	0.5658	463764000.0
2015-08-27	AMZN	Stock	25.6855	26.1345	25.363	25.9185	122290000.0
2015-08-27	GOOGL	Stock	33.5995	33.699	32.555	33.398	58974720.0
2015-08-27	META	Stock	89.1	90.06	87.19	89.73	42431400.0
2015-08-27	TSLA	Stock	15.4	16.3167	15.3873	16.1993	114840000.0
2015-08-27	TLT	Stock	121.82	122.87	121.65	122.0	9126952.0
2015-08-27	ES	Stock	48.37	48.62	47.87	48.59	1263400.0
2015-08-27	CL	Stock	62.58	63.29	61.94	63.09	5006900.0
2015-08-27	A	Stock	36.17	36.67	35.89	36.64	2406300.0
2015-08-27	AA.B-DELISTED	Stock	31.9	33.51	31.9	33.1	62534.0
2015-08-27	AABA-DELISTED	Stock	33.36	33.77	32.95	33.69	17913695.0
2015-08-27	AAC-DELISTED	Stock	21.95	22.345	20.5	21.75	241836.0
2015-08-27	AACG	Stock	2.52	2.55	2.31	2.4	3800.0
2015-08-27	AAIC-DELISTED	Stock	16.5	16.9099	16.37	16.73	249846.0
2015-08-27	AAL	Stock	39.17	39.45	37.97	39.03	13793600.0
2015-08-27	AAMC-DELISTED	Stock	9.9971	11.1824	9.8235	11.1176	66698.0
2015-08-27	AAME	Stock	3.6	3.6	3.48	3.52	4600.0
2015-08-27	AAMI	Stock	16.52	16.63	16.1	16.57	163000.0
2015-08-27	AAOI	Stock	19.79	20.76	19.6	20.49	350900.0
2015-08-27	AAON	Stock	13.5533	13.8333	13.2733	13.82	218550.0
2015-08-27	AAP	Stock	172.81	176.3	172.25	176.23	1591600.0
2015-08-27	AAT	Stock	39.04	39.87	38.84	39.63	148700.0
2015-08-27	AAU-DELISTED	Stock	0.5159	0.6015	0.4961	0.5	44723.0
2015-08-27	AAUAF-DELISTED	Stock	0.52	0.6063	0.5001	0.504	45090.0
2015-08-27	AAV-DELISTED	Stock	5.16	5.62	5.15	5.33	193393.0
2015-08-27	AAVL-DELISTED	Stock	10.5	10.87	10.46	10.67	408736.0
2015-08-27	AAWW-DELISTED	Stock	39.75	41.25	39.3101	41.18	397268.0
2015-08-27	AAXJ	Stock	53.35	54.37	53.28	54.27	2496248.0
2015-08-27	AAXN-DELISTED	Stock	22.85	23.79	22.35	23.62	2824769.0
2015-08-27	AB	Stock	27.09	27.55	26.54	27.1	348600.0
2015-08-27	ABAC-DELISTED	Stock	0.768	0.78	0.675	0.78	11983.0
2015-08-27	ABAX-DELISTED	Stock	47.19	47.55	46.58	47.18	143119.0
2015-08-27	ABB-DELISTED	Stock	19.08	19.42	19.015	19.32	3730914.0
2015-08-27	ABBNY-DELISTED	Stock	19.08	19.42	19.015	19.32	3823731.0
2015-08-27	ABBV	Stock	64.03	64.6	63.0	64.51	12592100.0
2015-08-27	ABC-DELISTED	Stock	101.47	101.785	99.4	101.15	3193035.0
2015-08-27	ABCB	Stock	26.77	27.18	26.48	26.67	127200.0
2015-08-27	ABCD-DELISTED	Stock	4.98	5.32	4.9	5.15	209735.0
2015-08-27	ABCO-DELISTED	Stock	50.11	50.21	48.91	49.63	284715.0
2015-08-27	ABCW-DELISTED	Stock	39.72	41.29	39.46	41.29	12233.0
2015-08-27	ABDC-DELISTED	Stock	11.87	12.566	11.84	12.21	80826.0
2015-08-27	ABE-DELISTED	Stock	10.76	11.15	10.76	10.94	8148.0
2015-08-27	ABEO	Stock	114.75	121.25	114.5	117.5	4668.0
2015-08-27	ABEOW-DELISTED	Stock	1.72	1.73	1.3457	1.55	4051.0
2015-08-27	ABEV	Stock	5.27	5.44	5.27	5.37	15585000.0
2015-08-27	ABG	Stock	79.99	82.18	79.35	80.1	419600.0
2015-08-27	ABGB-DELISTED	Stock	6.49	6.57	5.56	5.63	396078.0
2015-08-27	ABIL-DELISTED	Stock	10.05	10.05	10.05	10.05	100.0

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

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