PREVIEW / stock_daily / 2017-06-26

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-26.parquet
  size:    215 KB
  rows:    6,465
  symbols: 3,002

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-26	AAPL	Stock	36.7925	37.07	36.345	36.455	102769600.0
2017-06-26	MSFT	Stock	71.4	71.71	70.44	70.53	19607000.0
2017-06-26	NVDA	Stock	3.879	3.915	3.7083	3.8038	1063960000.0
2017-06-26	AMZN	Stock	50.425	50.49	49.6	49.699	67724000.0
2017-06-26	GOOGL	Stock	49.5	49.6995	48.5165	48.6045	30358240.0
2017-06-26	META	Stock	156.25	156.5	153.2	153.59	18049700.0
2017-06-26	TSLA	Stock	25.7793	25.7967	24.8733	25.166	99061500.0
2017-06-26	TLT	Stock	128.27	128.57	128.16	128.26	5541628.0
2017-06-26	ES	Stock	62.41	62.84	62.12	62.66	1050300.0
2017-06-26	CL	Stock	76.15	76.19	75.81	75.89	1906700.0
2017-06-26	A	Stock	59.79	59.95	59.15	59.24	1535500.0
2017-06-26	AA	Stock	31.19	31.295	30.65	31.18	2936000.0
2017-06-26	AAAP-DELISTED	Stock	40.0	40.0	38.37	39.15	91212.0
2017-06-26	AABA-DELISTED	Stock	55.37	55.6	53.97	54.32	20698966.0
2017-06-26	AAC-DELISTED	Stock	7.01	7.25	6.99	7.08	48972.0
2017-06-26	AACG	Stock	4.82	4.84	4.72	4.82	4300.0
2017-06-26	AAIC-DELISTED	Stock	14.83	15.0	14.75	15.0	599978.0
2017-06-26	AAL	Stock	48.81	49.78	48.54	48.78	3992900.0
2017-06-26	AAM.A-DELISTED	Stock	25.9	25.94	25.85	25.94	62662.0
2017-06-26	AAMC-DELISTED	Stock	26.3382	26.7647	25.5882	26.7647	15997.0
2017-06-26	AAME	Stock	3.7	3.7	3.65	3.7	1000.0
2017-06-26	AAMI	Stock	14.8	14.97	14.65	14.95	560300.0
2017-06-26	AAOI	Stock	65.01	65.01	60.765	61.59	4653100.0
2017-06-26	AAON	Stock	24.1667	24.1667	23.8667	24.0333	112200.0
2017-06-26	AAP	Stock	120.06	124.62	120.06	121.79	1544400.0
2017-06-26	AAT	Stock	40.01	40.46	39.83	40.02	226800.0
2017-06-26	AAU-DELISTED	Stock	1.36	1.36	1.33	1.36	95507.0
2017-06-26	AAUAF-DELISTED	Stock	1.36	1.36	1.33	1.36	96631.0
2017-06-26	AAV-DELISTED	Stock	6.35	6.425	6.275	6.4	58962.0
2017-06-26	AAWW-DELISTED	Stock	51.2	52.025	50.8	51.7	239698.0
2017-06-26	AAXJ	Stock	68.48	68.61	68.225	68.41	255154.0
2017-06-26	AAXN-DELISTED	Stock	26.27	26.39	25.88	25.95	337039.0
2017-06-26	AB	Stock	23.65	23.95	23.5	23.6	324000.0
2017-06-26	ABAC-DELISTED	Stock	2.08	2.11	2.01	2.01	1900.0
2017-06-26	ABAX-DELISTED	Stock	52.6	53.15	52.271	52.94	60837.0
2017-06-26	ABB-DELISTED	Stock	25.47	25.565	25.36	25.365	1329783.0
2017-06-26	ABBNY-DELISTED	Stock	25.47	25.565	25.36	25.36	1365601.0
2017-06-26	ABBV	Stock	72.79	72.94	72.41	72.74	4019500.0
2017-06-26	ABC-DELISTED	Stock	96.2	96.72	95.63	95.96	988958.0
2017-06-26	ABCB	Stock	46.45	46.85	45.9	46.35	78500.0
2017-06-26	ABCD-DELISTED	Stock	5.08	5.09	4.9675	5.05	9032.0
2017-06-26	ABCO-DELISTED	Stock	51.35	51.6	49.95	51.1	342839.0
2017-06-26	ABDC-DELISTED	Stock	13.57	13.74	13.46	13.67	66420.0
2017-06-26	ABE-DELISTED	Stock	14.08	14.08	14.0452	14.08	1949.0
2017-06-26	ABEO	Stock	148.75	151.25	142.5	148.75	19812.0
2017-06-26	ABEV	Stock	5.45	5.54	5.44	5.49	37801900.0
2017-06-26	ABG	Stock	52.4	54.5	52.3	54.15	315300.0
2017-06-26	ABIL-DELISTED	Stock	1.26	1.56	1.24	1.38	1836214.0
2017-06-26	ABM	Stock	41.65	41.95	41.61	41.76	240600.0
2017-06-26	ABMD-DELISTED	Stock	144.49	145.4	142.59	142.78	219564.0

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

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