PREVIEW / etf_daily / 2009-04-20

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-20.parquet
  size:    28 KB
  rows:    642

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-20	SPY	ETF	85.54	87.05	83.34	83.43	293690100.0
2009-04-20	QQQ	ETF	32.7	32.82	32.06	32.24	123080472.0
2009-04-20	IWM	ETF	46.77	47.0	45.2	45.3	53370100.0
2009-04-20	DIA	ETF	80.05	80.16	78.35	78.52	16640200.0
2009-04-20	GLD	ETF	86.03	87.34	86.0	86.95	12674400.0
2009-04-20	TLT	ETF	102.63	103.4	102.45	103.24	1714400.0
2009-04-20	AAXJ	ETF	37.21	37.21	36.13	36.32	71200.0
2009-04-20	ACWI	ETF	30.61	30.69	30.02	30.04	93400.0
2009-04-20	ACWX	ETF	28.82	28.82	28.2	28.24	71356.0
2009-04-20	ADRE	ETF	29.98	29.98	29.1	29.13	169635.0
2009-04-20	AFK	ETF	20.98	20.98	20.2164	20.2164	4671.0
2009-04-20	AGG	ETF	101.11	101.25	100.78	101.25	705600.0
2009-04-20	AGQ	ETF	66.78	68.22	66.6	66.8	62750.0
2009-04-20	AGZ	ETF	108.0	108.28	107.61	108.24	34622.0
2009-04-20	AIA	ETF	28.66	28.66	27.31	27.4482	21639.0
2009-04-20	AIQ	ETF	42.9	43.95	40.7	41.7	35699.0
2009-04-20	AIS	ETF	0.45	0.4501	0.42	0.42	37123.0
2009-04-20	AIVI	ETF	30.58	30.58	29.85	29.85	12000.0
2009-04-20	AMJ	ETF	20.15	20.18	20.07	20.1	3600.0
2009-04-20	AOA	ETF	24.0	24.0	22.77	22.77	7500.0
2009-04-20	AOK	ETF	24.82	25.154	24.82	25.08	931.0
2009-04-20	AOM	ETF	24.85	24.9	24.39	24.39	7260.0
2009-04-20	AOR	ETF	24.59	24.59	23.36	23.67	37707.0
2009-04-20	ARB	ETF	19.38	19.99	19.0	19.31	678402.0
2009-04-20	BAL	ETF	27.93	27.93	27.432	27.432	7250.0
2009-04-20	BBH	ETF	28.9533	29.06	28.1833	28.4433	778800.0
2009-04-20	BIL	ETF	91.7	91.72	91.66	91.7	115500.0
2009-04-20	BITS	ETF	17.68	17.76	17.68	17.76	175.0
2009-04-20	BIV	ETF	76.51	76.87	76.3	76.81	69500.0
2009-04-20	BJK	ETF	18.23	18.23	17.34	17.43	7500.0
2009-04-20	BKF	ETF	29.78	29.78	27.7	27.7799	82155.0
2009-04-20	BLV	ETF	72.87	73.92	72.8	73.08	23900.0
2009-04-20	BMVP	ETF	10.51	10.51	10.21	10.21	41438.0
2009-04-20	BND	ETF	76.96	77.3	76.96	77.22	247700.0
2009-04-20	BNE	ETF	4.75	4.84	4.52	4.63	175943.0
2009-04-20	BSV	ETF	78.54	78.86	78.54	78.86	139600.0
2009-04-20	BTF	ETF	45.99999999999999	45.99999999999999	44.24999999999999	45.0	6115.400000000001
2009-04-20	BWX	ETF	25.57	25.57	25.2802	25.3	456300.0
2009-04-20	BWZ	ETF	32.74	32.74	32.615	32.63	5838.0
2009-04-20	CBON	ETF	2.49	2.49	2.3	2.49	19883.0
2009-04-20	CEF	ETF	10.6	10.94	10.6	10.9	1339900.0
2009-04-20	CGO	ETF	9.51	9.55	9.3289	9.372	23946.0
2009-04-20	CGW	ETF	13.44	13.44	12.75	12.81	27678.0
2009-04-20	CHB	ETF	0.63	0.63	0.53	0.6	770185.0
2009-04-20	CHI	ETF	9.35	9.35	9.01	9.09	93141.0
2009-04-20	CHIC	ETF	11.8	11.84	11.15	11.38	598588.0
2009-04-20	CHW	ETF	5.96	6.08	5.8	5.8	241844.0
2009-04-20	CHY	ETF	9.01	9.07	8.81	8.99	247950.0
2009-04-20	CMF	ETF	52.145	52.145	52.117	52.131	3006.0
2009-04-20	CNXT	ETF	1.27	1.74	1.2	1.53	2729092.0

> showing 50 of 642 rows — these rows as CSV

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