PREVIEW / etf_daily / 2009-10-12

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-12.parquet
  size:    30 KB
  rows:    682

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-10-12	SPY	ETF	107.76	108.09	107.28	107.68	118031000.0
2009-10-12	QQQ	ETF	42.63	42.87	42.28	42.57	53221870.0
2009-10-12	IWM	ETF	61.79	62.03	61.14	61.43	26895500.0
2009-10-12	DIA	ETF	99.0	99.39	98.56	98.94	5438300.0
2009-10-12	GLD	ETF	103.39	103.92	103.22	103.56	9179000.0
2009-10-12	TLT	ETF	96.03	96.33	95.6	96.05	1939700.0
2009-10-12	AAXJ	ETF	53.57	53.61	53.0	53.26	177500.0
2009-10-12	ACWI	ETF	41.43	41.78	41.36	41.38	183500.0
2009-10-12	ACWX	ETF	40.78	40.8652	40.49	40.6	1762696.0
2009-10-12	ADRE	ETF	42.72	42.94	42.3788	42.5499	147337.0
2009-10-12	AFK	ETF	29.86	31.14	29.85	30.43	81660.0
2009-10-12	AGG	ETF	104.43	104.46	104.2	104.4	417000.0
2009-10-12	AGQ	ETF	130.52	132.3	129.28	129.68	175400.0
2009-10-12	AGZ	ETF	107.9	108.42	107.9	108.03	50075.0
2009-10-12	AIA	ETF	38.42	38.67	38.29	38.34	34022.0
2009-10-12	AIQ	ETF	31.75	31.75	31.2	31.25	33078.0
2009-10-12	AIS	ETF	1.15	1.16	1.12	1.13	438398.0
2009-10-12	AIVI	ETF	43.07	43.36	42.87	42.92	29900.0
2009-10-12	AMJ	ETF	25.66	25.95	25.62	25.78	271924.0
2009-10-12	AOA	ETF	29.45	29.53	29.45	29.53	3700.0
2009-10-12	AOK	ETF	27.37	27.37	27.18	27.21	4196.0
2009-10-12	AOM	ETF	27.99	27.99	27.91	27.93	51246.0
2009-10-12	AOR	ETF	28.77	28.77	28.5375	28.57	8129.0
2009-10-12	ARB	ETF	21.69	22.6	21.57	22.34	203939.0
2009-10-12	BAL	ETF	33.38	33.64	33.23	33.4	13688.0
2009-10-12	BBH	ETF	33.6167	33.6167	33.2367	33.29	134700.0
2009-10-12	BIL	ETF	91.72	91.74	91.7	91.72	101850.0
2009-10-12	BITS	ETF	22.36	22.36	21.6052	21.9196	979.0
2009-10-12	BIV	ETF	79.89	80.36	79.86	80.05	144200.0
2009-10-12	BJK	ETF	26.49	26.8	25.97	26.14	53400.0
2009-10-12	BKF	ETF	44.26	44.6	44.1	44.38	352127.0
2009-10-12	BLV	ETF	78.23	78.24	77.77	78.24	93300.0
2009-10-12	BMVP	ETF	12.223	12.303	12.21	12.249	43178.0
2009-10-12	BND	ETF	79.04	79.3	78.92	79.28	350700.0
2009-10-12	BNE	ETF	7.8	7.85	7.7425	7.77	43998.0
2009-10-12	BOSS	ETF	23.17	23.17	22.35	23.17	200.0
2009-10-12	BRF	ETF	44.05	44.45	43.58	44.12	700917.0
2009-10-12	BSV	ETF	79.96	80.09	79.83	79.95	225400.0
2009-10-12	BTF	ETF	60.3	61.050000000000004	60.3	60.75	9880.400000000001
2009-10-12	BWX	ETF	29.43	29.505	29.3839	29.495	286000.0
2009-10-12	BWZ	ETF	37.48	37.62	37.39	37.6055	137608.0
2009-10-12	BZQ	ETF	4484.8	4598.4	4468.8	4540.8	61.0
2009-10-12	CEF	ETF	13.78	13.88	13.69	13.78	747600.0
2009-10-12	CEW	ETF	21.96	21.989	21.92	21.98	61659.0
2009-10-12	CGO	ETF	14.22	14.36	14.18	14.2	20286.0
2009-10-12	CGW	ETF	17.86	17.93	17.72	17.81	66007.0
2009-10-12	CHB	ETF	0.44	0.45	0.42	0.44	1801742.0
2009-10-12	CHI	ETF	11.87	11.95	11.72	11.7697	141737.0
2009-10-12	CHIC	ETF	17.5	17.51	17.48	17.48	102874.0
2009-10-12	CHW	ETF	7.84	7.89	7.77	7.8	144467.0

> showing 50 of 682 rows — these rows as CSV

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