PREVIEW / etf_1min / 2017-09-05

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-09-05.parquet
  size:    3.0 MB
  rows:    152,212

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-05 04:00:00	SPY	ETF	247.3	247.3	247.3	247.3	413.0
2017-09-05 04:34:00	SPY	ETF	247.42	247.42	247.42	247.42	100.0
2017-09-05 04:36:00	SPY	ETF	247.37	247.37	247.37	247.37	300.0
2017-09-05 04:53:00	SPY	ETF	247.29	247.29	247.29	247.29	380.0
2017-09-05 05:08:00	SPY	ETF	247.31	247.31	247.31	247.31	100.0
2017-09-05 05:13:00	SPY	ETF	247.3	247.3	247.3	247.3	201.0
2017-09-05 05:15:00	SPY	ETF	247.32	247.34	247.32	247.34	803.0
2017-09-05 05:17:00	SPY	ETF	247.34	247.34	247.34	247.34	600.0
2017-09-05 05:23:00	SPY	ETF	247.35	247.35	247.35	247.35	100.0
2017-09-05 05:25:00	SPY	ETF	247.37	247.37	247.37	247.37	100.0
2017-09-05 05:34:00	SPY	ETF	247.3	247.3	247.3	247.3	505.0
2017-09-05 05:37:00	SPY	ETF	247.27	247.27	247.27	247.27	3300.0
2017-09-05 05:38:00	SPY	ETF	247.29	247.29	247.29	247.29	1500.0
2017-09-05 05:39:00	SPY	ETF	247.29	247.29	247.29	247.29	500.0
2017-09-05 05:42:00	SPY	ETF	247.25	247.25	247.25	247.25	155.0
2017-09-05 05:43:00	SPY	ETF	247.2	247.2	247.2	247.2	3500.0
2017-09-05 05:46:00	SPY	ETF	247.2	247.22	247.2	247.22	6250.0
2017-09-05 05:49:00	SPY	ETF	247.2	247.2	247.2	247.2	600.0
2017-09-05 05:54:00	SPY	ETF	247.17	247.17	247.17	247.17	302.0
2017-09-05 05:56:00	SPY	ETF	247.16	247.16	247.16	247.16	201.0
2017-09-05 05:58:00	SPY	ETF	247.18	247.18	247.17	247.17	800.0
2017-09-05 06:02:00	SPY	ETF	247.16	247.16	247.16	247.16	214.0
2017-09-05 06:03:00	SPY	ETF	247.14	247.14	247.14	247.14	200.0
2017-09-05 06:23:00	SPY	ETF	247.1	247.1	247.08	247.08	5400.0
2017-09-05 06:24:00	SPY	ETF	247.08	247.08	247.07	247.07	1501.0
2017-09-05 06:25:00	SPY	ETF	247.07	247.07	247.07	247.07	190.0
2017-09-05 06:26:00	SPY	ETF	247.07	247.07	247.05	247.05	302.0
2017-09-05 06:28:00	SPY	ETF	247.05	247.05	247.02	247.02	1206.0
2017-09-05 06:29:00	SPY	ETF	247.01	247.01	246.94	246.94	689.0
2017-09-05 06:36:00	SPY	ETF	246.95	246.95	246.95	246.95	300.0
2017-09-05 06:37:00	SPY	ETF	246.95	246.95	246.95	246.95	300.0
2017-09-05 06:38:00	SPY	ETF	246.94	246.94	246.94	246.94	1100.0
2017-09-05 06:39:00	SPY	ETF	246.94	246.94	246.94	246.94	300.0
2017-09-05 06:40:00	SPY	ETF	246.94	246.94	246.94	246.94	500.0
2017-09-05 06:44:00	SPY	ETF	247.0	247.01	247.0	247.01	25000.0
2017-09-05 06:45:00	SPY	ETF	247.0	247.0	247.0	247.0	1000.0
2017-09-05 06:47:00	SPY	ETF	247.02	247.02	247.02	247.02	202.0
2017-09-05 06:48:00	SPY	ETF	247.03	247.03	247.03	247.03	100.0
2017-09-05 06:49:00	SPY	ETF	247.05	247.05	247.05	247.05	14000.0
2017-09-05 06:50:00	SPY	ETF	247.03	247.04	247.03	247.03	11400.0
2017-09-05 06:51:00	SPY	ETF	247.05	247.05	247.03	247.03	11800.0
2017-09-05 06:52:00	SPY	ETF	247.03	247.03	247.01	247.01	13309.0
2017-09-05 06:53:00	SPY	ETF	247.01	247.01	247.01	247.01	100.0
2017-09-05 06:56:00	SPY	ETF	247.01	247.04	247.01	247.04	300.0
2017-09-05 06:59:00	SPY	ETF	247.03	247.03	247.03	247.03	160.0
2017-09-05 07:00:00	SPY	ETF	247.05	247.05	247.05	247.05	5002.0
2017-09-05 07:03:00	SPY	ETF	247.08	247.08	247.04	247.04	300.0
2017-09-05 07:04:00	SPY	ETF	247.04	247.04	247.03	247.03	702.0
2017-09-05 07:06:00	SPY	ETF	247.06	247.06	247.05	247.06	8460.0
2017-09-05 07:07:00	SPY	ETF	247.06	247.06	247.06	247.06	200.0

> showing 50 of 152,212 rows — these rows as CSV

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