PREVIEW / etf_daily / 2020-07-06

all etf daily files

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

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-07-06	SPY	ETF	316.37	317.68	315.56	317.05	61713800.0
2020-07-06	QQQ	ETF	255.46	258.928	255.43	258.39	34589049.0
2020-07-06	IWM	ETF	145.32	145.7	142.93	143.43	19858200.0
2020-07-06	DIA	ETF	262.16	263.05	260.87	263.0	2989100.0
2020-07-06	GLD	ETF	167.75	168.0	167.19	167.98	7265700.0
2020-07-06	TLT	ETF	162.33	163.02	161.75	162.92	7972700.0
2020-07-06	AAAU	ETF	17.81	17.82	17.74	17.81	254600.0
2020-07-06	AADR	ETF	54.97	54.99	54.51	54.66	3000.0
2020-07-06	AAXJ	ETF	74.51	75.28	74.44	75.27	1651800.0
2020-07-06	ABEQ	ETF	22.56	22.56	22.446	22.446	400.0
2020-07-06	ACES	ETF	41.21	41.699	41.075	41.61	52100.0
2020-07-06	ACIO	ETF	25.42	25.51	25.387	25.435	37200.0
2020-07-06	ACSI	ETF	34.345	34.3934	34.18	34.3934	502.0
2020-07-06	ACTX	ETF	2.95	3.304	2.95	3.304	1329.0
2020-07-06	ACWF	ETF	28.63	28.66	28.5	28.635	7752.0
2020-07-06	ACWI	ETF	76.21	76.44	76.0	76.4	2516900.0
2020-07-06	ACWV	ETF	89.77	89.77	88.91	89.13	214200.0
2020-07-06	ACWX	ETF	44.95	45.17	44.88	45.14	910412.0
2020-07-06	ADME	ETF	32.61	32.885	32.61	32.784	12300.0
2020-07-06	ADRE	ETF	42.34	42.685	42.31	42.5644	12581.0
2020-07-06	AESR	ETF	10.183	10.203	10.16	10.203	3400.0
2020-07-06	AFIF	ETF	9.8	9.8213	9.8	9.82	74030.0
2020-07-06	AFK	ETF	16.72	16.8	16.636	16.7101	20164.0
2020-07-06	AFLG	ETF	19.17	19.21	19.16	19.2	3000.0
2020-07-06	AFSM	ETF	16.884	16.884	16.884	16.884	100.0
2020-07-06	AFTY	ETF	19.58	19.94	19.44	19.94	34500.0
2020-07-06	AGG	ETF	118.18	118.21	118.0	118.18	5945100.0
2020-07-06	AGGY	ETF	53.81	53.91	53.81	53.88	245400.0
2020-07-06	AGNG	ETF	25.205	25.239	25.038	25.064	3700.0
2020-07-06	AGQ	ETF	29.83	30.0	29.26	29.53	1007800.0
2020-07-06	AGZ	ETF	120.75	120.79	120.5	120.79	56521.0
2020-07-06	AGZD	ETF	23.74	23.74	23.515	23.575	15000.0
2020-07-06	AIA	ETF	69.53	70.11	69.47	70.04	227254.0
2020-07-06	AIEQ	ETF	28.83	29.04	28.79	28.82	27100.0
2020-07-06	AIQ	ETF	21.53	21.69	21.45	21.65	40729.0
2020-07-06	AIRR	ETF	23.82	23.88	23.81	23.88	6400.0
2020-07-06	AIVI	ETF	36.27	36.32	36.24	36.3	82600.0
2020-07-06	ALTL	ETF	24.03	24.6908	24.03	24.44	17357.0
2020-07-06	ALTY	ETF	10.89	10.89	10.55	10.64	12300.0
2020-07-06	AMJ	ETF	13.21	13.36	12.435	12.66	2590944.0
2020-07-06	AMLP	ETF	24.51	24.78	23.02	23.51	4014600.0
2020-07-06	AMNA	ETF	24.25	24.35	23.18	23.36	58401.0
2020-07-06	AMOM	ETF	30.99	31.81	30.99	31.356	2600.0
2020-07-06	AMUB	ETF	8.12	8.38	7.8578	8.0	34064.0
2020-07-06	AMZA	ETF	17.22	17.45	15.95	16.34	122200.0
2020-07-06	ANGL	ETF	28.91	29.07	28.84	29.03	1164900.0
2020-07-06	AOA	ETF	55.73	55.94	55.72	55.82	53900.0
2020-07-06	AOK	ETF	36.61	36.75	36.57	36.61	173367.0
2020-07-06	AOM	ETF	40.11	40.1702	40.07	40.15	194793.0
2020-07-06	AOR	ETF	46.89	47.06	46.85	47.03	140443.0

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

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