PREVIEW / etf_daily / 2019-10-04

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-04.parquet
  size:    71 KB
  rows:    1,839

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-10-04	SPY	ETF	291.14	294.63	291.08	294.35	65091200.0
2019-10-04	QQQ	ETF	186.99	189.08	186.88	188.81	32752668.0
2019-10-04	IWM	ETF	147.99	149.25	147.12	149.14	18640400.0
2019-10-04	DIA	ETF	262.88	265.85	262.72	265.66	2937500.0
2019-10-04	GLD	ETF	141.48	142.31	141.14	141.9	9651000.0
2019-10-04	TLT	ETF	145.35	146.03	145.2	145.99	11516200.0
2019-10-04	AAAU	ETF	14.99	15.05	14.96	15.03	69900.0
2019-10-04	AADR	ETF	47.53	47.97	47.41	47.87	4300.0
2019-10-04	AAXJ	ETF	66.04	66.49	65.91	66.43	555100.0
2019-10-04	ACES	ETF	30.4	30.765	30.33	30.765	40500.0
2019-10-04	ACIO	ETF	24.336	24.41	24.336	24.41	3500.0
2019-10-04	ACSI	ETF	33.269	33.5308	33.18	33.5308	1001.0
2019-10-04	ACTX	ETF	12.3901	15.9891	11.8001	12.396	713.0
2019-10-04	ACWF	ETF	28.4438	28.6571	28.4438	28.6571	2857.0
2019-10-04	ACWI	ETF	72.38	73.07	72.36	73.04	2933400.0
2019-10-04	ACWV	ETF	93.92	94.86	93.89	94.77	276600.0
2019-10-04	ACWX	ETF	45.26	45.55	45.19	45.55	1503413.0
2019-10-04	ADRE	ETF	38.41	38.57	38.3423	38.57	3697.0
2019-10-04	AFIF	ETF	9.81	9.81	9.805	9.805	1988.0
2019-10-04	AFK	ETF	19.87	20.0657	19.75	20.035	5104.0
2019-10-04	AFTY	ETF	16.61	16.775	16.61	16.775	900.0
2019-10-04	AGG	ETF	113.68	113.83	113.63	113.82	3331200.0
2019-10-04	AGGY	ETF	52.66	52.72	52.62	52.681	779200.0
2019-10-04	AGNG	ETF	21.2	21.271	21.177	21.177	4800.0
2019-10-04	AGQ	ETF	30.8	31.47	30.67	31.3	205300.0
2019-10-04	AGZ	ETF	117.04	117.1199	117.01	117.04	34400.0
2019-10-04	AGZD	ETF	23.845	23.865	23.805	23.81	8400.0
2019-10-04	AIA	ETF	58.41	58.8	58.28	58.69	36429.0
2019-10-04	AIEQ	ETF	25.74	26.07	25.74	26.03	24100.0
2019-10-04	AIQ	ETF	15.75	15.9092	15.75	15.9063	1826.0
2019-10-04	AIRR	ETF	25.97	26.149	25.932	26.149	1400.0
2019-10-04	AIVI	ETF	39.46	39.78	39.46	39.76	5800.0
2019-10-04	ALTY	ETF	14.62	14.665	14.6	14.636	11800.0
2019-10-04	AMJ	ETF	23.05	23.15	22.89	22.95	939329.0
2019-10-04	AMLP	ETF	45.2	45.5	45.0	45.25	2832080.0
2019-10-04	AMOM	ETF	25.96	26.187	25.96	26.187	300.0
2019-10-04	AMUB	ETF	14.5031	14.5031	14.5031	14.5031	0.0
2019-10-04	AMZA	ETF	48.2	48.7	48.1	48.5	52740.0
2019-10-04	ANGL	ETF	29.01	29.11	28.96	29.03	1836300.0
2019-10-04	AOA	ETF	53.99	54.39	53.99	54.37	31800.0
2019-10-04	AOK	ETF	35.49	35.67	35.49	35.63	63479.0
2019-10-04	AOM	ETF	38.92	39.0999	38.92	39.04	116422.0
2019-10-04	AOR	ETF	45.37	45.69	45.37	45.67	45355.0
2019-10-04	ARGT	ETF	22.87	23.16	22.86	23.13	21000.0
2019-10-04	ARKF	ETF	21.37	21.577	21.32	21.577	4800.0
2019-10-04	ARKG	ETF	28.72	29.09	28.47	29.09	52200.0
2019-10-04	ARKK	ETF	41.64	42.0	41.295	41.97	231700.0
2019-10-04	ARKQ	ETF	31.17	31.33	31.11	31.33	3800.0
2019-10-04	ARKW	ETF	48.1	48.6	47.83	48.6	45700.0
2019-10-04	ASEA	ETF	15.42	15.44	15.35	15.44	1100.0

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

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