PREVIEW / etf_daily / 2019-01-04

all etf daily files

  file:    by_date/etf_daily/2019/2019-01-04.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-04	SPY	ETF	247.59	253.11	247.17	252.39	142628800.0
2019-01-04	QQQ	ETF	152.18	157.0	151.74	156.23	74709320.0
2019-01-04	IWM	ETF	133.92	137.6	133.71	137.19	35355300.0
2019-01-04	DIA	ETF	230.0	235.18	229.73	234.28	7343700.0
2019-01-04	GLD	ETF	121.32	121.6	120.69	121.44	13334000.0
2019-01-04	TLT	ETF	122.34	122.56	121.65	122.11	12970200.0
2019-01-04	AAAU	ETF	12.83	12.85	12.76	12.84	12100.0
2019-01-04	AADR	ETF	40.35	41.43	40.04	41.43	28400.0
2019-01-04	AAXJ	ETF	62.64	63.89	62.64	63.63	1658100.0
2019-01-04	ACES	ETF	23.05	23.29	23.05	23.218	25200.0
2019-01-04	ACSI	ETF	29.02	29.4475	29.02	29.4475	3456.0
2019-01-04	ACTX	ETF	53.1005	53.1005	50.1505	51.9205	327.0
2019-01-04	ACWF	ETF	25.9704	26.3222	25.93	26.2785	342593.0
2019-01-04	ACWI	ETF	63.92	65.23	63.85	65.06	6289000.0
2019-01-04	ACWV	ETF	80.93	81.92	80.79	81.74	497100.0
2019-01-04	ACWX	ETF	42.05	42.78	41.99	42.7	2971173.0
2019-01-04	ADRE	ETF	36.13	37.09	36.13	37.08	7066.0
2019-01-04	AFIF	ETF	9.9	9.94	9.89	9.9119	9649.0
2019-01-04	AFK	ETF	19.945	20.2	19.905	20.2	10386.0
2019-01-04	AFTY	ETF	13.54	13.54	13.3	13.48	12100.0
2019-01-04	AGG	ETF	106.66	106.72	106.55	106.69	8149000.0
2019-01-04	AGGY	ETF	48.38	48.63	48.31	48.35	307100.0
2019-01-04	AGNG	ETF	18.97	19.41	18.97	19.39	1300.0
2019-01-04	AGQ	ETF	27.16	27.32	26.78	27.1	119300.0
2019-01-04	AGZ	ETF	112.47	112.47	112.2601	112.38	32963.0
2019-01-04	AGZD	ETF	23.655	23.775	23.54	23.745	123600.0
2019-01-04	AIA	ETF	54.31	55.2814	54.24	55.11	104559.0
2019-01-04	AIEQ	ETF	21.62	22.42	21.62	22.3	78500.0
2019-01-04	AIQ	ETF	12.82	13.24	12.8	13.18	10778.0
2019-01-04	AIRR	ETF	22.06	22.378	22.06	22.33	10100.0
2019-01-04	AIVI	ETF	38.07	38.65	38.06	38.57	9100.0
2019-01-04	ALTY	ETF	13.57	13.63	13.57	13.612	6300.0
2019-01-04	AMJ	ETF	23.14	24.07	23.06	23.86	5080277.0
2019-01-04	AMLP	ETF	45.35	47.35	45.3	47.2	5144980.0
2019-01-04	AMUB	ETF	14.9994	14.9994	14.9994	14.9994	0.0
2019-01-04	AMZA	ETF	53.4	56.07	53.23	55.7	131160.0
2019-01-04	ANGL	ETF	26.86	27.31	26.86	27.18	1294400.0
2019-01-04	AOA	ETF	48.49	49.19	48.43	49.14	363500.0
2019-01-04	AOK	ETF	32.77	32.95	32.7376	32.92	116677.0
2019-01-04	AOM	ETF	35.75	35.95	35.65	35.94	512339.0
2019-01-04	AOR	ETF	41.25	41.6919	41.14	41.67	311830.0
2019-01-04	ARCM	ETF	99.75	99.75	99.725	99.725	2000.0
2019-01-04	ARGT	ETF	23.95	24.7	23.95	24.59	32600.0
2019-01-04	ARKG	ETF	24.6	25.84	24.6	25.73	146600.0
2019-01-04	ARKK	ETF	36.9	38.56	36.86	38.43	317400.0
2019-01-04	ARKQ	ETF	28.866	29.788	28.866	29.73	8800.0
2019-01-04	ARKW	ETF	41.74	43.8	41.74	43.46	110500.0
2019-01-04	ASEA	ETF	15.48	15.8	15.48	15.67	22500.0
2019-01-04	ASET	ETF	25.77	25.77	25.77	25.77	407.0
2019-01-04	ASHR	ETF	22.18	22.52	22.18	22.5	3778500.0

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

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