PREVIEW / etf_1min / 2017-06-20

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-06-20.parquet
  size:    2.7 MB
  rows:    140,623

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-06-20 04:08:00	SPY	ETF	244.54	244.54	244.54	244.54	200.0
2017-06-20 04:18:00	SPY	ETF	244.47	244.47	244.47	244.47	200.0
2017-06-20 04:22:00	SPY	ETF	244.45	244.45	244.45	244.45	110.0
2017-06-20 05:00:00	SPY	ETF	244.44	244.44	244.44	244.44	200.0
2017-06-20 05:02:00	SPY	ETF	244.46	244.46	244.46	244.46	2500.0
2017-06-20 05:03:00	SPY	ETF	244.47	244.47	244.47	244.47	300.0
2017-06-20 05:04:00	SPY	ETF	244.47	244.47	244.47	244.47	1000.0
2017-06-20 05:05:00	SPY	ETF	244.47	244.47	244.47	244.47	500.0
2017-06-20 05:13:00	SPY	ETF	244.44	244.44	244.44	244.44	2500.0
2017-06-20 05:23:00	SPY	ETF	244.43	244.47	244.43	244.47	200.0
2017-06-20 05:24:00	SPY	ETF	244.45	244.45	244.45	244.45	300.0
2017-06-20 05:32:00	SPY	ETF	244.43	244.43	244.43	244.43	400.0
2017-06-20 05:42:00	SPY	ETF	244.4	244.4	244.4	244.4	500.0
2017-06-20 05:45:00	SPY	ETF	244.42	244.42	244.42	244.42	2600.0
2017-06-20 05:46:00	SPY	ETF	244.42	244.42	244.42	244.42	2400.0
2017-06-20 05:53:00	SPY	ETF	244.4	244.4	244.4	244.4	400.0
2017-06-20 05:55:00	SPY	ETF	244.4	244.4	244.4	244.4	300.0
2017-06-20 06:00:00	SPY	ETF	244.4	244.4	244.4	244.4	300.0
2017-06-20 06:10:00	SPY	ETF	244.36	244.36	244.36	244.36	100.0
2017-06-20 06:15:00	SPY	ETF	244.37	244.37	244.37	244.37	304.0
2017-06-20 06:16:00	SPY	ETF	244.37	244.37	244.37	244.37	300.0
2017-06-20 06:17:00	SPY	ETF	244.42	244.42	244.42	244.42	396.0
2017-06-20 06:20:00	SPY	ETF	244.42	244.42	244.42	244.42	997.0
2017-06-20 06:22:00	SPY	ETF	244.39	244.39	244.39	244.39	2000.0
2017-06-20 06:24:00	SPY	ETF	244.44	244.44	244.44	244.44	1000.0
2017-06-20 06:27:00	SPY	ETF	244.44	244.44	244.44	244.44	3000.0
2017-06-20 06:28:00	SPY	ETF	244.38	244.38	244.38	244.38	300.0
2017-06-20 06:31:00	SPY	ETF	244.45	244.45	244.45	244.45	21000.0
2017-06-20 06:32:00	SPY	ETF	244.45	244.45	244.45	244.45	22000.0
2017-06-20 06:33:00	SPY	ETF	244.46	244.46	244.46	244.46	400.0
2017-06-20 06:36:00	SPY	ETF	244.47	244.47	244.47	244.47	100.0
2017-06-20 06:37:00	SPY	ETF	244.46	244.46	244.46	244.46	200.0
2017-06-20 06:41:00	SPY	ETF	244.45	244.45	244.45	244.45	300.0
2017-06-20 06:45:00	SPY	ETF	244.45	244.45	244.45	244.45	1500.0
2017-06-20 06:46:00	SPY	ETF	244.45	244.45	244.45	244.45	1400.0
2017-06-20 06:50:00	SPY	ETF	244.45	244.45	244.45	244.45	200.0
2017-06-20 06:52:00	SPY	ETF	244.45	244.45	244.45	244.45	500.0
2017-06-20 06:54:00	SPY	ETF	244.45	244.45	244.38	244.38	5100.0
2017-06-20 06:55:00	SPY	ETF	244.4	244.4	244.4	244.4	100.0
2017-06-20 06:58:00	SPY	ETF	244.41	244.41	244.41	244.41	300.0
2017-06-20 07:01:00	SPY	ETF	244.42	244.42	244.42	244.42	7100.0
2017-06-20 07:02:00	SPY	ETF	244.42	244.42	244.42	244.42	300.0
2017-06-20 07:03:00	SPY	ETF	244.42	244.42	244.42	244.42	500.0
2017-06-20 07:04:00	SPY	ETF	244.42	244.42	244.42	244.42	220.0
2017-06-20 07:05:00	SPY	ETF	244.42	244.42	244.42	244.42	200.0
2017-06-20 07:06:00	SPY	ETF	244.4	244.42	244.4	244.4	3100.0
2017-06-20 07:07:00	SPY	ETF	244.4	244.4	244.4	244.4	48504.0
2017-06-20 07:10:00	SPY	ETF	244.42	244.42	244.42	244.42	969.0
2017-06-20 07:11:00	SPY	ETF	244.41	244.41	244.41	244.41	969.0
2017-06-20 07:13:00	SPY	ETF	244.4	244.4	244.4	244.4	1000.0

> showing 50 of 140,623 rows — these rows as CSV

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