PREVIEW / etf_daily / 2015-01-06

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-06.parquet
  size:    47 KB
  rows:    1,166

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-01-06	SPY	ETF	202.09	202.72	198.86	199.82	209151400.0
2015-01-06	QQQ	ETF	101.58	101.75	99.62	100.07	66205451.0
2015-01-06	IWM	ETF	117.62	117.77	114.36	115.31	67446000.0
2015-01-06	DIA	ETF	175.1	175.54	172.32	173.39	10131400.0
2015-01-06	GLD	ETF	116.22	117.5	115.8	117.12	11238300.0
2015-01-06	TLT	ETF	130.7	132.49	130.19	131.65	18331300.0
2015-01-06	AADR	ETF	35.57	35.89	35.56	35.89	600.0
2015-01-06	AAXJ	ETF	59.6	59.84	59.04	59.32	725900.0
2015-01-06	ACWI	ETF	57.2	57.43	56.4	56.62	5221500.0
2015-01-06	ACWV	ETF	68.01	68.44	67.58	67.75	73000.0
2015-01-06	ACWX	ETF	41.82	41.92	41.2414	41.4	520768.0
2015-01-06	ADRE	ETF	34.51	34.54	34.11	34.48	7264.0
2015-01-06	AFK	ETF	25.56	25.977	25.56	25.67	18505.0
2015-01-06	AGG	ETF	110.96	111.35	110.89	110.95	3688100.0
2015-01-06	AGQ	ETF	40.89	42.97	40.6	42.1	324600.0
2015-01-06	AGZ	ETF	113.81	114.06	113.3801	113.85	40983.0
2015-01-06	AGZD	ETF	24.615	24.635	24.51	24.51	4400.0
2015-01-06	AIA	ETF	45.91	46.04	45.5401	45.72	33428.0
2015-01-06	AIQ	ETF	21.22	21.22	19.8	20.46	27524.0
2015-01-06	AIRR	ETF	17.81	17.81	17.26	17.44	59900.0
2015-01-06	AIVI	ETF	41.56	41.78	41.06	41.32	21600.0
2015-01-06	ALTL	ETF	37.0	37.0	37.0	37.0	163.0
2015-01-06	AMJ	ETF	44.49	45.15	43.0	43.89	2896647.0
2015-01-06	AMLP	ETF	85.85	86.3	83.7	84.75	1447280.0
2015-01-06	AMZA	ETF	216.7	216.7	206.4	210.5	570.0
2015-01-06	ANGL	ETF	26.28	26.28	26.05	26.05	1700.0
2015-01-06	AOA	ETF	45.61	45.65	45.0	45.19	50900.0
2015-01-06	AOK	ETF	32.47	32.47	32.2858	32.32	27120.0
2015-01-06	AOM	ETF	34.83	34.89	34.64	34.65	82761.0
2015-01-06	AOR	ETF	39.68	39.75	39.3087	39.39	70953.0
2015-01-06	ARGT	ETF	17.97	18.06	17.92	17.99	5800.0
2015-01-06	ARKG	ETF	21.3	21.3	20.868	20.985	6600.0
2015-01-06	ARKK	ETF	19.79	19.79	19.36	19.61	3300.0
2015-01-06	ARKQ	ETF	19.14	19.15	18.7	18.916	3000.0
2015-01-06	ARKW	ETF	20.16	20.16	19.81	19.834	2000.0
2015-01-06	ASEA	ETF	15.24	15.25	15.16	15.18	14300.0
2015-01-06	ASHR	ETF	37.88	38.0	37.49	37.58	1291600.0
2015-01-06	ASHS	ETF	36.05	36.19	35.78	35.95	23800.0
2015-01-06	ATMP	ETF	30.51	30.51	28.8	29.25	68300.0
2015-01-06	AVIV	ETF	36.47	37.2	36.4	37.15	504312.0
2015-01-06	AWAY	ETF	27.4	27.48	26.35	26.78	2322659.0
2015-01-06	BAB	ETF	30.81	30.9996	30.7401	30.96	204878.0
2015-01-06	BAL	ETF	41.44	41.5499	40.912	41.0399	3332.0
2015-01-06	BALT	ETF	2.38	2.38	2.11	2.24	674634.0
2015-01-06	BAR	ETF	2.9	2.981	2.895	2.944	36850.0
2015-01-06	BBC	ETF	28.58	28.92	27.46	27.72	17055.0
2015-01-06	BBH	ETF	117.05	117.72	113.87	114.7	324900.0
2015-01-06	BBP	ETF	27.17	27.17	25.74	26.08	6500.0
2015-01-06	BCHP	ETF	17.5	17.5	17.5	17.5	110.0
2015-01-06	BCM	ETF	31.57	31.6	31.54	31.6	2793.0

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

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