PREVIEW / etf_1min / 2014-07-28

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-07-28.parquet
  size:    2.1 MB
  rows:    107,070

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-28 04:09:00	SPY	ETF	197.49	197.49	197.49	197.49	100.0
2014-07-28 04:36:00	SPY	ETF	197.51	197.51	197.51	197.51	107.0
2014-07-28 04:38:00	SPY	ETF	197.47	197.47	197.47	197.47	500.0
2014-07-28 04:40:00	SPY	ETF	197.45	197.45	197.45	197.45	200.0
2014-07-28 04:41:00	SPY	ETF	197.43	197.43	197.43	197.43	126.0
2014-07-28 04:44:00	SPY	ETF	197.45	197.45	197.45	197.45	149.0
2014-07-28 04:45:00	SPY	ETF	197.43	197.43	197.43	197.43	213.0
2014-07-28 04:49:00	SPY	ETF	197.42	197.42	197.42	197.42	100.0
2014-07-28 05:07:00	SPY	ETF	197.43	197.43	197.43	197.43	198.0
2014-07-28 05:22:00	SPY	ETF	197.51	197.51	197.51	197.51	100.0
2014-07-28 05:23:00	SPY	ETF	197.6	197.6	197.6	197.6	174.0
2014-07-28 05:31:00	SPY	ETF	197.53	197.53	197.53	197.53	200.0
2014-07-28 05:44:00	SPY	ETF	197.48	197.48	197.48	197.48	156.0
2014-07-28 05:51:00	SPY	ETF	197.55	197.55	197.55	197.55	200.0
2014-07-28 05:52:00	SPY	ETF	197.56	197.56	197.56	197.56	200.0
2014-07-28 06:04:00	SPY	ETF	197.52	197.52	197.51	197.51	200.0
2014-07-28 06:13:00	SPY	ETF	197.48	197.48	197.48	197.48	100.0
2014-07-28 06:17:00	SPY	ETF	197.48	197.48	197.48	197.48	157.0
2014-07-28 06:22:00	SPY	ETF	197.5	197.51	197.5	197.51	215.0
2014-07-28 06:28:00	SPY	ETF	197.58	197.59	197.58	197.59	300.0
2014-07-28 06:29:00	SPY	ETF	197.61	197.61	197.61	197.61	160.0
2014-07-28 06:33:00	SPY	ETF	197.68	197.68	197.68	197.68	200.0
2014-07-28 06:34:00	SPY	ETF	197.66	197.66	197.66	197.66	100.0
2014-07-28 06:47:00	SPY	ETF	197.6	197.6	197.6	197.6	178.0
2014-07-28 06:52:00	SPY	ETF	197.56	197.56	197.55	197.55	25000.0
2014-07-28 06:53:00	SPY	ETF	197.53	197.53	197.53	197.53	200.0
2014-07-28 06:59:00	SPY	ETF	197.59	197.59	197.59	197.59	100.0
2014-07-28 07:00:00	SPY	ETF	197.58	197.6	197.58	197.6	250.0
2014-07-28 07:02:00	SPY	ETF	197.59	197.59	197.59	197.59	1000.0
2014-07-28 07:03:00	SPY	ETF	197.55	197.55	197.55	197.55	200.0
2014-07-28 07:04:00	SPY	ETF	197.6	197.6	197.6	197.6	200.0
2014-07-28 07:10:00	SPY	ETF	197.63	197.63	197.62	197.62	2150.0
2014-07-28 07:11:00	SPY	ETF	197.62	197.62	197.61	197.61	2900.0
2014-07-28 07:13:00	SPY	ETF	197.57	197.57	197.57	197.57	250.0
2014-07-28 07:14:00	SPY	ETF	197.54	197.54	197.5	197.5	3300.0
2014-07-28 07:15:00	SPY	ETF	197.5	197.5	197.49	197.49	600.0
2014-07-28 07:16:00	SPY	ETF	197.52	197.52	197.41	197.41	17210.0
2014-07-28 07:17:00	SPY	ETF	197.4	197.45	197.4	197.42	3969.0
2014-07-28 07:18:00	SPY	ETF	197.42	197.45	197.42	197.45	997.0
2014-07-28 07:19:00	SPY	ETF	197.47	197.48	197.47	197.48	200.0
2014-07-28 07:20:00	SPY	ETF	197.48	197.48	197.45	197.45	14420.0
2014-07-28 07:22:00	SPY	ETF	197.43	197.43	197.43	197.43	170.0
2014-07-28 07:24:00	SPY	ETF	197.48	197.5	197.48	197.5	13500.0
2014-07-28 07:25:00	SPY	ETF	197.48	197.48	197.48	197.48	1500.0
2014-07-28 07:26:00	SPY	ETF	197.49	197.5	197.47	197.47	20200.0
2014-07-28 07:27:00	SPY	ETF	197.47	197.49	197.47	197.49	1100.0
2014-07-28 07:28:00	SPY	ETF	197.5	197.5	197.5	197.5	100.0
2014-07-28 07:29:00	SPY	ETF	197.5	197.5	197.5	197.5	1500.0
2014-07-28 07:30:00	SPY	ETF	197.44	197.45	197.44	197.45	1343.0
2014-07-28 07:32:00	SPY	ETF	197.43	197.43	197.43	197.43	289.0

> showing 50 of 107,070 rows — these rows as CSV

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