PREVIEW / etf_daily / 2008-01-28

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-28.parquet
  size:    25 KB
  rows:    565

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
2008-01-28	SPY	ETF	133.26	135.52	132.06	135.24	217934600.0
2008-01-28	QQQ	ETF	44.02	44.44	43.57	44.33	163711180.0
2008-01-28	IWM	ETF	68.32	69.97	67.71	69.92	81259000.0
2008-01-28	DIA	ETF	122.02	123.8	121.0	123.53	19403800.0
2008-01-28	GLD	ETF	90.96	91.89	90.75	91.75	8533200.0
2008-01-28	TLT	ETF	95.68	96.0	95.36	95.59	1633500.0
2008-01-28	ADRE	ETF	47.92	49.49	47.55	49.35	523110.0
2008-01-28	AGG	ETF	103.01	103.36	102.97	103.22	484000.0
2008-01-28	AIA	ETF	43.04	43.04	42.4	42.94	6200.0
2008-01-28	AIQ	ETF	50.95	51.85	50.0	51.65	43092.0
2008-01-28	AIS	ETF	0.94	1.0	0.88	1.0	258900.0
2008-01-28	AIVI	ETF	63.74	64.78	63.09	64.78	35300.0
2008-01-28	ARB	ETF	40.24	41.1	39.99	41.06	227700.0
2008-01-28	BBH	ETF	53.7167	53.87	53.2367	53.6333	799500.0
2008-01-28	BIL	ETF	91.94	91.94	91.82	91.82	26100.0
2008-01-28	BITS	ETF	21.32	23.56	21.32	23.24	15632.0
2008-01-28	BIV	ETF	79.52	79.58	79.29	79.5	48300.0
2008-01-28	BJK	ETF	42.84	42.84	40.93	41.6	3900.0
2008-01-28	BKF	ETF	51.17	52.704	50.1901	52.704	24400.0
2008-01-28	BLV	ETF	78.41	78.41	78.0	78.25	14700.0
2008-01-28	BMVP	ETF	15.68	15.7233	15.2967	15.7067	72900.0
2008-01-28	BND	ETF	78.51	78.51	78.22	78.37	172100.0
2008-01-28	BNE	ETF	12.72	12.98	12.57	12.9	156400.0
2008-01-28	BRF	ETF	14.63	14.63	14.618	14.626	18900.0
2008-01-28	BSV	ETF	78.16	78.59	78.16	78.53	94400.0
2008-01-28	BTF	ETF	104.74999999999999	107.39999999999999	104.74999999999999	107.35	1340.0
2008-01-28	BWX	ETF	27.41	27.46	27.29	27.396	272950.0
2008-01-28	CBON	ETF	15.62	15.83	15.36	15.6	66920.0
2008-01-28	CDL	ETF	1.67	1.79	1.61	1.73	1881716.0
2008-01-28	CEF	ETF	11.95	12.1	11.74	12.09	837000.0
2008-01-28	CGO	ETF	16.95	17.25	16.5	17.25	22650.0
2008-01-28	CGW	ETF	22.75	23.68	21.86	23.0901	76397.0
2008-01-28	CHB	ETF	9.04	9.75	8.55	9.65	1230681.0
2008-01-28	CHI	ETF	15.84	15.96	15.69	15.77	150576.0
2008-01-28	CHIC	ETF	15.9	16.6	15.5	16.6	1071929.0
2008-01-28	CHW	ETF	12.06	12.15	11.93	12.1	140326.0
2008-01-28	CHY	ETF	14.2	14.2	14.0	14.19	159950.0
2008-01-28	CMF	ETF	53.12	53.12	53.005	53.045	29600.0
2008-01-28	CN	ETF	61.05	62.3	60.51	62.1	341200.0
2008-01-28	CNXT	ETF	0.64	0.665	0.63	0.65	3991913.0
2008-01-28	COW	ETF	45.26	45.4	44.8601	45.39	7100.0
2008-01-28	CPI	ETF	21.4	21.85	20.75	20.75	8300.0
2008-01-28	CPST	ETF	1.56	1.63	1.51	1.63	1657874.0
2008-01-28	CSA	ETF	16.18	16.65	16.12	16.3	42400.0
2008-01-28	CSD	ETF	23.85	24.33	23.51	24.33	11300.0
2008-01-28	CSQ	ETF	13.45	13.58	13.34	13.44	251430.0
2008-01-28	CUT	ETF	20.8	21.02	20.77	21.02	9900.0
2008-01-28	CVY	ETF	22.5	23.07	22.39	23.07	23200.0
2008-01-28	CWI	ETF	24.6	25.02	24.4267	24.9533	86250.0
2008-01-28	DBA	ETF	36.5	37.08	36.19	37.07	1703300.0

> showing 50 of 565 rows — these rows as CSV

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