PREVIEW / etf_daily / 2009-04-16

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-16.parquet
  size:    28 KB
  rows:    645

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
2009-04-16	SPY	ETF	85.93	87.15	84.77	86.5	335202900.0
2009-04-16	QQQ	ETF	32.83	33.43	32.51	33.24	171167985.0
2009-04-16	IWM	ETF	46.53	47.69	45.76	47.33	66307000.0
2009-04-16	DIA	ETF	80.86	81.79	79.71	81.26	19526700.0
2009-04-16	GLD	ETF	87.38	87.45	85.68	85.81	21033600.0
2009-04-16	TLT	ETF	102.85	103.45	102.78	102.83	1055600.0
2009-04-16	AAXJ	ETF	37.91	38.15	37.17	37.78	212300.0
2009-04-16	ACWI	ETF	31.19	31.47	30.83	31.4	58000.0
2009-04-16	ACWX	ETF	29.39	29.56	29.04	29.42	133026.0
2009-04-16	ADRE	ETF	30.78	30.87	30.27	30.67	151592.0
2009-04-16	AFK	ETF	20.62	21.06	20.6	21.06	1150.0
2009-04-16	AGG	ETF	101.26	101.32	101.02	101.23	457700.0
2009-04-16	AGQ	ETF	73.38	73.48	68.0	68.84	169450.0
2009-04-16	AGZ	ETF	107.46	108.28	107.46	108.01	9366.0
2009-04-16	AIA	ETF	29.55	29.55	28.13	28.71	36961.0
2009-04-16	AIQ	ETF	38.9	41.2	38.75	41.15	42327.0
2009-04-16	AIS	ETF	0.47	0.47	0.44	0.46	59340.0
2009-04-16	AIVI	ETF	31.28	31.73	31.23	31.58	32500.0
2009-04-16	AMJ	ETF	20.05	20.3	20.05	20.28	21182.0
2009-04-16	AOA	ETF	23.26	23.66	23.17	23.57	4300.0
2009-04-16	AOM	ETF	24.65	24.88	24.5	24.83	17506.0
2009-04-16	AOR	ETF	24.07	24.3452	23.65	24.26	30106.0
2009-04-16	ARB	ETF	18.18	19.04	18.11	18.93	421443.0
2009-04-16	BAL	ETF	27.65	28.0	27.65	28.0	452.0
2009-04-16	BBH	ETF	29.6567	29.6967	28.9367	29.4167	772500.0
2009-04-16	BIL	ETF	91.72	91.76	91.68	91.76	176000.0
2009-04-16	BITS	ETF	17.76	17.8	17.32	17.8	1348.0
2009-04-16	BIV	ETF	76.75	76.89	76.57	76.81	50300.0
2009-04-16	BJK	ETF	19.16	19.46	17.99	18.35	6900.0
2009-04-16	BKF	ETF	29.1	30.32	28.87	29.33	136787.0
2009-04-16	BLV	ETF	73.18	73.67	73.01	73.53	14600.0
2009-04-16	BMVP	ETF	10.403	10.606	10.343	10.547	15176.0
2009-04-16	BND	ETF	77.09	77.3	77.09	77.25	436800.0
2009-04-16	BNE	ETF	4.45	5.11	4.4	4.81	290586.0
2009-04-16	BOSS	ETF	12.66	13.35	12.66	13.35	100.0
2009-04-16	BSV	ETF	78.75	78.85	78.63	78.75	141400.0
2009-04-16	BTF	ETF	46.25	46.94899999999999	46.199999999999996	46.8	5243.400000000001
2009-04-16	BWX	ETF	25.7	25.72	25.555	25.635	145586.0
2009-04-16	BWZ	ETF	33.05	33.05	32.946	33.02	6297.0
2009-04-16	CBON	ETF	2.31	2.46	2.3	2.37	13460.0
2009-04-16	CEF	ETF	10.94	10.95	10.58	10.64	1394900.0
2009-04-16	CGO	ETF	9.54	9.65	9.41	9.61	23814.0
2009-04-16	CGW	ETF	13.41	13.41	13.0	13.37	40782.0
2009-04-16	CHB	ETF	0.6116	0.6116	0.58	0.61	498486.0
2009-04-16	CHI	ETF	9.46	9.5	9.24	9.42	236591.0
2009-04-16	CHIC	ETF	12.09	12.59	11.6	11.93	2313607.0
2009-04-16	CHW	ETF	6.05	6.09	5.86	5.91	194397.0
2009-04-16	CHY	ETF	9.01	9.01	8.79	8.98	238770.0
2009-04-16	CMF	ETF	51.99	51.99	51.73	51.775	21934.0
2009-04-16	CNXT	ETF	0.72	0.74	0.72	0.74	214312.0

> showing 50 of 645 rows — these rows as CSV

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