PREVIEW / etf_daily / 2010-01-27

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-27.parquet
  size:    31 KB
  rows:    717

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-01-27	SPY	ETF	109.17	110.08	108.33	109.83	271863600.0
2010-01-27	QQQ	ETF	44.29	44.85	44.01	44.7	161632631.0
2010-01-27	IWM	ETF	60.92	61.94	60.71	61.84	72565800.0
2010-01-27	DIA	ETF	101.67	102.51	100.99	102.3	16203100.0
2010-01-27	GLD	ETF	107.53	108.8	106.16	106.53	19005100.0
2010-01-27	TLT	ETF	91.75	92.09	91.37	91.56	3325700.0
2010-01-27	AAXJ	ETF	52.51	52.84	51.87	52.84	532900.0
2010-01-27	ACWI	ETF	40.98	41.33	40.8	41.28	241000.0
2010-01-27	ACWX	ETF	39.63	39.7	39.05	39.64	103686.0
2010-01-27	ADRE	ETF	40.29	40.48	39.66	40.48	559970.0
2010-01-27	AFK	ETF	28.33	28.48	28.1	28.47	5017.0
2010-01-27	AGG	ETF	104.47	104.71	104.43	104.5	618300.0
2010-01-27	AGQ	ETF	108.74	109.38	105.5	107.4	236900.0
2010-01-27	AGZ	ETF	108.6628	108.7073	108.27	108.39	19563.0
2010-01-27	AIA	ETF	37.72	37.9	37.42	37.9	24800.0
2010-01-27	AIQ	ETF	24.5	24.6475	23.8175	24.55	40937.0
2010-01-27	AIS	ETF	1.2	1.2	1.133	1.14	48298.0
2010-01-27	AIVI	ETF	42.06	42.13	41.64	42.12	18700.0
2010-01-27	AMJ	ETF	29.87	29.87	28.98	29.15	282943.0
2010-01-27	AOA	ETF	29.48	29.5	29.31	29.48	12400.0
2010-01-27	AOK	ETF	27.31	27.37	27.17	27.34	7879.0
2010-01-27	AOM	ETF	28.02	28.08	27.92	28.08	11290.0
2010-01-27	AOR	ETF	28.67	28.75	28.5	28.75	13444.0
2010-01-27	ARB	ETF	25.7	26.07	25.18	25.87	275730.0
2010-01-27	BAB	ETF	24.9	24.95	24.85	24.9	102559.0
2010-01-27	BAL	ETF	33.8401	33.9	33.77	33.798	15040.0
2010-01-27	BBH	ETF	33.1767	34.0	33.1767	33.9267	275400.0
2010-01-27	BIL	ETF	91.68	91.74	91.68	91.74	406850.0
2010-01-27	BITS	ETF	31.72	32.36	31.72	32.3596	1713.0
2010-01-27	BIV	ETF	80.69	80.72	80.29	80.39	109200.0
2010-01-27	BJK	ETF	24.4	24.4	23.8	24.1	16100.0
2010-01-27	BKF	ETF	42.1	42.21	41.23	41.84	332118.0
2010-01-27	BLV	ETF	77.58	77.69	76.54	77.35	30600.0
2010-01-27	BMVP	ETF	12.44	12.51	12.32	12.5	56452.0
2010-01-27	BND	ETF	79.63	79.66	79.43	79.47	597800.0
2010-01-27	BNE	ETF	6.4	6.55	6.21	6.55	144878.0
2010-01-27	BRF	ETF	43.16	43.49	42.49	43.06	934414.0
2010-01-27	BSV	ETF	80.31	80.33	80.14	80.19	353900.0
2010-01-27	BTF	ETF	66.75	67.19999999999999	65.3	66.14999999999999	19965.0
2010-01-27	BWX	ETF	28.485	28.52	28.25	28.33	281080.0
2010-01-27	BWZ	ETF	36.41	36.41	36.1	36.15	31473.0
2010-01-27	BZQ	ETF	4630.4	4755.2	4550.4	4585.6	956.0
2010-01-27	CEF	ETF	13.51	13.55	13.18	13.18	1463900.0
2010-01-27	CEW	ETF	21.77	21.77	21.68	21.738	71524.0
2010-01-27	CGO	ETF	14.29	14.3364	14.17	14.33	20101.0
2010-01-27	CGW	ETF	17.92	18.05	17.8	18.0	149693.0
2010-01-27	CHI	ETF	12.44	12.5	12.37	12.5	120317.0
2010-01-27	CHIE	ETF	13.62	13.62	13.3901	13.59	35073.0
2010-01-27	CHII	ETF	14.32	14.378	14.17	14.378	23199.0
2010-01-27	CHIM	ETF	24.36	24.3602	24.36	24.3602	100.0

> showing 50 of 717 rows — these rows as CSV

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