PREVIEW / etf_1min / 2017-09-25

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-09-25.parquet
  size:    2.8 MB
  rows:    142,061

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-09-25 04:00:00	SPY	ETF	249.36	249.36	249.25	249.25	875.0
2017-09-25 04:04:00	SPY	ETF	249.2	249.2	249.2	249.2	2500.0
2017-09-25 04:06:00	SPY	ETF	249.18	249.18	249.18	249.18	3000.0
2017-09-25 04:07:00	SPY	ETF	249.15	249.15	249.15	249.15	2800.0
2017-09-25 04:11:00	SPY	ETF	249.18	249.18	249.18	249.18	2000.0
2017-09-25 04:29:00	SPY	ETF	249.11	249.11	249.11	249.11	100.0
2017-09-25 04:35:00	SPY	ETF	249.15	249.15	249.11	249.11	1000.0
2017-09-25 04:36:00	SPY	ETF	249.07	249.07	249.07	249.07	4800.0
2017-09-25 04:38:00	SPY	ETF	249.18	249.18	249.18	249.18	100.0
2017-09-25 04:40:00	SPY	ETF	249.21	249.21	249.21	249.21	302.0
2017-09-25 04:43:00	SPY	ETF	249.29	249.29	249.29	249.29	300.0
2017-09-25 04:45:00	SPY	ETF	249.26	249.26	249.26	249.26	302.0
2017-09-25 04:59:00	SPY	ETF	249.34	249.34	249.34	249.34	630.0
2017-09-25 05:00:00	SPY	ETF	249.34	249.34	249.34	249.34	1201.0
2017-09-25 05:01:00	SPY	ETF	249.28	249.28	249.28	249.28	302.0
2017-09-25 05:08:00	SPY	ETF	249.29	249.29	249.29	249.29	1100.0
2017-09-25 05:15:00	SPY	ETF	249.31	249.31	249.31	249.31	501.0
2017-09-25 05:19:00	SPY	ETF	249.26	249.26	249.26	249.26	502.0
2017-09-25 05:32:00	SPY	ETF	249.19	249.19	249.19	249.19	300.0
2017-09-25 05:36:00	SPY	ETF	249.16	249.16	249.16	249.16	1802.0
2017-09-25 05:37:00	SPY	ETF	249.17	249.17	249.15	249.15	503.0
2017-09-25 05:38:00	SPY	ETF	249.11	249.11	249.11	249.11	501.0
2017-09-25 05:39:00	SPY	ETF	249.12	249.12	249.12	249.12	200.0
2017-09-25 05:40:00	SPY	ETF	249.12	249.12	249.12	249.12	100.0
2017-09-25 05:46:00	SPY	ETF	249.12	249.12	249.11	249.11	400.0
2017-09-25 05:54:00	SPY	ETF	249.16	249.16	249.16	249.16	2600.0
2017-09-25 05:56:00	SPY	ETF	249.18	249.18	249.18	249.18	2302.0
2017-09-25 05:58:00	SPY	ETF	249.18	249.18	249.18	249.18	600.0
2017-09-25 05:59:00	SPY	ETF	249.25	249.25	249.25	249.25	301.0
2017-09-25 06:07:00	SPY	ETF	249.28	249.28	249.28	249.28	300.0
2017-09-25 06:13:00	SPY	ETF	249.31	249.31	249.31	249.31	300.0
2017-09-25 06:18:00	SPY	ETF	249.31	249.31	249.31	249.31	1000.0
2017-09-25 06:23:00	SPY	ETF	249.33	249.33	249.33	249.33	401.0
2017-09-25 06:39:00	SPY	ETF	249.33	249.33	249.33	249.33	2400.0
2017-09-25 06:44:00	SPY	ETF	249.33	249.33	249.33	249.33	200.0
2017-09-25 06:48:00	SPY	ETF	249.33	249.33	249.33	249.33	5800.0
2017-09-25 06:50:00	SPY	ETF	249.34	249.37	249.34	249.37	2272.0
2017-09-25 06:51:00	SPY	ETF	249.34	249.34	249.34	249.34	1450.0
2017-09-25 06:53:00	SPY	ETF	249.37	249.37	249.37	249.37	5000.0
2017-09-25 07:00:00	SPY	ETF	249.39	249.39	249.39	249.39	230.0
2017-09-25 07:02:00	SPY	ETF	249.42	249.42	249.42	249.42	1500.0
2017-09-25 07:07:00	SPY	ETF	249.41	249.41	249.41	249.41	100.0
2017-09-25 07:08:00	SPY	ETF	249.42	249.42	249.42	249.42	4320.0
2017-09-25 07:12:00	SPY	ETF	249.41	249.41	249.41	249.41	300.0
2017-09-25 07:17:00	SPY	ETF	249.41	249.41	249.41	249.41	500.0
2017-09-25 07:18:00	SPY	ETF	249.41	249.41	249.41	249.41	1500.0
2017-09-25 07:21:00	SPY	ETF	249.4	249.4	249.4	249.4	200.0
2017-09-25 07:22:00	SPY	ETF	249.39	249.39	249.39	249.39	143.0
2017-09-25 07:26:00	SPY	ETF	249.36	249.36	249.34	249.34	902.0
2017-09-25 07:29:00	SPY	ETF	249.36	249.39	249.36	249.39	412.0

> showing 50 of 142,061 rows — these rows as CSV

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