PREVIEW / etf_daily / 2010-04-21

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-21.parquet
  size:    32 KB
  rows:    748

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-04-21	SPY	ETF	120.95	121.23	119.99	120.66	192910100.0
2010-04-21	QQQ	ETF	50.09	50.19	49.725	50.03	74748648.0
2010-04-21	IWM	ETF	72.2	72.72	71.92	72.58	60382500.0
2010-04-21	DIA	ETF	111.14	111.5	110.69	111.16	9115800.0
2010-04-21	GLD	ETF	111.82	112.64	111.48	112.31	6842900.0
2010-04-21	TLT	ETF	90.27	90.83	90.26	90.7	4162200.0
2010-04-21	AAXJ	ETF	58.05	58.05	57.4	57.82	94700.0
2010-04-21	ACWI	ETF	44.72	44.72	44.31	44.5	49100.0
2010-04-21	ACWX	ETF	42.38	42.4	41.99	42.24	43567.0
2010-04-21	ADRE	ETF	44.75	44.75	44.01	44.43	119588.0
2010-04-21	AFK	ETF	32.31	32.45	31.9599	32.0501	15441.0
2010-04-21	AGG	ETF	104.4	104.58	104.32	104.58	747600.0
2010-04-21	AGQ	ETF	120.72	123.54	119.76	123.26	114900.0
2010-04-21	AGZ	ETF	108.23	108.23	108.08	108.205	13468.0
2010-04-21	AIA	ETF	41.49	41.49	40.9575	41.25	17012.0
2010-04-21	AIQ	ETF	29.05	29.05	28.7	28.75	32287.0
2010-04-21	AIS	ETF	1.59	1.62	1.57	1.6	398603.0
2010-04-21	AIVI	ETF	43.86	43.86	43.49	43.76	5200.0
2010-04-21	AMJ	ETF	31.6	31.6	31.4	31.51	362192.0
2010-04-21	AOA	ETF	32.54	32.74	32.34	32.45	5500.0
2010-04-21	AOK	ETF	28.0934	28.13	28.067	28.11	3682.0
2010-04-21	AOM	ETF	28.96	29.13	28.96	29.13	15141.0
2010-04-21	AOR	ETF	30.65	30.65	30.02	30.35	4984.0
2010-04-21	ARB	ETF	28.0	28.73	27.98	28.65	240032.0
2010-04-21	BAB	ETF	25.28	25.41	25.21	25.31	340883.0
2010-04-21	BAL	ETF	40.79	40.9	40.2101	40.2101	7338.0
2010-04-21	BALT	ETF	13.9	13.98	13.82	13.94	222272.0
2010-04-21	BBH	ETF	33.5833	33.5833	32.75	32.9467	242700.0
2010-04-21	BIB	ETF	7.5263	7.5263	7.2	7.2787	20960.0
2010-04-21	BICK	ETF	29.94	30.05	29.5782	29.7699	43464.0
2010-04-21	BIL	ETF	91.68	91.7	91.68	91.68	120100.0
2010-04-21	BIS	ETF	9795.2	9953.6	9776.0	9882.56	30.5
2010-04-21	BITS	ETF	31.44	31.84	31.44	31.8	100.0
2010-04-21	BIV	ETF	80.56	80.74	80.45	80.7	107200.0
2010-04-21	BJK	ETF	27.08	27.08	26.72	26.83	70100.0
2010-04-21	BKF	ETF	46.87	46.88	46.03	46.42	102544.0
2010-04-21	BLV	ETF	77.53	77.94	77.53	77.93	19900.0
2010-04-21	BMVP	ETF	13.67	13.72	13.64	13.72	29189.0
2010-04-21	BND	ETF	79.4	79.5	79.36	79.45	704900.0
2010-04-21	BNE	ETF	11.17	11.19	11.14	11.18	438259.0
2010-04-21	BRF	ETF	46.16	46.36	45.51	45.85	1082847.0
2010-04-21	BSV	ETF	80.01	80.08	79.98	80.07	521400.0
2010-04-21	BTF	ETF	75.05	75.3	74.64999999999999	74.85	6395.200000000001
2010-04-21	BWX	ETF	27.92	27.92	27.8265	27.87	168970.0
2010-04-21	BWZ	ETF	35.64	35.678	35.52	35.6	33186.0
2010-04-21	BZQ	ETF	3568.0	3732.8	3542.4	3625.6	365.0
2010-04-21	CEF	ETF	14.38	14.53	14.36	14.48	786100.0
2010-04-21	CEW	ETF	22.34	22.41	22.34	22.41	321880.0
2010-04-21	CGO	ETF	15.09	15.09	14.89	14.92	63745.0
2010-04-21	CGW	ETF	18.77	18.79	18.64	18.73	36145.0

> showing 50 of 748 rows — these rows as CSV

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