PREVIEW / stock_daily / 2015-01-21

all stock daily files

  file:    by_date/stock_daily/2015/2015-01-21.parquet
  size:    221 KB
  rows:    6,620
  symbols: 3,518

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-01-21	AAPL	Stock	27.2375	27.765	27.0675	27.3875	194303600.0
2015-01-21	MSFT	Stock	45.94	46.14	45.48	45.92	39081100.0
2015-01-21	NVDA	Stock	0.4978	0.5088	0.4942	0.5075	144780000.0
2015-01-21	AMZN	Stock	14.482	15.3	14.363	14.8625	201302000.0
2015-01-21	GOOGL	Stock	25.542	26.0926	25.4795	26.0195	46355780.0
2015-01-21	META	Stock	76.16	77.3	75.85	76.74	25096700.0
2015-01-21	TSLA	Stock	12.6367	13.2453	12.634	13.1047	62295000.0
2015-01-21	TLT	Stock	135.2	135.585	132.955	133.4	9803896.0
2015-01-21	ES	Stock	55.17	55.84	54.73	55.76	1396800.0
2015-01-21	CL	Stock	68.14	68.96	67.76	68.35	3373100.0
2015-01-21	A	Stock	37.75	38.41	37.68	38.16	2721600.0
2015-01-21	AA.B-DELISTED	Stock	49.8	51.169	49.8	51.0	48983.0
2015-01-21	AABA-DELISTED	Stock	47.62	48.3799	47.32	48.2	15505946.0
2015-01-21	AAC-DELISTED	Stock	28.88	29.9068	28.5	28.95	38436.0
2015-01-21	AACG	Stock	4.84	4.91	4.73	4.73	42000.0
2015-01-21	AAIC-DELISTED	Stock	26.24	26.61	26.03	26.54	251468.0
2015-01-21	AAL	Stock	52.65	54.0	51.95	53.67	12882200.0
2015-01-21	AAMC-DELISTED	Stock	81.9118	83.8294	78.5088	79.4088	19601.0
2015-01-21	AAMI	Stock	15.99	16.05	15.69	15.77	124000.0
2015-01-21	AAOI	Stock	8.62	8.89	8.56	8.74	144200.0
2015-01-21	AAON	Stock	14.3333	14.54	14.2933	14.4	131250.0
2015-01-21	AAP	Stock	152.49	154.09	152.07	153.35	711200.0
2015-01-21	AAT	Stock	43.34	43.55	42.98	43.42	89000.0
2015-01-21	AAU-DELISTED	Stock	1.1429	1.21	1.1	1.2	409627.0
2015-01-21	AAUAF-DELISTED	Stock	1.2	1.27	1.16	1.2	391772.0
2015-01-21	AAV-DELISTED	Stock	4.4	4.41	4.12	4.14	297957.0
2015-01-21	AAVL-DELISTED	Stock	47.3	47.63	39.93	41.56	683878.0
2015-01-21	AAWW-DELISTED	Stock	46.18	47.01	45.37	45.72	224412.0
2015-01-21	AAXJ	Stock	62.58	63.07	62.42	63.07	2593167.0
2015-01-21	AAXN-DELISTED	Stock	26.78	27.189	26.27	26.8	2122371.0
2015-01-21	AB	Stock	25.99	26.29	25.72	26.25	186700.0
2015-01-21	ABAC-DELISTED	Stock	1.4	1.4907	1.4	1.4907	1700.0
2015-01-21	ABAX-DELISTED	Stock	60.13	61.0	58.87	59.1	147288.0
2015-01-21	ABB-DELISTED	Stock	19.79	19.9	19.59	19.78	3920813.0
2015-01-21	ABBNY-DELISTED	Stock	19.79	19.9	19.59	19.78	6499358.0
2015-01-21	ABBV	Stock	63.1	63.45	62.28	62.7	7979500.0
2015-01-21	ABC-DELISTED	Stock	92.38	93.0	91.8995	92.79	1309989.0
2015-01-21	ABCB	Stock	23.24	23.66	22.91	23.01	74400.0
2015-01-21	ABCD-DELISTED	Stock	2.11	2.41	2.11	2.3	171999.0
2015-01-21	ABCO-DELISTED	Stock	46.99	46.99	44.11	44.33	621387.0
2015-01-21	ABCW-DELISTED	Stock	33.81	34.89	33.81	33.81	1537.0
2015-01-21	ABDC-DELISTED	Stock	12.97	13.08	12.6744	12.84	71843.0
2015-01-21	ABE-DELISTED	Stock	13.22	13.3625	13.1901	13.35	4567.0
2015-01-21	ABEO	Stock	78.0	83.0	77.0	79.75	400.0
2015-01-21	ABEOW-DELISTED	Stock	0.675	0.6999	0.675	0.69	2500.0
2015-01-21	ABEV	Stock	6.52	6.62	6.49	6.58	10901700.0
2015-01-21	ABG	Stock	70.38	72.07	70.26	71.87	269300.0
2015-01-21	ABGB-DELISTED	Stock	16.15	16.4712	16.0609	16.42	40388.0
2015-01-21	ABM	Stock	28.98	29.29	28.82	29.1	135700.0
2015-01-21	ABMD-DELISTED	Stock	37.69	38.45	37.45	37.81	224428.0

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

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