PREVIEW / etf_daily / 2010-01-25

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-25.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-25	SPY	ETF	110.21	110.41	109.41	109.77	186937500.0
2010-01-25	QQQ	ETF	44.39	44.6	44.12	44.31	154218611.0
2010-01-25	IWM	ETF	62.08	62.15	61.33	61.8	62298700.0
2010-01-25	DIA	ETF	102.39	102.52	101.67	101.91	18236800.0
2010-01-25	GLD	ETF	107.44	107.72	107.07	107.48	13200500.0
2010-01-25	TLT	ETF	91.54	91.92	91.49	91.58	2419500.0
2010-01-25	AAXJ	ETF	54.3	54.62	53.86	54.1	425600.0
2010-01-25	ACWI	ETF	41.57	41.7	41.35	41.53	277400.0
2010-01-25	ACWX	ETF	40.43	40.43	40.0	40.16	103515.0
2010-01-25	ADRE	ETF	41.82	41.83	41.04	41.16	235287.0
2010-01-25	AFK	ETF	28.66	29.17	28.41	28.87	13902.0
2010-01-25	AGG	ETF	104.49	104.49	104.26	104.45	514200.0
2010-01-25	AGQ	ETF	114.0	115.46	112.88	114.92	243250.0
2010-01-25	AGZ	ETF	108.46	108.54	108.32	108.54	13272.0
2010-01-25	AIA	ETF	38.93	39.05	38.78	38.8501	51719.0
2010-01-25	AIQ	ETF	26.0	26.35	25.4	25.55	24859.0
2010-01-25	AIS	ETF	1.22	1.22	1.13	1.13	250029.0
2010-01-25	AIVI	ETF	42.4	42.47	42.22	42.27	16700.0
2010-01-25	AMJ	ETF	29.32	29.7	29.32	29.67	285535.0
2010-01-25	AOA	ETF	29.72	29.83	29.58	29.68	29900.0
2010-01-25	AOK	ETF	27.3855	27.43	27.26	27.42	3701.0
2010-01-25	AOM	ETF	28.18	28.18	28.03	28.1	8111.0
2010-01-25	AOR	ETF	28.9	28.9	28.74	28.79	17386.0
2010-01-25	ARB	ETF	26.14	26.25	25.4	25.46	174924.0
2010-01-25	BAB	ETF	24.87	24.92	24.8	24.89	70298.0
2010-01-25	BAL	ETF	34.9699	34.9699	34.1	34.1	18244.0
2010-01-25	BBH	ETF	33.2667	33.2667	32.88	32.8933	107700.0
2010-01-25	BIL	ETF	91.72	91.72	91.66	91.72	132000.0
2010-01-25	BITS	ETF	32.0	32.4	31.56	32.16	2600.0
2010-01-25	BIV	ETF	80.59	80.65	80.54	80.64	100800.0
2010-01-25	BJK	ETF	24.89	24.89	24.47	24.5	16200.0
2010-01-25	BKF	ETF	43.76	44.0893	43.32	43.58	329317.0
2010-01-25	BLV	ETF	77.27	77.75	77.19	77.32	33400.0
2010-01-25	BMVP	ETF	12.4967	12.5584	12.4967	12.5167	17810.0
2010-01-25	BND	ETF	79.58	79.58	79.35	79.39	692900.0
2010-01-25	BNE	ETF	6.6	6.64	6.4	6.54	64416.0
2010-01-25	BRF	ETF	45.59	45.9499	44.7	44.97	474815.0
2010-01-25	BSV	ETF	80.26	80.31	80.2	80.26	413900.0
2010-01-25	BTF	ETF	64.74999999999999	65.25	64.6	64.6	9249.6
2010-01-25	BWX	ETF	28.755	28.755	28.425	28.44	560650.0
2010-01-25	BWZ	ETF	36.64	36.64	36.2655	36.37	29180.0
2010-01-25	BZQ	ETF	4262.4	4480.0	4232.0	4393.6	362.0
2010-01-25	CEF	ETF	13.63	13.66	13.51	13.55	947300.0
2010-01-25	CEW	ETF	21.97	22.01	21.89	21.92	277834.0
2010-01-25	CGO	ETF	14.82	14.82	14.16	14.29	22775.0
2010-01-25	CGW	ETF	18.31	18.31	18.13	18.16	144855.0
2010-01-25	CHI	ETF	12.44	12.44	12.32	12.4	128307.0
2010-01-25	CHIE	ETF	14.0304	14.049	13.9606	14.049	3070.0
2010-01-25	CHII	ETF	15.18	15.3	14.94	15.03	13730.0
2010-01-25	CHIM	ETF	27.12	27.12	26.58	26.58	170.0

> showing 50 of 717 rows — these rows as CSV

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