PREVIEW / etf_daily / 2020-01-13

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-13.parquet
  size:    73 KB
  rows:    1,936

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-01-13	SPY	ETF	326.39	327.96	325.92	327.95	47086800.0
2020-01-13	QQQ	ETF	219.31	220.98	218.98	220.95	22846102.0
2020-01-13	IWM	ETF	164.94	166.04	164.07	165.96	17271100.0
2020-01-13	DIA	ETF	288.79	289.08	288.14	289.02	1463300.0
2020-01-13	GLD	ETF	146.35	146.38	145.78	145.82	7593800.0
2020-01-13	TLT	ETF	137.88	138.09	137.39	138.02	5966900.0
2020-01-13	AAAU	ETF	15.5	15.51	15.26	15.45	161400.0
2020-01-13	AADR	ETF	55.08	55.37	54.74	55.11	12700.0
2020-01-13	AAXJ	ETF	75.74	76.44	75.59	76.35	962200.0
2020-01-13	ACES	ETF	35.58	35.973	35.465	35.747	31000.0
2020-01-13	ACIO	ETF	25.632	25.67	25.611	25.657	11600.0
2020-01-13	ACSI	ETF	35.591	35.7937	35.541	35.7937	1616.0
2020-01-13	ACTX	ETF	11.2101	12.0951	11.2101	11.8066	232.0
2020-01-13	ACWF	ETF	31.43	31.56	31.385	31.56	14877.0
2020-01-13	ACWI	ETF	80.19	80.62	80.06	80.62	2383400.0
2020-01-13	ACWV	ETF	96.44	96.88	96.4	96.85	361900.0
2020-01-13	ACWX	ETF	49.44	49.73	49.35	49.73	2843178.0
2020-01-13	ADME	ETF	30.66	30.86	30.62	30.86	16400.0
2020-01-13	ADRE	ETF	45.92	46.11	45.695	46.046	54072.0
2020-01-13	AESR	ETF	10.235	10.26	10.235	10.255	6500.0
2020-01-13	AFIF	ETF	9.71	9.725	9.7	9.725	2865.0
2020-01-13	AFK	ETF	20.52	20.52	20.3	20.485	7011.0
2020-01-13	AFMC	ETF	20.52	20.52	20.52	20.52	100.0
2020-01-13	AFTY	ETF	17.75	17.98	17.75	17.971	607000.0
2020-01-13	AGG	ETF	112.89	112.94	112.83	112.91	4465300.0
2020-01-13	AGGY	ETF	52.46	52.48	52.41	52.48	368100.0
2020-01-13	AGNG	ETF	24.0	24.023	23.915	23.915	3400.0
2020-01-13	AGQ	ETF	32.19	32.19	31.72	31.96	504800.0
2020-01-13	AGZ	ETF	115.98	116.0	115.9	116.0	28703.0
2020-01-13	AGZD	ETF	24.12	24.12	24.035	24.115	10200.0
2020-01-13	AIA	ETF	68.54	69.35	68.52	69.35	120098.0
2020-01-13	AIEQ	ETF	29.05	29.2	29.0	29.2	37300.0
2020-01-13	AIQ	ETF	18.61	18.8483	18.61	18.79	24553.0
2020-01-13	AIRR	ETF	28.72	28.95	28.66	28.911	5200.0
2020-01-13	AIVI	ETF	42.67	42.8	42.59	42.8	1400.0
2020-01-13	ALTY	ETF	14.88	14.979	14.871	14.94	27300.0
2020-01-13	AMJ	ETF	22.32	22.59	22.2	22.52	2471198.0
2020-01-13	AMLP	ETF	43.6	44.1	43.3	43.85	3195500.0
2020-01-13	AMOM	ETF	26.46	26.57	26.06	26.06	10000.0
2020-01-13	AMUB	ETF	14.1599	14.1599	14.1599	14.1599	0.0
2020-01-13	AMZA	ETF	46.0	46.9	45.8	46.5	64630.0
2020-01-13	ANGL	ETF	30.1	30.1	30.0	30.0	714900.0
2020-01-13	AOA	ETF	58.49	58.73	58.39	58.73	121700.0
2020-01-13	AOK	ETF	36.46	36.51	36.4	36.51	82944.0
2020-01-13	AOM	ETF	40.27	40.43	40.27	40.38	173004.0
2020-01-13	AOR	ETF	48.14	48.29	48.1101	48.26	95809.0
2020-01-13	ARGT	ETF	27.13	27.31	26.9	26.96	32300.0
2020-01-13	ARKF	ETF	25.37	25.63	25.328	25.61	51200.0
2020-01-13	ARKG	ETF	34.5	34.684	33.9	34.41	252800.0
2020-01-13	ARKK	ETF	52.53	53.11	52.3	53.04	345500.0

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

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