PREVIEW / etf_1min / 2018-05-14

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-05-14.parquet
  size:    2.8 MB
  rows:    147,687

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-14 04:00:00	SPY	ETF	273.28	273.44	273.28	273.44	1474.0
2018-05-14 04:01:00	SPY	ETF	273.5	273.54	273.48	273.49	1672.0
2018-05-14 04:02:00	SPY	ETF	273.5	273.5	273.47	273.47	412.0
2018-05-14 04:05:00	SPY	ETF	273.49	273.49	273.49	273.49	175.0
2018-05-14 04:06:00	SPY	ETF	273.47	273.49	273.47	273.49	860.0
2018-05-14 04:07:00	SPY	ETF	273.49	273.49	273.49	273.49	500.0
2018-05-14 04:08:00	SPY	ETF	273.49	273.49	273.49	273.49	500.0
2018-05-14 04:11:00	SPY	ETF	273.49	273.49	273.44	273.44	1019.0
2018-05-14 04:14:00	SPY	ETF	273.49	273.49	273.44	273.44	815.0
2018-05-14 04:16:00	SPY	ETF	273.44	273.44	273.44	273.44	330.0
2018-05-14 04:18:00	SPY	ETF	273.51	273.51	273.51	273.51	1000.0
2018-05-14 04:21:00	SPY	ETF	273.49	273.49	273.49	273.49	510.0
2018-05-14 04:22:00	SPY	ETF	273.5	273.5	273.47	273.47	1515.0
2018-05-14 04:25:00	SPY	ETF	273.53	273.53	273.53	273.53	415.0
2018-05-14 04:26:00	SPY	ETF	273.53	273.53	273.51	273.51	550.0
2018-05-14 04:28:00	SPY	ETF	273.52	273.52	273.52	273.52	300.0
2018-05-14 04:29:00	SPY	ETF	273.56	273.56	273.56	273.56	475.0
2018-05-14 04:31:00	SPY	ETF	273.51	273.51	273.51	273.51	345.0
2018-05-14 04:33:00	SPY	ETF	273.53	273.53	273.53	273.53	415.0
2018-05-14 04:40:00	SPY	ETF	273.51	273.51	273.51	273.51	170.0
2018-05-14 04:43:00	SPY	ETF	273.48	273.48	273.48	273.48	425.0
2018-05-14 04:44:00	SPY	ETF	273.46	273.46	273.46	273.46	218.0
2018-05-14 04:45:00	SPY	ETF	273.42	273.42	273.42	273.42	345.0
2018-05-14 04:50:00	SPY	ETF	273.46	273.46	273.46	273.46	1055.0
2018-05-14 04:52:00	SPY	ETF	273.44	273.44	273.44	273.44	100.0
2018-05-14 04:54:00	SPY	ETF	273.44	273.44	273.43	273.43	615.0
2018-05-14 04:55:00	SPY	ETF	273.46	273.46	273.46	273.46	245.0
2018-05-14 04:56:00	SPY	ETF	273.4	273.4	273.4	273.4	715.0
2018-05-14 04:58:00	SPY	ETF	273.42	273.42	273.42	273.42	340.0
2018-05-14 05:02:00	SPY	ETF	273.48	273.48	273.45	273.45	405.0
2018-05-14 05:09:00	SPY	ETF	273.48	273.48	273.48	273.48	300.0
2018-05-14 05:14:00	SPY	ETF	273.47	273.47	273.47	273.47	805.0
2018-05-14 05:16:00	SPY	ETF	273.5	273.5	273.5	273.5	305.0
2018-05-14 05:18:00	SPY	ETF	273.54	273.54	273.52	273.52	905.0
2018-05-14 05:21:00	SPY	ETF	273.52	273.52	273.52	273.52	315.0
2018-05-14 05:22:00	SPY	ETF	273.52	273.52	273.52	273.52	300.0
2018-05-14 05:25:00	SPY	ETF	273.55	273.55	273.55	273.55	315.0
2018-05-14 05:32:00	SPY	ETF	273.55	273.55	273.55	273.55	1510.0
2018-05-14 05:34:00	SPY	ETF	273.58	273.59	273.57	273.57	2325.0
2018-05-14 05:36:00	SPY	ETF	273.6	273.6	273.59	273.59	5440.0
2018-05-14 05:39:00	SPY	ETF	273.59	273.59	273.59	273.59	300.0
2018-05-14 05:53:00	SPY	ETF	273.53	273.53	273.53	273.53	205.0
2018-05-14 05:54:00	SPY	ETF	273.54	273.54	273.54	273.54	205.0
2018-05-14 05:56:00	SPY	ETF	273.51	273.51	273.51	273.51	1055.0
2018-05-14 06:01:00	SPY	ETF	273.47	273.47	273.47	273.47	105.0
2018-05-14 06:02:00	SPY	ETF	273.49	273.49	273.49	273.49	420.0
2018-05-14 06:04:00	SPY	ETF	273.48	273.48	273.48	273.48	100.0
2018-05-14 06:09:00	SPY	ETF	273.45	273.45	273.45	273.45	1721.0
2018-05-14 06:11:00	SPY	ETF	273.45	273.45	273.45	273.45	200.0
2018-05-14 06:12:00	SPY	ETF	273.46	273.46	273.46	273.46	100.0

> showing 50 of 147,687 rows — these rows as CSV

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