PREVIEW / etf_daily / 2010-05-12

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-12.parquet
  size:    33 KB
  rows:    757

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-05-12	SPY	ETF	116.29	117.62	116.09	117.45	235607100.0
2010-05-12	QQQ	ETF	47.98	48.66	47.9	48.62	85462326.0
2010-05-12	IWM	ETF	69.85	71.7	69.79	71.62	84618400.0
2010-05-12	DIA	ETF	108.08	109.35	107.95	109.26	12985000.0
2010-05-12	GLD	ETF	121.28	122.24	120.77	121.4	32703600.0
2010-05-12	TLT	ETF	93.14	93.26	92.61	92.65	5530800.0
2010-05-12	AAXJ	ETF	55.69	55.69	54.73	55.29	838900.0
2010-05-12	ACWI	ETF	41.62	42.29	41.62	42.29	158800.0
2010-05-12	ACWX	ETF	39.29	39.44	38.8	39.31	35796.0
2010-05-12	ADRE	ETF	42.32	42.375	42.06	42.28	365317.0
2010-05-12	AFK	ETF	30.5	31.35	30.5	31.302	12882.0
2010-05-12	AGG	ETF	104.67	104.79	104.57	104.68	426600.0
2010-05-12	AGQ	ETF	141.2	143.86	140.72	141.06	302900.0
2010-05-12	AGZ	ETF	108.59	108.7	108.51	108.65	10645.0
2010-05-12	AIA	ETF	39.0	39.3	39.0	39.25	91810.0
2010-05-12	AIQ	ETF	27.45	28.8	27.45	28.2	23940.0
2010-05-12	AIS	ETF	1.68	1.68	1.62	1.68	554940.0
2010-05-12	AIVI	ETF	39.99	40.34	39.99	40.16	54200.0
2010-05-12	AMJ	ETF	30.52	30.82	30.11	30.8	470408.0
2010-05-12	AOA	ETF	31.09	31.35	31.09	31.32	5500.0
2010-05-12	AOK	ETF	27.929	28.01	27.929	28.01	9950.0
2010-05-12	AOM	ETF	28.63	28.73	28.63	28.71	131680.0
2010-05-12	AOR	ETF	29.57	29.76	29.532	29.75	29950.0
2010-05-12	ARB	ETF	31.84	32.75	31.68	32.64	148144.0
2010-05-12	BAB	ETF	25.84	25.89	25.77	25.78	132565.0
2010-05-12	BAL	ETF	38.55	38.76	38.02	38.0201	1348.0
2010-05-12	BALT	ETF	13.3	13.36	12.89	13.33	314871.0
2010-05-12	BBH	ETF	31.5933	32.07	31.4733	32.05	106200.0
2010-05-12	BIB	ETF	6.5663	6.7812	6.5663	6.7812	3200.0
2010-05-12	BICK	ETF	28.37	28.88	27.22	28.86	28049.0
2010-05-12	BIL	ETF	91.72	91.72	91.7	91.72	209450.0
2010-05-12	BIS	ETF	10326.4	10326.4	10326.4	10326.4	1.875
2010-05-12	BITS	ETF	31.16	31.2	30.72	31.16	575.0
2010-05-12	BIV	ETF	81.24	81.32	81.06	81.23	87800.0
2010-05-12	BJK	ETF	25.66	25.83	25.62	25.73	7300.0
2010-05-12	BKF	ETF	43.69	43.9375	43.442	43.73	250025.0
2010-05-12	BLV	ETF	78.58	78.77	78.25	78.34	29400.0
2010-05-12	BMVP	ETF	13.11	13.36	13.11	13.36	42416.0
2010-05-12	BND	ETF	79.91	79.94	79.69	79.7	2226900.0
2010-05-12	BNE	ETF	11.21	11.21	11.06	11.16	1895145.0
2010-05-12	BRF	ETF	44.08	44.6199	44.0545	44.38	213120.0
2010-05-12	BSV	ETF	80.26	80.27	80.19	80.24	262300.0
2010-05-12	BTF	ETF	70.0	70.5525	69.95	70.3	4526.8
2010-05-12	BWX	ETF	27.05	27.05	26.735	26.845	364854.0
2010-05-12	BWZ	ETF	34.21	34.379	34.13	34.15	81673.0
2010-05-12	BZQ	ETF	3907.2	3948.8	3840.0	3924.8	1266.0
2010-05-12	CEF	ETF	15.43	15.43	15.17	15.25	3824300.0
2010-05-12	CEW	ETF	21.97	22.0	21.93	21.99	61271.0
2010-05-12	CGO	ETF	13.74	13.9	13.73	13.83	38583.0
2010-05-12	CGW	ETF	17.85	18.0	17.71	17.93	62230.0

> showing 50 of 757 rows — these rows as CSV

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