PREVIEW / etf_daily / 2019-01-10

all etf daily files

  file:    by_date/etf_daily/2019/2019-01-10.parquet
  size:    67 KB
  rows:    1,741

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
2019-01-10	SPY	ETF	256.26	259.16	255.5	258.88	96823900.0
2019-01-10	QQQ	ETF	159.59	161.37	158.7	161.28	38943414.0
2019-01-10	IWM	ETF	142.06	143.72	141.35	143.64	22896800.0
2019-01-10	DIA	ETF	237.64	240.16	237.04	240.0	3052200.0
2019-01-10	GLD	ETF	121.98	122.18	121.57	121.59	6672000.0
2019-01-10	TLT	ETF	121.28	121.41	120.34	120.46	8222900.0
2019-01-10	AAAU	ETF	12.9	12.91	12.86	12.86	536200.0
2019-01-10	AADR	ETF	42.81	42.97	42.31	42.96	17800.0
2019-01-10	AAXJ	ETF	64.98	65.78	64.97	65.74	877200.0
2019-01-10	ACES	ETF	24.39	24.478	24.32	24.478	6000.0
2019-01-10	ACSI	ETF	29.7517	30.17	29.724	30.17	9078.0
2019-01-10	ACTX	ETF	42.4804	56.0505	41.3004	52.2155	608.0
2019-01-10	ACWF	ETF	26.97	27.22	26.8999	27.14	44188.0
2019-01-10	ACWI	ETF	66.22	66.86	66.08	66.86	3110900.0
2019-01-10	ACWV	ETF	82.25	83.11	82.25	83.11	410700.0
2019-01-10	ACWX	ETF	43.41	43.81	43.395	43.78	2222218.0
2019-01-10	ADRE	ETF	38.25	38.3906	38.16	38.3906	2431.0
2019-01-10	AFIF	ETF	9.925	9.97	9.92	9.9451	11303.0
2019-01-10	AFK	ETF	20.2	20.72	20.2	20.57	13576.0
2019-01-10	AFTY	ETF	13.66	13.696	13.66	13.68	7000.0
2019-01-10	AGG	ETF	106.52	106.56	106.33	106.4	3532500.0
2019-01-10	AGGY	ETF	48.35	48.38	48.31	48.36	71900.0
2019-01-10	AGNG	ETF	19.87	20.1	19.87	20.1	400.0
2019-01-10	AGQ	ETF	26.87	26.97	26.53	26.54	122700.0
2019-01-10	AGZ	ETF	112.2	112.2	112.03	112.03	9328.0
2019-01-10	AGZD	ETF	23.77	23.815	23.68	23.75	18400.0
2019-01-10	AIA	ETF	56.43	57.2	56.4171	57.2	115908.0
2019-01-10	AIEQ	ETF	23.07	23.35	23.0	23.34	35100.0
2019-01-10	AIQ	ETF	13.72	13.78	13.56	13.77	11834.0
2019-01-10	AIRR	ETF	23.0	23.35	23.0	23.35	22500.0
2019-01-10	AIVI	ETF	39.15	39.41	39.15	39.41	5700.0
2019-01-10	ALTY	ETF	14.033	14.08	14.0	14.08	900.0
2019-01-10	AMJ	ETF	25.04	25.17	24.62	24.77	2874822.0
2019-01-10	AMLP	ETF	49.45	49.45	48.15	48.75	10799160.0
2019-01-10	AMUB	ETF	15.83	15.83	15.6133	15.6133	101.0
2019-01-10	AMZA	ETF	59.3	59.5	58.2	58.8	88070.0
2019-01-10	ANGL	ETF	27.8	27.94	27.7	27.94	174200.0
2019-01-10	AOA	ETF	49.8	50.17	49.74	50.15	110200.0
2019-01-10	AOK	ETF	33.04	33.16	33.0	33.15	133554.0
2019-01-10	AOM	ETF	36.18	36.29	36.12	36.28	408753.0
2019-01-10	AOR	ETF	42.07	42.29	42.0463	42.28	239007.0
2019-01-10	ARCM	ETF	99.7	99.775	99.7	99.775	40000.0
2019-01-10	ARGT	ETF	25.91	26.26	25.91	26.14	15300.0
2019-01-10	ARKG	ETF	27.62	28.13	27.34	28.11	98300.0
2019-01-10	ARKK	ETF	41.2	41.7	40.502	41.69	335100.0
2019-01-10	ARKQ	ETF	31.32	31.36	30.66	31.36	11600.0
2019-01-10	ARKW	ETF	46.01	46.8	45.448	46.76	135300.0
2019-01-10	ASEA	ETF	15.95	16.17	15.95	16.03	60800.0
2019-01-10	ASET	ETF	26.52	26.6463	26.52	26.639	4126.0
2019-01-10	ASHR	ETF	22.74	22.9	22.71	22.88	787900.0

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

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