PREVIEW / etf_daily / 2007-01-12

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-12.parquet
  size:    19 KB
  rows:    402

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
2007-01-12	SPY	ETF	142.15	143.24	142.11	143.24	55370600.0
2007-01-12	QQQ	ETF	45.02	45.35	44.97	45.31	104236332.0
2007-01-12	IWM	ETF	78.26	79.05	78.13	78.98	28392800.0
2007-01-12	DIA	ETF	124.94	125.66	124.81	125.66	5995700.0
2007-01-12	GLD	ETF	61.0	62.28	60.9	62.17	5840200.0
2007-01-12	TLT	ETF	88.15	88.84	87.9	88.04	846300.0
2007-01-12	AAA	ETF	61.7	62.0	61.69	61.94	4100.0
2007-01-12	ADRE	ETF	37.64	38.1	37.4001	38.1	159129.0
2007-01-12	AGG	ETF	99.8	99.85	99.6	99.67	232500.0
2007-01-12	AIQ	ETF	34.8	35.45	34.0	35.25	36160.0
2007-01-12	AIS	ETF	1.27	1.27	1.2201	1.25	191400.0
2007-01-12	ARB	ETF	46.2	46.88	46.07	46.41	226100.0
2007-01-12	BAB	ETF	106.68	108.75	106.29	108.45	132700.0
2007-01-12	BBC	ETF	4.77	4.98	4.71	4.91	237600.0
2007-01-12	BBH	ETF	64.7333	65.2033	64.4	64.8667	675300.0
2007-01-12	BITS	ETF	36.96	37.8624	36.96	37.44	23411.0
2007-01-12	BNE	ETF	15.61	15.86	15.61	15.8	77500.0
2007-01-12	BRF	ETF	14.54	14.72	14.5301	14.55	13800.0
2007-01-12	BTF	ETF	105.85000000000001	105.99999999999999	105.1	105.99999999999999	1920.0
2007-01-12	CBON	ETF	30.0699	30.17	29.99	30.12	60198.0
2007-01-12	CDL	ETF	9.93	10.05	9.91	10.02	237400.0
2007-01-12	CEF	ETF	8.81	9.09	8.79	9.07	429200.0
2007-01-12	CEW	ETF	25.7701	25.7701	25.77	25.77	300.0
2007-01-12	CGO	ETF	16.84	16.867	16.54	16.7	51800.0
2007-01-12	CHB	ETF	8.35	8.53	8.28	8.36	787800.0
2007-01-12	CHI	ETF	19.93	20.0	19.82	19.87	72300.0
2007-01-12	CHIC	ETF	32.36	33.1	32.26	32.93	427438.0
2007-01-12	CHY	ETF	17.04	17.06	16.96	17.03	136800.0
2007-01-12	CIL	ETF	25.32	25.32	25.32	25.32	400.0
2007-01-12	CN	ETF	49.1	49.45	48.04	49.33	114900.0
2007-01-12	CNXT	ETF	2.08	2.09	2.06	2.09	6760656.0
2007-01-12	CPI	ETF	23.5	23.5	23.21	23.4	800.0
2007-01-12	CPST	ETF	1.12	1.13	1.08	1.09	2127103.0
2007-01-12	CSA	ETF	22.3	22.3	21.9024	21.94	61300.0
2007-01-12	CSB	ETF	33.87	34.1	33.82	34.0	32300.0
2007-01-12	CSD	ETF	25.25	25.38	25.25	25.38	2700.0
2007-01-12	CSQ	ETF	15.56	15.59	15.49	15.52	301400.0
2007-01-12	CTEC	ETF	94.0	94.14999999999999	92.79999999999998	93.49999999999999	7060.6
2007-01-12	CVY	ETF	26.37	26.46	26.35	26.44	22900.0
2007-01-12	DBA	ETF	25.3	27.3	25.3	27.1	333500.0
2007-01-12	DBB	ETF	24.45	24.45	24.02	24.12	8900.0
2007-01-12	DBC	ETF	22.65	23.2	22.5	23.18	328400.0
2007-01-12	DBE	ETF	22.95	23.43	22.95	23.43	38700.0
2007-01-12	DBO	ETF	22.35	22.9	22.26	22.78	36200.0
2007-01-12	DBP	ETF	24.5	25.07	24.5	25.0	20100.0
2007-01-12	DBS	ETF	25.06	25.39	24.97	25.34	1200.0
2007-01-12	DBV	ETF	26.3	26.34	26.2	26.26	143700.0
2007-01-12	DDM	ETF	6.9392	7.0117	6.9283	6.9958	710400.0
2007-01-12	DEF	ETF	25.28	25.37	25.28	25.35	7300.0
2007-01-12	DES	ETF	19.0833	19.18	19.0833	19.18	46200.0

> showing 50 of 402 rows — these rows as CSV

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