PREVIEW / etf_daily / 2017-04-12

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-12.parquet
  size:    54 KB
  rows:    1,370

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-12	SPY	ETF	234.74	234.96	233.77	234.03	81864400.0
2017-04-12	QQQ	ETF	131.45	131.54	130.78	130.92	15955195.0
2017-04-12	IWM	ETF	136.64	136.7	134.92	135.04	25700800.0
2017-04-12	DIA	ETF	206.3	206.3	205.35	205.67	2181700.0
2017-04-12	GLD	ETF	121.38	122.22	121.14	122.02	9502500.0
2017-04-12	TLT	ETF	122.51	123.19	122.29	123.09	11532500.0
2017-04-12	AADR	ETF	46.24	46.24	45.78	46.08	26700.0
2017-04-12	AAXJ	ETF	62.86	62.87	62.57	62.86	745400.0
2017-04-12	ACSI	ETF	27.94	27.9575	27.89	27.92	700.0
2017-04-12	ACTX	ETF	106.496	109.151	104.5489	106.201	793.0
2017-04-12	ACWF	ETF	25.491	25.491	25.49	25.4901	400.0
2017-04-12	ACWI	ETF	63.11	63.12	62.86	63.01	1185600.0
2017-04-12	ACWV	ETF	77.36	77.56	77.3	77.53	141600.0
2017-04-12	ACWX	ETF	43.52	43.55	43.34	43.54	468817.0
2017-04-12	ADRE	ETF	36.4	36.47	36.2501	36.261	4754.0
2017-04-12	AFK	ETF	21.01	21.29	20.99	21.16	10446.0
2017-04-12	AFTY	ETF	13.82	13.82	13.78	13.82	7800.0
2017-04-12	AGG	ETF	108.93	109.2	108.89	109.13	2433000.0
2017-04-12	AGGY	ETF	50.149	50.26	50.117	50.26	14600.0
2017-04-12	AGQ	ETF	41.71	42.22	41.3	42.16	161400.0
2017-04-12	AGZ	ETF	113.39	113.65	113.381	113.53	22286.0
2017-04-12	AGZD	ETF	23.965	24.025	23.965	24.02	15000.0
2017-04-12	AIA	ETF	52.5	52.5	52.2265	52.41	17765.0
2017-04-12	AIQ	ETF	12.8	12.91	12.8	12.85	66230.0
2017-04-12	AIRR	ETF	24.08	24.08	23.5	23.56	49400.0
2017-04-12	AIVI	ETF	39.58	39.58	39.36	39.5	14400.0
2017-04-12	ALTY	ETF	15.52	15.52	15.495	15.495	1000.0
2017-04-12	AMJ	ETF	32.3	32.375	32.12	32.2	676055.0
2017-04-12	AMLP	ETF	63.7	63.75	63.3	63.35	1215240.0
2017-04-12	AMZA	ETF	106.5	106.5	105.5	105.7	53750.0
2017-04-12	ANGL	ETF	29.6	29.6	29.38	29.46	1046200.0
2017-04-12	AOA	ETF	49.75	49.75	49.55	49.64	85500.0
2017-04-12	AOK	ETF	33.3185	33.3899	33.27	33.3899	30859.0
2017-04-12	AOM	ETF	36.36	36.36	36.25	36.36	72055.0
2017-04-12	AOR	ETF	42.24	42.24	42.1	42.22	170554.0
2017-04-12	ARCM	ETF	100.0	100.0	100.0	100.0	3000.0
2017-04-12	ARGT	ETF	29.08	29.13	28.8	28.87	23800.0
2017-04-12	ARKG	ETF	20.06	20.06	20.06	20.06	200.0
2017-04-12	ARKK	ETF	24.07	24.07	23.816	23.816	2500.0
2017-04-12	ARKQ	ETF	24.9	24.9	24.519	24.519	5500.0
2017-04-12	ARKW	ETF	29.2	29.3	29.0	29.0	2700.0
2017-04-12	ASET	ETF	26.89	26.89	26.8204	26.8204	2254.0
2017-04-12	ASHR	ETF	25.36	25.43	25.32	25.4	387000.0
2017-04-12	ASHS	ETF	34.58	34.59	34.58	34.59	400.0
2017-04-12	ATMP	ETF	23.74	23.93	23.67	23.85	54000.0
2017-04-12	BAB	ETF	29.59	29.64	29.5195	29.64	59384.0
2017-04-12	BAL	ETF	48.59	48.6	48.38	48.38	1807.0
2017-04-12	BBC	ETF	21.72	21.76	21.51	21.57	4035.0
2017-04-12	BBH	ETF	117.96	118.47	117.61	118.15	23600.0
2017-04-12	BBP	ETF	36.63	36.64	36.34	36.44	1700.0

> showing 50 of 1,370 rows — these rows as CSV

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