PREVIEW / etf_daily / 2015-07-22

all etf daily files

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

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-22	SPY	ETF	210.93	211.77	210.89	211.37	88667900.0
2015-07-22	QQQ	ETF	112.17	113.169	112.165	112.62	35574962.0
2015-07-22	IWM	ETF	124.08	125.09	123.88	124.95	20654200.0
2015-07-22	DIA	ETF	178.43	178.92	177.84	178.3	3811500.0
2015-07-22	GLD	ETF	104.39	105.09	104.18	104.8	8349200.0
2015-07-22	TLT	ETF	119.01	119.9	118.95	119.6	6228900.0
2015-07-22	AADR	ETF	39.6	39.65	39.4	39.65	5900.0
2015-07-22	AAXJ	ETF	60.89	60.93	60.63	60.69	1105400.0
2015-07-22	ACTX	ETF	1.77	1.77	1.18	1.77	744.0
2015-07-22	ACWI	ETF	60.25	60.41	60.2	60.32	1913900.0
2015-07-22	ACWV	ETF	70.59	70.9	70.51	70.69	217200.0
2015-07-22	ACWX	ETF	44.26	44.34	44.2	44.255	566194.0
2015-07-22	ADRE	ETF	34.11	34.162	33.82	33.89	10223.0
2015-07-22	AFK	ETF	23.18	23.18	22.86	23.09	51398.0
2015-07-22	AFTY	ETF	19.95	19.95	19.79	19.87	74100.0
2015-07-22	AGG	ETF	108.83	108.99	108.82	108.83	1100000.0
2015-07-22	AGGY	ETF	49.77	49.77	49.77	49.77	4100.0
2015-07-22	AGQ	ETF	31.8	32.68	31.62	32.22	127800.0
2015-07-22	AGZ	ETF	113.05	113.37	113.05	113.2301	9067.0
2015-07-22	AGZD	ETF	24.34	24.47	24.275	24.445	4800.0
2015-07-22	AIA	ETF	48.42	48.48	48.27	48.36	39417.0
2015-07-22	AIQ	ETF	16.14	16.3499	16.01	16.18	19935.0
2015-07-22	AIRR	ETF	17.774	17.79	17.71	17.75	78600.0
2015-07-22	AIVI	ETF	43.02	43.19	43.0	43.04	7900.0
2015-07-22	AMJ	ETF	37.58	37.89	36.52	36.79	3068943.0
2015-07-22	AMLP	ETF	76.15	76.2	74.35	74.7	1598160.0
2015-07-22	AMZA	ETF	181.6	181.6	173.4	174.9	4400.0
2015-07-22	ANGL	ETF	27.17	27.17	26.91	26.91	16300.0
2015-07-22	AOA	ETF	47.59	47.59	47.32	47.51	18000.0
2015-07-22	AOK	ETF	32.5	32.51	32.39	32.49	103513.0
2015-07-22	AOM	ETF	35.22	35.22	35.1106	35.2	30660.0
2015-07-22	AOR	ETF	40.62	40.65	40.5301	40.563	29714.0
2015-07-22	ARGT	ETF	19.12	19.15	18.98	19.1	1200.0
2015-07-22	ARKG	ETF	23.43	23.525	23.43	23.525	800.0
2015-07-22	ARKK	ETF	21.79	21.79	21.62	21.65	2600.0
2015-07-22	ARKQ	ETF	19.799	19.799	19.77	19.77	600.0
2015-07-22	ARKW	ETF	23.89	23.89	23.69	23.75	2500.0
2015-07-22	ASEA	ETF	14.8	14.8	14.73	14.74	2700.0
2015-07-22	ASHR	ETF	42.95	43.08	42.82	43.02	2758100.0
2015-07-22	ASHS	ETF	51.11	52.94	51.11	52.32	196700.0
2015-07-22	ATMP	ETF	25.59	25.59	25.09	25.2	32200.0
2015-07-22	AWAY	ETF	31.18	31.52	31.04	31.34	584763.0
2015-07-22	BAB	ETF	28.8	28.86	28.7	28.7	191321.0
2015-07-22	BAL	ETF	42.8799	43.36	42.822	43.17	2885.0
2015-07-22	BBC	ETF	38.04	39.0	36.5	38.48	36433.0
2015-07-22	BBH	ETF	142.59	143.61	141.66	143.08	66100.0
2015-07-22	BBP	ETF	36.86	37.55	36.7	37.5	20100.0
2015-07-22	BCM	ETF	28.978	29.01	28.9373	28.99	5977.0
2015-07-22	BFOR	ETF	8.2725	8.31	8.2725	8.2925	48800.0
2015-07-22	BIB	ETF	100.62	103.39	100.0	102.9	603818.0

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

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