PREVIEW / etf_1min / 2019-06-25

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-06-25.parquet
  size:    3.2 MB
  rows:    168,321

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-06-25 04:00:00	SPY	ETF	293.22	293.34	293.15	293.33	1704.0
2019-06-25 04:01:00	SPY	ETF	293.33	293.33	293.26	293.26	900.0
2019-06-25 04:03:00	SPY	ETF	293.33	293.33	293.33	293.33	1080.0
2019-06-25 04:16:00	SPY	ETF	293.23	293.23	293.23	293.23	100.0
2019-06-25 04:21:00	SPY	ETF	293.3	293.3	293.3	293.3	900.0
2019-06-25 04:34:00	SPY	ETF	293.4	293.4	293.4	293.4	530.0
2019-06-25 04:35:00	SPY	ETF	293.44	293.55	293.44	293.55	2704.0
2019-06-25 04:42:00	SPY	ETF	293.5	293.5	293.5	293.5	250.0
2019-06-25 04:58:00	SPY	ETF	293.23	293.23	293.23	293.23	100.0
2019-06-25 05:00:00	SPY	ETF	293.2	293.2	293.2	293.2	100.0
2019-06-25 05:17:00	SPY	ETF	293.2	293.2	293.2	293.2	100.0
2019-06-25 05:20:00	SPY	ETF	293.3	293.3	293.3	293.3	100.0
2019-06-25 05:29:00	SPY	ETF	293.28	293.28	293.28	293.28	1000.0
2019-06-25 05:41:00	SPY	ETF	293.41	293.41	293.41	293.41	200.0
2019-06-25 05:43:00	SPY	ETF	293.41	293.41	293.36	293.36	1300.0
2019-06-25 05:48:00	SPY	ETF	293.41	293.41	293.41	293.41	100.0
2019-06-25 05:58:00	SPY	ETF	293.34	293.34	293.34	293.34	121.0
2019-06-25 06:02:00	SPY	ETF	293.33	293.33	293.33	293.33	200.0
2019-06-25 06:03:00	SPY	ETF	293.31	293.31	293.31	293.31	300.0
2019-06-25 06:04:00	SPY	ETF	293.24	293.24	293.24	293.24	100.0
2019-06-25 06:08:00	SPY	ETF	293.26	293.26	293.26	293.26	100.0
2019-06-25 06:22:00	SPY	ETF	293.29	293.29	293.29	293.29	600.0
2019-06-25 06:23:00	SPY	ETF	293.3	293.3	293.3	293.3	500.0
2019-06-25 06:29:00	SPY	ETF	293.3	293.3	293.3	293.3	302.0
2019-06-25 06:31:00	SPY	ETF	293.28	293.28	293.27	293.28	1500.0
2019-06-25 06:32:00	SPY	ETF	293.28	293.28	293.28	293.28	1025.0
2019-06-25 06:35:00	SPY	ETF	293.2	293.2	293.2	293.2	342.0
2019-06-25 06:40:00	SPY	ETF	293.3	293.3	293.3	293.3	342.0
2019-06-25 06:42:00	SPY	ETF	293.3	293.3	293.3	293.3	485.0
2019-06-25 06:43:00	SPY	ETF	293.31	293.31	293.31	293.31	300.0
2019-06-25 06:47:00	SPY	ETF	293.31	293.31	293.31	293.31	169.0
2019-06-25 06:49:00	SPY	ETF	293.26	293.26	293.24	293.24	2986.0
2019-06-25 06:50:00	SPY	ETF	293.24	293.25	293.24	293.25	2014.0
2019-06-25 06:53:00	SPY	ETF	293.25	293.25	293.25	293.25	20000.0
2019-06-25 06:55:00	SPY	ETF	293.33	293.33	293.33	293.33	305.0
2019-06-25 06:56:00	SPY	ETF	293.43	293.43	293.43	293.43	500.0
2019-06-25 06:59:00	SPY	ETF	293.37	293.39	293.37	293.39	400.0
2019-06-25 07:00:00	SPY	ETF	293.39	293.39	293.39	293.39	109.0
2019-06-25 07:01:00	SPY	ETF	293.48	293.48	293.48	293.48	1050.0
2019-06-25 07:02:00	SPY	ETF	293.48	293.48	293.48	293.48	450.0
2019-06-25 07:03:00	SPY	ETF	293.46	293.46	293.46	293.46	125.0
2019-06-25 07:04:00	SPY	ETF	293.49	293.49	293.49	293.49	364.0
2019-06-25 07:05:00	SPY	ETF	293.5	293.5	293.5	293.5	200.0
2019-06-25 07:06:00	SPY	ETF	293.48	293.48	293.45	293.46	3485.0
2019-06-25 07:09:00	SPY	ETF	293.45	293.45	293.45	293.45	4300.0
2019-06-25 07:12:00	SPY	ETF	293.45	293.46	293.45	293.46	10905.0
2019-06-25 07:13:00	SPY	ETF	293.46	293.46	293.42	293.46	534.0
2019-06-25 07:14:00	SPY	ETF	293.48	293.49	293.48	293.49	8795.0
2019-06-25 07:15:00	SPY	ETF	293.45	293.45	293.45	293.45	300.0
2019-06-25 07:17:00	SPY	ETF	293.46	293.46	293.45	293.45	7300.0

> showing 50 of 168,321 rows — these rows as CSV

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