PREVIEW / etf_daily / 2015-04-07

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-07.parquet
  size:    47 KB
  rows:    1,170

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
2015-04-07	SPY	ETF	207.86	208.76	207.24	207.28	81236300.0
2015-04-07	QQQ	ETF	105.92	106.7	105.8	105.8	19379381.0
2015-04-07	IWM	ETF	124.97	125.5	124.37	124.4	20214700.0
2015-04-07	DIA	ETF	178.77	179.58	178.42	178.42	6011600.0
2015-04-07	GLD	ETF	116.27	116.51	115.94	116.11	2468500.0
2015-04-07	TLT	ETF	130.23	131.22	129.85	131.09	4764900.0
2015-04-07	AADR	ETF	39.32	39.32	39.32	39.32	600.0
2015-04-07	AAXJ	ETF	65.8	65.93	65.62	65.62	512900.0
2015-04-07	ACWI	ETF	61.21	61.4	60.96	60.96	1233000.0
2015-04-07	ACWV	ETF	72.81	72.87	72.44	72.44	66200.0
2015-04-07	ACWX	ETF	45.9972	46.22	45.92	45.94	207313.0
2015-04-07	ADRE	ETF	35.79	36.0035	35.7801	35.8035	6146.0
2015-04-07	AFK	ETF	26.3	26.3	25.88	25.9	41506.0
2015-04-07	AFTY	ETF	20.444	20.46	20.35	20.37	17700.0
2015-04-07	AGG	ETF	111.45	111.57	111.28	111.52	1415200.0
2015-04-07	AGQ	ETF	42.91	42.91	42.36	42.84	105900.0
2015-04-07	AGZ	ETF	114.46	114.52	114.075	114.18	107090.0
2015-04-07	AGZD	ETF	24.495	24.515	24.445	24.515	4200.0
2015-04-07	AIA	ETF	51.09	51.12	50.94	50.98	32541.0
2015-04-07	AIQ	ETF	22.895	23.69	22.441	23.27	17382.0
2015-04-07	AIRR	ETF	19.11	19.221	19.09	19.09	12600.0
2015-04-07	AIVI	ETF	45.18	45.24	44.87	44.87	37900.0
2015-04-07	ALTL	ETF	37.91	37.93	37.88	37.89	8907.0
2015-04-07	AMJ	ETF	43.2	43.64	43.02	43.43	710824.0
2015-04-07	AMLP	ETF	83.25	83.7	82.95	83.45	658560.0
2015-04-07	AMZA	ETF	214.0	214.0	212.1	212.2	400.0
2015-04-07	ANGL	ETF	27.34	27.38	27.26	27.36	4200.0
2015-04-07	AOA	ETF	48.11	48.15	47.87	47.91	43500.0
2015-04-07	AOK	ETF	33.2	33.23	33.13	33.17	76643.0
2015-04-07	AOM	ETF	35.89	35.89	35.77	35.83	38835.0
2015-04-07	AOR	ETF	41.31	41.31	41.1	41.18	85075.0
2015-04-07	ARGT	ETF	21.62	21.78	21.55	21.76	8800.0
2015-04-07	ARKG	ETF	22.69	23.01	22.69	22.92	3200.0
2015-04-07	ARKK	ETF	21.06	21.07	20.96	20.96	2500.0
2015-04-07	ARKQ	ETF	20.3	20.3	20.182	20.182	4100.0
2015-04-07	ARKW	ETF	22.24	22.24	22.09	22.09	2600.0
2015-04-07	ASEA	ETF	16.1	16.1	16.04	16.06	4400.0
2015-04-07	ASHR	ETF	44.13	44.15	43.88	43.91	1546600.0
2015-04-07	ASHS	ETF	52.73	52.81	52.26	52.37	123200.0
2015-04-07	ATMP	ETF	29.37	29.57	29.35	29.54	51000.0
2015-04-07	AWAY	ETF	30.55	30.82	30.24	30.68	1324856.0
2015-04-07	BAB	ETF	30.5	30.5	30.28	30.46	82421.0
2015-04-07	BAL	ETF	44.74	45.26	44.385	45.07	7170.0
2015-04-07	BALT	ETF	1.59	1.68	1.57	1.62	247841.0
2015-04-07	BAR	ETF	2.802	2.8409	2.762	2.762	28330.0
2015-04-07	BBC	ETF	32.26	33.27	32.26	32.6464	15577.0
2015-04-07	BBH	ETF	127.93	130.56	127.89	128.56	310400.0
2015-04-07	BBP	ETF	31.5	32.03	31.5	31.673	18500.0
2015-04-07	BCHP	ETF	19.56	19.56	19.55	19.55	500.0
2015-04-07	BCM	ETF	31.15	31.4277	31.15	31.41	1325.0

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

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