PREVIEW / etf_daily / 2013-06-18

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-18.parquet
  size:    40 KB
  rows:    994

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-06-18	SPY	ETF	164.53	165.99	164.52	165.74	114695600.0
2013-06-18	QQQ	ETF	73.07	73.72	73.06	73.58	24861267.0
2013-06-18	IWM	ETF	98.52	99.8	98.33	99.51	40520200.0
2013-06-18	DIA	ETF	151.96	153.36	151.92	153.1	4807900.0
2013-06-18	GLD	ETF	132.72	132.96	131.53	132.13	7379300.0
2013-06-18	TLT	ETF	112.85	113.68	112.72	113.28	5192700.0
2013-06-18	AADR	ETF	34.05	34.19	34.05	34.12	3800.0
2013-06-18	AAXJ	ETF	56.4	56.42	56.17	56.4	3659000.0
2013-06-18	ACTV	ETF	7.15	7.15	7.01	7.09	328511.0
2013-06-18	ACWI	ETF	52.11	52.43	52.09	52.36	794400.0
2013-06-18	ACWV	ETF	61.47	61.79	61.36	61.78	129200.0
2013-06-18	ACWX	ETF	42.99	43.22	42.99	43.11	510262.0
2013-06-18	ADRE	ETF	35.49	35.67	35.4125	35.55	64479.0
2013-06-18	AFK	ETF	28.79	28.85	28.52	28.64	33359.0
2013-06-18	AGEM	ETF	20.86	20.86	20.86	20.86	412.0
2013-06-18	AGG	ETF	108.63	108.73	108.52	108.66	1067500.0
2013-06-18	AGQ	ETF	84.64	85.4	82.92	83.64	394650.0
2013-06-18	AGZ	ETF	111.88	112.1799	111.87	111.92	26206.0
2013-06-18	AIA	ETF	43.55	43.84	43.55	43.77	48183.0
2013-06-18	AIQ	ETF	16.24	16.24	15.78	16.0	31455.0
2013-06-18	AIVI	ETF	43.12	43.36	43.02	43.26	184800.0
2013-06-18	AMJ	ETF	46.57	46.88	46.01	46.33	547072.0
2013-06-18	AMLP	ETF	88.5	88.75	88.1	88.55	586240.0
2013-06-18	ANGL	ETF	26.9	27.1	26.88	26.96	32600.0
2013-06-18	AOA	ETF	40.75	41.0	40.74	40.95	24400.0
2013-06-18	AOK	ETF	31.21	31.28	31.19	31.27	22268.0
2013-06-18	AOM	ETF	32.97	33.08	32.97	33.07	23884.0
2013-06-18	AOR	ETF	36.18	36.34	36.18	36.32	37151.0
2013-06-18	ARB	ETF	46.82	46.89	46.79	46.85	103083.0
2013-06-18	ARGT	ETF	16.94	16.94	16.94	16.94	1300.0
2013-06-18	ASEA	ETF	17.18	17.2	17.14	17.19	10200.0
2013-06-18	ATMP	ETF	25.77	25.91	25.77	25.89	173800.0
2013-06-18	AVIV	ETF	26.44	26.74	25.95	26.22	362450.0
2013-06-18	AWAY	ETF	29.94	30.155	29.56	30.14	479664.0
2013-06-18	BAB	ETF	28.67	29.0	28.67	28.919	824874.0
2013-06-18	BAL	ETF	56.47	56.47	55.784	55.88	17478.0
2013-06-18	BALT	ETF	3.61	3.71	3.5933	3.68	57169.0
2013-06-18	BBH	ETF	68.59	69.63	68.46	69.46	50900.0
2013-06-18	BCM	ETF	40.39	40.5799	40.39	40.5799	2174.0
2013-06-18	BFOR	ETF	6.3025	6.3575	6.3025	6.35	310800.0
2013-06-18	BIB	ETF	22.8225	23.6175	22.7078	23.5475	88628.0
2013-06-18	BICK	ETF	21.91	22.06	21.89	21.98	15540.0
2013-06-18	BIL	ETF	91.6	91.62	91.6	91.6	169700.0
2013-06-18	BIS	ETF	1539.2	1552.0	1500.0	1500.0	155.0
2013-06-18	BIV	ETF	85.45	85.54	85.36	85.44	220800.0
2013-06-18	BIZD	ETF	19.8	20.03	19.8	20.03	3800.0
2013-06-18	BJK	ETF	42.69	42.79	42.5	42.75	53400.0
2013-06-18	BKF	ETF	35.78	35.87	35.57	35.82	139130.0
2013-06-18	BKLN	ETF	24.86	24.91	24.86	24.9	3922500.0
2013-06-18	BLV	ETF	87.45	87.93	87.38	87.62	30700.0

> showing 50 of 994 rows — these rows as CSV

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