PREVIEW / etf_1min / 2016-07-14

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-07-14.parquet
  size:    2.7 MB
  rows:    143,055

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
2016-07-14 04:00:00	SPY	ETF	216.0	216.35	215.2	216.35	1797.0
2016-07-14 04:01:00	SPY	ETF	216.24	216.24	216.24	216.24	260.0
2016-07-14 04:02:00	SPY	ETF	216.26	216.35	216.24	216.26	3524.0
2016-07-14 04:03:00	SPY	ETF	216.26	216.26	216.24	216.24	322.0
2016-07-14 04:04:00	SPY	ETF	216.26	216.27	216.26	216.26	4500.0
2016-07-14 04:05:00	SPY	ETF	216.28	216.35	216.28	216.31	900.0
2016-07-14 04:07:00	SPY	ETF	216.31	216.38	216.31	216.38	732.0
2016-07-14 04:09:00	SPY	ETF	216.33	216.37	216.33	216.37	700.0
2016-07-14 04:10:00	SPY	ETF	216.38	216.38	216.32	216.36	811.0
2016-07-14 04:11:00	SPY	ETF	216.37	216.4	216.36	216.4	452.0
2016-07-14 04:12:00	SPY	ETF	216.32	216.41	216.32	216.38	5102.0
2016-07-14 04:13:00	SPY	ETF	216.38	216.38	216.34	216.38	24950.0
2016-07-14 04:14:00	SPY	ETF	216.38	216.43	216.37	216.37	55056.0
2016-07-14 04:15:00	SPY	ETF	216.36	216.37	216.35	216.37	900.0
2016-07-14 04:16:00	SPY	ETF	216.39	216.39	216.39	216.39	400.0
2016-07-14 04:18:00	SPY	ETF	216.37	216.37	216.37	216.37	500.0
2016-07-14 04:21:00	SPY	ETF	216.36	216.42	216.35	216.41	19865.0
2016-07-14 04:22:00	SPY	ETF	216.38	216.38	216.38	216.38	5001.0
2016-07-14 04:24:00	SPY	ETF	216.3	216.3	216.3	216.3	300.0
2016-07-14 04:26:00	SPY	ETF	216.33	216.33	216.32	216.32	8100.0
2016-07-14 04:27:00	SPY	ETF	216.3	216.3	216.3	216.3	500.0
2016-07-14 04:30:00	SPY	ETF	216.27	216.27	216.27	216.27	1100.0
2016-07-14 04:31:00	SPY	ETF	216.3	216.31	216.3	216.31	2300.0
2016-07-14 04:34:00	SPY	ETF	216.33	216.33	216.33	216.33	1702.0
2016-07-14 04:35:00	SPY	ETF	216.31	216.31	216.31	216.31	100.0
2016-07-14 04:36:00	SPY	ETF	216.31	216.31	216.31	216.31	1000.0
2016-07-14 04:43:00	SPY	ETF	216.36	216.36	216.36	216.36	1501.0
2016-07-14 04:44:00	SPY	ETF	216.36	216.36	216.35	216.35	900.0
2016-07-14 04:47:00	SPY	ETF	216.31	216.31	216.31	216.31	1002.0
2016-07-14 04:49:00	SPY	ETF	216.31	216.31	216.31	216.31	1940.0
2016-07-14 04:51:00	SPY	ETF	216.28	216.28	216.28	216.28	100.0
2016-07-14 04:52:00	SPY	ETF	216.31	216.31	216.31	216.31	300.0
2016-07-14 04:54:00	SPY	ETF	216.28	216.28	216.28	216.28	510.0
2016-07-14 05:01:00	SPY	ETF	216.3	216.3	216.28	216.28	700.0
2016-07-14 05:02:00	SPY	ETF	216.3	216.3	216.3	216.3	2000.0
2016-07-14 05:06:00	SPY	ETF	216.27	216.27	216.27	216.27	602.0
2016-07-14 05:09:00	SPY	ETF	216.3	216.3	216.3	216.3	100.0
2016-07-14 05:11:00	SPY	ETF	216.3	216.32	216.3	216.32	260.0
2016-07-14 05:15:00	SPY	ETF	216.45	216.5	216.45	216.45	2631.0
2016-07-14 05:16:00	SPY	ETF	216.45	216.45	216.45	216.45	100.0
2016-07-14 05:17:00	SPY	ETF	216.42	216.42	216.42	216.42	10000.0
2016-07-14 05:19:00	SPY	ETF	216.45	216.45	216.45	216.45	701.0
2016-07-14 05:20:00	SPY	ETF	216.45	216.45	216.45	216.45	8000.0
2016-07-14 05:23:00	SPY	ETF	216.37	216.37	216.37	216.37	204.0
2016-07-14 05:24:00	SPY	ETF	216.36	216.36	216.36	216.36	5000.0
2016-07-14 05:28:00	SPY	ETF	216.36	216.36	216.36	216.36	1500.0
2016-07-14 05:29:00	SPY	ETF	216.36	216.36	216.36	216.36	1500.0
2016-07-14 05:31:00	SPY	ETF	216.38	216.38	216.38	216.38	300.0
2016-07-14 05:32:00	SPY	ETF	216.38	216.38	216.38	216.38	3000.0
2016-07-14 05:34:00	SPY	ETF	216.37	216.37	216.37	216.37	500.0

> showing 50 of 143,055 rows — these rows as CSV

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