PREVIEW / etf_daily / 2020-01-09

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-09.parquet
  size:    74 KB
  rows:    1,933

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-09	SPY	ETF	326.16	326.73	325.52	326.65	48473300.0
2020-01-09	QQQ	ETF	218.91	219.41	217.7125	218.99	23641291.0
2020-01-09	IWM	ETF	166.12	166.45	165.26	165.51	11895400.0
2020-01-09	DIA	ETF	288.95	289.84	288.43	289.56	1783100.0
2020-01-09	GLD	ETF	146.07	146.41	145.44	146.03	10292300.0
2020-01-09	TLT	ETF	136.0	137.44	135.91	137.22	7411500.0
2020-01-09	AAAU	ETF	15.48	15.51	15.41	15.47	24700.0
2020-01-09	AADR	ETF	54.88	55.25	54.77	55.0	34300.0
2020-01-09	AAXJ	ETF	74.71	74.74	74.45	74.58	2997700.0
2020-01-09	ACES	ETF	35.07	35.16	34.857	34.99	48900.0
2020-01-09	ACIO	ETF	25.63	25.67	25.62	25.667	29900.0
2020-01-09	ACSI	ETF	35.561	35.63	35.561	35.5707	1039.0
2020-01-09	ACTX	ETF	11.806	12.717	11.806	11.9523	140.0
2020-01-09	ACWF	ETF	31.3145	31.346	31.28	31.3454	2219.0
2020-01-09	ACWI	ETF	80.11	80.2	79.94	80.2	1694600.0
2020-01-09	ACWV	ETF	96.12	96.34	96.01	96.26	383200.0
2020-01-09	ACWX	ETF	49.39	49.41	49.2701	49.36	1792480.0
2020-01-09	ADME	ETF	30.6	30.75	30.6	30.705	39200.0
2020-01-09	ADRE	ETF	45.38	45.4	45.1167	45.295	10909.0
2020-01-09	AESR	ETF	10.23	10.23	10.215	10.215	1400.0
2020-01-09	AFIF	ETF	9.7298	9.7501	9.7252	9.7501	4327.0
2020-01-09	AFK	ETF	20.46	20.46	20.3	20.3	16376.0
2020-01-09	AFLG	ETF	20.58	20.589	20.58	20.589	200.0
2020-01-09	AFMC	ETF	20.38	20.38	20.354	20.354	100.0
2020-01-09	AFSM	ETF	20.377	20.377	20.377	20.377	100.0
2020-01-09	AFTY	ETF	17.57	17.649	17.57	17.62	1700.0
2020-01-09	AGG	ETF	112.49	112.79	112.46	112.79	9110900.0
2020-01-09	AGGY	ETF	52.32	52.44	52.27	52.44	359000.0
2020-01-09	AGNG	ETF	23.804	23.953	23.77	23.925	19300.0
2020-01-09	AGQ	ETF	31.67	31.85	31.36	31.66	216900.0
2020-01-09	AGZ	ETF	115.67	115.94	115.67	115.92	19577.0
2020-01-09	AGZD	ETF	24.045	24.09	23.995	24.035	6600.0
2020-01-09	AIA	ETF	67.52	67.52	67.23	67.4128	35545.0
2020-01-09	AIEQ	ETF	29.11	29.11	28.98	29.07	58000.0
2020-01-09	AIQ	ETF	18.5	18.68	18.5	18.645	40530.0
2020-01-09	AIRR	ETF	28.943	29.095	28.943	28.97	4200.0
2020-01-09	AIVI	ETF	42.73	42.73	42.62	42.68	4200.0
2020-01-09	ALTY	ETF	14.847	14.92	14.847	14.9	13400.0
2020-01-09	AMJ	ETF	22.52	22.57	22.285	22.42	1993031.0
2020-01-09	AMLP	ETF	43.9	44.1	43.55	43.8	3299260.0
2020-01-09	AMOM	ETF	26.42	26.442	26.42	26.442	600.0
2020-01-09	AMUB	ETF	14.1271	14.1271	14.1271	14.1271	0.0
2020-01-09	AMZA	ETF	46.5	46.8	46.0	46.7	55870.0
2020-01-09	ANGL	ETF	29.99	30.04	29.93	30.03	241100.0
2020-01-09	AOA	ETF	58.43	58.48	58.31	58.48	54500.0
2020-01-09	AOK	ETF	36.38	36.41	36.3314	36.4	95223.0
2020-01-09	AOM	ETF	40.28	40.33	40.21	40.33	181644.0
2020-01-09	AOR	ETF	48.04	48.14	48.0136	48.09	133387.0
2020-01-09	ARCM	ETF	100.045	100.045	99.722	100.045	4400.0
2020-01-09	ARGT	ETF	26.75	27.08	26.75	26.99	51000.0

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

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