PREVIEW / etf_daily / 2018-10-30

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-30.parquet
  size:    64 KB
  rows:    1,655

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-10-30	SPY	ETF	263.67	268.12	263.12	267.77	157116000.0
2018-10-30	QQQ	ETF	162.8	166.035	162.015	165.92	92583965.0
2018-10-30	IWM	ETF	146.85	149.89	146.56	149.73	29017200.0
2018-10-30	DIA	ETF	244.44	248.94	244.09	248.7	6151100.0
2018-10-30	GLD	ETF	115.85	116.04	115.64	115.8	7233300.0
2018-10-30	TLT	ETF	114.26	114.54	114.02	114.16	9939500.0
2018-10-30	AAAU	ETF	12.2	12.25	12.2	12.24	11000.0
2018-10-30	AADR	ETF	45.08	45.74	44.3	45.54	35200.0
2018-10-30	AAXJ	ETF	61.43	62.16	61.28	62.16	766800.0
2018-10-30	ACES	ETF	23.71	24.05	23.71	23.99	32200.0
2018-10-30	ACSI	ETF	31.7099	31.82	31.7099	31.8059	2615.0
2018-10-30	ACTX	ETF	75.5207	77.2907	59.0005	63.7206	2636.0
2018-10-30	ACWF	ETF	27.6155	27.6824	27.53	27.63	4284.0
2018-10-30	ACWI	ETF	67.02	68.05	66.97	67.99	5115500.0
2018-10-30	ACWV	ETF	82.65	83.62	82.62	83.61	84900.0
2018-10-30	ACWX	ETF	43.06	43.515	42.98	43.5	1982055.0
2018-10-30	ADRE	ETF	36.1174	36.88	36.1174	36.87	8126.0
2018-10-30	AFIF	ETF	10.72	10.72	10.01	10.0499	13376.0
2018-10-30	AFK	ETF	19.87	20.09	19.87	19.97	3573.0
2018-10-30	AFTY	ETF	13.94	14.03	13.935	13.98	19300.0
2018-10-30	AGG	ETF	104.68	104.78	104.64	104.64	2552000.0
2018-10-30	AGGY	ETF	47.63	47.68	47.6	47.64	76900.0
2018-10-30	AGNG	ETF	19.25	19.48	19.25	19.446	1900.0
2018-10-30	AGQ	ETF	23.3	23.54	23.3	23.46	48300.0
2018-10-30	AGZ	ETF	110.57	110.6699	110.57	110.6062	6680.0
2018-10-30	AGZD	ETF	23.79	23.855	23.76	23.8	9400.0
2018-10-30	AIA	ETF	53.81	54.55	53.81	54.45	64423.0
2018-10-30	AIEQ	ETF	25.56	26.106	25.56	26.05	47800.0
2018-10-30	AIQ	ETF	13.18	13.47	13.18	13.465	36585.0
2018-10-30	AIRR	ETF	24.05	24.4	24.05	24.4	51400.0
2018-10-30	AIVI	ETF	39.2	39.54	39.2	39.54	4900.0
2018-10-30	ALTY	ETF	14.34	14.35	14.31	14.31	4500.0
2018-10-30	AMJ	ETF	24.89	25.29	24.76	25.1	2584893.0
2018-10-30	AMLP	ETF	48.15	49.45	47.95	49.45	3755480.0
2018-10-30	AMZA	ETF	62.1	63.21	61.3	62.9	141400.0
2018-10-30	ANGL	ETF	28.25	28.27	28.12	28.21	490100.0
2018-10-30	AOA	ETF	50.12	50.74	50.08	50.74	55100.0
2018-10-30	AOK	ETF	32.94	33.07	32.9268	33.06	110521.0
2018-10-30	AOM	ETF	36.12	36.24	36.0423	36.21	210596.0
2018-10-30	AOR	ETF	42.19	42.5	42.16	42.5	134837.0
2018-10-30	ARCM	ETF	100.2	100.2	100.2	100.2	50000.0
2018-10-30	ARGT	ETF	24.12	24.62	23.87	24.57	13100.0
2018-10-30	ARKG	ETF	25.86	27.067	25.86	26.88	166700.0
2018-10-30	ARKK	ETF	40.19	41.63	40.092	41.52	507400.0
2018-10-30	ARKQ	ETF	31.09	31.855	30.84	31.79	31100.0
2018-10-30	ARKW	ETF	49.31	51.215	49.115	51.09	126600.0
2018-10-30	ARVR	ETF	18.2821	18.71	18.2821	18.41	916.0
2018-10-30	ASEA	ETF	15.07	15.07	15.07	15.07	1000.0
2018-10-30	ASET	ETF	26.47	26.51	26.38	26.483	2655.0
2018-10-30	ASHR	ETF	22.5	22.75	22.49	22.71	2650000.0

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

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