PREVIEW / etf_daily / 2018-12-28

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-28.parquet
  size:    67 KB
  rows:    1,738

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-12-28	SPY	ETF	249.58	251.4	246.45	247.75	153100200.0
2018-12-28	QQQ	ETF	154.01	155.59	151.72	152.97	77856625.0
2018-12-28	IWM	ETF	132.48	135.01	131.54	132.86	35994400.0
2018-12-28	DIA	ETF	232.71	233.81	229.67	230.48	7266800.0
2018-12-28	GLD	ETF	120.8	121.08	120.72	121.06	6864700.0
2018-12-28	TLT	ETF	120.4	121.05	120.29	121.05	9879100.0
2018-12-28	AAAU	ETF	12.79	12.8	12.77	12.8	98200.0
2018-12-28	AADR	ETF	39.86	40.28	39.57	39.99	66800.0
2018-12-28	AAXJ	ETF	63.67	64.12	63.48	63.71	1256500.0
2018-12-28	ACES	ETF	23.17	23.17	22.43	22.66	35200.0
2018-12-28	ACSI	ETF	28.8107	28.8107	28.66	28.6937	2038.0
2018-12-28	ACTX	ETF	50.1505	53.1005	46.0204	47.7904	520.0
2018-12-28	ACWF	ETF	25.9955	26.1	25.76	25.7934	57487.0
2018-12-28	ACWI	ETF	64.08	64.47	63.58	63.85	13396000.0
2018-12-28	ACWV	ETF	81.19	81.5	80.66	80.92	873200.0
2018-12-28	ACWX	ETF	41.97	42.08	41.73	41.89	6739220.0
2018-12-28	ADRE	ETF	36.34	36.4916	36.18	36.19	12935.0
2018-12-28	AFIF	ETF	9.8914	9.93	9.87	9.9	36408.0
2018-12-28	AFK	ETF	19.68	19.7999	19.67	19.756	9218.0
2018-12-28	AFTY	ETF	13.04	13.205	13.04	13.12	9800.0
2018-12-28	AGG	ETF	105.97	106.22	105.94	106.22	7019600.0
2018-12-28	AGGY	ETF	47.96	48.1	47.93	48.1	103800.0
2018-12-28	AGNG	ETF	18.854	18.977	18.729	18.966	3600.0
2018-12-28	AGQ	ETF	26.0	26.12	25.74	26.08	103900.0
2018-12-28	AGZ	ETF	111.8661	112.03	111.8661	111.96	26413.0
2018-12-28	AGZD	ETF	23.645	23.7	23.62	23.7	72200.0
2018-12-28	AIA	ETF	55.45	55.67	55.2	55.32	88520.0
2018-12-28	AIEQ	ETF	21.88	21.95	21.525	21.65	82400.0
2018-12-28	AIQ	ETF	12.89	13.0583	12.79	12.84	8580.0
2018-12-28	AIRR	ETF	21.42	21.81	21.15	21.47	151700.0
2018-12-28	AIVI	ETF	37.94	37.94	37.66	37.75	25900.0
2018-12-28	ALTY	ETF	13.36	13.49	13.346	13.4	11100.0
2018-12-28	AMJ	ETF	22.12	22.21	21.59	21.95	11193782.0
2018-12-28	AMLP	ETF	43.4	43.6	42.35	43.2	11202260.0
2018-12-28	AMUB	ETF	13.85	13.85	13.7861	13.7861	100.0
2018-12-28	AMZA	ETF	50.0	50.7	48.61	49.5	144040.0
2018-12-28	ANGL	ETF	26.62	26.81	26.59	26.72	542100.0
2018-12-28	AOA	ETF	48.51	48.73	48.16	48.34	561300.0
2018-12-28	AOK	ETF	32.73	32.755	32.57	32.63	800176.0
2018-12-28	AOM	ETF	35.58	35.77	35.5	35.61	1382817.0
2018-12-28	AOR	ETF	41.14	41.34	41.005	41.09	1297628.0
2018-12-28	ARGT	ETF	23.16	23.4	22.79	23.1	126000.0
2018-12-28	ARKG	ETF	23.26	23.8	22.981	23.35	177600.0
2018-12-28	ARKK	ETF	36.63	37.404	36.04	36.77	939300.0
2018-12-28	ARKQ	ETF	29.77	29.93	29.152	29.5	27900.0
2018-12-28	ARKW	ETF	42.3	42.774	41.384	42.01	173800.0
2018-12-28	ASEA	ETF	15.37	15.39	15.25	15.26	1700.0
2018-12-28	ASET	ETF	25.44	25.51	25.3901	25.51	862.0
2018-12-28	ASHR	ETF	21.93	22.09	21.87	22.01	2091800.0
2018-12-28	ASHS	ETF	22.42	22.42	22.22	22.23	11600.0

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

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