PREVIEW / stock_daily / 2015-07-14

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-14.parquet
  size:    223 KB
  rows:    6,651
  symbols: 3,484

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-14	AAPL	Stock	31.51	31.5925	31.26	31.4025	127072400.0
2015-07-14	MSFT	Stock	45.45	45.96	45.31	45.62	22880300.0
2015-07-14	NVDA	Stock	0.4978	0.4982	0.4908	0.4972	249216000.0
2015-07-14	AMZN	Stock	23.116	23.48	22.908	23.2785	94724000.0
2015-07-14	GOOGL	Stock	28.725	29.4854	28.7085	29.209	74831660.0
2015-07-14	META	Stock	90.46	90.8	89.65	89.68	26627800.0
2015-07-14	TSLA	Stock	17.4733	17.7327	17.3673	17.71	28614000.0
2015-07-14	TLT	Stock	116.02	116.27	115.66	116.07	4227782.0
2015-07-14	ES	Stock	47.04	47.35	46.89	47.3	1322000.0
2015-07-14	CL	Stock	67.5	67.5	66.93	67.27	2143600.0
2015-07-14	A	Stock	40.05	40.66	39.89	40.49	2800900.0
2015-07-14	AA.B-DELISTED	Stock	39.52	39.64	39.02	39.1	299754.0
2015-07-14	AABA-DELISTED	Stock	38.65	39.03	38.44	38.62	8439386.0
2015-07-14	AAC-DELISTED	Stock	43.47	43.845	42.75	43.43	123691.0
2015-07-14	AACG	Stock	4.3	4.81	4.3	4.36	6700.0
2015-07-14	AAIC-DELISTED	Stock	20.14	20.36	20.11	20.2	357802.0
2015-07-14	AAL	Stock	42.04	42.46	41.29	42.06	12701500.0
2015-07-14	AAMC-DELISTED	Stock	42.2941	45.0706	42.0588	43.0794	33466.0
2015-07-14	AAME	Stock	3.7	3.7	3.65	3.65	2700.0
2015-07-14	AAMI	Stock	17.59	18.07	17.551	17.65	207700.0
2015-07-14	AAOI	Stock	19.85	20.33	19.335	19.7	456200.0
2015-07-14	AAON	Stock	15.4533	15.5333	15.2733	15.2933	93000.0
2015-07-14	AAP	Stock	169.39	169.9	167.06	167.21	829200.0
2015-07-14	AAT	Stock	41.08	41.23	40.75	41.03	71900.0
2015-07-14	AAU-DELISTED	Stock	0.775	0.81	0.7518	0.8016	42292.0
2015-07-14	AAUAF-DELISTED	Stock	0.775	0.81	0.7518	0.8016	42777.0
2015-07-14	AAV-DELISTED	Stock	6.23	6.35	6.22	6.24	59047.0
2015-07-14	AAVL-DELISTED	Stock	16.46	16.83	16.36	16.68	427912.0
2015-07-14	AAWW-DELISTED	Stock	53.18	54.35	52.39	53.55	516974.0
2015-07-14	AAXJ	Stock	61.09	61.49	61.07	61.43	703111.0
2015-07-14	AAXN-DELISTED	Stock	33.01	33.33	32.44	32.59	881641.0
2015-07-14	AB	Stock	28.7	29.0	28.03	28.23	428700.0
2015-07-14	ABAC-DELISTED	Stock	1.048	1.0699	0.995	1.03	73148.0
2015-07-14	ABAX-DELISTED	Stock	53.8	54.27	53.6101	54.01	40525.0
2015-07-14	ABB-DELISTED	Stock	20.94	21.0	20.82	20.87	1650199.0
2015-07-14	ABBNY-DELISTED	Stock	20.94	21.0	20.82	20.88	1699692.0
2015-07-14	ABBV	Stock	69.71	70.52	69.4	69.8	6628300.0
2015-07-14	ABC-DELISTED	Stock	109.99	110.69	109.23	110.38	1314512.0
2015-07-14	ABCB	Stock	25.85	26.02	25.66	26.01	187500.0
2015-07-14	ABCD-DELISTED	Stock	4.96	5.0	4.86	4.95	141742.0
2015-07-14	ABCO-DELISTED	Stock	58.26	58.7	57.73	57.99	542739.0
2015-07-14	ABCW-DELISTED	Stock	40.75	41.5	40.26	41.18	13271.0
2015-07-14	ABDC-DELISTED	Stock	13.0	13.36	12.58	12.64	111332.0
2015-07-14	ABE-DELISTED	Stock	13.0	13.06	12.97	12.98	6199.0
2015-07-14	ABEO	Stock	166.25	167.0	153.75	160.25	16684.0
2015-07-14	ABEOW-DELISTED	Stock	3.0	3.0	2.5	2.5	24747.0
2015-07-14	ABEV	Stock	6.22	6.28	6.19	6.21	12403900.0
2015-07-14	ABG	Stock	93.76	94.4	93.12	93.37	215600.0
2015-07-14	ABGB-DELISTED	Stock	15.6992	16.12	15.6992	15.98	4805.0
2015-07-14	ABM	Stock	32.43	32.72	32.3	32.66	122200.0

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

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