PREVIEW / stock_daily / 2014-06-30

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-30.parquet
  size:    221 KB
  rows:    6,620
  symbols: 3,599

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
2014-06-30	AAPL	Stock	23.025	23.4325	23.0225	23.2325	197929200.0
2014-06-30	MSFT	Stock	42.17	42.21	41.7	41.7	30793100.0
2014-06-30	NVDA	Stock	0.4578	0.4648	0.4578	0.4635	180512000.0
2014-06-30	AMZN	Stock	16.249	16.349	16.112	16.239	53426000.0
2014-06-30	GOOGL	Stock	29.338	29.3855	29.1645	29.2335	29588220.0
2014-06-30	META	Stock	67.46	67.92	67.13	67.29	27102800.0
2014-06-30	TSLA	Stock	15.97	16.2993	15.9333	16.004	72429000.0
2014-06-30	TLT	Stock	113.56	113.8	113.09	113.52	5593063.0
2014-06-30	ES	Stock	46.92	47.37	46.65	47.27	1257400.0
2014-06-30	CL	Stock	68.31	68.86	67.92	68.18	2711400.0
2014-06-30	A	Stock	41.1302	41.3162	40.9013	41.0873	1837531.0
2014-06-30	AABA-DELISTED	Stock	34.96	35.26	34.85	35.12	19449835.0
2014-06-30	AACG	Stock	4.52	4.77	4.5	4.65	13000.0
2014-06-30	AAIC-DELISTED	Stock	27.34	27.47	27.26	27.33	187099.0
2014-06-30	AAL	Stock	44.04	44.08	42.83	42.96	10439600.0
2014-06-30	AAMC-DELISTED	Stock	232.6471	237.2962	210.2941	212.6647	194432.0
2014-06-30	AAME	Stock	3.97	3.97	3.83	3.85	1300.0
2014-06-30	AAOI	Stock	22.96	23.32	22.35	23.2	163400.0
2014-06-30	AAON	Stock	14.7156	14.9556	14.5467	14.8978	283050.0
2014-06-30	AAP	Stock	133.67	136.12	132.88	134.92	1470500.0
2014-06-30	AAT	Stock	34.34	34.61	34.0	34.55	142100.0
2014-06-30	AAU-DELISTED	Stock	1.36	1.42	1.345	1.3951	141732.0
2014-06-30	AAUAF-DELISTED	Stock	1.36	1.41	1.3401	1.4	144857.0
2014-06-30	AAV-DELISTED	Stock	6.68	6.74	6.64	6.72	167145.0
2014-06-30	AAWW-DELISTED	Stock	36.52	37.25	36.29	36.85	157783.0
2014-06-30	AAXJ	Stock	62.95	62.99	62.64	62.69	158534.0
2014-06-30	AAXN-DELISTED	Stock	13.31	13.32	12.99	13.3	1133215.0
2014-06-30	AB	Stock	25.57	25.98	25.51	25.88	208600.0
2014-06-30	ABAC-DELISTED	Stock	2.07	2.09	2.03	2.05	9765.0
2014-06-30	ABAX-DELISTED	Stock	44.16	44.402	43.565	44.31	116515.0
2014-06-30	ABB-DELISTED	Stock	22.96	23.05	22.915	23.03	972533.0
2014-06-30	ABBNY-DELISTED	Stock	22.96	23.05	22.915	23.02	1087678.0
2014-06-30	ABBV	Stock	56.51	56.89	56.1	56.44	6229700.0
2014-06-30	ABC-DELISTED	Stock	72.99	72.99	72.4	72.65	1003828.0
2014-06-30	ABCB	Stock	21.6	21.65	21.36	21.56	35600.0
2014-06-30	ABCD-DELISTED	Stock	2.14	2.2	2.0907	2.2	13979.0
2014-06-30	ABCO-DELISTED	Stock	50.3	52.07	50.3	51.8	262247.0
2014-06-30	ABDC-DELISTED	Stock	14.7	15.5	14.17	14.85	196041.0
2014-06-30	ABE-DELISTED	Stock	14.37	14.39	14.315	14.36	2479.0
2014-06-30	ABEO	Stock	350.0	375.0	350.0	375.0	32.0
2014-06-30	ABEV	Stock	7.04	7.05	6.99	7.04	7074000.0
2014-06-30	ABG	Stock	67.75	69.42	67.34	68.74	405500.0
2014-06-30	ABGB-DELISTED	Stock	26.29	26.61	26.21	26.46	8502.0
2014-06-30	ABIL-DELISTED	Stock	9.76	9.8	9.76	9.76	399.0
2014-06-30	ABM	Stock	26.62	27.0	26.47	26.98	240600.0
2014-06-30	ABMD-DELISTED	Stock	25.08	25.24	24.65	25.15	372076.0
2014-06-30	ABR	Stock	7.0	7.05	6.94	6.95	101700.0
2014-06-30	ABR.A-DELISTED	Stock	24.6	24.82	24.56	24.6	16565.0
2014-06-30	ABR.B-DELISTED	Stock	24.45	24.66	24.45	24.65	4327.0
2014-06-30	ABR.C-DELISTED	Stock	25.07	25.07	25.07	25.07	400.0

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

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