PREVIEW / etf_daily / 2014-12-24

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-24.parquet
  size:    46 KB
  rows:    1,131

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
2014-12-24	SPY	ETF	208.02	208.34	207.72	207.77	42963400.0
2014-12-24	QQQ	ETF	104.34	104.7	104.2699	104.3	14291333.0
2014-12-24	IWM	ETF	119.63	120.07	119.26	119.76	19175400.0
2014-12-24	DIA	ETF	180.19	180.53	179.94	180.03	1647600.0
2014-12-24	GLD	ETF	112.83	112.92	112.66	112.77	1501600.0
2014-12-24	TLT	ETF	123.06	124.06	122.93	123.95	4871400.0
2014-12-24	AADR	ETF	37.79	37.8	37.38	37.39	5500.0
2014-12-24	AAXJ	ETF	60.29	60.44	60.28	60.37	354700.0
2014-12-24	ACWI	ETF	59.38	59.44	59.23	59.31	925200.0
2014-12-24	ACWV	ETF	69.3	69.55	68.95	69.14	125800.0
2014-12-24	ACWX	ETF	43.57	43.65	43.39	43.59	488067.0
2014-12-24	ADRE	ETF	35.65	35.76	35.65	35.76	5407.0
2014-12-24	AFK	ETF	25.78	25.9899	25.7	25.72	26820.0
2014-12-24	AGG	ETF	109.63	109.71	109.46	109.69	922100.0
2014-12-24	AGQ	ETF	38.23	38.47	37.98	38.25	52700.0
2014-12-24	AGZ	ETF	112.5675	113.3799	112.5675	113.127	23413.0
2014-12-24	AGZD	ETF	24.57	24.645	24.57	24.645	5200.0
2014-12-24	AIA	ETF	46.65	46.8499	46.65	46.742	2797.0
2014-12-24	AIQ	ETF	22.68	22.85	22.12	22.33	9548.0
2014-12-24	AIRR	ETF	18.32	18.47	18.32	18.39	16900.0
2014-12-24	AIVI	ETF	43.85	44.02	43.8	43.85	17800.0
2014-12-24	AMJ	ETF	45.95	46.18	45.51	45.98	474743.0
2014-12-24	AMLP	ETF	87.55	87.9	87.0	87.75	465180.0
2014-12-24	AMZA	ETF	227.9	229.4	227.9	229.2	200.0
2014-12-24	ANGL	ETF	26.6	26.88	26.6	26.88	1700.0
2014-12-24	AOA	ETF	47.0	47.05	46.95	47.0	48400.0
2014-12-24	AOK	ETF	32.72	32.85	32.72	32.81	32838.0
2014-12-24	AOM	ETF	35.55	35.55	35.418	35.52	143363.0
2014-12-24	AOR	ETF	40.58	40.5883	40.525	40.57	137449.0
2014-12-24	ARGT	ETF	18.87	18.95	18.86	18.95	7700.0
2014-12-24	ARKG	ETF	20.6	21.3	20.6	21.206	1500.0
2014-12-24	ARKK	ETF	20.65	20.65	20.37	20.37	3200.0
2014-12-24	ARKQ	ETF	19.89	19.9	19.89	19.89	700.0
2014-12-24	ARKW	ETF	20.879	20.879	20.797	20.815	1100.0
2014-12-24	ASHR	ETF	33.56	33.96	33.22	33.86	483100.0
2014-12-24	ASHS	ETF	34.69	34.91	34.69	34.9	8500.0
2014-12-24	ATMP	ETF	31.0	31.0	30.4	30.62	40200.0
2014-12-24	AVIV	ETF	34.75	35.0	34.57	34.73	62383.0
2014-12-24	AWAY	ETF	28.75	29.06	28.7201	28.87	359243.0
2014-12-24	BAB	ETF	30.29	30.31	30.0	30.31	51018.0
2014-12-24	BAL	ETF	42.36	42.4	42.15	42.15	3540.0
2014-12-24	BALT	ETF	2.56	2.62	2.43	2.47	312523.0
2014-12-24	BAR	ETF	2.673	2.673	2.666	2.666	3420.0
2014-12-24	BBC	ETF	27.0	27.3599	26.75	26.85	57794.0
2014-12-24	BBH	ETF	111.71	115.09	111.65	113.91	117200.0
2014-12-24	BBP	ETF	25.38	25.81	25.38	25.596	3100.0
2014-12-24	BCHP	ETF	18.22	18.34	18.22	18.34	770.0
2014-12-24	BCM	ETF	32.4	32.41	31.87	32.27	136781.0
2014-12-24	BFOR	ETF	7.9375	7.9375	7.9175	7.93	44400.0
2014-12-24	BIB	ETF	58.445	62.405	58.445	61.255	842600.0

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

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