PREVIEW / etf_daily / 2019-01-23

all etf daily files

  file:    by_date/etf_daily/2019/2019-01-23.parquet
  size:    67 KB
  rows:    1,737

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-01-23	SPY	ETF	264.01	264.79	260.66	263.41	86030300.0
2019-01-23	QQQ	ETF	162.77	163.51	160.32	162.15	38106062.0
2019-01-23	IWM	ETF	145.32	146.18	143.46	144.6	20621300.0
2019-01-23	DIA	ETF	246.15	246.92	242.98	245.72	4330300.0
2019-01-23	GLD	ETF	120.96	121.54	120.86	121.28	5224900.0
2019-01-23	TLT	ETF	119.88	120.62	119.83	120.32	5776800.0
2019-01-23	AAAU	ETF	12.9	12.9	12.78	12.83	14600.0
2019-01-23	AADR	ETF	42.76	42.78	42.29	42.52	4500.0
2019-01-23	AAXJ	ETF	66.15	66.19	65.71	66.19	2261500.0
2019-01-23	ACES	ETF	24.64	24.64	24.14	24.27	3700.0
2019-01-23	ACSI	ETF	30.61	30.8401	30.61	30.7281	1405.0
2019-01-23	ACTX	ETF	49.5604	51.9205	48.3804	48.9704	376.0
2019-01-23	ACWF	ETF	27.75	27.75	27.445	27.56	8085.0
2019-01-23	ACWI	ETF	67.7	67.8	66.96	67.5	4049500.0
2019-01-23	ACWV	ETF	83.7	83.9	83.31	83.8	181700.0
2019-01-23	ACWX	ETF	44.02	44.1	43.71	43.93	2990486.0
2019-01-23	ADRE	ETF	38.55	38.55	38.2929	38.4676	2681.0
2019-01-23	AFIF	ETF	9.9872	9.9899	9.93	9.95	31530.0
2019-01-23	AFK	ETF	20.46	20.5506	20.435	20.49	5042.0
2019-01-23	AFTY	ETF	14.06	14.08	14.035	14.059	2200.0
2019-01-23	AGG	ETF	106.38	106.59	106.37	106.55	3222800.0
2019-01-23	AGGY	ETF	48.39	48.45	48.34	48.4	121600.0
2019-01-23	AGNG	ETF	20.4	20.4	20.4	20.4	200.0
2019-01-23	AGQ	ETF	25.59	25.85	25.49	25.8	70100.0
2019-01-23	AGZ	ETF	111.96	112.02	111.9201	112.02	21398.0
2019-01-23	AGZD	ETF	23.655	23.725	23.635	23.66	47400.0
2019-01-23	AIA	ETF	57.73	57.73	57.2826	57.53	41756.0
2019-01-23	AIEQ	ETF	23.89	24.03	23.53	23.7	34200.0
2019-01-23	AIQ	ETF	14.04	14.12	13.82	13.94	22034.0
2019-01-23	AIRR	ETF	23.51	23.52	23.11	23.22	60900.0
2019-01-23	AIVI	ETF	39.4	39.45	39.21	39.3	7300.0
2019-01-23	ALTY	ETF	14.34	14.34	14.25	14.29	17300.0
2019-01-23	AMJ	ETF	24.48	24.66	24.17	24.43	3422563.0
2019-01-23	AMLP	ETF	48.2	48.55	47.6	48.1	3602900.0
2019-01-23	AMUB	ETF	15.399	15.399	15.399	15.399	0.0
2019-01-23	AMZA	ETF	57.2	57.9	56.1	56.5	78180.0
2019-01-23	ANGL	ETF	27.89	27.95	27.78	27.84	283200.0
2019-01-23	AOA	ETF	50.6	52.05	50.3	50.55	187300.0
2019-01-23	AOK	ETF	33.27	33.39	33.245	33.28	189818.0
2019-01-23	AOM	ETF	36.46	36.73	36.3518	36.45	295313.0
2019-01-23	AOR	ETF	42.55	42.63	42.37	42.56	229609.0
2019-01-23	ARCM	ETF	99.9	99.975	99.85	99.975	1900.0
2019-01-23	ARGT	ETF	26.03	26.28	25.92	26.15	75000.0
2019-01-23	ARKG	ETF	27.89	28.4	26.95	27.21	79400.0
2019-01-23	ARKK	ETF	41.3	41.52	40.33	40.7	288700.0
2019-01-23	ARKQ	ETF	30.91	31.27	30.66	30.91	13300.0
2019-01-23	ARKW	ETF	47.1	47.4	46.287	46.73	142600.0
2019-01-23	ASEA	ETF	15.97	16.0	15.9	16.0	1500.0
2019-01-23	ASET	ETF	27.05	27.05	26.92	26.9402	5069.0
2019-01-23	ASHR	ETF	23.27	23.33	23.19	23.27	2517600.0

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

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