PREVIEW / etf_daily / 2015-07-24

all etf daily files

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

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-24	SPY	ETF	210.3	210.37	207.6	208.0	117755000.0
2015-07-24	QQQ	ETF	112.8	113.003	110.93	111.1	30844714.0
2015-07-24	IWM	ETF	123.48	123.71	121.49	121.58	39533000.0
2015-07-24	DIA	ETF	177.23	177.25	175.31	175.52	4591300.0
2015-07-24	GLD	ETF	103.61	105.59	103.43	105.35	11572700.0
2015-07-24	TLT	ETF	121.5	121.55	120.92	121.39	7307900.0
2015-07-24	AADR	ETF	39.76	39.76	39.15	39.4	1500.0
2015-07-24	AAXJ	ETF	60.05	60.09	59.48	59.69	1237100.0
2015-07-24	ACTX	ETF	1.77	1.77	1.77	1.77	101.0
2015-07-24	ACWF	ETF	24.22	24.22	24.17	24.17	760.0
2015-07-24	ACWI	ETF	59.98	59.98	59.26	59.38	868000.0
2015-07-24	ACWV	ETF	70.61	70.61	70.09	70.17	108000.0
2015-07-24	ACWX	ETF	43.97	43.97	43.5195	43.57	151503.0
2015-07-24	ADRE	ETF	33.33	33.33	32.78	32.8841	3253.0
2015-07-24	AFK	ETF	22.92	22.92	22.5144	22.62	76499.0
2015-07-24	AFTY	ETF	19.75	19.805	19.678	19.75	54000.0
2015-07-24	AGG	ETF	109.23	109.24	109.06	109.12	1192500.0
2015-07-24	AGQ	ETF	30.65	31.98	30.37	31.68	296400.0
2015-07-24	AGZ	ETF	113.49	113.67	112.94	113.39	20398.0
2015-07-24	AGZD	ETF	24.305	24.45	24.305	24.45	4600.0
2015-07-24	AIA	ETF	47.88	47.88	47.43	47.55	11320.0
2015-07-24	AIQ	ETF	16.07	16.135	15.7	15.71	33809.0
2015-07-24	AIRR	ETF	17.37	17.37	17.02	17.08	92300.0
2015-07-24	AIVI	ETF	42.81	42.85	42.36	42.38	38200.0
2015-07-24	ALTY	ETF	14.67	14.69	14.6	14.69	1100.0
2015-07-24	AMJ	ETF	36.84	37.2899	36.63	37.16	1554798.0
2015-07-24	AMLP	ETF	75.25	75.55	74.85	75.35	981520.0
2015-07-24	AMZA	ETF	177.2	178.59	175.5	176.7	3350.0
2015-07-24	ANGL	ETF	26.98	26.99	26.85	26.93	16400.0
2015-07-24	AOA	ETF	47.28	47.28	46.86	46.96	27600.0
2015-07-24	AOK	ETF	32.39	32.46	32.3	32.42	82443.0
2015-07-24	AOM	ETF	35.09	35.2099	34.9501	35.03	28016.0
2015-07-24	AOR	ETF	40.55	40.55	40.19	40.29	45327.0
2015-07-24	ARGT	ETF	18.83	18.83	18.39	18.52	4600.0
2015-07-24	ARKG	ETF	23.29	23.29	22.89	22.89	1200.0
2015-07-24	ARKK	ETF	21.9	21.9	21.9	21.9	200.0
2015-07-24	ARKQ	ETF	19.729	19.729	19.729	19.729	200.0
2015-07-24	ARKW	ETF	24.17	24.19	23.979	23.979	1300.0
2015-07-24	ASEA	ETF	14.73	14.73	14.61	14.61	7000.0
2015-07-24	ASHR	ETF	43.3	43.3	42.8	43.11	3459600.0
2015-07-24	ASHS	ETF	53.8	53.8	52.17	52.56	165300.0
2015-07-24	ATMP	ETF	25.26	25.45	25.21	25.33	28100.0
2015-07-24	AWAY	ETF	31.1	31.44	29.81	29.91	1674331.0
2015-07-24	BAB	ETF	28.98	29.0	28.91	28.99	59344.0
2015-07-24	BAL	ETF	43.46	43.46	42.987	43.4145	4331.0
2015-07-24	BBC	ETF	37.85	39.95	36.79	36.85	32025.0
2015-07-24	BBH	ETF	140.76	140.76	136.41	136.7	243300.0
2015-07-24	BBP	ETF	37.1	37.1	35.72	35.83	39800.0
2015-07-24	BCHP	ETF	18.91	18.9199	18.79	18.79	179041.0
2015-07-24	BCM	ETF	28.48	28.48	28.37	28.4693	16727.0

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

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