PREVIEW / etf_daily / 2015-09-01

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-01.parquet
  size:    49 KB
  rows:    1,217

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-09-01	SPY	ETF	193.12	194.77	190.73	191.77	256000400.0
2015-09-01	QQQ	ETF	101.71	103.29	100.63	101.05	73155538.0
2015-09-01	IWM	ETF	113.11	114.12	111.6	111.9	45129200.0
2015-09-01	DIA	ETF	161.4	162.62	159.74	160.46	14266900.0
2015-09-01	GLD	ETF	109.63	109.77	108.94	109.2	7077800.0
2015-09-01	TLT	ETF	121.64	122.09	120.98	122.03	15298200.0
2015-09-01	AADR	ETF	36.2	36.2	35.98	35.98	800.0
2015-09-01	AAXJ	ETF	52.01	52.25	51.37	51.62	1902900.0
2015-09-01	ACTX	ETF	1.77	1.77	1.711	1.77	229.0
2015-09-01	ACWF	ETF	22.4	22.4599	22.4	22.4599	500.0
2015-09-01	ACWI	ETF	54.41	54.83	53.84	54.03	3179000.0
2015-09-01	ACWV	ETF	66.0	66.55	65.55	65.81	180600.0
2015-09-01	ACWX	ETF	39.64	39.8503	39.3	39.42	1085104.0
2015-09-01	ADRE	ETF	29.02	29.23	28.7558	28.92	7642.0
2015-09-01	AFK	ETF	20.13	20.3	19.94	19.95	22929.0
2015-09-01	AFTY	ETF	14.63	15.1	14.32	14.53	158500.0
2015-09-01	AGG	ETF	108.89	109.11	108.77	109.02	3386000.0
2015-09-01	AGGY	ETF	49.69	49.69	49.69	49.69	100.0
2015-09-01	AGQ	ETF	31.19	31.37	30.75	30.95	106700.0
2015-09-01	AGZ	ETF	113.54	114.0	113.3701	113.96	93453.0
2015-09-01	AGZD	ETF	24.0	24.0	23.955	23.955	4000.0
2015-09-01	AIA	ETF	41.12	41.19	40.72	40.78	39008.0
2015-09-01	AIQ	ETF	14.2	14.2	13.77	13.91	21013.0
2015-09-01	AIRR	ETF	16.44	16.54	16.15	16.15	10200.0
2015-09-01	AIVI	ETF	39.44	39.44	38.97	39.05	98100.0
2015-09-01	ALTY	ETF	14.31	14.31	14.06	14.06	1300.0
2015-09-01	AMJ	ETF	35.14	35.48	34.85	35.06	3107793.0
2015-09-01	AMLP	ETF	71.15	71.9	70.95	71.25	1431480.0
2015-09-01	AMZA	ETF	166.0	171.5	163.1	163.2	1960.0
2015-09-01	ANGL	ETF	26.22	26.3	26.1	26.28	24200.0
2015-09-01	AOA	ETF	43.99	44.15	43.51	43.71	44300.0
2015-09-01	AOK	ETF	31.53	31.7034	31.43	31.455	29654.0
2015-09-01	AOM	ETF	33.83	33.945	33.69	33.72	68181.0
2015-09-01	AOR	ETF	38.27	38.64	38.0	38.11	144277.0
2015-09-01	ARGT	ETF	17.69	17.74	17.51	17.51	4000.0
2015-09-01	ARKG	ETF	20.5	20.5	20.5	20.5	200.0
2015-09-01	ARKK	ETF	19.5	19.5	19.366	19.37	500.0
2015-09-01	ARKQ	ETF	18.18	18.18	17.78	17.8	1400.0
2015-09-01	ARKW	ETF	21.25	21.67	21.21	21.329	3400.0
2015-09-01	ASEA	ETF	12.69	12.69	12.52	12.53	8000.0
2015-09-01	ASHR	ETF	31.42	31.55	30.72	31.09	5838100.0
2015-09-01	ASHS	ETF	36.95	36.95	33.02	33.48	289000.0
2015-09-01	ATMP	ETF	24.05	24.05	23.66	23.81	119700.0
2015-09-01	AWAY	ETF	27.96	28.74	27.48	27.5	1329010.0
2015-09-01	BAB	ETF	28.88	28.9999	28.8	28.99	56982.0
2015-09-01	BAL	ETF	41.79	41.84	41.62	41.64	2932.0
2015-09-01	BBC	ETF	30.5	31.3067	30.5	30.56	18924.0
2015-09-01	BBH	ETF	124.75	125.58	120.24	122.6	245200.0
2015-09-01	BBP	ETF	31.77	32.79	31.61	31.85	32400.0
2015-09-01	BCHP	ETF	17.31	17.31	17.31	17.31	363.0

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

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