PREVIEW / etf_1min / 2017-11-24

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-11-24.parquet
  size:    1.4 MB
  rows:    73,028

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-11-24 04:00:00	SPY	ETF	259.8	259.88	259.8	259.88	1600.0
2017-11-24 04:01:00	SPY	ETF	259.9	259.92	259.9	259.92	300.0
2017-11-24 04:02:00	SPY	ETF	259.95	259.95	259.95	259.95	100.0
2017-11-24 04:03:00	SPY	ETF	259.95	259.95	259.95	259.95	400.0
2017-11-24 04:04:00	SPY	ETF	259.97	259.97	259.97	259.97	100.0
2017-11-24 04:20:00	SPY	ETF	259.95	259.95	259.95	259.95	1000.0
2017-11-24 04:27:00	SPY	ETF	259.9	259.9	259.9	259.9	300.0
2017-11-24 05:17:00	SPY	ETF	259.9	259.9	259.9	259.9	100.0
2017-11-24 05:21:00	SPY	ETF	259.99	259.99	259.99	259.99	202.0
2017-11-24 05:26:00	SPY	ETF	259.99	260.0	259.99	259.99	582.0
2017-11-24 05:39:00	SPY	ETF	260.04	260.04	260.04	260.04	100.0
2017-11-24 05:48:00	SPY	ETF	260.08	260.1	260.08	260.1	8204.0
2017-11-24 06:03:00	SPY	ETF	260.06	260.06	260.06	260.06	2001.0
2017-11-24 06:05:00	SPY	ETF	260.12	260.12	260.12	260.12	100.0
2017-11-24 06:06:00	SPY	ETF	260.12	260.12	260.12	260.12	500.0
2017-11-24 06:08:00	SPY	ETF	260.12	260.12	260.12	260.12	400.0
2017-11-24 06:10:00	SPY	ETF	260.12	260.12	260.12	260.12	300.0
2017-11-24 06:11:00	SPY	ETF	260.12	260.12	260.12	260.12	500.0
2017-11-24 06:12:00	SPY	ETF	260.12	260.12	260.12	260.12	201.0
2017-11-24 06:13:00	SPY	ETF	260.15	260.4	260.15	260.4	2953.0
2017-11-24 06:14:00	SPY	ETF	260.14	260.14	260.14	260.14	500.0
2017-11-24 06:24:00	SPY	ETF	260.18	260.18	260.18	260.18	500.0
2017-11-24 06:36:00	SPY	ETF	260.26	260.26	260.26	260.26	251.0
2017-11-24 06:37:00	SPY	ETF	260.33	260.33	260.33	260.33	27402.0
2017-11-24 06:38:00	SPY	ETF	260.33	260.33	260.33	260.33	1298.0
2017-11-24 06:41:00	SPY	ETF	260.32	260.32	260.32	260.32	2000.0
2017-11-24 06:46:00	SPY	ETF	260.32	260.32	260.32	260.32	5600.0
2017-11-24 06:48:00	SPY	ETF	260.34	260.34	260.34	260.34	1500.0
2017-11-24 06:49:00	SPY	ETF	260.34	260.34	260.34	260.34	112.0
2017-11-24 06:52:00	SPY	ETF	260.29	260.29	260.29	260.29	150.0
2017-11-24 06:53:00	SPY	ETF	260.3	260.33	260.3	260.33	2201.0
2017-11-24 06:54:00	SPY	ETF	260.32	260.32	260.32	260.32	200.0
2017-11-24 06:55:00	SPY	ETF	260.33	260.35	260.33	260.35	1200.0
2017-11-24 06:56:00	SPY	ETF	260.35	260.35	260.33	260.33	200.0
2017-11-24 07:00:00	SPY	ETF	260.29	260.29	260.29	260.29	6000.0
2017-11-24 07:02:00	SPY	ETF	260.3	260.3	260.3	260.3	300.0
2017-11-24 07:03:00	SPY	ETF	260.29	260.29	260.29	260.29	669.0
2017-11-24 07:04:00	SPY	ETF	260.29	260.29	260.29	260.29	2969.0
2017-11-24 07:05:00	SPY	ETF	260.3	260.3	260.3	260.3	5369.0
2017-11-24 07:06:00	SPY	ETF	260.31	260.31	260.31	260.31	3507.0
2017-11-24 07:07:00	SPY	ETF	260.31	260.31	260.31	260.31	3800.0
2017-11-24 07:08:00	SPY	ETF	260.31	260.31	260.31	260.31	1738.0
2017-11-24 07:10:00	SPY	ETF	260.3	260.32	260.3	260.31	7100.0
2017-11-24 07:11:00	SPY	ETF	260.31	260.34	260.31	260.34	8038.0
2017-11-24 07:12:00	SPY	ETF	260.34	260.34	260.33	260.34	2169.0
2017-11-24 07:13:00	SPY	ETF	260.34	260.36	260.34	260.35	5538.0
2017-11-24 07:14:00	SPY	ETF	260.35	260.36	260.35	260.36	2769.0
2017-11-24 07:16:00	SPY	ETF	260.33	260.34	260.33	260.34	3388.0
2017-11-24 07:17:00	SPY	ETF	260.33	260.33	260.33	260.33	2338.0
2017-11-24 07:18:00	SPY	ETF	260.34	260.36	260.34	260.36	3727.0

> showing 50 of 73,028 rows — these rows as CSV

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