PREVIEW / stock_daily / 2015-04-06

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-06.parquet
  size:    223 KB
  rows:    6,654
  symbols: 3,528

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-04-06	AAPL	Stock	31.1175	31.8775	31.0825	31.8375	148776000.0
2015-04-06	MSFT	Stock	40.34	41.78	40.18	41.55	39223700.0
2015-04-06	NVDA	Stock	0.5242	0.5435	0.5188	0.5418	515864000.0
2015-04-06	AMZN	Stock	18.505	19.01	18.468	18.852	61014000.0
2015-04-06	GOOGL	Stock	26.942	27.277	26.785	27.1975	33717880.0
2015-04-06	META	Stock	80.8	82.81	80.8	82.44	19062900.0
2015-04-06	TSLA	Stock	13.2	13.85	13.1667	13.54	186837000.0
2015-04-06	TLT	Stock	131.43	131.48	129.72	130.0	5923761.0
2015-04-06	ES	Stock	50.73	51.42	50.57	51.05	1318200.0
2015-04-06	CL	Stock	69.02	70.3	68.88	69.95	2021700.0
2015-04-06	A	Stock	41.68	42.2	41.51	41.93	2379800.0
2015-04-06	AA.B-DELISTED	Stock	44.54	45.2099	44.54	45.06	70149.0
2015-04-06	AABA-DELISTED	Stock	43.82	44.03	43.61	43.67	10203870.0
2015-04-06	AAC-DELISTED	Stock	30.7	30.876	30.28	30.61	114095.0
2015-04-06	AACG	Stock	3.96	4.1	3.95	4.1	17900.0
2015-04-06	AAIC-DELISTED	Stock	23.85	24.08	23.85	24.02	168866.0
2015-04-06	AAL	Stock	48.35	48.69	47.67	48.08	13323400.0
2015-04-06	AAMC-DELISTED	Stock	62.3529	73.4147	62.3529	68.3324	40052.0
2015-04-06	AAME	Stock	3.96	3.96	3.96	3.96	300.0
2015-04-06	AAMI	Stock	18.46	18.71	18.46	18.55	102500.0
2015-04-06	AAOI	Stock	13.46	13.79	13.0	13.69	140200.0
2015-04-06	AAON	Stock	15.7933	16.02	15.7933	15.8733	136050.0
2015-04-06	AAP	Stock	143.77	147.26	143.34	145.73	1150900.0
2015-04-06	AAT	Stock	43.31	43.9	43.31	43.59	108600.0
2015-04-06	AAU-DELISTED	Stock	0.88	0.8922	0.85	0.8778	169078.0
2015-04-06	AAUAF-DELISTED	Stock	0.88	0.89	0.85	0.8842	175211.0
2015-04-06	AAV-DELISTED	Stock	5.63	5.84	5.6201	5.75	157151.0
2015-04-06	AAVL-DELISTED	Stock	37.99	38.9399	37.42	38.48	195049.0
2015-04-06	AAWW-DELISTED	Stock	42.83	43.3	42.49	42.5	178646.0
2015-04-06	AAXJ	Stock	65.62	66.13	65.55	65.83	1138907.0
2015-04-06	AAXN-DELISTED	Stock	24.19	24.71	24.16	24.51	592873.0
2015-04-06	AB	Stock	30.67	30.91	30.42	30.54	206100.0
2015-04-06	ABAC-DELISTED	Stock	1.7	1.94	1.49	1.83	215582.0
2015-04-06	ABAX-DELISTED	Stock	62.94	63.122	62.14	62.3	106768.0
2015-04-06	ABB-DELISTED	Stock	21.48	21.81	21.45	21.66	1319844.0
2015-04-06	ABBNY-DELISTED	Stock	21.48	21.81	21.45	21.66	1395177.0
2015-04-06	ABBV	Stock	56.81	57.89	56.68	57.61	10280100.0
2015-04-06	ABC-DELISTED	Stock	111.99	113.13	111.79	112.5	1570291.0
2015-04-06	ABCB	Stock	26.79	26.82	26.35	26.44	80000.0
2015-04-06	ABCD-DELISTED	Stock	3.23	3.23	3.1401	3.15	5950.0
2015-04-06	ABCO-DELISTED	Stock	52.65	54.12	52.41	53.96	192974.0
2015-04-06	ABCW-DELISTED	Stock	34.65	34.99	34.465	34.8	8468.0
2015-04-06	ABDC-DELISTED	Stock	13.69	13.9158	13.32	13.55	59516.0
2015-04-06	ABE-DELISTED	Stock	12.89	13.01	12.88	12.97	27586.0
2015-04-06	ABEO	Stock	78.0	79.75	75.0	79.75	852.0
2015-04-06	ABEOW-DELISTED	Stock	1.01	1.01	1.0	1.0	300.0
2015-04-06	ABEV	Stock	6.14	6.27	6.14	6.19	14949500.0
2015-04-06	ABG	Stock	83.69	85.16	83.01	85.01	202900.0
2015-04-06	ABGB-DELISTED	Stock	18.9	19.18	18.78	18.95	20641.0
2015-04-06	ABIL-DELISTED	Stock	10.0799	10.08	10.0799	10.08	1000.0

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

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