PREVIEW / etf_daily / 2015-03-30

all etf daily files

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

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-30	SPY	ETF	206.98	208.61	206.96	208.25	96180400.0
2015-03-30	QQQ	ETF	106.16	106.82	106.16	106.73	30570196.0
2015-03-30	IWM	ETF	123.72	124.99	123.7	124.77	20487000.0
2015-03-30	DIA	ETF	178.31	179.76	178.28	179.39	5399300.0
2015-03-30	GLD	ETF	113.9	114.01	113.54	113.75	4383900.0
2015-03-30	TLT	ETF	130.9	131.0	130.09	130.41	7010600.0
2015-03-30	AADR	ETF	39.07	39.07	38.37	38.52	14800.0
2015-03-30	AAXJ	ETF	64.02	64.41	63.78	64.32	546100.0
2015-03-30	ACWI	ETF	60.39	60.74	60.24	60.64	565100.0
2015-03-30	ACWV	ETF	71.8	72.29	71.78	72.21	289400.0
2015-03-30	ACWX	ETF	45.1	45.33	45.1	45.22	170458.0
2015-03-30	ADRE	ETF	34.47	34.91	34.47	34.85	10482.0
2015-03-30	AFK	ETF	24.73	24.96	24.73	24.88	12445.0
2015-03-30	AFTY	ETF	20.12	20.12	19.91	20.096	207700.0
2015-03-30	AGG	ETF	111.34	111.34	111.16	111.24	1310700.0
2015-03-30	AGQ	ETF	42.39	42.43	41.63	42.01	218900.0
2015-03-30	AGZ	ETF	114.061	114.45	114.061	114.25	73036.0
2015-03-30	AGZD	ETF	24.52	24.54	24.46	24.54	6600.0
2015-03-30	AIA	ETF	49.88	50.2256	49.88	50.22	8386.0
2015-03-30	AIQ	ETF	20.85	22.3	20.81	22.15	25589.0
2015-03-30	AIRR	ETF	18.831	19.03	18.831	19.03	33900.0
2015-03-30	AIVI	ETF	44.57	44.61	44.4	44.52	48700.0
2015-03-30	ALTL	ETF	37.74	38.0139	37.74	38.0139	1150.0
2015-03-30	AMJ	ETF	42.74	43.06	42.573	43.04	669821.0
2015-03-30	AMLP	ETF	82.8	83.05	82.6	83.05	516760.0
2015-03-30	AMZA	ETF	214.51	215.9	214.51	215.4	240.0
2015-03-30	ANGL	ETF	27.39	27.41	27.39	27.41	1400.0
2015-03-30	AOA	ETF	47.82	48.01	47.67	47.81	60200.0
2015-03-30	AOK	ETF	32.95	33.25	32.95	33.09	56297.0
2015-03-30	AOM	ETF	35.76	36.89	35.7	35.83	34931.0
2015-03-30	AOR	ETF	40.99	42.27	40.9801	41.11	105312.0
2015-03-30	ARGT	ETF	21.28	21.28	21.07	21.21	2900.0
2015-03-30	ARKG	ETF	22.75	22.97	22.74	22.97	5000.0
2015-03-30	ARKK	ETF	21.0	21.0	21.0	21.0	100.0
2015-03-30	ARKQ	ETF	19.86	19.96	19.836	19.96	2100.0
2015-03-30	ARKW	ETF	21.89	22.044	21.89	22.0	1800.0
2015-03-30	ASEA	ETF	15.67	15.8	15.67	15.8	15000.0
2015-03-30	ASHR	ETF	42.49	42.94	42.25	42.89	1539500.0
2015-03-30	ASHS	ETF	48.74	49.02	48.59	48.97	87100.0
2015-03-30	ATMP	ETF	29.0	29.36	29.0	29.32	16800.0
2015-03-30	AVIV	ETF	36.13	37.05	36.13	36.96	207338.0
2015-03-30	AWAY	ETF	31.01	31.12	29.905	30.13	1656853.0
2015-03-30	BAB	ETF	30.12	30.4	30.12	30.39	230439.0
2015-03-30	BAL	ETF	43.17	43.65	42.31	42.31	5631.0
2015-03-30	BALT	ETF	1.49	1.54	1.47	1.52	93460.0
2015-03-30	BAR	ETF	2.6484	2.733	2.6301	2.733	13530.0
2015-03-30	BBC	ETF	32.56	33.46	32.1801	33.46	50071.0
2015-03-30	BBH	ETF	133.21	133.77	131.83	132.96	509800.0
2015-03-30	BBP	ETF	31.84	31.86	31.18	31.53	18500.0
2015-03-30	BCHP	ETF	19.2699	19.27	19.17	19.18	2444.0

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

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