PREVIEW / etf_daily / 2018-10-03

all etf daily files

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

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-03	SPY	ETF	292.74	293.21	291.32	291.72	64694600.0
2018-10-03	QQQ	ETF	186.52	186.97	185.66	185.95	29128683.0
2018-10-03	IWM	ETF	165.18	166.73	164.51	165.97	26027200.0
2018-10-03	DIA	ETF	268.77	269.28	267.67	267.95	5827700.0
2018-10-03	GLD	ETF	113.87	114.05	113.26	113.42	6674500.0
2018-10-03	TLT	ETF	116.27	116.36	114.24	114.83	20829200.0
2018-10-03	AAAU	ETF	12.04	12.04	11.98	11.98	26100.0
2018-10-03	AADR	ETF	53.21	53.64	53.02	53.38	21900.0
2018-10-03	AAXJ	ETF	69.31	69.51	68.52	68.64	968800.0
2018-10-03	ACES	ETF	26.07	26.07	25.741	25.741	300.0
2018-10-03	ACSI	ETF	33.867	33.89	33.7463	33.7463	3796.0
2018-10-03	ACTX	ETF	117.7061	118.0011	86.1408	100.3599	14889.0
2018-10-03	ACWF	ETF	30.7	30.7	30.565	30.62	10290.0
2018-10-03	ACWI	ETF	74.5	74.55	74.04	74.17	1080500.0
2018-10-03	ACWV	ETF	87.92	87.92	87.14	87.24	308800.0
2018-10-03	ACWX	ETF	47.64	47.64	47.2666	47.32	553589.0
2018-10-03	ADRE	ETF	41.05	41.05	40.41	40.47	10302.0
2018-10-03	AFIF	ETF	10.046	10.07	10.0438	10.0501	6184.0
2018-10-03	AFK	ETF	21.59	21.6	21.1136	21.26	9295.0
2018-10-03	AFTY	ETF	15.01	15.12	15.01	15.1	700.0
2018-10-03	AGG	ETF	105.22	105.24	104.75	104.86	2540500.0
2018-10-03	AGGY	ETF	48.31	48.32	48.05	48.13	108400.0
2018-10-03	AGNG	ETF	22.57	22.57	22.391	22.391	1300.0
2018-10-03	AGQ	ETF	24.27	24.55	24.05	24.17	102800.0
2018-10-03	AGZ	ETF	110.56	110.57	110.1912	110.31	176652.0
2018-10-03	AGZD	ETF	23.99	24.01	23.935	23.98	40600.0
2018-10-03	AIA	ETF	61.43	61.48	60.715	60.75	31172.0
2018-10-03	AIEQ	ETF	29.47	29.58	29.4	29.45	41100.0
2018-10-03	AIQ	ETF	15.7249	15.75	15.7	15.74	5915.0
2018-10-03	AIRR	ETF	27.64	27.829	27.4	27.741	7500.0
2018-10-03	AIVI	ETF	42.1	42.1	41.91	41.94	12400.0
2018-10-03	ALTY	ETF	15.15	15.15	14.961	15.0	8300.0
2018-10-03	AMJ	ETF	27.95	28.25	27.9	28.12	1295969.0
2018-10-03	AMLP	ETF	54.0	54.65	54.0	54.4	2514600.0
2018-10-03	AMZA	ETF	75.9	76.5	75.5	76.4	71950.0
2018-10-03	ANGL	ETF	29.01	29.07	28.94	28.94	1373200.0
2018-10-03	AOA	ETF	54.6	54.63	54.31	54.37	43700.0
2018-10-03	AOK	ETF	34.06	34.07	33.97	33.99	106716.0
2018-10-03	AOM	ETF	37.72	37.7485	37.5612	37.61	179723.0
2018-10-03	AOR	ETF	44.99	44.9999	44.78	44.84	111786.0
2018-10-03	ARGT	ETF	27.67	28.1	27.31	27.41	211800.0
2018-10-03	ARKG	ETF	31.74	32.17	31.62	31.96	161400.0
2018-10-03	ARKK	ETF	46.53	46.6	45.96	46.28	295900.0
2018-10-03	ARKQ	ETF	35.99	36.238	35.911	36.01	40700.0
2018-10-03	ARKW	ETF	57.45	57.5	56.96	57.25	226200.0
2018-10-03	ARVR	ETF	21.3	21.3003	21.2901	21.3003	1327.0
2018-10-03	ASEA	ETF	16.2	16.3	16.02	16.05	129900.0
2018-10-03	ASHR	ETF	24.98	25.01	24.76	24.77	1428900.0
2018-10-03	ASHS	ETF	25.18	25.18	25.0	25.04	2200.0
2018-10-03	ATMP	ETF	21.32	21.4	21.25	21.27	26900.0

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

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