PREVIEW / etf_daily / 2015-07-14

all etf daily files

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

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-14	SPY	ETF	209.72	211.05	209.65	210.68	81709600.0
2015-07-14	QQQ	ETF	109.69	110.56	109.63	110.26	21977167.0
2015-07-14	IWM	ETF	125.46	126.5	125.4	126.23	21009500.0
2015-07-14	DIA	ETF	179.45	180.54	179.31	180.33	2757100.0
2015-07-14	GLD	ETF	111.0	111.08	110.63	110.74	2601000.0
2015-07-14	TLT	ETF	116.02	116.27	115.66	116.07	4227800.0
2015-07-14	AAXJ	ETF	61.09	61.49	61.07	61.43	703100.0
2015-07-14	ACTX	ETF	1.77	1.77	1.18	1.77	278.0
2015-07-14	ACWI	ETF	60.18	60.61	60.17	60.55	1328900.0
2015-07-14	ACWV	ETF	71.01	71.14	70.87	71.08	107600.0
2015-07-14	ACWX	ETF	44.57	44.74	44.5	44.7	279887.0
2015-07-14	ADRE	ETF	34.27	34.56	34.27	34.45	2235.0
2015-07-14	AFK	ETF	23.29	23.41	23.26	23.26	6756.0
2015-07-14	AFTY	ETF	20.16	20.16	19.93	20.01	61900.0
2015-07-14	AGG	ETF	108.43	108.5	108.32	108.4	1441400.0
2015-07-14	AGQ	ETF	35.17	35.26	34.6	34.85	100500.0
2015-07-14	AGZ	ETF	113.02	113.18	112.51	113.1699	9738.0
2015-07-14	AGZD	ETF	24.455	24.46	24.33	24.365	7600.0
2015-07-14	AIA	ETF	48.37	48.57	48.3654	48.5499	10450.0
2015-07-14	AIQ	ETF	17.265	17.54	17.14	17.48	23731.0
2015-07-14	AIRR	ETF	18.23	18.294	18.23	18.28	21900.0
2015-07-14	AIVI	ETF	43.19	43.47	43.19	43.41	180700.0
2015-07-14	ALTY	ETF	15.14	15.14	15.1027	15.14	7816.0
2015-07-14	AMJ	ETF	40.17	40.965	40.17	40.61	2111964.0
2015-07-14	AMLP	ETF	79.25	80.2	78.95	79.8	755440.0
2015-07-14	AMZA	ETF	199.7	199.7	197.2	198.4	3890.0
2015-07-14	ANGL	ETF	27.09	27.1	27.0	27.01	17000.0
2015-07-14	AOA	ETF	47.5	47.62	47.43	47.51	19900.0
2015-07-14	AOK	ETF	32.43	32.48	32.36	32.43	120346.0
2015-07-14	AOM	ETF	35.17	35.225	35.05	35.2	30723.0
2015-07-14	AOR	ETF	41.32	42.54	40.48	40.62	60916.0
2015-07-14	ARGT	ETF	19.79	19.88	19.77	19.86	4200.0
2015-07-14	ARKG	ETF	23.373	23.373	23.23	23.23	200.0
2015-07-14	ARKK	ETF	21.57	21.57	21.565	21.565	300.0
2015-07-14	ARKQ	ETF	19.929	19.98	19.929	19.98	1100.0
2015-07-14	ARKW	ETF	23.44	23.47	23.44	23.47	2100.0
2015-07-14	ASEA	ETF	14.91	14.98	14.91	14.94	12600.0
2015-07-14	ASHR	ETF	41.94	42.27	41.79	42.07	3955800.0
2015-07-14	ASHS	ETF	50.55	50.67	49.15	49.54	145200.0
2015-07-14	ATMP	ETF	27.4	27.73	27.36	27.65	79700.0
2015-07-14	AWAY	ETF	31.19	31.62	31.18	31.51	710720.0
2015-07-14	BAB	ETF	28.62	28.772	28.62	28.76	57261.0
2015-07-14	BAL	ETF	44.256	44.256	44.256	44.256	309.0
2015-07-14	BALT	ETF	1.54	1.54	1.47	1.5	293921.0
2015-07-14	BBC	ETF	37.92	38.74	37.63	38.67	59500.0
2015-07-14	BBH	ETF	137.57	140.77	137.08	140.53	169700.0
2015-07-14	BBP	ETF	36.47	36.71	36.05	36.62	47000.0
2015-07-14	BCM	ETF	30.309	30.31	30.25	30.31	2468.0
2015-07-14	BFOR	ETF	8.3525	8.4125	8.3525	8.4075	40000.0
2015-07-14	BIB	ETF	95.86	99.84	95.13	99.49	1010501.0

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

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