PREVIEW / etf_daily / 2015-07-21

all etf daily files

  file:    by_date/etf_daily/2015/2015-07-21.parquet
  size:    48 KB
  rows:    1,184

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-07-21	SPY	ETF	212.43	212.74	211.39	211.75	77965000.0
2015-07-21	QQQ	ETF	114.02	114.2	113.58	113.91	35468865.0
2015-07-21	IWM	ETF	125.07	125.8	124.11	124.49	28118700.0
2015-07-21	DIA	ETF	179.69	179.71	178.43	178.97	5026700.0
2015-07-21	GLD	ETF	105.81	106.32	105.25	105.37	10519800.0
2015-07-21	TLT	ETF	117.68	118.93	117.66	118.86	5627500.0
2015-07-21	AADR	ETF	39.8	40.11	39.8	40.04	8400.0
2015-07-21	AAXJ	ETF	61.43	61.66	61.25	61.3	724800.0
2015-07-21	ACTX	ETF	1.18	1.77	1.18	1.18	262.0
2015-07-21	ACWI	ETF	60.71	60.83	60.54	60.65	880800.0
2015-07-21	ACWV	ETF	70.94	71.1	70.76	70.93	68400.0
2015-07-21	ACWX	ETF	44.69	44.8	44.596	44.66	124918.0
2015-07-21	ADRE	ETF	34.28	34.5	34.247	34.32	6979.0
2015-07-21	AFK	ETF	23.31	23.45	23.18	23.19	15695.0
2015-07-21	AFTY	ETF	20.0	20.125	19.97	19.97	50200.0
2015-07-21	AGG	ETF	108.54	108.85	108.51	108.78	1191500.0
2015-07-21	AGGY	ETF	49.85	49.85	49.85	49.85	300.0
2015-07-21	AGQ	ETF	32.32	32.92	32.13	32.27	169800.0
2015-07-21	AGZ	ETF	113.0	113.26	112.9101	113.18	12671.0
2015-07-21	AGZD	ETF	24.285	24.35	24.275	24.285	7200.0
2015-07-21	AIA	ETF	49.02	49.0249	48.8197	48.83	10681.0
2015-07-21	AIQ	ETF	16.34	16.57	16.036	16.22	17671.0
2015-07-21	AIRR	ETF	17.78	17.846	17.78	17.8	6700.0
2015-07-21	AIVI	ETF	43.48	43.67	43.35	43.46	9000.0
2015-07-21	ALTY	ETF	15.02	15.02	14.98	14.98	3700.0
2015-07-21	AMJ	ETF	38.0	38.45	37.53	37.79	2887218.0
2015-07-21	AMLP	ETF	76.25	76.9	75.75	76.2	999960.0
2015-07-21	AMZA	ETF	181.8	185.0	180.0	181.5	2090.0
2015-07-21	ANGL	ETF	27.08	27.14	27.04	27.05	30200.0
2015-07-21	AOA	ETF	47.7	47.86	47.6	47.72	41900.0
2015-07-21	AOK	ETF	32.4	32.55	32.4	32.486	34513.0
2015-07-21	AOM	ETF	35.36	35.36	35.19	35.24	101603.0
2015-07-21	AOR	ETF	40.68	40.77	40.63	40.74	60508.0
2015-07-21	ARGT	ETF	19.34	19.53	19.3	19.3	63600.0
2015-07-21	ARKG	ETF	23.95	23.95	23.56	23.61	2400.0
2015-07-21	ARKK	ETF	21.94	21.94	21.87	21.87	800.0
2015-07-21	ARKQ	ETF	19.8	19.88	19.8	19.88	600.0
2015-07-21	ARKW	ETF	24.04	24.04	23.81	23.88	1500.0
2015-07-21	ASEA	ETF	14.89	14.9	14.87	14.87	7600.0
2015-07-21	ASHR	ETF	42.8	43.0	42.72	42.99	2640900.0
2015-07-21	ASHS	ETF	51.0	52.42	50.92	51.31	71900.0
2015-07-21	ATMP	ETF	26.24	26.24	25.77	25.88	40900.0
2015-07-21	AWAY	ETF	31.01	31.52	30.935	31.28	1582617.0
2015-07-21	BAB	ETF	28.75	28.8	28.66	28.78	59323.0
2015-07-21	BAL	ETF	43.17	43.33	42.9726	43.05	5088.0
2015-07-21	BBC	ETF	38.69	38.8923	37.8701	38.49	42219.0
2015-07-21	BBH	ETF	144.67	144.99	142.42	143.67	142000.0
2015-07-21	BBP	ETF	37.38	37.45	36.76	37.24	31300.0
2015-07-21	BCHP	ETF	19.49	19.49	19.4805	19.49	300.0
2015-07-21	BCM	ETF	29.36	29.36	29.3496	29.3496	913.0

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

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