PREVIEW / stock_daily / 2015-07-27

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-27.parquet
  size:    223 KB
  rows:    6,672
  symbols: 3,490

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-07-27	AAPL	Stock	30.7725	30.9025	30.53	30.6925	177822000.0
2015-07-27	MSFT	Stock	45.94	46.01	45.25	45.35	39701400.0
2015-07-27	NVDA	Stock	0.4812	0.4883	0.4772	0.4828	192420000.0
2015-07-27	AMZN	Stock	26.3875	27.2475	26.33	26.5705	149820000.0
2015-07-27	GOOGL	Stock	32.5785	33.3535	32.5775	32.9135	58382200.0
2015-07-27	META	Stock	96.58	96.61	93.83	94.17	38585400.0
2015-07-27	TSLA	Stock	17.4953	17.6287	16.7193	16.8673	70413000.0
2015-07-27	TLT	Stock	122.19	122.285	121.48	122.04	8171957.0
2015-07-27	ES	Stock	47.27	48.11	47.27	47.87	1207300.0
2015-07-27	CL	Stock	66.76	67.31	66.54	67.3	3576300.0
2015-07-27	A	Stock	39.04	39.65	38.61	39.61	5261300.0
2015-07-27	AA.B-DELISTED	Stock	36.5	36.99	35.86	35.9	28875.0
2015-07-27	AABA-DELISTED	Stock	38.31	38.31	37.65	37.84	12247722.0
2015-07-27	AAC-DELISTED	Stock	38.27	39.22	37.91	39.15	342947.0
2015-07-27	AACG	Stock	3.95	3.97	3.33	3.55	38100.0
2015-07-27	AAIC-DELISTED	Stock	18.69	18.88	18.66	18.73	436710.0
2015-07-27	AAL	Stock	39.63	40.81	38.9	40.14	12071400.0
2015-07-27	AAMC-DELISTED	Stock	40.2971	40.8794	38.9706	39.1471	16946.0
2015-07-27	AAME	Stock	3.7	3.7	3.7	3.7	900.0
2015-07-27	AAMI	Stock	17.05	17.5	17.0	17.45	332200.0
2015-07-27	AAOI	Stock	18.27	18.59	18.0	18.24	257800.0
2015-07-27	AAON	Stock	14.7	14.8	14.6133	14.7467	232050.0
2015-07-27	AAP	Stock	167.53	169.18	166.5	168.34	586400.0
2015-07-27	AAT	Stock	41.51	41.82	41.24	41.41	426900.0
2015-07-27	AAU-DELISTED	Stock	0.5993	0.609	0.58	0.6	78345.0
2015-07-27	AAUAF-DELISTED	Stock	0.62	0.63	0.58	0.58	77893.0
2015-07-27	AAV-DELISTED	Stock	5.41	5.45	5.28	5.33	110809.0
2015-07-27	AAVL-DELISTED	Stock	14.75	14.75	14.03	14.28	512961.0
2015-07-27	AAWW-DELISTED	Stock	48.36	49.21	47.85	48.7	440658.0
2015-07-27	AAXJ	Stock	58.42	58.69	58.2	58.4	3083832.0
2015-07-27	AAXN-DELISTED	Stock	30.76	30.9	29.17	30.33	1666427.0
2015-07-27	AB	Stock	26.26	26.75	25.55	26.75	307700.0
2015-07-27	ABAC-DELISTED	Stock	1.22	1.22	1.2	1.2	1400.0
2015-07-27	ABAX-DELISTED	Stock	49.01	49.496	48.02	49.09	266616.0
2015-07-27	ABB-DELISTED	Stock	19.89	19.89	19.64	19.68	2136411.0
2015-07-27	ABBNY-DELISTED	Stock	19.89	19.89	19.64	19.68	2211014.0
2015-07-27	ABBV	Stock	68.46	70.96	68.46	69.34	12841500.0
2015-07-27	ABC-DELISTED	Stock	108.13	108.2917	106.8	107.37	2341902.0
2015-07-27	ABCB	Stock	25.69	25.96	25.69	25.93	134300.0
2015-07-27	ABCD-DELISTED	Stock	4.86	4.91	4.76	4.84	64840.0
2015-07-27	ABCO-DELISTED	Stock	56.45	57.6	56.2756	57.01	186212.0
2015-07-27	ABCW-DELISTED	Stock	37.418	37.6	37.05	37.22	8236.0
2015-07-27	ABDC-DELISTED	Stock	12.74	13.0	12.07	12.21	56754.0
2015-07-27	ABE-DELISTED	Stock	12.53	12.69	12.4	12.49	18795.0
2015-07-27	ABEO	Stock	143.75	146.5	134.5	136.5	9792.0
2015-07-27	ABEOW-DELISTED	Stock	1.65	1.65	1.65	1.65	285.0
2015-07-27	ABEV	Stock	5.61	5.64	5.51	5.56	26916800.0
2015-07-27	ABG	Stock	84.18	84.7	82.48	83.13	544600.0
2015-07-27	ABGB-DELISTED	Stock	12.33	12.39	12.1	12.14	35211.0
2015-07-27	ABIL-DELISTED	Stock	9.95	9.97	9.95	9.95	129768.0

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

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