PREVIEW / stock_daily / 2017-04-05

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-05.parquet
  size:    216 KB
  rows:    6,477
  symbols: 3,047

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-05	AAPL	Stock	36.055	36.365	35.9525	36.005	110871600.0
2017-04-05	MSFT	Stock	66.3	66.35	65.44	65.56	21448600.0
2017-04-05	NVDA	Stock	2.5005	2.5593	2.4875	2.5008	747048000.0
2017-04-05	AMZN	Stock	45.541	46.186	45.281	45.464	150168000.0
2017-04-05	GOOGL	Stock	42.7355	43.0295	42.376	42.4455	37103060.0
2017-04-05	META	Stock	142.26	143.44	141.29	141.85	17158100.0
2017-04-05	TSLA	Stock	20.136	20.3253	19.6133	19.6667	118213500.0
2017-04-05	TLT	Stock	120.56	121.52	120.36	121.38	8555235.0
2017-04-05	ES	Stock	58.74	59.48	58.63	59.41	1729200.0
2017-04-05	CL	Stock	73.55	74.05	73.31	73.46	3882300.0
2017-04-05	A	Stock	52.72	53.22	52.7	52.71	1778300.0
2017-04-05	AA	Stock	34.79	35.09	33.755	33.85	4016800.0
2017-04-05	AAAP-DELISTED	Stock	39.7	39.91	38.31	39.6	119522.0
2017-04-05	AABA-DELISTED	Stock	46.41	46.92	46.24	46.37	4288355.0
2017-04-05	AAC-DELISTED	Stock	8.39	8.53	8.11	8.19	94865.0
2017-04-05	AACG	Stock	4.03	4.03	3.73	3.86	15000.0
2017-04-05	AAIC-DELISTED	Stock	14.15	14.2	13.8999	13.94	441986.0
2017-04-05	AAL	Stock	41.15	42.13	41.06	41.31	7012700.0
2017-04-05	AAM.A-DELISTED	Stock	25.25	25.28	25.19	25.22	310499.0
2017-04-05	AAMC-DELISTED	Stock	19.8235	19.8235	18.7077	18.8235	34673.0
2017-04-05	AAME	Stock	3.95	3.95	3.81	3.85	1200.0
2017-04-05	AAMI	Stock	15.21	15.21	14.91	14.92	448000.0
2017-04-05	AAOI	Stock	51.3	51.55	44.54	44.68	6126900.0
2017-04-05	AAON	Stock	23.2667	23.6	22.7333	22.8	183300.0
2017-04-05	AAP	Stock	143.76	144.69	142.54	142.74	741500.0
2017-04-05	AAT	Stock	41.83	42.03	41.43	41.44	169800.0
2017-04-05	AAU-DELISTED	Stock	1.2	1.31	1.2	1.29	465775.0
2017-04-05	AAUAF-DELISTED	Stock	1.2	1.31	1.2	1.29	477685.0
2017-04-05	AAV-DELISTED	Stock	6.85	6.939	6.75	6.8	106168.0
2017-04-05	AAWW-DELISTED	Stock	54.4	54.75	53.15	53.55	101404.0
2017-04-05	AAXJ	Stock	63.49	63.68	63.22	63.28	1305652.0
2017-04-05	AAXN-DELISTED	Stock	23.35	23.393	21.18	21.9	9965356.0
2017-04-05	AB	Stock	22.55	22.85	22.45	22.45	308100.0
2017-04-05	ABAC-DELISTED	Stock	2.31	2.33	2.25	2.26	24676.0
2017-04-05	ABAX-DELISTED	Stock	47.68	48.115	46.86	47.3	113047.0
2017-04-05	ABB-DELISTED	Stock	23.28	23.44	23.055	23.075	2771847.0
2017-04-05	ABBNY-DELISTED	Stock	23.28	23.44	23.055	23.07	2976333.0
2017-04-05	ABBV	Stock	65.23	65.76	64.86	64.96	4396300.0
2017-04-05	ABC-DELISTED	Stock	87.44	88.26	86.99	87.17	1004932.0
2017-04-05	ABCB	Stock	45.75	46.0	44.15	44.2	210500.0
2017-04-05	ABCD-DELISTED	Stock	4.89	4.89	4.81	4.84	17369.0
2017-04-05	ABCO-DELISTED	Stock	46.7	47.15	46.45	46.8	249022.0
2017-04-05	ABDC-DELISTED	Stock	13.86	14.15	13.704	14.05	56612.0
2017-04-05	ABE-DELISTED	Stock	13.39	13.48	13.35	13.3869	7199.0
2017-04-05	ABEO	Stock	127.5	130.0	125.0	128.75	8752.0
2017-04-05	ABEV	Stock	5.79	5.82	5.68	5.72	15536900.0
2017-04-05	ABG	Stock	57.2	57.75	55.6	55.7	346000.0
2017-04-05	ABIL-DELISTED	Stock	1.78	1.79	1.76	1.7899	14428.0
2017-04-05	ABM	Stock	42.64	42.71	41.9	41.91	284400.0
2017-04-05	ABMD-DELISTED	Stock	124.75	125.31	123.28	123.385	250830.0

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

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