PREVIEW / etf_1min / 2014-07-09

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-07-09.parquet
  size:    2.1 MB
  rows:    108,243

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-09 04:01:00	SPY	ETF	196.5	196.5	196.5	196.5	504.0
2014-07-09 04:02:00	SPY	ETF	196.47	196.47	196.47	196.47	100.0
2014-07-09 04:08:00	SPY	ETF	196.49	196.49	196.49	196.49	250.0
2014-07-09 04:13:00	SPY	ETF	196.57	196.57	196.57	196.57	100.0
2014-07-09 04:14:00	SPY	ETF	196.58	196.58	196.58	196.58	700.0
2014-07-09 04:17:00	SPY	ETF	196.58	196.58	196.58	196.58	113.0
2014-07-09 04:18:00	SPY	ETF	196.59	196.59	196.59	196.59	215.0
2014-07-09 04:22:00	SPY	ETF	196.56	196.56	196.56	196.56	100.0
2014-07-09 04:23:00	SPY	ETF	196.58	196.58	196.58	196.58	100.0
2014-07-09 04:24:00	SPY	ETF	196.59	196.59	196.59	196.59	400.0
2014-07-09 04:26:00	SPY	ETF	196.58	196.58	196.58	196.58	138.0
2014-07-09 04:36:00	SPY	ETF	196.52	196.52	196.52	196.52	100.0
2014-07-09 04:38:00	SPY	ETF	196.51	196.51	196.51	196.51	187.0
2014-07-09 04:48:00	SPY	ETF	196.48	196.48	196.48	196.48	194.0
2014-07-09 04:58:00	SPY	ETF	196.48	196.48	196.48	196.48	199.0
2014-07-09 05:01:00	SPY	ETF	196.44	196.44	196.44	196.44	100.0
2014-07-09 05:02:00	SPY	ETF	196.46	196.46	196.46	196.46	126.0
2014-07-09 05:06:00	SPY	ETF	196.43	196.43	196.43	196.43	100.0
2014-07-09 05:11:00	SPY	ETF	196.48	196.48	196.48	196.48	100.0
2014-07-09 05:12:00	SPY	ETF	196.51	196.51	196.51	196.51	153.0
2014-07-09 05:14:00	SPY	ETF	196.49	196.49	196.49	196.49	1000.0
2014-07-09 05:15:00	SPY	ETF	196.51	196.51	196.51	196.51	128.0
2014-07-09 05:18:00	SPY	ETF	196.47	196.47	196.47	196.47	100.0
2014-07-09 05:29:00	SPY	ETF	196.4	196.42	196.4	196.42	1151.0
2014-07-09 05:33:00	SPY	ETF	196.51	196.51	196.51	196.51	143.0
2014-07-09 05:35:00	SPY	ETF	196.41	196.48	196.41	196.48	600.0
2014-07-09 05:40:00	SPY	ETF	196.46	196.46	196.46	196.46	1100.0
2014-07-09 05:43:00	SPY	ETF	196.48	196.48	196.48	196.48	100.0
2014-07-09 05:47:00	SPY	ETF	196.47	196.47	196.47	196.47	100.0
2014-07-09 05:52:00	SPY	ETF	196.51	196.51	196.51	196.51	200.0
2014-07-09 05:54:00	SPY	ETF	196.53	196.53	196.53	196.53	500.0
2014-07-09 05:57:00	SPY	ETF	196.52	196.52	196.52	196.52	4800.0
2014-07-09 06:08:00	SPY	ETF	196.54	196.54	196.54	196.54	200.0
2014-07-09 06:10:00	SPY	ETF	196.54	196.54	196.54	196.54	800.0
2014-07-09 06:11:00	SPY	ETF	196.58	196.59	196.58	196.59	400.0
2014-07-09 06:12:00	SPY	ETF	196.62	196.62	196.62	196.62	2600.0
2014-07-09 06:14:00	SPY	ETF	196.63	196.63	196.63	196.63	250.0
2014-07-09 06:16:00	SPY	ETF	196.64	196.64	196.64	196.64	700.0
2014-07-09 06:18:00	SPY	ETF	196.59	196.59	196.59	196.59	4100.0
2014-07-09 06:22:00	SPY	ETF	196.6	196.62	196.6	196.62	2417.0
2014-07-09 06:24:00	SPY	ETF	196.63	196.64	196.63	196.64	1000.0
2014-07-09 06:25:00	SPY	ETF	196.64	196.64	196.64	196.64	686.0
2014-07-09 06:26:00	SPY	ETF	196.66	196.66	196.66	196.66	400.0
2014-07-09 06:28:00	SPY	ETF	196.64	196.64	196.64	196.64	5200.0
2014-07-09 06:31:00	SPY	ETF	196.59	196.59	196.59	196.59	228.0
2014-07-09 06:42:00	SPY	ETF	196.59	196.59	196.57	196.57	4835.0
2014-07-09 06:43:00	SPY	ETF	196.55	196.55	196.52	196.52	1318.0
2014-07-09 06:44:00	SPY	ETF	196.52	196.52	196.52	196.52	2200.0
2014-07-09 06:45:00	SPY	ETF	196.52	196.52	196.51	196.51	200.0
2014-07-09 06:51:00	SPY	ETF	196.56	196.56	196.56	196.56	200.0

> showing 50 of 108,243 rows — these rows as CSV

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