PREVIEW / etf_daily / 2007-11-09

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-09.parquet
  size:    24 KB
  rows:    532

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-11-09	SPY	ETF	145.69	147.54	144.89	145.14	277745100.0
2007-11-09	QQQ	ETF	50.73	51.12	50.0	50.0	309419820.0
2007-11-09	IWM	ETF	76.74	77.75	76.13	76.85	104492000.0
2007-11-09	DIA	ETF	131.29	132.08	130.18	130.31	20911400.0
2007-11-09	GLD	ETF	81.79	82.63	81.22	82.18	6947800.0
2007-11-09	TLT	ETF	91.04	91.59	90.93	91.33	887200.0
2007-11-09	ADRE	ETF	55.21	56.49	54.36	55.15	431128.0
2007-11-09	AGG	ETF	100.67	100.84	100.55	100.8	184600.0
2007-11-09	AIQ	ETF	45.55	45.55	43.75	44.4	44360.0
2007-11-09	AIS	ETF	1.1	1.13	1.07	1.12	197300.0
2007-11-09	AIVI	ETF	73.59	74.0	72.88	73.05	112100.0
2007-11-09	ARB	ETF	49.13	49.71	48.6	48.69	289600.0
2007-11-09	BBH	ETF	59.5067	59.5067	58.4867	58.4867	257100.0
2007-11-09	BIL	ETF	91.78	91.8	91.7	91.74	9400.0
2007-11-09	BITS	ETF	25.32	25.4	24.0	25.24	16613.0
2007-11-09	BIV	ETF	76.59	76.73	76.48	76.7	11700.0
2007-11-09	BLV	ETF	76.0	76.32	76.0	76.18	22700.0
2007-11-09	BMVP	ETF	16.9733	17.1533	16.9133	16.9533	61100.0
2007-11-09	BND	ETF	76.51	76.51	76.15	76.3	36000.0
2007-11-09	BNE	ETF	16.65	17.01	16.59	16.77	228300.0
2007-11-09	BRF	ETF	14.67	14.72	14.59	14.72	5700.0
2007-11-09	BSV	ETF	76.79	76.79	76.6	76.71	38500.0
2007-11-09	BTF	ETF	112.35	112.85	112.10000000000001	112.10000000000001	520.0
2007-11-09	BWX	ETF	27.235	27.235	27.1	27.2	213200.0
2007-11-09	CBON	ETF	19.24	20.08	18.96	19.66	94850.0
2007-11-09	CDL	ETF	3.7	3.78	2.31	2.4	11581124.0
2007-11-09	CEF	ETF	10.9	11.08	10.74	10.93	557400.0
2007-11-09	CGO	ETF	18.34	18.93	18.34	18.9299	23201.0
2007-11-09	CGW	ETF	25.1	25.45	25.1	25.45	58000.0
2007-11-09	CHB	ETF	10.54	10.63	10.16	10.4	2110800.0
2007-11-09	CHI	ETF	14.81	15.1873	14.67	15.05	220101.0
2007-11-09	CHIC	ETF	12.86	13.98	12.81	13.37	906654.0
2007-11-09	CHW	ETF	12.37	12.5	12.1	12.39	195400.0
2007-11-09	CHY	ETF	13.05	13.26	13.03	13.2	269131.0
2007-11-09	CMF	ETF	51.65	51.65	51.65	51.65	6000.0
2007-11-09	CN	ETF	55.5	55.5	52.11	53.44	208100.0
2007-11-09	CNXT	ETF	1.18	1.21	1.14	1.17	6032822.0
2007-11-09	COW	ETF	48.2	48.88	48.2	48.7982	700.0
2007-11-09	CPI	ETF	24.0	24.0	24.0	24.0	100.0
2007-11-09	CPST	ETF	1.23	1.29	1.16	1.25	3760501.0
2007-11-09	CSA	ETF	16.26	16.52	16.05	16.28	83900.0
2007-11-09	CSD	ETF	27.7	27.7	27.12	27.31	14900.0
2007-11-09	CSM	ETF	1.4725	1.4725	1.4725	1.4725	800.0
2007-11-09	CSQ	ETF	13.83	14.1	13.52	13.92	299701.0
2007-11-09	CUT	ETF	25.2	25.2	24.9	24.9	12400.0
2007-11-09	CVY	ETF	24.4	24.76	24.36	24.58	13500.0
2007-11-09	CWI	ETF	28.6533	28.84	28.44	28.5867	28200.0
2007-11-09	CZA	ETF	26.08	26.08	25.89	25.89	200.0
2007-11-09	DBA	ETF	29.95	29.95	29.46	29.87	306900.0
2007-11-09	DBB	ETF	24.9	24.92	24.69	24.8	40500.0

> showing 50 of 532 rows — these rows as CSV

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