PREVIEW / etf_daily / 2018-10-09

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-09.parquet
  size:    62 KB
  rows:    1,610

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-09	SPY	ETF	287.39	288.86	286.77	287.4	74339000.0
2018-10-09	QQQ	ETF	179.2	181.02	178.75	179.63	49097949.0
2018-10-09	IWM	ETF	161.62	162.74	160.98	161.19	20620400.0
2018-10-09	DIA	ETF	264.38	265.32	263.14	264.23	4559100.0
2018-10-09	GLD	ETF	112.37	112.67	111.97	112.6	8352300.0
2018-10-09	TLT	ETF	113.14	113.85	113.07	113.8	11530800.0
2018-10-09	AAAU	ETF	11.86	11.89	11.86	11.87	202900.0
2018-10-09	AADR	ETF	50.01	50.55	50.0	50.24	29600.0
2018-10-09	AAXJ	ETF	65.67	66.1	65.48	65.74	1689400.0
2018-10-09	ACES	ETF	24.63	24.63	24.63	24.63	100.0
2018-10-09	ACSI	ETF	33.6	33.6055	33.59	33.6055	2556.0
2018-10-09	ACTX	ETF	155.4664	166.3815	107.381	110.921	14249.0
2018-10-09	ACWF	ETF	29.82	29.9193	29.7934	29.8736	2477.0
2018-10-09	ACWI	ETF	72.43	72.9	72.3	72.69	1526800.0
2018-10-09	ACWV	ETF	86.39	86.77	86.3	86.56	78500.0
2018-10-09	ACWX	ETF	45.87	46.21	45.73	46.1	596935.0
2018-10-09	ADRE	ETF	39.12	39.44	39.12	39.2	2676.0
2018-10-09	AFIF	ETF	10.0634	10.07	10.02	10.0332	12010.0
2018-10-09	AFK	ETF	20.52	20.86	20.52	20.75	8639.0
2018-10-09	AFTY	ETF	14.53	14.6	14.483	14.57	7400.0
2018-10-09	AGG	ETF	104.39	104.51	104.32	104.44	21903200.0
2018-10-09	AGGY	ETF	47.69	47.769	47.69	47.75	30800.0
2018-10-09	AGNG	ETF	21.33	21.56	21.33	21.467	2100.0
2018-10-09	AGQ	ETF	23.09	23.35	22.87	23.29	67000.0
2018-10-09	AGZ	ETF	110.135	110.135	109.8101	109.9346	6048.0
2018-10-09	AGZD	ETF	23.975	23.99	23.91	23.91	13000.0
2018-10-09	AIA	ETF	58.55	58.7688	58.2	58.56	40812.0
2018-10-09	AIEQ	ETF	28.71	28.77	28.617	28.71	39900.0
2018-10-09	AIQ	ETF	15.05	15.1094	14.95	14.9949	7932.0
2018-10-09	AIRR	ETF	27.27	27.36	27.2	27.2	19900.0
2018-10-09	AIVI	ETF	40.91	41.18	40.91	41.15	4100.0
2018-10-09	ALTY	ETF	14.65	14.87	14.65	14.861	10000.0
2018-10-09	AMJ	ETF	27.88	28.225	27.78	28.14	1654351.0
2018-10-09	AMLP	ETF	53.9	54.65	53.8	54.65	2429080.0
2018-10-09	AMZA	ETF	75.5	76.1	75.35	75.7	37750.0
2018-10-09	ANGL	ETF	28.53	28.71	28.53	28.71	218200.0
2018-10-09	AOA	ETF	53.33	53.56	53.23	53.45	75900.0
2018-10-09	AOK	ETF	33.64	33.7278	33.6101	33.65	50967.0
2018-10-09	AOM	ETF	37.13	37.19	37.09	37.17	149736.0
2018-10-09	AOR	ETF	44.1	44.26	44.01	44.15	106318.0
2018-10-09	ARCM	ETF	100.21	100.21	100.21	100.21	200.0
2018-10-09	ARGT	ETF	26.19	26.39	26.01	26.24	43300.0
2018-10-09	ARKG	ETF	29.76	30.3	29.73	29.94	159400.0
2018-10-09	ARKK	ETF	43.1	43.82	43.04	43.36	640800.0
2018-10-09	ARKQ	ETF	33.87	33.97	33.607	33.7	73100.0
2018-10-09	ARKW	ETF	53.62	54.31	53.34	53.83	126500.0
2018-10-09	ARVR	ETF	20.41	20.41	20.41	20.41	100.0
2018-10-09	ASEA	ETF	15.56	15.59	15.56	15.56	2000.0
2018-10-09	ASET	ETF	27.5499	27.6152	27.52	27.5988	1694.0
2018-10-09	ASHR	ETF	24.0	24.12	23.88	23.98	1692000.0

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

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