PREVIEW / stock_daily / 2017-03-27

all stock daily files

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

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-27	AAPL	Stock	34.8475	35.305	34.655	35.22	94300400.0
2017-03-27	MSFT	Stock	64.63	65.22	64.35	65.1	18614700.0
2017-03-27	NVDA	Stock	2.6395	2.7103	2.5895	2.7063	506644000.0
2017-03-27	AMZN	Stock	41.9035	42.515	41.675	42.341	55116000.0
2017-03-27	GOOGL	Stock	41.4045	42.069	41.215	41.9255	38704220.0
2017-03-27	META	Stock	139.05	140.65	138.77	140.32	12800500.0
2017-03-27	TSLA	Stock	17.3733	18.038	17.3167	18.0147	93462000.0
2017-03-27	TLT	Stock	121.83	121.97	121.19	121.43	6878473.0
2017-03-27	ES	Stock	60.26	60.36	59.29	59.55	1370500.0
2017-03-27	CL	Stock	73.41	73.74	73.03	73.43	3052400.0
2017-03-27	A	Stock	52.6	53.34	52.42	53.24	1446500.0
2017-03-27	AA	Stock	31.74	32.57	31.29	32.47	3654000.0
2017-03-27	AAAP-DELISTED	Stock	38.68	39.48	38.68	39.18	132875.0
2017-03-27	AABA-DELISTED	Stock	45.92	46.48	45.74	46.4	5701186.0
2017-03-27	AAC-DELISTED	Stock	7.99	8.55	7.92	8.43	110461.0
2017-03-27	AACG	Stock	3.88	4.06	3.75	3.81	17400.0
2017-03-27	AAIC-DELISTED	Stock	14.44	14.64	14.37	14.55	597022.0
2017-03-27	AAL	Stock	41.07	41.89	40.56	41.74	6050500.0
2017-03-27	AAM.A-DELISTED	Stock	25.03	25.11	24.97	25.1	234136.0
2017-03-27	AAMC-DELISTED	Stock	17.0853	18.2941	17.0853	18.0882	26608.0
2017-03-27	AAME	Stock	3.75	3.75	3.75	3.75	500.0
2017-03-27	AAMI	Stock	14.34	15.0	14.28	14.95	991400.0
2017-03-27	AAOI	Stock	53.84	60.19	52.57	59.88	3697700.0
2017-03-27	AAON	Stock	23.8	23.9333	23.3333	23.3667	257550.0
2017-03-27	AAP	Stock	148.5	148.77	146.18	147.8	769900.0
2017-03-27	AAT	Stock	41.61	42.08	41.18	41.38	221700.0
2017-03-27	AAU-DELISTED	Stock	1.14	1.15	1.1	1.11	152699.0
2017-03-27	AAUAF-DELISTED	Stock	1.14	1.15	1.1	1.11	153278.0
2017-03-27	AAV-DELISTED	Stock	6.1	6.45	6.1	6.4	141079.0
2017-03-27	AAWW-DELISTED	Stock	50.75	52.05	50.15	51.8	123796.0
2017-03-27	AAXJ	Stock	63.1	63.36	62.895	63.33	948668.0
2017-03-27	AAXN-DELISTED	Stock	22.22	22.575	22.05	22.48	416415.0
2017-03-27	AB	Stock	21.7	21.7	21.35	21.6	390700.0
2017-03-27	ABAC-DELISTED	Stock	2.42	2.59	2.3816	2.46	11808.0
2017-03-27	ABAX-DELISTED	Stock	47.56	48.43	47.3311	48.23	68691.0
2017-03-27	ABB-DELISTED	Stock	23.2	23.4	23.11	23.36	2312297.0
2017-03-27	ABBNY-DELISTED	Stock	23.2	23.4	23.11	23.37	2416774.0
2017-03-27	ABBV	Stock	65.37	66.28	65.24	66.1	4962300.0
2017-03-27	ABC-DELISTED	Stock	86.14	87.545	86.12	87.48	1337990.0
2017-03-27	ABCB	Stock	43.6	44.7	42.95	44.65	238200.0
2017-03-27	ABCD-DELISTED	Stock	5.06	5.09	4.965	5.0501	12978.0
2017-03-27	ABCO-DELISTED	Stock	45.55	47.025	45.1	46.8	1036762.0
2017-03-27	ABDC-DELISTED	Stock	13.86	14.0	13.54	14.0	100972.0
2017-03-27	ABE-DELISTED	Stock	12.55	12.72	12.5498	12.72	9123.0
2017-03-27	ABEO	Stock	120.0	124.0	117.5	121.25	10808.0
2017-03-27	ABEOW-DELISTED	Stock	2.95	2.95	2.95	2.95	100.0
2017-03-27	ABEV	Stock	5.56	5.64	5.55	5.63	12478200.0
2017-03-27	ABG	Stock	60.3	61.35	60.0	61.3	385800.0
2017-03-27	ABIL-DELISTED	Stock	2.2	2.31	2.13	2.25	20378.0
2017-03-27	ABM	Stock	42.97	43.41	42.59	43.31	265600.0

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

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