PREVIEW / etf_daily / 2010-03-24

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-24.parquet
  size:    32 KB
  rows:    735

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-03-24	SPY	ETF	116.97	117.43	115.58	116.84	196072600.0
2010-03-24	QQQ	ETF	48.14	48.17	47.91	48.02	63030095.0
2010-03-24	IWM	ETF	68.68	68.97	68.25	68.27	59664500.0
2010-03-24	DIA	ETF	108.52	108.81	108.22	108.4	7075900.0
2010-03-24	GLD	ETF	106.94	107.07	106.24	106.3	14236700.0
2010-03-24	TLT	ETF	89.84	90.25	89.06	89.27	8049300.0
2010-03-24	AAXJ	ETF	55.9	55.95	55.44	55.59	118000.0
2010-03-24	ACWI	ETF	43.2	43.2	42.91	42.97	108300.0
2010-03-24	ACWX	ETF	41.05	41.1	40.83	40.93	35101.0
2010-03-24	ADRE	ETF	43.22	43.46	43.0	43.08	62066.0
2010-03-24	AFK	ETF	30.81	30.87	30.6144	30.7499	15872.0
2010-03-24	AGG	ETF	104.67	104.67	104.22	104.32	602700.0
2010-03-24	AGQ	ETF	105.6	106.6	104.36	104.8	310950.0
2010-03-24	AGZ	ETF	108.16	108.3599	107.99	108.11	9715.0
2010-03-24	AIA	ETF	39.75	39.75	39.38	39.58	20001.0
2010-03-24	AIQ	ETF	28.15	29.4	28.15	28.8	159727.0
2010-03-24	AIS	ETF	1.55	1.55	1.48	1.5	271501.0
2010-03-24	AIVI	ETF	41.82	41.94	41.62	41.8	18700.0
2010-03-24	AMJ	ETF	29.92	30.3	29.81	29.98	343060.0
2010-03-24	AOA	ETF	31.47	31.47	31.22	31.36	22600.0
2010-03-24	AOK	ETF	27.78	27.8526	27.78	27.83	10199.0
2010-03-24	AOM	ETF	28.74	28.76	28.63	28.63	6697.0
2010-03-24	AOR	ETF	29.83	29.83	29.64	29.72	8706.0
2010-03-24	ARB	ETF	25.96	26.49	25.95	26.22	281826.0
2010-03-24	BAB	ETF	24.93	24.94	24.771	24.8	281905.0
2010-03-24	BAL	ETF	39.57	39.57	39.2299	39.2299	4389.0
2010-03-24	BALT	ETF	13.44	13.55	13.07	13.55	267570.0
2010-03-24	BBH	ETF	35.2767	35.47	34.9767	35.0167	41400.0
2010-03-24	BIL	ETF	91.68	91.7	91.68	91.68	161800.0
2010-03-24	BITS	ETF	32.16	32.8	31.92	32.8	3451.0
2010-03-24	BIV	ETF	80.48	80.54	80.05	80.11	129700.0
2010-03-24	BJK	ETF	25.43	25.63	25.33	25.34	4200.0
2010-03-24	BKF	ETF	45.23	45.6299	45.15	45.29	217238.0
2010-03-24	BLV	ETF	76.99	77.16	76.52	76.6	25500.0
2010-03-24	BMVP	ETF	13.28	13.29	13.2	13.2	23543.0
2010-03-24	BND	ETF	79.37	79.47	79.14	79.22	654000.0
2010-03-24	BNE	ETF	11.26	11.29	11.25	11.25	1133346.0
2010-03-24	BRF	ETF	45.74	46.14	45.15	45.252	265175.0
2010-03-24	BSV	ETF	80.05	80.06	79.89	79.93	870300.0
2010-03-24	BTF	ETF	74.25	74.25	73.2	73.94999999999999	5190.200000000001
2010-03-24	BWX	ETF	28.0	28.04	27.805	27.92	381122.0
2010-03-24	BWZ	ETF	35.35	35.36	35.16	35.16	35217.0
2010-03-24	BZQ	ETF	3774.4	3830.4	3670.4	3806.4	968.0
2010-03-24	CEF	ETF	13.6	13.69	13.51	13.58	882400.0
2010-03-24	CEW	ETF	22.0	22.03	21.93	21.97	178290.0
2010-03-24	CGO	ETF	14.6	14.85	14.5	14.7	51691.0
2010-03-24	CGW	ETF	18.27	18.27	18.0901	18.14	51718.0
2010-03-24	CHI	ETF	12.52	12.72	12.52	12.7	167492.0
2010-03-24	CHIE	ETF	14.1	14.15	14.03	14.0799	1824.0
2010-03-24	CHII	ETF	14.97	15.05	14.95	14.95	6548.0

> showing 50 of 735 rows — these rows as CSV

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