PREVIEW / etf_daily / 2019-03-08

all etf daily files

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

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-03-08	SPY	ETF	272.94	274.65	272.42	274.46	85795800.0
2019-03-08	QQQ	ETF	169.51	171.26	169.3375	171.17	39303225.0
2019-03-08	IWM	ETF	150.84	151.76	150.61	151.64	20466800.0
2019-03-08	DIA	ETF	252.88	254.9	252.74	254.71	5495800.0
2019-03-08	GLD	ETF	122.7	122.89	122.37	122.84	10427700.0
2019-03-08	TLT	ETF	121.12	121.69	120.85	121.57	7517600.0
2019-03-08	AAAU	ETF	12.98	13.0	12.96	13.0	26400.0
2019-03-08	AADR	ETF	44.16	44.5	44.09	44.5	10300.0
2019-03-08	AAXJ	ETF	67.82	68.21	67.71	68.13	2818500.0
2019-03-08	ACES	ETF	26.16	26.448	26.16	26.448	3500.0
2019-03-08	ACSI	ETF	31.64	31.8153	31.64	31.8153	2784.0
2019-03-08	ACTX	ETF	56.0505	56.0505	52.5105	56.0505	438.0
2019-03-08	ACWF	ETF	28.33	28.45	28.29	28.39	18008.0
2019-03-08	ACWI	ETF	69.57	69.98	69.5	69.94	3024800.0
2019-03-08	ACWV	ETF	86.51	86.84	86.4	86.81	1126300.0
2019-03-08	ACWX	ETF	44.98	45.19	44.9	45.19	1475449.0
2019-03-08	ADRE	ETF	39.33	39.69	39.27	39.69	3341.0
2019-03-08	AFIF	ETF	10.0237	10.05	10.01	10.01	10387.0
2019-03-08	AFK	ETF	21.4	22.28	21.4	21.54	4301.0
2019-03-08	AFTY	ETF	15.64	15.75	15.54	15.65	23700.0
2019-03-08	AGG	ETF	107.31	107.47	107.24	107.43	4943100.0
2019-03-08	AGGY	ETF	49.03	49.09	48.96	49.08	73000.0
2019-03-08	AGNG	ETF	21.0	21.0	20.75	20.75	1000.0
2019-03-08	AGQ	ETF	25.15	25.44	25.04	25.4	167000.0
2019-03-08	AGZ	ETF	112.32	112.39	112.25	112.39	13762.0
2019-03-08	AGZD	ETF	23.835	23.875	23.8	23.8	5400.0
2019-03-08	AIA	ETF	59.07	59.37	59.07	59.34	62671.0
2019-03-08	AIEQ	ETF	25.08	25.21	24.93	25.19	66900.0
2019-03-08	AIQ	ETF	14.91	14.98	14.87	14.93	19484.0
2019-03-08	AIRR	ETF	24.65	24.651	24.55	24.64	12800.0
2019-03-08	AIVI	ETF	40.27	40.52	40.27	40.5	13400.0
2019-03-08	ALTY	ETF	14.5	14.57	14.5	14.55	15200.0
2019-03-08	AMJ	ETF	24.61	24.86	24.485	24.78	1823639.0
2019-03-08	AMLP	ETF	48.55	48.95	48.15	48.8	3212040.0
2019-03-08	AMUB	ETF	15.612	15.612	15.612	15.612	0.0
2019-03-08	AMZA	ETF	58.2	58.5	57.2	58.5	115330.0
2019-03-08	ANGL	ETF	28.29	28.37	28.21	28.33	781900.0
2019-03-08	AOA	ETF	52.01	52.19	51.91	52.19	76700.0
2019-03-08	AOK	ETF	33.78	33.86	33.76	33.86	88174.0
2019-03-08	AOM	ETF	37.19	37.3	37.18	37.28	106970.0
2019-03-08	AOR	ETF	43.6	43.73	43.5312	43.73	158785.0
2019-03-08	ARGT	ETF	26.39	26.99	26.38	26.87	193800.0
2019-03-08	ARKF	ETF	20.32	20.537	20.16	20.537	26100.0
2019-03-08	ARKG	ETF	29.9	30.64	29.67	30.58	131400.0
2019-03-08	ARKK	ETF	43.82	44.915	43.38	44.86	304900.0
2019-03-08	ARKQ	ETF	32.49	32.99	32.22	32.99	17400.0
2019-03-08	ARKW	ETF	48.96	49.725	48.63	49.7	130400.0
2019-03-08	ASEA	ETF	15.63	15.64	15.52	15.62	3800.0
2019-03-08	ASET	ETF	28.11	28.12	28.1	28.12	1155.0
2019-03-08	ASHR	ETF	26.92	27.01	26.69	26.9	13501800.0

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

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