PREVIEW / etf_daily / 2010-09-10

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-10.parquet
  size:    33 KB
  rows:    774

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-09-10	SPY	ETF	111.12	111.61	110.87	111.48	127819000.0
2010-09-10	QQQ	ETF	46.49	46.67	46.25	46.6	66995684.0
2010-09-10	IWM	ETF	63.76	64.11	63.35	63.72	46973500.0
2010-09-10	DIA	ETF	104.42	104.82	104.15	104.78	3521600.0
2010-09-10	GLD	ETF	121.4	122.3	121.39	121.73	12510000.0
2010-09-10	TLT	ETF	102.25	102.7	101.85	102.32	6910300.0
2010-09-10	AADR	ETF	26.62	26.62	26.52	26.56	1900.0
2010-09-10	AAXJ	ETF	56.87	57.18	56.87	57.11	283300.0
2010-09-10	ACWI	ETF	41.46	41.64	41.43	41.55	112100.0
2010-09-10	ACWX	ETF	39.58	39.69	39.4701	39.61	45021.0
2010-09-10	ADRE	ETF	42.44	42.6388	42.41	42.52	53298.0
2010-09-10	AFK	ETF	30.5	30.5	29.91	30.1	14315.0
2010-09-10	AGG	ETF	107.62	107.72	107.48	107.5	770900.0
2010-09-10	AGQ	ETF	139.24	141.66	138.16	139.2	111550.0
2010-09-10	AGZ	ETF	110.53	110.668	110.53	110.588	8277.0
2010-09-10	AIA	ETF	40.236	40.2699	40.02	40.23	47598.0
2010-09-10	AIQ	ETF	22.2	22.35	21.8	21.95	11263.0
2010-09-10	AIS	ETF	1.51	1.55	1.5	1.54	200520.0
2010-09-10	AIVI	ETF	41.3	41.37	41.19	41.31	10800.0
2010-09-10	AMJ	ETF	32.9	32.95	32.69	32.81	1277292.0
2010-09-10	AMLP	ETF	76.25	76.3	75.8	75.9	102440.0
2010-09-10	AOA	ETF	30.27	30.42	30.27	30.42	6100.0
2010-09-10	AOK	ETF	28.02	28.02	27.9701	28.02	7427.0
2010-09-10	AOM	ETF	28.62	28.65	28.6	28.6299	11721.0
2010-09-10	AOR	ETF	29.242	29.3077	29.24	29.258	2205.0
2010-09-10	ARB	ETF	26.11	26.64	26.06	26.41	107916.0
2010-09-10	BAB	ETF	26.39	26.46	26.3	26.41	183687.0
2010-09-10	BAL	ETF	44.26	44.63	44.26	44.45	2900.0
2010-09-10	BALT	ETF	11.07	11.27	11.0	11.13	72613.0
2010-09-10	BBH	ETF	31.5367	31.7433	31.4833	31.6933	44400.0
2010-09-10	BIB	ETF	6.0187	6.13	6.0187	6.1215	48800.0
2010-09-10	BICK	ETF	29.81	29.81	29.61	29.74	15908.0
2010-09-10	BIL	ETF	91.72	91.72	91.7	91.7	329900.0
2010-09-10	BIS	ETF	10296.64	10296.64	10296.64	10296.64	0.75
2010-09-10	BITS	ETF	24.76	25.0	24.76	24.96	19304.0
2010-09-10	BIV	ETF	84.97	85.06	84.73	84.99	152800.0
2010-09-10	BJK	ETF	26.96	26.96	26.69	26.85	3000.0
2010-09-10	BKF	ETF	45.12	45.35	45.04	45.23	101928.0
2010-09-10	BLV	ETF	83.71	84.12	83.68	83.99	28300.0
2010-09-10	BMVP	ETF	12.6333	12.6333	12.5741	12.61	5126.0
2010-09-10	BND	ETF	81.83	81.88	81.72	81.8	417400.0
2010-09-10	BNE	ETF	11.05	11.09	10.99	11.06	689066.0
2010-09-10	BOSS	ETF	30.565	31.25	30.565	31.25	100.0
2010-09-10	BRF	ETF	54.35	54.5654	54.17	54.45	621746.0
2010-09-10	BSCE	ETF	20.72	20.76	20.72	20.76	10550.0
2010-09-10	BSV	ETF	81.23	81.29	81.2	81.27	487800.0
2010-09-10	BTF	ETF	73.49999999999999	73.55	73.2	73.55	4398.400000000001
2010-09-10	BWX	ETF	28.57	28.675	28.245	28.245	190338.0
2010-09-10	BWZ	ETF	35.45	35.45	35.27	35.375	9182.0
2010-09-10	BZQ	ETF	3216.0	3244.8	3212.8	3240.0	132.5

> showing 50 of 774 rows — these rows as CSV

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