PREVIEW / etf_daily / 2009-01-27

all etf daily files

  file:    by_date/etf_daily/2009/2009-01-27.parquet
  size:    28 KB
  rows:    630

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-27	SPY	ETF	84.13	85.15	83.3	84.53	273789700.0
2009-01-27	QQQ	ETF	29.14	29.57	29.12	29.32	110914811.0
2009-01-27	IWM	ETF	45.07	45.82	44.72	45.38	54932300.0
2009-01-27	DIA	ETF	81.49	82.24	80.8	81.51	23352800.0
2009-01-27	GLD	ETF	88.4	88.84	88.01	88.38	11787400.0
2009-01-27	TLT	ETF	107.8	109.59	107.63	109.26	3420800.0
2009-01-27	AAXJ	ETF	30.64	31.03	30.24	30.94	46600.0
2009-01-27	ACWI	ETF	29.25	29.64	29.15	29.48	168100.0
2009-01-27	ACWX	ETF	27.13	27.39	26.97	27.33	122191.0
2009-01-27	ADRE	ETF	25.73	25.99	25.55	25.73	305487.0
2009-01-27	AFK	ETF	18.484	18.484	18.484	18.484	200.0
2009-01-27	AGG	ETF	101.63	102.5	101.45	102.34	541200.0
2009-01-27	AGQ	ETF	69.88	71.82	68.94	69.1	18400.0
2009-01-27	AGZ	ETF	108.12	108.4	108.08	108.4	1857.0
2009-01-27	AIA	ETF	23.04	23.476	23.04	23.13	57650.0
2009-01-27	AIQ	ETF	42.3	44.3	42.3	44.05	64825.0
2009-01-27	AIS	ETF	0.4601	0.48	0.4601	0.48	10400.0
2009-01-27	AIVI	ETF	28.91	29.1	28.53	29.04	16400.0
2009-01-27	AOA	ETF	22.4	22.55	20.12	22.41	61000.0
2009-01-27	AOK	ETF	25.19	25.24	24.94	25.2	3750.0
2009-01-27	AOM	ETF	24.43	24.94	24.43	24.94	10624.0
2009-01-27	AOR	ETF	23.71	23.73	23.6	23.73	11068.0
2009-01-27	ARB	ETF	14.38	15.18	14.38	14.74	219071.0
2009-01-27	BAL	ETF	29.97	30.46	29.89	30.24	3950.0
2009-01-27	BBH	ETF	55.7133	56.6333	55.7133	56.3133	146700.0
2009-01-27	BIL	ETF	91.78	91.78	91.66	91.72	105150.0
2009-01-27	BITS	ETF	19.72	19.8	17.9368	19.6	1502.0
2009-01-27	BIV	ETF	77.27	78.16	77.18	78.04	50700.0
2009-01-27	BJK	ETF	16.15	16.19	16.13	16.14	1300.0
2009-01-27	BKF	ETF	22.36	22.68	22.0	22.51	13704.0
2009-01-27	BLV	ETF	75.57	77.0	75.47	77.0	19800.0
2009-01-27	BMVP	ETF	10.327	10.453	10.273	10.423	37375.0
2009-01-27	BND	ETF	77.31	77.97	77.28	77.77	382400.0
2009-01-27	BNE	ETF	2.29	2.58	2.0	2.58	579820.0
2009-01-27	BSV	ETF	78.92	79.94	78.65	79.87	162700.0
2009-01-27	BTF	ETF	45.99999999999999	46.5	45.4	45.949999999999996	4467.400000000001
2009-01-27	BWX	ETF	25.75	25.825	25.705	25.805	162338.0
2009-01-27	BWZ	ETF	33.45	33.45	33.05	33.05	30400.0
2009-01-27	CBON	ETF	2.8	2.835	2.7	2.83	12616.0
2009-01-27	CDL	ETF	0.21	0.22	0.2	0.21	883766.0
2009-01-27	CEF	ETF	10.4	10.67	10.3	10.5	3325500.0
2009-01-27	CGO	ETF	9.53	9.76	9.5	9.62	33575.0
2009-01-27	CGW	ETF	12.94	13.06	12.7553	12.93	38262.0
2009-01-27	CHB	ETF	0.54	0.56	0.48	0.51	611420.0
2009-01-27	CHI	ETF	9.21	9.24	8.9	9.0	236363.0
2009-01-27	CHIC	ETF	4.56	4.61	4.45	4.58	174252.0
2009-01-27	CHW	ETF	5.79	6.01	5.79	6.01	221108.0
2009-01-27	CHY	ETF	8.98	9.01	8.7	8.8	194295.0
2009-01-27	CMF	ETF	50.745	51.135	50.5725	50.9	3408.0
2009-01-27	CNXT	ETF	0.67	0.699	0.67	0.69	79699.0

> showing 50 of 630 rows — these rows as CSV

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