PREVIEW / etf_daily / 2019-11-21

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-21.parquet
  size:    72 KB
  rows:    1,879

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-11-21	SPY	ETF	310.89	311.01	309.39	310.27	54664700.0
2019-11-21	QQQ	ETF	201.94	202.07	201.07	201.7	17934353.0
2019-11-21	IWM	ETF	158.82	158.89	157.23	157.73	15388300.0
2019-11-21	DIA	ETF	278.33	278.42	277.16	277.72	1382100.0
2019-11-21	GLD	ETF	138.39	138.56	137.77	138.0	4197200.0
2019-11-21	TLT	ETF	139.64	140.08	139.12	139.72	5980900.0
2019-11-21	AAAU	ETF	14.66	14.66	14.59	14.61	31500.0
2019-11-21	AADR	ETF	49.94	49.98	49.86	49.94	1600.0
2019-11-21	AAXJ	ETF	69.69	69.82	69.53	69.82	649100.0
2019-11-21	ACES	ETF	31.7	31.79	31.65	31.716	11400.0
2019-11-21	ACIO	ETF	25.149	25.17	25.12	25.144	14500.0
2019-11-21	ACSI	ETF	34.672	34.672	34.61	34.6457	765.0
2019-11-21	ACTX	ETF	7.0801	7.6701	6.496	6.7851	415.0
2019-11-21	ACWF	ETF	30.3159	30.39	30.301	30.3605	5094.0
2019-11-21	ACWI	ETF	77.07	77.07	76.74	77.01	955200.0
2019-11-21	ACWV	ETF	95.67	95.67	95.21	95.29	182400.0
2019-11-21	ACWX	ETF	47.86	47.88	47.6835	47.83	1029906.0
2019-11-21	ADME	ETF	30.1	30.1	30.05	30.054	49100.0
2019-11-21	ADRE	ETF	40.7423	41.008	40.7423	40.915	4069.0
2019-11-21	AFIF	ETF	9.71	9.73	9.6953	9.6953	16892.0
2019-11-21	AFK	ETF	20.62	20.88	20.62	20.7899	4631.0
2019-11-21	AFTY	ETF	17.43	17.44	17.404	17.43	4500.0
2019-11-21	AGG	ETF	112.8	112.89	112.72	112.81	6522800.0
2019-11-21	AGGY	ETF	52.26	52.274	52.19	52.24	120700.0
2019-11-21	AGNG	ETF	23.126	23.15	23.126	23.15	500.0
2019-11-21	AGQ	ETF	29.42	29.57	29.24	29.39	92400.0
2019-11-21	AGZ	ETF	116.32	116.3416	116.25	116.25	25385.0
2019-11-21	AGZD	ETF	23.985	23.985	23.955	23.975	4200.0
2019-11-21	AIA	ETF	61.83	61.83	61.61	61.75	28958.0
2019-11-21	AIEQ	ETF	27.5	27.587	27.377	27.4	16300.0
2019-11-21	AIQ	ETF	17.02	17.0887	17.0073	17.015	3201.0
2019-11-21	AIRR	ETF	28.22	28.22	27.913	27.985	4400.0
2019-11-21	AIVI	ETF	41.77	41.77	41.55	41.68	7500.0
2019-11-21	ALTY	ETF	14.69	14.69	14.57	14.635	28000.0
2019-11-21	AMJ	ETF	20.43	20.83	20.35	20.83	3164828.0
2019-11-21	AMLP	ETF	38.95	39.7	38.75	39.7	7404100.0
2019-11-21	AMUB	ETF	13.0977	13.0977	13.0977	13.0977	0.0
2019-11-21	AMZA	ETF	40.6	41.4	40.2	41.3	113490.0
2019-11-21	ANGL	ETF	29.14	29.17	29.04	29.06	378500.0
2019-11-21	AOA	ETF	56.62	56.64	56.42	56.61	35400.0
2019-11-21	AOK	ETF	35.98	36.01	35.9	35.97	102855.0
2019-11-21	AOM	ETF	39.72	39.78	39.65	39.7	195975.0
2019-11-21	AOR	ETF	47.02	47.02	46.8962	46.98	99163.0
2019-11-21	ARGT	ETF	22.57	22.71	22.46	22.64	48700.0
2019-11-21	ARKF	ETF	23.257	23.32	23.21	23.271	6900.0
2019-11-21	ARKG	ETF	32.85	32.85	32.219	32.38	72600.0
2019-11-21	ARKK	ETF	48.41	48.55	48.0	48.15	145800.0
2019-11-21	ARKQ	ETF	34.35	34.41	34.203	34.254	23600.0
2019-11-21	ARKW	ETF	54.65	54.95	54.4	54.54	41500.0
2019-11-21	ASEA	ETF	16.02	16.02	15.96	15.96	3900.0

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

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