PREVIEW / etf_daily / 2009-01-12

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-12.parquet
  size:    28 KB
  rows:    629

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-01-12	SPY	ETF	88.84	88.91	86.41	86.95	277858500.0
2009-01-12	QQQ	ETF	30.12	30.15	29.2	29.52	102778875.0
2009-01-12	IWM	ETF	47.95	48.11	46.5	46.7	53721400.0
2009-01-12	DIA	ETF	85.77	86.02	84.26	84.79	22622000.0
2009-01-12	GLD	ETF	81.72	82.04	80.26	80.76	14755500.0
2009-01-12	TLT	ETF	111.57	114.05	111.57	113.9	2462800.0
2009-01-12	AAXJ	ETF	32.56	32.56	31.43	31.49	43300.0
2009-01-12	ACWI	ETF	31.59	31.68	30.73	30.93	630600.0
2009-01-12	ACWX	ETF	29.94	29.94	29.06	29.2	266261.0
2009-01-12	ADRE	ETF	27.59	27.59	26.29	26.4299	250022.0
2009-01-12	AFK	ETF	20.1	20.1	19.5	19.5	9400.0
2009-01-12	AGG	ETF	102.5	103.28	102.37	103.05	774400.0
2009-01-12	AGQ	ETF	58.34	60.06	52.78	55.34	31350.0
2009-01-12	AGZ	ETF	108.22	108.69	108.22	108.652	8939.0
2009-01-12	AIA	ETF	24.75	24.75	23.3	24.3	28100.0
2009-01-12	AIQ	ETF	41.5	42.5	40.75	41.1	32607.0
2009-01-12	AIS	ETF	0.47	0.47	0.4299	0.45	31178.0
2009-01-12	AIVI	ETF	33.32	33.32	32.39	32.65	15700.0
2009-01-12	AOA	ETF	25.31	25.31	23.5	23.51	8400.0
2009-01-12	AOK	ETF	25.46	25.46	25.22	25.45	3675.0
2009-01-12	AOM	ETF	26.0	26.0	24.77	25.2	22668.0
2009-01-12	AOR	ETF	23.76	24.4	23.76	24.12	13808.0
2009-01-12	ARB	ETF	15.93	16.37	15.43	15.65	326617.0
2009-01-12	BAL	ETF	29.14	29.14	27.35	27.53	3291.0
2009-01-12	BBH	ETF	57.93	57.9667	57.1167	57.7	120600.0
2009-01-12	BIL	ETF	91.72	91.88	91.68	91.68	178700.0
2009-01-12	BITS	ETF	19.16	19.8	17.32	18.4	2125.0
2009-01-12	BIV	ETF	78.61	79.15	78.61	78.96	81000.0
2009-01-12	BJK	ETF	19.46	19.46	17.35	17.35	3000.0
2009-01-12	BKF	ETF	24.65	24.65	23.19	23.37	47802.0
2009-01-12	BLV	ETF	77.76	78.49	77.34	77.8	39800.0
2009-01-12	BMVP	ETF	10.57	10.57	10.33	10.39	20538.0
2009-01-12	BND	ETF	78.05	78.39	77.76	77.93	402000.0
2009-01-12	BNE	ETF	5.09	5.09	4.05	4.1	333384.0
2009-01-12	BSV	ETF	79.7	79.97	79.3	79.94	127300.0
2009-01-12	BTF	ETF	54.1	54.1	51.95	52.9	12278.400000000001
2009-01-12	BWX	ETF	26.5	26.5	26.24	26.45	688466.0
2009-01-12	CBON	ETF	2.65	2.65	2.335	2.39	127325.0
2009-01-12	CDL	ETF	0.22	0.24	0.2	0.22	635020.0
2009-01-12	CEF	ETF	10.14	10.14	9.87	10.0	781900.0
2009-01-12	CGO	ETF	10.26	10.26	9.8601	9.93	16884.0
2009-01-12	CGW	ETF	13.82	14.0	13.61	13.65	40703.0
2009-01-12	CHB	ETF	0.76	0.81	0.7	0.73	941879.0
2009-01-12	CHI	ETF	9.8	9.93	9.5	9.76	350688.0
2009-01-12	CHIC	ETF	6.18	6.36	5.75	5.82	155663.0
2009-01-12	CHW	ETF	6.37	6.44	6.17	6.26	431631.0
2009-01-12	CHY	ETF	9.4	9.43	8.96	9.09	373998.0
2009-01-12	CMF	ETF	52.0	52.0	51.305	51.8225	21256.0
2009-01-12	CNXT	ETF	0.79	0.79	0.753	0.76	241910.0
2009-01-12	COW	ETF	33.09	33.2	32.77	32.87	30681.0

> showing 50 of 629 rows — these rows as CSV

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