PREVIEW / etf_daily / 2010-04-19

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-19.parquet
  size:    32 KB
  rows:    749

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-19	SPY	ETF	119.01	119.93	118.47	119.81	217947800.0
2010-04-19	QQQ	ETF	49.36	49.66	48.9	49.5	98251680.0
2010-04-19	IWM	ETF	71.06	71.77	69.78	71.11	85284600.0
2010-04-19	DIA	ETF	109.86	110.91	109.74	110.84	10482500.0
2010-04-19	GLD	ETF	110.88	111.36	110.67	111.15	7993700.0
2010-04-19	TLT	ETF	89.87	90.03	89.52	89.64	3211500.0
2010-04-19	AAXJ	ETF	56.7	57.41	56.7	57.25	337700.0
2010-04-19	ACWI	ETF	43.95	44.35	43.85	44.26	261400.0
2010-04-19	ACWX	ETF	41.97	42.16	41.608	42.134	142840.0
2010-04-19	ADRE	ETF	44.12	44.54	43.75	44.37	136764.0
2010-04-19	AFK	ETF	31.67	32.44	31.67	31.84	22571.0
2010-04-19	AGG	ETF	104.41	104.5	104.21	104.23	769500.0
2010-04-19	AGQ	ETF	117.12	118.86	116.46	118.32	126800.0
2010-04-19	AGZ	ETF	108.24	108.35	108.14	108.2	18406.0
2010-04-19	AIA	ETF	40.75	41.11	40.591	41.09	23231.0
2010-04-19	AIQ	ETF	28.75	29.2	28.65	28.9	24521.0
2010-04-19	AIS	ETF	1.5	1.57	1.5	1.56	285039.0
2010-04-19	AIVI	ETF	43.36	43.62	43.11	43.58	11800.0
2010-04-19	AMJ	ETF	30.98	31.16	30.76	31.16	360870.0
2010-04-19	AOA	ETF	32.03	32.14	31.79	32.09	7300.0
2010-04-19	AOK	ETF	28.03	28.03	27.91	28.01	13785.0
2010-04-19	AOM	ETF	29.01	29.01	28.866	29.0	3037.0
2010-04-19	AOR	ETF	30.17	30.21	29.9799	30.21	11948.0
2010-04-19	ARB	ETF	27.26	27.49	26.71	27.25	244968.0
2010-04-19	BAB	ETF	25.14	25.16	25.05	25.09	165193.0
2010-04-19	BAL	ETF	38.15	38.65	38.15	38.65	2050.0
2010-04-19	BALT	ETF	13.78	13.84	13.64	13.67	408637.0
2010-04-19	BBH	ETF	34.3433	34.74	34.3433	34.6667	128400.0
2010-04-19	BIB	ETF	7.5	7.5738	7.375	7.4887	18800.0
2010-04-19	BICK	ETF	29.65	29.65	29.1	29.3	9093.0
2010-04-19	BIL	ETF	91.68	91.7	91.68	91.7	100600.0
2010-04-19	BIS	ETF	9499.2	9732.8	9499.2	9648.0	40.6
2010-04-19	BITS	ETF	32.16	32.2	31.484	32.2	1539.0
2010-04-19	BIV	ETF	80.63	80.64	80.41	80.48	71000.0
2010-04-19	BJK	ETF	26.32	26.49	25.98	26.37	12300.0
2010-04-19	BKF	ETF	46.1	46.516	45.7501	46.46	220212.0
2010-04-19	BLV	ETF	77.47	77.56	77.13	77.21	20500.0
2010-04-19	BMVP	ETF	13.52	13.54	13.43	13.5	11094.0
2010-04-19	BND	ETF	79.46	79.46	79.26	79.31	436600.0
2010-04-19	BNE	ETF	11.13	11.16	11.13	11.16	994212.0
2010-04-19	BRF	ETF	45.68	46.25	45.438	46.06	289163.0
2010-04-19	BSV	ETF	80.11	80.11	80.0	80.04	448100.0
2010-04-19	BTF	ETF	73.1	74.301	73.1	74.3	3877.0
2010-04-19	BWX	ETF	27.775	27.9525	27.775	27.85	456446.0
2010-04-19	BWZ	ETF	35.74	35.8299	35.648	35.74	13227.0
2010-04-19	BZQ	ETF	3648.0	3702.4	3542.4	3584.0	1976.0
2010-04-19	CEF	ETF	14.08	14.34	14.08	14.31	964100.0
2010-04-19	CEW	ETF	22.24	22.33	22.22	22.33	215470.0
2010-04-19	CGO	ETF	14.88	14.89	14.63	14.89	42551.0
2010-04-19	CGW	ETF	18.6	18.69	18.43	18.67	61222.0

> showing 50 of 749 rows — these rows as CSV

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