PREVIEW / etf_daily / 2012-01-06

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-06.parquet
  size:    37 KB
  rows:    891

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-06	SPY	ETF	128.2	128.22	127.29	127.71	148050000.0
2012-01-06	QQQ	ETF	57.65	57.94	57.4	57.81	46325172.0
2012-01-06	IWM	ETF	75.02	75.38	74.27	74.79	45499800.0
2012-01-06	DIA	ETF	124.08	124.08	123.14	123.53	7488600.0
2012-01-06	GLD	ETF	158.59	158.63	156.38	157.2	9790500.0
2012-01-06	TLT	ETF	117.75	118.96	117.71	118.73	7348500.0
2012-01-06	AADR	ETF	28.01	28.05	27.95	27.95	5800.0
2012-01-06	AAXJ	ETF	50.6	50.68	50.25	50.42	353700.0
2012-01-06	ACTV	ETF	13.23	13.41	13.14	13.27	83248.0
2012-01-06	ACWI	ETF	42.78	42.78	42.36	42.47	611800.0
2012-01-06	ACWX	ETF	36.95	36.95	36.55	36.57	192455.0
2012-01-06	ADRE	ETF	39.34	39.4	38.971	39.02	13406.0
2012-01-06	AFK	ETF	26.01	26.05	25.95	25.98	12371.0
2012-01-06	AGEM	ETF	21.19	21.19	21.047	21.047	316.0
2012-01-06	AGG	ETF	110.03	110.25	110.02	110.12	897900.0
2012-01-06	AGQ	ETF	187.68	187.88	177.68	178.6	399575.0
2012-01-06	AGZ	ETF	112.9893	113.06	112.5901	112.66	6511.0
2012-01-06	AIA	ETF	39.4	39.602	39.4	39.58	20197.0
2012-01-06	AIQ	ETF	5.7	5.8	5.6	5.65	10176.0
2012-01-06	AIS	ETF	2.04	2.16	2.04	2.08	518523.0
2012-01-06	AIVI	ETF	39.47	39.47	38.98	39.0	98800.0
2012-01-06	AMJ	ETF	39.76	39.825	38.69	39.37	1930432.0
2012-01-06	AMLP	ETF	84.25	84.35	82.45	83.6	541660.0
2012-01-06	AOA	ETF	33.43	33.5	33.22	33.4	4700.0
2012-01-06	AOK	ETF	29.39	29.44	29.3705	29.41	80927.0
2012-01-06	AOM	ETF	30.0	30.02	29.92	29.99	14767.0
2012-01-06	AOR	ETF	31.26	31.41	31.26	31.34	6703.0
2012-01-06	ARB	ETF	36.37	36.37	35.19	35.56	260567.0
2012-01-06	ARGT	ETF	22.26	22.26	22.1	22.1	200.0
2012-01-06	ASEA	ETF	14.65	14.69	14.54	14.59	21900.0
2012-01-06	AWAY	ETF	23.91	24.55	23.42	24.39	183272.0
2012-01-06	BAB	ETF	28.41	28.61	28.3989	28.58	135707.0
2012-01-06	BAL	ETF	58.78	59.61	58.78	59.23	32091.0
2012-01-06	BALT	ETF	4.46	4.49	4.26	4.31	121371.0
2012-01-06	BBH	ETF	38.0233	38.0933	37.9667	38.0367	6600.0
2012-01-06	BCM	ETF	43.85	43.86	43.85	43.86	1126.0
2012-01-06	BIB	ETF	9.1125	9.2119	9.0125	9.1387	206672.0
2012-01-06	BICK	ETF	23.34	23.34	23.1499	23.1499	1689.0
2012-01-06	BIL	ETF	91.64	91.66	91.64	91.64	476800.0
2012-01-06	BIS	ETF	5092.8	5092.8	4956.8	4987.2	21.85
2012-01-06	BITS	ETF	23.0	23.0	22.72	22.8	1775.0
2012-01-06	BIV	ETF	86.86	87.04	86.79	86.96	232100.0
2012-01-06	BJK	ETF	30.18	30.18	29.99	30.01	14400.0
2012-01-06	BKF	ETF	37.28	37.34	36.9	36.98	38146.0
2012-01-06	BKLN	ETF	24.05	24.07	24.02	24.07	114200.0
2012-01-06	BLV	ETF	90.7	91.23	90.7	91.23	44100.0
2012-01-06	BMVP	ETF	13.87	13.88	13.81	13.85	6184.0
2012-01-06	BND	ETF	83.31	83.45	83.29	83.34	1053000.0
2012-01-06	BNO	ETF	39.29	39.425	38.95	39.425	224400.0
2012-01-06	BOIL	ETF	2074000.0	2161000.0	2046000.0	2156000.0	0.2

> showing 50 of 891 rows — these rows as CSV

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