PREVIEW / etf_daily / 2019-01-18

all etf daily files

  file:    by_date/etf_daily/2019/2019-01-18.parquet
  size:    67 KB
  rows:    1,739

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-01-18	SPY	ETF	264.98	266.98	263.0	266.46	127900300.0
2019-01-18	QQQ	ETF	164.84	166.02	163.82	165.25	57183243.0
2019-01-18	IWM	ETF	146.6	147.92	146.0	147.33	28306700.0
2019-01-18	DIA	ETF	245.65	247.4	244.51	247.05	5393200.0
2019-01-18	GLD	ETF	121.23	121.52	121.02	121.02	10896000.0
2019-01-18	TLT	ETF	119.84	120.12	119.39	119.56	14106400.0
2019-01-18	AAAU	ETF	12.82	12.83	12.8	12.81	30800.0
2019-01-18	AADR	ETF	42.95	43.07	42.72	42.87	21700.0
2019-01-18	AAXJ	ETF	66.73	67.08	66.63	66.9	915900.0
2019-01-18	ACES	ETF	24.75	24.82	24.677	24.677	8900.0
2019-01-18	ACSI	ETF	30.9501	31.1078	30.95	31.0626	1637.0
2019-01-18	ACTX	ETF	51.9205	53.6905	50.7405	53.1005	685.0
2019-01-18	ACWF	ETF	27.7	27.87	27.68	27.84	324441.0
2019-01-18	ACWI	ETF	68.02	68.36	67.82	68.23	5224300.0
2019-01-18	ACWV	ETF	83.73	84.12	83.67	84.1	145800.0
2019-01-18	ACWX	ETF	44.33	44.45	44.23	44.39	4288627.0
2019-01-18	ADRE	ETF	39.3082	39.3082	39.1536	39.2371	5512.0
2019-01-18	AFIF	ETF	9.94	9.97	9.93	9.935	8957.0
2019-01-18	AFK	ETF	20.9	20.9	20.59	20.68	5449.0
2019-01-18	AFTY	ETF	14.19	14.26	14.19	14.221	16500.0
2019-01-18	AGG	ETF	106.37	106.48	106.28	106.35	5643400.0
2019-01-18	AGGY	ETF	48.36	48.448	48.36	48.402	30400.0
2019-01-18	AGNG	ETF	20.36	20.65	20.36	20.65	1500.0
2019-01-18	AGQ	ETF	25.97	26.12	25.72	25.75	176100.0
2019-01-18	AGZ	ETF	112.02	112.0385	111.8023	111.87	81240.0
2019-01-18	AGZD	ETF	23.725	23.765	23.725	23.765	11400.0
2019-01-18	AIA	ETF	58.13	58.5162	58.09	58.38	84513.0
2019-01-18	AIEQ	ETF	24.0	24.245	23.95	24.24	30900.0
2019-01-18	AIQ	ETF	14.05	14.28	14.05	14.18	15146.0
2019-01-18	AIRR	ETF	23.67	24.1	23.67	23.982	39100.0
2019-01-18	AIVI	ETF	39.58	39.72	39.55	39.7	103400.0
2019-01-18	ALTY	ETF	14.39	14.39	14.3	14.3	7900.0
2019-01-18	AMJ	ETF	24.85	25.05	24.705	25.01	1942368.0
2019-01-18	AMLP	ETF	48.95	49.35	48.6	49.3	3415580.0
2019-01-18	AMUB	ETF	15.736	15.736	15.736	15.736	0.0
2019-01-18	AMZA	ETF	58.9	59.5	58.62	59.0	118910.0
2019-01-18	ANGL	ETF	27.97	28.09	27.95	27.96	268700.0
2019-01-18	AOA	ETF	50.92	51.08	50.77	51.02	186000.0
2019-01-18	AOK	ETF	33.31	33.4055	33.31	33.37	162235.0
2019-01-18	AOM	ETF	36.52	36.63	36.52	36.62	437085.0
2019-01-18	AOR	ETF	42.7	42.87	42.67	42.81	250156.0
2019-01-18	ARCM	ETF	99.86	99.915	99.85	99.915	2100.0
2019-01-18	ARGT	ETF	26.38	26.81	26.38	26.69	22200.0
2019-01-18	ARKG	ETF	28.89	28.9	28.32	28.83	157100.0
2019-01-18	ARKK	ETF	42.85	43.14	42.4	42.8	490700.0
2019-01-18	ARKQ	ETF	31.72	32.129	31.68	31.89	23000.0
2019-01-18	ARKW	ETF	48.36	48.93	48.03	48.47	145400.0
2019-01-18	ASEA	ETF	15.99	16.24	15.99	16.12	3200.0
2019-01-18	ASET	ETF	27.05	27.05	27.0372	27.05	13402.0
2019-01-18	ASHR	ETF	23.55	23.64	23.5	23.53	3935400.0

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

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