PREVIEW / etf_daily / 2015-04-02

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-02.parquet
  size:    47 KB
  rows:    1,165

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-04-02	SPY	ETF	205.62	206.98	205.4	206.44	86900900.0
2015-04-02	QQQ	ETF	105.15	105.46	104.78	105.12	19164241.0
2015-04-02	IWM	ETF	124.36	125.26	124.29	124.65	23586400.0
2015-04-02	DIA	ETF	176.7	177.91	176.43	177.33	3223600.0
2015-04-02	GLD	ETF	115.47	115.72	114.68	115.28	3884100.0
2015-04-02	TLT	ETF	131.93	131.97	130.61	130.73	6663400.0
2015-04-02	AADR	ETF	38.89	38.89	38.86	38.86	1200.0
2015-04-02	AAXJ	ETF	64.93	65.38	64.9	65.3	670900.0
2015-04-02	ACWI	ETF	60.3	60.66	60.23	60.56	663700.0
2015-04-02	ACWV	ETF	71.96	72.26	71.95	72.09	78900.0
2015-04-02	ACWX	ETF	45.33	45.54	45.33	45.49	366798.0
2015-04-02	ADRE	ETF	35.41	35.59	35.41	35.5601	5066.0
2015-04-02	AFK	ETF	25.9	26.1	25.602	25.9	35372.0
2015-04-02	AFTY	ETF	19.77	19.77	19.556	19.59	10900.0
2015-04-02	AGG	ETF	111.57	111.57	111.38	111.43	1761700.0
2015-04-02	AGQ	ETF	42.43	42.72	41.39	42.15	189000.0
2015-04-02	AGZ	ETF	114.3	114.54	114.1427	114.34	26642.0
2015-04-02	AGZD	ETF	24.5	24.54	24.44	24.54	13200.0
2015-04-02	AIA	ETF	50.57	50.74	50.35	50.71	37675.0
2015-04-02	AIQ	ETF	22.52	23.05	22.45	22.87	15695.0
2015-04-02	AIRR	ETF	19.14	19.14	19.022	19.08	6800.0
2015-04-02	AIVI	ETF	44.26	44.45	44.24	44.4	43700.0
2015-04-02	AMJ	ETF	42.75	43.245	42.75	43.07	1835211.0
2015-04-02	AMLP	ETF	82.5	83.35	82.5	83.05	623900.0
2015-04-02	AMZA	ETF	219.4	219.4	214.23	214.5	660.0
2015-04-02	ANGL	ETF	27.32	27.32	27.28	27.31	1900.0
2015-04-02	AOA	ETF	47.54	47.73	47.54	47.69	21000.0
2015-04-02	AOK	ETF	33.0132	33.03	32.959	33.03	17413.0
2015-04-02	AOM	ETF	35.67	35.73	35.61	35.68	35195.0
2015-04-02	AOR	ETF	40.89	41.0134	40.89	40.97	60190.0
2015-04-02	ARGT	ETF	21.08	21.33	21.08	21.26	1500.0
2015-04-02	ARKG	ETF	22.44	22.49	22.358	22.362	1600.0
2015-04-02	ARKK	ETF	20.59	20.658	20.59	20.658	400.0
2015-04-02	ARKQ	ETF	19.9	19.929	19.9	19.929	700.0
2015-04-02	ARKW	ETF	21.68	21.68	21.68	21.68	500.0
2015-04-02	ASEA	ETF	15.82	16.0	15.82	15.98	10200.0
2015-04-02	ASHR	ETF	42.28	42.52	42.12	42.32	1216100.0
2015-04-02	ASHS	ETF	50.61	50.82	50.51	50.77	143400.0
2015-04-02	ATMP	ETF	29.21	29.35	29.08	29.2	28800.0
2015-04-02	AWAY	ETF	29.87	30.66	29.86	30.44	1199075.0
2015-04-02	BAB	ETF	30.51	30.5399	30.32	30.37	80180.0
2015-04-02	BAL	ETF	43.0	43.3828	43.0	43.38	8743.0
2015-04-02	BALT	ETF	1.49	1.57	1.49	1.51	229163.0
2015-04-02	BAR	ETF	2.789	2.799	2.7241	2.787	10050.0
2015-04-02	BBC	ETF	33.19	33.3255	32.29	32.57	27978.0
2015-04-02	BBH	ETF	128.27	128.99	127.0	127.98	80000.0
2015-04-02	BBP	ETF	31.42	31.45	30.99	31.44	12900.0
2015-04-02	BCM	ETF	30.88	30.88	30.74	30.79	25786.0
2015-04-02	BFOR	ETF	8.2975	8.365	8.2875	8.3275	77200.0
2015-04-02	BIB	ETF	77.65	78.34	76.273	77.395	849712.0

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

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