PREVIEW / etf_1min / 2018-07-09

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-07-09.parquet
  size:    2.9 MB
  rows:    156,104

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-07-09 04:00:00	SPY	ETF	276.52	276.52	276.52	276.52	650.0
2018-07-09 04:03:00	SPY	ETF	276.42	276.42	276.42	276.42	500.0
2018-07-09 04:04:00	SPY	ETF	276.62	276.62	276.62	276.62	122.0
2018-07-09 04:14:00	SPY	ETF	276.49	276.49	276.49	276.49	302.0
2018-07-09 04:15:00	SPY	ETF	276.48	276.48	276.48	276.48	102.0
2018-07-09 04:23:00	SPY	ETF	276.5	276.5	276.5	276.5	397.0
2018-07-09 04:29:00	SPY	ETF	276.46	276.46	276.46	276.46	233.0
2018-07-09 04:34:00	SPY	ETF	276.49	276.49	276.49	276.49	150.0
2018-07-09 04:40:00	SPY	ETF	276.36	276.36	276.36	276.36	100.0
2018-07-09 04:47:00	SPY	ETF	276.36	276.36	276.36	276.36	313.0
2018-07-09 04:50:00	SPY	ETF	276.28	276.28	276.28	276.28	100.0
2018-07-09 05:03:00	SPY	ETF	276.35	276.35	276.35	276.35	112.0
2018-07-09 05:09:00	SPY	ETF	276.4	276.4	276.4	276.4	200.0
2018-07-09 05:10:00	SPY	ETF	276.4	276.4	276.4	276.4	100.0
2018-07-09 05:14:00	SPY	ETF	276.4	276.4	276.4	276.4	150.0
2018-07-09 05:19:00	SPY	ETF	276.46	276.46	276.46	276.46	180.0
2018-07-09 05:30:00	SPY	ETF	276.5	276.55	276.5	276.55	715.0
2018-07-09 05:34:00	SPY	ETF	276.54	276.54	276.54	276.54	350.0
2018-07-09 05:36:00	SPY	ETF	276.54	276.54	276.54	276.54	500.0
2018-07-09 05:38:00	SPY	ETF	276.54	276.54	276.5	276.5	2500.0
2018-07-09 05:39:00	SPY	ETF	276.5	276.5	276.5	276.5	1500.0
2018-07-09 05:41:00	SPY	ETF	276.5	276.5	276.5	276.5	100.0
2018-07-09 05:55:00	SPY	ETF	276.59	276.59	276.59	276.59	100.0
2018-07-09 05:59:00	SPY	ETF	276.62	276.62	276.62	276.62	425.0
2018-07-09 06:24:00	SPY	ETF	276.6	276.6	276.6	276.6	150.0
2018-07-09 06:33:00	SPY	ETF	276.57	276.57	276.57	276.57	400.0
2018-07-09 06:34:00	SPY	ETF	276.57	276.57	276.54	276.54	200.0
2018-07-09 06:39:00	SPY	ETF	276.54	276.54	276.52	276.52	300.0
2018-07-09 06:40:00	SPY	ETF	276.51	276.51	276.5	276.5	400.0
2018-07-09 06:43:00	SPY	ETF	276.54	276.6	276.54	276.6	500.0
2018-07-09 06:52:00	SPY	ETF	276.6	276.6	276.6	276.6	2500.0
2018-07-09 06:57:00	SPY	ETF	276.55	276.58	276.55	276.58	1800.0
2018-07-09 06:58:00	SPY	ETF	276.6	276.6	276.6	276.6	400.0
2018-07-09 07:00:00	SPY	ETF	276.6	276.6	276.56	276.56	1845.0
2018-07-09 07:01:00	SPY	ETF	276.55	276.55	276.5	276.5	350.0
2018-07-09 07:02:00	SPY	ETF	276.55	276.55	276.55	276.55	317.0
2018-07-09 07:03:00	SPY	ETF	276.55	276.56	276.55	276.56	600.0
2018-07-09 07:04:00	SPY	ETF	276.59	276.6	276.59	276.6	800.0
2018-07-09 07:05:00	SPY	ETF	276.6	276.6	276.6	276.6	500.0
2018-07-09 07:06:00	SPY	ETF	276.6	276.65	276.6	276.65	990.0
2018-07-09 07:07:00	SPY	ETF	276.66	276.67	276.66	276.67	13629.0
2018-07-09 07:09:00	SPY	ETF	276.67	276.72	276.67	276.72	1745.0
2018-07-09 07:10:00	SPY	ETF	276.74	276.74	276.66	276.66	25200.0
2018-07-09 07:11:00	SPY	ETF	276.69	276.69	276.69	276.69	600.0
2018-07-09 07:12:00	SPY	ETF	276.67	276.67	276.65	276.65	23100.0
2018-07-09 07:13:00	SPY	ETF	276.64	276.65	276.6	276.64	2756.0
2018-07-09 07:14:00	SPY	ETF	276.61	276.61	276.61	276.61	100.0
2018-07-09 07:15:00	SPY	ETF	276.65	276.65	276.64	276.64	640.0
2018-07-09 07:16:00	SPY	ETF	276.64	276.64	276.61	276.61	400.0
2018-07-09 07:18:00	SPY	ETF	276.62	276.62	276.61	276.61	3400.0

> showing 50 of 156,104 rows — these rows as CSV

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