PREVIEW / etf_daily / 2013-01-07

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-07.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-07	SPY	ETF	145.85	146.11	145.43	145.97	110002500.0
2013-01-07	QQQ	ETF	66.46	66.76	66.25	66.6504	26766190.0
2013-01-07	IWM	ETF	86.8	87.07	86.62	86.91	23693400.0
2013-01-07	DIA	ETF	133.69	133.73	133.16	133.51	6119700.0
2013-01-07	GLD	ETF	159.36	159.96	159.15	159.43	9361800.0
2013-01-07	TLT	ETF	118.37	118.73	118.0	118.45	4193100.0
2013-01-07	AADR	ETF	31.73	31.8	31.73	31.8	600.0
2013-01-07	AAXJ	ETF	60.88	60.88	60.64	60.81	249900.0
2013-01-07	ACTV	ETF	5.57	5.62	5.36	5.48	490778.0
2013-01-07	ACWI	ETF	48.79	48.89	48.67	48.84	1497400.0
2013-01-07	ACWV	ETF	56.62	56.62	56.25	56.35	49700.0
2013-01-07	ACWX	ETF	42.08	42.259	42.07	42.2	258641.0
2013-01-07	ADRE	ETF	40.97	40.99	40.72	40.969	29663.0
2013-01-07	AFK	ETF	31.62	31.646	31.43	31.64	31029.0
2013-01-07	AGEM	ETF	23.7	23.75	23.5	23.75	6329.0
2013-01-07	AGG	ETF	110.79	110.82	110.68	110.73	1854400.0
2013-01-07	AGQ	ETF	171.12	174.2	170.72	173.08	196700.0
2013-01-07	AGZ	ETF	113.175	113.18	113.01	113.17	54975.0
2013-01-07	AIA	ETF	48.3	48.3	48.1	48.174	33539.0
2013-01-07	AIQ	ETF	6.53	6.67	6.51	6.57	5956.0
2013-01-07	AIVI	ETF	41.77	42.02	41.76	41.97	26400.0
2013-01-07	ALTL	ETF	26.76	26.76	26.76	26.76	200.0
2013-01-07	AMJ	ETF	40.44	40.85	40.44	40.69	1015930.0
2013-01-07	AMLP	ETF	82.5	83.0	82.5	82.75	566680.0
2013-01-07	ANGL	ETF	27.32	27.32	27.0	27.12	6400.0
2013-01-07	AOA	ETF	37.79	37.86	37.72	37.83	27800.0
2013-01-07	AOK	ETF	30.7	30.72	30.6501	30.69	7651.0
2013-01-07	AOM	ETF	31.94	31.97	31.9	31.969	35775.0
2013-01-07	AOR	ETF	34.34	34.37	34.26	34.33	12272.0
2013-01-07	ARB	ETF	46.72	46.75	46.6	46.74	561078.0
2013-01-07	ARGT	ETF	17.92	18.0	17.92	17.98	4100.0
2013-01-07	ASEA	ETF	17.1	17.13	17.01	17.07	11500.0
2013-01-07	AWAY	ETF	23.24	23.43	22.61	23.41	442584.0
2013-01-07	BAB	ETF	29.92	30.0	29.9	29.91	142073.0
2013-01-07	BAL	ETF	48.8	49.43	48.7451	49.43	19614.0
2013-01-07	BALT	ETF	3.26	3.43	3.25	3.25	217059.0
2013-01-07	BBH	ETF	55.3	55.79	55.09	55.76	59100.0
2013-01-07	BCM	ETF	43.58	43.74	43.5296	43.74	7733.0
2013-01-07	BIB	ETF	15.6325	15.855	15.56	15.8475	45824.0
2013-01-07	BICK	ETF	25.65	25.73	25.65	25.73	3979.0
2013-01-07	BIL	ETF	91.6	91.62	91.6	91.6	179650.0
2013-01-07	BIS	ETF	2478.0	2478.0	2415.2	2415.2	589.0
2013-01-07	BIV	ETF	87.93	87.93	87.81	87.9	450000.0
2013-01-07	BJK	ETF	37.43	37.54	37.37	37.54	18300.0
2013-01-07	BKF	ETF	41.59	41.72	41.4801	41.63	53223.0
2013-01-07	BKLN	ETF	25.09	25.11	25.05	25.09	1005000.0
2013-01-07	BLNG	ETF	48.9	48.9	48.9	48.9	200.0
2013-01-07	BLV	ETF	92.26	92.5	92.18	92.46	72000.0
2013-01-07	BMVP	ETF	16.747	16.747	16.64	16.68	4149.0
2013-01-07	BND	ETF	83.71	83.76	83.66	83.72	1866600.0

> showing 50 of 977 rows — these rows as CSV

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