PREVIEW / etf_daily / 2020-01-02

all etf daily files

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

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-02	SPY	ETF	323.54	324.89	322.53	324.87	59151200.0
2020-01-02	QQQ	ETF	214.4	216.16	213.98	216.16	31014904.0
2020-01-02	IWM	ETF	166.74	166.75	164.23	165.78	18297500.0
2020-01-02	DIA	ETF	286.44	288.63	286.15	288.62	3865500.0
2020-01-02	GLD	ETF	143.86	144.21	143.4	143.95	7733800.0
2020-01-02	TLT	ETF	136.79	137.53	136.67	137.01	11034100.0
2020-01-02	AAAU	ETF	15.24	15.28	15.2	15.25	43100.0
2020-01-02	AADR	ETF	54.56	54.86	54.45	54.86	9300.0
2020-01-02	AAXJ	ETF	74.3	74.96	74.3	74.91	840900.0
2020-01-02	ACES	ETF	34.34	34.34	33.81	34.228	19600.0
2020-01-02	ACIO	ETF	25.71	25.71	25.631	25.705	10000.0
2020-01-02	ACSI	ETF	35.5584	35.5584	35.4099	35.5257	7324.0
2020-01-02	ACTX	ETF	11.2101	13.5701	11.2101	13.5701	196.0
2020-01-02	ACWF	ETF	31.38	31.4372	31.2989	31.4372	6384.0
2020-01-02	ACWI	ETF	79.77	80.1	79.65	80.07	2341600.0
2020-01-02	ACWV	ETF	96.27	96.31	95.7	96.1	316700.0
2020-01-02	ACWX	ETF	49.5	49.72	49.46	49.72	1597235.0
2020-01-02	ADME	ETF	30.65	30.652	30.585	30.652	4900.0
2020-01-02	ADRE	ETF	44.86	45.71	44.86	45.71	31682.0
2020-01-02	AESR	ETF	10.1	10.138	10.1	10.138	1800.0
2020-01-02	AFIF	ETF	9.76	9.76	9.7403	9.755	3518.0
2020-01-02	AFK	ETF	20.54	20.6902	20.3363	20.52	21809.0
2020-01-02	AFLG	ETF	20.563	20.563	20.563	20.563	100.0
2020-01-02	AFTY	ETF	17.72	17.762	17.71	17.762	14200.0
2020-01-02	AGG	ETF	112.68	112.8	112.56	112.68	6791400.0
2020-01-02	AGGY	ETF	52.36	52.39	52.27	52.35	181700.0
2020-01-02	AGNG	ETF	23.59	23.74	23.56	23.665	2400.0
2020-01-02	AGQ	ETF	32.19	32.47	31.91	32.18	300700.0
2020-01-02	AGZ	ETF	115.7	115.8916	115.7	115.78	20312.0
2020-01-02	AGZD	ETF	24.025	24.09	24.0	24.06	79400.0
2020-01-02	AIA	ETF	66.65	67.46	66.65	67.46	252202.0
2020-01-02	AIEQ	ETF	28.55	28.7	28.34	28.68	48200.0
2020-01-02	AIQ	ETF	17.96	18.31	17.96	18.2975	13866.0
2020-01-02	AIRR	ETF	29.18	29.19	28.741	28.822	5000.0
2020-01-02	AIVI	ETF	42.84	42.97	42.81	42.97	5300.0
2020-01-02	ALTY	ETF	14.826	14.84	14.74	14.799	29300.0
2020-01-02	AMJ	ETF	21.92	22.08	21.81	22.04	2045115.0
2020-01-02	AMLP	ETF	42.9	43.15	42.6	43.05	4167720.0
2020-01-02	AMOM	ETF	26.159	26.159	26.159	26.159	100.0
2020-01-02	AMUB	ETF	13.89	13.89	13.885	13.885	600.0
2020-01-02	AMZA	ETF	45.6	46.4	45.5	46.4	58560.0
2020-01-02	ANGL	ETF	29.96	29.96	29.81	29.91	1214200.0
2020-01-02	AOA	ETF	58.33	58.49	58.22	58.48	162500.0
2020-01-02	AOK	ETF	36.22	36.41	36.22	36.41	177929.0
2020-01-02	AOM	ETF	40.3	40.3	40.2	40.28	404707.0
2020-01-02	AOR	ETF	48.01	48.14	47.96	48.13	223062.0
2020-01-02	ARGT	ETF	26.59	27.12	26.59	26.72	114500.0
2020-01-02	ARKF	ETF	24.21	24.57	24.21	24.57	13300.0
2020-01-02	ARKG	ETF	34.0	34.0	32.91	33.35	264900.0
2020-01-02	ARKK	ETF	50.64	50.64	49.9	50.5	248400.0

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

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