PREVIEW / stock_daily / 2016-03-03

all stock daily files

  file:    by_date/stock_daily/2016/2016-03-03.parquet
  size:    219 KB
  rows:    6,576
  symbols: 3,336

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-03-03	AAPL	Stock	25.145	25.4275	25.1125	25.375	147822800.0
2016-03-03	MSFT	Stock	52.97	52.97	51.78	52.35	24427800.0
2016-03-03	NVDA	Stock	0.8225	0.826	0.8052	0.8162	302004000.0
2016-03-03	AMZN	Stock	28.898	28.9935	28.6555	28.8745	54826000.0
2016-03-03	GOOGL	Stock	36.974	37.05	36.4815	36.5795	40534000.0
2016-03-03	META	Stock	110.25	110.3	108.54	109.58	21353100.0
2016-03-03	TSLA	Stock	12.552	13.1613	12.2813	13.0493	72435000.0
2016-03-03	TLT	Stock	129.07	129.94	128.77	129.43	6395336.0
2016-03-03	ES	Stock	54.44	54.66	53.59	54.63	1185200.0
2016-03-03	CL	Stock	66.86	67.61	66.71	67.61	2415000.0
2016-03-03	A	Stock	38.92	39.23	38.74	39.2	946800.0
2016-03-03	AA.B-DELISTED	Stock	32.34	32.5899	31.2001	32.13	16037.0
2016-03-03	AAAP-DELISTED	Stock	32.3	33.57	31.48	33.22	18468.0
2016-03-03	AABA-DELISTED	Stock	32.71	33.21	32.425	32.88	10658794.0
2016-03-03	AAC-DELISTED	Stock	19.86	20.54	19.66	19.92	180987.0
2016-03-03	AACG	Stock	4.94	5.4	4.61	4.68	4400.0
2016-03-03	AAIC-DELISTED	Stock	12.46	13.08	12.46	12.83	254892.0
2016-03-03	AAL	Stock	41.52	42.24	41.23	41.88	8812800.0
2016-03-03	AAMC-DELISTED	Stock	5.0059	5.1176	4.9324	4.9676	10523.0
2016-03-03	AAME	Stock	4.3	4.3	4.02	4.02	3600.0
2016-03-03	AAMI	Stock	11.73	11.91	11.7	11.87	76700.0
2016-03-03	AAOI	Stock	18.29	18.57	18.01	18.32	154600.0
2016-03-03	AAON	Stock	16.84	17.2	16.84	16.92	291300.0
2016-03-03	AAP	Stock	151.34	154.2	149.87	153.88	785300.0
2016-03-03	AAT	Stock	37.86	37.92	37.49	37.8	179300.0
2016-03-03	AAU-DELISTED	Stock	0.6901	0.79	0.6901	0.775	247669.0
2016-03-03	AAUAF-DELISTED	Stock	0.6901	0.79	0.6901	0.775	249251.0
2016-03-03	AAV-DELISTED	Stock	5.23	5.37	5.19	5.19	64232.0
2016-03-03	AAVL-DELISTED	Stock	5.59	5.82	5.3	5.34	498800.0
2016-03-03	AAWW-DELISTED	Stock	36.6	38.39	36.6	38.21	322865.0
2016-03-03	AAXJ	Stock	51.55	51.92	51.5099	51.85	478026.0
2016-03-03	AAXN-DELISTED	Stock	19.48	19.74	19.115	19.47	1128350.0
2016-03-03	AB	Stock	20.6	21.54	20.5	21.27	381100.0
2016-03-03	ABAC-DELISTED	Stock	0.635	0.635	0.635	0.635	1000.0
2016-03-03	ABAX-DELISTED	Stock	40.5	40.9	40.05	40.43	157923.0
2016-03-03	ABB-DELISTED	Stock	18.36	18.5	18.36	18.49	1184887.0
2016-03-03	ABBNY-DELISTED	Stock	18.36	18.51	18.36	18.51	1271484.0
2016-03-03	ABBV	Stock	55.69	56.09	55.15	55.93	9283900.0
2016-03-03	ABC-DELISTED	Stock	87.63	88.34	87.13	88.23	1724040.0
2016-03-03	ABCB	Stock	27.51	28.37	27.43	28.33	178600.0
2016-03-03	ABCD-DELISTED	Stock	4.66	4.989	4.554	4.67	54030.0
2016-03-03	ABCO-DELISTED	Stock	28.01	28.37	27.83	28.25	1077568.0
2016-03-03	ABCW-DELISTED	Stock	42.52	43.27	42.52	43.25	48478.0
2016-03-03	ABDC-DELISTED	Stock	10.21	10.21	10.0	10.13	14923.0
2016-03-03	ABE-DELISTED	Stock	10.8908	10.8908	10.8908	10.8908	851.0
2016-03-03	ABEO	Stock	57.0	62.25	54.75	58.75	3464.0
2016-03-03	ABEV	Stock	4.72	4.84	4.69	4.84	17030400.0
2016-03-03	ABG	Stock	59.35	60.92	59.12	60.45	770300.0
2016-03-03	ABGB-DELISTED	Stock	0.76	0.78	0.7347	0.7347	5394.0
2016-03-03	ABIL-DELISTED	Stock	6.56	6.89	6.43	6.89	9866.0

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

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