PREVIEW / etf_daily / 2015-04-01

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-01.parquet
  size:    48 KB
  rows:    1,175

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-01	SPY	ETF	206.39	206.42	204.51	205.7	137303600.0
2015-04-01	QQQ	ETF	105.6	105.62	104.37	105.05	32970452.0
2015-04-01	IWM	ETF	124.23	124.42	122.9	124.42	31955200.0
2015-04-01	DIA	ETF	177.54	177.54	175.57	176.74	7440500.0
2015-04-01	GLD	ETF	114.56	115.99	114.54	115.6	7324000.0
2015-04-01	TLT	ETF	131.33	132.48	131.3	132.13	9273900.0
2015-04-01	AADR	ETF	38.53	38.53	38.37	38.37	10800.0
2015-04-01	AAXJ	ETF	64.4	64.64	64.29	64.62	1206000.0
2015-04-01	ACWI	ETF	60.12	60.38	59.79	60.2	4228000.0
2015-04-01	ACWV	ETF	71.61	71.72	71.3	71.7	78300.0
2015-04-01	ACWX	ETF	44.96	45.07	44.79	45.07	269481.0
2015-04-01	ADRE	ETF	34.98	35.266	34.98	35.2	4063.0
2015-04-01	AFK	ETF	25.31	26.09	25.31	26.04	69087.0
2015-04-01	AFTY	ETF	19.91	19.91	19.82	19.86	76400.0
2015-04-01	AGG	ETF	111.42	111.63	111.31	111.58	1927300.0
2015-04-01	AGQ	ETF	42.02	43.88	42.02	43.29	164700.0
2015-04-01	AGZ	ETF	114.51	114.56	114.155	114.44	33164.0
2015-04-01	AGZD	ETF	24.42	24.645	24.42	24.645	3800.0
2015-04-01	AIA	ETF	50.21	50.21	50.1	50.21	23293.0
2015-04-01	AIQ	ETF	22.09	22.68	21.9	22.53	20984.0
2015-04-01	AIRR	ETF	19.03	19.076	18.89	18.954	10000.0
2015-04-01	AIVI	ETF	44.08	44.13	43.89	44.07	47900.0
2015-04-01	ALTL	ETF	37.46	37.46	37.46	37.46	320.0
2015-04-01	AMJ	ETF	42.87	43.295	42.78	42.83	1000875.0
2015-04-01	AMLP	ETF	83.05	83.5	82.7	82.75	586680.0
2015-04-01	AMZA	ETF	217.7	217.7	214.0	214.0	520.0
2015-04-01	ANGL	ETF	27.47	27.47	27.25	27.29	7100.0
2015-04-01	AOA	ETF	48.0	48.0	47.37	47.53	22600.0
2015-04-01	AOK	ETF	33.04	33.0634	32.601	33.06	19670.0
2015-04-01	AOM	ETF	35.79	35.79	35.6572	35.74	53893.0
2015-04-01	AOR	ETF	40.86	41.06	40.81	40.97	69959.0
2015-04-01	ARGT	ETF	20.9	21.11	20.86	21.09	8800.0
2015-04-01	ARKG	ETF	22.5	22.5	22.19	22.42	3000.0
2015-04-01	ARKK	ETF	20.5	20.5	20.5	20.5	1000.0
2015-04-01	ARKQ	ETF	19.74	19.78	19.7	19.78	500.0
2015-04-01	ARKW	ETF	22.17	22.17	21.6	21.63	2700.0
2015-04-01	ASEA	ETF	15.71	15.79	15.71	15.79	2800.0
2015-04-01	ASHR	ETF	42.75	42.8	42.44	42.7	789700.0
2015-04-01	ASHS	ETF	49.53	49.95	49.5	49.86	67900.0
2015-04-01	ATMP	ETF	28.96	29.39	28.96	29.1	37700.0
2015-04-01	AVIV	ETF	36.32	37.0	36.02	36.75	5286409.0
2015-04-01	AWAY	ETF	30.14	30.34	29.49	29.84	1353093.0
2015-04-01	BAB	ETF	30.55	30.5634	30.3	30.46	143209.0
2015-04-01	BAL	ETF	42.62	42.62	42.45	42.565	9718.0
2015-04-01	BALT	ETF	1.48	1.65	1.47	1.5	207759.0
2015-04-01	BAR	ETF	2.757	2.757	2.757	2.757	10680.0
2015-04-01	BBC	ETF	32.5	32.83	31.65	32.83	35311.0
2015-04-01	BBH	ETF	129.57	129.57	125.8	127.99	288000.0
2015-04-01	BBP	ETF	30.85	31.34	30.72	31.231	9800.0
2015-04-01	BCHP	ETF	19.11	19.19	19.11	19.18	1979.0

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

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