PREVIEW / etf_1min / 2018-06-25

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-06-25.parquet
  size:    3.2 MB
  rows:    166,857

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-06-25 04:00:00	SPY	ETF	273.5	273.79	273.5	273.6	2923.0
2018-06-25 04:01:00	SPY	ETF	273.6	273.6	273.55	273.57	11460.0
2018-06-25 04:02:00	SPY	ETF	273.66	273.66	273.66	273.66	1251.0
2018-06-25 04:03:00	SPY	ETF	273.69	273.69	273.69	273.69	210.0
2018-06-25 04:06:00	SPY	ETF	273.62	273.66	273.62	273.66	1600.0
2018-06-25 04:08:00	SPY	ETF	273.66	273.66	273.66	273.66	1500.0
2018-06-25 04:10:00	SPY	ETF	273.52	273.52	273.52	273.52	300.0
2018-06-25 04:11:00	SPY	ETF	273.59	273.59	273.59	273.59	100.0
2018-06-25 04:13:00	SPY	ETF	273.61	273.61	273.61	273.61	3000.0
2018-06-25 04:15:00	SPY	ETF	273.5	273.54	273.45	273.45	1715.0
2018-06-25 04:16:00	SPY	ETF	273.45	273.45	273.45	273.45	350.0
2018-06-25 04:17:00	SPY	ETF	273.45	273.45	273.45	273.45	700.0
2018-06-25 04:18:00	SPY	ETF	273.42	273.42	273.42	273.42	400.0
2018-06-25 04:20:00	SPY	ETF	273.49	273.49	273.49	273.49	100.0
2018-06-25 04:22:00	SPY	ETF	273.47	273.47	273.47	273.47	300.0
2018-06-25 04:24:00	SPY	ETF	273.42	273.47	273.42	273.47	2235.0
2018-06-25 04:26:00	SPY	ETF	273.5	273.5	273.47	273.47	2500.0
2018-06-25 04:27:00	SPY	ETF	273.42	273.42	273.42	273.42	800.0
2018-06-25 04:28:00	SPY	ETF	273.42	273.42	273.42	273.42	620.0
2018-06-25 04:29:00	SPY	ETF	273.4	273.4	273.39	273.39	680.0
2018-06-25 04:30:00	SPY	ETF	273.38	273.38	273.38	273.38	140.0
2018-06-25 04:35:00	SPY	ETF	273.37	273.37	273.37	273.37	120.0
2018-06-25 04:37:00	SPY	ETF	273.43	273.46	273.43	273.46	200.0
2018-06-25 04:38:00	SPY	ETF	273.42	273.56	273.42	273.56	2895.0
2018-06-25 04:43:00	SPY	ETF	273.42	273.42	273.42	273.42	400.0
2018-06-25 04:45:00	SPY	ETF	273.35	273.35	273.35	273.35	700.0
2018-06-25 04:47:00	SPY	ETF	273.31	273.31	273.31	273.31	510.0
2018-06-25 04:49:00	SPY	ETF	273.36	273.36	273.36	273.36	150.0
2018-06-25 04:52:00	SPY	ETF	273.3	273.3	273.25	273.25	1340.0
2018-06-25 04:53:00	SPY	ETF	273.27	273.27	273.27	273.27	452.0
2018-06-25 04:54:00	SPY	ETF	273.25	273.25	273.25	273.25	200.0
2018-06-25 04:55:00	SPY	ETF	273.24	273.24	273.24	273.24	220.0
2018-06-25 04:59:00	SPY	ETF	273.26	273.26	273.19	273.19	1530.0
2018-06-25 05:00:00	SPY	ETF	273.25	273.25	273.25	273.25	1300.0
2018-06-25 05:01:00	SPY	ETF	273.25	273.27	273.25	273.27	700.0
2018-06-25 05:02:00	SPY	ETF	273.26	273.26	273.26	273.26	200.0
2018-06-25 05:03:00	SPY	ETF	273.21	273.21	273.21	273.21	100.0
2018-06-25 05:05:00	SPY	ETF	273.23	273.23	273.23	273.23	1000.0
2018-06-25 05:06:00	SPY	ETF	273.25	273.26	273.25	273.26	1250.0
2018-06-25 05:07:00	SPY	ETF	273.28	273.28	273.28	273.28	1000.0
2018-06-25 05:09:00	SPY	ETF	273.21	273.21	273.2	273.2	500.0
2018-06-25 05:11:00	SPY	ETF	273.21	273.21	273.21	273.21	100.0
2018-06-25 05:12:00	SPY	ETF	273.24	273.24	273.24	273.24	150.0
2018-06-25 05:13:00	SPY	ETF	273.23	273.23	273.2	273.2	900.0
2018-06-25 05:14:00	SPY	ETF	273.28	273.28	273.28	273.28	1000.0
2018-06-25 05:16:00	SPY	ETF	273.22	273.22	273.22	273.22	1300.0
2018-06-25 05:18:00	SPY	ETF	273.2	273.2	273.2	273.2	3000.0
2018-06-25 05:19:00	SPY	ETF	273.17	273.17	273.17	273.17	300.0
2018-06-25 05:20:00	SPY	ETF	273.16	273.16	273.1	273.1	1460.0
2018-06-25 05:21:00	SPY	ETF	273.1	273.1	273.1	273.1	2100.0

> showing 50 of 166,857 rows — these rows as CSV

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