PREVIEW / etf_daily / 2015-03-04

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-04.parquet
  size:    47 KB
  rows:    1,165

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
2015-03-04	SPY	ETF	210.4	210.49	209.06	210.23	114497200.0
2015-03-04	QQQ	ETF	108.51	108.67	107.86	108.45	21007420.0
2015-03-04	IWM	ETF	122.21	122.61	121.61	122.36	22822500.0
2015-03-04	DIA	ETF	181.41	181.41	180.13	180.78	3820200.0
2015-03-04	GLD	ETF	115.7	115.79	115.02	115.11	4762400.0
2015-03-04	TLT	ETF	126.94	127.04	126.16	126.45	6478900.0
2015-03-04	AADR	ETF	39.18	39.18	38.81	38.81	700.0
2015-03-04	AAXJ	ETF	63.08	63.36	62.98	63.27	764500.0
2015-03-04	ACWI	ETF	60.61	60.61	60.2	60.55	1234800.0
2015-03-04	ACWV	ETF	71.59	71.72	71.23	71.55	62500.0
2015-03-04	ACWX	ETF	44.74	44.84	44.5101	44.81	311716.0
2015-03-04	ADRE	ETF	35.61	35.8299	35.44	35.8299	6289.0
2015-03-04	AFK	ETF	25.79	25.79	25.59	25.73	23680.0
2015-03-04	AGG	ETF	110.44	110.51	110.28	110.37	1477100.0
2015-03-04	AGQ	ETF	40.11	40.27	39.08	39.6	143400.0
2015-03-04	AGZ	ETF	113.3	113.75	113.3	113.6799	15668.0
2015-03-04	AGZD	ETF	24.63	24.675	24.565	24.565	4400.0
2015-03-04	AIA	ETF	49.31	49.31	48.859	49.09	10074.0
2015-03-04	AIQ	ETF	22.88	23.0	22.57	22.74	9664.0
2015-03-04	AIRR	ETF	18.331	18.331	18.11	18.23	587900.0
2015-03-04	AIVI	ETF	44.95	45.0	44.65	44.88	15500.0
2015-03-04	AMJ	ETF	44.5	44.55	43.935	44.26	618475.0
2015-03-04	AMLP	ETF	84.85	84.95	84.1	84.5	875580.0
2015-03-04	AMZA	ETF	225.6	225.6	219.0	220.4	480.0
2015-03-04	ANGL	ETF	27.09	27.41	27.09	27.34	2500.0
2015-03-04	AOA	ETF	47.75	47.75	47.31	47.6	36000.0
2015-03-04	AOK	ETF	32.99	32.99	32.68	32.7601	43204.0
2015-03-04	AOM	ETF	35.63	35.7199	35.4001	35.55	50954.0
2015-03-04	AOR	ETF	40.95	40.95	40.69	40.87	52238.0
2015-03-04	ARGT	ETF	20.1	20.18	20.05	20.18	8700.0
2015-03-04	ARKG	ETF	23.28	23.28	22.856	23.05	2000.0
2015-03-04	ARKK	ETF	21.08	21.219	21.08	21.219	300.0
2015-03-04	ARKQ	ETF	20.26	20.31	20.26	20.31	300.0
2015-03-04	ARKW	ETF	22.0	22.0	21.966	22.0	800.0
2015-03-04	ASEA	ETF	15.63	15.63	15.5	15.56	7800.0
2015-03-04	ASHR	ETF	35.71	35.75	35.51	35.69	335300.0
2015-03-04	ASHS	ETF	40.51	40.67	40.48	40.64	5400.0
2015-03-04	ATMP	ETF	29.48	29.6	29.42	29.58	33000.0
2015-03-04	AVIV	ETF	36.1	36.46	35.93	35.99	102456.0
2015-03-04	AWAY	ETF	31.5	31.885	30.88	31.01	1391687.0
2015-03-04	BAB	ETF	30.22	30.22	29.91	29.93	408294.0
2015-03-04	BAL	ETF	43.09	43.28	42.96	43.15	4501.0
2015-03-04	BALT	ETF	1.65	1.7	1.62	1.63	326226.0
2015-03-04	BAR	ETF	2.8	2.8	2.748	2.748	8110.0
2015-03-04	BBC	ETF	31.69	32.44	31.19	32.36	28041.0
2015-03-04	BBH	ETF	127.86	129.62	127.03	128.95	46000.0
2015-03-04	BBP	ETF	30.45	30.8	29.98	30.776	10200.0
2015-03-04	BCHP	ETF	19.45	19.45	19.14	19.31	1151.0
2015-03-04	BCM	ETF	31.77	31.77	31.43	31.59	22156.0
2015-03-04	BFOR	ETF	8.185	8.185	8.13	8.1675	48400.0

> showing 50 of 1,165 rows — these rows as CSV

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