PREVIEW / etf_daily / 2010-08-09

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-09.parquet
  size:    33 KB
  rows:    764

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-09	SPY	ETF	112.92	113.18	112.32	112.99	120800400.0
2010-08-09	QQQ	ETF	47.01	47.19	46.79	47.08	26937014.0
2010-08-09	IWM	ETF	65.62	66.11	64.85	65.86	35100700.0
2010-08-09	DIA	ETF	107.0	107.37	106.64	107.12	3723500.0
2010-08-09	GLD	ETF	117.76	117.85	117.23	117.4	6751400.0
2010-08-09	TLT	ETF	99.74	99.98	99.61	99.73	2578500.0
2010-08-09	AADR	ETF	26.0	26.23	26.0	26.06	5500.0
2010-08-09	AAXJ	ETF	57.19	57.45	57.11	57.24	251900.0
2010-08-09	ACWI	ETF	42.18	42.32	42.0	42.27	489400.0
2010-08-09	ACWX	ETF	40.23	40.26	40.048	40.13	20476.0
2010-08-09	ADRE	ETF	43.5	43.65	43.45	43.52	68735.0
2010-08-09	AFK	ETF	31.6	31.6	31.24	31.48	10322.0
2010-08-09	AGG	ETF	107.66	107.68	107.53	107.63	506900.0
2010-08-09	AGQ	ETF	121.1	121.16	118.54	119.78	55950.0
2010-08-09	AGZ	ETF	110.93	110.93	110.67	110.77	14943.0
2010-08-09	AIA	ETF	41.01	41.01	40.84	40.98	32861.0
2010-08-09	AIQ	ETF	23.7	25.3	23.25	24.2	49815.0
2010-08-09	AIS	ETF	1.74	1.74	1.69	1.71	638532.0
2010-08-09	AIVI	ETF	42.11	42.11	41.93	42.06	6000.0
2010-08-09	AMJ	ETF	33.89	33.89	33.17	33.34	1331594.0
2010-08-09	AOA	ETF	30.77	30.88	30.77	30.86	50100.0
2010-08-09	AOK	ETF	28.08	28.08	28.02	28.04	4932.0
2010-08-09	AOM	ETF	28.75	28.8	28.72	28.7401	4957.0
2010-08-09	AOR	ETF	29.49	29.5388	29.45	29.5388	5190.0
2010-08-09	ARB	ETF	27.83	28.1493	27.36	27.44	249453.0
2010-08-09	BAB	ETF	26.17	26.19	26.078	26.15	236985.0
2010-08-09	BAL	ETF	39.23	39.23	39.06	39.065	3476.0
2010-08-09	BALT	ETF	11.57	12.0	11.42	11.75	160235.0
2010-08-09	BBH	ETF	32.2367	32.2367	31.9567	32.0433	55200.0
2010-08-09	BIB	ETF	6.1162	6.1617	6.1113	6.1487	7200.0
2010-08-09	BICK	ETF	29.87	29.87	29.6	29.69	33752.0
2010-08-09	BIL	ETF	91.7	91.72	91.68	91.68	94550.0
2010-08-09	BIS	ETF	10494.4	10564.8	10494.4	10560.0	5.6
2010-08-09	BIV	ETF	85.03	85.06	84.94	85.02	152700.0
2010-08-09	BJK	ETF	26.04	26.16	25.97	26.12	10700.0
2010-08-09	BKF	ETF	45.82	46.0	45.6519	45.74	324771.0
2010-08-09	BLV	ETF	82.96	83.06	82.76	82.95	43900.0
2010-08-09	BMVP	ETF	12.76	12.8305	12.74	12.8207	8761.0
2010-08-09	BND	ETF	81.98	82.0	81.86	81.93	427000.0
2010-08-09	BNE	ETF	11.23	11.23	11.18	11.21	308369.0
2010-08-09	BNO	ETF	27.335	27.435	27.335	27.385	9400.0
2010-08-09	BRF	ETF	50.56	50.68	50.36	50.37	253517.0
2010-08-09	BSCE	ETF	20.81	20.81	20.7401	20.804	9268.0
2010-08-09	BSV	ETF	81.42	81.45	81.34	81.37	500900.0
2010-08-09	BTF	ETF	71.25	71.55	71.1	71.44999999999999	7160.8
2010-08-09	BWX	ETF	29.32	29.32	29.075	29.185	228768.0
2010-08-09	BWZ	ETF	35.9	35.99	35.75	35.87	15460.0
2010-08-09	BZQ	ETF	3238.4	3283.2	3232.0	3283.2	1857.0
2010-08-09	CEF	ETF	14.82	14.85	14.69	14.79	610900.0
2010-08-09	CEW	ETF	22.27	22.27	22.19	22.2157	116138.0

> showing 50 of 764 rows — these rows as CSV

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