PREVIEW / stock_daily / 2017-04-06

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-06.parquet
  size:    214 KB
  rows:    6,437
  symbols: 3,026

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-04-06	AAPL	Stock	36.0725	36.13	35.8625	35.915	84596000.0
2017-04-06	MSFT	Stock	65.6	66.06	65.48	65.73	18103500.0
2017-04-06	NVDA	Stock	2.506	2.5312	2.4603	2.519	635120000.0
2017-04-06	AMZN	Stock	45.69	45.8595	44.7245	44.914	126882000.0
2017-04-06	GOOGL	Stock	42.475	42.6795	42.2	42.2548	30671280.0
2017-04-06	META	Stock	142.11	142.22	140.91	141.17	15103400.0
2017-04-06	TSLA	Stock	19.792	20.1293	19.6067	19.9133	82809000.0
2017-04-06	TLT	Stock	121.24	121.41	120.52	121.2	6496995.0
2017-04-06	ES	Stock	59.22	59.57	58.87	59.54	1714000.0
2017-04-06	CL	Stock	73.4	73.7	72.96	73.13	4064700.0
2017-04-06	A	Stock	52.7	53.23	52.26	53.15	1548200.0
2017-04-06	AA	Stock	33.85	34.16	33.19	33.65	3626800.0
2017-04-06	AAAP-DELISTED	Stock	39.77	39.77	38.91	39.2	51234.0
2017-04-06	AABA-DELISTED	Stock	46.38	46.43	46.04	46.29	3896196.0
2017-04-06	AAC-DELISTED	Stock	8.2	8.44	8.15	8.43	112882.0
2017-04-06	AACG	Stock	3.81	3.97	3.81	3.85	47600.0
2017-04-06	AAIC-DELISTED	Stock	13.98	14.145	13.9	14.11	287749.0
2017-04-06	AAL	Stock	41.4	41.96	41.16	41.72	3627600.0
2017-04-06	AAM.A-DELISTED	Stock	25.2	25.28	25.11	25.27	136450.0
2017-04-06	AAMC-DELISTED	Stock	19.3971	19.3971	18.8941	19.0441	8044.0
2017-04-06	AAME	Stock	3.9	4.0	3.9	3.9	3200.0
2017-04-06	AAMI	Stock	15.0	15.21	14.96	15.12	328600.0
2017-04-06	AAOI	Stock	44.76	47.71	44.6	46.31	2988700.0
2017-04-06	AAON	Stock	22.8333	23.1667	22.7	22.9333	153300.0
2017-04-06	AAP	Stock	143.75	144.65	142.36	142.56	765100.0
2017-04-06	AAT	Stock	41.43	42.16	41.19	42.02	267500.0
2017-04-06	AAU-DELISTED	Stock	1.28	1.38	1.28	1.35	551272.0
2017-04-06	AAUAF-DELISTED	Stock	1.28	1.38	1.28	1.35	558846.0
2017-04-06	AAV-DELISTED	Stock	6.85	6.85	6.75	6.85	43243.0
2017-04-06	AAWW-DELISTED	Stock	53.5	54.2	53.4	54.0	129433.0
2017-04-06	AAXJ	Stock	63.3	63.3	63.06	63.22	412086.0
2017-04-06	AAXN-DELISTED	Stock	22.3	23.1	21.895	23.08	2078945.0
2017-04-06	AB	Stock	22.4	22.9	22.35	22.85	262400.0
2017-04-06	ABAC-DELISTED	Stock	2.2842	2.35	2.25	2.28	36530.0
2017-04-06	ABAX-DELISTED	Stock	47.35	47.39	46.63	47.34	54483.0
2017-04-06	ABB-DELISTED	Stock	23.39	23.44	23.29	23.32	1920848.0
2017-04-06	ABBNY-DELISTED	Stock	23.39	23.44	23.29	23.31	1963023.0
2017-04-06	ABBV	Stock	65.03	65.19	64.65	65.08	4628400.0
2017-04-06	ABC-DELISTED	Stock	87.26	87.69	86.85	87.63	1396670.0
2017-04-06	ABCB	Stock	44.2	46.15	43.9	44.7	119500.0
2017-04-06	ABCD-DELISTED	Stock	4.83	4.95	4.82	4.88	31571.0
2017-04-06	ABCO-DELISTED	Stock	46.9	47.05	46.55	47.05	286144.0
2017-04-06	ABDC-DELISTED	Stock	13.95	14.09	13.7972	14.03	55648.0
2017-04-06	ABE-DELISTED	Stock	13.32	13.5	13.32	13.415	13172.0
2017-04-06	ABEO	Stock	130.0	130.0	125.75	128.75	10152.0
2017-04-06	ABEOW-DELISTED	Stock	2.7	2.85	2.7	2.8159	3100.0
2017-04-06	ABEV	Stock	5.67	5.76	5.63	5.65	17067500.0
2017-04-06	ABG	Stock	56.0	58.45	55.9	58.4	420300.0
2017-04-06	ABIL-DELISTED	Stock	1.75	1.798	1.72	1.78	11037.0
2017-04-06	ABM	Stock	41.9	42.14	41.64	42.1	237800.0

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

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