PREVIEW / etf_daily / 2015-01-02

all etf daily files

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

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-02	SPY	ETF	206.38	206.88	204.18	205.43	121465900.0
2015-01-02	QQQ	ETF	103.76	104.2	102.44	102.94	31314599.0
2015-01-02	IWM	ETF	120.07	120.56	117.89	118.93	46133100.0
2015-01-02	DIA	ETF	178.65	179.23	176.98	177.94	4997200.0
2015-01-02	GLD	ETF	112.49	114.8	112.32	114.08	7109600.0
2015-01-02	TLT	ETF	126.29	127.66	126.15	127.32	9432000.0
2015-01-02	AADR	ETF	37.25	37.25	36.64	36.64	2000.0
2015-01-02	AAXJ	ETF	61.17	61.17	60.49	60.63	509500.0
2015-01-02	ACWI	ETF	58.66	58.88	58.15	58.36	1424100.0
2015-01-02	ACWV	ETF	68.95	69.07	68.34	68.66	48600.0
2015-01-02	ACWX	ETF	43.17	43.17	42.6965	42.76	2486824.0
2015-01-02	ADRE	ETF	35.47	35.47	35.06	35.16	15088.0
2015-01-02	AFK	ETF	26.08	26.1999	25.94	26.05	51132.0
2015-01-02	AGG	ETF	110.18	110.5	110.18	110.43	2090200.0
2015-01-02	AGQ	ETF	37.68	39.77	37.33	38.42	324100.0
2015-01-02	AGZ	ETF	113.115	113.512	112.919	113.42	36695.0
2015-01-02	AGZD	ETF	24.655	24.66	24.555	24.645	4800.0
2015-01-02	AIA	ETF	47.05	47.05	46.6	46.77	63563.0
2015-01-02	AIQ	ETF	20.86	22.12	20.59	22.1	33469.0
2015-01-02	AIRR	ETF	18.28	18.33	18.002	18.19	12400.0
2015-01-02	AIVI	ETF	43.0	43.15	42.72	42.83	113400.0
2015-01-02	AMJ	ETF	45.75	47.06	45.75	46.92	1947856.0
2015-01-02	AMLP	ETF	87.65	88.9	87.6	88.3	1161360.0
2015-01-02	AMZA	ETF	232.61	234.8	232.61	234.49	220.0
2015-01-02	ANGL	ETF	25.97	25.97	25.97	25.97	400.0
2015-01-02	AOA	ETF	46.48	46.5	46.03	46.23	58500.0
2015-01-02	AOK	ETF	32.61	32.6421	32.52	32.62	57569.0
2015-01-02	AOM	ETF	35.29	35.29	35.0202	35.13	46376.0
2015-01-02	AOR	ETF	40.28	40.28	39.88	40.1	76206.0
2015-01-02	ARGT	ETF	18.59	18.61	18.51	18.59	21600.0
2015-01-02	ARKG	ETF	21.04	21.455	21.04	21.3	3700.0
2015-01-02	ARKK	ETF	21.0	21.0	19.96	20.17	5600.0
2015-01-02	ARKQ	ETF	19.797	19.797	19.52	19.64	1200.0
2015-01-02	ARKW	ETF	20.49	20.519	20.28	20.32	1000.0
2015-01-02	ASEA	ETF	15.78	15.78	15.59	15.64	2800.0
2015-01-02	ASHR	ETF	37.71	37.94	37.18	37.28	1060600.0
2015-01-02	ASHS	ETF	35.4	35.48	35.28	35.3	3000.0
2015-01-02	ATMP	ETF	30.7	31.04	30.65	30.99	10700.0
2015-01-02	AVIV	ETF	34.74	35.82	34.74	35.77	148909.0
2015-01-02	AWAY	ETF	29.9	29.995	28.7604	28.9	926827.0
2015-01-02	BAB	ETF	30.33	30.572	30.3101	30.55	180939.0
2015-01-02	BAL	ETF	40.91	41.0	40.56	40.5601	19719.0
2015-01-02	BALT	ETF	2.54	2.55	2.38	2.39	486186.0
2015-01-02	BAR	ETF	2.763	2.763	2.705	2.727	274580.0
2015-01-02	BBC	ETF	28.0	28.6299	27.75	28.4	15961.0
2015-01-02	BBH	ETF	116.06	117.71	115.71	116.44	137400.0
2015-01-02	BBP	ETF	26.79	26.79	26.132	26.48	6200.0
2015-01-02	BCHP	ETF	17.96	17.96	17.95	17.95	287.0
2015-01-02	BFOR	ETF	7.9075	7.9275	7.78	7.8325	71200.0
2015-01-02	BIB	ETF	63.92	65.125	62.7332	63.91	597208.0

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

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