PREVIEW / etf_1min / 2017-06-19

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-06-19.parquet
  size:    2.7 MB
  rows:    139,342

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-19 04:00:00	SPY	ETF	243.2	243.2	243.2	243.2	310.0
2017-06-19 04:04:00	SPY	ETF	243.38	243.38	243.38	243.38	110.0
2017-06-19 04:05:00	SPY	ETF	243.3	243.3	243.3	243.3	3000.0
2017-06-19 04:22:00	SPY	ETF	243.4	243.4	243.4	243.4	100.0
2017-06-19 04:23:00	SPY	ETF	243.42	243.42	243.3	243.3	1500.0
2017-06-19 04:27:00	SPY	ETF	243.37	243.37	243.37	243.37	1000.0
2017-06-19 04:32:00	SPY	ETF	243.3	243.3	243.3	243.3	400.0
2017-06-19 04:34:00	SPY	ETF	243.31	243.31	243.31	243.31	500.0
2017-06-19 04:42:00	SPY	ETF	243.34	243.34	243.34	243.34	100.0
2017-06-19 04:43:00	SPY	ETF	243.3	243.3	243.3	243.3	100.0
2017-06-19 04:56:00	SPY	ETF	243.35	243.35	243.35	243.35	500.0
2017-06-19 05:03:00	SPY	ETF	243.35	243.35	243.35	243.35	100.0
2017-06-19 05:31:00	SPY	ETF	243.44	243.44	243.44	243.44	102.0
2017-06-19 05:32:00	SPY	ETF	243.44	243.44	243.44	243.44	200.0
2017-06-19 05:34:00	SPY	ETF	243.46	243.46	243.46	243.46	500.0
2017-06-19 05:35:00	SPY	ETF	243.44	243.44	243.44	243.44	500.0
2017-06-19 05:40:00	SPY	ETF	243.35	243.35	243.34	243.34	2300.0
2017-06-19 05:44:00	SPY	ETF	243.31	243.31	243.31	243.31	1000.0
2017-06-19 05:58:00	SPY	ETF	243.33	243.33	243.33	243.33	300.0
2017-06-19 06:06:00	SPY	ETF	243.33	243.33	243.33	243.33	1000.0
2017-06-19 06:24:00	SPY	ETF	243.3	243.3	243.3	243.3	150.0
2017-06-19 06:37:00	SPY	ETF	243.31	243.31	243.31	243.31	260.0
2017-06-19 06:41:00	SPY	ETF	243.33	243.33	243.33	243.33	100.0
2017-06-19 06:46:00	SPY	ETF	243.35	243.35	243.35	243.35	100.0
2017-06-19 06:47:00	SPY	ETF	243.35	243.35	243.35	243.35	130.0
2017-06-19 06:49:00	SPY	ETF	243.32	243.32	243.32	243.32	1500.0
2017-06-19 06:52:00	SPY	ETF	243.33	243.33	243.33	243.33	420.0
2017-06-19 06:56:00	SPY	ETF	243.35	243.35	243.35	243.35	300.0
2017-06-19 07:01:00	SPY	ETF	243.4	243.42	243.4	243.42	7000.0
2017-06-19 07:02:00	SPY	ETF	243.42	243.42	243.4	243.4	2530.0
2017-06-19 07:03:00	SPY	ETF	243.4	243.4	243.4	243.4	600.0
2017-06-19 07:06:00	SPY	ETF	243.4	243.41	243.4	243.41	10000.0
2017-06-19 07:08:00	SPY	ETF	243.4	243.4	243.4	243.4	4000.0
2017-06-19 07:11:00	SPY	ETF	243.4	243.4	243.4	243.4	400.0
2017-06-19 07:15:00	SPY	ETF	243.41	243.41	243.41	243.41	300.0
2017-06-19 07:17:00	SPY	ETF	243.39	243.41	243.39	243.41	2200.0
2017-06-19 07:18:00	SPY	ETF	243.41	243.41	243.4	243.4	1197.0
2017-06-19 07:20:00	SPY	ETF	243.41	243.41	243.41	243.41	500.0
2017-06-19 07:21:00	SPY	ETF	243.41	243.41	243.41	243.41	510.0
2017-06-19 07:22:00	SPY	ETF	243.41	243.41	243.41	243.41	1910.0
2017-06-19 07:25:00	SPY	ETF	243.44	243.44	243.44	243.44	1110.0
2017-06-19 07:26:00	SPY	ETF	243.46	243.46	243.46	243.46	2910.0
2017-06-19 07:27:00	SPY	ETF	243.44	243.44	243.44	243.44	510.0
2017-06-19 07:28:00	SPY	ETF	243.45	243.46	243.45	243.46	2310.0
2017-06-19 07:32:00	SPY	ETF	243.44	243.44	243.44	243.44	969.0
2017-06-19 07:33:00	SPY	ETF	243.43	243.43	243.42	243.42	1400.0
2017-06-19 07:35:00	SPY	ETF	243.47	243.48	243.47	243.48	1138.0
2017-06-19 07:36:00	SPY	ETF	243.47	243.47	243.47	243.47	469.0
2017-06-19 07:37:00	SPY	ETF	243.47	243.49	243.47	243.49	32544.0
2017-06-19 07:39:00	SPY	ETF	243.48	243.48	243.48	243.48	456.0

> showing 50 of 139,342 rows — these rows as CSV

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