PREVIEW / etf_daily / 2011-01-04

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-04.parquet
  size:    35 KB
  rows:    819

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
2011-01-04	SPY	ETF	127.33	127.37	126.19	126.98	137409700.0
2011-01-04	QQQ	ETF	55.53	55.55	54.92	55.265	43851454.0
2011-01-04	IWM	ETF	79.84	79.9	77.57	78.42	77509000.0
2011-01-04	DIA	ETF	116.71	116.73	116.11	116.64	9775600.0
2011-01-04	GLD	ETF	136.24	136.28	134.16	134.75	26154300.0
2011-01-04	TLT	ETF	93.41	93.77	92.91	93.52	10466900.0
2011-01-04	AADR	ETF	30.3	30.35	29.91	30.01	22200.0
2011-01-04	AAXJ	ETF	65.19	65.19	64.36	64.93	574300.0
2011-01-04	ACWI	ETF	47.38	47.38	46.79	47.11	168500.0
2011-01-04	ACWX	ETF	44.61	44.72	43.93	44.17	411814.0
2011-01-04	ADRE	ETF	48.55	48.66	47.903	48.5	66965.0
2011-01-04	AFK	ETF	35.16	35.3	35.0	35.27	33762.0
2011-01-04	AGG	ETF	105.68	105.77	105.5	105.66	625500.0
2011-01-04	AGQ	ETF	305.7	306.16	285.24	294.78	882000.0
2011-01-04	AGZ	ETF	109.48	109.67	109.46	109.49	18198.0
2011-01-04	AIA	ETF	48.02	48.02	47.451	47.74	78637.0
2011-01-04	AIQ	ETF	21.8	21.8	21.25	21.45	24251.0
2011-01-04	AIS	ETF	1.7	1.8	1.7	1.73	688649.0
2011-01-04	AIVI	ETF	44.33	44.37	43.86	44.0	35600.0
2011-01-04	AMJ	ETF	36.64	36.699	36.2301	36.38	908341.0
2011-01-04	AMLP	ETF	80.2	80.75	80.1	80.35	217940.0
2011-01-04	AOA	ETF	34.84	34.84	34.35	34.56	24600.0
2011-01-04	AOK	ETF	28.92	28.92	28.7923	28.8299	55986.0
2011-01-04	AOM	ETF	30.1	30.1	29.94	30.01	13938.0
2011-01-04	AOR	ETF	31.75	31.75	31.5	31.58	17118.0
2011-01-04	ARB	ETF	42.77	43.1992	41.79	42.0	293599.0
2011-01-04	BAB	ETF	25.0	25.0635	24.93	25.0	277051.0
2011-01-04	BAL	ETF	72.16	73.609	71.61	73.56	54088.0
2011-01-04	BALT	ETF	10.49	10.6	10.36	10.36	119222.0
2011-01-04	BBH	ETF	33.58	33.8867	33.58	33.7967	120600.0
2011-01-04	BIB	ETF	7.6625	7.6625	7.5625	7.5625	45600.0
2011-01-04	BICK	ETF	33.48	33.48	33.016	33.37	93751.0
2011-01-04	BIL	ETF	91.72	91.72	91.7	91.72	156750.0
2011-01-04	BITS	ETF	29.32	29.32	28.72	28.92	2433.0
2011-01-04	BIV	ETF	82.62	82.75	82.43	82.54	190800.0
2011-01-04	BJK	ETF	32.04	32.12	31.81	32.1	16200.0
2011-01-04	BKF	ETF	50.1	50.43	49.47	50.08	204053.0
2011-01-04	BLV	ETF	78.87	79.19	78.65	78.96	23700.0
2011-01-04	BMVP	ETF	14.843	14.843	14.647	14.713	7236.0
2011-01-04	BND	ETF	80.22	80.33	80.08	80.18	1784100.0
2011-01-04	BNO	ETF	31.655	31.655	30.905	30.93	17400.0
2011-01-04	BRF	ETF	58.54	58.65	57.55	58.65	534370.0
2011-01-04	BSCE	ETF	20.73	20.77	20.64	20.7299	24823.0
2011-01-04	BSV	ETF	80.45	80.49	80.36	80.4	430400.0
2011-01-04	BTF	ETF	78.3	78.595	77.5	78.31	2550.8
2011-01-04	BWX	ETF	29.25	29.25	29.02	29.08	295244.0
2011-01-04	BWZ	ETF	37.15	37.15	36.8901	36.915	20236.0
2011-01-04	BZQ	ETF	2372.8	2433.6	2344.0	2344.0	915.0
2011-01-04	CEF	ETF	20.36	20.44	19.76	19.93	2017600.0
2011-01-04	CEW	ETF	22.45	22.51	22.39	22.5	179718.0

> showing 50 of 819 rows — these rows as CSV

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