PREVIEW / etf_daily / 2019-01-17

all etf daily files

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

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-17	SPY	ETF	260.01	263.92	259.96	262.96	96118400.0
2019-01-17	QQQ	ETF	161.84	164.36	161.57	163.63	39328959.0
2019-01-17	IWM	ETF	143.99	146.33	143.97	145.83	19273400.0
2019-01-17	DIA	ETF	241.23	244.81	241.04	243.8	4108400.0
2019-01-17	GLD	ETF	122.03	122.26	121.81	122.11	8558500.0
2019-01-17	TLT	ETF	120.22	120.53	119.89	120.19	8153400.0
2019-01-17	AAAU	ETF	12.91	12.92	12.9	12.92	9000.0
2019-01-17	AADR	ETF	42.31	42.83	42.31	42.83	5600.0
2019-01-17	AAXJ	ETF	65.62	66.69	65.62	66.48	1278700.0
2019-01-17	ACES	ETF	24.52	24.79	24.52	24.684	5100.0
2019-01-17	ACSI	ETF	30.5077	30.7471	30.49	30.69	2648.0
2019-01-17	ACTX	ETF	50.7405	53.1005	50.7405	50.7405	251.0
2019-01-17	ACWF	ETF	27.295	27.49	27.27	27.48	917908.0
2019-01-17	ACWI	ETF	66.8	67.7	66.74	67.52	3570900.0
2019-01-17	ACWV	ETF	82.75	83.58	82.75	83.46	177600.0
2019-01-17	ACWX	ETF	43.57	44.1	43.53	43.96	3921994.0
2019-01-17	ADRE	ETF	38.31	39.0489	38.2966	38.83	2124.0
2019-01-17	AFIF	ETF	9.93	9.9696	9.9	9.945	39272.0
2019-01-17	AFK	ETF	20.57	20.66	20.57	20.66	3050.0
2019-01-17	AFTY	ETF	13.86	14.05	13.86	14.024	7800.0
2019-01-17	AGG	ETF	106.53	106.53	106.34	106.43	5547000.0
2019-01-17	AGGY	ETF	48.42	48.44	48.35	48.42	68200.0
2019-01-17	AGNG	ETF	20.21	20.281	20.21	20.281	1000.0
2019-01-17	AGQ	ETF	26.33	26.51	26.2	26.43	77400.0
2019-01-17	AGZ	ETF	112.12	112.12	112.0107	112.08	31600.0
2019-01-17	AGZD	ETF	23.7	23.735	23.645	23.73	35200.0
2019-01-17	AIA	ETF	57.08	58.0	57.08	57.87	84780.0
2019-01-17	AIEQ	ETF	23.56	23.877	23.46	23.82	26100.0
2019-01-17	AIQ	ETF	13.77	14.04	13.76	13.97	50509.0
2019-01-17	AIRR	ETF	23.29	23.69	23.27	23.62	18300.0
2019-01-17	AIVI	ETF	38.88	39.34	38.88	39.33	91200.0
2019-01-17	ALTY	ETF	14.32	14.32	14.249	14.32	8100.0
2019-01-17	AMJ	ETF	24.68	24.81	24.54	24.7	2651013.0
2019-01-17	AMLP	ETF	48.45	48.95	48.3	48.65	4267220.0
2019-01-17	AMUB	ETF	15.5682	15.5682	15.5682	15.5682	0.0
2019-01-17	AMZA	ETF	58.7	59.2	58.2	58.9	63770.0
2019-01-17	ANGL	ETF	27.92	27.99	27.86	27.9	334000.0
2019-01-17	AOA	ETF	50.19	50.7	50.19	50.54	252800.0
2019-01-17	AOK	ETF	33.15	33.2977	33.15	33.25	178052.0
2019-01-17	AOM	ETF	36.3	36.481	36.2431	36.41	398985.0
2019-01-17	AOR	ETF	42.3	42.63	42.3	42.56	217731.0
2019-01-17	ARCM	ETF	99.81	99.885	99.81	99.885	800.0
2019-01-17	ARGT	ETF	26.08	26.28	26.01	26.25	13700.0
2019-01-17	ARKG	ETF	28.26	28.77	28.16	28.55	118100.0
2019-01-17	ARKK	ETF	42.21	43.02	42.07	42.64	301500.0
2019-01-17	ARKQ	ETF	31.43	31.95	31.395	31.72	15100.0
2019-01-17	ARKW	ETF	47.44	48.49	47.156	48.1	69600.0
2019-01-17	ASEA	ETF	16.04	16.11	15.87	16.04	2400.0
2019-01-17	ASET	ETF	26.85	27.002	26.85	27.002	951.0
2019-01-17	ASHR	ETF	23.03	23.45	23.03	23.38	2510800.0

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

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