PREVIEW / stock_daily / 2016-01-27

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-27.parquet
  size:    218 KB
  rows:    6,577
  symbols: 3,351

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-01-27	AAPL	Stock	24.01	24.1575	23.335	23.355	533478800.0
2016-01-27	MSFT	Stock	52.01	52.2	51.02	51.22	36775200.0
2016-01-27	NVDA	Stock	0.7165	0.7188	0.6955	0.709	231700000.0
2016-01-27	AMZN	Stock	30.0995	30.1695	28.939	29.1675	103058000.0
2016-01-27	GOOGL	Stock	36.7945	36.7945	35.6725	35.879	42428680.0
2016-01-27	META	Stock	97.79	97.85	94.23	94.45	58699400.0
2016-01-27	TSLA	Stock	12.8253	12.884	12.3847	12.538	54258000.0
2016-01-27	TLT	Stock	125.75	126.29	125.19	126.05	7957753.0
2016-01-27	ES	Stock	52.23	52.68	51.84	52.32	1753400.0
2016-01-27	CL	Stock	64.29	65.1	63.88	64.3	3265900.0
2016-01-27	A	Stock	37.39	37.92	36.81	37.05	1479400.0
2016-01-27	AA.B-DELISTED	Stock	25.41	26.2499	25.13	25.13	140084.0
2016-01-27	AAAP-DELISTED	Stock	25.0	25.355	23.81	24.75	26177.0
2016-01-27	AABA-DELISTED	Stock	29.91	30.53	29.445	29.7	12331009.0
2016-01-27	AAC-DELISTED	Stock	19.18	19.53	17.82	19.53	315057.0
2016-01-27	AACG	Stock	5.47	5.81	5.37	5.63	9700.0
2016-01-27	AAIC-DELISTED	Stock	10.83	11.08	10.7	10.81	168356.0
2016-01-27	AAL	Stock	40.15	40.87	39.48	39.69	10186000.0
2016-01-27	AAMC-DELISTED	Stock	4.9874	5.1173	4.4706	4.8088	260117.0
2016-01-27	AAME	Stock	4.39	4.39	4.03	4.27	1400.0
2016-01-27	AAMI	Stock	10.97	11.065	10.67	10.75	156400.0
2016-01-27	AAOI	Stock	15.47	16.39	15.245	16.28	542000.0
2016-01-27	AAON	Stock	13.8533	13.9333	13.54	13.6267	220650.0
2016-01-27	AAP	Stock	151.15	154.06	150.18	151.52	987900.0
2016-01-27	AAT	Stock	37.58	37.6	36.71	37.05	196500.0
2016-01-27	AAU-DELISTED	Stock	0.6024	0.633	0.5999	0.633	112960.0
2016-01-27	AAUAF-DELISTED	Stock	0.6024	0.64	0.5999	0.64	113714.0
2016-01-27	AAV-DELISTED	Stock	5.3	5.45	5.175	5.25	240060.0
2016-01-27	AAVL-DELISTED	Stock	6.48	6.59	6.16	6.3	247555.0
2016-01-27	AAWW-DELISTED	Stock	35.64	36.105	34.3817	34.66	197852.0
2016-01-27	AAXJ	Stock	48.31	48.73	47.78	48.01	1212998.0
2016-01-27	AAXN-DELISTED	Stock	15.63	15.73	15.12	15.15	697200.0
2016-01-27	AB	Stock	19.07	19.27	18.49	18.67	278300.0
2016-01-27	ABAX-DELISTED	Stock	52.26	52.46	50.92	51.44	192780.0
2016-01-27	ABB-DELISTED	Stock	16.66	17.16	16.66	16.89	3326859.0
2016-01-27	ABBNY-DELISTED	Stock	16.66	17.16	16.66	16.9	3393177.0
2016-01-27	ABBV	Stock	58.36	58.93	56.45	57.11	9077700.0
2016-01-27	ABC-DELISTED	Stock	91.29	91.52	89.73	90.18	2538930.0
2016-01-27	ABCB	Stock	27.12	27.88	26.91	27.59	445100.0
2016-01-27	ABCD-DELISTED	Stock	4.62	4.67	4.4	4.4499	36483.0
2016-01-27	ABCO-DELISTED	Stock	43.15	44.61	42.92	43.77	345407.0
2016-01-27	ABCW-DELISTED	Stock	41.25	42.09	40.93	41.29	178520.0
2016-01-27	ABDC-DELISTED	Stock	10.66	11.0857	10.31	10.69	14517.0
2016-01-27	ABE-DELISTED	Stock	10.01	10.101	9.95	9.98	6571.0
2016-01-27	ABEO	Stock	66.25	67.25	61.75	62.5	2244.0
2016-01-27	ABEV	Stock	4.2	4.37	4.18	4.33	22337000.0
2016-01-27	ABG	Stock	48.81	49.45	46.47	46.94	819700.0
2016-01-27	ABGB-DELISTED	Stock	0.94	1.01	0.9011	0.98	41270.0
2016-01-27	ABIL-DELISTED	Stock	9.48	9.5	9.36	9.44	155054.0
2016-01-27	ABM	Stock	29.26	29.57	29.05	29.14	403200.0

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

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