PREVIEW / etf_daily / 2019-10-22

all etf daily files

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

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-22	SPY	ETF	300.58	300.9	298.91	299.01	48594700.0
2019-10-22	QQQ	ETF	194.06	194.42	191.79	191.85	22988988.0
2019-10-22	IWM	ETF	154.2	155.05	153.74	154.21	12471800.0
2019-10-22	DIA	ETF	268.48	269.38	267.76	267.82	2534300.0
2019-10-22	GLD	ETF	140.13	140.3	139.72	140.2	3879700.0
2019-10-22	TLT	ETF	139.38	139.53	138.64	139.34	6683300.0
2019-10-22	AAAU	ETF	14.85	14.89	14.8	14.85	64100.0
2019-10-22	AADR	ETF	48.52	48.55	48.18	48.33	6300.0
2019-10-22	AAXJ	ETF	68.78	68.9	68.59	68.68	835400.0
2019-10-22	ACES	ETF	31.51	31.53	31.014	31.014	14200.0
2019-10-22	ACIO	ETF	24.724	24.77	24.721	24.728	9900.0
2019-10-22	ACSI	ETF	34.1771	34.3892	34.1771	34.3173	951.0
2019-10-22	ACTX	ETF	10.8561	11.6821	10.8561	11.3576	165.0
2019-10-22	ACWF	ETF	29.4	29.54	29.35	29.3768	11136.0
2019-10-22	ACWI	ETF	75.07	75.2	74.76	74.76	1683500.0
2019-10-22	ACWV	ETF	95.51	95.56	95.0	95.0	216000.0
2019-10-22	ACWX	ETF	47.14	47.2799	47.02	47.05	962438.0
2019-10-22	ADRE	ETF	39.8165	39.8165	39.55	39.56	9738.0
2019-10-22	AFIF	ETF	9.77	9.77	9.67	9.73	31551.0
2019-10-22	AFK	ETF	20.36	20.7	20.36	20.57	7606.0
2019-10-22	AFTY	ETF	17.405	17.45	17.4	17.419	3600.0
2019-10-22	AGG	ETF	112.65	112.74	112.51	112.66	2147400.0
2019-10-22	AGGY	ETF	52.12	52.25	52.001	52.06	140000.0
2019-10-22	AGNG	ETF	21.9	22.06	21.872	21.99	3500.0
2019-10-22	AGQ	ETF	31.06	31.28	30.74	31.0	172800.0
2019-10-22	AGZ	ETF	116.07	116.13	116.01	116.13	15038.0
2019-10-22	AGZD	ETF	23.895	23.895	23.83	23.885	4000.0
2019-10-22	AIA	ETF	60.97	61.142	60.97	60.98	10981.0
2019-10-22	AIEQ	ETF	26.6	26.6	26.23	26.262	17200.0
2019-10-22	AIQ	ETF	16.05	16.0804	15.8607	15.8607	6880.0
2019-10-22	AIRR	ETF	27.804	27.935	27.804	27.935	1700.0
2019-10-22	AIVI	ETF	41.55	41.62	41.4	41.4	4400.0
2019-10-22	ALTY	ETF	14.88	14.92	14.833	14.879	9900.0
2019-10-22	AMJ	ETF	22.2	22.45	22.105	22.15	735480.0
2019-10-22	AMLP	ETF	43.7	44.1	43.4	43.55	2561440.0
2019-10-22	AMUB	ETF	13.9706	13.9706	13.9706	13.9706	0.0
2019-10-22	AMZA	ETF	45.9	46.6	45.7	46.0	54310.0
2019-10-22	ANGL	ETF	29.37	29.37	29.3	29.33	260800.0
2019-10-22	AOA	ETF	55.45	55.57	55.33	55.33	21100.0
2019-10-22	AOK	ETF	35.63	35.72	35.6203	35.6583	55449.0
2019-10-22	AOM	ETF	39.2	39.32	39.2	39.21	100290.0
2019-10-22	AOR	ETF	46.31	46.34	46.14	46.14	112710.0
2019-10-22	ARCM	ETF	100.23	100.23	100.185	100.185	400.0
2019-10-22	ARGT	ETF	22.56	22.71	22.25	22.31	43900.0
2019-10-22	ARKF	ETF	21.93	21.95	21.603	21.603	5000.0
2019-10-22	ARKG	ETF	29.19	29.49	28.559	28.61	63300.0
2019-10-22	ARKK	ETF	42.63	42.74	41.88	41.93	186700.0
2019-10-22	ARKQ	ETF	32.336	32.442	32.23	32.28	5800.0
2019-10-22	ARKW	ETF	49.83	49.95	49.0	49.03	27700.0
2019-10-22	ASEA	ETF	15.76	15.79	15.74	15.76	2200.0

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

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