PREVIEW / etf_daily / 2007-12-12

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-12.parquet
  size:    25 KB
  rows:    553

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-12-12	SPY	ETF	151.06	151.77	147.2	149.37	322435600.0
2007-12-12	QQQ	ETF	52.25	52.43	50.89	51.78	162975125.0
2007-12-12	IWM	ETF	78.71	78.81	76.09	76.91	112505300.0
2007-12-12	DIA	ETF	136.94	137.12	133.33	135.0	15786800.0
2007-12-12	GLD	ETF	80.05	80.92	79.94	80.49	9702500.0
2007-12-12	TLT	ETF	91.45	92.65	91.27	92.03	2225400.0
2007-12-12	ADRE	ETF	57.39	57.93	55.86	57.08	488375.0
2007-12-12	AGG	ETF	100.77	101.23	100.52	101.05	500900.0
2007-12-12	AIA	ETF	50.36	50.36	47.88	48.56	68800.0
2007-12-12	AIQ	ETF	48.2	48.55	46.8	47.3	40852.0
2007-12-12	AIS	ETF	1.08	1.09	1.05	1.05	165600.0
2007-12-12	AIVI	ETF	75.95	76.2	74.52	75.08	59100.0
2007-12-12	ARB	ETF	42.29	42.29	40.5	41.22	286600.0
2007-12-12	BBH	ETF	56.0	57.93	56.0	57.6	331800.0
2007-12-12	BIL	ETF	91.76	91.8	91.68	91.76	24700.0
2007-12-12	BITS	ETF	22.92	24.56	22.92	24.0	10373.0
2007-12-12	BIV	ETF	76.66	77.22	76.6	77.04	34400.0
2007-12-12	BKF	ETF	61.61	61.98	60.15	60.68	26900.0
2007-12-12	BLV	ETF	75.55	76.21	75.53	75.97	17900.0
2007-12-12	BMVP	ETF	17.5033	17.5933	17.2567	17.4367	49206.0
2007-12-12	BND	ETF	76.43	76.83	76.37	76.73	133600.0
2007-12-12	BNE	ETF	18.43	18.43	17.87	17.99	147400.0
2007-12-12	BRF	ETF	14.59	14.59	14.58	14.58	4500.0
2007-12-12	BSV	ETF	77.01	77.09	76.82	77.06	102900.0
2007-12-12	BTF	ETF	115.99999999999999	117.44999999999999	115.29999999999998	115.29999999999998	41060.0
2007-12-12	BWX	ETF	27.37	27.37	26.705	26.81	53284.0
2007-12-12	CBON	ETF	18.41	18.41	16.55	17.32	127523.0
2007-12-12	CDL	ETF	2.15	2.24	2.02	2.07	2071004.0
2007-12-12	CEF	ETF	10.78	10.78	10.65	10.71	261100.0
2007-12-12	CGO	ETF	19.55	19.7299	19.17	19.35	23400.0
2007-12-12	CGW	ETF	26.31	26.338	25.55	25.8	58700.0
2007-12-12	CHB	ETF	9.04	9.53	8.75	9.02	1351246.0
2007-12-12	CHI	ETF	14.15	14.37	13.89	13.98	326200.0
2007-12-12	CHIC	ETF	16.07	16.22	15.45	15.66	600216.0
2007-12-12	CHW	ETF	12.72	12.86	12.34	12.63	412700.0
2007-12-12	CHY	ETF	13.46	13.6512	13.17	13.19	236700.0
2007-12-12	CMF	ETF	51.825	52.16	51.825	52.16	2400.0
2007-12-12	CN	ETF	63.04	64.29	60.54	61.83	221100.0
2007-12-12	CNXT	ETF	1.1	1.11	1.04	1.05	5605073.0
2007-12-12	COW	ETF	48.92	49.048	48.53	49.048	1800.0
2007-12-12	CPI	ETF	25.3	25.3	23.61	24.45	900.0
2007-12-12	CPST	ETF	1.35	1.5	1.34	1.43	10386706.0
2007-12-12	CSA	ETF	16.25	16.58	15.96	16.0	23200.0
2007-12-12	CSD	ETF	27.79	27.81	27.35	27.59	12000.0
2007-12-12	CSQ	ETF	14.34	14.52	14.14	14.22	473700.0
2007-12-12	CUT	ETF	26.89	28.91	24.49	24.49	26900.0
2007-12-12	CVY	ETF	24.6	24.6	23.93	24.14	34000.0
2007-12-12	CWI	ETF	29.72	29.72	28.8267	29.1067	135300.0
2007-12-12	CZA	ETF	26.2599	26.28	26.23	26.23	400.0
2007-12-12	DBA	ETF	32.18	32.67	32.06	32.63	677100.0

> showing 50 of 553 rows — these rows as CSV

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