PREVIEW / etf_daily / 2015-01-21

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-21.parquet
  size:    47 KB
  rows:    1,160

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-01-21	SPY	ETF	201.5	203.66	200.94	203.08	122942700.0
2015-01-21	QQQ	ETF	101.32	102.619	100.9648	102.14	40128772.0
2015-01-21	IWM	ETF	115.8	116.82	115.29	115.84	27333500.0
2015-01-21	DIA	ETF	174.25	175.75	173.66	175.35	6259300.0
2015-01-21	GLD	ETF	125.18	125.34	123.37	124.23	11082700.0
2015-01-21	TLT	ETF	135.2	135.59	132.96	133.4	9803900.0
2015-01-21	AAXJ	ETF	62.58	63.07	62.42	63.07	2593200.0
2015-01-21	ACWI	ETF	58.1	58.52	57.89	58.44	3439300.0
2015-01-21	ACWV	ETF	70.52	70.68	70.2	70.68	182000.0
2015-01-21	ACWX	ETF	42.96	43.27	42.87	43.27	846802.0
2015-01-21	ADRE	ETF	36.27	36.99	36.27	36.99	6368.0
2015-01-21	AFK	ETF	25.69	25.93	25.69	25.8895	17351.0
2015-01-21	AGG	ETF	111.68	111.81	111.39	111.49	2020200.0
2015-01-21	AGQ	ETF	51.93	52.29	49.58	50.47	497400.0
2015-01-21	AGZ	ETF	114.66	114.88	114.37	114.5848	45225.0
2015-01-21	AGZD	ETF	24.41	24.49	24.4	24.41	9600.0
2015-01-21	AIA	ETF	48.43	48.82	48.43	48.79	39770.0
2015-01-21	AIQ	ETF	21.55	22.235	21.38	21.88	35472.0
2015-01-21	AIRR	ETF	16.51	16.7	16.51	16.65	92300.0
2015-01-21	AIVI	ETF	43.04	43.49	43.04	43.49	46000.0
2015-01-21	ALTL	ETF	37.92	38.09	37.92	38.08	1402.0
2015-01-21	AMJ	ETF	44.07	45.17	43.73	45.12	1494354.0
2015-01-21	AMLP	ETF	85.05	86.55	85.0	86.4	1012060.0
2015-01-21	AMZA	ETF	216.1	216.9	216.1	216.89	360.0
2015-01-21	ANGL	ETF	26.39	26.42	26.35	26.35	1800.0
2015-01-21	AOA	ETF	46.05	46.34	45.95	46.3	45700.0
2015-01-21	AOK	ETF	32.6	32.72	32.6	32.67	34180.0
2015-01-21	AOM	ETF	35.09	35.28	35.09	35.24	103952.0
2015-01-21	AOR	ETF	40.05	40.2	39.97	40.12	65088.0
2015-01-21	ARGT	ETF	18.32	18.57	18.32	18.55	1900.0
2015-01-21	ARKG	ETF	22.79	22.79	22.18	22.22	3000.0
2015-01-21	ARKK	ETF	19.97	20.25	19.97	20.25	400.0
2015-01-21	ARKQ	ETF	18.818	18.83	18.76	18.788	1700.0
2015-01-21	ARKW	ETF	20.42	20.5	20.37	20.44	4200.0
2015-01-21	ASEA	ETF	15.51	15.67	15.51	15.64	18900.0
2015-01-21	ASHR	ETF	36.43	36.97	36.36	36.95	2375100.0
2015-01-21	ASHS	ETF	36.87	37.02	36.87	37.02	7400.0
2015-01-21	ATMP	ETF	29.15	29.83	29.15	29.83	24800.0
2015-01-21	AVIV	ETF	39.41	39.46	39.05	39.11	234489.0
2015-01-21	AWAY	ETF	26.55	26.99	26.19	26.33	760209.0
2015-01-21	BAB	ETF	30.98	31.11	30.8201	30.9	200334.0
2015-01-21	BAL	ETF	39.37	39.54	39.22	39.32	18902.0
2015-01-21	BALT	ETF	1.74	1.805	1.71	1.77	352335.0
2015-01-21	BAR	ETF	3.623	3.623	3.463	3.508	145970.0
2015-01-21	BBC	ETF	29.27	29.27	27.91	27.95	10250.0
2015-01-21	BBH	ETF	123.47	123.9	122.19	122.54	183300.0
2015-01-21	BBP	ETF	28.13	28.2	27.58	27.58	6900.0
2015-01-21	BCHP	ETF	18.124	18.124	18.124	18.124	1193.0
2015-01-21	BCM	ETF	31.1	31.1	30.95	30.97	11082.0
2015-01-21	BFOR	ETF	7.65	7.72	7.65	7.7	156000.0

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

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