PREVIEW / etf_1min / 2019-09-18

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-09-18.parquet
  size:    3.1 MB
  rows:    154,846

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
2019-09-18 04:11:00	SPY	ETF	300.74	300.74	300.74	300.74	100.0
2019-09-18 04:17:00	SPY	ETF	300.8	300.8	300.8	300.8	800.0
2019-09-18 04:22:00	SPY	ETF	300.8	300.8	300.8	300.8	1130.0
2019-09-18 04:25:00	SPY	ETF	300.77	300.77	300.77	300.77	100.0
2019-09-18 04:27:00	SPY	ETF	300.73	300.73	300.73	300.73	200.0
2019-09-18 04:32:00	SPY	ETF	300.73	300.73	300.73	300.73	1360.0
2019-09-18 04:58:00	SPY	ETF	300.64	300.64	300.64	300.64	2000.0
2019-09-18 05:02:00	SPY	ETF	300.55	300.55	300.55	300.55	2000.0
2019-09-18 05:15:00	SPY	ETF	300.54	300.54	300.53	300.53	5000.0
2019-09-18 05:18:00	SPY	ETF	300.54	300.54	300.54	300.54	300.0
2019-09-18 05:19:00	SPY	ETF	300.5	300.52	300.5	300.52	1290.0
2019-09-18 05:24:00	SPY	ETF	300.56	300.56	300.56	300.56	100.0
2019-09-18 05:42:00	SPY	ETF	300.56	300.56	300.56	300.56	500.0
2019-09-18 05:53:00	SPY	ETF	300.53	300.53	300.53	300.53	300.0
2019-09-18 05:54:00	SPY	ETF	300.52	300.52	300.52	300.52	1000.0
2019-09-18 05:56:00	SPY	ETF	300.52	300.52	300.48	300.48	400.0
2019-09-18 05:57:00	SPY	ETF	300.52	300.52	300.51	300.52	900.0
2019-09-18 05:58:00	SPY	ETF	300.52	300.52	300.52	300.52	175.0
2019-09-18 06:08:00	SPY	ETF	300.52	300.52	300.52	300.52	100.0
2019-09-18 06:10:00	SPY	ETF	300.53	300.53	300.53	300.53	100.0
2019-09-18 06:13:00	SPY	ETF	300.5	300.51	300.5	300.51	1000.0
2019-09-18 06:14:00	SPY	ETF	300.48	300.48	300.48	300.48	300.0
2019-09-18 06:17:00	SPY	ETF	300.45	300.45	300.45	300.45	100.0
2019-09-18 06:18:00	SPY	ETF	300.45	300.45	300.45	300.45	900.0
2019-09-18 06:20:00	SPY	ETF	300.43	300.43	300.43	300.43	1000.0
2019-09-18 06:21:00	SPY	ETF	300.45	300.45	300.45	300.45	150.0
2019-09-18 06:29:00	SPY	ETF	300.51	300.51	300.51	300.51	100.0
2019-09-18 06:31:00	SPY	ETF	300.51	300.51	300.51	300.51	8000.0
2019-09-18 06:32:00	SPY	ETF	300.52	300.52	300.52	300.52	400.0
2019-09-18 06:42:00	SPY	ETF	300.6	300.6	300.58	300.6	5000.0
2019-09-18 06:46:00	SPY	ETF	300.55	300.55	300.55	300.55	300.0
2019-09-18 06:48:00	SPY	ETF	300.58	300.58	300.58	300.58	396.0
2019-09-18 06:54:00	SPY	ETF	300.57	300.57	300.57	300.57	6600.0
2019-09-18 06:55:00	SPY	ETF	300.55	300.55	300.55	300.55	1200.0
2019-09-18 06:56:00	SPY	ETF	300.53	300.53	300.53	300.53	1000.0
2019-09-18 07:00:00	SPY	ETF	300.63	300.63	300.6	300.6	261.0
2019-09-18 07:01:00	SPY	ETF	300.61	300.61	300.6	300.6	12642.0
2019-09-18 07:02:00	SPY	ETF	300.6	300.6	300.6	300.6	100.0
2019-09-18 07:03:00	SPY	ETF	300.6	300.6	300.59	300.59	958.0
2019-09-18 07:05:00	SPY	ETF	300.58	300.58	300.58	300.58	900.0
2019-09-18 07:06:00	SPY	ETF	300.55	300.55	300.54	300.54	3100.0
2019-09-18 07:07:00	SPY	ETF	300.51	300.51	300.51	300.51	977.0
2019-09-18 07:08:00	SPY	ETF	300.5	300.51	300.46	300.46	13008.0
2019-09-18 07:09:00	SPY	ETF	300.46	300.46	300.4	300.4	18450.0
2019-09-18 07:10:00	SPY	ETF	300.39	300.42	300.37	300.41	17764.0
2019-09-18 07:11:00	SPY	ETF	300.42	300.42	300.41	300.41	9530.0
2019-09-18 07:12:00	SPY	ETF	300.36	300.4	300.36	300.4	8475.0
2019-09-18 07:13:00	SPY	ETF	300.42	300.42	300.42	300.42	2515.0
2019-09-18 07:14:00	SPY	ETF	300.38	300.38	300.38	300.38	1004.0
2019-09-18 07:15:00	SPY	ETF	300.4	300.4	300.4	300.4	500.0

> showing 50 of 154,846 rows — these rows as CSV

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