PREVIEW / stock_daily / 2017-04-28

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-28.parquet
  size:    214 KB
  rows:    6,449
  symbols: 3,027

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-28	AAPL	Stock	36.0225	36.075	35.8175	35.9125	83441600.0
2017-04-28	MSFT	Stock	68.91	69.14	67.69	68.46	39548800.0
2017-04-28	NVDA	Stock	2.634	2.641	2.6018	2.6075	348248000.0
2017-04-28	AMZN	Stock	47.4415	47.4795	46.2165	46.2495	147294000.0
2017-04-28	GOOGL	Stock	46.45	46.795	46.161	46.226	76917140.0
2017-04-28	META	Stock	149.5	151.53	149.07	150.25	30652200.0
2017-04-28	TSLA	Stock	20.6553	20.9867	20.5333	20.938	67582500.0
2017-04-28	TLT	Stock	121.6	122.435	121.55	122.35	8166295.0
2017-04-28	ES	Stock	59.72	59.74	59.18	59.4	2029100.0
2017-04-28	CL	Stock	71.18	72.54	70.17	72.04	7466000.0
2017-04-28	A	Stock	55.31	55.35	54.84	55.05	3078200.0
2017-04-28	AA	Stock	34.81	34.945	33.68	33.73	5240000.0
2017-04-28	AAAP-DELISTED	Stock	37.62	38.48	37.58	37.89	50308.0
2017-04-28	AABA-DELISTED	Stock	48.36	48.5	48.16	48.205	4503213.0
2017-04-28	AAC-DELISTED	Stock	7.1	7.45	7.01	7.15	52872.0
2017-04-28	AACG	Stock	3.99	3.99	3.65	3.65	12300.0
2017-04-28	AAIC-DELISTED	Stock	14.67	14.79	14.52	14.56	340844.0
2017-04-28	AAL	Stock	44.02	44.06	42.56	42.62	13358000.0
2017-04-28	AAM.A-DELISTED	Stock	25.373	25.44	25.3612	25.43	82642.0
2017-04-28	AAMC-DELISTED	Stock	21.6294	22.9265	21.6294	22.4265	22702.0
2017-04-28	AAME	Stock	3.9	3.95	3.9	3.95	1000.0
2017-04-28	AAMI	Stock	15.65	15.67	15.49	15.56	190200.0
2017-04-28	AAOI	Stock	48.84	49.8	48.2	49.39	1383200.0
2017-04-28	AAON	Stock	24.8333	25.1	24.4	24.4333	180000.0
2017-04-28	AAP	Stock	142.97	142.97	140.12	142.14	1458400.0
2017-04-28	AAT	Stock	43.2	43.2	42.5	42.83	277700.0
2017-04-28	AAU-DELISTED	Stock	1.47	1.53	1.46	1.46	200737.0
2017-04-28	AAUAF-DELISTED	Stock	1.47	1.53	1.46	1.47	202368.0
2017-04-28	AAV-DELISTED	Stock	6.3	6.35	6.25	6.3	33472.0
2017-04-28	AAWW-DELISTED	Stock	57.3	59.05	57.0915	58.05	217366.0
2017-04-28	AAXJ	Stock	64.3	64.3	64.1	64.21	1659348.0
2017-04-28	AAXN-DELISTED	Stock	24.75	24.75	24.4374	24.58	516287.0
2017-04-28	AB	Stock	22.9	22.93	22.6	22.9	453700.0
2017-04-28	ABAC-DELISTED	Stock	1.76	1.77	1.65	1.665	9899.0
2017-04-28	ABAX-DELISTED	Stock	47.5	48.365	44.67	44.96	679287.0
2017-04-28	ABB-DELISTED	Stock	24.51	24.63	24.5	24.6	2535925.0
2017-04-28	ABBNY-DELISTED	Stock	24.51	24.63	24.5	24.6	2606989.0
2017-04-28	ABBV	Stock	66.06	66.32	65.44	65.94	5521100.0
2017-04-28	ABC-DELISTED	Stock	82.17	82.4	81.61	82.06	1280452.0
2017-04-28	ABCB	Stock	48.4	48.45	47.05	47.1	121000.0
2017-04-28	ABCD-DELISTED	Stock	4.9099	4.91	4.84	4.85	18934.0
2017-04-28	ABCO-DELISTED	Stock	49.25	51.675	49.25	51.1	1022946.0
2017-04-28	ABDC-DELISTED	Stock	13.85	14.0	13.72	13.93	40591.0
2017-04-28	ABE-DELISTED	Stock	13.53	13.6078	13.5199	13.6078	3620.0
2017-04-28	ABEO	Stock	140.0	143.25	135.0	141.25	8512.0
2017-04-28	ABEV	Stock	5.63	5.75	5.63	5.73	25685900.0
2017-04-28	ABG	Stock	63.15	63.3	61.0	61.2	339300.0
2017-04-28	ABIL-DELISTED	Stock	0.77	0.8099	0.76	0.8005	10478.0
2017-04-28	ABM	Stock	43.56	43.56	42.98	43.19	742700.0
2017-04-28	ABMD-DELISTED	Stock	131.26	131.68	129.8	130.29	182614.0

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

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