PREVIEW / etf_1min / 2014-07-03

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-07-03.parquet
  size:    1.4 MB
  rows:    69,950

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2014-07-03 04:07:00	SPY	ETF	197.38	197.38	197.38	197.38	183.0
2014-07-03 05:20:00	SPY	ETF	197.32	197.32	197.32	197.32	100.0
2014-07-03 05:33:00	SPY	ETF	197.32	197.32	197.32	197.32	100.0
2014-07-03 05:35:00	SPY	ETF	197.24	197.37	197.24	197.37	400.0
2014-07-03 05:37:00	SPY	ETF	197.38	197.4	197.38	197.4	800.0
2014-07-03 05:46:00	SPY	ETF	197.42	197.42	197.42	197.42	500.0
2014-07-03 05:47:00	SPY	ETF	197.45	197.45	197.45	197.45	100.0
2014-07-03 05:58:00	SPY	ETF	197.4	197.4	197.4	197.4	100.0
2014-07-03 06:15:00	SPY	ETF	197.46	197.46	197.46	197.46	200.0
2014-07-03 06:16:00	SPY	ETF	197.46	197.46	197.46	197.46	294.0
2014-07-03 06:17:00	SPY	ETF	197.45	197.45	197.45	197.45	100.0
2014-07-03 06:24:00	SPY	ETF	197.42	197.42	197.42	197.42	200.0
2014-07-03 06:27:00	SPY	ETF	197.45	197.45	197.45	197.45	100.0
2014-07-03 06:29:00	SPY	ETF	197.46	197.46	197.46	197.46	200.0
2014-07-03 06:40:00	SPY	ETF	197.44	197.44	197.44	197.44	200.0
2014-07-03 06:47:00	SPY	ETF	197.46	197.46	197.46	197.46	200.0
2014-07-03 06:51:00	SPY	ETF	197.43	197.43	197.43	197.43	500.0
2014-07-03 07:00:00	SPY	ETF	197.44	197.44	197.44	197.44	200.0
2014-07-03 07:04:00	SPY	ETF	197.43	197.43	197.43	197.43	100.0
2014-07-03 07:09:00	SPY	ETF	197.46	197.47	197.46	197.47	6000.0
2014-07-03 07:10:00	SPY	ETF	197.45	197.45	197.45	197.45	100.0
2014-07-03 07:16:00	SPY	ETF	197.46	197.49	197.45	197.49	57378.0
2014-07-03 07:19:00	SPY	ETF	197.48	197.49	197.48	197.49	3000.0
2014-07-03 07:21:00	SPY	ETF	197.49	197.49	197.49	197.49	1000.0
2014-07-03 07:23:00	SPY	ETF	197.45	197.49	197.45	197.48	7698.0
2014-07-03 07:24:00	SPY	ETF	197.48	197.48	197.48	197.48	1000.0
2014-07-03 07:27:00	SPY	ETF	197.45	197.45	197.45	197.45	400.0
2014-07-03 07:28:00	SPY	ETF	197.44	197.44	197.44	197.44	500.0
2014-07-03 07:30:00	SPY	ETF	197.44	197.47	197.44	197.47	10300.0
2014-07-03 07:32:00	SPY	ETF	197.45	197.45	197.44	197.44	890.0
2014-07-03 07:33:00	SPY	ETF	197.44	197.44	197.44	197.44	290.0
2014-07-03 07:35:00	SPY	ETF	197.46	197.46	197.44	197.44	400.0
2014-07-03 07:38:00	SPY	ETF	197.47	197.47	197.47	197.47	400.0
2014-07-03 07:39:00	SPY	ETF	197.45	197.45	197.44	197.44	2100.0
2014-07-03 07:41:00	SPY	ETF	197.44	197.44	197.44	197.44	300.0
2014-07-03 07:44:00	SPY	ETF	197.49	197.53	197.49	197.52	25000.0
2014-07-03 07:45:00	SPY	ETF	197.5	197.5	197.46	197.46	823.0
2014-07-03 07:46:00	SPY	ETF	197.46	197.46	197.46	197.46	100.0
2014-07-03 07:48:00	SPY	ETF	197.45	197.45	197.45	197.45	100.0
2014-07-03 07:50:00	SPY	ETF	197.44	197.44	197.44	197.44	101.0
2014-07-03 07:53:00	SPY	ETF	197.43	197.44	197.43	197.44	300.0
2014-07-03 07:54:00	SPY	ETF	197.44	197.44	197.44	197.44	200.0
2014-07-03 07:57:00	SPY	ETF	197.43	197.43	197.43	197.43	3200.0
2014-07-03 07:58:00	SPY	ETF	197.43	197.43	197.42	197.43	460.0
2014-07-03 07:59:00	SPY	ETF	197.43	197.45	197.43	197.45	8210.0
2014-07-03 08:00:00	SPY	ETF	197.45	197.45	197.43	197.43	11793.0
2014-07-03 08:01:00	SPY	ETF	197.43	197.43	197.41	197.43	14575.0
2014-07-03 08:02:00	SPY	ETF	197.43	197.43	197.41	197.41	2000.0
2014-07-03 08:03:00	SPY	ETF	197.43	197.43	197.42	197.42	3861.0
2014-07-03 08:04:00	SPY	ETF	197.46	197.47	197.46	197.47	1200.0

> showing 50 of 69,950 rows — these rows as CSV

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