PREVIEW / stock_daily / 2014-03-07

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-07.parquet
  size:    219 KB
  rows:    6,515
  symbols: 3,557

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-03-07	AAPL	Stock	18.9675	18.9993	18.7875	18.9443	220729600.0
2014-03-07	MSFT	Stock	38.28	38.36	37.69	37.9	26591600.0
2014-03-07	NVDA	Stock	0.4615	0.4622	0.4555	0.459	268452000.0
2014-03-07	AMZN	Stock	18.729	18.7495	18.4765	18.603	45596000.0
2014-03-07	META	Stock	71.08	71.18	69.47	69.8	38927000.0
2014-03-07	TSLA	Stock	16.8627	16.99	16.294	16.414	117184500.0
2014-03-07	TLT	Stock	105.64	106.17	105.6	105.89	8270425.0
2014-03-07	ES	Stock	43.43	43.75	43.21	43.75	1772900.0
2014-03-07	CL	Stock	63.09	63.23	62.85	63.13	1992800.0
2014-03-07	A	Stock	42.2461	42.3462	41.1445	41.7883	4539586.0
2014-03-07	AABA-DELISTED	Stock	39.71	39.9101	38.45	38.69	13962277.0
2014-03-07	AACG	Stock	4.2	6.41	4.2	4.62	434400.0
2014-03-07	AAIC-DELISTED	Stock	27.35	27.4194	26.67	26.81	197318.0
2014-03-07	AAL	Stock	39.22	39.29	38.11	39.02	10536100.0
2014-03-07	AAMC-DELISTED	Stock	235.2941	248.1235	235.2794	243.2794	162727.0
2014-03-07	AAME	Stock	3.85	3.95	3.85	3.92	15200.0
2014-03-07	AAOI	Stock	25.85	25.85	24.4	25.29	165800.0
2014-03-07	AAON	Stock	13.7822	13.8044	13.3111	13.6133	193050.0
2014-03-07	AAP	Stock	127.03	128.13	126.46	126.8	530300.0
2014-03-07	AAT	Stock	33.19	33.42	32.7	32.84	121000.0
2014-03-07	AAU-DELISTED	Stock	1.62	1.63	1.541	1.56	237986.0
2014-03-07	AAUAF-DELISTED	Stock	1.62	1.63	1.541	1.56	240271.0
2014-03-07	AAV-DELISTED	Stock	4.15	4.19	4.11	4.13	85824.0
2014-03-07	AAWW-DELISTED	Stock	32.66	32.66	31.44	31.99	813584.0
2014-03-07	AAXJ	Stock	58.72	58.72	58.01	58.37	706570.0
2014-03-07	AAXN-DELISTED	Stock	19.8	19.85	18.7202	18.89	1494776.0
2014-03-07	AB	Stock	24.11	24.15	23.7	23.85	209800.0
2014-03-07	ABAC-DELISTED	Stock	2.05	2.14	1.96	2.0599	64550.0
2014-03-07	ABAX-DELISTED	Stock	39.1	40.0	38.44	39.12	50480.0
2014-03-07	ABB-DELISTED	Stock	25.8	25.81	25.39	25.52	1798631.0
2014-03-07	ABBNY-DELISTED	Stock	25.8	25.81	25.39	25.51	2392156.0
2014-03-07	ABBV	Stock	52.25	52.5	51.01	51.46	5860700.0
2014-03-07	ABC-DELISTED	Stock	69.25	69.27	68.56	68.95	1275136.0
2014-03-07	ABCB	Stock	21.59	21.62	21.25	21.59	74100.0
2014-03-07	ABCD-DELISTED	Stock	2.0001	2.1	1.98	2.08	114436.0
2014-03-07	ABCO-DELISTED	Stock	66.95	67.64	66.44	67.27	128106.0
2014-03-07	ABE-DELISTED	Stock	12.75	12.75	12.531	12.574	9539.0
2014-03-07	ABEO	Stock	462.5	487.5	462.5	462.5	1.0
2014-03-07	ABEV	Stock	7.18	7.22	7.07	7.15	8040700.0
2014-03-07	ABFS-DELISTED	Stock	36.75	37.61	36.417	37.19	512355.0
2014-03-07	ABG	Stock	54.41	55.09	54.16	54.88	368000.0
2014-03-07	ABGB-DELISTED	Stock	24.64	24.81	24.42	24.44	17172.0
2014-03-07	ABIL-DELISTED	Stock	9.6	9.69	9.6	9.69	1784.0
2014-03-07	ABM	Stock	28.32	28.6	28.11	28.44	273500.0
2014-03-07	ABMD-DELISTED	Stock	30.75	30.75	29.08	29.43	159124.0
2014-03-07	ABR	Stock	6.75	6.98	6.68	6.85	145100.0
2014-03-07	ABR.A-DELISTED	Stock	24.32	24.3675	24.312	24.3499	1100.0
2014-03-07	ABR.B-DELISTED	Stock	23.0	23.0	22.95	22.95	10113.0
2014-03-07	ABR.C-DELISTED	Stock	24.28	24.4	24.25	24.4	43503.0
2014-03-07	ABT	Stock	39.84	39.95	39.32	39.57	8630700.0

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

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