PREVIEW / etf_daily / 2017-04-21

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-21.parquet
  size:    54 KB
  rows:    1,362

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
2017-04-21	SPY	ETF	235.25	235.31	234.13	234.59	110389800.0
2017-04-21	QQQ	ETF	132.7	132.76	132.22	132.56	22454948.0
2017-04-21	IWM	ETF	137.24	137.55	136.71	137.21	29386000.0
2017-04-21	DIA	ETF	205.51	205.73	204.77	205.25	3034800.0
2017-04-21	GLD	ETF	122.14	122.61	121.73	122.31	15608000.0
2017-04-21	TLT	ETF	123.82	124.24	123.49	123.54	9798500.0
2017-04-21	AADR	ETF	46.06	46.52	46.06	46.4	7300.0
2017-04-21	AAXJ	ETF	62.91	62.95	62.74	62.89	580400.0
2017-04-21	ACSI	ETF	28.0799	28.0799	28.05	28.05	310.0
2017-04-21	ACTX	ETF	92.3358	95.5809	89.0908	90.0348	856.0
2017-04-21	ACWI	ETF	63.07	63.12	62.91	63.02	2036300.0
2017-04-21	ACWV	ETF	77.56	77.64	77.46	77.56	43000.0
2017-04-21	ACWX	ETF	43.51	43.53	43.4234	43.52	314618.0
2017-04-21	ADRE	ETF	36.42	36.44	36.24	36.325	6987.0
2017-04-21	AFK	ETF	21.22	21.23	21.1	21.1	17132.0
2017-04-21	AFTY	ETF	13.67	13.67	13.67	13.67	300.0
2017-04-21	AGG	ETF	109.4	109.49	109.3	109.34	1539300.0
2017-04-21	AGGY	ETF	50.41	50.44	50.357	50.37	4600.0
2017-04-21	AGNG	ETF	17.074	17.074	17.074	17.074	100.0
2017-04-21	AGQ	ETF	39.84	39.97	39.3	39.96	203400.0
2017-04-21	AGZ	ETF	113.68	113.8	113.55	113.68	24340.0
2017-04-21	AGZD	ETF	24.0	24.0	24.0	24.0	1400.0
2017-04-21	AIA	ETF	52.11	52.2498	52.09	52.17	25585.0
2017-04-21	AIQ	ETF	13.0	13.15	13.0	13.1	27079.0
2017-04-21	AIRR	ETF	23.83	23.931	23.69	23.81	26200.0
2017-04-21	AIVI	ETF	38.95	39.0	38.88	38.95	6100.0
2017-04-21	ALTY	ETF	15.613	15.613	15.52	15.52	800.0
2017-04-21	AMJ	ETF	31.81	31.87	31.66	31.84	1523804.0
2017-04-21	AMLP	ETF	63.1	63.1	62.65	62.8	738740.0
2017-04-21	AMZA	ETF	105.2	105.2	104.3	104.5	39920.0
2017-04-21	ANGL	ETF	29.57	29.6	29.51	29.54	643600.0
2017-04-21	AOA	ETF	49.83	49.83	49.7	49.75	29800.0
2017-04-21	AOK	ETF	33.43	33.4599	33.41	33.42	31511.0
2017-04-21	AOM	ETF	36.42	36.436	36.36	36.42	71489.0
2017-04-21	AOR	ETF	42.32	42.33	42.24	42.33	49962.0
2017-04-21	ARCM	ETF	100.3	100.3	100.3	100.3	4040.0
2017-04-21	ARGT	ETF	28.89	28.89	28.62	28.66	128700.0
2017-04-21	ARKG	ETF	19.94	19.94	19.815	19.85	2300.0
2017-04-21	ARKK	ETF	24.59	24.59	24.32	24.34	5400.0
2017-04-21	ARKQ	ETF	25.5	25.5	25.29	25.306	16500.0
2017-04-21	ARKW	ETF	29.92	29.92	29.59	29.59	10600.0
2017-04-21	ASEA	ETF	14.25	14.28	14.2	14.2	10200.0
2017-04-21	ASET	ETF	26.819	26.83	26.7757	26.7998	3402.0
2017-04-21	ASHR	ETF	25.05	25.08	25.01	25.03	790200.0
2017-04-21	ASHS	ETF	33.04	33.04	32.96	32.96	5500.0
2017-04-21	ASHX	ETF	19.47	19.47	19.4611	19.47	913.0
2017-04-21	ATMP	ETF	23.31	23.42	23.25	23.34	10700.0
2017-04-21	BAB	ETF	29.59	29.6679	29.57	29.57	141532.0
2017-04-21	BAL	ETF	50.31	50.52	50.2388	50.5	2942.0
2017-04-21	BBC	ETF	22.16	22.16	21.67	21.7001	8332.0

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

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