PREVIEW / stock_daily / 2015-06-19

all stock daily files

  file:    by_date/stock_daily/2015/2015-06-19.parquet
  size:    226 KB
  rows:    6,681
  symbols: 3,512

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-06-19	AAPL	Stock	31.9275	31.955	31.6	31.65	218867600.0
2015-06-19	MSFT	Stock	46.79	46.83	45.99	46.1	63837000.0
2015-06-19	NVDA	Stock	0.5485	0.553	0.5418	0.5468	355656000.0
2015-06-19	AMZN	Stock	22.013	22.2495	21.662	21.746	89902000.0
2015-06-19	GOOGL	Stock	27.826	27.8955	27.6129	27.876	59289780.0
2015-06-19	META	Stock	82.83	82.98	82.12	82.51	23353200.0
2015-06-19	TSLA	Stock	17.4933	17.5867	17.34	17.5007	36945000.0
2015-06-19	TLT	Stock	118.51	119.185	118.49	119.08	10439248.0
2015-06-19	ES	Stock	47.27	47.51	46.74	46.74	1819900.0
2015-06-19	CL	Stock	66.79	67.18	66.6	66.9	3674400.0
2015-06-19	A	Stock	39.8	39.94	39.49	39.49	2658800.0
2015-06-19	AA.B-DELISTED	Stock	41.99	42.55	41.99	42.37	117394.0
2015-06-19	AABA-DELISTED	Stock	40.93	40.93	40.37	40.505	10912229.0
2015-06-19	AAC-DELISTED	Stock	43.58	44.4	43.2717	44.27	156011.0
2015-06-19	AACG	Stock	5.89	5.89	5.6	5.79	22900.0
2015-06-19	AAIC-DELISTED	Stock	21.02	21.18	20.92	20.95	487511.0
2015-06-19	AAL	Stock	40.3	41.89	40.3	41.56	20198300.0
2015-06-19	AAMC-DELISTED	Stock	44.4559	46.6735	44.4118	46.6735	31827.0
2015-06-19	AAME	Stock	3.68	3.72	3.63	3.7	18900.0
2015-06-19	AAMI	Stock	18.08	18.68	17.96	18.34	752800.0
2015-06-19	AAOI	Stock	18.74	18.89	17.05	18.36	607600.0
2015-06-19	AAON	Stock	15.7267	15.7267	15.56	15.5667	343050.0
2015-06-19	AAP	Stock	159.64	161.94	159.49	160.5	649200.0
2015-06-19	AAT	Stock	41.11	41.37	40.62	41.26	563100.0
2015-06-19	AAU-DELISTED	Stock	0.87	0.883	0.85	0.87	57755.0
2015-06-19	AAUAF-DELISTED	Stock	0.87	0.883	0.85	0.87	58660.0
2015-06-19	AAV-DELISTED	Stock	6.24	6.29	6.18	6.29	57149.0
2015-06-19	AAVL-DELISTED	Stock	16.24	16.32	15.03	15.55	3642812.0
2015-06-19	AAWW-DELISTED	Stock	55.21	55.74	54.18	54.74	476752.0
2015-06-19	AAXJ	Stock	64.29	64.44	64.12	64.13	752138.0
2015-06-19	AAXN-DELISTED	Stock	35.0	35.15	34.12	34.48	2894788.0
2015-06-19	AB	Stock	30.88	30.9	30.58	30.66	120200.0
2015-06-19	ABAC-DELISTED	Stock	1.4073	1.5993	1.4073	1.491	36990.0
2015-06-19	ABAX-DELISTED	Stock	52.21	52.21	51.78	51.93	109448.0
2015-06-19	ABB-DELISTED	Stock	22.48	22.5	22.26	22.3	2079107.0
2015-06-19	ABBNY-DELISTED	Stock	22.48	22.5	22.26	22.31	2128287.0
2015-06-19	ABBV	Stock	68.5	69.75	68.5	69.48	9979500.0
2015-06-19	ABC-DELISTED	Stock	111.72	112.31	111.3375	111.76	3976933.0
2015-06-19	ABCB	Stock	25.85	25.85	25.08	25.59	223500.0
2015-06-19	ABCD-DELISTED	Stock	4.25	4.25	4.12	4.22	42656.0
2015-06-19	ABCO-DELISTED	Stock	53.61	54.16	52.93	53.89	372846.0
2015-06-19	ABCW-DELISTED	Stock	37.0	37.1	36.94	36.98	226358.0
2015-06-19	ABDC-DELISTED	Stock	13.75	13.9	13.74	13.75	43044.0
2015-06-19	ABE-DELISTED	Stock	12.85	12.8796	12.84	12.8796	895.0
2015-06-19	ABEO	Stock	165.5	168.0	156.25	165.25	32616.0
2015-06-19	ABEOW-DELISTED	Stock	2.42	2.44	2.4	2.4	1622.0
2015-06-19	ABEV	Stock	6.07	6.09	6.03	6.07	10285900.0
2015-06-19	ABG	Stock	88.03	89.3	87.91	88.22	505100.0
2015-06-19	ABGB-DELISTED	Stock	16.7	17.06	16.6725	16.87	31790.0
2015-06-19	ABM	Stock	33.33	33.48	33.0	33.34	251800.0

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

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