PREVIEW / stock_daily / 2017-03-28

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-28.parquet
  size:    215 KB
  rows:    6,478
  symbols: 3,060

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-28	AAPL	Stock	35.2275	36.01	35.155	35.95	133499200.0
2017-03-28	MSFT	Stock	64.96	65.47	64.65	65.29	20080400.0
2017-03-28	NVDA	Stock	2.7075	2.7223	2.6818	2.6922	432444000.0
2017-03-28	AMZN	Stock	42.5875	42.923	42.505	42.8	60832000.0
2017-03-28	GOOGL	Stock	41.9845	42.27	41.6132	42.0315	30384040.0
2017-03-28	META	Stock	140.36	141.95	140.01	141.76	14679400.0
2017-03-28	TSLA	Stock	18.468	18.712	18.3333	18.4967	119814000.0
2017-03-28	TLT	Stock	121.79	121.82	120.4947	120.62	6811244.0
2017-03-28	ES	Stock	59.51	59.73	59.24	59.49	1749700.0
2017-03-28	CL	Stock	73.22	74.03	73.09	73.77	3605200.0
2017-03-28	A	Stock	53.29	53.61	53.1	53.44	1312700.0
2017-03-28	AA	Stock	32.5	33.637	32.45	32.92	4039700.0
2017-03-28	AAAP-DELISTED	Stock	39.2	39.6	38.8	39.37	275444.0
2017-03-28	AABA-DELISTED	Stock	46.33	46.76	46.24	46.57	4337807.0
2017-03-28	AAC-DELISTED	Stock	8.37	8.51	8.13	8.28	98353.0
2017-03-28	AACG	Stock	3.91	3.94	3.9	3.94	1000.0
2017-03-28	AAIC-DELISTED	Stock	14.6	14.85	14.5	14.63	783758.0
2017-03-28	AAL	Stock	41.83	42.93	41.55	42.6	6185800.0
2017-03-28	AAM.A-DELISTED	Stock	25.14	25.19	25.13	25.15	181032.0
2017-03-28	AAMC-DELISTED	Stock	17.8676	20.425	17.8676	19.9853	173618.0
2017-03-28	AAME	Stock	3.8	3.85	3.7	3.7	800.0
2017-03-28	AAMI	Stock	14.86	15.1	14.75	15.06	267400.0
2017-03-28	AAOI	Stock	60.02	60.09	57.12	58.56	2109400.0
2017-03-28	AAON	Stock	23.2667	23.46	23.1333	23.2	285000.0
2017-03-28	AAP	Stock	147.19	148.88	146.36	148.36	1118600.0
2017-03-28	AAT	Stock	41.41	41.47	41.11	41.29	303200.0
2017-03-28	AAU-DELISTED	Stock	1.1	1.11	1.05	1.07	186103.0
2017-03-28	AAUAF-DELISTED	Stock	1.1	1.11	1.05	1.07	190220.0
2017-03-28	AAV-DELISTED	Stock	6.35	6.5	6.325	6.45	49275.0
2017-03-28	AAWW-DELISTED	Stock	51.6	53.75	51.6	53.35	139734.0
2017-03-28	AAXJ	Stock	63.17	63.62	63.17	63.5	1002985.0
2017-03-28	AAXN-DELISTED	Stock	22.43	22.82	22.25	22.79	561072.0
2017-03-28	AB	Stock	21.6	22.2	21.55	21.95	388400.0
2017-03-28	ABAC-DELISTED	Stock	2.475	2.5	2.36	2.36	21470.0
2017-03-28	ABAX-DELISTED	Stock	48.14	48.5	47.67	48.21	81054.0
2017-03-28	ABB-DELISTED	Stock	23.4	23.54	23.38	23.4364	1252683.0
2017-03-28	ABBNY-DELISTED	Stock	23.4	23.54	23.38	23.44	1384735.0
2017-03-28	ABBV	Stock	65.96	66.21	65.64	65.98	5067400.0
2017-03-28	ABC-DELISTED	Stock	87.12	87.97	87.12	87.49	973146.0
2017-03-28	ABCB	Stock	44.35	45.1	44.05	44.85	196500.0
2017-03-28	ABCD-DELISTED	Stock	5.04	5.24	4.91	5.0201	22188.0
2017-03-28	ABCO-DELISTED	Stock	46.9	47.1	46.35	46.9	290249.0
2017-03-28	ABDC-DELISTED	Stock	14.0	14.23	13.91	13.97	83654.0
2017-03-28	ABE-DELISTED	Stock	12.67	12.96	12.67	12.9393	34673.0
2017-03-28	ABEO	Stock	120.0	122.5	118.5	121.25	5968.0
2017-03-28	ABEOW-DELISTED	Stock	1.81	2.95	1.81	2.95	200.0
2017-03-28	ABEV	Stock	5.65	5.69	5.63	5.67	9531400.0
2017-03-28	ABG	Stock	61.2	62.4	60.7	62.05	207400.0
2017-03-28	ABIL-DELISTED	Stock	2.11	2.1872	1.95	2.1783	14543.0
2017-03-28	ABM	Stock	43.19	43.32	42.87	43.15	352300.0

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

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