PREVIEW / etf_daily / 2019-06-17

all etf daily files

  file:    by_date/etf_daily/2019/2019-06-17.parquet
  size:    69 KB
  rows:    1,809

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-06-17	SPY	ETF	289.52	290.22	289.18	289.37	39205700.0
2019-06-17	QQQ	ETF	183.01	184.25	182.835	183.74	20379476.0
2019-06-17	IWM	ETF	151.87	152.9	151.67	152.24	12509300.0
2019-06-17	DIA	ETF	261.64	262.18	260.97	261.68	1319500.0
2019-06-17	GLD	ETF	126.7	126.77	126.17	126.48	4763300.0
2019-06-17	TLT	ETF	131.39	131.76	131.13	131.69	6046400.0
2019-06-17	AAAU	ETF	13.41	13.46	13.35	13.4	42500.0
2019-06-17	AADR	ETF	47.99	48.17	47.92	48.05	1800.0
2019-06-17	AAXJ	ETF	66.16	66.4	66.09	66.25	1071700.0
2019-06-17	ACES	ETF	28.56	28.64	28.5	28.595	13500.0
2019-06-17	ACSI	ETF	33.5099	33.53	33.4952	33.4952	893.0
2019-06-17	ACTX	ETF	16.5142	16.5142	11.8001	12.3901	2495.0
2019-06-17	ACWF	ETF	28.44	28.4742	28.37	28.37	3906.0
2019-06-17	ACWI	ETF	71.95	72.09	71.85	71.94	1088000.0
2019-06-17	ACWV	ETF	91.23	91.23	91.04	91.06	296900.0
2019-06-17	ACWX	ETF	45.19	45.32	45.17	45.25	367565.0
2019-06-17	ADRE	ETF	38.39	38.5343	38.39	38.44	1474.0
2019-06-17	AFIF	ETF	9.86	9.8685	9.85	9.86	7501.0
2019-06-17	AFK	ETF	20.98	21.16	20.98	21.11	7054.0
2019-06-17	AFTY	ETF	16.46	16.47	16.447	16.447	1800.0
2019-06-17	AGG	ETF	110.52	110.6	110.46	110.54	3312600.0
2019-06-17	AGGY	ETF	50.8	50.84	50.75	50.81	83400.0
2019-06-17	AGNG	ETF	21.04	21.2	21.04	21.19	2400.0
2019-06-17	AGQ	ETF	23.45	23.45	23.17	23.24	140400.0
2019-06-17	AGZ	ETF	114.81	114.87	114.79	114.86	18714.0
2019-06-17	AGZD	ETF	23.79	23.79	23.79	23.79	1400.0
2019-06-17	AIA	ETF	57.6	57.6284	57.44	57.54	103135.0
2019-06-17	AIEQ	ETF	25.81	25.905	25.76	25.76	26200.0
2019-06-17	AIQ	ETF	15.83	15.83	15.77	15.7948	9986.0
2019-06-17	AIRR	ETF	25.14	25.14	25.02	25.07	2900.0
2019-06-17	AIVI	ETF	40.61	40.66	40.59	40.59	2500.0
2019-06-17	ALTY	ETF	14.9	14.9	14.8	14.825	5500.0
2019-06-17	AMJ	ETF	24.64	24.67	24.46	24.55	922406.0
2019-06-17	AMLP	ETF	48.55	48.65	48.15	48.35	2291120.0
2019-06-17	AMOM	ETF	25.678	25.678	25.678	25.678	100.0
2019-06-17	AMUB	ETF	15.4811	15.4811	15.4811	15.4811	0.0
2019-06-17	AMZA	ETF	54.3	54.49	53.8	54.4	40710.0
2019-06-17	ANGL	ETF	28.85	28.87	28.81	28.84	134400.0
2019-06-17	AOA	ETF	53.98	54.05	53.88	53.97	33900.0
2019-06-17	AOK	ETF	34.91	34.94	34.86	34.92	67549.0
2019-06-17	AOM	ETF	38.52	38.5499	38.46	38.51	155315.0
2019-06-17	AOR	ETF	45.2	45.22	45.13	45.18	325455.0
2019-06-17	ARGT	ETF	31.43	31.67	31.31	31.44	52200.0
2019-06-17	ARKF	ETF	22.03	22.128	22.004	22.075	8800.0
2019-06-17	ARKG	ETF	30.5	31.73	30.5	31.67	87600.0
2019-06-17	ARKK	ETF	43.17	44.63	43.154	44.41	208400.0
2019-06-17	ARKQ	ETF	30.73	31.237	30.73	31.049	14100.0
2019-06-17	ARKW	ETF	49.6	50.6	49.55	50.42	104100.0
2019-06-17	ASEA	ETF	16.3	16.3	16.05	16.05	100.0
2019-06-17	ASET	ETF	29.44	29.446	29.44	29.446	450.0

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

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