PREVIEW / etf_daily / 2010-12-29

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-29.parquet
  size:    35 KB
  rows:    813

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-12-29	SPY	ETF	125.98	126.2	125.9	125.92	58033100.0
2010-12-29	QQQ	ETF	54.82	54.9	54.73	54.79	24132688.0
2010-12-29	IWM	ETF	78.85	79.02	78.75	78.91	18138800.0
2010-12-29	DIA	ETF	115.71	115.98	115.62	115.65	6621900.0
2010-12-29	GLD	ETF	137.38	138.05	137.19	137.71	8442300.0
2010-12-29	TLT	ETF	91.76	93.52	91.47	93.16	13115400.0
2010-12-29	AADR	ETF	29.64	29.79	29.64	29.79	600.0
2010-12-29	AAXJ	ETF	63.23	63.38	63.21	63.22	739900.0
2010-12-29	ACWI	ETF	46.67	46.77	46.55	46.61	500500.0
2010-12-29	ACWX	ETF	43.86	43.98	43.7456	43.89	42887.0
2010-12-29	ADRE	ETF	47.11	47.5688	47.11	47.51	52711.0
2010-12-29	AFK	ETF	34.63	34.71	34.44	34.67	15351.0
2010-12-29	AGG	ETF	104.71	105.47	104.68	105.4	487100.0
2010-12-29	AGQ	ETF	309.86	313.52	308.44	310.84	387350.0
2010-12-29	AGZ	ETF	109.3	109.56	109.03	109.47	16423.0
2010-12-29	AIA	ETF	46.23	46.48	46.23	46.39	35254.0
2010-12-29	AIQ	ETF	21.35	21.9	21.25	21.8	25510.0
2010-12-29	AIS	ETF	1.72	1.75	1.69	1.72	481438.0
2010-12-29	AIVI	ETF	43.84	44.1	43.76	44.0	67500.0
2010-12-29	AMJ	ETF	36.05	36.17	35.96	36.08	548293.0
2010-12-29	AMLP	ETF	79.95	80.0	79.75	79.95	189540.0
2010-12-29	AOA	ETF	34.34	34.44	34.29	34.39	20000.0
2010-12-29	AOK	ETF	28.62	28.74	28.62	28.7101	10703.0
2010-12-29	AOM	ETF	29.84	29.93	29.82	29.93	13279.0
2010-12-29	AOR	ETF	31.44	31.55	31.42	31.516	29002.0
2010-12-29	ARB	ETF	42.08	42.18	41.66	41.72	126020.0
2010-12-29	BAB	ETF	24.77	24.97	24.69	24.9499	242560.0
2010-12-29	BAL	ETF	73.8	74.28	71.11	71.15	64537.0
2010-12-29	BALT	ETF	10.3	10.4	10.2	10.23	192339.0
2010-12-29	BBH	ETF	33.4267	33.5467	33.4267	33.45	18000.0
2010-12-29	BICK	ETF	32.04	32.4	32.04	32.329	53253.0
2010-12-29	BIL	ETF	91.72	91.72	91.7	91.7	72150.0
2010-12-29	BIS	ETF	8003.2	8003.2	8003.2	8003.2	0.625
2010-12-29	BITS	ETF	28.72	28.84	28.24	28.8	825.0
2010-12-29	BIV	ETF	81.59	82.43	81.57	82.3	113300.0
2010-12-29	BJK	ETF	31.16	31.24	31.06	31.18	7500.0
2010-12-29	BKF	ETF	48.3	48.61	48.29	48.49	113933.0
2010-12-29	BLV	ETF	77.53	78.84	77.43	78.73	27600.0
2010-12-29	BMVP	ETF	14.69	14.735	14.677	14.707	5395.0
2010-12-29	BND	ETF	79.56	80.08	79.54	79.99	642100.0
2010-12-29	BNO	ETF	31.385	31.385	31.355	31.355	800.0
2010-12-29	BRF	ETF	54.94	55.88	54.77	55.76	297250.0
2010-12-29	BSCE	ETF	20.69	20.69	20.6095	20.6095	8507.0
2010-12-29	BSV	ETF	80.1	80.36	80.07	80.35	522500.0
2010-12-29	BTF	ETF	77.69949999999999	77.75	76.845	77.05	14352.0
2010-12-29	BWX	ETF	28.77	28.94	28.665	28.94	369578.0
2010-12-29	BWZ	ETF	36.56	36.71	36.406	36.65	8422.0
2010-12-29	BZQ	ETF	2612.8	2612.8	2500.8	2500.8	761.0
2010-12-29	CEF	ETF	20.44	20.72	20.35	20.56	1183500.0
2010-12-29	CEW	ETF	22.38	22.39	22.32	22.38	269575.0

> showing 50 of 813 rows — these rows as CSV

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