PREVIEW / etf_daily / 2013-01-08

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-08.parquet
  size:    40 KB
  rows:    974

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-08	SPY	ETF	145.71	145.91	144.98	145.55	121265100.0
2013-01-08	QQQ	ETF	66.64	66.815	66.17	66.52	28743941.0
2013-01-08	IWM	ETF	86.88	87.01	86.39	86.85	23760000.0
2013-01-08	DIA	ETF	133.32	133.5	132.74	133.06	4269800.0
2013-01-08	GLD	ETF	160.46	160.99	160.01	160.56	7694800.0
2013-01-08	TLT	ETF	119.04	119.29	118.82	119.23	4380900.0
2013-01-08	AADR	ETF	31.44	31.63	31.44	31.45	5500.0
2013-01-08	AAXJ	ETF	60.59	60.6	60.12	60.3	219100.0
2013-01-08	ACTV	ETF	5.46	5.5299	5.22	5.29	395710.0
2013-01-08	ACWI	ETF	48.71	48.75	48.43	48.6	306300.0
2013-01-08	ACWV	ETF	56.38	56.44	56.25	56.44	19200.0
2013-01-08	ACWX	ETF	42.09	42.09	41.81	41.92	90396.0
2013-01-08	ADRE	ETF	40.66	40.69	40.45	40.53	64690.0
2013-01-08	AFK	ETF	31.49	31.6199	31.41	31.46	23142.0
2013-01-08	AGEM	ETF	23.58	23.64	23.36	23.402	5839.0
2013-01-08	AGG	ETF	110.79	110.89	110.75	110.83	1784500.0
2013-01-08	AGQ	ETF	176.48	178.0	173.56	175.6	278325.0
2013-01-08	AGZ	ETF	113.28	113.34	113.22	113.3395	29164.0
2013-01-08	AIA	ETF	47.93	47.93	47.612	47.7699	13405.0
2013-01-08	AIQ	ETF	6.64	6.64	6.57	6.62	5717.0
2013-01-08	AIVI	ETF	41.82	41.91	41.67	41.83	28800.0
2013-01-08	ALTL	ETF	26.65	26.65	26.65	26.65	264.0
2013-01-08	AMJ	ETF	40.88	40.9	40.5	40.6783	602689.0
2013-01-08	AMLP	ETF	82.75	82.95	82.4	82.45	727140.0
2013-01-08	ANGL	ETF	27.11	27.17	27.08	27.08	2200.0
2013-01-08	AOA	ETF	37.78	37.8	37.61	37.71	22100.0
2013-01-08	AOK	ETF	30.71	30.71	30.65	30.69	29501.0
2013-01-08	AOM	ETF	31.98	31.98	31.87	31.92	17629.0
2013-01-08	AOR	ETF	34.34	34.34	34.226	34.28	51135.0
2013-01-08	ARB	ETF	46.7	46.84	46.67	46.8	641370.0
2013-01-08	ARGT	ETF	17.92	17.92	17.82	17.82	1100.0
2013-01-08	ASEA	ETF	17.01	17.01	16.86	16.96	20100.0
2013-01-08	AWAY	ETF	23.28	23.71	22.61	22.74	540610.0
2013-01-08	BAB	ETF	30.04	30.18	30.01	30.18	593594.0
2013-01-08	BAL	ETF	49.2221	49.43	48.93	49.1	20560.0
2013-01-08	BALT	ETF	3.28	3.5	3.25	3.33	77582.0
2013-01-08	BBH	ETF	55.69	56.37	55.69	56.31	30900.0
2013-01-08	BCM	ETF	43.7	43.83	43.6999	43.8299	2456.0
2013-01-08	BIB	ETF	15.825	16.0025	15.6625	16.0025	122156.0
2013-01-08	BICK	ETF	25.44	25.44	25.35	25.35	3934.0
2013-01-08	BIL	ETF	91.62	91.62	91.6	91.6	106650.0
2013-01-08	BIS	ETF	2430.4	2430.4	2380.0	2392.0	184.5
2013-01-08	BIV	ETF	87.99	88.06	87.91	87.97	378800.0
2013-01-08	BJK	ETF	37.54	37.59	37.42	37.59	3200.0
2013-01-08	BKF	ETF	41.34	41.38	41.01	41.28	310155.0
2013-01-08	BKLN	ETF	25.13	25.14	25.1	25.13	1782200.0
2013-01-08	BLNG	ETF	49.32	49.32	49.31	49.31	800.0
2013-01-08	BLV	ETF	92.72	92.99	92.66	92.85	50400.0
2013-01-08	BMVP	ETF	16.63	16.68	16.56	16.63	11470.0
2013-01-08	BND	ETF	83.75	83.85	83.73	83.8	1189000.0

> showing 50 of 974 rows — these rows as CSV

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