PREVIEW / etf_daily / 2019-01-29

all etf daily files

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

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-29	SPY	ETF	263.92	264.55	262.48	263.41	66136300.0
2019-01-29	QQQ	ETF	163.2	163.24	160.99	161.57	30784175.0
2019-01-29	IWM	ETF	146.71	146.82	145.88	146.2	12084800.0
2019-01-29	DIA	ETF	245.35	246.65	244.95	245.71	2432900.0
2019-01-29	GLD	ETF	123.71	124.0	123.46	123.98	11610200.0
2019-01-29	TLT	ETF	120.53	121.04	120.39	121.02	5750100.0
2019-01-29	AAAU	ETF	13.08	13.11	13.06	13.11	18800.0
2019-01-29	AADR	ETF	43.26	43.38	43.08	43.24	9800.0
2019-01-29	AAXJ	ETF	67.41	67.42	66.99	67.09	1692700.0
2019-01-29	ACES	ETF	24.93	24.93	24.897	24.897	1500.0
2019-01-29	ACSI	ETF	30.8597	30.87	30.7809	30.7809	2836.0
2019-01-29	ACTX	ETF	48.3804	49.5604	47.2004	47.7904	474.0
2019-01-29	ACWF	ETF	28.03	28.0482	27.93	28.0	45636.0
2019-01-29	ACWI	ETF	68.08	68.18	67.77	67.91	3944000.0
2019-01-29	ACWV	ETF	84.04	84.17	83.87	84.06	420000.0
2019-01-29	ACWX	ETF	44.58	44.66	44.45	44.46	2559511.0
2019-01-29	ADRE	ETF	38.7035	38.7035	38.51	38.51	3164.0
2019-01-29	AFIF	ETF	9.94	10.0098	9.94	9.975	18977.0
2019-01-29	AFK	ETF	21.0	21.11	21.0	21.09	6465.0
2019-01-29	AFTY	ETF	14.465	14.49	14.465	14.49	700.0
2019-01-29	AGG	ETF	106.73	106.93	106.69	106.9	6158600.0
2019-01-29	AGGY	ETF	48.57	48.61	48.52	48.61	27500.0
2019-01-29	AGNG	ETF	20.41	20.41	20.41	20.41	300.0
2019-01-29	AGQ	ETF	27.49	27.58	27.31	27.39	102400.0
2019-01-29	AGZ	ETF	112.11	112.3	112.1	112.27	981643.0
2019-01-29	AGZD	ETF	23.68	23.76	23.68	23.73	10400.0
2019-01-29	AIA	ETF	59.36	59.36	59.03	59.13	10234.0
2019-01-29	AIEQ	ETF	24.16	24.22	24.0	24.02	27800.0
2019-01-29	AIQ	ETF	14.17	14.18	14.01	14.03	12972.0
2019-01-29	AIRR	ETF	23.59	23.697	23.58	23.58	60600.0
2019-01-29	AIVI	ETF	39.9	39.92	39.83	39.84	7800.0
2019-01-29	ALTY	ETF	14.509	14.511	14.45	14.464	11400.0
2019-01-29	AMJ	ETF	24.74	25.07	24.72	24.94	3002018.0
2019-01-29	AMLP	ETF	48.85	49.4	48.7	49.05	3574720.0
2019-01-29	AMUB	ETF	15.74	15.74	15.7375	15.7375	200.0
2019-01-29	AMZA	ETF	57.8	58.9	57.7	58.6	86010.0
2019-01-29	ANGL	ETF	27.88	27.94	27.79	27.8	317200.0
2019-01-29	AOA	ETF	50.92	51.0	50.77	50.83	379700.0
2019-01-29	AOK	ETF	33.43	33.45	33.38	33.41	196479.0
2019-01-29	AOM	ETF	36.65	36.66	36.5689	36.59	1047584.0
2019-01-29	AOR	ETF	42.85	42.85	42.6965	42.75	284470.0
2019-01-29	ARCM	ETF	100.075	100.075	100.075	100.075	50000.0
2019-01-29	ARGT	ETF	27.17	27.25	27.02	27.21	39900.0
2019-01-29	ARKG	ETF	27.33	27.39	26.87	27.08	119800.0
2019-01-29	ARKK	ETF	41.76	41.845	41.13	41.25	231000.0
2019-01-29	ARKQ	ETF	31.6	32.03	31.6	31.817	9700.0
2019-01-29	ARKW	ETF	48.06	48.06	47.0	47.19	99900.0
2019-01-29	ASEA	ETF	15.96	16.05	15.96	15.97	3700.0
2019-01-29	ASET	ETF	27.47	27.5036	27.47	27.4926	2080.0
2019-01-29	ASHR	ETF	23.79	23.83	23.67	23.7	1116900.0

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

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