PREVIEW / etf_daily / 2013-01-09

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-09.parquet
  size:    40 KB
  rows:    962

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-09	SPY	ETF	145.87	146.32	145.64	145.92	90745600.0
2013-01-09	QQQ	ETF	66.62	66.95	66.55	66.77	25609172.0
2013-01-09	IWM	ETF	87.02	87.35	86.96	87.27	27425500.0
2013-01-09	DIA	ETF	133.4	133.98	133.4	133.71	3898000.0
2013-01-09	GLD	ETF	160.77	160.83	159.9	160.49	8334200.0
2013-01-09	TLT	ETF	119.25	119.54	118.87	119.12	3870300.0
2013-01-09	AADR	ETF	31.84	31.84	31.49	31.66	15500.0
2013-01-09	AAXJ	ETF	60.71	60.84	60.57	60.76	553300.0
2013-01-09	ACTV	ETF	5.32	5.45	5.25	5.41	422850.0
2013-01-09	ACWI	ETF	48.76	48.87	48.7	48.77	407500.0
2013-01-09	ACWV	ETF	56.58	56.9	56.37	56.55	52300.0
2013-01-09	ACWX	ETF	42.17	42.23	42.05	42.19	155958.0
2013-01-09	ADRE	ETF	40.54	40.81	40.54	40.75	13331.0
2013-01-09	AFK	ETF	31.7	31.74	31.4701	31.6077	29739.0
2013-01-09	AGEM	ETF	23.47	23.5623	23.0	23.5243	21164.0
2013-01-09	AGG	ETF	110.85	110.85	110.71	110.75	1346900.0
2013-01-09	AGQ	ETF	175.2	175.84	172.24	175.4	174050.0
2013-01-09	AGZ	ETF	113.2192	113.3599	113.2055	113.34	8467.0
2013-01-09	AIA	ETF	47.88	48.12	47.88	48.0	17429.0
2013-01-09	AIQ	ETF	6.62	6.69	6.62	6.64	5490.0
2013-01-09	AIVI	ETF	41.82	42.02	41.82	41.96	34600.0
2013-01-09	AMJ	ETF	40.63	40.93	40.63	40.9	706675.0
2013-01-09	AMLP	ETF	82.7	83.1	82.55	83.1	735900.0
2013-01-09	ANGL	ETF	27.23	27.4	27.23	27.4	2900.0
2013-01-09	AOA	ETF	37.81	37.9	37.79	37.85	17400.0
2013-01-09	AOK	ETF	30.69	30.73	30.69	30.69	36681.0
2013-01-09	AOM	ETF	31.97	31.9899	31.96	31.98	19156.0
2013-01-09	AOR	ETF	34.4	34.4	34.3101	34.36	31837.0
2013-01-09	ARB	ETF	46.8	46.84	46.69	46.84	443775.0
2013-01-09	ARGT	ETF	18.0	18.22	18.0	18.12	7450.0
2013-01-09	ASEA	ETF	17.07	17.07	16.98	17.01	12500.0
2013-01-09	AWAY	ETF	22.71	23.01	22.38	22.94	482110.0
2013-01-09	BAB	ETF	30.18	30.23	30.1243	30.18	115046.0
2013-01-09	BAL	ETF	48.9672	49.15	48.77	48.89	8316.0
2013-01-09	BALT	ETF	3.36	3.433	3.32	3.34	74019.0
2013-01-09	BBH	ETF	56.41	57.06	56.16	56.96	71200.0
2013-01-09	BCM	ETF	43.6616	43.78	43.6616	43.725	2806.0
2013-01-09	BIB	ETF	16.1975	16.465	16.0675	16.4585	80488.0
2013-01-09	BICK	ETF	25.54	25.6799	25.54	25.67	2072.0
2013-01-09	BIL	ETF	91.6	91.62	91.6	91.6	197400.0
2013-01-09	BIS	ETF	2385.2	2385.2	2320.4	2324.4	191.5
2013-01-09	BIV	ETF	88.1	88.12	87.93	88.04	252100.0
2013-01-09	BJK	ETF	37.94	38.13	37.84	37.86	8700.0
2013-01-09	BKF	ETF	41.43	41.57	41.33	41.5	115732.0
2013-01-09	BKLN	ETF	25.15	25.18	25.12	25.16	1716400.0
2013-01-09	BLV	ETF	93.01	93.25	92.73	92.99	219600.0
2013-01-09	BMVP	ETF	16.68	16.7867	16.68	16.7833	15476.0
2013-01-09	BND	ETF	83.77	83.8	83.68	83.77	1439600.0
2013-01-09	BNO	ETF	41.255	41.315	41.11	41.26	37600.0
2013-01-09	BOIL	ETF	690000.0	698000.0	662800.0	678000.0	22.4

> showing 50 of 962 rows — these rows as CSV

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