PREVIEW / etf_1min / 2018-08-07

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-08-07.parquet
  size:    2.8 MB
  rows:    147,537

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
2018-08-07 04:00:00	SPY	ETF	285.2	285.3	285.17	285.3	6692.0
2018-08-07 04:01:00	SPY	ETF	285.32	285.32	285.3	285.3	1302.0
2018-08-07 04:02:00	SPY	ETF	285.3	285.3	285.3	285.3	2648.0
2018-08-07 04:03:00	SPY	ETF	285.26	285.26	285.26	285.26	1100.0
2018-08-07 04:04:00	SPY	ETF	285.26	285.26	285.26	285.26	200.0
2018-08-07 04:05:00	SPY	ETF	285.26	285.29	285.26	285.29	1702.0
2018-08-07 04:06:00	SPY	ETF	285.3	285.31	285.3	285.31	520.0
2018-08-07 04:07:00	SPY	ETF	285.27	285.27	285.27	285.27	120.0
2018-08-07 04:09:00	SPY	ETF	285.25	285.25	285.25	285.25	1000.0
2018-08-07 04:12:00	SPY	ETF	285.32	285.32	285.31	285.31	2182.0
2018-08-07 04:13:00	SPY	ETF	285.32	285.34	285.32	285.34	700.0
2018-08-07 04:18:00	SPY	ETF	285.33	285.33	285.33	285.33	200.0
2018-08-07 04:19:00	SPY	ETF	285.35	285.35	285.35	285.35	200.0
2018-08-07 04:22:00	SPY	ETF	285.33	285.33	285.33	285.33	300.0
2018-08-07 04:28:00	SPY	ETF	285.35	285.35	285.35	285.35	100.0
2018-08-07 04:29:00	SPY	ETF	285.38	285.38	285.38	285.38	1000.0
2018-08-07 04:30:00	SPY	ETF	285.4	285.4	285.39	285.39	2600.0
2018-08-07 04:33:00	SPY	ETF	285.38	285.38	285.38	285.38	400.0
2018-08-07 04:45:00	SPY	ETF	285.43	285.43	285.43	285.43	200.0
2018-08-07 04:47:00	SPY	ETF	285.45	285.45	285.45	285.45	1100.0
2018-08-07 04:50:00	SPY	ETF	285.46	285.46	285.46	285.46	102.0
2018-08-07 04:52:00	SPY	ETF	285.48	285.48	285.48	285.48	2800.0
2018-08-07 04:53:00	SPY	ETF	285.5	285.5	285.48	285.48	3100.0
2018-08-07 04:54:00	SPY	ETF	285.48	285.48	285.48	285.48	350.0
2018-08-07 04:56:00	SPY	ETF	285.41	285.41	285.41	285.41	1032.0
2018-08-07 04:58:00	SPY	ETF	285.38	285.38	285.38	285.38	300.0
2018-08-07 04:59:00	SPY	ETF	285.4	285.4	285.38	285.38	3000.0
2018-08-07 05:00:00	SPY	ETF	285.38	285.38	285.38	285.38	4400.0
2018-08-07 05:01:00	SPY	ETF	285.35	285.36	285.35	285.36	4400.0
2018-08-07 05:02:00	SPY	ETF	285.36	285.36	285.36	285.36	598.0
2018-08-07 05:05:00	SPY	ETF	285.36	285.36	285.36	285.36	3002.0
2018-08-07 05:08:00	SPY	ETF	285.45	285.45	285.45	285.45	100.0
2018-08-07 05:16:00	SPY	ETF	285.43	285.43	285.43	285.43	100.0
2018-08-07 05:18:00	SPY	ETF	285.4	285.4	285.4	285.4	300.0
2018-08-07 05:26:00	SPY	ETF	285.34	285.34	285.34	285.34	500.0
2018-08-07 05:28:00	SPY	ETF	285.32	285.32	285.32	285.32	300.0
2018-08-07 05:34:00	SPY	ETF	285.36	285.36	285.36	285.36	500.0
2018-08-07 05:36:00	SPY	ETF	285.32	285.32	285.32	285.32	2702.0
2018-08-07 05:47:00	SPY	ETF	285.25	285.25	285.25	285.25	300.0
2018-08-07 05:48:00	SPY	ETF	285.28	285.28	285.28	285.28	300.0
2018-08-07 05:49:00	SPY	ETF	285.28	285.28	285.25	285.25	4000.0
2018-08-07 05:51:00	SPY	ETF	285.28	285.28	285.28	285.28	400.0
2018-08-07 05:52:00	SPY	ETF	285.28	285.28	285.28	285.28	800.0
2018-08-07 06:02:00	SPY	ETF	285.28	285.28	285.28	285.28	300.0
2018-08-07 06:04:00	SPY	ETF	285.34	285.34	285.33	285.33	2800.0
2018-08-07 06:05:00	SPY	ETF	285.33	285.34	285.33	285.34	600.0
2018-08-07 06:12:00	SPY	ETF	285.28	285.28	285.28	285.28	250.0
2018-08-07 06:16:00	SPY	ETF	285.26	285.26	285.2	285.2	634.0
2018-08-07 06:18:00	SPY	ETF	285.2	285.2	285.2	285.2	700.0
2018-08-07 06:19:00	SPY	ETF	285.2	285.2	285.2	285.2	2000.0

> showing 50 of 147,537 rows — these rows as CSV

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