PREVIEW / etf_daily / 2010-10-22

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-22.parquet
  size:    34 KB
  rows:    789

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-22	SPY	ETF	118.31	118.53	118.0	118.35	108212400.0
2010-10-22	QQQ	ETF	51.3	51.69	51.21	51.64	47409146.0
2010-10-22	IWM	ETF	70.04	70.39	69.76	70.32	26267800.0
2010-10-22	DIA	ETF	111.59	111.68	111.15	111.36	3549800.0
2010-10-22	GLD	ETF	129.47	129.75	128.97	129.73	11885300.0
2010-10-22	TLT	ETF	100.44	101.47	100.41	101.38	4770700.0
2010-10-22	AADR	ETF	29.0	29.5	29.0	29.5	500.0
2010-10-22	AAXJ	ETF	62.69	62.7	62.44	62.55	319400.0
2010-10-22	ACWI	ETF	44.82	44.91	44.75	44.91	62700.0
2010-10-22	ACWX	ETF	43.07	43.07	42.8	42.94	40478.0
2010-10-22	ADRE	ETF	45.94	46.09	45.66	45.79	73285.0
2010-10-22	AFK	ETF	33.61	33.61	33.29	33.47	35231.0
2010-10-22	AGG	ETF	108.45	108.57	108.41	108.5	551400.0
2010-10-22	AGQ	ETF	186.4	187.64	184.38	187.64	192000.0
2010-10-22	AGZ	ETF	111.68	111.681	111.61	111.67	5769.0
2010-10-22	AIA	ETF	43.76	43.869	43.726	43.82	11015.0
2010-10-22	AIQ	ETF	21.2	21.35	20.9	21.35	23746.0
2010-10-22	AIS	ETF	1.44	1.46	1.41	1.42	268318.0
2010-10-22	AIVI	ETF	45.31	45.31	45.09	45.25	8400.0
2010-10-22	AMJ	ETF	34.95	34.98	34.8401	34.935	693835.0
2010-10-22	AMLP	ETF	79.05	79.15	78.85	78.95	65760.0
2010-10-22	AOA	ETF	32.6	32.6	32.54	32.6	6200.0
2010-10-22	AOK	ETF	28.72	28.8	28.72	28.79	11871.0
2010-10-22	AOM	ETF	29.6	29.65	29.6	29.65	4755.0
2010-10-22	AOR	ETF	30.69	30.73	30.681	30.69	4339.0
2010-10-22	ARB	ETF	30.02	30.46	29.83	30.29	211816.0
2010-10-22	BAB	ETF	26.21	26.34	26.17	26.34	122214.0
2010-10-22	BAL	ETF	56.95	59.51	56.95	59.28	64525.0
2010-10-22	BALT	ETF	11.35	11.35	11.08	11.11	118980.0
2010-10-22	BBH	ETF	33.24	33.43	33.2367	33.4067	11400.0
2010-10-22	BIB	ETF	6.69	6.69	6.69	6.69	1600.0
2010-10-22	BICK	ETF	32.89	32.89	32.4501	32.51	29101.0
2010-10-22	BIL	ETF	91.72	91.72	91.7	91.72	114950.0
2010-10-22	BIS	ETF	9270.4	9275.2	9270.4	9275.2	12.2
2010-10-22	BITS	ETF	26.64	27.16	26.6	26.92	2817.0
2010-10-22	BIV	ETF	86.88	86.95	86.77	86.92	119100.0
2010-10-22	BJK	ETF	29.88	30.16	29.88	30.07	17100.0
2010-10-22	BKF	ETF	49.37	49.64	49.04	49.24	99280.0
2010-10-22	BLV	ETF	83.71	84.08	83.52	83.95	37900.0
2010-10-22	BMVP	ETF	13.57	13.61	13.57	13.59	11437.0
2010-10-22	BND	ETF	82.64	82.73	82.61	82.62	524400.0
2010-10-22	BNE	ETF	11.35	11.36	11.24	11.25	1003393.0
2010-10-22	BRF	ETF	59.2	59.29	58.17	58.33	324115.0
2010-10-22	BSCE	ETF	21.06	21.06	21.05	21.054	3559.0
2010-10-22	BSV	ETF	81.9	81.93	81.86	81.9	364500.0
2010-10-22	BTF	ETF	78.05	78.35	77.75	77.955	3656.0
2010-10-22	BWX	ETF	30.495	30.6525	30.465	30.57	158538.0
2010-10-22	BWZ	ETF	37.47	37.66	37.427	37.451	20162.0
2010-10-22	BZQ	ETF	2660.8	2784.0	2652.8	2760.0	907.5
2010-10-22	CEF	ETF	17.04	17.17	16.89	17.01	1220200.0

> showing 50 of 789 rows — these rows as CSV

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