PREVIEW / etf_daily / 2015-12-23

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-23.parquet
  size:    49 KB
  rows:    1,226

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-12-23	SPY	ETF	204.69	206.07	204.58	206.02	110987200.0
2015-12-23	QQQ	ETF	112.34	112.69	112.16	112.61	25656928.0
2015-12-23	IWM	ETF	113.92	114.96	113.73	114.78	29609700.0
2015-12-23	DIA	ETF	175.22	175.82	174.76	175.81	6456600.0
2015-12-23	GLD	ETF	102.4	102.59	102.21	102.31	2821400.0
2015-12-23	TLT	ETF	121.23	121.61	120.87	121.39	7287100.0
2015-12-23	AADR	ETF	38.86	38.9	38.45	38.88	5900.0
2015-12-23	AAXJ	ETF	54.27	54.7	54.27	54.63	932400.0
2015-12-23	ACTX	ETF	7.6701	8.2601	5.9001	7.0801	798.0
2015-12-23	ACWI	ETF	56.22	56.55	56.14	56.54	2376900.0
2015-12-23	ACWV	ETF	69.43	69.8	69.35	69.74	510100.0
2015-12-23	ACWX	ETF	39.98	40.25	39.92	40.25	6443780.0
2015-12-23	ADRE	ETF	29.76	29.96	29.76	29.96	23370.0
2015-12-23	AFK	ETF	17.77	18.03	17.7	17.96	107233.0
2015-12-23	AFTY	ETF	14.85	14.96	14.82	14.89	34100.0
2015-12-23	AGG	ETF	108.01	108.19	108.0	108.18	3599600.0
2015-12-23	AGGY	ETF	49.0	49.0	49.0	49.0	100.0
2015-12-23	AGQ	ETF	28.83	29.13	28.64	29.02	55500.0
2015-12-23	AGZ	ETF	112.96	113.2199	112.8501	113.0	15986.0
2015-12-23	AGZD	ETF	23.965	23.985	23.855	23.89	12800.0
2015-12-23	AIA	ETF	43.09	43.32	43.09	43.32	46581.0
2015-12-23	AIQ	ETF	9.0	9.095	8.83	8.93	18133.0
2015-12-23	AIRR	ETF	16.73	16.911	16.73	16.91	8700.0
2015-12-23	AIVI	ETF	38.2	38.53	38.2	38.51	71700.0
2015-12-23	AMJ	ETF	27.63	29.08	27.61	29.07	8659386.0
2015-12-23	AMLP	ETF	58.7	59.95	57.5	59.95	6493960.0
2015-12-23	AMZA	ETF	105.9	111.54	105.9	111.1	5180.0
2015-12-23	ANGL	ETF	24.37	24.47	24.29	24.47	11900.0
2015-12-23	AOA	ETF	45.36	45.6	45.2	45.6	156900.0
2015-12-23	AOK	ETF	31.77	31.86	31.76	31.86	77994.0
2015-12-23	AOM	ETF	34.39	34.42	34.28	34.39	720034.0
2015-12-23	AOR	ETF	39.18	39.339	39.11	39.33	918239.0
2015-12-23	ARGT	ETF	18.02	18.35	18.02	18.32	25400.0
2015-12-23	ARKG	ETF	20.73	20.73	20.73	20.73	100.0
2015-12-23	ARKK	ETF	21.21	21.267	21.21	21.267	200.0
2015-12-23	ARKQ	ETF	19.68	19.68	19.68	19.68	200.0
2015-12-23	ARKW	ETF	23.79	23.79	23.711	23.711	700.0
2015-12-23	ASEA	ETF	12.65	12.66	12.65	12.66	5600.0
2015-12-23	ASET	ETF	24.58	24.7	24.58	24.7	7200.0
2015-12-23	ASHR	ETF	29.45	29.49	29.3	29.39	1349400.0
2015-12-23	ASHS	ETF	43.67	43.67	43.1	43.4	72300.0
2015-12-23	ASHX	ETF	26.72	26.72	26.57	26.57	2233.0
2015-12-23	ATMP	ETF	17.75	18.92	17.74	18.84	304400.0
2015-12-23	BAB	ETF	28.88	29.0	28.82	28.87	88546.0
2015-12-23	BBC	ETF	29.1612	29.5863	29.1612	29.5863	9093.0
2015-12-23	BBH	ETF	126.38	126.9	125.71	126.65	58900.0
2015-12-23	BBP	ETF	30.815	31.0	30.815	30.91	5000.0
2015-12-23	BCM	ETF	23.642	23.89	23.642	23.89	6324.0
2015-12-23	BFOR	ETF	7.57	7.6125	7.57	7.6075	98000.0
2015-12-23	BIB	ETF	70.34	71.84	70.05	71.6	463775.0

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

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