PREVIEW / etf_daily / 2012-04-19

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-19.parquet
  size:    38 KB
  rows:    921

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-04-19	SPY	ETF	138.63	139.15	137.07	137.72	198666700.0
2012-04-19	QQQ	ETF	66.38	67.17	65.62	65.86	81110267.0
2012-04-19	IWM	ETF	80.32	80.99	79.25	79.75	74260400.0
2012-04-19	DIA	ETF	130.23	130.67	128.82	129.54	8957000.0
2012-04-19	GLD	ETF	160.0	160.64	159.02	159.43	9914400.0
2012-04-19	TLT	ETF	117.25	117.47	117.02	117.05	5374300.0
2012-04-19	AADR	ETF	30.42	30.42	30.42	30.42	300.0
2012-04-19	AAXJ	ETF	56.17	56.44	55.65	55.91	225800.0
2012-04-19	ACTV	ETF	16.75	16.98	16.38	16.56	101711.0
2012-04-19	ACWI	ETF	46.32	46.5	45.82	46.05	317300.0
2012-04-19	ACWX	ETF	39.84	40.01	39.45	39.66	104232.0
2012-04-19	ADRE	ETF	41.26	41.4	40.92	41.13	12389.0
2012-04-19	AFK	ETF	28.78	29.0	28.74	28.74	8605.0
2012-04-19	AGG	ETF	110.5	110.58	110.46	110.46	618700.0
2012-04-19	AGQ	ETF	209.72	212.88	207.72	208.68	310500.0
2012-04-19	AGZ	ETF	112.64	112.79	112.57	112.76	23953.0
2012-04-19	AIA	ETF	44.65	44.82	44.33	44.43	15383.0
2012-04-19	AIQ	ETF	7.05	7.0505	6.8	6.95	7495.0
2012-04-19	AIS	ETF	3.0	3.09	2.99	3.01	1275363.0
2012-04-19	AIVI	ETF	39.93	40.13	39.57	39.78	26200.0
2012-04-19	AMJ	ETF	38.96	39.31	38.79	39.25	883897.0
2012-04-19	AMLP	ETF	82.45	83.2	82.45	83.1	335600.0
2012-04-19	ANGL	ETF	25.7	25.7	25.5	25.6	4800.0
2012-04-19	AOA	ETF	35.81	36.0	35.61	35.75	8700.0
2012-04-19	AOK	ETF	30.03	30.11	29.96	29.98	39357.0
2012-04-19	AOM	ETF	31.08	31.12	30.953	31.0	34465.0
2012-04-19	AOR	ETF	33.04	33.04	32.86	32.95	9099.0
2012-04-19	ARB	ETF	39.98	39.98	38.08	38.31	719237.0
2012-04-19	ARGT	ETF	18.4	18.74	18.4	18.58	1600.0
2012-04-19	ASEA	ETF	16.12	16.16	16.03	16.03	2600.0
2012-04-19	AWAY	ETF	24.22	24.39	23.87	24.13	312904.0
2012-04-19	BAB	ETF	29.43	29.5	29.37	29.47	152877.0
2012-04-19	BAL	ETF	56.11	56.68	55.88	56.44	37699.0
2012-04-19	BALT	ETF	4.34	4.5383	4.29	4.49	168358.0
2012-04-19	BBH	ETF	43.76	44.8	43.76	44.31	225900.0
2012-04-19	BCM	ETF	44.31	44.31	44.188	44.28	4320.0
2012-04-19	BIB	ETF	11.3663	11.76	11.3663	11.5038	26048.0
2012-04-19	BICK	ETF	25.7	25.8693	25.5	25.6301	14515.0
2012-04-19	BIL	ETF	91.64	91.66	91.64	91.66	38300.0
2012-04-19	BIS	ETF	3812.8	3812.8	3694.4	3771.2	15.6
2012-04-19	BIV	ETF	87.72	87.76	87.65	87.72	351900.0
2012-04-19	BJK	ETF	36.93	37.03	36.34	36.65	40500.0
2012-04-19	BKF	ETF	40.48	40.67	40.11	40.38	136785.0
2012-04-19	BKLN	ETF	24.43	24.46	24.37	24.37	156500.0
2012-04-19	BLV	ETF	91.17	91.33	91.14	91.21	28500.0
2012-04-19	BMVP	ETF	15.35	15.42	15.25	15.32	4696.0
2012-04-19	BND	ETF	83.83	83.83	83.73	83.74	664200.0
2012-04-19	BNO	ETF	41.915	42.0	41.55	41.64	162200.0
2012-04-19	BOIL	ETF	604000.0	619000.0	586000.0	590000.0	7.2
2012-04-19	BOND	ETF	102.96	103.079	102.94	102.99	225416.0

> showing 50 of 921 rows — these rows as CSV

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