PREVIEW / etf_daily / 2019-03-27

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-27.parquet
  size:    68 KB
  rows:    1,767

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-03-27	SPY	ETF	281.11	281.76	277.93	279.65	72224700.0
2019-03-27	QQQ	ETF	179.27	179.72	176.6	177.9	37096697.0
2019-03-27	IWM	ETF	151.71	152.21	149.48	151.27	23477100.0
2019-03-27	DIA	ETF	256.63	257.43	254.1	256.11	3166200.0
2019-03-27	GLD	ETF	124.35	124.38	123.56	123.65	6595000.0
2019-03-27	TLT	ETF	125.42	126.34	125.31	126.12	14207200.0
2019-03-27	AAAU	ETF	13.15	13.15	13.08	13.08	14300.0
2019-03-27	AADR	ETF	45.2	45.2	44.57	44.61	4200.0
2019-03-27	AAXJ	ETF	69.67	69.79	69.19	69.42	660200.0
2019-03-27	ACES	ETF	26.93	26.989	26.75	26.896	11200.0
2019-03-27	ACSI	ETF	32.4699	32.4699	32.1301	32.3253	1157.0
2019-03-27	ACTX	ETF	54.2805	56.0505	50.1505	50.2094	1005.0
2019-03-27	ACWF	ETF	28.84	28.84	28.5817	28.7189	1995.0
2019-03-27	ACWI	ETF	71.82	71.94	71.09	71.49	2407800.0
2019-03-27	ACWV	ETF	89.22	89.29	88.63	88.9	190900.0
2019-03-27	ACWX	ETF	46.13	46.2	45.74	45.96	1053046.0
2019-03-27	ADRE	ETF	40.5	40.6	40.287	40.43	2297.0
2019-03-27	AFIF	ETF	9.9937	10.02	9.97	9.99	19282.0
2019-03-27	AFK	ETF	21.5	21.5	21.29	21.39	11048.0
2019-03-27	AFTY	ETF	16.218	16.218	16.07	16.169	5300.0
2019-03-27	AGG	ETF	109.0	109.18	108.99	109.07	3719600.0
2019-03-27	AGGY	ETF	49.82	49.93	49.81	49.89	103500.0
2019-03-27	AGNG	ETF	21.275	21.328	21.142	21.328	2000.0
2019-03-27	AGQ	ETF	25.39	25.42	25.03	25.05	167100.0
2019-03-27	AGZ	ETF	113.6467	113.7	113.61	113.61	11670.0
2019-03-27	AGZD	ETF	23.83	23.86	23.805	23.86	34200.0
2019-03-27	AIA	ETF	60.54	60.6	60.09	60.41	29701.0
2019-03-27	AIEQ	ETF	25.59	25.76	25.391	25.55	38400.0
2019-03-27	AIQ	ETF	15.72	15.72	15.421	15.5078	6682.0
2019-03-27	AIRR	ETF	24.12	24.12	23.91	24.02	13200.0
2019-03-27	AIVI	ETF	41.06	41.2	40.96	41.2	6300.0
2019-03-27	ALTY	ETF	14.76	14.92	14.722	14.796	11400.0
2019-03-27	AMJ	ETF	25.41	25.5	25.13	25.25	891951.0
2019-03-27	AMLP	ETF	50.1	50.2	49.5	49.7	2484660.0
2019-03-27	AMUB	ETF	15.9037	15.9037	15.9037	15.9037	0.0
2019-03-27	AMZA	ETF	59.5	59.61	58.7	58.8	84990.0
2019-03-27	ANGL	ETF	28.75	28.81	28.66	28.68	351800.0
2019-03-27	AOA	ETF	53.3	53.35	52.92	53.19	60600.0
2019-03-27	AOK	ETF	34.44	34.48	34.37	34.45	36703.0
2019-03-27	AOM	ETF	37.98	38.0003	37.85	37.96	83157.0
2019-03-27	AOR	ETF	44.59	44.66	44.34	44.51	112403.0
2019-03-27	ARGT	ETF	27.48	27.48	26.66	26.92	83500.0
2019-03-27	ARKF	ETF	21.345	21.37	21.0	21.182	36600.0
2019-03-27	ARKG	ETF	32.2	32.23	31.24	31.78	105500.0
2019-03-27	ARKK	ETF	46.14	46.38	44.922	45.65	653400.0
2019-03-27	ARKQ	ETF	33.695	33.695	33.11	33.47	6400.0
2019-03-27	ARKW	ETF	51.3	51.56	50.03	50.59	71700.0
2019-03-27	ASEA	ETF	15.9	15.9	15.62	15.68	14600.0
2019-03-27	ASET	ETF	28.97	28.97	28.93	28.93	871.0
2019-03-27	ASHR	ETF	27.71	27.79	27.54	27.72	6735300.0

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

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