PREVIEW / etf_daily / 2012-01-04

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-04.parquet
  size:    37 KB
  rows:    897

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
2012-01-04	SPY	ETF	127.2	127.81	126.71	127.7	127186500.0
2012-01-04	QQQ	ETF	56.8	57.22	56.56	57.14	29403365.0
2012-01-04	IWM	ETF	74.58	74.86	74.07	74.56	34648500.0
2012-01-04	DIA	ETF	123.4	124.05	123.11	123.97	7625200.0
2012-01-04	GLD	ETF	155.43	157.38	155.34	156.71	11549700.0
2012-01-04	TLT	ETF	119.26	119.28	117.68	118.01	8417100.0
2012-01-04	AADR	ETF	28.58	28.73	28.58	28.65	500.0
2012-01-04	AAXJ	ETF	50.74	50.97	50.53	50.87	314500.0
2012-01-04	ACTV	ETF	13.34	13.35	13.09	13.19	159395.0
2012-01-04	ACWI	ETF	42.94	43.02	42.65	42.97	717100.0
2012-01-04	ACWV	ETF	51.37	51.37	51.37	51.37	200.0
2012-01-04	ACWX	ETF	37.49	37.57	37.27	37.49	383999.0
2012-01-04	ADRE	ETF	39.1	39.46	39.07	39.4	23514.0
2012-01-04	AFK	ETF	26.05	26.28	25.89	26.11	8324.0
2012-01-04	AGEM	ETF	21.15	21.22	21.15	21.22	850.0
2012-01-04	AGG	ETF	110.07	110.07	109.77	109.88	1299200.0
2012-01-04	AGQ	ETF	185.4	189.76	183.6	185.12	525675.0
2012-01-04	AGZ	ETF	112.86	112.96	112.4847	112.77	28681.0
2012-01-04	AIA	ETF	39.92	40.11	39.84	40.04	8308.0
2012-01-04	AIQ	ETF	6.2	6.2	5.7	5.75	9606.0
2012-01-04	AIS	ETF	2.15	2.18	2.05	2.05	677681.0
2012-01-04	AIVI	ETF	40.31	40.39	40.02	40.35	43500.0
2012-01-04	AMJ	ETF	39.07	39.51	38.8	39.49	978026.0
2012-01-04	AMLP	ETF	83.3	83.75	83.2	83.75	332880.0
2012-01-04	AOA	ETF	33.41	33.47	33.28	33.47	12400.0
2012-01-04	AOK	ETF	29.366	29.41	29.35	29.41	18247.0
2012-01-04	AOM	ETF	30.02	30.06	29.935	30.06	96203.0
2012-01-04	AOR	ETF	31.35	31.4	31.3	31.39	49484.0
2012-01-04	ARB	ETF	36.26	37.26	35.8	37.2	257769.0
2012-01-04	ARGT	ETF	21.94	22.26	21.94	22.26	3400.0
2012-01-04	ASEA	ETF	14.71	14.75	14.6	14.72	4500.0
2012-01-04	AWAY	ETF	23.94	24.39	23.69	23.93	230651.0
2012-01-04	BAB	ETF	28.57	28.57	28.28	28.31	275660.0
2012-01-04	BAL	ETF	59.6	59.65	58.8728	59.27	10892.0
2012-01-04	BALT	ETF	4.63	4.636	4.48	4.55	83756.0
2012-01-04	BBH	ETF	36.8233	36.88	36.77	36.8167	18600.0
2012-01-04	BCM	ETF	44.1	44.25	44.1	44.25	2826.0
2012-01-04	BIB	ETF	8.8075	8.81	8.7833	8.8038	11040.0
2012-01-04	BICK	ETF	23.33	23.59	23.33	23.534	6073.0
2012-01-04	BIL	ETF	91.66	91.66	91.64	91.64	443250.0
2012-01-04	BIS	ETF	5169.6	5204.8	5168.0	5204.8	8.75
2012-01-04	BITS	ETF	22.8	22.88	22.56	22.56	804.0
2012-01-04	BIV	ETF	86.92	86.95	86.55	86.69	200100.0
2012-01-04	BJK	ETF	30.72	30.82	30.57	30.73	12200.0
2012-01-04	BKF	ETF	37.29	37.57	37.18	37.51	172752.0
2012-01-04	BKLN	ETF	23.95	23.99	23.92	23.99	109300.0
2012-01-04	BLV	ETF	91.22	91.23	90.5	90.65	45400.0
2012-01-04	BMVP	ETF	13.8	13.81	13.75	13.8	3465.0
2012-01-04	BND	ETF	83.32	83.36	83.21	83.32	2227400.0
2012-01-04	BNO	ETF	38.89	39.52	38.89	39.48	310000.0

> showing 50 of 897 rows — these rows as CSV

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