PREVIEW / etf_daily / 2016-03-11

all etf daily files

  file:    by_date/etf_daily/2016/2016-03-11.parquet
  size:    50 KB
  rows:    1,248

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
2016-03-11	SPY	ETF	201.26	202.81	199.52	202.76	137964500.0
2016-03-11	QQQ	ETF	105.8	106.49	105.46	106.49	31453958.0
2016-03-11	IWM	ETF	106.79	108.33	106.66	108.2	33625000.0
2016-03-11	DIA	ETF	171.47	172.34	171.42	172.23	3674200.0
2016-03-11	GLD	ETF	121.19	121.39	119.36	119.41	10812300.0
2016-03-11	TLT	ETF	128.82	128.88	127.21	127.36	8927000.0
2016-03-11	AADR	ETF	37.6	37.69	37.58	37.69	1400.0
2016-03-11	AAXJ	ETF	52.62	53.11	52.51	53.08	787100.0
2016-03-11	ACTX	ETF	4.72	4.72	3.54	4.72	1627.0
2016-03-11	ACWI	ETF	54.9	55.38	54.9	55.36	1583800.0
2016-03-11	ACWV	ETF	71.49	71.88	71.49	71.88	285600.0
2016-03-11	ACWX	ETF	38.99	39.31	38.98	39.3	1025380.0
2016-03-11	ADRE	ETF	29.64	30.145	29.64	30.11	11187.0
2016-03-11	AFK	ETF	18.97	19.04	18.72	18.77	11477.0
2016-03-11	AFTY	ETF	12.36	12.43	12.35	12.41	10700.0
2016-03-11	AGG	ETF	109.65	109.71	109.39	109.42	2065000.0
2016-03-11	AGGY	ETF	49.93	49.93	49.74	49.83	21200.0
2016-03-11	AGQ	ETF	33.92	34.02	33.16	33.21	111900.0
2016-03-11	AGZ	ETF	114.0	114.2699	113.7401	113.88	15442.0
2016-03-11	AGZD	ETF	23.725	23.83	23.725	23.805	14200.0
2016-03-11	AIA	ETF	41.65	42.04	41.65	42.02	6131.0
2016-03-11	AIQ	ETF	7.9	8.05	7.05	7.72	22934.0
2016-03-11	AIRR	ETF	16.79	16.96	16.79	16.96	1600.0
2016-03-11	AIVI	ETF	38.01	38.32	38.01	38.27	44500.0
2016-03-11	AMJ	ETF	25.93	26.4	25.88	26.22	2810458.0
2016-03-11	AMLP	ETF	52.45	53.4	52.3	52.9	2157980.0
2016-03-11	AMZA	ETF	85.5	87.5	85.0	86.6	2460.0
2016-03-11	ANGL	ETF	25.36	25.56	25.36	25.47	27700.0
2016-03-11	AOA	ETF	44.35	44.73	44.35	44.73	34900.0
2016-03-11	AOK	ETF	31.7301	31.88	31.7301	31.87	25531.0
2016-03-11	AOM	ETF	34.2	34.35	34.125	34.35	45266.0
2016-03-11	AOR	ETF	38.75	38.91	38.7	38.91	127095.0
2016-03-11	ARGT	ETF	18.88	19.03	18.88	18.96	82100.0
2016-03-11	ARKG	ETF	17.1	17.1	17.1	17.1	1000.0
2016-03-11	ARKK	ETF	17.93	17.93	17.93	17.93	1000.0
2016-03-11	ARKQ	ETF	17.72	17.72	17.72	17.72	200.0
2016-03-11	ARKW	ETF	19.63	19.808	19.63	19.808	800.0
2016-03-11	ASEA	ETF	13.07	13.16	13.07	13.16	900.0
2016-03-11	ASHR	ETF	22.74	23.13	22.74	23.11	1835600.0
2016-03-11	ASHS	ETF	30.45	30.69	30.45	30.61	19800.0
2016-03-11	ATMP	ETF	17.65	17.73	17.56	17.59	31700.0
2016-03-11	BAB	ETF	29.95	29.99	29.74	29.74	318587.0
2016-03-11	BAL	ETF	37.3583	37.5261	37.11	37.4	2639.0
2016-03-11	BBC	ETF	18.0	18.32	17.9	18.2658	2915.0
2016-03-11	BBH	ETF	101.6	103.15	101.36	103.05	58000.0
2016-03-11	BBP	ETF	24.22	24.561	24.0	24.561	4000.0
2016-03-11	BCM	ETF	24.87	24.87	24.7452	24.81	1405.0
2016-03-11	BFOR	ETF	7.3075	7.3975	7.3075	7.3975	59200.0
2016-03-11	BIB	ETF	40.2	41.54	39.79	41.4301	656262.0
2016-03-11	BICK	ETF	19.4675	19.4675	19.3501	19.38	1176.0

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

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