PREVIEW / etf_daily / 2012-01-18

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-18.parquet
  size:    37 KB
  rows:    895

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
2012-01-18	SPY	ETF	129.31	130.84	129.08	130.77	163395200.0
2012-01-18	QQQ	ETF	58.84	59.49	58.6822	59.49	48692630.0
2012-01-18	IWM	ETF	76.32	77.73	76.15	77.72	49330800.0
2012-01-18	DIA	ETF	124.53	125.72	124.41	125.62	6473000.0
2012-01-18	GLD	ETF	159.94	161.64	159.68	161.6	9341200.0
2012-01-18	TLT	ETF	121.53	121.61	119.91	119.97	5804000.0
2012-01-18	AADR	ETF	28.75	28.75	28.75	28.75	400.0
2012-01-18	AAXJ	ETF	52.7	53.65	52.66	53.58	410800.0
2012-01-18	ACTV	ETF	15.01	15.09	14.78	15.0	141871.0
2012-01-18	ACWI	ETF	43.27	43.89	43.26	43.85	408100.0
2012-01-18	ACWV	ETF	51.92	51.94	51.92	51.94	500.0
2012-01-18	ACWX	ETF	37.61	38.09	37.56	38.08	340386.0
2012-01-18	ADRE	ETF	40.9	41.65	40.9	41.61	32589.0
2012-01-18	AFK	ETF	26.7	27.16	26.7	27.1	16758.0
2012-01-18	AGEM	ETF	22.15	22.64	22.15	22.61	2254.0
2012-01-18	AGG	ETF	110.56	110.68	110.4	110.44	1216900.0
2012-01-18	AGQ	ETF	196.52	202.4	195.8	200.8	389225.0
2012-01-18	AGZ	ETF	112.99	113.07	112.81	112.828	9014.0
2012-01-18	AIA	ETF	41.14	41.67	41.14	41.67	18648.0
2012-01-18	AIQ	ETF	5.5	5.6	5.35	5.55	14217.0
2012-01-18	AIS	ETF	2.21	2.26	2.2	2.25	603100.0
2012-01-18	AIVI	ETF	39.85	40.22	39.76	40.22	109700.0
2012-01-18	AMJ	ETF	39.06	39.31	39.06	39.29	1340369.0
2012-01-18	AMLP	ETF	83.2	83.35	83.05	83.3	413160.0
2012-01-18	AOA	ETF	33.95	34.27	33.93	34.27	7100.0
2012-01-18	AOK	ETF	29.57	29.62	29.5604	29.61	104255.0
2012-01-18	AOM	ETF	30.2842	30.36	30.28	30.32	67060.0
2012-01-18	AOR	ETF	31.72	31.92	31.69	31.92	32913.0
2012-01-18	ARB	ETF	36.39	37.0	36.2	36.81	94307.0
2012-01-18	ARGT	ETF	22.88	22.98	22.62	22.98	1350.0
2012-01-18	ASEA	ETF	14.96	15.27	14.96	15.26	10700.0
2012-01-18	AWAY	ETF	25.13	25.71	24.94	25.2	138759.0
2012-01-18	BAB	ETF	29.09	29.1	28.89	28.89	255401.0
2012-01-18	BAL	ETF	59.96	60.44	59.42	59.87	10037.0
2012-01-18	BALT	ETF	4.14	4.49	4.14	4.43	216811.0
2012-01-18	BBH	ETF	40.2467	40.6633	40.2367	40.65	83100.0
2012-01-18	BCM	ETF	44.11	44.11	44.11	44.11	1114.0
2012-01-18	BIB	ETF	10.0575	10.3688	10.0575	10.3662	120008.0
2012-01-18	BICK	ETF	25.39	25.57	25.2725	25.559	21838.0
2012-01-18	BIL	ETF	91.64	91.66	91.64	91.64	1529650.0
2012-01-18	BIS	ETF	4521.6	4552.0	4384.0	4385.6	61.0
2012-01-18	BITS	ETF	22.76	22.8	22.56	22.8	3206.0
2012-01-18	BIV	ETF	87.52	87.53	87.2	87.32	332900.0
2012-01-18	BJK	ETF	31.28	31.88	31.28	31.81	27400.0
2012-01-18	BKF	ETF	39.49	40.32	39.4213	40.32	96539.0
2012-01-18	BKLN	ETF	24.11	24.15	24.07	24.07	52900.0
2012-01-18	BLV	ETF	92.52	92.6	91.98	91.98	1165000.0
2012-01-18	BMVP	ETF	14.23	14.3271	14.2	14.3267	53760.0
2012-01-18	BND	ETF	83.8	83.81	83.61	83.61	1904100.0
2012-01-18	BNO	ETF	38.745	38.795	38.415	38.61	117600.0

> showing 50 of 895 rows — these rows as CSV

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