PREVIEW / etf_1min / 2014-05-02

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-05-02.parquet
  size:    2.0 MB
  rows:    109,004

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-05-02 04:00:00	SPY	ETF	188.58	188.58	188.58	188.58	100.0
2014-05-02 04:12:00	SPY	ETF	188.5	188.5	188.5	188.5	150.0
2014-05-02 05:55:00	SPY	ETF	188.29	188.43	188.29	188.43	1700.0
2014-05-02 05:58:00	SPY	ETF	188.52	188.52	188.52	188.52	144.0
2014-05-02 06:01:00	SPY	ETF	188.5	188.5	188.5	188.5	356.0
2014-05-02 06:15:00	SPY	ETF	188.53	188.53	188.53	188.53	500.0
2014-05-02 06:33:00	SPY	ETF	188.58	188.6	188.5	188.54	18202.0
2014-05-02 06:36:00	SPY	ETF	188.56	188.56	188.54	188.54	400.0
2014-05-02 06:38:00	SPY	ETF	188.54	188.54	188.53	188.53	900.0
2014-05-02 06:40:00	SPY	ETF	188.53	188.53	188.5	188.5	400.0
2014-05-02 06:41:00	SPY	ETF	188.5	188.5	188.5	188.5	2000.0
2014-05-02 06:42:00	SPY	ETF	188.49	188.49	188.48	188.48	839.0
2014-05-02 06:43:00	SPY	ETF	188.45	188.45	188.45	188.45	329.0
2014-05-02 06:44:00	SPY	ETF	188.49	188.49	188.49	188.49	1550.0
2014-05-02 06:46:00	SPY	ETF	188.41	188.45	188.38	188.45	12000.0
2014-05-02 06:47:00	SPY	ETF	188.39	188.39	188.39	188.39	1000.0
2014-05-02 06:48:00	SPY	ETF	188.39	188.39	188.39	188.39	1089.0
2014-05-02 06:49:00	SPY	ETF	188.44	188.44	188.44	188.44	156.0
2014-05-02 06:58:00	SPY	ETF	188.42	188.42	188.42	188.42	10010.0
2014-05-02 07:01:00	SPY	ETF	188.4	188.4	188.4	188.4	100.0
2014-05-02 07:05:00	SPY	ETF	188.43	188.43	188.43	188.43	1118.0
2014-05-02 07:09:00	SPY	ETF	188.46	188.46	188.46	188.46	100.0
2014-05-02 07:10:00	SPY	ETF	188.46	188.46	188.46	188.46	180.0
2014-05-02 07:11:00	SPY	ETF	188.46	188.49	188.46	188.49	3300.0
2014-05-02 07:13:00	SPY	ETF	188.49	188.54	188.49	188.54	30300.0
2014-05-02 07:14:00	SPY	ETF	188.52	188.54	188.52	188.54	3000.0
2014-05-02 07:15:00	SPY	ETF	188.48	188.48	188.48	188.48	700.0
2014-05-02 07:20:00	SPY	ETF	188.46	188.46	188.46	188.46	2500.0
2014-05-02 07:25:00	SPY	ETF	188.44	188.44	188.44	188.44	1000.0
2014-05-02 07:30:00	SPY	ETF	188.46	188.46	188.46	188.46	1000.0
2014-05-02 07:33:00	SPY	ETF	188.45	188.46	188.45	188.46	45000.0
2014-05-02 07:34:00	SPY	ETF	188.46	188.46	188.46	188.46	76000.0
2014-05-02 07:36:00	SPY	ETF	188.46	188.46	188.46	188.46	100.0
2014-05-02 07:38:00	SPY	ETF	188.46	188.46	188.44	188.44	5100.0
2014-05-02 07:39:00	SPY	ETF	188.46	188.46	188.46	188.46	1100.0
2014-05-02 07:41:00	SPY	ETF	188.44	188.46	188.44	188.46	29500.0
2014-05-02 07:43:00	SPY	ETF	188.43	188.43	188.43	188.43	2500.0
2014-05-02 07:44:00	SPY	ETF	188.44	188.44	188.43	188.43	1500.0
2014-05-02 07:45:00	SPY	ETF	188.43	188.43	188.43	188.43	400.0
2014-05-02 07:46:00	SPY	ETF	188.45	188.45	188.45	188.45	2000.0
2014-05-02 07:48:00	SPY	ETF	188.46	188.46	188.46	188.46	800.0
2014-05-02 07:49:00	SPY	ETF	188.46	188.46	188.44	188.44	20100.0
2014-05-02 07:50:00	SPY	ETF	188.44	188.44	188.43	188.43	28450.0
2014-05-02 07:55:00	SPY	ETF	188.42	188.42	188.42	188.42	250.0
2014-05-02 07:58:00	SPY	ETF	188.45	188.49	188.45	188.49	2700.0
2014-05-02 08:00:00	SPY	ETF	188.48	188.49	188.46	188.48	1155.0
2014-05-02 08:01:00	SPY	ETF	188.47	188.5	188.47	188.5	525.0
2014-05-02 08:02:00	SPY	ETF	188.5	188.51	188.5	188.5	400.0
2014-05-02 08:03:00	SPY	ETF	188.51	188.51	188.5	188.5	1075.0
2014-05-02 08:04:00	SPY	ETF	188.42	188.42	188.42	188.42	53000.0

> showing 50 of 109,004 rows — these rows as CSV

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