PREVIEW / etf_daily / 2020-06-10

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-10.parquet
  size:    76 KB
  rows:    2,022

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-06-10	SPY	ETF	321.42	322.39	318.22	319.0	95000800.0
2020-06-10	QQQ	ETF	245.0	247.815	244.51	246.22	58084410.0
2020-06-10	IWM	ETF	150.09	150.26	145.9	146.18	51774500.0
2020-06-10	DIA	ETF	273.2	274.18	270.01	270.46	6531200.0
2020-06-10	GLD	ETF	162.1	163.63	160.52	163.57	13009300.0
2020-06-10	TLT	ETF	159.24	160.9	159.05	160.84	13135500.0
2020-06-10	AAAU	ETF	17.2	17.35	17.08	17.35	316900.0
2020-06-10	AADR	ETF	50.93	51.34	50.71	51.34	14300.0
2020-06-10	AAXJ	ETF	70.0	70.55	69.64	70.45	1203000.0
2020-06-10	ABEQ	ETF	23.0	23.022	22.987	22.987	800.0
2020-06-10	ACES	ETF	39.55	39.55	38.741	39.155	40200.0
2020-06-10	ACIO	ETF	25.15	25.2	25.045	25.099	63200.0
2020-06-10	ACSI	ETF	34.98	34.98	34.6466	34.6466	338.0
2020-06-10	ACTX	ETF	4.248	4.72	4.248	4.4604	756.0
2020-06-10	ACWF	ETF	29.0	29.0	28.741	28.8595	36848.0
2020-06-10	ACWI	ETF	76.81	77.11	76.2	76.45	3593800.0
2020-06-10	ACWV	ETF	91.14	91.59	90.67	91.35	407800.0
2020-06-10	ACWX	ETF	45.12	45.27	44.72	44.91	2029098.0
2020-06-10	ADME	ETF	32.51	32.57	32.43	32.498	40900.0
2020-06-10	ADRE	ETF	40.64	40.777	40.495	40.67	10012.0
2020-06-10	AESR	ETF	10.1	10.2	10.1	10.11	24400.0
2020-06-10	AFIF	ETF	9.8322	9.8687	9.81	9.85	9745.0
2020-06-10	AFK	ETF	16.52	16.6993	16.52	16.64	6888.0
2020-06-10	AFLG	ETF	19.42	19.426	19.42	19.426	100.0
2020-06-10	AFMC	ETF	17.78	17.78	17.775	17.775	100.0
2020-06-10	AFSM	ETF	17.27	17.27	17.238	17.238	100.0
2020-06-10	AFTY	ETF	16.56	16.64	16.56	16.64	1900.0
2020-06-10	AGG	ETF	117.25	117.68	117.19	117.66	4680800.0
2020-06-10	AGGY	ETF	53.56	53.72	53.46	53.72	212800.0
2020-06-10	AGNG	ETF	24.96	24.96	24.593	24.69	2600.0
2020-06-10	AGQ	ETF	28.5	29.45	27.26	29.43	854200.0
2020-06-10	AGZ	ETF	120.31	120.8	120.31	120.8	29398.0
2020-06-10	AGZD	ETF	23.555	23.555	23.475	23.515	6800.0
2020-06-10	AIA	ETF	65.31	65.7597	65.16	65.65	89924.0
2020-06-10	AIEQ	ETF	28.06	28.29	27.97	28.04	14300.0
2020-06-10	AIQ	ETF	20.56	20.7984	20.478	20.6758	23356.0
2020-06-10	AIRR	ETF	25.42	25.43	24.667	24.667	15800.0
2020-06-10	AIVI	ETF	37.13	37.15	37.02	37.12	5900.0
2020-06-10	ALTY	ETF	12.0	12.0	11.5	11.6	15800.0
2020-06-10	AMJ	ETF	16.14	16.14	15.47	15.95	1579002.0
2020-06-10	AMLP	ETF	29.84	29.92	28.76	29.62	4559400.0
2020-06-10	AMOM	ETF	29.237	29.237	29.237	29.237	200.0
2020-06-10	AMUB	ETF	10.46	10.46	9.84	10.0177	12043.0
2020-06-10	AMZA	ETF	23.17	23.17	22.021	22.78	98200.0
2020-06-10	ANGL	ETF	28.99	29.16	28.78	29.09	1183800.0
2020-06-10	AOA	ETF	56.35	56.5	55.95	56.18	116700.0
2020-06-10	AOK	ETF	36.67	36.72	36.5244	36.56	113442.0
2020-06-10	AOM	ETF	40.4	40.47	40.195	40.37	131061.0
2020-06-10	AOR	ETF	47.3	47.44	47.0601	47.14	107860.0
2020-06-10	APRT	ETF	25.58	25.59	25.4941	25.4941	2466.0

> showing 50 of 2,022 rows — these rows as CSV

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