PREVIEW / etf_1min / 2014-04-24

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-04-24.parquet
  size:    2.1 MB
  rows:    111,845

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-04-24 04:19:00	SPY	ETF	188.52	188.52	188.52	188.52	240.0
2014-04-24 04:27:00	SPY	ETF	188.5	188.5	188.5	188.5	1075.0
2014-04-24 04:37:00	SPY	ETF	188.51	188.51	188.51	188.51	335.0
2014-04-24 04:42:00	SPY	ETF	188.5	188.5	188.5	188.5	233.0
2014-04-24 04:43:00	SPY	ETF	188.5	188.5	188.5	188.5	233.0
2014-04-24 04:53:00	SPY	ETF	188.5	188.5	188.5	188.5	100.0
2014-04-24 04:57:00	SPY	ETF	188.53	188.53	188.53	188.53	356.0
2014-04-24 04:58:00	SPY	ETF	188.52	188.52	188.52	188.52	100.0
2014-04-24 04:59:00	SPY	ETF	188.52	188.52	188.52	188.52	170.0
2014-04-24 05:02:00	SPY	ETF	188.52	188.52	188.52	188.52	199.0
2014-04-24 05:04:00	SPY	ETF	188.52	188.52	188.52	188.52	1000.0
2014-04-24 05:05:00	SPY	ETF	188.43	188.48	188.43	188.48	800.0
2014-04-24 05:10:00	SPY	ETF	188.53	188.53	188.49	188.49	865.0
2014-04-24 05:13:00	SPY	ETF	188.49	188.49	188.49	188.49	1522.0
2014-04-24 05:24:00	SPY	ETF	188.52	188.52	188.52	188.52	139.0
2014-04-24 05:27:00	SPY	ETF	188.52	188.52	188.52	188.52	146.0
2014-04-24 05:28:00	SPY	ETF	188.52	188.52	188.52	188.52	177.0
2014-04-24 05:29:00	SPY	ETF	188.53	188.53	188.53	188.53	1018.0
2014-04-24 05:33:00	SPY	ETF	188.5	188.5	188.5	188.5	400.0
2014-04-24 05:36:00	SPY	ETF	188.52	188.52	188.52	188.52	119.0
2014-04-24 05:48:00	SPY	ETF	188.48	188.48	188.48	188.48	398.0
2014-04-24 06:03:00	SPY	ETF	188.44	188.44	188.44	188.44	100.0
2014-04-24 06:04:00	SPY	ETF	188.53	188.53	188.53	188.53	3577.0
2014-04-24 06:05:00	SPY	ETF	188.58	188.6	188.58	188.6	4400.0
2014-04-24 06:07:00	SPY	ETF	188.59	188.59	188.59	188.59	1000.0
2014-04-24 06:16:00	SPY	ETF	188.61	188.63	188.61	188.63	2043.0
2014-04-24 06:19:00	SPY	ETF	188.63	188.63	188.63	188.63	100.0
2014-04-24 06:20:00	SPY	ETF	188.64	188.67	188.64	188.66	3900.0
2014-04-24 06:22:00	SPY	ETF	188.67	188.67	188.67	188.67	200.0
2014-04-24 06:23:00	SPY	ETF	188.68	188.68	188.68	188.68	400.0
2014-04-24 06:24:00	SPY	ETF	188.68	188.68	188.68	188.68	2000.0
2014-04-24 06:26:00	SPY	ETF	188.68	188.68	188.68	188.68	250.0
2014-04-24 06:27:00	SPY	ETF	188.65	188.65	188.65	188.65	100.0
2014-04-24 06:28:00	SPY	ETF	188.65	188.65	188.65	188.65	100.0
2014-04-24 06:29:00	SPY	ETF	188.65	188.65	188.65	188.65	400.0
2014-04-24 06:32:00	SPY	ETF	188.65	188.65	188.65	188.65	100.0
2014-04-24 06:40:00	SPY	ETF	188.69	188.69	188.69	188.69	1425.0
2014-04-24 06:41:00	SPY	ETF	188.69	188.69	188.69	188.69	1475.0
2014-04-24 06:44:00	SPY	ETF	188.63	188.63	188.63	188.63	400.0
2014-04-24 06:46:00	SPY	ETF	188.6	188.6	188.6	188.6	102.0
2014-04-24 06:49:00	SPY	ETF	188.58	188.58	188.58	188.58	400.0
2014-04-24 06:51:00	SPY	ETF	188.58	188.58	188.58	188.58	200.0
2014-04-24 07:00:00	SPY	ETF	188.63	188.63	188.63	188.63	450.0
2014-04-24 07:01:00	SPY	ETF	188.62	188.64	188.62	188.64	957.0
2014-04-24 07:02:00	SPY	ETF	188.61	188.61	188.6	188.61	450.0
2014-04-24 07:03:00	SPY	ETF	188.58	188.58	188.57	188.57	525.0
2014-04-24 07:06:00	SPY	ETF	188.59	188.6	188.51	188.57	33268.0
2014-04-24 07:07:00	SPY	ETF	188.56	188.58	188.55	188.58	3000.0
2014-04-24 07:08:00	SPY	ETF	188.58	188.58	188.55	188.55	900.0
2014-04-24 07:09:00	SPY	ETF	188.54	188.54	188.5	188.5	2900.0

> showing 50 of 111,845 rows — these rows as CSV

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