PREVIEW / etf_daily / 2015-03-06

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-06.parquet
  size:    48 KB
  rows:    1,178

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-03-06	SPY	ETF	209.42	209.94	207.1	207.5	188128000.0
2015-03-06	QQQ	ETF	108.5	108.71	107.14	107.41	30990366.0
2015-03-06	IWM	ETF	121.98	122.69	120.88	121.17	37319900.0
2015-03-06	DIA	ETF	180.12	180.63	178.13	178.4	7297400.0
2015-03-06	GLD	ETF	113.17	113.26	111.7	111.86	11190800.0
2015-03-06	TLT	ETF	124.67	124.83	122.97	123.5	20022900.0
2015-03-06	AAXJ	ETF	62.96	63.02	62.32	62.52	1225400.0
2015-03-06	ACWI	ETF	60.25	60.33	59.7	59.79	1497900.0
2015-03-06	ACWV	ETF	71.42	71.6	70.65	70.72	88200.0
2015-03-06	ACWX	ETF	44.56	44.57	44.1801	44.25	241073.0
2015-03-06	ADRE	ETF	35.34	35.34	34.9401	35.0185	11701.0
2015-03-06	AFK	ETF	25.53	25.9073	25.47	25.52	26121.0
2015-03-06	AGG	ETF	110.08	110.09	109.6	109.7	1872900.0
2015-03-06	AGQ	ETF	38.32	38.46	37.65	38.1	326400.0
2015-03-06	AGZ	ETF	113.31	113.43	112.92	113.1	16089.0
2015-03-06	AGZD	ETF	24.545	24.685	24.47	24.555	35600.0
2015-03-06	AIA	ETF	48.68	48.73	48.419	48.53	15237.0
2015-03-06	AIQ	ETF	21.33	21.73	20.87	20.87	23753.0
2015-03-06	AIRR	ETF	18.237	18.29	18.02	18.06	237600.0
2015-03-06	AIVI	ETF	44.5	44.56	44.05	44.06	29700.0
2015-03-06	ALTL	ETF	37.25	37.25	37.061	37.086	10180.0
2015-03-06	AMJ	ETF	43.95	44.3999	43.47	43.7	625004.0
2015-03-06	AMLP	ETF	84.15	84.7	83.5	83.7	1034000.0
2015-03-06	AMZA	ETF	222.2	222.2	216.3	218.5	380.0
2015-03-06	ANGL	ETF	27.16	27.39	27.14	27.37	8100.0
2015-03-06	AOA	ETF	47.6	47.6	47.0	47.04	32200.0
2015-03-06	AOK	ETF	32.8	32.83	32.48	32.56	51156.0
2015-03-06	AOM	ETF	35.53	35.58	35.21	35.27	36666.0
2015-03-06	AOR	ETF	40.87	40.87	40.43	40.5	39310.0
2015-03-06	ARGT	ETF	20.47	20.47	20.31	20.39	7300.0
2015-03-06	ARKG	ETF	23.19	23.235	23.01	23.036	3200.0
2015-03-06	ARKK	ETF	21.53	21.53	20.966	20.966	1100.0
2015-03-06	ARKQ	ETF	20.15	20.15	20.12	20.12	700.0
2015-03-06	ARKW	ETF	22.01	22.01	21.82	21.82	900.0
2015-03-06	ASEA	ETF	15.52	15.53	15.45	15.46	16800.0
2015-03-06	ASHR	ETF	35.13	35.15	34.86	35.0	607400.0
2015-03-06	ASHS	ETF	40.24	40.24	39.89	39.91	7600.0
2015-03-06	ATMP	ETF	29.39	29.6	29.28	29.34	37800.0
2015-03-06	AVIV	ETF	35.51	35.51	33.94	34.14	226432.0
2015-03-06	AWAY	ETF	30.52	30.68	30.23	30.53	819274.0
2015-03-06	BAB	ETF	29.79	29.8602	29.5351	29.67	426329.0
2015-03-06	BAL	ETF	42.91	42.91	42.42	42.48	13765.0
2015-03-06	BALT	ETF	1.54	1.58	1.48	1.52	552292.0
2015-03-06	BAR	ETF	2.659	2.659	2.529	2.558	66290.0
2015-03-06	BBC	ETF	33.8	33.8	32.38	32.8	36905.0
2015-03-06	BBH	ETF	132.02	132.25	129.77	130.03	136100.0
2015-03-06	BBP	ETF	31.69	31.69	30.625	30.76	19000.0
2015-03-06	BCHP	ETF	19.0899	19.0899	18.9809	18.9809	374.0
2015-03-06	BCM	ETF	31.2	31.2	31.092	31.1799	3342.0
2015-03-06	BFOR	ETF	8.145	8.18	8.0875	8.09	42800.0

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

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