PREVIEW / etf_daily / 2010-09-16

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-16.parquet
  size:    33 KB
  rows:    782

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
2010-09-16	SPY	ETF	112.73	113.12	112.35	113.05	199962900.0
2010-09-16	QQQ	ETF	47.68	47.98	47.54	47.94	66885758.0
2010-09-16	IWM	ETF	65.2	65.41	64.39	64.94	52659700.0
2010-09-16	DIA	ETF	105.67	106.24	105.4	106.19	5449000.0
2010-09-16	GLD	ETF	124.5	124.77	124.19	124.63	12672800.0
2010-09-16	TLT	ETF	101.53	101.82	100.85	101.26	17116200.0
2010-09-16	AADR	ETF	27.32	27.32	27.32	27.32	200.0
2010-09-16	AAXJ	ETF	58.15	58.25	57.98	58.14	1078800.0
2010-09-16	ACWI	ETF	42.34	42.4	42.16	42.4	63400.0
2010-09-16	ACWX	ETF	40.39	40.47	40.25	40.44	633333.0
2010-09-16	ADRE	ETF	43.23	43.4681	43.22	43.42	109531.0
2010-09-16	AFK	ETF	31.24	31.3	31.06	31.3	14530.0
2010-09-16	AGG	ETF	107.79	107.89	107.56	107.75	691600.0
2010-09-16	AGQ	ETF	150.98	152.86	150.14	152.6	210450.0
2010-09-16	AGZ	ETF	110.86	110.91	110.75	110.87	11057.0
2010-09-16	AIA	ETF	40.92	41.07	40.8755	41.07	3072.0
2010-09-16	AIQ	ETF	21.85	21.9	21.375	21.65	11070.0
2010-09-16	AIS	ETF	1.49	1.54	1.48	1.51	127252.0
2010-09-16	AIVI	ETF	42.35	42.35	42.07	42.28	50400.0
2010-09-16	AMJ	ETF	32.81	32.94	32.8	32.89	286934.0
2010-09-16	AMLP	ETF	76.15	76.15	75.75	75.95	134020.0
2010-09-16	AOA	ETF	30.82	30.94	30.82	30.92	9600.0
2010-09-16	AOK	ETF	28.15	28.15	28.08	28.14	5475.0
2010-09-16	AOM	ETF	28.79	28.8499	28.79	28.8499	4741.0
2010-09-16	AOR	ETF	29.59	29.61	29.5124	29.61	5029.0
2010-09-16	ARB	ETF	27.23	27.23	26.37	26.79	99518.0
2010-09-16	BAB	ETF	26.26	26.3	26.13	26.21	280889.0
2010-09-16	BAL	ETF	46.67	46.94	46.19	46.7799	23326.0
2010-09-16	BALT	ETF	11.18	11.3	11.01	11.23	63018.0
2010-09-16	BBH	ETF	31.9067	32.0533	31.8233	31.99	92700.0
2010-09-16	BIB	ETF	6.305	6.305	6.1813	6.2088	27392.0
2010-09-16	BICK	ETF	30.34	30.46	30.045	30.3	18917.0
2010-09-16	BIL	ETF	91.7	91.72	91.7	91.72	213550.0
2010-09-16	BIS	ETF	10158.4	10169.6	10110.4	10169.6	2.5
2010-09-16	BITS	ETF	26.0	26.0	25.64	25.8	2200.0
2010-09-16	BIV	ETF	85.29	85.39	85.11	85.21	142500.0
2010-09-16	BJK	ETF	27.48	27.55	27.25	27.36	4400.0
2010-09-16	BKF	ETF	45.88	46.19	45.88	46.115	80803.0
2010-09-16	BLV	ETF	83.63	83.68	83.13	83.39	49100.0
2010-09-16	BMVP	ETF	12.83	12.84	12.78	12.83	16089.0
2010-09-16	BND	ETF	81.95	82.0	81.81	81.92	490600.0
2010-09-16	BNE	ETF	11.09	11.1	11.05	11.05	585679.0
2010-09-16	BNO	ETF	26.69	26.69	26.26	26.335	35200.0
2010-09-16	BRF	ETF	55.19	55.6	55.19	55.47	329265.0
2010-09-16	BSCE	ETF	20.82	20.82	20.819	20.819	6940.0
2010-09-16	BSV	ETF	81.47	81.47	81.4	81.46	317700.0
2010-09-16	BTF	ETF	73.94999999999999	74.74999999999999	73.44999999999999	74.05	1020.0
2010-09-16	BWX	ETF	28.915	29.015	28.86	29.005	177106.0
2010-09-16	BWZ	ETF	35.805	35.94	35.7301	35.94	21518.0
2010-09-16	BZQ	ETF	3104.0	3116.8	3081.6	3081.6	439.0

> showing 50 of 782 rows — these rows as CSV

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