PREVIEW / etf_daily / 2010-01-12

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-12.parquet
  size:    31 KB
  rows:    710

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-12	SPY	ETF	113.97	114.21	113.22	113.66	163333500.0
2010-01-12	QQQ	ETF	46.08	46.14	45.53	45.78	90673830.0
2010-01-12	IWM	ETF	63.86	64.16	63.26	63.56	45854900.0
2010-01-12	DIA	ETF	105.85	106.42	105.58	106.14	8869900.0
2010-01-12	GLD	ETF	112.38	113.05	110.14	110.49	29182600.0
2010-01-12	TLT	ETF	90.16	90.39	89.84	90.32	4321200.0
2010-01-12	AAXJ	ETF	57.68	57.72	57.1	57.42	1028300.0
2010-01-12	ACWI	ETF	43.55	43.55	43.18	43.3	171500.0
2010-01-12	ACWX	ETF	42.18	42.4	42.04	42.27	304096.0
2010-01-12	ADRE	ETF	45.24	45.24	44.65	44.83	178917.0
2010-01-12	AFK	ETF	29.72	30.85	29.6599	29.7	43204.0
2010-01-12	AGG	ETF	103.87	104.24	103.82	104.24	1818500.0
2010-01-12	AGQ	ETF	134.42	136.18	129.46	130.62	219300.0
2010-01-12	AGZ	ETF	108.17	108.28	108.1106	108.28	29586.0
2010-01-12	AIA	ETF	41.0	41.06	40.55	40.6	121466.0
2010-01-12	AIQ	ETF	26.5	26.6	26.0	26.15	45689.0
2010-01-12	AIS	ETF	1.29	1.29	1.23	1.24	546191.0
2010-01-12	AIVI	ETF	44.4	44.45	44.03	44.14	34400.0
2010-01-12	AMJ	ETF	29.13	29.5	29.13	29.24	217899.0
2010-01-12	AOA	ETF	30.68	30.71	30.52	30.59	6400.0
2010-01-12	AOK	ETF	27.65	27.66	27.59	27.66	44747.0
2010-01-12	AOM	ETF	28.5995	28.61	28.5395	28.56	14699.0
2010-01-12	AOR	ETF	29.5	29.54	29.36	29.47	7519.0
2010-01-12	ARB	ETF	24.05	25.22	23.17	24.15	1096707.0
2010-01-12	BAB	ETF	24.59	24.6	24.46	24.59	163202.0
2010-01-12	BAL	ETF	36.75	36.75	35.54	35.58	4729.0
2010-01-12	BBH	ETF	33.1133	33.27	32.71	32.99	301800.0
2010-01-12	BIL	ETF	91.7	91.7	91.68	91.68	142400.0
2010-01-12	BITS	ETF	31.5996	32.64	31.44	32.008	3862.0
2010-01-12	BIV	ETF	80.15	80.24	79.97	80.16	132200.0
2010-01-12	BJK	ETF	25.22	25.3	24.86	25.04	25000.0
2010-01-12	BKF	ETF	47.29	47.32	46.69	47.0	254762.0
2010-01-12	BLV	ETF	76.55	76.93	76.47	76.65	38100.0
2010-01-12	BMVP	ETF	12.94	12.96	12.87	12.89	41866.0
2010-01-12	BND	ETF	79.11	79.23	79.08	79.23	702100.0
2010-01-12	BNE	ETF	7.19	7.3	7.06	7.13	140091.0
2010-01-12	BOSS	ETF	20.82	20.82	20.05	20.565	800.0
2010-01-12	BRF	ETF	50.05	50.44	49.75	50.0	561617.0
2010-01-12	BSV	ETF	80.0	80.09	79.97	80.05	409300.0
2010-01-12	BTF	ETF	64.18499999999999	64.35	64.0	64.0	1079.2
2010-01-12	BWX	ETF	28.83	29.0	28.79	28.795	286320.0
2010-01-12	BWZ	ETF	36.98	37.1	36.73	37.0	35328.0
2010-01-12	BZQ	ETF	3564.8	3601.6	3512.0	3547.2	432.5
2010-01-12	CEF	ETF	14.65	14.66	14.24	14.3	1240100.0
2010-01-12	CEW	ETF	22.33	22.37	22.31	22.34	155609.0
2010-01-12	CGO	ETF	14.8	15.0	14.8	14.91	30185.0
2010-01-12	CGW	ETF	18.88	19.04	18.7619	18.87	65302.0
2010-01-12	CHI	ETF	12.61	12.67	12.57	12.67	114329.0
2010-01-12	CHIE	ETF	16.15	16.15	15.8	15.91	33854.0
2010-01-12	CHII	ETF	16.74	16.74	16.26	16.39	38538.0

> showing 50 of 710 rows — these rows as CSV

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