PREVIEW / etf_daily / 2019-01-08

all etf daily files

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

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-08	SPY	ETF	256.82	257.31	254.0	256.77	102512600.0
2019-01-08	QQQ	ETF	159.56	160.11	157.2	159.52	49388694.0
2019-01-08	IWM	ETF	140.8	141.79	139.39	141.73	27320900.0
2019-01-08	DIA	ETF	237.94	238.66	235.79	237.92	4845800.0
2019-01-08	GLD	ETF	121.15	121.71	121.06	121.53	7643100.0
2019-01-08	TLT	ETF	121.69	121.94	121.39	121.43	7737100.0
2019-01-08	AAAU	ETF	12.78	12.85	12.78	12.85	17200.0
2019-01-08	AADR	ETF	42.2	42.29	41.78	42.21	22300.0
2019-01-08	AAXJ	ETF	64.08	64.27	63.61	64.18	1385800.0
2019-01-08	ACES	ETF	23.563	23.818	23.563	23.818	2500.0
2019-01-08	ACSI	ETF	29.9501	30.049	29.76	30.049	2282.0
2019-01-08	ACTX	ETF	53.1005	54.2805	50.1505	52.5105	763.0
2019-01-08	ACWF	ETF	26.73	26.76	26.5	26.7	71686.0
2019-01-08	ACWI	ETF	65.95	66.1	65.46	65.94	4535800.0
2019-01-08	ACWV	ETF	82.33	82.43	81.82	82.36	235000.0
2019-01-08	ACWX	ETF	43.03	43.12	42.85	43.04	2304869.0
2019-01-08	ADRE	ETF	37.36	37.75	37.2257	37.75	4366.0
2019-01-08	AFIF	ETF	9.55	9.95	9.55	9.92	25119.0
2019-01-08	AFK	ETF	20.1799	20.1799	20.1118	20.1168	1121.0
2019-01-08	AFTY	ETF	13.34	13.374	13.34	13.366	400.0
2019-01-08	AGG	ETF	106.4	106.53	106.38	106.43	4395600.0
2019-01-08	AGGY	ETF	48.35	48.37	48.31	48.326	43300.0
2019-01-08	AGNG	ETF	19.67	19.88	19.67	19.762	3000.0
2019-01-08	AGQ	ETF	26.77	27.05	26.77	26.93	98100.0
2019-01-08	AGZ	ETF	112.1	112.1491	112.01	112.03	99339.0
2019-01-08	AGZD	ETF	23.715	23.795	23.585	23.795	17200.0
2019-01-08	AIA	ETF	55.29	55.45	54.9819	55.3	73737.0
2019-01-08	AIEQ	ETF	22.92	22.979	22.621	22.95	23400.0
2019-01-08	AIQ	ETF	13.54	13.61	13.36	13.56	9696.0
2019-01-08	AIRR	ETF	22.83	22.98	22.65	22.98	25800.0
2019-01-08	AIVI	ETF	38.98	38.98	38.78	38.92	9600.0
2019-01-08	ALTY	ETF	13.922	14.03	13.922	14.03	8300.0
2019-01-08	AMJ	ETF	24.57	25.06	24.5	24.89	6121880.0
2019-01-08	AMLP	ETF	48.35	49.35	48.15	49.0	5810780.0
2019-01-08	AMUB	ETF	15.6745	15.6745	15.6745	15.6745	0.0
2019-01-08	AMZA	ETF	57.3	59.1	57.3	58.7	107560.0
2019-01-08	ANGL	ETF	27.52	27.74	27.52	27.73	1539600.0
2019-01-08	AOA	ETF	49.78	49.78	49.35	49.65	128400.0
2019-01-08	AOK	ETF	33.06	33.06	32.94	33.0	359587.0
2019-01-08	AOM	ETF	36.04	36.14	35.97	36.07	259654.0
2019-01-08	AOR	ETF	41.97	42.0	41.7918	41.91	262571.0
2019-01-08	ARGT	ETF	25.36	25.58	24.96	25.34	66200.0
2019-01-08	ARKG	ETF	27.7	27.79	26.57	27.1	190700.0
2019-01-08	ARKK	ETF	40.71	40.83	39.308	40.22	461700.0
2019-01-08	ARKQ	ETF	30.88	31.0	30.25	30.71	23100.0
2019-01-08	ARKW	ETF	45.69	45.86	44.323	45.5	114300.0
2019-01-08	ASEA	ETF	15.77	15.84	15.7	15.84	11900.0
2019-01-08	ASET	ETF	26.3083	26.3083	26.3083	26.3083	374.0
2019-01-08	ASHR	ETF	22.41	22.49	22.33	22.44	1434100.0
2019-01-08	ASHS	ETF	23.26	23.26	23.09	23.1	9200.0

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

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