PREVIEW / etf_1min / 2012-07-27

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-07-27.parquet
  size:    2.1 MB
  rows:    104,294

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
2012-07-27 04:00:00	SPY	ETF	136.12	136.12	136.12	136.12	250.0
2012-07-27 04:27:00	SPY	ETF	136.18	136.18	136.18	136.18	100.0
2012-07-27 04:28:00	SPY	ETF	136.18	136.18	136.18	136.18	100.0
2012-07-27 04:32:00	SPY	ETF	136.17	136.17	136.17	136.17	500.0
2012-07-27 04:43:00	SPY	ETF	136.2	136.2	136.2	136.2	760.0
2012-07-27 04:46:00	SPY	ETF	136.15	136.15	136.05	136.05	2184.0
2012-07-27 04:49:00	SPY	ETF	136.07	136.07	136.07	136.07	5000.0
2012-07-27 04:50:00	SPY	ETF	136.09	136.09	136.09	136.09	200.0
2012-07-27 04:51:00	SPY	ETF	136.0	136.0	136.0	136.0	2000.0
2012-07-27 04:52:00	SPY	ETF	136.0	136.0	136.0	136.0	2900.0
2012-07-27 04:56:00	SPY	ETF	136.1	136.1	136.1	136.1	1000.0
2012-07-27 05:04:00	SPY	ETF	136.0	136.0	135.99	135.99	5000.0
2012-07-27 05:06:00	SPY	ETF	136.0	136.0	136.0	136.0	3184.0
2012-07-27 05:07:00	SPY	ETF	135.99	135.99	135.99	135.99	216.0
2012-07-27 05:08:00	SPY	ETF	136.05	136.05	136.05	136.05	500.0
2012-07-27 05:16:00	SPY	ETF	135.97	135.97	135.97	135.97	100.0
2012-07-27 05:17:00	SPY	ETF	136.03	136.06	136.03	136.06	1000.0
2012-07-27 05:18:00	SPY	ETF	136.1	136.1	136.1	136.1	500.0
2012-07-27 05:23:00	SPY	ETF	136.07	136.07	136.07	136.07	1000.0
2012-07-27 05:24:00	SPY	ETF	136.04	136.04	136.04	136.04	100.0
2012-07-27 05:30:00	SPY	ETF	135.97	135.97	135.97	135.97	200.0
2012-07-27 05:33:00	SPY	ETF	135.99	135.99	135.99	135.99	150.0
2012-07-27 05:36:00	SPY	ETF	135.96	135.96	135.96	135.96	300.0
2012-07-27 05:40:00	SPY	ETF	136.05	136.08	136.05	136.08	700.0
2012-07-27 05:44:00	SPY	ETF	136.44	136.52	136.44	136.52	485.0
2012-07-27 05:49:00	SPY	ETF	136.41	136.41	136.41	136.41	100.0
2012-07-27 05:51:00	SPY	ETF	136.27	136.27	136.27	136.27	500.0
2012-07-27 05:52:00	SPY	ETF	136.27	136.27	136.27	136.27	600.0
2012-07-27 05:53:00	SPY	ETF	136.15	136.15	136.15	136.15	200.0
2012-07-27 05:56:00	SPY	ETF	136.17	136.17	136.17	136.17	310.0
2012-07-27 05:57:00	SPY	ETF	136.17	136.17	136.17	136.17	100.0
2012-07-27 05:58:00	SPY	ETF	136.22	136.22	136.22	136.22	220.0
2012-07-27 05:59:00	SPY	ETF	136.15	136.15	136.15	136.15	100.0
2012-07-27 06:06:00	SPY	ETF	136.23	136.23	136.23	136.23	100.0
2012-07-27 06:07:00	SPY	ETF	136.26	136.26	136.22	136.22	300.0
2012-07-27 06:18:00	SPY	ETF	136.27	136.27	136.26	136.26	1300.0
2012-07-27 06:19:00	SPY	ETF	136.27	136.27	136.27	136.27	105.0
2012-07-27 06:24:00	SPY	ETF	136.39	136.39	136.39	136.39	495.0
2012-07-27 06:25:00	SPY	ETF	136.41	136.41	136.41	136.41	150.0
2012-07-27 06:26:00	SPY	ETF	136.44	136.44	136.44	136.44	993.0
2012-07-27 06:32:00	SPY	ETF	136.5	136.5	136.5	136.5	160.0
2012-07-27 06:35:00	SPY	ETF	136.5	136.5	136.5	136.5	100.0
2012-07-27 06:36:00	SPY	ETF	136.5	136.5	136.5	136.5	1000.0
2012-07-27 06:38:00	SPY	ETF	136.45	136.45	136.45	136.45	935.0
2012-07-27 06:50:00	SPY	ETF	136.39	136.41	136.39	136.41	800.0
2012-07-27 06:51:00	SPY	ETF	136.44	136.44	136.44	136.44	2900.0
2012-07-27 06:53:00	SPY	ETF	136.39	136.39	136.38	136.38	600.0
2012-07-27 06:56:00	SPY	ETF	136.4	136.4	136.4	136.4	100.0
2012-07-27 06:57:00	SPY	ETF	136.44	136.44	136.44	136.44	900.0
2012-07-27 06:58:00	SPY	ETF	136.49	136.59	136.49	136.59	7900.0

> showing 50 of 104,294 rows — these rows as CSV

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