PREVIEW / etf_daily / 2009-10-28

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-28.parquet
  size:    30 KB
  rows:    683

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-28	SPY	ETF	106.15	106.48	104.35	104.41	248821400.0
2009-10-28	QQQ	ETF	42.19	42.32	41.3	41.39	143553508.0
2009-10-28	IWM	ETF	58.59	58.8	56.59	56.83	84951000.0
2009-10-28	DIA	ETF	98.62	99.07	97.62	97.68	17191500.0
2009-10-28	GLD	ETF	101.5	102.03	100.65	100.73	19344900.0
2009-10-28	TLT	ETF	95.14	95.8	94.96	95.45	4585400.0
2009-10-28	AAXJ	ETF	52.27	52.64	51.25	51.48	212400.0
2009-10-28	ACWI	ETF	40.73	40.8	39.77	39.88	726600.0
2009-10-28	ACWX	ETF	39.73	39.73	38.77	38.77	216358.0
2009-10-28	ADRE	ETF	41.87	41.87	40.14	40.19	461137.0
2009-10-28	AFK	ETF	28.63	28.76	27.33	27.96	111324.0
2009-10-28	AGG	ETF	104.48	104.66	104.33	104.62	651700.0
2009-10-28	AGQ	ETF	109.42	111.32	105.84	106.26	271950.0
2009-10-28	AGZ	ETF	108.57	108.71	108.48	108.6783	15239.0
2009-10-28	AIA	ETF	38.26	38.32	37.33	37.4126	59981.0
2009-10-28	AIQ	ETF	28.75	29.55	26.35	26.9	125414.0
2009-10-28	AIS	ETF	1.13	1.17	1.07	1.09	659646.0
2009-10-28	AIVI	ETF	42.39	42.39	41.08	41.25	30300.0
2009-10-28	AMJ	ETF	26.2	26.245	25.33	25.46	148059.0
2009-10-28	AOA	ETF	28.85	28.85	28.24	28.33	18400.0
2009-10-28	AOK	ETF	27.13	27.13	26.94	26.97	6219.0
2009-10-28	AOM	ETF	27.73	27.73	27.5	27.5	3000.0
2009-10-28	AOR	ETF	28.25	28.25	27.85	27.87	5278.0
2009-10-28	ARB	ETF	22.86	23.0	21.65	21.74	347419.0
2009-10-28	BAL	ETF	34.6693	34.7	34.36	34.6999	6400.0
2009-10-28	BBH	ETF	30.5967	31.2733	30.5967	30.66	511200.0
2009-10-28	BIL	ETF	91.7	91.72	91.7	91.7	79600.0
2009-10-28	BITS	ETF	25.12	25.48	24.44	24.64	1437.0
2009-10-28	BIV	ETF	80.04	80.39	79.96	80.12	131900.0
2009-10-28	BJK	ETF	24.08	24.37	23.3	23.37	72300.0
2009-10-28	BKF	ETF	43.63	43.8	41.8	41.81	516476.0
2009-10-28	BLV	ETF	78.42	78.8	78.0	78.65	21700.0
2009-10-28	BMVP	ETF	11.98	11.98	11.73	11.74	34303.0
2009-10-28	BND	ETF	79.17	79.29	78.89	79.1	766700.0
2009-10-28	BNE	ETF	6.85	7.03	6.53	6.65	211904.0
2009-10-28	BOSS	ETF	21.37	22.03	20.83	21.37	100.0
2009-10-28	BRF	ETF	42.79	43.0	39.8	40.22	1609976.0
2009-10-28	BSV	ETF	79.91	79.99	79.82	79.95	486700.0
2009-10-28	BTF	ETF	59.65	60.99999999999999	58.3	59.74999999999999	17008.0
2009-10-28	BWX	ETF	29.25	29.25	29.065	29.14	269158.0
2009-10-28	BWZ	ETF	37.4	37.4	37.3094	37.31	24873.0
2009-10-28	BZQ	ETF	4713.6	5257.6	4689.6	5243.2	210.0
2009-10-28	CEF	ETF	13.2	13.27	13.09	13.13	1071100.0
2009-10-28	CEW	ETF	21.7	21.7919	21.51	21.6	66318.0
2009-10-28	CGO	ETF	13.93	14.02	12.94	13.07	49462.0
2009-10-28	CGW	ETF	17.39	17.4057	17.0	17.01	75134.0
2009-10-28	CHB	ETF	0.28	0.28	0.18	0.19	6257380.0
2009-10-28	CHI	ETF	11.78	11.91	11.32	11.36	265271.0
2009-10-28	CHW	ETF	7.84	7.87	7.53	7.55	265671.0
2009-10-28	CHY	ETF	11.67	11.73	11.05	11.06	237888.0

> showing 50 of 683 rows — these rows as CSV

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