PREVIEW / etf_daily / 2010-08-11

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-11.parquet
  size:    33 KB
  rows:    771

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-08-11	SPY	ETF	110.65	110.69	109.12	109.3	273406900.0
2010-08-11	QQQ	ETF	45.91	45.92	45.21	45.4	92219647.0
2010-08-11	IWM	ETF	63.33	63.33	61.91	62.08	87392600.0
2010-08-11	DIA	ETF	105.19	105.21	103.91	104.13	9496200.0
2010-08-11	GLD	ETF	117.74	118.14	116.58	117.34	12436900.0
2010-08-11	TLT	ETF	100.31	101.39	100.31	101.28	6778300.0
2010-08-11	AADR	ETF	25.17	25.17	25.17	25.17	100.0
2010-08-11	AAXJ	ETF	55.3	55.48	54.8	54.8	248900.0
2010-08-11	ACWI	ETF	40.99	40.99	40.44	40.44	276000.0
2010-08-11	ACWX	ETF	38.68	38.68	38.09	38.12	46620.0
2010-08-11	ADRE	ETF	42.22	42.49	41.6	41.73	245111.0
2010-08-11	AFK	ETF	30.7	30.7	30.0301	30.2	14102.0
2010-08-11	AGG	ETF	107.91	107.96	107.79	107.91	682300.0
2010-08-11	AGQ	ETF	116.84	117.48	113.1	114.08	170150.0
2010-08-11	AGZ	ETF	111.03	111.03	110.89	110.96	27429.0
2010-08-11	AIA	ETF	39.54	39.54	39.2	39.2319	28711.0
2010-08-11	AIQ	ETF	22.95	23.5	22.45	22.45	30610.0
2010-08-11	AIS	ETF	1.65	1.68	1.55	1.67	1223445.0
2010-08-11	AIVI	ETF	40.5	40.5	39.84	39.87	4400.0
2010-08-11	AMJ	ETF	32.7	32.89	32.02	32.16	1199407.0
2010-08-11	AOA	ETF	30.01	30.01	29.59	29.63	21300.0
2010-08-11	AOK	ETF	27.89	27.89	27.8	27.84	8334.0
2010-08-11	AOM	ETF	28.48	28.48	28.2801	28.33	88827.0
2010-08-11	AOR	ETF	29.01	29.03	28.7908	28.85	12085.0
2010-08-11	ARB	ETF	26.59	26.59	25.95	26.24	192705.0
2010-08-11	BAB	ETF	26.29	26.43	26.23	26.4	356162.0
2010-08-11	BAL	ETF	39.42	39.52	39.325	39.39	1017.0
2010-08-11	BALT	ETF	11.12	11.45	10.86	10.89	262340.0
2010-08-11	BBH	ETF	31.56	31.6167	30.9633	31.0333	93000.0
2010-08-11	BIB	ETF	5.8963	5.8963	5.6868	5.7075	10400.0
2010-08-11	BICK	ETF	28.82	28.82	28.35	28.39	14646.0
2010-08-11	BIL	ETF	91.68	91.72	91.68	91.72	830500.0
2010-08-11	BITS	ETF	27.4	27.6	27.4	27.6	175.0
2010-08-11	BIV	ETF	85.61	85.69	85.5	85.64	181200.0
2010-08-11	BJK	ETF	25.15	25.15	24.82	24.94	9200.0
2010-08-11	BKF	ETF	44.05	44.07	43.5	43.67	129137.0
2010-08-11	BLV	ETF	83.17	83.68	83.01	83.61	31700.0
2010-08-11	BMVP	ETF	12.46	12.46	12.3	12.3	8007.0
2010-08-11	BND	ETF	82.14	82.2	82.08	82.16	865000.0
2010-08-11	BNE	ETF	11.21	11.23	11.16	11.18	452045.0
2010-08-11	BNO	ETF	26.55	26.575	26.25	26.27	27400.0
2010-08-11	BRF	ETF	49.24	49.24	48.18	48.2	369426.0
2010-08-11	BSCE	ETF	20.86	20.86	20.7952	20.833	14568.0
2010-08-11	BSV	ETF	81.55	81.56	81.47	81.5	300300.0
2010-08-11	BTF	ETF	70.7	70.70049999999999	69.17999999999999	69.25	5315.6
2010-08-11	BWX	ETF	28.67	28.9167	28.365	28.615	269758.0
2010-08-11	BWZ	ETF	35.58	35.58	35.29	35.3787	9323.0
2010-08-11	BZQ	ETF	3457.6	3569.6	3448.0	3563.2	1252.5
2010-08-11	CEF	ETF	14.76	14.77	14.53	14.63	795900.0
2010-08-11	CEW	ETF	22.02	22.02	21.9	21.93	131424.0

> showing 50 of 771 rows — these rows as CSV

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