PREVIEW / etf_daily / 2010-12-14

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-14.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-14	SPY	ETF	124.75	125.23	124.29	124.67	147249600.0
2010-12-14	QQQ	ETF	54.42	54.62	54.23	54.395	69944026.0
2010-12-14	IWM	ETF	77.71	77.72	77.18	77.31	60000700.0
2010-12-14	DIA	ETF	114.63	115.38	114.59	115.01	5212500.0
2010-12-14	GLD	ETF	136.27	137.21	135.86	136.18	17430800.0
2010-12-14	TLT	ETF	92.4	93.02	91.44	92.14	23516400.0
2010-12-14	AADR	ETF	29.81	29.81	29.5	29.64	6800.0
2010-12-14	AAXJ	ETF	63.76	63.76	63.38	63.52	165400.0
2010-12-14	ACWI	ETF	46.62	46.8	46.46	46.54	725400.0
2010-12-14	ACWX	ETF	43.93	44.27	43.92	44.07	74696.0
2010-12-14	ADRE	ETF	46.89	47.138	46.8	46.93	33170.0
2010-12-14	AFK	ETF	34.48	34.699	34.2	34.31	36273.0
2010-12-14	AGG	ETF	105.16	105.28	104.6	104.78	941200.0
2010-12-14	AGQ	ETF	288.46	297.88	286.04	290.82	631150.0
2010-12-14	AGZ	ETF	109.52	109.52	108.74	109.35	29521.0
2010-12-14	AIA	ETF	46.57	46.59	46.32	46.38	31283.0
2010-12-14	AIQ	ETF	18.7	18.75	17.0	17.5	679654.0
2010-12-14	AIS	ETF	1.51	1.55	1.48	1.49	371633.0
2010-12-14	AIVI	ETF	43.95	44.2	43.79	44.01	22400.0
2010-12-14	AMJ	ETF	36.13	36.13	35.78	35.86	1359718.0
2010-12-14	AMLP	ETF	80.1	80.1	79.6	79.65	195300.0
2010-12-14	AOA	ETF	34.18	34.23	34.05	34.05	23300.0
2010-12-14	AOK	ETF	28.6146	28.6248	28.49	28.49	5289.0
2010-12-14	AOM	ETF	29.86	29.87	29.7265	29.75	10305.0
2010-12-14	AOR	ETF	31.35	31.42	31.24	31.28	19363.0
2010-12-14	ARB	ETF	38.24	39.9	37.96	39.56	648670.0
2010-12-14	BAB	ETF	25.02	25.12	24.9277	24.978	521201.0
2010-12-14	BAL	ETF	74.3	74.74	72.91	73.0	52323.0
2010-12-14	BALT	ETF	11.1	11.24	11.0	11.02	223268.0
2010-12-14	BBH	ETF	33.4267	33.61	33.2533	33.55	123600.0
2010-12-14	BIB	ETF	7.2313	7.2313	7.2313	7.2313	2400.0
2010-12-14	BICK	ETF	32.46	32.54	32.28	32.42	20006.0
2010-12-14	BIL	ETF	91.7	91.72	91.7	91.72	388500.0
2010-12-14	BITS	ETF	28.92	29.0	28.2804	28.92	1812.0
2010-12-14	BIV	ETF	82.78	82.78	82.0	82.19	280500.0
2010-12-14	BJK	ETF	31.63	31.75	31.27	31.29	9200.0
2010-12-14	BKF	ETF	49.22	49.46	49.05	49.26	98836.0
2010-12-14	BLV	ETF	78.31	78.77	77.73	77.96	152400.0
2010-12-14	BMVP	ETF	14.7067	14.7967	14.7067	14.7333	9575.0
2010-12-14	BND	ETF	80.33	80.43	79.91	80.02	1305100.0
2010-12-14	BNO	ETF	30.315	30.565	30.31	30.46	25400.0
2010-12-14	BOSS	ETF	45.305	45.305	45.17	45.17	100.0
2010-12-14	BRF	ETF	58.95	59.14	58.7	58.93	261719.0
2010-12-14	BSCE	ETF	20.66	20.66	20.55	20.64	2707.0
2010-12-14	BSV	ETF	80.72	80.75	80.52	80.59	516500.0
2010-12-14	BTF	ETF	77.64999999999999	78.624	77.5	78.25	3250.8
2010-12-14	BWX	ETF	28.875	28.945	28.645	28.705	420788.0
2010-12-14	BWZ	ETF	36.585	36.78	36.5001	36.59	1628.0
2010-12-14	BZQ	ETF	2667.2	2668.8	2609.6	2632.0	1406.0
2010-12-14	CEF	ETF	20.2	20.33	20.05	20.14	809800.0

> showing 50 of 813 rows — these rows as CSV

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