PREVIEW / etf_daily / 2015-03-12

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-12.parquet
  size:    47 KB
  rows:    1,165

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-03-12	SPY	ETF	205.26	207.18	205.2	207.1	93993500.0
2015-03-12	QQQ	ETF	105.03	105.92	104.96	105.8	21473171.0
2015-03-12	IWM	ETF	121.82	123.15	121.74	123.05	41063300.0
2015-03-12	DIA	ETF	177.24	179.02	177.2	178.97	4024300.0
2015-03-12	GLD	ETF	111.15	111.2	110.25	110.72	6631500.0
2015-03-12	TLT	ETF	128.2	128.2	126.72	127.11	10295900.0
2015-03-12	AADR	ETF	38.09	38.09	38.09	38.09	200.0
2015-03-12	AAXJ	ETF	62.1	62.29	62.0	62.05	1025400.0
2015-03-12	ACWI	ETF	59.21	59.51	59.2	59.5	626600.0
2015-03-12	ACWV	ETF	70.36	70.76	70.34	70.7	186100.0
2015-03-12	ACWX	ETF	43.92	43.9338	43.72	43.86	150066.0
2015-03-12	ADRE	ETF	34.29	34.42	34.1301	34.16	9670.0
2015-03-12	AFK	ETF	24.9	25.0699	24.89	24.9	57262.0
2015-03-12	AFTY	ETF	17.72	17.72	17.66	17.66	17500.0
2015-03-12	AGG	ETF	110.69	110.72	110.42	110.55	1416600.0
2015-03-12	AGQ	ETF	37.04	37.06	36.3	36.79	131000.0
2015-03-12	AGZ	ETF	113.97	113.97	113.56	113.7	20767.0
2015-03-12	AGZD	ETF	24.58	24.635	24.51	24.56	8000.0
2015-03-12	AIA	ETF	48.36	48.41	48.291	48.41	40760.0
2015-03-12	AIQ	ETF	22.63	23.58	22.63	23.56	14389.0
2015-03-12	AIRR	ETF	18.01	18.312	18.01	18.29	26900.0
2015-03-12	AIVI	ETF	43.46	43.52	43.3	43.44	22700.0
2015-03-12	ALTL	ETF	37.01	37.26	37.0	37.26	9123.0
2015-03-12	AMJ	ETF	42.36	43.14	41.93	42.05	1227477.0
2015-03-12	AMLP	ETF	81.9	82.1	81.35	81.35	905260.0
2015-03-12	AMZA	ETF	208.7	208.7	206.5	206.5	210.0
2015-03-12	ANGL	ETF	27.26	27.39	27.24	27.24	2300.0
2015-03-12	AOA	ETF	46.63	47.04	46.63	47.04	56300.0
2015-03-12	AOK	ETF	32.7	32.7	32.5933	32.66	46825.0
2015-03-12	AOM	ETF	35.15	35.361	35.15	35.31	49346.0
2015-03-12	AOR	ETF	40.36	40.49	40.36	40.49	187459.0
2015-03-12	ARGT	ETF	20.5	20.75	20.5	20.55	22400.0
2015-03-12	ARKG	ETF	22.84	23.03	22.84	23.02	3300.0
2015-03-12	ARKK	ETF	20.68	20.68	20.68	20.68	200.0
2015-03-12	ARKQ	ETF	20.04	20.4	19.91	19.98	2500.0
2015-03-12	ARKW	ETF	21.65	21.65	21.65	21.65	200.0
2015-03-12	ASEA	ETF	15.3	15.3	15.19	15.21	46000.0
2015-03-12	ASHR	ETF	36.68	36.73	36.56	36.64	569200.0
2015-03-12	ASHS	ETF	41.43	41.43	41.3	41.36	5800.0
2015-03-12	ATMP	ETF	28.38	28.5	28.38	28.44	110900.0
2015-03-12	AVIV	ETF	35.2	35.72	35.18	35.48	288889.0
2015-03-12	AWAY	ETF	30.39	30.73	30.3	30.39	1413717.0
2015-03-12	BAB	ETF	30.2	30.25	29.9503	30.0	111976.0
2015-03-12	BAL	ETF	41.18	41.81	40.94	41.34	9059.0
2015-03-12	BALT	ETF	1.4	1.48	1.38	1.44	389063.0
2015-03-12	BAR	ETF	2.465	2.478	2.465	2.478	6750.0
2015-03-12	BBC	ETF	33.69	33.73	32.9	33.3999	23036.0
2015-03-12	BBH	ETF	129.5	130.0	128.77	129.95	63400.0
2015-03-12	BBP	ETF	31.25	31.25	30.83	31.13	8500.0
2015-03-12	BCHP	ETF	18.91	18.91	18.805	18.805	1000.0

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

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