PREVIEW / etf_daily / 2019-12-23

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-23.parquet
  size:    73 KB
  rows:    1,923

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-12-23	SPY	ETF	321.59	321.65	321.06	321.22	52990000.0
2019-12-23	QQQ	ETF	212.03	212.15	211.63	211.81	23798671.0
2019-12-23	IWM	ETF	166.24	166.36	165.36	166.3	13372100.0
2019-12-23	DIA	ETF	285.34	285.66	285.15	285.33	2564700.0
2019-12-23	GLD	ETF	139.53	139.96	139.53	139.95	5180900.0
2019-12-23	TLT	ETF	136.81	136.97	136.0	136.45	5175000.0
2019-12-23	AAAU	ETF	14.78	14.83	14.78	14.82	95600.0
2019-12-23	AADR	ETF	53.69	53.83	53.6	53.72	9100.0
2019-12-23	AAXJ	ETF	72.96	73.03	72.81	73.03	244800.0
2019-12-23	ACES	ETF	33.76	33.78	33.64	33.765	10700.0
2019-12-23	ACIO	ETF	26.4	26.4	25.786	25.823	21000.0
2019-12-23	ACSI	ETF	36.22	36.22	35.93	35.93	1901.0
2019-12-23	ACTX	ETF	12.0833	12.3901	11.806	11.806	2175.0
2019-12-23	ACWF	ETF	31.19	31.19	31.1025	31.1127	16086.0
2019-12-23	ACWI	ETF	79.08	79.12	79.01	79.05	1385500.0
2019-12-23	ACWV	ETF	95.73	95.73	95.36	95.39	332900.0
2019-12-23	ACWX	ETF	48.92	48.97	48.885	48.97	1720263.0
2019-12-23	ADME	ETF	31.0	31.0	30.807	30.807	11400.0
2019-12-23	ADRE	ETF	45.0	45.0	44.4073	44.66	65857.0
2019-12-23	AFIF	ETF	9.74	9.7481	9.73	9.7373	2019.0
2019-12-23	AFK	ETF	20.1	20.15	19.9	20.01	13331.0
2019-12-23	AFSM	ETF	20.54	20.54	20.52	20.52	100.0
2019-12-23	AFTY	ETF	17.01	17.01	16.94	16.95	3300.0
2019-12-23	AGG	ETF	112.38	112.39	112.18	112.24	3148600.0
2019-12-23	AGGY	ETF	52.18	52.18	52.085	52.12	72700.0
2019-12-23	AGNG	ETF	23.98	23.98	23.745	23.895	4500.0
2019-12-23	AGQ	ETF	29.77	30.3	29.76	30.23	204300.0
2019-12-23	AGZ	ETF	115.48	115.535	115.39	115.42	14030.0
2019-12-23	AGZD	ETF	24.025	24.075	23.97	24.02	8800.0
2019-12-23	AIA	ETF	65.34	65.5	65.33	65.42	23629.0
2019-12-23	AIEQ	ETF	28.53	28.59	28.484	28.49	14000.0
2019-12-23	AIQ	ETF	18.0	18.05	17.9725	18.03	9082.0
2019-12-23	AIRR	ETF	29.21	29.27	29.09	29.248	7600.0
2019-12-23	AIVI	ETF	42.48	42.61	42.48	42.61	89300.0
2019-12-23	ALTY	ETF	14.96	14.981	14.94	14.945	11500.0
2019-12-23	AMJ	ETF	21.82	22.03	21.7345	22.0	4633316.0
2019-12-23	AMLP	ETF	42.45	43.05	42.4	43.05	8485100.0
2019-12-23	AMOM	ETF	26.1	26.1	25.95	25.95	300.0
2019-12-23	AMUB	ETF	13.82	13.8392	13.82	13.8392	200.0
2019-12-23	AMZA	ETF	45.6	46.0	45.4	45.9	102240.0
2019-12-23	ANGL	ETF	29.92	29.93	29.8	29.93	324700.0
2019-12-23	AOA	ETF	58.41	58.42	58.35	58.4	44700.0
2019-12-23	AOK	ETF	36.37	36.3999	36.32	36.35	93349.0
2019-12-23	AOM	ETF	40.33	40.42	40.3	40.3	156984.0
2019-12-23	AOR	ETF	48.09	48.175	48.09	48.12	94183.0
2019-12-23	ARGT	ETF	26.07	26.82	26.07	26.82	62500.0
2019-12-23	ARKF	ETF	24.25	24.31	24.21	24.23	15700.0
2019-12-23	ARKG	ETF	35.95	36.46	35.479	36.33	593500.0
2019-12-23	ARKK	ETF	51.26	51.74	50.912	51.59	303700.0
2019-12-23	ARKQ	ETF	37.6	37.83	37.4	37.747	21900.0

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

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