PREVIEW / etf_1min / 2014-11-07

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-11-07.parquet
  size:    2.3 MB
  rows:    118,223

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-11-07 04:00:00	SPY	ETF	203.41	203.72	203.41	203.72	323.0
2014-11-07 04:01:00	SPY	ETF	203.64	203.64	203.64	203.64	100.0
2014-11-07 04:05:00	SPY	ETF	203.63	203.7	203.63	203.7	1400.0
2014-11-07 04:11:00	SPY	ETF	203.65	203.65	203.65	203.65	200.0
2014-11-07 04:13:00	SPY	ETF	203.57	203.57	203.57	203.57	125.0
2014-11-07 04:19:00	SPY	ETF	203.67	203.67	203.67	203.67	100.0
2014-11-07 04:22:00	SPY	ETF	203.68	203.7	203.68	203.7	2100.0
2014-11-07 04:23:00	SPY	ETF	203.68	203.69	203.68	203.69	1100.0
2014-11-07 04:24:00	SPY	ETF	203.68	203.68	203.68	203.68	200.0
2014-11-07 04:28:00	SPY	ETF	203.7	203.7	203.7	203.7	172.0
2014-11-07 04:29:00	SPY	ETF	203.68	203.68	203.68	203.68	100.0
2014-11-07 04:30:00	SPY	ETF	203.67	203.67	203.67	203.67	100.0
2014-11-07 04:31:00	SPY	ETF	203.67	203.67	203.67	203.67	150.0
2014-11-07 04:33:00	SPY	ETF	203.62	203.62	203.62	203.62	172.0
2014-11-07 04:37:00	SPY	ETF	203.64	203.64	203.64	203.64	222.0
2014-11-07 04:39:00	SPY	ETF	203.62	203.62	203.6	203.6	392.0
2014-11-07 04:40:00	SPY	ETF	203.58	203.58	203.58	203.58	100.0
2014-11-07 04:41:00	SPY	ETF	203.56	203.57	203.56	203.57	4616.0
2014-11-07 04:44:00	SPY	ETF	203.57	203.57	203.57	203.57	399.0
2014-11-07 04:49:00	SPY	ETF	203.56	203.57	203.56	203.57	298.0
2014-11-07 04:52:00	SPY	ETF	203.56	203.56	203.56	203.56	500.0
2014-11-07 04:54:00	SPY	ETF	203.55	203.55	203.55	203.55	108.0
2014-11-07 04:56:00	SPY	ETF	203.56	203.56	203.54	203.54	1158.0
2014-11-07 04:59:00	SPY	ETF	203.61	203.61	203.61	203.61	100.0
2014-11-07 05:01:00	SPY	ETF	203.67	203.67	203.67	203.67	420.0
2014-11-07 05:02:00	SPY	ETF	203.62	203.62	203.62	203.62	6250.0
2014-11-07 05:03:00	SPY	ETF	203.63	203.63	203.62	203.62	469.0
2014-11-07 05:17:00	SPY	ETF	203.58	203.58	203.58	203.58	250.0
2014-11-07 05:18:00	SPY	ETF	203.6	203.6	203.58	203.58	220.0
2014-11-07 05:22:00	SPY	ETF	203.57	203.57	203.56	203.57	700.0
2014-11-07 05:23:00	SPY	ETF	203.6	203.6	203.6	203.6	213.0
2014-11-07 05:24:00	SPY	ETF	203.57	203.59	203.57	203.59	462.0
2014-11-07 05:25:00	SPY	ETF	203.6	203.62	203.6	203.6	669.0
2014-11-07 05:26:00	SPY	ETF	203.59	203.59	203.57	203.57	1000.0
2014-11-07 05:28:00	SPY	ETF	203.57	203.57	203.57	203.57	100.0
2014-11-07 05:30:00	SPY	ETF	203.57	203.57	203.52	203.52	1000.0
2014-11-07 05:32:00	SPY	ETF	203.42	203.43	203.39	203.39	5350.0
2014-11-07 05:33:00	SPY	ETF	203.38	203.38	203.3	203.3	956.0
2014-11-07 05:36:00	SPY	ETF	203.32	203.32	203.32	203.32	500.0
2014-11-07 05:37:00	SPY	ETF	203.27	203.27	203.27	203.27	1000.0
2014-11-07 05:40:00	SPY	ETF	203.32	203.32	203.32	203.32	400.0
2014-11-07 05:41:00	SPY	ETF	203.32	203.32	203.32	203.32	1550.0
2014-11-07 05:43:00	SPY	ETF	203.35	203.35	203.35	203.35	100.0
2014-11-07 05:44:00	SPY	ETF	203.37	203.37	203.37	203.37	6500.0
2014-11-07 05:45:00	SPY	ETF	203.32	203.32	203.32	203.32	32000.0
2014-11-07 05:46:00	SPY	ETF	203.27	203.3	203.27	203.3	26104.0
2014-11-07 05:48:00	SPY	ETF	203.32	203.32	203.32	203.32	227.0
2014-11-07 05:50:00	SPY	ETF	203.27	203.27	203.27	203.27	11500.0
2014-11-07 05:54:00	SPY	ETF	203.22	203.22	203.22	203.22	32000.0
2014-11-07 05:55:00	SPY	ETF	203.18	203.18	203.17	203.17	324.0

> showing 50 of 118,223 rows — these rows as CSV

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