PREVIEW / stock_daily / 2017-04-17

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-17.parquet
  size:    214 KB
  rows:    6,473
  symbols: 3,037

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-17	AAPL	Stock	35.37	35.47	35.2175	35.4575	66328400.0
2017-04-17	MSFT	Stock	65.04	65.49	65.01	65.48	16689300.0
2017-04-17	NVDA	Stock	2.4003	2.481	2.395	2.4808	497292000.0
2017-04-17	AMZN	Stock	44.375	45.119	44.375	45.0995	57094000.0
2017-04-17	GOOGL	Stock	42.069	42.782	42.0515	42.7565	20982500.0
2017-04-17	META	Stock	139.76	141.55	139.75	141.42	11519700.0
2017-04-17	TSLA	Stock	20.18	20.2667	19.912	20.096	62080500.0
2017-04-17	TLT	Stock	123.46	123.55	122.86	123.09	8015015.0
2017-04-17	ES	Stock	59.78	60.34	59.73	60.29	1513600.0
2017-04-17	CL	Stock	73.64	74.17	73.52	74.07	1949500.0
2017-04-17	A	Stock	52.63	53.71	52.43	53.46	1569200.0
2017-04-17	AA	Stock	31.17	31.79	30.97	31.31	4099700.0
2017-04-17	AAAP-DELISTED	Stock	37.63	37.97	37.07	37.605	20502.0
2017-04-17	AABA-DELISTED	Stock	47.02	47.42	46.92	47.39	3575654.0
2017-04-17	AAC-DELISTED	Stock	8.07	8.07	7.85	7.98	117587.0
2017-04-17	AACG	Stock	3.62	3.73	3.62	3.67	4700.0
2017-04-17	AAIC-DELISTED	Stock	14.02	14.24	14.02	14.2	334056.0
2017-04-17	AAL	Stock	43.47	44.25	43.36	44.23	4563200.0
2017-04-17	AAM.A-DELISTED	Stock	25.3	25.31	25.2165	25.26	120070.0
2017-04-17	AAMC-DELISTED	Stock	21.3907	22.0588	20.8824	21.6176	24184.0
2017-04-17	AAME	Stock	3.7	3.95	3.7	3.85	2700.0
2017-04-17	AAMI	Stock	14.68	14.96	14.65	14.96	118800.0
2017-04-17	AAOI	Stock	45.51	46.369	43.19	43.33	3987100.0
2017-04-17	AAON	Stock	22.7333	23.1333	22.6667	23.1	149100.0
2017-04-17	AAP	Stock	141.26	141.48	140.15	140.84	645900.0
2017-04-17	AAT	Stock	44.14	44.53	44.1	44.53	184800.0
2017-04-17	AAU-DELISTED	Stock	1.71	1.72	1.55	1.58	826553.0
2017-04-17	AAUAF-DELISTED	Stock	1.71	1.72	1.55	1.59	834269.0
2017-04-17	AAV-DELISTED	Stock	6.55	6.725	6.55	6.7	32594.0
2017-04-17	AAWW-DELISTED	Stock	54.25	55.0	53.6	54.95	56870.0
2017-04-17	AAXJ	Stock	62.85	63.11	62.78	63.11	326069.0
2017-04-17	AAXN-DELISTED	Stock	22.04	22.17	21.95	22.08	636985.0
2017-04-17	AB	Stock	23.1	23.15	22.95	23.05	278000.0
2017-04-17	ABAC-DELISTED	Stock	2.43	2.5101	2.28	2.35	44467.0
2017-04-17	ABAX-DELISTED	Stock	46.71	48.125	46.7	47.45	118262.0
2017-04-17	ABB-DELISTED	Stock	22.66	22.87	22.6	22.85	1498515.0
2017-04-17	ABBNY-DELISTED	Stock	22.6	22.87	22.6	22.85	1566429.0
2017-04-17	ABBV	Stock	64.79	64.97	64.06	64.31	4189500.0
2017-04-17	ABC-DELISTED	Stock	86.64	86.72	86.21	86.63	953994.0
2017-04-17	ABCB	Stock	43.35	43.9	42.65	43.85	131300.0
2017-04-17	ABCD-DELISTED	Stock	4.85	4.85	4.7181	4.78	10074.0
2017-04-17	ABCO-DELISTED	Stock	46.9	47.175	46.375	46.9	153471.0
2017-04-17	ABDC-DELISTED	Stock	14.39	14.55	14.29	14.32	60453.0
2017-04-17	ABE-DELISTED	Stock	13.32	13.4899	13.32	13.475	11701.0
2017-04-17	ABEO	Stock	123.75	123.75	120.0	123.75	5376.0
2017-04-17	ABEV	Stock	5.68	5.81	5.67	5.8	12745300.0
2017-04-17	ABG	Stock	57.65	58.75	57.5	58.65	213000.0
2017-04-17	ABIL-DELISTED	Stock	1.23	1.302	1.09	1.18	37491.0
2017-04-17	ABM	Stock	41.99	42.21	41.9	42.21	251300.0
2017-04-17	ABMD-DELISTED	Stock	122.0	122.0	119.13	120.75	504324.0

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

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