PREVIEW / stock_daily / 2017-06-27

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-27.parquet
  size:    215 KB
  rows:    6,462
  symbols: 2,988

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-06-27	AAPL	Stock	36.2525	36.54	35.905	35.9325	99047600.0
2017-06-27	MSFT	Stock	70.11	70.18	69.18	69.21	25215100.0
2017-06-27	NVDA	Stock	3.786	3.7948	3.6588	3.6645	999492000.0
2017-06-27	AMZN	Stock	49.5345	49.94	48.8	48.839	75648000.0
2017-06-27	GOOGL	Stock	48.08	48.361	47.3545	47.4045	48872040.0
2017-06-27	META	Stock	152.84	153.31	150.39	150.58	19360800.0
2017-06-27	TSLA	Stock	25.0933	25.0933	24.1347	24.158	104946000.0
2017-06-27	TLT	Stock	127.43	127.49	126.62	126.89	8354227.0
2017-06-27	ES	Stock	62.36	62.51	61.69	61.99	1779900.0
2017-06-27	CL	Stock	75.83	75.97	75.33	75.37	3541100.0
2017-06-27	A	Stock	59.13	59.57	58.84	58.88	1060300.0
2017-06-27	AA	Stock	31.6	32.5	31.49	31.63	5464800.0
2017-06-27	AAAP-DELISTED	Stock	38.5	39.0335	37.67	37.69	21520.0
2017-06-27	AABA-DELISTED	Stock	54.44	54.73	53.53	53.74	16478910.0
2017-06-27	AAC-DELISTED	Stock	7.07	7.21	6.86	6.9	29655.0
2017-06-27	AACG	Stock	4.82	4.82	4.82	4.82	200.0
2017-06-27	AAIC-DELISTED	Stock	15.03	15.03	14.7	14.71	1009511.0
2017-06-27	AAL	Stock	48.6	49.56	48.5	48.5	4264400.0
2017-06-27	AAM.A-DELISTED	Stock	25.94	25.94	25.67	25.7	222018.0
2017-06-27	AAMC-DELISTED	Stock	26.2353	26.6324	25.2941	25.8676	45261.0
2017-06-27	AAME	Stock	3.7	3.75	3.65	3.7	1500.0
2017-06-27	AAMI	Stock	15.0	15.1	14.875	14.98	530900.0
2017-06-27	AAOI	Stock	61.3	62.229	58.268	58.44	2748300.0
2017-06-27	AAON	Stock	24.0333	24.3333	23.7667	23.7667	160650.0
2017-06-27	AAP	Stock	121.39	123.3	121.29	121.96	1652600.0
2017-06-27	AAT	Stock	39.92	40.43	39.87	40.23	191900.0
2017-06-27	AAU-DELISTED	Stock	1.34	1.36	1.34	1.355	78182.0
2017-06-27	AAUAF-DELISTED	Stock	1.34	1.36	1.34	1.34	82507.0
2017-06-27	AAV-DELISTED	Stock	6.45	6.6	6.4	6.5	89888.0
2017-06-27	AAWW-DELISTED	Stock	51.65	52.0	50.9	50.9	224545.0
2017-06-27	AAXJ	Stock	68.09	68.19	67.73	67.73	655145.0
2017-06-27	AAXN-DELISTED	Stock	25.93	25.99	25.35	25.45	429687.0
2017-06-27	AB	Stock	23.55	23.76	23.25	23.25	269600.0
2017-06-27	ABAC-DELISTED	Stock	2.0376	2.13	2.02	2.0526	12651.0
2017-06-27	ABAX-DELISTED	Stock	52.94	53.37	52.65	53.08	89171.0
2017-06-27	ABB-DELISTED	Stock	25.5	25.51	25.25	25.31	1562032.0
2017-06-27	ABBNY-DELISTED	Stock	25.5	25.51	25.25	25.32	1610108.0
2017-06-27	ABBV	Stock	72.7	73.06	72.25	72.39	4490600.0
2017-06-27	ABC-DELISTED	Stock	95.83	96.7	95.1	95.54	1063373.0
2017-06-27	ABCB	Stock	46.6	47.4	46.35	47.05	134000.0
2017-06-27	ABCD-DELISTED	Stock	5.05	5.1	5.0	5.015	18856.0
2017-06-27	ABCO-DELISTED	Stock	51.1	51.9	50.85	51.5	133429.0
2017-06-27	ABDC-DELISTED	Stock	13.67	13.755	13.6	13.68	79647.0
2017-06-27	ABE-DELISTED	Stock	13.93	13.94	13.92	13.92	1925.0
2017-06-27	ABEO	Stock	150.0	160.0	145.0	155.0	16044.0
2017-06-27	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	103.0
2017-06-27	ABEV	Stock	5.45	5.51	5.4	5.46	41015700.0
2017-06-27	ABG	Stock	54.15	55.3	54.0	54.95	130500.0
2017-06-27	ABIL-DELISTED	Stock	1.44	1.53	1.27	1.3446	703986.0
2017-06-27	ABM	Stock	41.8	42.31	41.65	41.8	262400.0

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

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