PREVIEW / etf_1min / 2014-06-20

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-06-20.parquet
  size:    1.9 MB
  rows:    105,383

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-06-20 04:00:00	SPY	ETF	195.51	195.6	195.43	195.56	2508.0
2014-06-20 04:02:00	SPY	ETF	195.5	195.5	195.5	195.5	500.0
2014-06-20 04:07:00	SPY	ETF	195.24	195.24	195.24	195.24	20000.0
2014-06-20 04:42:00	SPY	ETF	195.57	195.57	195.57	195.57	1000.0
2014-06-20 04:43:00	SPY	ETF	195.57	195.57	195.57	195.57	200.0
2014-06-20 04:44:00	SPY	ETF	195.54	195.54	195.54	195.54	400.0
2014-06-20 04:46:00	SPY	ETF	195.57	195.57	195.57	195.57	1400.0
2014-06-20 05:08:00	SPY	ETF	195.57	195.57	195.55	195.55	10250.0
2014-06-20 05:35:00	SPY	ETF	195.75	195.79	195.59	195.6	18983.0
2014-06-20 05:40:00	SPY	ETF	195.6	195.64	195.6	195.64	400.0
2014-06-20 05:50:00	SPY	ETF	195.68	195.68	195.68	195.68	600.0
2014-06-20 05:54:00	SPY	ETF	195.66	195.66	195.66	195.66	200.0
2014-06-20 06:09:00	SPY	ETF	195.65	195.65	195.64	195.64	760.0
2014-06-20 06:15:00	SPY	ETF	195.67	195.67	195.67	195.67	200.0
2014-06-20 06:18:00	SPY	ETF	195.66	195.66	195.66	195.66	100.0
2014-06-20 06:28:00	SPY	ETF	195.68	195.68	195.64	195.64	3005.0
2014-06-20 06:29:00	SPY	ETF	195.63	195.65	195.63	195.64	300.0
2014-06-20 06:30:00	SPY	ETF	195.65	195.65	195.65	195.65	100.0
2014-06-20 06:31:00	SPY	ETF	195.65	195.68	195.65	195.68	1600.0
2014-06-20 06:32:00	SPY	ETF	195.68	195.68	195.68	195.68	400.0
2014-06-20 06:33:00	SPY	ETF	195.65	195.65	195.63	195.63	900.0
2014-06-20 06:34:00	SPY	ETF	195.68	195.68	195.64	195.64	600.0
2014-06-20 06:37:00	SPY	ETF	195.6	195.6	195.6	195.6	400.0
2014-06-20 06:40:00	SPY	ETF	195.57	195.57	195.57	195.57	200.0
2014-06-20 06:48:00	SPY	ETF	195.6	195.6	195.6	195.6	100.0
2014-06-20 06:51:00	SPY	ETF	195.56	195.56	195.56	195.56	250.0
2014-06-20 06:53:00	SPY	ETF	195.54	195.56	195.54	195.56	600.0
2014-06-20 06:54:00	SPY	ETF	195.53	195.53	195.53	195.53	200.0
2014-06-20 06:55:00	SPY	ETF	195.58	195.58	195.57	195.58	3000.0
2014-06-20 06:56:00	SPY	ETF	195.52	195.59	195.52	195.56	950.0
2014-06-20 07:00:00	SPY	ETF	195.6	195.6	195.56	195.56	856.0
2014-06-20 07:03:00	SPY	ETF	195.6	195.6	195.57	195.57	35000.0
2014-06-20 07:04:00	SPY	ETF	195.57	195.57	195.54	195.56	5314.0
2014-06-20 07:05:00	SPY	ETF	195.55	195.55	195.55	195.55	6200.0
2014-06-20 07:06:00	SPY	ETF	195.57	195.6	195.57	195.6	4300.0
2014-06-20 07:10:00	SPY	ETF	195.58	195.6	195.58	195.59	1500.0
2014-06-20 07:12:00	SPY	ETF	195.55	195.64	195.55	195.64	16214.0
2014-06-20 07:15:00	SPY	ETF	195.64	195.64	195.61	195.61	1807.0
2014-06-20 07:16:00	SPY	ETF	195.6	195.64	195.6	195.63	4511.0
2014-06-20 07:17:00	SPY	ETF	195.6	195.6	195.57	195.6	846.0
2014-06-20 07:18:00	SPY	ETF	195.6	195.6	195.57	195.57	400.0
2014-06-20 07:19:00	SPY	ETF	195.57	195.58	195.46	195.58	18100.0
2014-06-20 07:20:00	SPY	ETF	195.58	195.6	195.56	195.56	600.0
2014-06-20 07:25:00	SPY	ETF	195.54	195.54	195.54	195.54	100.0
2014-06-20 07:29:00	SPY	ETF	195.53	195.53	195.53	195.53	100.0
2014-06-20 07:30:00	SPY	ETF	195.57	195.57	195.52	195.52	10800.0
2014-06-20 07:31:00	SPY	ETF	195.54	195.54	195.54	195.54	100.0
2014-06-20 07:32:00	SPY	ETF	195.52	195.52	195.52	195.52	500.0
2014-06-20 07:33:00	SPY	ETF	195.52	195.52	195.52	195.52	1000.0
2014-06-20 07:34:00	SPY	ETF	195.53	195.53	195.53	195.53	100.0

> showing 50 of 105,383 rows — these rows as CSV

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