PREVIEW / etf_5min / 2017-12-04

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-12-04.parquet
  size:    1.4 MB
  rows:    60,102

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-12-04 04:00:00	SPY	ETF	265.9	266.15	265.9	266.01	7137.0
2017-12-04 04:05:00	SPY	ETF	265.96	266.11	265.96	266.03	5130.0
2017-12-04 04:10:00	SPY	ETF	266.02	266.08	266.02	266.07	400.0
2017-12-04 04:15:00	SPY	ETF	266.04	266.04	266.04	266.04	125.0
2017-12-04 04:20:00	SPY	ETF	266.05	266.05	266.05	266.05	100.0
2017-12-04 04:30:00	SPY	ETF	266.06	266.06	266.06	266.06	300.0
2017-12-04 04:55:00	SPY	ETF	265.94	265.94	265.87	265.87	400.0
2017-12-04 05:00:00	SPY	ETF	265.87	265.97	265.87	265.97	919.0
2017-12-04 05:05:00	SPY	ETF	265.98	265.99	265.96	265.99	1650.0
2017-12-04 05:10:00	SPY	ETF	265.99	266.02	265.97	265.97	5600.0
2017-12-04 05:15:00	SPY	ETF	265.98	265.98	265.98	265.98	4100.0
2017-12-04 05:20:00	SPY	ETF	266.01	266.03	266.0	266.03	1195.0
2017-12-04 05:25:00	SPY	ETF	266.06	266.1	266.06	266.07	10325.0
2017-12-04 05:30:00	SPY	ETF	266.12	266.12	266.06	266.06	3300.0
2017-12-04 05:35:00	SPY	ETF	266.1	266.13	266.08	266.13	1100.0
2017-12-04 05:40:00	SPY	ETF	266.15	266.22	266.15	266.18	6605.0
2017-12-04 05:45:00	SPY	ETF	266.22	266.22	266.18	266.18	700.0
2017-12-04 05:50:00	SPY	ETF	266.2	266.2	266.18	266.18	800.0
2017-12-04 05:55:00	SPY	ETF	266.25	266.27	266.23	266.23	700.0
2017-12-04 06:00:00	SPY	ETF	266.23	266.23	266.22	266.22	3900.0
2017-12-04 06:05:00	SPY	ETF	266.2	266.22	266.18	266.22	2905.0
2017-12-04 06:10:00	SPY	ETF	266.23	266.27	266.23	266.27	1130.0
2017-12-04 06:15:00	SPY	ETF	266.27	266.3	266.24	266.25	6975.0
2017-12-04 06:20:00	SPY	ETF	266.27	266.27	266.25	266.25	3191.0
2017-12-04 06:25:00	SPY	ETF	266.27	266.32	266.27	266.32	300.0
2017-12-04 06:30:00	SPY	ETF	266.3	266.37	266.3	266.37	5172.0
2017-12-04 06:35:00	SPY	ETF	266.32	266.36	266.3	266.33	31600.0
2017-12-04 06:40:00	SPY	ETF	266.31	266.32	266.31	266.32	1000.0
2017-12-04 06:45:00	SPY	ETF	266.31	266.36	266.31	266.36	4600.0
2017-12-04 06:50:00	SPY	ETF	266.33	266.33	266.3	266.3	400.0
2017-12-04 06:55:00	SPY	ETF	266.33	266.35	266.3	266.34	26600.0
2017-12-04 07:00:00	SPY	ETF	266.31	266.32	266.23	266.28	23076.0
2017-12-04 07:05:00	SPY	ETF	266.28	266.29	266.25	266.26	12771.0
2017-12-04 07:10:00	SPY	ETF	266.28	266.28	266.25	266.25	5456.0
2017-12-04 07:15:00	SPY	ETF	266.28	266.29	266.27	266.27	3300.0
2017-12-04 07:20:00	SPY	ETF	266.27	266.3	266.27	266.3	18360.0
2017-12-04 07:25:00	SPY	ETF	266.3	266.35	266.3	266.35	131063.0
2017-12-04 07:30:00	SPY	ETF	266.35	266.38	266.35	266.36	60107.0
2017-12-04 07:35:00	SPY	ETF	266.36	266.38	266.35	266.35	37199.0
2017-12-04 07:40:00	SPY	ETF	266.34	266.37	266.33	266.33	30572.0
2017-12-04 07:45:00	SPY	ETF	266.33	266.36	266.29	266.29	10440.0
2017-12-04 07:50:00	SPY	ETF	266.32	266.32	266.26	266.29	48851.0
2017-12-04 07:55:00	SPY	ETF	266.23	266.26	266.18	266.18	125940.0
2017-12-04 08:00:00	SPY	ETF	264.46	266.36	264.46	266.17	48040.0
2017-12-04 08:05:00	SPY	ETF	265.99	266.2	265.99	266.2	87763.0
2017-12-04 08:10:00	SPY	ETF	266.2	266.24	266.18	266.23	94825.0
2017-12-04 08:15:00	SPY	ETF	266.21	266.21	266.11	266.13	22355.0
2017-12-04 08:20:00	SPY	ETF	266.11	266.11	265.99	265.99	61946.0
2017-12-04 08:25:00	SPY	ETF	265.98	266.04	265.93	266.04	85152.0
2017-12-04 08:30:00	SPY	ETF	266.04	266.09	266.0	266.05	28625.0

> showing 50 of 60,102 rows — these rows as CSV

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