PREVIEW / etf_daily / 2011-01-07

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-07.parquet
  size:    35 KB
  rows:    820

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-01-07	SPY	ETF	127.56	127.77	126.15	127.14	156034600.0
2011-01-07	QQQ	ETF	56.02	56.05	55.32	55.87	72261625.0
2011-01-07	IWM	ETF	79.24	79.44	77.44	78.52	59486800.0
2011-01-07	DIA	ETF	116.91	117.1	115.82	116.57	9249800.0
2011-01-07	GLD	ETF	133.38	134.61	133.18	133.58	16761400.0
2011-01-07	TLT	ETF	91.51	92.63	91.03	92.35	12694600.0
2011-01-07	AADR	ETF	29.74	29.74	29.67	29.67	1700.0
2011-01-07	AAXJ	ETF	64.2	64.2	63.43	63.83	790600.0
2011-01-07	ACWI	ETF	46.89	46.89	46.27	46.64	165400.0
2011-01-07	ACWX	ETF	43.79	43.82	43.26	43.52	52238.0
2011-01-07	ADRE	ETF	47.71	47.86	47.15	47.52	42018.0
2011-01-07	AFK	ETF	35.18	35.36	34.56	35.16	49949.0
2011-01-07	AGG	ETF	105.31	105.61	105.18	105.51	968500.0
2011-01-07	AGQ	ETF	276.64	285.0	270.42	273.9	605550.0
2011-01-07	AGZ	ETF	109.3799	109.6599	109.3	109.65	34405.0
2011-01-07	AIA	ETF	47.62	47.62	47.0	47.29	52147.0
2011-01-07	AIQ	ETF	22.1	22.1	21.05	21.4	14518.0
2011-01-07	AIS	ETF	1.74	1.74	1.7	1.74	250912.0
2011-01-07	AIVI	ETF	43.07	43.25	42.58	42.84	178500.0
2011-01-07	AMJ	ETF	36.47	36.7	36.3	36.395	478373.0
2011-01-07	AMLP	ETF	80.4	80.5	80.15	80.35	206860.0
2011-01-07	AOA	ETF	34.53	34.54	34.16	34.37	14900.0
2011-01-07	AOK	ETF	28.81	28.81	28.71	28.7648	12907.0
2011-01-07	AOM	ETF	29.91	29.97	29.83	29.9199	17807.0
2011-01-07	AOR	ETF	31.5399	31.57	31.3712	31.5	68299.0
2011-01-07	ARB	ETF	42.56	42.66	41.91	42.17	246065.0
2011-01-07	BAB	ETF	24.98	25.1	24.9201	25.05	327550.0
2011-01-07	BAL	ETF	71.53	72.039	71.0	71.31	25886.0
2011-01-07	BALT	ETF	10.95	11.07	10.75	10.88	179046.0
2011-01-07	BBH	ETF	34.01	34.1467	33.9033	34.0933	47100.0
2011-01-07	BIB	ETF	7.7577	7.7577	7.6675	7.6895	13552.0
2011-01-07	BICK	ETF	33.19	33.19	32.51	32.82	37889.0
2011-01-07	BIL	ETF	91.7	91.72	91.7	91.7	124600.0
2011-01-07	BITS	ETF	28.84	28.84	28.56	28.56	375.0
2011-01-07	BIV	ETF	82.34	82.86	82.31	82.73	110300.0
2011-01-07	BJK	ETF	32.29	32.68	32.22	32.52	20900.0
2011-01-07	BKF	ETF	49.58	49.68	48.9	49.17	126334.0
2011-01-07	BLV	ETF	77.87	78.68	77.7	78.45	23900.0
2011-01-07	BMVP	ETF	14.75	14.8	14.63	14.73	7884.0
2011-01-07	BND	ETF	80.0	80.3	79.94	80.2	847000.0
2011-01-07	BNO	ETF	31.295	31.295	31.135	31.135	19200.0
2011-01-07	BRF	ETF	57.55	57.63	56.74	56.97	247624.0
2011-01-07	BSCE	ETF	20.76	20.77	20.748	20.754	6146.0
2011-01-07	BSV	ETF	80.4	80.54	80.36	80.54	1839200.0
2011-01-07	BTF	ETF	78.0	78.2	77.5	77.5	2665.2000000000003
2011-01-07	BWX	ETF	28.465	28.54	28.355	28.36	368384.0
2011-01-07	BWZ	ETF	36.18	36.47	36.17	36.36	23322.0
2011-01-07	BZQ	ETF	2425.6	2512.0	2420.8	2483.2	250.0
2011-01-07	CEF	ETF	19.28	19.38	19.02	19.11	1769100.0
2011-01-07	CEW	ETF	22.26	22.31	22.2	22.25	112421.0

> showing 50 of 820 rows — these rows as CSV

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