PREVIEW / etf_daily / 2019-10-17

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-17.parquet
  size:    71 KB
  rows:    1,840

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-10-17	SPY	ETF	299.68	300.24	298.52	299.28	45736600.0
2019-10-17	QQQ	ETF	194.18	194.5	192.81	193.55	19161821.0
2019-10-17	IWM	ETF	152.29	153.51	152.05	153.34	13175800.0
2019-10-17	DIA	ETF	270.67	271.15	269.71	270.38	1883400.0
2019-10-17	GLD	ETF	140.5	141.12	140.42	140.61	6131000.0
2019-10-17	TLT	ETF	139.52	140.38	139.3	139.58	6219300.0
2019-10-17	AAAU	ETF	14.9	14.93	14.88	14.88	88300.0
2019-10-17	AADR	ETF	48.73	48.73	48.55	48.66	900.0
2019-10-17	AAXJ	ETF	68.92	68.92	68.57	68.71	693100.0
2019-10-17	ACES	ETF	30.96	31.26	30.95	31.05	8900.0
2019-10-17	ACIO	ETF	24.67	24.67	24.66	24.67	6200.0
2019-10-17	ACSI	ETF	34.0929	34.158	34.0929	34.158	877.0
2019-10-17	ACTX	ETF	11.8001	12.9801	11.8001	12.9801	115.0
2019-10-17	ACWF	ETF	29.24	29.3309	29.2245	29.2433	3580.0
2019-10-17	ACWI	ETF	74.87	74.96	74.57	74.71	1954200.0
2019-10-17	ACWV	ETF	95.22	95.34	95.05	95.16	184800.0
2019-10-17	ACWX	ETF	47.03	47.04	46.8	46.87	1073570.0
2019-10-17	ADRE	ETF	40.13	40.13	39.7511	39.7716	3180.0
2019-10-17	AFIF	ETF	9.73	9.7479	9.71	9.725	4426.0
2019-10-17	AFK	ETF	20.4	20.53	20.4	20.53	13269.0
2019-10-17	AFTY	ETF	17.58	17.62	17.58	17.609	6000.0
2019-10-17	AGG	ETF	112.67	112.86	112.62	112.72	2316400.0
2019-10-17	AGGY	ETF	52.12	52.25	52.12	52.16	84000.0
2019-10-17	AGNG	ETF	21.648	21.753	21.64	21.753	2300.0
2019-10-17	AGQ	ETF	31.1	31.48	30.98	31.12	143600.0
2019-10-17	AGZ	ETF	116.15	116.2599	116.1104	116.15	24166.0
2019-10-17	AGZD	ETF	23.91	23.96	23.885	23.96	8000.0
2019-10-17	AIA	ETF	61.1	61.14	60.83	60.88	32909.0
2019-10-17	AIEQ	ETF	26.44	26.56	26.44	26.53	24900.0
2019-10-17	AIQ	ETF	16.14	16.14	16.08	16.11	12401.0
2019-10-17	AIRR	ETF	26.92	27.26	26.92	27.26	4600.0
2019-10-17	AIVI	ETF	41.32	41.38	41.13	41.22	4800.0
2019-10-17	ALTY	ETF	14.73	14.758	14.703	14.73	8400.0
2019-10-17	AMJ	ETF	22.18	22.2	22.0	22.0	2959285.0
2019-10-17	AMLP	ETF	43.65	43.75	43.3	43.3	3096520.0
2019-10-17	AMUB	ETF	13.8902	13.8902	13.8902	13.8902	0.0
2019-10-17	AMZA	ETF	46.5	46.65	46.2	46.3	39970.0
2019-10-17	ANGL	ETF	29.36	29.4	29.31	29.35	224000.0
2019-10-17	AOA	ETF	55.34	55.38	55.18	55.23	21300.0
2019-10-17	AOK	ETF	35.64	35.6761	35.6044	35.65	62919.0
2019-10-17	AOM	ETF	39.18	39.26	39.16	39.17	109494.0
2019-10-17	AOR	ETF	46.19	46.2316	46.1	46.1	90387.0
2019-10-17	ARCM	ETF	100.23	100.23	100.23	100.23	1300.0
2019-10-17	ARGT	ETF	22.92	23.0	22.67	22.74	20800.0
2019-10-17	ARKF	ETF	21.98	21.98	21.887	21.915	6900.0
2019-10-17	ARKG	ETF	29.21	29.21	28.93	29.07	74100.0
2019-10-17	ARKK	ETF	42.88	43.09	42.77	42.881	154200.0
2019-10-17	ARKQ	ETF	32.681	32.71	32.433	32.51	11400.0
2019-10-17	ARKW	ETF	50.17	50.45	50.17	50.41	41300.0
2019-10-17	ASEA	ETF	15.78	15.81	15.67	15.67	1300.0

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

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