PREVIEW / etf_daily / 2010-10-12

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-12.parquet
  size:    34 KB
  rows:    797

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-10-12	SPY	ETF	116.27	117.35	115.65	117.01	182210000.0
2010-10-12	QQQ	ETF	49.69	50.21	49.26	50.11	88571612.0
2010-10-12	IWM	ETF	69.16	69.82	68.41	69.52	51099800.0
2010-10-12	DIA	ETF	109.93	110.63	109.21	110.26	5373500.0
2010-10-12	GLD	ETF	132.06	132.21	131.36	131.96	13289200.0
2010-10-12	TLT	ETF	104.41	104.76	103.18	103.21	6122400.0
2010-10-12	AADR	ETF	28.64	28.76	28.45	28.76	2000.0
2010-10-12	AAXJ	ETF	62.18	62.31	61.83	62.17	732400.0
2010-10-12	ACWI	ETF	44.32	44.59	44.0	44.51	131900.0
2010-10-12	ACWX	ETF	42.5	42.78	42.15	42.69	50127.0
2010-10-12	ADRE	ETF	46.33	46.33	45.72	46.3	83969.0
2010-10-12	AFK	ETF	33.47	33.78	33.26	33.749	19275.0
2010-10-12	AGG	ETF	108.82	108.9	108.6	108.65	573300.0
2010-10-12	AGQ	ETF	188.48	192.26	184.72	189.92	353900.0
2010-10-12	AGZ	ETF	111.7408	111.85	111.66	111.67	19597.0
2010-10-12	AIA	ETF	43.27	43.37	42.9201	43.31	14938.0
2010-10-12	AIQ	ETF	23.35	23.35	22.75	22.95	23523.0
2010-10-12	AIS	ETF	1.6	1.6	1.53	1.56	261958.0
2010-10-12	AIVI	ETF	44.39	44.64	44.05	44.55	16100.0
2010-10-12	AMJ	ETF	34.88	34.9	34.68	34.9	345773.0
2010-10-12	AMLP	ETF	78.85	79.0	78.5	78.95	108520.0
2010-10-12	AOA	ETF	31.92	32.34	31.92	32.34	5200.0
2010-10-12	AOK	ETF	28.7	28.7	28.6	28.6384	11062.0
2010-10-12	AOM	ETF	29.45	29.51	29.3801	29.51	4483.0
2010-10-12	AOR	ETF	30.42	30.5299	30.339	30.5299	5219.0
2010-10-12	ARB	ETF	29.31	29.74	28.97	29.63	56284.0
2010-10-12	BAB	ETF	26.78	26.79	26.62	26.62	210000.0
2010-10-12	BAL	ETF	54.38	54.38	53.44	53.55	20139.0
2010-10-12	BALT	ETF	11.05	11.14	10.97	11.01	129991.0
2010-10-12	BBH	ETF	32.3067	32.4667	32.0833	32.4267	41100.0
2010-10-12	BIB	ETF	6.6338	6.6338	6.6338	6.6338	1600.0
2010-10-12	BICK	ETF	32.74	32.74	32.47	32.632	41098.0
2010-10-12	BIL	ETF	91.7	91.72	91.7	91.7	425750.0
2010-10-12	BIS	ETF	9620.8	9620.8	9297.6	9308.8	23.75
2010-10-12	BITS	ETF	27.36	27.36	26.8	27.36	1325.0
2010-10-12	BIV	ETF	87.56	87.56	87.25	87.31	246400.0
2010-10-12	BJK	ETF	29.95	30.11	29.65	30.01	11000.0
2010-10-12	BKF	ETF	49.34	49.67	49.04	49.61	132756.0
2010-10-12	BLV	ETF	85.82	85.9	85.11	85.12	24600.0
2010-10-12	BMVP	ETF	13.31	13.4	13.23	13.39	10161.0
2010-10-12	BND	ETF	82.91	82.93	82.72	82.72	431400.0
2010-10-12	BNE	ETF	11.31	11.39	11.31	11.36	965400.0
2010-10-12	BRF	ETF	59.81	60.19	58.911	60.19	421525.0
2010-10-12	BSCE	ETF	21.09	21.15	20.99	21.145	17208.0
2010-10-12	BSV	ETF	81.94	81.96	81.83	81.84	411100.0
2010-10-12	BTF	ETF	76.9	77.45	76.85	77.14999999999999	2132.8
2010-10-12	BWX	ETF	30.66	30.9245	30.605	30.705	233412.0
2010-10-12	BWZ	ETF	37.44	37.7684	37.43	37.6101	8037.0
2010-10-12	BZQ	ETF	2584.0	2632.0	2547.2	2568.0	634.0
2010-10-12	CEF	ETF	17.31	17.31	17.11	17.26	834900.0

> showing 50 of 797 rows — these rows as CSV

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