PREVIEW / stock_daily / 2016-08-25

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-25.parquet
  size:    219 KB
  rows:    6,542
  symbols: 3,236

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
2016-08-25	AAPL	Stock	26.8475	26.97	26.67	26.8925	100344800.0
2016-08-25	MSFT	Stock	57.88	58.29	57.78	58.17	18552600.0
2016-08-25	NVDA	Stock	1.549	1.5498	1.519	1.5383	406032000.0
2016-08-25	AMZN	Stock	37.8	38.028	37.737	37.961	32460000.0
2016-08-25	GOOGL	Stock	39.6	39.736	39.3615	39.565	24053600.0
2016-08-25	META	Stock	123.12	124.37	123.1	123.89	10730800.0
2016-08-25	TSLA	Stock	14.874	14.92	14.718	14.7307	26437500.0
2016-08-25	TLT	Stock	139.26	139.78	138.96	139.17	5855464.0
2016-08-25	ES	Stock	55.31	55.63	55.21	55.27	1138300.0
2016-08-25	CL	Stock	74.43	74.93	74.22	74.63	1567600.0
2016-08-25	A	Stock	46.67	47.42	46.61	47.26	2160100.0
2016-08-25	AA.B-DELISTED	Stock	34.6	35.04	34.4427	34.5461	25629.0
2016-08-25	AAAP-DELISTED	Stock	34.27	34.52	33.0	33.02	163294.0
2016-08-25	AABA-DELISTED	Stock	41.83	42.235	41.73	42.04	4802408.0
2016-08-25	AAC-DELISTED	Stock	18.32	18.7	18.32	18.67	162988.0
2016-08-25	AACG	Stock	4.08	4.5	4.08	4.27	2900.0
2016-08-25	AAIC-DELISTED	Stock	14.56	14.76	14.56	14.74	147263.0
2016-08-25	AAL	Stock	36.34	36.94	36.32	36.72	5446000.0
2016-08-25	AAMC-DELISTED	Stock	3.8809	3.8824	3.7235	3.7412	14511.0
2016-08-25	AAME	Stock	3.55	3.7	3.35	3.49	17700.0
2016-08-25	AAMI	Stock	13.55	13.71	13.26	13.37	120400.0
2016-08-25	AAOI	Stock	15.35	16.43	14.66	16.11	1753100.0
2016-08-25	AAON	Stock	18.52	18.7067	18.4467	18.6133	110850.0
2016-08-25	AAP	Stock	160.05	160.92	158.94	160.18	783600.0
2016-08-25	AAT	Stock	44.53	44.84	44.33	44.63	109500.0
2016-08-25	AAU-DELISTED	Stock	1.34	1.45	1.34	1.42	540604.0
2016-08-25	AAUAF-DELISTED	Stock	1.34	1.45	1.34	1.42	544678.0
2016-08-25	AAV-DELISTED	Stock	6.99	7.1	6.91	7.07	61819.0
2016-08-25	AAWW-DELISTED	Stock	35.47	35.47	34.95	35.22	248827.0
2016-08-25	AAXJ	Stock	58.98	59.155	58.9	59.13	646528.0
2016-08-25	AAXN-DELISTED	Stock	28.45	28.88	28.41	28.69	465315.0
2016-08-25	AB	Stock	21.72	22.0	21.72	21.86	164100.0
2016-08-25	ABAC-DELISTED	Stock	0.7751	0.85	0.7501	0.8086	160056.0
2016-08-25	ABAX-DELISTED	Stock	49.12	50.56	49.12	49.73	66593.0
2016-08-25	ABB-DELISTED	Stock	21.93	22.0	21.93	21.95	617769.0
2016-08-25	ABBNY-DELISTED	Stock	21.93	22.0	21.93	21.94	643640.0
2016-08-25	ABBV	Stock	65.04	65.43	64.27	64.72	6379000.0
2016-08-25	ABC-DELISTED	Stock	88.07	88.26	85.264	85.4	3029572.0
2016-08-25	ABCB	Stock	33.85	34.03	33.27	33.99	111600.0
2016-08-25	ABCD-DELISTED	Stock	4.69	4.72	4.6	4.61	1147.0
2016-08-25	ABCO-DELISTED	Stock	42.53	42.76	42.04	42.19	270345.0
2016-08-25	ABDC-DELISTED	Stock	12.49	12.58	12.47	12.52	29153.0
2016-08-25	ABE-DELISTED	Stock	12.67	12.7	12.67	12.67	1276.0
2016-08-25	ABEO	Stock	108.25	108.5	104.0	107.0	2652.0
2016-08-25	ABEOW-DELISTED	Stock	2.05	2.05	2.05	2.05	800.0
2016-08-25	ABEV	Stock	6.09	6.12	5.95	5.96	20654000.0
2016-08-25	ABG	Stock	52.68	53.31	52.47	53.01	145000.0
2016-08-25	ABIL-DELISTED	Stock	4.25	4.25	4.1	4.2	18685.0
2016-08-25	ABM	Stock	38.18	38.39	38.0	38.25	207700.0
2016-08-25	ABMD-DELISTED	Stock	117.0	119.19	116.21	116.97	245376.0

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

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