PREVIEW / etf_daily / 2020-06-29

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-29.parquet
  size:    77 KB
  rows:    2,036

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-29	SPY	ETF	301.41	304.61	298.93	304.46	79773300.0
2020-06-29	QQQ	ETF	239.98	242.85	237.35	242.84	34377800.0
2020-06-29	IWM	ETF	138.71	141.99	137.1	141.14	33935200.0
2020-06-29	DIA	ETF	252.18	256.12	250.95	255.91	3759000.0
2020-06-29	GLD	ETF	166.56	166.8	166.18	166.63	6735700.0
2020-06-29	TLT	ETF	164.85	165.27	164.38	164.73	7274400.0
2020-06-29	AAAU	ETF	17.67	17.69	17.63	17.68	405500.0
2020-06-29	AADR	ETF	52.62	52.68	52.31	52.63	1300.0
2020-06-29	AAXJ	ETF	69.05	69.38	68.72	69.38	1165700.0
2020-06-29	ABEQ	ETF	24.08	24.08	22.01	22.07	5100.0
2020-06-29	ACES	ETF	37.13	38.42	37.13	38.29	29800.0
2020-06-29	ACIO	ETF	25.02	25.02	24.89	24.956	12100.0
2020-06-29	ACSI	ETF	33.0771	33.0771	33.0771	33.0771	132.0
2020-06-29	ACTX	ETF	3.3188	3.9501	3.304	3.304	1036.0
2020-06-29	ACWF	ETF	27.51	27.56	27.22	27.5	8283.0
2020-06-29	ACWI	ETF	72.69	73.24	72.17	73.24	1806700.0
2020-06-29	ACWV	ETF	86.75	87.17	86.39	87.16	225900.0
2020-06-29	ACWX	ETF	43.16	43.33	42.89	43.28	1545518.0
2020-06-29	ADME	ETF	31.4	31.561	31.4	31.561	11100.0
2020-06-29	ADRE	ETF	39.042	39.4352	38.95	39.4352	8254.0
2020-06-29	AESR	ETF	9.77	9.77	9.754	9.754	500.0
2020-06-29	AFIF	ETF	9.8132	9.826	9.8	9.8174	42975.0
2020-06-29	AFK	ETF	16.0	16.37	16.0	16.36	8739.0
2020-06-29	AFLG	ETF	18.524	18.524	18.524	18.524	100.0
2020-06-29	AFMC	ETF	16.651	16.651	16.651	16.651	100.0
2020-06-29	AFSM	ETF	16.528	16.528	16.528	16.528	100.0
2020-06-29	AFTY	ETF	16.67	16.69	16.66	16.69	3000.0
2020-06-29	AGG	ETF	118.01	118.11	117.95	118.11	3517200.0
2020-06-29	AGGY	ETF	53.76	53.81	53.71	53.81	152400.0
2020-06-29	AGQ	ETF	27.78	27.9	27.41	27.86	487100.0
2020-06-29	AGZ	ETF	121.11	121.11	120.9	120.9	50461.0
2020-06-29	AGZD	ETF	23.655	23.655	23.445	23.5	6600.0
2020-06-29	AIA	ETF	64.75	64.95	64.43	64.93	52263.0
2020-06-29	AIEQ	ETF	27.53	27.66	27.241	27.64	12900.0
2020-06-29	AIQ	ETF	20.21	20.24	19.92	20.24	13191.0
2020-06-29	AIRR	ETF	23.306	23.92	23.306	23.9	11700.0
2020-06-29	AIVI	ETF	35.34	35.54	35.24	35.5	11100.0
2020-06-29	ALTL	ETF	23.53	23.93	23.53	23.8568	7444.0
2020-06-29	ALTY	ETF	10.68	10.7	10.55	10.649	42400.0
2020-06-29	AMJ	ETF	13.04	13.26	12.92	13.02	1015736.0
2020-06-29	AMLP	ETF	24.35	24.66	24.01	24.2	2483600.0
2020-06-29	AMNA	ETF	23.29	23.51	23.28	23.3189	18750.0
2020-06-29	AMOM	ETF	28.9	29.082	28.9	29.082	400.0
2020-06-29	AMUB	ETF	8.21	8.21	8.18	8.2004	1355.0
2020-06-29	AMZA	ETF	17.38	17.47	16.9	17.07	98300.0
2020-06-29	ANGL	ETF	28.57	28.9	28.14	28.3	2569100.0
2020-06-29	AOA	ETF	54.09	54.49	53.88	54.45	163600.0
2020-06-29	AOK	ETF	36.09	36.239	36.04	36.18	134891.0
2020-06-29	AOM	ETF	39.53	39.77	39.4389	39.68	288035.0
2020-06-29	AOR	ETF	45.9	46.135	45.69	46.13	1491130.0

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

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