PREVIEW / etf_daily / 2010-08-25

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-25.parquet
  size:    33 KB
  rows:    771

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-25	SPY	ETF	104.95	106.34	104.29	105.94	272234800.0
2010-08-25	QQQ	ETF	43.35	44.26	43.27	44.07	87347880.0
2010-08-25	IWM	ETF	59.14	60.68	58.89	60.53	64025300.0
2010-08-25	DIA	ETF	99.91	100.98	99.37	100.61	9732500.0
2010-08-25	GLD	ETF	121.12	121.38	120.67	121.36	13987100.0
2010-08-25	TLT	ETF	108.8	109.34	107.07	107.41	13299800.0
2010-08-25	AADR	ETF	24.85	24.87	24.85	24.87	700.0
2010-08-25	AAXJ	ETF	54.16	54.68	53.8	54.51	429700.0
2010-08-25	ACWI	ETF	39.1	39.29	38.75	39.25	886800.0
2010-08-25	ACWX	ETF	37.02	37.42	36.77	37.35	176336.0
2010-08-25	ADRE	ETF	40.51	40.83	40.09	40.72	235869.0
2010-08-25	AFK	ETF	29.45	29.634	29.3	29.47	37941.0
2010-08-25	AGG	ETF	108.96	109.09	108.55	108.59	486000.0
2010-08-25	AGQ	ETF	124.66	128.7	123.94	127.18	345400.0
2010-08-25	AGZ	ETF	111.4	111.4	111.1435	111.22	12606.0
2010-08-25	AIA	ETF	38.57	38.76	38.33	38.744	41877.0
2010-08-25	AIQ	ETF	22.05	22.75	22.05	22.65	30513.0
2010-08-25	AIS	ETF	1.5	1.51	1.47	1.51	461310.0
2010-08-25	AIVI	ETF	38.41	38.81	38.26	38.76	9400.0
2010-08-25	AMJ	ETF	32.07	32.2	31.63	31.93	1507391.0
2010-08-25	AMLP	ETF	75.75	76.55	74.55	74.9	185758.0
2010-08-25	AOA	ETF	28.64	28.83	28.44	28.83	7700.0
2010-08-25	AOK	ETF	27.6164	27.69	27.58	27.68	5810.0
2010-08-25	AOM	ETF	27.91	28.082	27.91	28.043	6364.0
2010-08-25	AOR	ETF	28.25	28.43	28.24	28.43	5070.0
2010-08-25	ARB	ETF	24.17	24.46	24.04	24.17	211154.0
2010-08-25	BAB	ETF	27.0	27.08	26.8	26.82	263628.0
2010-08-25	BAL	ETF	41.35	41.7185	41.32	41.32	26158.0
2010-08-25	BALT	ETF	10.74	11.22	10.62	11.21	136357.0
2010-08-25	BBH	ETF	29.5467	30.2967	29.46	30.2433	63600.0
2010-08-25	BIB	ETF	5.2862	5.3463	5.2337	5.3463	38400.0
2010-08-25	BICK	ETF	27.87	27.91	27.71	27.84	22062.0
2010-08-25	BIL	ETF	91.72	91.72	91.7	91.72	615100.0
2010-08-25	BIS	ETF	12144.0	12144.0	11889.6	11889.6	10.0
2010-08-25	BITS	ETF	24.4	24.4	24.2	24.4	1125.0
2010-08-25	BIV	ETF	86.76	86.79	86.2	86.27	125700.0
2010-08-25	BJK	ETF	24.8	25.23	24.79	25.23	38300.0
2010-08-25	BKF	ETF	42.65	42.99	42.26	42.97	146647.0
2010-08-25	BLV	ETF	88.1	88.13	86.88	87.0	57300.0
2010-08-25	BMVP	ETF	11.85	12.032	11.813	12.008	20249.0
2010-08-25	BND	ETF	82.87	82.98	82.61	82.69	1040100.0
2010-08-25	BNE	ETF	11.11	11.16	11.11	11.15	275289.0
2010-08-25	BNO	ETF	24.355	24.765	24.34	24.765	44000.0
2010-08-25	BRF	ETF	50.06	50.56	49.79	50.27	320137.0
2010-08-25	BSCE	ETF	20.88	20.88	20.8632	20.874	2817.0
2010-08-25	BSV	ETF	81.71	81.74	81.57	81.61	457000.0
2010-08-25	BTF	ETF	68.2	68.75	67.69999999999999	68.6	6311.8
2010-08-25	BWX	ETF	28.82	28.9195	28.63	28.78	245796.0
2010-08-25	BWZ	ETF	34.99	35.05	34.85	34.988	16109.0
2010-08-25	BZQ	ETF	3680.0	3768.0	3644.8	3665.6	1921.0

> showing 50 of 771 rows — these rows as CSV

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