PREVIEW / etf_daily / 2018-06-26

all etf daily files

  file:    by_date/etf_daily/2018/2018-06-26.parquet
  size:    61 KB
  rows:    1,566

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-06-26	SPY	ETF	271.64	272.56	270.79	271.6	68547400.0
2018-06-26	QQQ	ETF	171.99	173.0585	171.37	172.07	39008146.0
2018-06-26	IWM	ETF	165.23	166.66	164.85	166.04	20464000.0
2018-06-26	DIA	ETF	242.92	243.69	242.27	242.67	3829900.0
2018-06-26	GLD	ETF	119.28	119.59	119.09	119.26	8674500.0
2018-06-26	TLT	ETF	120.77	121.03	120.66	120.97	5450000.0
2018-06-26	AADR	ETF	54.1	54.51	54.02	54.25	29200.0
2018-06-26	AAXJ	ETF	72.02	72.23	71.63	71.86	845000.0
2018-06-26	ACSI	ETF	32.16	32.26	32.1252	32.26	1442.0
2018-06-26	ACTX	ETF	73.7507	78.4707	73.7507	76.4057	830.0
2018-06-26	ACWF	ETF	30.21	30.3	30.18	30.2	6641.0
2018-06-26	ACWI	ETF	71.23	71.34	70.9	71.1	1539200.0
2018-06-26	ACWV	ETF	83.13	83.31	82.99	83.06	92100.0
2018-06-26	ACWX	ETF	47.23	47.29	47.01	47.15	370480.0
2018-06-26	ADRE	ETF	40.01	41.22	40.01	41.05	69643.0
2018-06-26	AFK	ETF	23.49	23.753	23.02	23.3074	4491.0
2018-06-26	AFTY	ETF	15.62	15.62	15.51	15.58	5500.0
2018-06-26	AGG	ETF	105.99	106.05	105.94	106.05	2665200.0
2018-06-26	AGGY	ETF	48.29	48.37	48.29	48.34	37200.0
2018-06-26	AGNG	ETF	20.84	20.88	20.778	20.88	2100.0
2018-06-26	AGQ	ETF	30.52	30.52	30.18	30.37	224900.0
2018-06-26	AGZ	ETF	111.16	111.309	111.16	111.16	14525.0
2018-06-26	AGZD	ETF	23.83	23.83	23.82	23.83	2800.0
2018-06-26	AIA	ETF	62.7	62.83	62.42	62.42	83278.0
2018-06-26	AIEQ	ETF	28.27	28.27	28.0	28.17	52000.0
2018-06-26	AIQ	ETF	15.09	15.1144	14.9766	15.065	11653.0
2018-06-26	AIRR	ETF	26.738	26.96	26.661	26.9	4600.0
2018-06-26	AIVI	ETF	41.76	41.85	41.68	41.73	38800.0
2018-06-26	ALTY	ETF	14.9	14.9	14.87	14.87	39400.0
2018-06-26	AMJ	ETF	26.05	26.525	25.97	26.46	1899583.0
2018-06-26	AMLP	ETF	50.7	51.6	50.4	51.6	3344640.0
2018-06-26	AMZA	ETF	73.0	74.5	72.6	74.5	77500.0
2018-06-26	ANGL	ETF	28.89	28.92	28.85	28.86	192500.0
2018-06-26	AOA	ETF	53.33	53.5	53.27	53.42	43100.0
2018-06-26	AOK	ETF	33.88	33.9699	33.86	33.9	42275.0
2018-06-26	AOM	ETF	37.5	37.53	37.41	37.49	61936.0
2018-06-26	AOR	ETF	44.33	44.42	44.27	44.38	48985.0
2018-06-26	ARGT	ETF	28.39	28.68	28.25	28.27	73400.0
2018-06-26	ARKG	ETF	29.81	30.0	29.34	29.85	132000.0
2018-06-26	ARKK	ETF	45.51	45.95	45.046	45.77	519600.0
2018-06-26	ARKQ	ETF	34.49	34.88	34.435	34.78	12300.0
2018-06-26	ARKW	ETF	55.72	56.38	55.43	56.06	174100.0
2018-06-26	ASEA	ETF	15.42	15.43	15.38	15.42	3400.0
2018-06-26	ASET	ETF	27.685	27.82	27.685	27.82	2670.0
2018-06-26	ASHR	ETF	26.84	26.84	26.66	26.69	1512300.0
2018-06-26	ASHS	ETF	28.45	28.45	28.28	28.34	8700.0
2018-06-26	ATMP	ETF	19.79	20.23	19.79	20.17	12700.0
2018-06-26	BAB	ETF	29.47	29.53	29.44	29.49	62116.0
2018-06-26	BAL	ETF	52.43	52.43	52.375	52.375	300.0
2018-06-26	BAR	ETF	12.579	12.597	12.5557	12.571	111360.0

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

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