PREVIEW / etf_1min / 2017-07-14

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-07-14.parquet
  size:    2.5 MB
  rows:    132,812

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
2017-07-14 04:00:00	SPY	ETF	244.31	244.31	244.31	244.31	156.0
2017-07-14 04:18:00	SPY	ETF	244.2	244.2	244.2	244.2	100.0
2017-07-14 04:52:00	SPY	ETF	244.17	244.17	244.17	244.17	100.0
2017-07-14 04:57:00	SPY	ETF	244.18	244.18	244.18	244.18	400.0
2017-07-14 04:58:00	SPY	ETF	244.2	244.2	244.2	244.2	4000.0
2017-07-14 05:02:00	SPY	ETF	244.16	244.16	244.16	244.16	1000.0
2017-07-14 05:25:00	SPY	ETF	244.19	244.19	244.19	244.19	200.0
2017-07-14 05:32:00	SPY	ETF	244.14	244.14	244.14	244.14	205.0
2017-07-14 05:33:00	SPY	ETF	244.13	244.13	244.13	244.13	100.0
2017-07-14 06:10:00	SPY	ETF	244.21	244.21	244.21	244.21	140.0
2017-07-14 06:23:00	SPY	ETF	244.21	244.21	244.21	244.21	200.0
2017-07-14 06:24:00	SPY	ETF	244.2	244.2	244.2	244.2	300.0
2017-07-14 06:30:00	SPY	ETF	244.22	244.22	244.22	244.22	100.0
2017-07-14 06:32:00	SPY	ETF	244.24	244.24	244.24	244.24	200.0
2017-07-14 06:42:00	SPY	ETF	244.25	244.25	244.23	244.23	1026.0
2017-07-14 06:43:00	SPY	ETF	244.26	244.35	244.26	244.35	6104.0
2017-07-14 06:54:00	SPY	ETF	244.35	244.35	244.35	244.35	1301.0
2017-07-14 06:55:00	SPY	ETF	244.35	244.35	244.35	244.35	4099.0
2017-07-14 06:56:00	SPY	ETF	244.35	244.35	244.35	244.35	1001.0
2017-07-14 06:57:00	SPY	ETF	244.33	244.33	244.33	244.33	300.0
2017-07-14 07:02:00	SPY	ETF	244.35	244.35	244.35	244.35	1000.0
2017-07-14 07:03:00	SPY	ETF	244.33	244.33	244.33	244.33	3401.0
2017-07-14 07:05:00	SPY	ETF	244.32	244.35	244.32	244.35	4870.0
2017-07-14 07:06:00	SPY	ETF	244.33	244.33	244.33	244.33	1001.0
2017-07-14 07:07:00	SPY	ETF	244.33	244.33	244.33	244.33	1999.0
2017-07-14 07:08:00	SPY	ETF	244.31	244.31	244.31	244.31	300.0
2017-07-14 07:13:00	SPY	ETF	244.33	244.33	244.33	244.33	300.0
2017-07-14 07:14:00	SPY	ETF	244.33	244.33	244.3	244.3	1601.0
2017-07-14 07:17:00	SPY	ETF	244.32	244.33	244.32	244.33	7000.0
2017-07-14 07:18:00	SPY	ETF	244.3	244.3	244.3	244.3	170.0
2017-07-14 07:19:00	SPY	ETF	244.3	244.3	244.3	244.3	8931.0
2017-07-14 07:22:00	SPY	ETF	244.3	244.3	244.3	244.3	1200.0
2017-07-14 07:23:00	SPY	ETF	244.3	244.3	244.3	244.3	1862.0
2017-07-14 07:28:00	SPY	ETF	244.3	244.3	244.3	244.3	100.0
2017-07-14 07:30:00	SPY	ETF	244.3	244.3	244.3	244.3	101.0
2017-07-14 07:32:00	SPY	ETF	244.32	244.34	244.3	244.34	1570.0
2017-07-14 07:44:00	SPY	ETF	244.34	244.34	244.34	244.34	212.0
2017-07-14 07:46:00	SPY	ETF	244.31	244.34	244.31	244.34	1169.0
2017-07-14 07:47:00	SPY	ETF	244.35	244.36	244.35	244.36	600.0
2017-07-14 07:49:00	SPY	ETF	244.36	244.36	244.36	244.36	100.0
2017-07-14 07:51:00	SPY	ETF	244.36	244.36	244.36	244.36	200.0
2017-07-14 07:53:00	SPY	ETF	244.36	244.36	244.36	244.36	169.0
2017-07-14 07:55:00	SPY	ETF	244.37	244.37	244.37	244.37	969.0
2017-07-14 07:58:00	SPY	ETF	244.37	244.37	244.36	244.36	5000.0
2017-07-14 07:59:00	SPY	ETF	244.36	244.37	244.36	244.37	7100.0
2017-07-14 08:00:00	SPY	ETF	244.35	244.38	244.3	244.36	6806.0
2017-07-14 08:01:00	SPY	ETF	244.37	244.37	244.34	244.34	21452.0
2017-07-14 08:02:00	SPY	ETF	244.34	244.34	244.33	244.33	3100.0
2017-07-14 08:06:00	SPY	ETF	244.32	244.32	244.28	244.28	2541.0
2017-07-14 08:07:00	SPY	ETF	244.28	244.29	244.26	244.29	15110.0

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

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