PREVIEW / etf_daily / 2020-01-10

all etf daily files

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

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-10	SPY	ETF	327.29	327.46	325.2	325.71	53029300.0
2020-01-10	QQQ	ETF	219.76	219.87	218.04	218.43	21914631.0
2020-01-10	IWM	ETF	165.55	165.69	164.2	164.89	15353000.0
2020-01-10	DIA	ETF	289.96	290.04	287.84	288.24	2989600.0
2020-01-10	GLD	ETF	146.22	146.99	146.17	146.91	6183300.0
2020-01-10	TLT	ETF	137.67	138.47	137.63	138.44	8776000.0
2020-01-10	AAAU	ETF	15.5	15.57	15.5	15.57	99100.0
2020-01-10	AADR	ETF	55.11	55.22	55.03	55.15	6700.0
2020-01-10	AAXJ	ETF	75.01	75.27	74.89	75.05	1304900.0
2020-01-10	ACES	ETF	35.13	35.25	34.95	35.05	34900.0
2020-01-10	ACIO	ETF	25.584	25.62	25.554	25.574	25600.0
2020-01-10	ACSI	ETF	35.5875	35.64	35.5188	35.5188	986.0
2020-01-10	ACTX	ETF	11.806	12.0981	11.806	11.806	297.0
2020-01-10	ACWF	ETF	31.47	31.47	31.284	31.3072	10034.0
2020-01-10	ACWI	ETF	80.28	80.37	79.89	80.02	3321300.0
2020-01-10	ACWV	ETF	96.31	96.48	96.2	96.25	471400.0
2020-01-10	ACWX	ETF	49.44	49.5334	49.26	49.3	2213648.0
2020-01-10	ADME	ETF	30.69	30.78	30.64	30.695	52800.0
2020-01-10	ADRE	ETF	45.65	45.65	45.2948	45.2948	6123.0
2020-01-10	AESR	ETF	10.27	10.27	10.155	10.155	800.0
2020-01-10	AFIF	ETF	9.75	9.75	9.72	9.735	15101.0
2020-01-10	AFK	ETF	20.44	20.48	20.39	20.4	9884.0
2020-01-10	AFLG	ETF	20.59	20.59	20.553	20.553	200.0
2020-01-10	AFMC	ETF	20.323	20.323	20.323	20.323	200.0
2020-01-10	AFSM	ETF	20.34	20.34	20.293	20.293	100.0
2020-01-10	AFTY	ETF	17.629	17.662	17.62	17.662	1700.0
2020-01-10	AGG	ETF	112.9	112.99	112.82	112.98	4198100.0
2020-01-10	AGGY	ETF	52.49	52.55	52.454	52.55	147400.0
2020-01-10	AGNG	ETF	23.96	24.113	23.89	24.01	2800.0
2020-01-10	AGQ	ETF	32.0	32.57	31.92	32.32	353400.0
2020-01-10	AGZ	ETF	115.97	116.05	115.9303	116.0288	72590.0
2020-01-10	AGZD	ETF	24.045	24.1	24.0	24.05	9600.0
2020-01-10	AIA	ETF	68.01	68.18	67.86	67.99	14709.0
2020-01-10	AIEQ	ETF	29.13	29.13	28.932	28.96	23300.0
2020-01-10	AIQ	ETF	18.64	18.748	18.61	18.61	26919.0
2020-01-10	AIRR	ETF	28.83	28.91	28.718	28.718	17400.0
2020-01-10	AIVI	ETF	42.68	42.77	42.57	42.57	4700.0
2020-01-10	ALTY	ETF	14.88	14.9	14.84	14.885	45100.0
2020-01-10	AMJ	ETF	22.46	22.46	22.17	22.3	1522094.0
2020-01-10	AMLP	ETF	43.8	43.85	43.25	43.55	4282520.0
2020-01-10	AMOM	ETF	26.419	26.419	26.419	26.419	100.0
2020-01-10	AMUB	ETF	14.08	14.08	14.0082	14.0082	653.0
2020-01-10	AMZA	ETF	46.7	46.7	45.8	46.1	59890.0
2020-01-10	ANGL	ETF	30.03	30.08	30.02	30.06	1325100.0
2020-01-10	AOA	ETF	58.47	58.6	58.31	58.31	172000.0
2020-01-10	AOK	ETF	36.41	36.4796	36.41	36.45	77272.0
2020-01-10	AOM	ETF	40.32	40.4	40.27	40.27	131312.0
2020-01-10	AOR	ETF	48.22	48.24	48.08	48.13	249272.0
2020-01-10	ARGT	ETF	27.05	27.25	26.9	27.06	52800.0
2020-01-10	ARKF	ETF	25.24	25.32	25.145	25.21	26300.0

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

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