PREVIEW / etf_daily / 2020-02-11

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-11.parquet
  size:    74 KB
  rows:    1,946

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
2020-02-11	SPY	ETF	336.16	337.02	334.68	335.26	54864500.0
2020-02-11	QQQ	ETF	233.21	234.02	231.3999	232.01	30197983.0
2020-02-11	IWM	ETF	166.79	167.96	166.27	166.96	15005600.0
2020-02-11	DIA	ETF	294.35	294.42	292.28	292.94	1994500.0
2020-02-11	GLD	ETF	148.03	148.16	147.01	147.66	5179400.0
2020-02-11	TLT	ETF	144.59	144.72	143.94	144.1	7784100.0
2020-02-11	AAAU	ETF	15.69	15.69	15.59	15.65	45100.0
2020-02-11	AADR	ETF	55.83	56.08	55.68	55.88	8800.0
2020-02-11	AAXJ	ETF	72.88	73.28	72.81	72.94	1775600.0
2020-02-11	ABEQ	ETF	25.16	25.178	25.15	25.165	4500.0
2020-02-11	ACES	ETF	39.83	39.92	39.47	39.775	38700.0
2020-02-11	ACIO	ETF	25.466	25.466	25.43	25.438	12900.0
2020-02-11	ACSI	ETF	37.145	37.26	37.137	37.137	1646.0
2020-02-11	ACTX	ETF	6.4901	8.2011	6.4901	7.1538	111.0
2020-02-11	ACWF	ETF	31.65	31.7305	31.56	31.67	17779.0
2020-02-11	ACWI	ETF	81.22	81.49	81.04	81.19	2964000.0
2020-02-11	ACWV	ETF	99.25	99.26	98.93	99.02	231700.0
2020-02-11	ACWX	ETF	49.05	49.19	48.93	49.0	3224072.0
2020-02-11	ADME	ETF	31.51	31.51	31.47	31.47	4100.0
2020-02-11	ADRE	ETF	43.65	44.0612	43.65	43.815	27524.0
2020-02-11	AESR	ETF	10.514	10.61	10.5	10.507	7600.0
2020-02-11	AFIF	ETF	9.745	9.755	9.745	9.7458	1107.0
2020-02-11	AFK	ETF	19.43	19.59	19.4007	19.4572	5820.0
2020-02-11	AFLG	ETF	21.127	21.127	21.122	21.122	100.0
2020-02-11	AFTY	ETF	16.48	16.557	16.42	16.446	3300.0
2020-02-11	AGG	ETF	114.35	114.35	114.19	114.21	5633400.0
2020-02-11	AGGY	ETF	53.26	53.27	53.22	53.23	253800.0
2020-02-11	AGNG	ETF	24.42	24.713	24.42	24.542	900.0
2020-02-11	AGQ	ETF	30.73	30.82	30.28	30.56	166800.0
2020-02-11	AGZ	ETF	117.09	117.09	116.9665	117.0	47753.0
2020-02-11	AGZD	ETF	23.97	24.075	23.945	24.025	16600.0
2020-02-11	AIA	ETF	66.07	66.54	66.07	66.28	315606.0
2020-02-11	AIEQ	ETF	29.88	29.95	29.76	29.81	43100.0
2020-02-11	AIQ	ETF	19.55	19.7177	19.52	19.5718	25009.0
2020-02-11	AIRR	ETF	28.83	29.271	28.83	29.128	46700.0
2020-02-11	AIVI	ETF	42.0	42.0	41.88	41.91	5600.0
2020-02-11	ALTY	ETF	14.88	14.94	14.88	14.915	39000.0
2020-02-11	AMJ	ETF	20.33	20.4001	20.2212	20.33	2240567.0
2020-02-11	AMLP	ETF	39.7	39.8	39.45	39.7	5486380.0
2020-02-11	AMOM	ETF	27.394	27.394	27.394	27.394	100.0
2020-02-11	AMUB	ETF	12.7473	12.755	12.7473	12.755	183.0
2020-02-11	AMZA	ETF	39.7	39.89	39.5	39.6	57650.0
2020-02-11	ANGL	ETF	30.27	30.38	30.25	30.33	560300.0
2020-02-11	AOA	ETF	59.18	59.28	59.04	59.08	48700.0
2020-02-11	AOK	ETF	36.9	36.9191	36.83	36.86	50217.0
2020-02-11	AOM	ETF	40.87	40.9517	40.8016	40.81	120446.0
2020-02-11	AOR	ETF	48.67	48.8231	48.6661	48.71	104339.0
2020-02-11	ARCM	ETF	100.12	100.12	100.12	100.12	100.0
2020-02-11	ARGT	ETF	25.8	25.8	25.32	25.47	23400.0
2020-02-11	ARKF	ETF	26.57	26.74	26.5	26.55	49100.0

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

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