PREVIEW / etf_daily / 2010-03-29

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-29.parquet
  size:    32 KB
  rows:    737

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-03-29	SPY	ETF	117.17	117.53	116.69	117.32	134513500.0
2010-03-29	QQQ	ETF	48.23	48.4	48.1	48.23	57993222.0
2010-03-29	IWM	ETF	68.11	68.4	67.81	68.18	38646400.0
2010-03-29	DIA	ETF	108.79	109.16	108.67	108.92	5886300.0
2010-03-29	GLD	ETF	108.87	109.17	108.4	108.75	11527000.0
2010-03-29	TLT	ETF	88.78	88.85	88.31	88.61	3245100.0
2010-03-29	AAXJ	ETF	56.73	56.84	56.43	56.73	47900.0
2010-03-29	ACWI	ETF	43.23	43.65	43.23	43.63	184600.0
2010-03-29	ACWX	ETF	41.51	41.68	41.413	41.68	27168.0
2010-03-29	ADRE	ETF	43.15	43.737	43.15	43.68	94046.0
2010-03-29	AFK	ETF	31.19	31.43	30.9301	31.3	10164.0
2010-03-29	AGG	ETF	104.25	104.25	104.04	104.1	480000.0
2010-03-29	AGQ	ETF	112.98	115.12	112.5	114.28	168000.0
2010-03-29	AGZ	ETF	108.21	108.225	108.02	108.175	13180.0
2010-03-29	AIA	ETF	40.16	40.48	40.1001	40.48	61891.0
2010-03-29	AIQ	ETF	28.95	29.9	28.85	29.3	19425.0
2010-03-29	AIS	ETF	1.47	1.47	1.36	1.37	736708.0
2010-03-29	AIVI	ETF	42.28	42.51	42.28	42.49	31600.0
2010-03-29	AMJ	ETF	29.75	30.1	29.56	30.0	489454.0
2010-03-29	AOA	ETF	31.44	31.51	31.42	31.51	19300.0
2010-03-29	AOK	ETF	27.8241	27.86	27.792	27.792	6024.0
2010-03-29	AOM	ETF	28.62	28.71	28.62	28.71	24292.0
2010-03-29	AOR	ETF	29.72	29.76	29.683	29.76	25642.0
2010-03-29	ARB	ETF	26.65	27.07	26.57	26.66	250748.0
2010-03-29	BAB	ETF	24.9	24.9	24.78	24.86	211896.0
2010-03-29	BAL	ETF	38.66	38.83	38.66	38.83	1406.0
2010-03-29	BALT	ETF	13.4	13.8	13.4	13.75	166270.0
2010-03-29	BBH	ETF	34.4867	34.7867	34.4867	34.7067	96600.0
2010-03-29	BIL	ETF	91.7	91.72	91.68	91.68	173250.0
2010-03-29	BITS	ETF	32.16	32.6	31.8	32.56	2665.0
2010-03-29	BIV	ETF	80.06	80.19	79.95	80.06	96700.0
2010-03-29	BJK	ETF	25.75	25.82	25.57	25.76	17900.0
2010-03-29	BKF	ETF	45.7	46.11	45.6348	46.11	186234.0
2010-03-29	BLV	ETF	76.49	76.49	76.2	76.39	18200.0
2010-03-29	BMVP	ETF	13.16	13.2	13.14	13.19	13552.0
2010-03-29	BND	ETF	79.12	79.18	78.97	78.97	853200.0
2010-03-29	BNE	ETF	11.26	11.26	11.24	11.25	518622.0
2010-03-29	BRF	ETF	45.13	45.44	44.72	45.42	338652.0
2010-03-29	BSV	ETF	79.99	79.99	79.87	79.92	453400.0
2010-03-29	BTF	ETF	74.25	74.85	74.25	74.71499999999999	4749.0
2010-03-29	BWX	ETF	27.725	27.8657	27.725	27.82	379700.0
2010-03-29	BWZ	ETF	35.3	35.48	35.27	35.47	57564.0
2010-03-29	BZQ	ETF	3843.2	3848.0	3699.2	3705.6	452.5
2010-03-29	CEF	ETF	13.9	14.0	13.85	13.94	680300.0
2010-03-29	CEW	ETF	22.07	22.09	22.018	22.09	81952.0
2010-03-29	CGO	ETF	14.99	15.03	14.71	14.72	21679.0
2010-03-29	CGW	ETF	18.35	18.39	18.264	18.35	80285.0
2010-03-29	CHI	ETF	12.65	12.67	12.5	12.61	139722.0
2010-03-29	CHIE	ETF	14.49	14.64	14.47	14.63	7120.0
2010-03-29	CHII	ETF	15.16	15.2426	15.15	15.2235	14155.0

> showing 50 of 737 rows — these rows as CSV

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