PREVIEW / etf_1min / 2016-08-02

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-08-02.parquet
  size:    2.8 MB
  rows:    146,710

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-08-02 04:02:00	SPY	ETF	216.64	216.94	216.64	216.94	400.0
2016-08-02 04:03:00	SPY	ETF	216.7	216.7	216.7	216.7	100.0
2016-08-02 04:05:00	SPY	ETF	216.67	216.67	216.57	216.57	1350.0
2016-08-02 04:17:00	SPY	ETF	216.55	216.55	216.55	216.55	5065.0
2016-08-02 04:18:00	SPY	ETF	216.51	216.51	216.37	216.37	425.0
2016-08-02 04:20:00	SPY	ETF	216.46	216.46	216.33	216.33	725.0
2016-08-02 04:22:00	SPY	ETF	216.34	216.38	216.34	216.38	6000.0
2016-08-02 04:23:00	SPY	ETF	216.35	216.35	216.35	216.35	100.0
2016-08-02 04:24:00	SPY	ETF	216.38	216.38	216.38	216.38	5050.0
2016-08-02 04:25:00	SPY	ETF	216.32	216.32	216.32	216.32	1000.0
2016-08-02 04:31:00	SPY	ETF	216.27	216.31	216.27	216.3	2301.0
2016-08-02 04:36:00	SPY	ETF	216.36	216.36	216.36	216.36	500.0
2016-08-02 04:37:00	SPY	ETF	216.35	216.35	216.35	216.35	103.0
2016-08-02 04:38:00	SPY	ETF	216.34	216.34	216.34	216.34	400.0
2016-08-02 04:39:00	SPY	ETF	216.38	216.38	216.38	216.38	201.0
2016-08-02 04:44:00	SPY	ETF	216.3	216.3	216.3	216.3	469.0
2016-08-02 04:48:00	SPY	ETF	216.23	216.23	216.21	216.21	501.0
2016-08-02 04:53:00	SPY	ETF	216.23	216.23	216.23	216.23	401.0
2016-08-02 04:56:00	SPY	ETF	216.31	216.31	216.31	216.31	106.0
2016-08-02 05:03:00	SPY	ETF	216.27	216.27	216.27	216.27	313.0
2016-08-02 05:09:00	SPY	ETF	216.29	216.29	216.29	216.29	500.0
2016-08-02 05:21:00	SPY	ETF	216.38	216.38	216.38	216.38	601.0
2016-08-02 05:22:00	SPY	ETF	216.38	216.38	216.37	216.37	900.0
2016-08-02 05:25:00	SPY	ETF	216.41	216.41	216.41	216.41	200.0
2016-08-02 05:28:00	SPY	ETF	216.37	216.37	216.37	216.37	600.0
2016-08-02 05:33:00	SPY	ETF	216.47	216.47	216.47	216.47	2003.0
2016-08-02 05:37:00	SPY	ETF	216.49	216.54	216.49	216.54	703.0
2016-08-02 05:46:00	SPY	ETF	216.55	216.57	216.55	216.57	601.0
2016-08-02 05:48:00	SPY	ETF	216.56	216.56	216.54	216.54	11000.0
2016-08-02 05:51:00	SPY	ETF	216.53	216.53	216.53	216.53	201.0
2016-08-02 05:53:00	SPY	ETF	216.5	216.5	216.5	216.5	302.0
2016-08-02 05:56:00	SPY	ETF	216.5	216.5	216.44	216.44	602.0
2016-08-02 05:59:00	SPY	ETF	216.43	216.43	216.43	216.43	224.0
2016-08-02 06:01:00	SPY	ETF	216.39	216.43	216.38	216.43	2451.0
2016-08-02 06:04:00	SPY	ETF	216.39	216.39	216.39	216.39	200.0
2016-08-02 06:05:00	SPY	ETF	216.41	216.41	216.41	216.41	100.0
2016-08-02 06:12:00	SPY	ETF	216.49	216.49	216.49	216.49	100.0
2016-08-02 06:17:00	SPY	ETF	216.5	216.5	216.49	216.49	411.0
2016-08-02 06:21:00	SPY	ETF	216.5	216.5	216.5	216.5	101.0
2016-08-02 06:25:00	SPY	ETF	216.44	216.45	216.41	216.45	16902.0
2016-08-02 06:29:00	SPY	ETF	216.41	216.42	216.41	216.42	15000.0
2016-08-02 06:30:00	SPY	ETF	216.41	216.41	216.41	216.41	4215.0
2016-08-02 06:31:00	SPY	ETF	216.41	216.41	216.4	216.4	6100.0
2016-08-02 06:32:00	SPY	ETF	216.4	216.43	216.4	216.42	814.0
2016-08-02 06:40:00	SPY	ETF	216.61	216.61	216.61	216.61	500.0
2016-08-02 06:41:00	SPY	ETF	216.58	216.58	216.58	216.58	5000.0
2016-08-02 06:42:00	SPY	ETF	216.58	216.64	216.58	216.64	3202.0
2016-08-02 06:45:00	SPY	ETF	216.61	216.61	216.57	216.57	851.0
2016-08-02 06:46:00	SPY	ETF	216.58	216.58	216.58	216.58	6500.0
2016-08-02 06:50:00	SPY	ETF	216.53	216.54	216.52	216.52	403.0

> showing 50 of 146,710 rows — these rows as CSV

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