PREVIEW / etf_daily / 2018-11-27

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-27.parquet
  size:    64 KB
  rows:    1,661

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
2018-11-27	SPY	ETF	266.34	268.4	265.66	268.4	75502400.0
2018-11-27	QQQ	ETF	162.0	163.85	161.18	163.44	36608063.0
2018-11-27	IWM	ETF	149.18	149.73	148.29	148.57	14461800.0
2018-11-27	DIA	ETF	245.18	247.53	244.14	247.5	2932000.0
2018-11-27	GLD	ETF	115.55	115.63	114.6	114.95	9671100.0
2018-11-27	TLT	ETF	114.81	115.25	114.76	115.01	5967200.0
2018-11-27	AAAU	ETF	12.22	12.22	12.14	12.14	3400.0
2018-11-27	AADR	ETF	43.03	43.6	42.7	43.6	43900.0
2018-11-27	AAXJ	ETF	65.43	65.94	65.2	65.94	1308800.0
2018-11-27	ACES	ETF	24.92	24.99	24.916	24.99	2600.0
2018-11-27	ACSI	ETF	32.14	32.2701	32.14	32.2701	4033.0
2018-11-27	ACTX	ETF	64.9006	66.0806	59.8855	63.1306	501.0
2018-11-27	ACWF	ETF	28.0635	28.08	27.9543	28.0168	16474.0
2018-11-27	ACWI	ETF	68.13	68.52	67.94	68.52	3520700.0
2018-11-27	ACWV	ETF	84.86	85.06	84.6	85.03	1120100.0
2018-11-27	ACWX	ETF	44.04	44.18	43.8899	44.18	3163281.0
2018-11-27	ADRE	ETF	37.23	37.5695	37.23	37.5695	5233.0
2018-11-27	AFIF	ETF	10.0	10.03	9.99	10.0079	25333.0
2018-11-27	AFK	ETF	20.64	20.64	20.3111	20.335	3094.0
2018-11-27	AFTY	ETF	13.97	13.97	13.88	13.9	7200.0
2018-11-27	AGG	ETF	104.58	104.74	104.58	104.66	4107700.0
2018-11-27	AGGY	ETF	47.38	47.57	47.37	47.426	127200.0
2018-11-27	AGNG	ETF	19.92	19.92	19.89	19.92	1000.0
2018-11-27	AGQ	ETF	22.62	22.67	22.08	22.22	70300.0
2018-11-27	AGZ	ETF	110.73	110.7828	110.67	110.67	8325.0
2018-11-27	AGZD	ETF	23.845	23.845	23.74	23.74	148000.0
2018-11-27	AIA	ETF	56.96	57.4	56.83	57.34	70322.0
2018-11-27	AIEQ	ETF	25.74	25.802	25.611	25.78	19900.0
2018-11-27	AIQ	ETF	13.51	13.62	13.5	13.59	21270.0
2018-11-27	AIRR	ETF	24.61	24.62	24.43	24.485	9800.0
2018-11-27	AIVI	ETF	39.54	39.61	39.4	39.6	10000.0
2018-11-27	ALTY	ETF	14.4	14.41	14.384	14.391	4800.0
2018-11-27	AMJ	ETF	24.73	24.965	24.65	24.7	1926886.0
2018-11-27	AMLP	ETF	47.3	47.7	46.95	47.05	3645760.0
2018-11-27	AMUB	ETF	15.65	15.65	15.65	15.65	200.0
2018-11-27	AMZA	ETF	60.6	61.0	59.5	59.6	95770.0
2018-11-27	ANGL	ETF	27.32	27.41	27.31	27.34	655500.0
2018-11-27	AOA	ETF	50.77	51.02	50.71	51.02	46400.0
2018-11-27	AOK	ETF	33.02	33.14	33.0021	33.09	145177.0
2018-11-27	AOM	ETF	36.31	36.41	36.2	36.41	255366.0
2018-11-27	AOR	ETF	42.55	42.711	42.47	42.67	88818.0
2018-11-27	ARGT	ETF	25.15	25.2	24.72	24.85	44400.0
2018-11-27	ARKG	ETF	28.58	28.769	28.384	28.46	141200.0
2018-11-27	ARKK	ETF	42.69	42.94	42.33	42.53	143900.0
2018-11-27	ARKQ	ETF	32.48	32.718	32.34	32.39	5500.0
2018-11-27	ARKW	ETF	50.92	51.54	50.654	51.39	62200.0
2018-11-27	ARVR	ETF	17.37	17.37	17.37	17.37	101.0
2018-11-27	ASEA	ETF	15.71	15.71	15.71	15.71	1500.0
2018-11-27	ASET	ETF	26.82	26.9651	26.0396	26.0396	906.0
2018-11-27	ASHR	ETF	22.85	22.98	22.78	22.98	1336500.0

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

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