PREVIEW / etf_daily / 2010-04-06

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-06.parquet
  size:    32 KB
  rows:    738

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
2010-04-06	SPY	ETF	118.42	119.25	118.29	119.04	110384200.0
2010-04-06	QQQ	ETF	48.49	48.9	48.39	48.75	54097057.0
2010-04-06	IWM	ETF	69.47	70.29	69.33	70.12	50203600.0
2010-04-06	DIA	ETF	109.45	109.87	109.28	109.72	4407600.0
2010-04-06	GLD	ETF	110.89	111.51	110.83	111.03	10322300.0
2010-04-06	TLT	ETF	87.8	87.85	87.35	87.61	3584600.0
2010-04-06	AAXJ	ETF	58.7	59.06	58.48	58.9	196000.0
2010-04-06	ACWI	ETF	44.11	44.53	44.01	44.52	612600.0
2010-04-06	ACWX	ETF	42.37	42.65	42.22	42.65	37797.0
2010-04-06	ADRE	ETF	45.27	45.65	45.1901	45.48	75977.0
2010-04-06	AFK	ETF	31.95	32.72	31.95	32.59	46031.0
2010-04-06	AGG	ETF	103.28	103.47	103.28	103.33	934800.0
2010-04-06	AGQ	ETF	123.08	123.78	121.42	122.1	173900.0
2010-04-06	AGZ	ETF	107.625	107.65	107.51	107.63	11806.0
2010-04-06	AIA	ETF	41.58	41.94	41.58	41.84	7314.0
2010-04-06	AIQ	ETF	27.7	28.25	27.7	28.25	24596.0
2010-04-06	AIS	ETF	1.6	1.74	1.6	1.64	2250092.0
2010-04-06	AIVI	ETF	42.92	43.45	42.92	43.45	14500.0
2010-04-06	AMJ	ETF	31.18	31.23	31.05	31.2	241579.0
2010-04-06	AOA	ETF	31.96	32.19	31.95	32.16	13800.0
2010-04-06	AOK	ETF	27.84	27.94	27.84	27.9078	10269.0
2010-04-06	AOM	ETF	28.84	28.93	28.84	28.87	11792.0
2010-04-06	AOR	ETF	29.96	30.1	29.96	30.08	10102.0
2010-04-06	ARB	ETF	27.87	28.07	27.5	27.57	251875.0
2010-04-06	BAB	ETF	24.79	24.79	24.59	24.68	274992.0
2010-04-06	BAL	ETF	39.7	40.0155	39.55	39.59	5301.0
2010-04-06	BALT	ETF	14.0	14.04	13.83	13.9	327373.0
2010-04-06	BBH	ETF	34.5133	34.7067	34.5067	34.5733	81000.0
2010-04-06	BIL	ETF	91.7	91.7	91.68	91.68	276000.0
2010-04-06	BITS	ETF	32.04	32.04	31.8	31.84	863.0
2010-04-06	BIV	ETF	79.43	79.58	79.32	79.5	113100.0
2010-04-06	BJK	ETF	26.62	26.88	26.43	26.81	25300.0
2010-04-06	BKF	ETF	47.99	48.35	47.85	48.16	311572.0
2010-04-06	BLV	ETF	75.9	75.9	75.53	75.64	28500.0
2010-04-06	BMVP	ETF	13.3733	13.4467	13.3667	13.4267	10232.0
2010-04-06	BND	ETF	78.53	78.59	78.5	78.53	487900.0
2010-04-06	BNE	ETF	11.11	11.18	11.09	11.13	760115.0
2010-04-06	BRF	ETF	46.02	46.39	45.93	46.16	389221.0
2010-04-06	BSV	ETF	79.51	79.55	79.45	79.5	729600.0
2010-04-06	BTF	ETF	74.14999999999999	75.1	74.1	74.69999999999999	2787.2000000000003
2010-04-06	BWX	ETF	27.785	27.885	27.705	27.795	241186.0
2010-04-06	BWZ	ETF	35.45	35.53	35.4	35.4894	19744.0
2010-04-06	BZQ	ETF	3443.2	3446.4	3360.0	3398.4	567.5
2010-04-06	CEF	ETF	14.32	14.44	14.32	14.34	687500.0
2010-04-06	CEW	ETF	22.32	22.4	22.3104	22.39	257913.0
2010-04-06	CGO	ETF	15.12	15.14	14.96	15.14	27875.0
2010-04-06	CGW	ETF	18.72	18.8799	18.675	18.86	48025.0
2010-04-06	CHI	ETF	12.82	12.88	12.8	12.83	207945.0
2010-04-06	CHIE	ETF	15.03	15.15	15.03	15.09	9110.0
2010-04-06	CHII	ETF	15.8	15.98	15.8	15.959	7273.0

> showing 50 of 738 rows — these rows as CSV

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