PREVIEW / etf_1min / 2018-05-24

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-05-24.parquet
  size:    2.8 MB
  rows:    144,642

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
2018-05-24 04:03:00	SPY	ETF	273.36	273.36	273.36	273.36	202.0
2018-05-24 04:11:00	SPY	ETF	273.37	273.37	273.37	273.37	200.0
2018-05-24 04:17:00	SPY	ETF	273.24	273.24	273.22	273.22	1500.0
2018-05-24 04:47:00	SPY	ETF	273.42	273.45	273.42	273.45	3900.0
2018-05-24 04:48:00	SPY	ETF	273.47	273.48	273.47	273.48	4700.0
2018-05-24 04:49:00	SPY	ETF	273.45	273.47	273.45	273.47	600.0
2018-05-24 04:50:00	SPY	ETF	273.45	273.45	273.45	273.45	300.0
2018-05-24 04:53:00	SPY	ETF	273.4	273.4	273.4	273.4	700.0
2018-05-24 04:54:00	SPY	ETF	273.37	273.4	273.37	273.37	1200.0
2018-05-24 04:55:00	SPY	ETF	273.4	273.4	273.4	273.4	530.0
2018-05-24 04:58:00	SPY	ETF	273.39	273.39	273.39	273.39	500.0
2018-05-24 04:59:00	SPY	ETF	273.37	273.45	273.37	273.45	1900.0
2018-05-24 05:00:00	SPY	ETF	273.45	273.46	273.45	273.46	1700.0
2018-05-24 05:01:00	SPY	ETF	273.47	273.47	273.47	273.47	1400.0
2018-05-24 05:02:00	SPY	ETF	273.5	273.5	273.5	273.5	2300.0
2018-05-24 05:03:00	SPY	ETF	273.42	273.42	273.42	273.42	300.0
2018-05-24 05:06:00	SPY	ETF	273.37	273.37	273.37	273.37	820.0
2018-05-24 05:15:00	SPY	ETF	273.3	273.3	273.3	273.3	3000.0
2018-05-24 05:16:00	SPY	ETF	273.33	273.33	273.32	273.32	700.0
2018-05-24 05:17:00	SPY	ETF	273.34	273.34	273.34	273.34	400.0
2018-05-24 05:19:00	SPY	ETF	273.34	273.34	273.34	273.34	300.0
2018-05-24 05:23:00	SPY	ETF	273.3	273.3	273.3	273.3	300.0
2018-05-24 05:28:00	SPY	ETF	273.34	273.34	273.34	273.34	700.0
2018-05-24 05:29:00	SPY	ETF	273.3	273.3	273.3	273.3	300.0
2018-05-24 05:32:00	SPY	ETF	273.27	273.27	273.27	273.27	300.0
2018-05-24 05:33:00	SPY	ETF	273.29	273.29	273.29	273.29	300.0
2018-05-24 05:37:00	SPY	ETF	273.27	273.27	273.27	273.27	400.0
2018-05-24 05:39:00	SPY	ETF	273.29	273.29	273.29	273.29	800.0
2018-05-24 05:40:00	SPY	ETF	273.32	273.34	273.32	273.34	1200.0
2018-05-24 05:42:00	SPY	ETF	273.35	273.37	273.35	273.37	1200.0
2018-05-24 05:47:00	SPY	ETF	273.33	273.33	273.33	273.33	5000.0
2018-05-24 05:48:00	SPY	ETF	273.29	273.29	273.29	273.29	500.0
2018-05-24 05:51:00	SPY	ETF	273.37	273.37	273.37	273.37	500.0
2018-05-24 05:52:00	SPY	ETF	273.34	273.34	273.34	273.34	300.0
2018-05-24 05:55:00	SPY	ETF	273.42	273.42	273.42	273.42	300.0
2018-05-24 05:56:00	SPY	ETF	273.4	273.4	273.4	273.4	100.0
2018-05-24 05:59:00	SPY	ETF	273.37	273.37	273.37	273.37	500.0
2018-05-24 06:00:00	SPY	ETF	273.37	273.37	273.37	273.37	800.0
2018-05-24 06:03:00	SPY	ETF	273.37	273.37	273.34	273.34	4000.0
2018-05-24 06:11:00	SPY	ETF	273.37	273.37	273.37	273.37	1000.0
2018-05-24 06:12:00	SPY	ETF	273.37	273.37	273.37	273.37	500.0
2018-05-24 06:22:00	SPY	ETF	273.38	273.38	273.38	273.38	5000.0
2018-05-24 06:24:00	SPY	ETF	273.34	273.34	273.32	273.32	2700.0
2018-05-24 06:25:00	SPY	ETF	273.32	273.32	273.32	273.32	400.0
2018-05-24 06:27:00	SPY	ETF	273.32	273.32	273.32	273.32	300.0
2018-05-24 06:28:00	SPY	ETF	273.32	273.32	273.32	273.32	300.0
2018-05-24 06:29:00	SPY	ETF	273.35	273.43	273.35	273.38	9550.0
2018-05-24 06:30:00	SPY	ETF	273.37	273.37	273.33	273.33	300.0
2018-05-24 06:31:00	SPY	ETF	273.33	273.33	273.33	273.33	600.0
2018-05-24 06:32:00	SPY	ETF	273.33	273.33	273.33	273.33	100.0

> showing 50 of 144,642 rows — these rows as CSV

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