PREVIEW / etf_daily / 2009-10-08

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-08.parquet
  size:    30 KB
  rows:    677

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
2009-10-08	SPY	ETF	106.55	107.17	105.85	106.61	183305800.0
2009-10-08	QQQ	ETF	42.31	42.62	42.14	42.24	107850372.0
2009-10-08	IWM	ETF	60.73	61.31	60.37	60.71	48971800.0
2009-10-08	DIA	ETF	97.94	98.45	97.54	97.91	9701300.0
2009-10-08	GLD	ETF	102.62	104.15	102.3	103.64	24250200.0
2009-10-08	TLT	ETF	99.71	99.76	97.68	98.15	5871600.0
2009-10-08	AAXJ	ETF	53.06	53.49	52.97	53.4	852400.0
2009-10-08	ACWI	ETF	41.3	41.5	41.04	41.34	187800.0
2009-10-08	ACWX	ETF	40.29	40.58	40.16	40.36	22148.0
2009-10-08	ADRE	ETF	42.1	42.4792	41.899	42.34	151146.0
2009-10-08	AFK	ETF	29.63	30.05	29.01	30.0	23617.0
2009-10-08	AGG	ETF	105.1	105.12	104.68	104.89	512000.0
2009-10-08	AGQ	ETF	127.9	132.38	126.38	130.48	361050.0
2009-10-08	AGZ	ETF	108.88	108.915	108.61	108.82	6289.0
2009-10-08	AIA	ETF	38.37	38.5	37.97	38.3	112290.0
2009-10-08	AIQ	ETF	31.0	31.45	30.75	31.2	115941.0
2009-10-08	AIS	ETF	1.17	1.17	1.08	1.13	336659.0
2009-10-08	AIVI	ETF	42.64	43.0	42.46	42.82	13300.0
2009-10-08	AMJ	ETF	25.22	25.56	25.22	25.53	145745.0
2009-10-08	AOA	ETF	29.27	29.34	29.17	29.24	11500.0
2009-10-08	AOK	ETF	27.14	27.27	27.11	27.2055	11690.0
2009-10-08	AOM	ETF	27.8	27.97	27.8	27.88	9594.0
2009-10-08	AOR	ETF	28.31	28.61	28.31	28.49	9058.0
2009-10-08	ARB	ETF	21.96	22.36	21.72	21.73	221352.0
2009-10-08	BAL	ETF	32.89	33.2385	32.8	33.11	19538.0
2009-10-08	BBH	ETF	33.1467	33.37	32.9933	33.0567	44700.0
2009-10-08	BIL	ETF	91.72	91.74	91.7	91.7	109950.0
2009-10-08	BITS	ETF	21.76	22.0	21.4	21.48	2715.0
2009-10-08	BIV	ETF	81.0	81.02	80.6	80.71	100200.0
2009-10-08	BJK	ETF	26.21	26.74	26.21	26.45	35100.0
2009-10-08	BKF	ETF	43.24	43.84	43.14	43.78	210277.0
2009-10-08	BLV	ETF	80.48	80.48	79.35	79.73	62100.0
2009-10-08	BMVP	ETF	12.0633	12.12	12.0122	12.0867	17768.0
2009-10-08	BND	ETF	79.71	79.71	79.35	79.59	1109400.0
2009-10-08	BNE	ETF	7.83	7.87	7.7	7.78	221439.0
2009-10-08	BOSS	ETF	20.73	21.42	20.73	21.42	500.0
2009-10-08	BRF	ETF	42.98	43.4	42.53	43.33	1053517.0
2009-10-08	BSV	ETF	80.07	80.14	79.88	79.95	243300.0
2009-10-08	BTF	ETF	59.74999999999999	60.949999999999996	59.74999999999999	60.49999999999999	11521.400000000001
2009-10-08	BWX	ETF	29.57	29.66	29.48	29.63	482312.0
2009-10-08	BWZ	ETF	37.4	37.63	37.4	37.63	21498.0
2009-10-08	BZQ	ETF	4880.0	4902.4	4702.4	4702.4	97.0
2009-10-08	CEF	ETF	13.7	13.87	13.58	13.64	1556400.0
2009-10-08	CEW	ETF	21.83	22.03	21.83	21.99	105971.0
2009-10-08	CGO	ETF	14.24	14.37	14.218	14.218	15896.0
2009-10-08	CGW	ETF	17.6	17.8	17.57	17.69	101803.0
2009-10-08	CHB	ETF	0.43	0.49	0.42	0.44	4524397.0
2009-10-08	CHI	ETF	11.85	11.98	11.85	11.9	208595.0
2009-10-08	CHIC	ETF	17.5	17.5	17.49	17.5	104294.0
2009-10-08	CHW	ETF	7.83	7.93	7.81	7.93	205962.0

> showing 50 of 677 rows — these rows as CSV

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