PREVIEW / etf_daily / 2013-01-04

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-04.parquet
  size:    40 KB
  rows:    977

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
2013-01-04	SPY	ETF	145.97	146.61	145.67	146.37	116817700.0
2013-01-04	QQQ	ETF	66.87	66.88	66.47	66.63	33973326.0
2013-01-04	IWM	ETF	87.01	87.44	86.66	87.24	29852500.0
2013-01-04	DIA	ETF	133.7	134.2	133.49	134.06	4759300.0
2013-01-04	GLD	ETF	159.52	160.63	158.89	160.44	19179800.0
2013-01-04	TLT	ETF	117.66	118.44	117.36	118.4	9574600.0
2013-01-04	AADR	ETF	31.49	31.7	31.49	31.55	2600.0
2013-01-04	AAXJ	ETF	61.06	61.33	60.95	61.29	296400.0
2013-01-04	ACTV	ETF	5.27	5.63	5.22	5.6	454771.0
2013-01-04	ACWI	ETF	48.84	49.1	48.75	49.04	1400200.0
2013-01-04	ACWV	ETF	56.49	56.74	56.49	56.69	45700.0
2013-01-04	ACWX	ETF	42.24	42.52	42.15	42.49	297133.0
2013-01-04	ADRE	ETF	41.0	41.289	40.95	41.263	63576.0
2013-01-04	AFK	ETF	31.58	31.655	31.42	31.655	34574.0
2013-01-04	AGEM	ETF	23.81	23.96	23.81	23.92	2200.0
2013-01-04	AGG	ETF	110.59	110.8	110.55	110.79	1286800.0
2013-01-04	AGQ	ETF	169.28	174.6	166.72	173.96	440750.0
2013-01-04	AGZ	ETF	113.14	113.15	112.9801	113.14	11531.0
2013-01-04	AIA	ETF	48.46	48.6372	48.3248	48.6149	20742.0
2013-01-04	AIQ	ETF	6.62	6.65	6.47	6.63	9996.0
2013-01-04	AIVI	ETF	41.93	42.33	41.92	42.31	25500.0
2013-01-04	AMJ	ETF	40.36	40.64	40.28	40.46	844147.0
2013-01-04	AMLP	ETF	82.25	82.85	82.2	82.85	542880.0
2013-01-04	ANGL	ETF	26.9	27.04	26.9	27.01	1700.0
2013-01-04	AOA	ETF	37.81	37.97	37.79	37.93	10800.0
2013-01-04	AOK	ETF	30.69	30.74	30.66	30.74	40683.0
2013-01-04	AOM	ETF	31.9075	32.01	31.9075	32.0	27465.0
2013-01-04	AOR	ETF	34.29	34.4395	34.25	34.43	112339.0
2013-01-04	ARB	ETF	46.7	46.74	46.65	46.69	414967.0
2013-01-04	ARGT	ETF	17.8	17.92	17.8	17.86	400.0
2013-01-04	ASEA	ETF	17.2	17.3	17.11	17.22	17200.0
2013-01-04	AWAY	ETF	22.23	23.46	22.23	23.4	620455.0
2013-01-04	BAB	ETF	30.02	30.02	29.9	29.96	347365.0
2013-01-04	BAL	ETF	48.48	49.049	48.1	49.0042	55111.0
2013-01-04	BALT	ETF	3.2	3.32	3.1501	3.27	129689.0
2013-01-04	BBH	ETF	55.3	55.74	55.21	55.47	34600.0
2013-01-04	BCM	ETF	43.68	43.68	43.4101	43.67	24139.0
2013-01-04	BIB	ETF	15.53	15.75	15.53	15.6375	37668.0
2013-01-04	BICK	ETF	25.93	25.93	25.7116	25.8563	2071.0
2013-01-04	BIL	ETF	91.62	91.64	91.62	91.64	192700.0
2013-01-04	BIS	ETF	2480.0	2480.0	2443.6	2443.6	46.4
2013-01-04	BIV	ETF	87.72	87.85	87.67	87.81	309200.0
2013-01-04	BJK	ETF	36.94	37.39	36.94	37.37	2400.0
2013-01-04	BKF	ETF	41.72	42.01	41.61	41.99	111397.0
2013-01-04	BKLN	ETF	25.03	25.06	25.03	25.06	986100.0
2013-01-04	BLNG	ETF	49.5	49.5	48.74	48.74	537.0
2013-01-04	BLV	ETF	91.95	92.46	91.76	92.46	53000.0
2013-01-04	BMVP	ETF	16.677	16.803	16.677	16.78	17892.0
2013-01-04	BND	ETF	83.61	83.78	83.58	83.78	1822700.0
2013-01-04	BNO	ETF	41.05	41.335	40.875	41.045	16200.0

> showing 50 of 977 rows — these rows as CSV

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