PREVIEW / etf_daily / 2010-04-22

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-22.parquet
  size:    33 KB
  rows:    755

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-04-22	SPY	ETF	119.81	121.17	119.12	121.02	115360300.0
2010-04-22	QQQ	ETF	49.5697	50.36	49.26	50.31	110477115.0
2010-04-22	IWM	ETF	71.84	73.49	71.46	73.35	79289500.0
2010-04-22	DIA	ETF	110.61	111.51	110.15	111.35	9946100.0
2010-04-22	GLD	ETF	111.79	112.01	110.76	111.84	9598900.0
2010-04-22	TLT	ETF	90.9	91.09	90.33	90.43	2841400.0
2010-04-22	AAXJ	ETF	57.64	58.24	57.15	58.12	671400.0
2010-04-22	ACWI	ETF	44.17	44.61	43.85	44.54	413900.0
2010-04-22	ACWX	ETF	41.71	42.03	41.42	42.02	30046.0
2010-04-22	ADRE	ETF	44.15	44.7392	43.8486	44.73	88163.0
2010-04-22	AFK	ETF	32.04	32.21	31.55	32.21	59884.0
2010-04-22	AGG	ETF	104.55	104.65	104.29	104.37	221600.0
2010-04-22	AGQ	ETF	121.0	122.22	118.76	121.8	140000.0
2010-04-22	AGZ	ETF	108.34	108.34	108.0	108.1	15603.0
2010-04-22	AIA	ETF	40.95	41.42	40.6906	41.42	7764.0
2010-04-22	AIQ	ETF	28.5	28.55	28.1	28.4	15401.0
2010-04-22	AIS	ETF	1.6	1.6005	1.56	1.59	303481.0
2010-04-22	AIVI	ETF	43.02	43.3	42.72	43.28	14300.0
2010-04-22	AMJ	ETF	31.35	31.5	31.231	31.48	348853.0
2010-04-22	AOA	ETF	32.08	32.54	32.08	32.54	8900.0
2010-04-22	AOK	ETF	28.09	28.15	28.02	28.09	17730.0
2010-04-22	AOM	ETF	29.03	29.14	28.946	29.13	17501.0
2010-04-22	AOR	ETF	30.23	30.41	30.15	30.41	7671.0
2010-04-22	ARB	ETF	28.36	30.98	27.891	30.88	576775.0
2010-04-22	BAB	ETF	25.37	25.4	25.22	25.26	302546.0
2010-04-22	BAL	ETF	40.22	40.3	40.22	40.2399	3696.0
2010-04-22	BALT	ETF	13.9	14.18	13.7	13.9	543822.0
2010-04-22	BBH	ETF	32.8333	32.84	32.5667	32.5667	267000.0
2010-04-22	BIB	ETF	7.2687	7.2687	6.9988	7.16	32336.0
2010-04-22	BICK	ETF	29.74	30.06	29.55	30.06	21283.0
2010-04-22	BIL	ETF	91.68	91.7	91.68	91.68	28350.0
2010-04-22	BIS	ETF	9897.6	10236.8	9897.6	10019.2	62.5
2010-04-22	BITS	ETF	31.44	31.88	31.4004	31.88	75.0
2010-04-22	BIV	ETF	80.81	80.87	80.42	80.46	55500.0
2010-04-22	BJK	ETF	26.73	27.18	26.55	27.18	13600.0
2010-04-22	BKF	ETF	46.27	46.97	45.79	46.97	97801.0
2010-04-22	BLV	ETF	77.86	78.19	77.58	77.73	15900.0
2010-04-22	BMVP	ETF	13.62	13.8	13.57	13.79	40271.0
2010-04-22	BND	ETF	79.5	79.59	79.36	79.4	476400.0
2010-04-22	BNE	ETF	11.16	11.2	11.15	11.2	257988.0
2010-04-22	BRF	ETF	45.8	46.37	45.43	46.14	307374.0
2010-04-22	BSV	ETF	80.07	80.13	79.96	80.0	358800.0
2010-04-22	BTF	ETF	73.89999999999999	74.89999999999999	73.89999999999999	74.88699999999999	2232.0
2010-04-22	BWX	ETF	27.855	27.855	27.645	27.645	285802.0
2010-04-22	BWZ	ETF	35.3701	35.4399	35.29	35.29	27771.0
2010-04-22	BZQ	ETF	3668.8	3748.8	3571.2	3571.2	1146.0
2010-04-22	CEF	ETF	14.4	14.45	14.25	14.36	297500.0
2010-04-22	CEW	ETF	22.34	22.44	22.27	22.34	106429.0
2010-04-22	CGO	ETF	14.94	15.01	14.826	15.01	23898.0
2010-04-22	CGW	ETF	18.58	18.81	18.5025	18.75	71251.0

> showing 50 of 755 rows — these rows as CSV

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