PREVIEW / stock_daily / 2014-09-30

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-30.parquet
  size:    222 KB
  rows:    6,633
  symbols: 3,566

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-09-30	AAPL	Stock	25.2025	25.385	25.1325	25.1875	221056400.0
2014-09-30	MSFT	Stock	46.37	46.48	46.01	46.36	33033100.0
2014-09-30	NVDA	Stock	0.461	0.4645	0.4558	0.4612	277204000.0
2014-09-30	AMZN	Stock	16.068	16.1715	15.9255	16.122	52724000.0
2014-09-30	GOOGL	Stock	29.3745	29.55	29.225	29.4205	31433760.0
2014-09-30	META	Stock	79.35	79.71	78.6	79.04	35899000.0
2014-09-30	TSLA	Stock	16.4613	16.51	16.008	16.1787	63574500.0
2014-09-30	TLT	Stock	116.66	117.04	116.13	116.27	7277543.0
2014-09-30	ES	Stock	44.39	44.83	44.18	44.3	1143300.0
2014-09-30	CL	Stock	65.76	65.83	65.16	65.22	5033900.0
2014-09-30	A	Stock	40.9227	41.0587	40.6438	40.7582	2964599.0
2014-09-30	AA.B-DELISTED	Stock	50.0	50.45	49.77	50.0	463598.0
2014-09-30	AABA-DELISTED	Stock	40.58	41.23	40.44	40.755	29300932.0
2014-09-30	AACG	Stock	4.44	4.48	4.44	4.48	4000.0
2014-09-30	AAIC-DELISTED	Stock	26.14	26.19	25.41	25.41	562311.0
2014-09-30	AAL	Stock	35.05	35.85	34.34	35.48	10657900.0
2014-09-30	AAMC-DELISTED	Stock	207.7853	208.8235	198.5324	198.5324	29226.0
2014-09-30	AAME	Stock	3.98	3.98	3.97	3.98	2100.0
2014-09-30	AAOI	Stock	16.65	16.79	15.61	16.1	534000.0
2014-09-30	AAON	Stock	11.6267	11.72	11.3333	11.34	461550.0
2014-09-30	AAP	Stock	130.84	131.09	129.01	130.3	781300.0
2014-09-30	AAT	Stock	33.51	33.64	32.96	32.97	375500.0
2014-09-30	AAU-DELISTED	Stock	1.3697	1.3697	1.33	1.34	63652.0
2014-09-30	AAUAF-DELISTED	Stock	1.3697	1.3697	1.33	1.34	64337.0
2014-09-30	AAV-DELISTED	Stock	5.24	5.31	5.04	5.09	460363.0
2014-09-30	AAVL-DELISTED	Stock	36.25	36.46	34.02	34.19	930678.0
2014-09-30	AAWW-DELISTED	Stock	33.94	34.07	32.98	33.02	361395.0
2014-09-30	AAXJ	Stock	61.3	61.44	61.14	61.32	593318.0
2014-09-30	AAXN-DELISTED	Stock	15.88	15.95	15.21	15.44	2964862.0
2014-09-30	AB	Stock	26.6	26.6	26.01	26.01	128400.0
2014-09-30	ABAC-DELISTED	Stock	2.05	2.09	1.99	2.0	8500.0
2014-09-30	ABAX-DELISTED	Stock	50.5	51.04	50.0	50.7	202297.0
2014-09-30	ABB-DELISTED	Stock	22.37	22.515	22.311	22.4	1799189.0
2014-09-30	ABBNY-DELISTED	Stock	22.37	22.515	22.311	22.41	1869751.0
2014-09-30	ABBV	Stock	58.26	58.81	57.73	57.76	8599000.0
2014-09-30	ABC-DELISTED	Stock	77.65	78.02	77.19	77.31	1155127.0
2014-09-30	ABCB	Stock	22.01	22.12	21.92	21.95	153400.0
2014-09-30	ABCD-DELISTED	Stock	1.49	1.55	1.49	1.55	1200.0
2014-09-30	ABCO-DELISTED	Stock	46.19	46.86	45.69	46.59	438651.0
2014-09-30	ABDC-DELISTED	Stock	12.8	13.28	12.4	13.28	184725.0
2014-09-30	ABE-DELISTED	Stock	13.85	13.89	13.85	13.88	5332.0
2014-09-30	ABEO	Stock	350.0	375.0	350.0	350.0	32.0
2014-09-30	ABEV	Stock	6.53	6.63	6.5	6.55	16911600.0
2014-09-30	ABG	Stock	65.82	65.85	64.2	64.42	352700.0
2014-09-30	ABGB-DELISTED	Stock	26.1	26.59	25.99	26.58	24874.0
2014-09-30	ABM	Stock	26.05	26.25	25.69	25.69	310400.0
2014-09-30	ABMD-DELISTED	Stock	25.09	25.15	24.75	24.86	272845.0
2014-09-30	ABR	Stock	6.69	6.77	6.61	6.74	190000.0
2014-09-30	ABR.A-DELISTED	Stock	24.35	24.5899	24.35	24.44	3011.0
2014-09-30	ABR.B-DELISTED	Stock	24.08	24.25	24.08	24.25	973.0

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

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