PREVIEW / etf_daily / 2018-12-04

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-04.parquet
  size:    65 KB
  rows:    1,699

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
2018-12-04	SPY	ETF	278.37	278.85	269.9	270.25	177986000.0
2018-12-04	QQQ	ETF	171.38	171.91	165.52	165.72	70594743.0
2018-12-04	IWM	ETF	153.75	154.13	147.14	147.52	41077900.0
2018-12-04	DIA	ETF	257.64	258.04	250.38	250.73	5376900.0
2018-12-04	GLD	ETF	117.37	117.39	116.93	117.12	7186100.0
2018-12-04	TLT	ETF	116.81	118.67	116.63	117.82	18100500.0
2018-12-04	AAAU	ETF	12.41	12.41	12.37	12.38	3600.0
2018-12-04	AADR	ETF	45.42	45.42	44.15	44.17	199200.0
2018-12-04	AAXJ	ETF	68.23	68.36	66.7	66.88	1034800.0
2018-12-04	ACES	ETF	25.568	25.6	25.305	25.305	7800.0
2018-12-04	ACSI	ETF	32.9	33.1299	32.21	32.21	2280.0
2018-12-04	ACTX	ETF	61.9506	62.5406	59.0005	61.3606	694.0
2018-12-04	ACWF	ETF	28.68	28.74	28.0	28.0	3040497.0
2018-12-04	ACWI	ETF	70.54	70.62	68.67	68.75	4112400.0
2018-12-04	ACWV	ETF	86.89	87.05	85.59	85.64	286700.0
2018-12-04	ACWX	ETF	45.03	45.07	44.06	44.1	3602429.0
2018-12-04	ADRE	ETF	39.06	39.06	38.3047	38.3047	2122.0
2018-12-04	AFIF	ETF	10.0013	10.0027	9.97	9.97	35747.0
2018-12-04	AFK	ETF	20.94	20.94	20.521	20.521	2208.0
2018-12-04	AFTY	ETF	14.82	14.82	14.45	14.51	13900.0
2018-12-04	AGG	ETF	104.98	105.28	104.94	105.08	5365200.0
2018-12-04	AGGY	ETF	47.68	47.78	47.62	47.64	74900.0
2018-12-04	AGNG	ETF	21.176	21.176	21.176	21.176	500.0
2018-12-04	AGQ	ETF	23.74	23.87	23.38	23.39	193900.0
2018-12-04	AGZ	ETF	110.9	111.08	110.801	111.06	50286.0
2018-12-04	AGZD	ETF	23.815	23.815	23.745	23.785	7400.0
2018-12-04	AIA	ETF	59.5	59.51	58.1	58.17	46333.0
2018-12-04	AIEQ	ETF	26.92	26.92	25.96	26.0	130700.0
2018-12-04	AIQ	ETF	14.39	14.39	13.91	13.91	4195.0
2018-12-04	AIRR	ETF	25.13	25.13	23.73	23.73	19200.0
2018-12-04	AIVI	ETF	39.99	40.03	39.27	39.29	10700.0
2018-12-04	ALTY	ETF	14.652	14.66	14.449	14.449	15900.0
2018-12-04	AMJ	ETF	25.4	25.45	24.52	24.55	1723694.0
2018-12-04	AMLP	ETF	49.15	49.2	47.7	47.8	3869740.0
2018-12-04	AMZA	ETF	63.1	63.24	60.97	61.0	57730.0
2018-12-04	ANGL	ETF	27.4	27.52	27.36	27.39	750300.0
2018-12-04	AOA	ETF	52.25	52.25	51.11	51.11	151100.0
2018-12-04	AOK	ETF	33.46	33.51	33.18	33.23	80122.0
2018-12-04	AOM	ETF	36.89	36.94	36.53	36.59	622970.0
2018-12-04	AOR	ETF	43.5	43.61	42.83	42.89	571407.0
2018-12-04	ARGT	ETF	26.47	26.47	25.79	25.97	154900.0
2018-12-04	ARKG	ETF	30.64	30.84	29.02	29.03	130900.0
2018-12-04	ARKK	ETF	45.3	45.54	43.21	43.27	263000.0
2018-12-04	ARKQ	ETF	34.2	34.2	32.56	32.65	17600.0
2018-12-04	ARKW	ETF	55.16	55.17	52.59	52.72	135700.0
2018-12-04	ARVR	ETF	18.015	18.02	18.0	18.015	1587.0
2018-12-04	ASEA	ETF	16.18	16.18	16.0	16.0	700.0
2018-12-04	ASET	ETF	27.1469	27.1469	26.94	26.95	6700.0
2018-12-04	ASHR	ETF	24.33	24.38	23.85	23.89	2795900.0
2018-12-04	ASHS	ETF	24.38	24.4	23.91	23.91	15800.0

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

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