PREVIEW / etf_daily / 2010-10-07

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-07.parquet
  size:    34 KB
  rows:    795

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-07	SPY	ETF	116.5	116.53	115.19	115.89	164860000.0
2010-10-07	QQQ	ETF	49.52	49.54	49.0	49.41	75693259.0
2010-10-07	IWM	ETF	69.02	69.08	67.92	68.41	39955400.0
2010-10-07	DIA	ETF	110.09	110.11	109.01	109.6	5282200.0
2010-10-07	GLD	ETF	132.6	132.67	129.51	130.37	38676800.0
2010-10-07	TLT	ETF	105.17	105.38	104.67	104.68	5780700.0
2010-10-07	AADR	ETF	28.59	28.59	28.39	28.39	3400.0
2010-10-07	AAXJ	ETF	62.6	62.6	62.01	62.27	740100.0
2010-10-07	ACWI	ETF	44.64	44.64	44.0	44.17	334900.0
2010-10-07	ACWX	ETF	42.88	42.9	42.28	42.52	28149.0
2010-10-07	ADRE	ETF	46.61	46.61	45.54	45.8699	144179.0
2010-10-07	AFK	ETF	33.5	33.5	32.952	33.2	12148.0
2010-10-07	AGG	ETF	108.69	108.73	108.56	108.6	962900.0
2010-10-07	AGQ	ETF	191.36	191.46	176.64	177.3	620350.0
2010-10-07	AGZ	ETF	111.64	111.77	111.6	111.71	13750.0
2010-10-07	AIA	ETF	43.71	43.71	43.304	43.46	21473.0
2010-10-07	AIQ	ETF	24.55	24.55	24.3	24.3	11567.0
2010-10-07	AIS	ETF	1.49	1.505	1.45	1.49	244800.0
2010-10-07	AIVI	ETF	44.85	44.87	44.19	44.47	22100.0
2010-10-07	AMJ	ETF	34.57	34.71	34.26	34.71	367519.0
2010-10-07	AMLP	ETF	78.35	78.7	77.9	78.55	158200.0
2010-10-07	AOA	ETF	32.26	32.26	31.87	32.02	3200.0
2010-10-07	AOK	ETF	28.65	28.65	28.542	28.59	7916.0
2010-10-07	AOM	ETF	29.4454	29.4454	29.3105	29.34	5018.0
2010-10-07	AOR	ETF	30.3101	30.3699	30.2599	30.3	2054.0
2010-10-07	ARB	ETF	29.06	29.43	28.82	29.08	91255.0
2010-10-07	BAB	ETF	26.8	26.807	26.72	26.75	107377.0
2010-10-07	BAL	ETF	50.07	51.702	49.73	50.669	26678.0
2010-10-07	BALT	ETF	11.03	11.1	10.9	10.9	185627.0
2010-10-07	BBH	ETF	32.2967	32.47	32.1633	32.4367	32400.0
2010-10-07	BIB	ETF	6.4737	6.4737	6.4737	6.4737	800.0
2010-10-07	BICK	ETF	32.75	32.75	32.16	32.318	45742.0
2010-10-07	BIL	ETF	91.7	91.72	91.7	91.7	524750.0
2010-10-07	BIS	ETF	9656.0	9656.0	9526.4	9564.8	62.5
2010-10-07	BITS	ETF	27.44	27.84	27.16	27.56	2068.0
2010-10-07	BIV	ETF	87.37	87.39	87.23	87.33	113000.0
2010-10-07	BJK	ETF	29.23	29.23	28.65	28.87	13000.0
2010-10-07	BKF	ETF	49.21	49.3399	48.55	48.78	239337.0
2010-10-07	BLV	ETF	86.22	86.22	85.78	85.84	197800.0
2010-10-07	BMVP	ETF	13.2333	13.2768	13.1667	13.2067	7302.0
2010-10-07	BND	ETF	82.89	82.95	82.83	82.93	559800.0
2010-10-07	BNE	ETF	11.37	11.37	11.28	11.28	600976.0
2010-10-07	BNO	ETF	27.975	27.975	27.965	27.965	5600.0
2010-10-07	BRF	ETF	59.06	59.09	57.65	58.0	1026560.0
2010-10-07	BSCE	ETF	21.07	21.07	21.04	21.05	3700.0
2010-10-07	BSV	ETF	81.83	81.91	81.83	81.91	316800.0
2010-10-07	BTF	ETF	76.55	77.1	76.05	77.1	4495.8
2010-10-07	BWX	ETF	30.85	30.85	30.57	30.685	210044.0
2010-10-07	BWZ	ETF	37.79	37.79	37.44	37.44	116550.0
2010-10-07	BZQ	ETF	2569.6	2720.0	2568.0	2668.8	723.0

> showing 50 of 795 rows — these rows as CSV

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