PREVIEW / stock_daily / 2017-03-09

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-09.parquet
  size:    214 KB
  rows:    6,473
  symbols: 3,065

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
2017-03-09	AAPL	Stock	34.685	34.6975	34.2625	34.67	88623600.0
2017-03-09	MSFT	Stock	65.19	65.2	64.48	64.73	19846800.0
2017-03-09	NVDA	Stock	2.4478	2.4862	2.435	2.4635	478060000.0
2017-03-09	AMZN	Stock	42.55	42.82	42.5155	42.65	40964000.0
2017-03-09	GOOGL	Stock	42.6845	43.0355	42.6335	42.892	26953940.0
2017-03-09	META	Stock	137.72	138.57	137.4	138.24	15535300.0
2017-03-09	TSLA	Stock	16.5087	16.5773	16.2	16.3267	58189500.0
2017-03-09	TLT	Stock	117.34	117.48	116.77	116.84	10575439.0
2017-03-09	ES	Stock	57.68	58.0	57.28	57.38	1025200.0
2017-03-09	CL	Stock	73.41	73.65	73.11	73.37	4049600.0
2017-03-09	A	Stock	51.42	51.58	51.13	51.43	1259400.0
2017-03-09	AA	Stock	36.07	36.55	34.89	35.36	4826200.0
2017-03-09	AAAP-DELISTED	Stock	38.0	38.7	37.8	38.09	95977.0
2017-03-09	AABA-DELISTED	Stock	45.87	46.12	45.68	45.94	3325816.0
2017-03-09	AAC-DELISTED	Stock	8.66	8.86	8.52	8.62	108295.0
2017-03-09	AACG	Stock	3.56	3.75	3.51	3.75	22100.0
2017-03-09	AAIC-DELISTED	Stock	13.52	13.8	13.5	13.51	371665.0
2017-03-09	AAL	Stock	44.5	44.93	43.25	43.33	9330100.0
2017-03-09	AAM.A-DELISTED	Stock	24.75	24.79	24.44	24.65	209007.0
2017-03-09	AAMC-DELISTED	Stock	21.8088	22.9559	21.7794	22.1765	20941.0
2017-03-09	AAME	Stock	3.75	3.75	3.75	3.75	400.0
2017-03-09	AAMI	Stock	14.98	15.15	14.98	15.04	316000.0
2017-03-09	AAOI	Stock	52.44	54.31	51.52	52.66	1019800.0
2017-03-09	AAON	Stock	23.2333	23.3867	23.1	23.3	223950.0
2017-03-09	AAP	Stock	154.97	155.48	154.21	155.15	1024600.0
2017-03-09	AAT	Stock	41.69	41.9	40.76	40.8	282600.0
2017-03-09	AAU-DELISTED	Stock	0.99	1.01	0.97	0.99	164338.0
2017-03-09	AAUAF-DELISTED	Stock	0.99	1.01	0.97	0.99	166294.0
2017-03-09	AAV-DELISTED	Stock	5.85	6.0	5.7	5.9	179229.0
2017-03-09	AAWW-DELISTED	Stock	53.95	55.05	53.55	54.2	77358.0
2017-03-09	AAXJ	Stock	60.14	60.2	59.77	60.1	571185.0
2017-03-09	AAXN-DELISTED	Stock	22.36	22.62	22.22	22.495	973919.0
2017-03-09	AB	Stock	23.1	23.2	22.75	22.8	263600.0
2017-03-09	ABAC-DELISTED	Stock	2.58	2.64	2.42	2.46	14959.0
2017-03-09	ABAX-DELISTED	Stock	49.05	49.34	48.54	48.87	58184.0
2017-03-09	ABB-DELISTED	Stock	22.32	22.39	22.24	22.37	1633653.0
2017-03-09	ABBNY-DELISTED	Stock	22.32	22.39	22.24	22.36	1683974.0
2017-03-09	ABBV	Stock	64.14	64.72	64.05	64.5	6957000.0
2017-03-09	ABC-DELISTED	Stock	89.4	89.4	88.08	88.6	945828.0
2017-03-09	ABCB	Stock	46.05	46.83	45.6	46.0	225600.0
2017-03-09	ABCD-DELISTED	Stock	4.83	4.91	4.68	4.7	14459.0
2017-03-09	ABCO-DELISTED	Stock	45.0	45.3	44.8	45.0	374631.0
2017-03-09	ABDC-DELISTED	Stock	12.54	12.7	12.4	12.66	52099.0
2017-03-09	ABE-DELISTED	Stock	12.14	12.14	11.98	12.06	111449.0
2017-03-09	ABEO	Stock	125.0	132.25	122.5	131.25	8404.0
2017-03-09	ABEV	Stock	5.39	5.45	5.36	5.37	31270100.0
2017-03-09	ABG	Stock	62.15	62.98	61.45	61.5	195300.0
2017-03-09	ABIL-DELISTED	Stock	2.29	2.29	2.25	2.25	3361.0
2017-03-09	ABM	Stock	42.71	43.82	42.17	42.35	666500.0
2017-03-09	ABMD-DELISTED	Stock	120.23	120.83	119.8	120.17	138009.0

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

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