PREVIEW / etf_daily / 2019-03-11

all etf daily files

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

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-11	SPY	ETF	275.26	278.62	275.23	278.44	65098900.0
2019-03-11	QQQ	ETF	171.86	174.85	171.85	174.73	30518408.0
2019-03-11	IWM	ETF	152.11	154.31	151.9	154.29	20854500.0
2019-03-11	DIA	ETF	252.85	256.83	252.46	256.76	5469400.0
2019-03-11	GLD	ETF	122.52	122.54	121.92	122.24	6708700.0
2019-03-11	TLT	ETF	121.4	121.42	120.98	121.21	5157800.0
2019-03-11	AAAU	ETF	12.96	12.96	12.89	12.93	16600.0
2019-03-11	AADR	ETF	44.86	45.0	44.67	45.0	6500.0
2019-03-11	AAXJ	ETF	68.73	69.43	68.7	69.4	666600.0
2019-03-11	ACES	ETF	26.49	26.97	26.49	26.97	10600.0
2019-03-11	ACSI	ETF	31.8978	32.23	31.8978	32.23	1937.0
2019-03-11	ACTX	ETF	56.0505	56.0505	50.1505	51.9205	762.0
2019-03-11	ACWF	ETF	28.47	28.81	28.47	28.81	59947.0
2019-03-11	ACWI	ETF	70.16	70.91	70.16	70.87	1635700.0
2019-03-11	ACWV	ETF	87.06	87.67	87.02	87.67	220100.0
2019-03-11	ACWX	ETF	45.35	45.73	45.35	45.73	704557.0
2019-03-11	ADRE	ETF	39.94	40.66	39.94	40.66	6609.0
2019-03-11	AFIF	ETF	10.0101	10.05	10.0	10.02	20420.0
2019-03-11	AFK	ETF	21.74	21.91	21.65	21.71	10333.0
2019-03-11	AFTY	ETF	15.88	16.16	15.88	16.158	23500.0
2019-03-11	AGG	ETF	107.44	107.47	107.35	107.44	5638300.0
2019-03-11	AGGY	ETF	49.09	49.09	49.03	49.09	374500.0
2019-03-11	AGNG	ETF	21.11	21.257	21.008	21.23	5300.0
2019-03-11	AGQ	ETF	25.22	25.27	24.93	25.24	84400.0
2019-03-11	AGZ	ETF	112.29	112.36	112.25	112.32	11650.0
2019-03-11	AGZD	ETF	23.82	23.83	23.815	23.815	6000.0
2019-03-11	AIA	ETF	59.88	60.42	59.88	60.4	66659.0
2019-03-11	AIEQ	ETF	25.19	25.63	25.19	25.58	31100.0
2019-03-11	AIQ	ETF	15.04	15.3799	15.04	15.3799	7736.0
2019-03-11	AIRR	ETF	24.65	25.03	24.65	25.02	32300.0
2019-03-11	AIVI	ETF	40.64	40.87	40.6	40.87	4400.0
2019-03-11	ALTY	ETF	14.79	14.79	14.62	14.67	8600.0
2019-03-11	AMJ	ETF	24.92	25.3	24.755	25.15	961298.0
2019-03-11	AMLP	ETF	49.05	49.85	48.95	49.5	3995540.0
2019-03-11	AMUB	ETF	15.9	15.9	15.8324	15.8324	400.0
2019-03-11	AMZA	ETF	58.7	59.7	58.45	59.6	109780.0
2019-03-11	ANGL	ETF	28.34	28.42	28.34	28.37	576300.0
2019-03-11	AOA	ETF	52.28	52.71	52.28	52.7	101200.0
2019-03-11	AOK	ETF	33.9	34.05	33.9	34.05	34770.0
2019-03-11	AOM	ETF	37.36	37.52	37.3568	37.48	81848.0
2019-03-11	AOR	ETF	43.81	44.0679	43.7965	44.03	75828.0
2019-03-11	ARGT	ETF	27.18	27.96	27.18	27.96	28500.0
2019-03-11	ARKF	ETF	20.89	21.12	20.887	21.09	9900.0
2019-03-11	ARKG	ETF	30.74	31.78	30.726	31.78	177100.0
2019-03-11	ARKK	ETF	45.14	46.42	45.0	46.42	461600.0
2019-03-11	ARKQ	ETF	33.05	33.872	33.05	33.82	18300.0
2019-03-11	ARKW	ETF	49.96	51.34	49.96	51.33	396100.0
2019-03-11	ASEA	ETF	15.62	15.85	15.62	15.85	61800.0
2019-03-11	ASET	ETF	28.36	28.49	28.36	28.49	4204.0
2019-03-11	ASHR	ETF	27.59	28.14	27.59	28.09	10956200.0

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

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