PREVIEW / etf_daily / 2019-01-07

all etf daily files

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

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-07	SPY	ETF	252.69	255.95	251.69	254.38	103139100.0
2019-01-07	QQQ	ETF	156.54	158.86	156.11	158.09	52059331.0
2019-01-07	IWM	ETF	137.26	140.37	136.74	139.59	30477900.0
2019-01-07	DIA	ETF	234.84	236.88	232.95	235.36	5101600.0
2019-01-07	GLD	ETF	122.16	122.22	121.57	121.86	7473600.0
2019-01-07	TLT	ETF	122.62	122.65	121.62	121.75	8498100.0
2019-01-07	AAAU	ETF	12.92	12.93	12.87	12.88	24500.0
2019-01-07	AADR	ETF	41.72	42.07	41.55	41.92	17700.0
2019-01-07	AAXJ	ETF	63.62	64.18	63.5	64.01	1060900.0
2019-01-07	ACES	ETF	23.69	23.69	23.574	23.574	2700.0
2019-01-07	ACSI	ETF	29.5076	29.74	29.5076	29.74	1213.0
2019-01-07	ACTX	ETF	51.9205	54.8705	48.9704	52.5105	364.0
2019-01-07	ACWF	ETF	26.3799	26.58	26.31	26.49	102052.0
2019-01-07	ACWI	ETF	65.11	65.78	64.93	65.46	3630900.0
2019-01-07	ACWV	ETF	81.73	82.31	81.54	81.88	205300.0
2019-01-07	ACWX	ETF	42.67	42.96	42.55	42.76	5497548.0
2019-01-07	ADRE	ETF	37.1	37.396	36.9	37.18	51487.0
2019-01-07	AFIF	ETF	9.9	9.94	9.88	9.92	40168.0
2019-01-07	AFK	ETF	20.12	20.2	20.12	20.1797	5593.0
2019-01-07	AFTY	ETF	13.41	13.41	13.3	13.385	4400.0
2019-01-07	AGG	ETF	106.72	106.79	106.46	106.51	7433700.0
2019-01-07	AGGY	ETF	48.37	48.43	48.31	48.35	64000.0
2019-01-07	AGNG	ETF	19.52	19.85	19.52	19.736	700.0
2019-01-07	AGQ	ETF	27.25	27.25	26.82	26.83	79000.0
2019-01-07	AGZ	ETF	112.41	112.41	112.1101	112.1456	87323.0
2019-01-07	AGZD	ETF	23.675	23.765	23.57	23.67	28400.0
2019-01-07	AIA	ETF	55.14	55.5999	55.005	55.45	57487.0
2019-01-07	AIEQ	ETF	22.33	22.829	22.33	22.61	31000.0
2019-01-07	AIQ	ETF	13.25	13.5	13.2	13.43	10728.0
2019-01-07	AIRR	ETF	22.31	22.808	22.25	22.69	20400.0
2019-01-07	AIVI	ETF	38.62	38.89	38.62	38.79	2800.0
2019-01-07	ALTY	ETF	13.86	13.92	13.71	13.89	15200.0
2019-01-07	AMJ	ETF	24.15	24.62	23.9715	24.31	4441637.0
2019-01-07	AMLP	ETF	47.5	48.4	47.1	47.8	5773780.0
2019-01-07	AMUB	ETF	15.2873	15.2873	15.2873	15.2873	0.0
2019-01-07	AMZA	ETF	56.1	57.9	56.1	56.6	90790.0
2019-01-07	ANGL	ETF	27.3	27.55	27.17	27.55	995400.0
2019-01-07	AOA	ETF	49.2	49.58	49.12	49.34	324400.0
2019-01-07	AOK	ETF	32.95	33.03	32.9001	32.96	172217.0
2019-01-07	AOM	ETF	35.99	36.066	35.89	35.98	428416.0
2019-01-07	AOR	ETF	41.69	41.9101	41.6112	41.75	519740.0
2019-01-07	ARGT	ETF	24.79	25.33	24.79	25.24	48200.0
2019-01-07	ARKG	ETF	26.56	27.52	26.349	27.32	212600.0
2019-01-07	ARKK	ETF	38.67	40.33	38.39	40.1	524500.0
2019-01-07	ARKQ	ETF	29.68	30.65	29.68	30.43	11300.0
2019-01-07	ARKW	ETF	43.73	45.238	43.695	45.0	134400.0
2019-01-07	ASEA	ETF	15.57	15.83	15.57	15.74	12400.0
2019-01-07	ASET	ETF	25.95	25.99	25.95	25.99	350.0
2019-01-07	ASHR	ETF	22.4	22.48	22.26	22.41	865300.0
2019-01-07	ASHS	ETF	23.01	23.1	23.01	23.05	8700.0

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

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