PREVIEW / etf_daily / 2010-01-11

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-11.parquet
  size:    31 KB
  rows:    714

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-11	SPY	ETF	115.08	115.13	114.24	114.73	106375700.0
2010-01-11	QQQ	ETF	46.6	46.64	46.12	46.36	104673315.0
2010-01-11	IWM	ETF	64.78	64.88	64.01	64.26	51638900.0
2010-01-11	DIA	ETF	106.4	106.66	105.82	106.54	6858300.0
2010-01-11	GLD	ETF	113.34	113.59	112.52	112.85	17253000.0
2010-01-11	TLT	ETF	88.99	89.36	88.77	88.8	2181300.0
2010-01-11	AAXJ	ETF	58.26	58.3	57.76	57.98	268700.0
2010-01-11	ACWI	ETF	43.78	43.88	43.62	43.85	118100.0
2010-01-11	ACWX	ETF	42.88	42.88	42.5	42.75	821303.0
2010-01-11	ADRE	ETF	46.0	46.0	45.276	45.59	142032.0
2010-01-11	AFK	ETF	29.78	29.83	29.58	29.81	7968.0
2010-01-11	AGG	ETF	103.65	103.72	103.51	103.58	684400.0
2010-01-11	AGQ	ETF	138.74	139.18	135.4	135.58	181550.0
2010-01-11	AGZ	ETF	108.11	108.11	107.868	108.0287	12808.0
2010-01-11	AIA	ETF	41.41	41.41	40.991	41.15	54531.0
2010-01-11	AIQ	ETF	26.5	26.7	26.15	26.55	33069.0
2010-01-11	AIS	ETF	1.33	1.35	1.2305	1.27	1264195.0
2010-01-11	AIVI	ETF	44.91	45.0	44.78	44.85	71500.0
2010-01-11	AMJ	ETF	29.48	29.685	29.3708	29.4	356294.0
2010-01-11	AOA	ETF	31.0	31.0	30.75	30.85	7700.0
2010-01-11	AOK	ETF	27.59	27.73	27.59	27.65	30463.0
2010-01-11	AOM	ETF	28.73	28.73	28.57	28.66	65137.0
2010-01-11	AOR	ETF	29.74	29.74	29.575	29.575	4352.0
2010-01-11	ARB	ETF	27.14	27.14	26.5	26.7	298693.0
2010-01-11	BAB	ETF	24.43	24.47	24.34	24.42	175179.0
2010-01-11	BAL	ETF	35.14	36.4	35.14	36.35	13051.0
2010-01-11	BBH	ETF	33.24	33.3733	33.0067	33.2867	184500.0
2010-01-11	BIL	ETF	91.68	91.7	91.68	91.68	131100.0
2010-01-11	BITS	ETF	31.04	31.88	31.04	31.7128	700.0
2010-01-11	BIV	ETF	79.79	79.89	79.6	79.82	182300.0
2010-01-11	BJK	ETF	25.44	25.44	25.0	25.16	15500.0
2010-01-11	BKF	ETF	48.14	48.14	47.4225	47.76	300629.0
2010-01-11	BLV	ETF	76.29	76.34	76.05	76.19	17400.0
2010-01-11	BMVP	ETF	13.01	13.02	12.96	13.01	17306.0
2010-01-11	BND	ETF	78.92	78.96	78.83	78.93	2237100.0
2010-01-11	BNE	ETF	7.39	7.39	7.23	7.29	79571.0
2010-01-11	BOSS	ETF	21.0	21.0	20.71	20.71	100.0
2010-01-11	BRF	ETF	50.97	51.0	50.26	50.68	527261.0
2010-01-11	BSV	ETF	80.0	80.0	79.81	79.96	419100.0
2010-01-11	BTF	ETF	64.5	64.69999999999999	64.19999999999999	64.3	2477.4
2010-01-11	BWX	ETF	28.735	28.8591	28.695	28.78	399262.0
2010-01-11	BWZ	ETF	36.91	36.91	36.8	36.87	56537.0
2010-01-11	BZQ	ETF	3392.0	3513.6	3380.8	3452.8	282.5
2010-01-11	CEF	ETF	14.76	14.94	14.63	14.68	1572200.0
2010-01-11	CEW	ETF	22.43	22.47	22.38	22.44	178114.0
2010-01-11	CGO	ETF	14.84	14.97	14.72	14.75	27379.0
2010-01-11	CGW	ETF	19.08	19.18	18.9101	19.07	102108.0
2010-01-11	CHI	ETF	12.83	12.83	12.6	12.66	144756.0
2010-01-11	CHIE	ETF	16.38	16.39	16.178	16.26	38684.0
2010-01-11	CHII	ETF	16.59	16.79	16.47	16.67	35368.0

> showing 50 of 714 rows — these rows as CSV

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