PREVIEW / etf_daily / 2019-10-07

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-07.parquet
  size:    70 KB
  rows:    1,837

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
2019-10-07	SPY	ETF	293.47	295.26	292.77	293.08	59610500.0
2019-10-07	QQQ	ETF	188.23	189.74	187.91	188.24	21404580.0
2019-10-07	IWM	ETF	148.78	150.07	148.12	148.88	15762800.0
2019-10-07	DIA	ETF	264.92	266.5	264.19	264.74	2104200.0
2019-10-07	GLD	ETF	141.16	141.77	140.24	140.69	6127200.0
2019-10-07	TLT	ETF	145.16	145.53	144.71	144.78	11013900.0
2019-10-07	AAAU	ETF	14.94	14.99	14.87	14.89	109700.0
2019-10-07	AADR	ETF	47.83	47.93	47.62	47.64	18200.0
2019-10-07	AAXJ	ETF	66.01	66.35	65.94	66.02	488000.0
2019-10-07	ACES	ETF	31.01	31.01	30.72	30.771	5500.0
2019-10-07	ACIO	ETF	24.41	24.41	24.36	24.36	10600.0
2019-10-07	ACSI	ETF	33.4738	33.5243	33.4738	33.5243	836.0
2019-10-07	ACTX	ETF	14.7324	14.7442	13.1418	14.3472	377.0
2019-10-07	ACWF	ETF	28.5773	28.71	28.53	28.542	10836.0
2019-10-07	ACWI	ETF	72.84	73.2	72.72	72.75	2268500.0
2019-10-07	ACWV	ETF	94.62	94.77	94.39	94.43	126800.0
2019-10-07	ACWX	ETF	45.42	45.6	45.37	45.37	1631015.0
2019-10-07	ADRE	ETF	38.63	38.69	38.47	38.47	3246.0
2019-10-07	AFIF	ETF	9.78	9.7885	9.78	9.785	1076.0
2019-10-07	AFK	ETF	20.05	20.0899	19.8568	19.96	3577.0
2019-10-07	AFTY	ETF	16.77	16.77	16.73	16.737	5200.0
2019-10-07	AGG	ETF	113.64	113.71	113.51	113.51	2493000.0
2019-10-07	AGGY	ETF	52.57	52.64	52.54	52.57	120100.0
2019-10-07	AGNG	ETF	21.292	21.415	21.23	21.399	4500.0
2019-10-07	AGQ	ETF	31.14	31.41	30.75	30.84	145500.0
2019-10-07	AGZ	ETF	116.98	117.0	116.875	116.92	18664.0
2019-10-07	AGZD	ETF	23.93	23.93	23.795	23.795	5000.0
2019-10-07	AIA	ETF	58.35	58.67	58.35	58.49	26023.0
2019-10-07	AIEQ	ETF	25.96	26.141	25.947	25.95	21100.0
2019-10-07	AIQ	ETF	15.961	16.02	15.961	15.963	4002.0
2019-10-07	AIRR	ETF	26.07	26.2	26.07	26.093	3100.0
2019-10-07	AIVI	ETF	39.81	39.97	39.8	39.8	4000.0
2019-10-07	ALTY	ETF	14.7	14.7	14.647	14.675	4900.0
2019-10-07	AMJ	ETF	22.99	23.016	22.65	22.65	2981682.0
2019-10-07	AMLP	ETF	45.2	45.25	44.7	44.8	3127820.0
2019-10-07	AMOM	ETF	25.98	26.03	25.98	26.03	100.0
2019-10-07	AMUB	ETF	14.3191	14.3191	14.3191	14.3191	0.0
2019-10-07	AMZA	ETF	48.2	48.4	47.5	47.6	77040.0
2019-10-07	ANGL	ETF	29.05	29.08	29.01	29.05	425100.0
2019-10-07	AOA	ETF	54.24	54.44	54.2	54.23	38600.0
2019-10-07	AOK	ETF	35.63	35.64	35.52	35.57	93419.0
2019-10-07	AOM	ETF	39.06	39.0811	38.96	39.0	140838.0
2019-10-07	AOR	ETF	45.61	45.7131	45.5394	45.6	95208.0
2019-10-07	ARCM	ETF	100.16	100.16	100.091	100.105	900.0
2019-10-07	ARGT	ETF	23.04	23.38	23.02	23.07	22300.0
2019-10-07	ARKF	ETF	21.537	21.606	21.49	21.501	5600.0
2019-10-07	ARKG	ETF	28.98	29.43	28.94	29.14	88500.0
2019-10-07	ARKK	ETF	41.8	42.39	41.686	42.03	171100.0
2019-10-07	ARKQ	ETF	31.19	31.543	31.12	31.32	27200.0
2019-10-07	ARKW	ETF	48.43	48.93	48.17	48.66	18900.0

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

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