PREVIEW / etf_daily / 2019-08-08

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-08.parquet
  size:    71 KB
  rows:    1,850

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-08-08	SPY	ETF	289.62	293.62	289.01	293.62	87713900.0
2019-08-08	QQQ	ETF	185.15	188.32	184.57	188.26	38418084.0
2019-08-08	IWM	ETF	150.15	152.63	149.99	152.54	19415600.0
2019-08-08	DIA	ETF	261.46	264.13	260.58	264.13	3637100.0
2019-08-08	GLD	ETF	140.9	142.37	140.71	141.73	13108600.0
2019-08-08	TLT	ETF	139.14	140.43	137.98	140.33	14746000.0
2019-08-08	AAAU	ETF	14.92	15.06	14.9	15.0	84300.0
2019-08-08	AADR	ETF	50.12	50.7	50.0	50.7	6700.0
2019-08-08	AAXJ	ETF	64.69	65.06	64.49	64.98	1890800.0
2019-08-08	ACES	ETF	32.5	32.5	31.133	31.53	5700.0
2019-08-08	ACIO	ETF	24.348	24.53	24.348	24.53	10000.0
2019-08-08	ACSI	ETF	33.58	33.82	33.56	33.82	1100.0
2019-08-08	ACTX	ETF	16.8152	19.7652	16.8152	18.5852	634.0
2019-08-08	ACWF	ETF	28.17	28.4866	28.17	28.4866	11875.0
2019-08-08	ACWI	ETF	71.75	72.55	71.65	72.47	4058700.0
2019-08-08	ACWV	ETF	92.38	93.24	92.17	93.16	348300.0
2019-08-08	ACWX	ETF	44.73	45.055	44.65	44.99	2153818.0
2019-08-08	ADRE	ETF	37.9	38.0099	37.7595	37.9689	7436.0
2019-08-08	AFIF	ETF	9.6532	9.6707	9.645	9.6707	7763.0
2019-08-08	AFK	ETF	20.47	20.5	20.2101	20.28	6648.0
2019-08-08	AFTY	ETF	16.42	16.45	16.42	16.43	16600.0
2019-08-08	AGG	ETF	112.51	112.82	112.33	112.79	3707200.0
2019-08-08	AGGY	ETF	52.02	52.18	51.96	52.16	83400.0
2019-08-08	AGNG	ETF	21.55	21.56	21.55	21.55	800.0
2019-08-08	AGQ	ETF	29.58	30.39	29.47	30.03	533000.0
2019-08-08	AGZ	ETF	116.16	116.29	116.0701	116.29	15533.0
2019-08-08	AGZD	ETF	23.795	23.875	23.795	23.875	24200.0
2019-08-08	AIA	ETF	56.74	57.15	56.65	57.15	16729.0
2019-08-08	AIEQ	ETF	25.58	26.18	25.58	26.07	67600.0
2019-08-08	AIQ	ETF	15.98	16.1009	15.9	16.1009	4285.0
2019-08-08	AIRR	ETF	25.43	25.767	25.43	25.74	3700.0
2019-08-08	AIVI	ETF	39.62	39.84	39.6	39.81	7900.0
2019-08-08	ALTY	ETF	14.92	14.92	14.68	14.88	478700.0
2019-08-08	AMJ	ETF	23.47	23.6823	23.35	23.68	1574270.0
2019-08-08	AMLP	ETF	45.3	45.45	44.9	45.45	3135760.0
2019-08-08	AMOM	ETF	26.541	26.541	26.541	26.541	800.0
2019-08-08	AMUB	ETF	14.8738	14.8738	14.8738	14.8738	0.0
2019-08-08	AMZA	ETF	49.3	49.9	48.7	49.5	136690.0
2019-08-08	ANGL	ETF	28.82	28.97	28.82	28.92	304100.0
2019-08-08	AOA	ETF	53.59	54.06	53.57	54.06	27900.0
2019-08-08	AOK	ETF	35.28	35.3853	35.21	35.32	149245.0
2019-08-08	AOM	ETF	38.62	38.85	38.6	38.85	150977.0
2019-08-08	AOR	ETF	45.08	45.43	45.05	45.41	61387.0
2019-08-08	ARCM	ETF	100.175	100.175	100.175	100.175	7500.0
2019-08-08	ARGT	ETF	31.5	32.16	31.5	32.15	13800.0
2019-08-08	ARKF	ETF	21.62	21.789	21.449	21.78	33800.0
2019-08-08	ARKG	ETF	32.55	33.17	32.45	33.13	115200.0
2019-08-08	ARKK	ETF	45.3	45.95	45.0	45.89	394500.0
2019-08-08	ARKQ	ETF	30.78	31.23	30.6	31.17	204400.0
2019-08-08	ARKW	ETF	50.0	50.847	49.68	50.847	42800.0

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

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