PREVIEW / stock_daily / 2016-09-08

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-08.parquet
  size:    218 KB
  rows:    6,539
  symbols: 3,227

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-09-08	AAPL	Stock	26.8125	26.8175	26.31	26.38	212008000.0
2016-09-08	MSFT	Stock	57.63	57.79	57.18	57.43	20146100.0
2016-09-08	NVDA	Stock	1.5533	1.5685	1.5355	1.566	315808000.0
2016-09-08	AMZN	Stock	39.1945	39.325	39.072	39.203	40610000.0
2016-09-08	GOOGL	Stock	40.261	40.421	40.0505	40.142	23553200.0
2016-09-08	META	Stock	130.92	131.08	129.81	130.27	15676600.0
2016-09-08	TSLA	Stock	13.3033	13.326	13.0907	13.1573	50668500.0
2016-09-08	TLT	Stock	138.86	139.27	137.26	137.79	14301465.0
2016-09-08	ES	Stock	54.73	55.12	54.63	55.01	1009700.0
2016-09-08	CL	Stock	73.73	73.75	72.94	72.99	3775400.0
2016-09-08	A	Stock	47.07	47.16	46.94	47.02	884700.0
2016-09-08	AA.B-DELISTED	Stock	34.76	34.8	34.18	34.38	37393.0
2016-09-08	AAAP-DELISTED	Stock	34.5	34.8	33.2401	34.64	38573.0
2016-09-08	AABA-DELISTED	Stock	44.07	44.72	44.03	44.34	6971166.0
2016-09-08	AAC-DELISTED	Stock	19.78	19.78	19.26	19.44	158237.0
2016-09-08	AACG	Stock	4.7	4.8	4.35	4.56	5100.0
2016-09-08	AAIC-DELISTED	Stock	15.18	15.37	15.1487	15.28	105638.0
2016-09-08	AAL	Stock	38.68	39.41	38.43	39.35	7101500.0
2016-09-08	AAMC-DELISTED	Stock	3.9146	3.9941	3.8529	3.8529	7174.0
2016-09-08	AAME	Stock	3.39	3.45	3.18	3.44	10600.0
2016-09-08	AAMI	Stock	13.53	13.6	13.31	13.55	121500.0
2016-09-08	AAOI	Stock	20.4	20.4	19.64	20.02	537300.0
2016-09-08	AAON	Stock	19.2	19.2	18.6	18.6867	142500.0
2016-09-08	AAP	Stock	160.67	161.14	157.21	158.87	1739200.0
2016-09-08	AAT	Stock	45.08	45.32	44.47	44.63	65800.0
2016-09-08	AAU-DELISTED	Stock	1.65	1.74	1.51	1.55	374752.0
2016-09-08	AAUAF-DELISTED	Stock	1.65	1.74	1.51	1.55	382205.0
2016-09-08	AAV-DELISTED	Stock	7.11	7.4	7.0401	7.31	86551.0
2016-09-08	AAWW-DELISTED	Stock	40.18	40.21	39.32	39.87	298311.0
2016-09-08	AAXJ	Stock	61.11	61.23	60.89	61.0	996080.0
2016-09-08	AAXN-DELISTED	Stock	25.98	26.24	25.76	25.86	721052.0
2016-09-08	AB	Stock	21.86	22.15	21.8	22.06	174100.0
2016-09-08	ABAC-DELISTED	Stock	0.61	0.61	0.5994	0.61	40626.0
2016-09-08	ABAX-DELISTED	Stock	49.29	49.59	49.29	49.35	82067.0
2016-09-08	ABB-DELISTED	Stock	22.62	22.78	22.61	22.65	1786350.0
2016-09-08	ABBNY-DELISTED	Stock	22.62	22.78	22.61	22.65	1836702.0
2016-09-08	ABBV	Stock	63.96	64.15	63.44	64.06	8238800.0
2016-09-08	ABC-DELISTED	Stock	87.47	87.67	87.14	87.28	1953407.0
2016-09-08	ABCB	Stock	35.8	35.85	35.58	35.78	139600.0
2016-09-08	ABCD-DELISTED	Stock	5.12	5.38	5.12	5.3601	16075.0
2016-09-08	ABCO-DELISTED	Stock	43.49	43.86	42.935	43.47	184336.0
2016-09-08	ABDC-DELISTED	Stock	12.84	12.94	12.7	12.79	64918.0
2016-09-08	ABE-DELISTED	Stock	12.7838	12.7838	12.73	12.73	2886.0
2016-09-08	ABEO	Stock	128.0	130.0	122.75	128.5	15792.0
2016-09-08	ABEOW-DELISTED	Stock	2.75	2.75	2.21	2.21	43100.0
2016-09-08	ABEV	Stock	6.23	6.25	6.14	6.24	21344600.0
2016-09-08	ABG	Stock	54.85	55.37	54.62	55.08	177000.0
2016-09-08	ABIL-DELISTED	Stock	4.05	4.05	3.95	3.99	9289.0
2016-09-08	ABM	Stock	40.0	40.47	38.69	40.42	779700.0
2016-09-08	ABMD-DELISTED	Stock	118.65	120.09	118.65	119.91	212601.0

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

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