PREVIEW / etf_1min / 2016-07-18

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-07-18.parquet
  size:    2.5 MB
  rows:    132,276

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-18 04:00:00	SPY	ETF	216.2	216.32	216.2	216.32	6125.0
2016-07-18 04:01:00	SPY	ETF	216.27	216.28	216.27	216.27	5200.0
2016-07-18 04:02:00	SPY	ETF	216.24	216.24	216.24	216.24	401.0
2016-07-18 04:03:00	SPY	ETF	216.24	216.3	216.24	216.27	3277.0
2016-07-18 04:04:00	SPY	ETF	216.27	216.27	216.25	216.25	2100.0
2016-07-18 04:05:00	SPY	ETF	216.25	216.27	216.25	216.27	801.0
2016-07-18 04:06:00	SPY	ETF	216.25	216.25	216.25	216.25	500.0
2016-07-18 04:07:00	SPY	ETF	216.3	216.3	216.24	216.3	1200.0
2016-07-18 04:08:00	SPY	ETF	216.3	216.36	216.3	216.36	654.0
2016-07-18 04:10:00	SPY	ETF	216.29	216.29	216.29	216.29	300.0
2016-07-18 04:11:00	SPY	ETF	216.35	216.36	216.35	216.36	400.0
2016-07-18 04:12:00	SPY	ETF	216.34	216.39	216.34	216.39	857.0
2016-07-18 04:13:00	SPY	ETF	216.28	216.28	216.28	216.28	458.0
2016-07-18 04:16:00	SPY	ETF	216.12	216.12	216.09	216.09	1549.0
2016-07-18 04:17:00	SPY	ETF	216.16	216.16	216.02	216.02	10000.0
2016-07-18 04:18:00	SPY	ETF	216.09	216.09	216.09	216.09	1010.0
2016-07-18 04:19:00	SPY	ETF	216.11	216.11	216.11	216.11	630.0
2016-07-18 04:20:00	SPY	ETF	216.07	216.07	216.07	216.07	168.0
2016-07-18 04:22:00	SPY	ETF	216.1	216.12	216.1	216.12	804.0
2016-07-18 04:23:00	SPY	ETF	216.11	216.11	216.11	216.11	501.0
2016-07-18 04:24:00	SPY	ETF	216.06	216.16	216.06	216.16	6705.0
2016-07-18 04:30:00	SPY	ETF	216.24	216.24	216.24	216.24	575.0
2016-07-18 04:33:00	SPY	ETF	216.24	216.24	216.24	216.24	501.0
2016-07-18 04:37:00	SPY	ETF	216.26	216.26	216.26	216.26	500.0
2016-07-18 04:39:00	SPY	ETF	216.34	216.34	216.34	216.34	5700.0
2016-07-18 04:43:00	SPY	ETF	216.28	216.35	216.28	216.35	2502.0
2016-07-18 04:46:00	SPY	ETF	216.25	216.25	216.25	216.25	1025.0
2016-07-18 04:48:00	SPY	ETF	216.21	216.21	216.21	216.21	2901.0
2016-07-18 04:52:00	SPY	ETF	216.23	216.23	216.23	216.23	203.0
2016-07-18 04:53:00	SPY	ETF	216.25	216.25	216.25	216.25	102.0
2016-07-18 04:57:00	SPY	ETF	216.26	216.26	216.26	216.26	226.0
2016-07-18 04:58:00	SPY	ETF	216.28	216.28	216.28	216.28	601.0
2016-07-18 04:59:00	SPY	ETF	216.3	216.47	216.3	216.47	2172.0
2016-07-18 05:00:00	SPY	ETF	216.43	216.45	216.43	216.45	600.0
2016-07-18 05:01:00	SPY	ETF	216.43	216.43	216.43	216.43	4950.0
2016-07-18 05:03:00	SPY	ETF	216.43	216.43	216.43	216.43	600.0
2016-07-18 05:04:00	SPY	ETF	216.43	216.44	216.38	216.44	11104.0
2016-07-18 05:05:00	SPY	ETF	216.44	216.47	216.44	216.47	42319.0
2016-07-18 05:06:00	SPY	ETF	216.44	216.44	216.44	216.44	332.0
2016-07-18 05:07:00	SPY	ETF	216.44	216.44	216.44	216.44	100.0
2016-07-18 05:08:00	SPY	ETF	216.42	216.42	216.42	216.42	207.0
2016-07-18 05:10:00	SPY	ETF	216.4	216.4	216.4	216.4	502.0
2016-07-18 05:13:00	SPY	ETF	216.42	216.42	216.42	216.42	102.0
2016-07-18 05:16:00	SPY	ETF	216.32	216.32	216.32	216.32	398.0
2016-07-18 05:17:00	SPY	ETF	216.29	216.3	216.29	216.3	500.0
2016-07-18 05:20:00	SPY	ETF	216.25	216.25	216.19	216.19	956.0
2016-07-18 05:21:00	SPY	ETF	216.19	216.23	216.19	216.23	402.0
2016-07-18 05:22:00	SPY	ETF	216.24	216.24	216.24	216.24	1200.0
2016-07-18 05:23:00	SPY	ETF	216.29	216.29	216.29	216.29	104.0
2016-07-18 05:26:00	SPY	ETF	216.27	216.28	216.27	216.28	10352.0

> showing 50 of 132,276 rows — these rows as CSV

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