PREVIEW / etf_daily / 2011-12-12

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-12.parquet
  size:    37 KB
  rows:    890

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
2011-12-12	SPY	ETF	124.95	124.97	123.16	124.21	215826100.0
2011-12-12	QQQ	ETF	56.42	57.0087	55.9	56.38	55411692.0
2011-12-12	IWM	ETF	73.49	74.6	72.5	73.47	47638600.0
2011-12-12	DIA	ETF	120.91	120.96	119.38	120.24	6291500.0
2011-12-12	GLD	ETF	162.35	162.41	161.14	161.99	15339400.0
2011-12-12	TLT	ETF	117.91	118.49	117.61	118.01	5734600.0
2011-12-12	AADR	ETF	28.42	28.42	27.77	27.96	1300.0
2011-12-12	AAXJ	ETF	50.25	50.43	49.59	50.0	914000.0
2011-12-12	ACTV	ETF	12.49	12.98	12.49	12.88	179498.0
2011-12-12	ACWI	ETF	42.4	42.4	41.82	42.15	812500.0
2011-12-12	ACWV	ETF	50.8	50.8	49.93	49.93	2800.0
2011-12-12	ACWX	ETF	37.26	37.27	36.754	37.0	249873.0
2011-12-12	ADRE	ETF	38.94	39.05	38.394	38.77	40959.0
2011-12-12	AFK	ETF	26.47	26.5	26.16	26.28	24347.0
2011-12-12	AGEM	ETF	20.95	20.95	20.7816	20.86	3786.0
2011-12-12	AGG	ETF	109.47	109.63	109.41	109.42	1220900.0
2011-12-12	AGQ	ETF	217.16	219.32	212.84	219.2	560825.0
2011-12-12	AGZ	ETF	112.5712	112.7055	112.31	112.34	38916.0
2011-12-12	AIA	ETF	39.92	39.92	39.33	39.57	32579.0
2011-12-12	AIQ	ETF	5.5	5.995	5.35	5.8	23903.0
2011-12-12	AIS	ETF	2.62	2.74	2.6	2.73	1745113.0
2011-12-12	AIVI	ETF	39.78	39.78	39.1	39.35	84500.0
2011-12-12	AMJ	ETF	37.37	37.41	37.1203	37.35	491305.0
2011-12-12	AMLP	ETF	80.75	81.05	80.4	80.8	176040.0
2011-12-12	AOA	ETF	32.76	32.84	32.63	32.83	22000.0
2011-12-12	AOK	ETF	29.27	29.27	29.17	29.24	77600.0
2011-12-12	AOM	ETF	29.87	31.31	29.42	29.81	242454.0
2011-12-12	AOR	ETF	31.13	31.13	30.891	31.039	74084.0
2011-12-12	ARB	ETF	36.5	37.01	35.91	36.95	153909.0
2011-12-12	ASEA	ETF	14.56	14.63	14.46	14.58	15700.0
2011-12-12	AWAY	ETF	24.94	25.225	24.0	24.41	348101.0
2011-12-12	BAB	ETF	28.48	28.5	28.3181	28.36	130375.0
2011-12-12	BAL	ETF	55.04	55.04	53.8101	54.02	67973.0
2011-12-12	BALT	ETF	4.99	5.05	4.88	4.97	85057.0
2011-12-12	BBH	ETF	34.54	34.7467	34.09	34.43	100500.0
2011-12-12	BCM	ETF	43.03	43.319	43.01	43.289	5048.0
2011-12-12	BIB	ETF	8.1237	8.1237	7.9638	7.98	13720.0
2011-12-12	BICK	ETF	23.69	23.81	23.43	23.52	10963.0
2011-12-12	BIL	ETF	91.66	91.68	91.66	91.66	11094100.0
2011-12-12	BIS	ETF	5670.4	5736.0	5670.4	5720.0	13.05
2011-12-12	BITS	ETF	21.4	21.56	21.24	21.4	5691.0
2011-12-12	BIV	ETF	87.08	87.31	87.07	87.18	202000.0
2011-12-12	BJK	ETF	30.13	30.23	29.92	30.04	12000.0
2011-12-12	BKF	ETF	36.77	36.77	36.11	36.44	113519.0
2011-12-12	BKLN	ETF	23.85	23.9	23.73	23.9	62400.0
2011-12-12	BLV	ETF	90.32	90.46	90.08	90.19	21300.0
2011-12-12	BMVP	ETF	13.383	13.43	13.352	13.43	4527.0
2011-12-12	BND	ETF	83.52	83.59	83.47	83.49	841400.0
2011-12-12	BNO	ETF	37.27	37.395	37.155	37.24	36000.0
2011-12-12	BOIL	ETF	2464000.0	2485000.0	2444000.0	2476000.0	0.4

> showing 50 of 890 rows — these rows as CSV

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