PREVIEW / etf_1min / 2018-08-15

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-08-15.parquet
  size:    3.3 MB
  rows:    168,711

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-15 04:00:00	SPY	ETF	283.7	283.7	283.6	283.6	1549.0
2018-08-15 04:05:00	SPY	ETF	283.56	283.56	283.56	283.56	2200.0
2018-08-15 04:06:00	SPY	ETF	283.56	283.56	283.56	283.56	157.0
2018-08-15 04:07:00	SPY	ETF	283.5	283.5	283.5	283.5	1797.0
2018-08-15 04:08:00	SPY	ETF	283.53	283.53	283.53	283.53	200.0
2018-08-15 04:13:00	SPY	ETF	283.55	283.55	283.55	283.55	300.0
2018-08-15 04:14:00	SPY	ETF	283.62	283.62	283.59	283.59	300.0
2018-08-15 04:17:00	SPY	ETF	283.58	283.58	283.58	283.58	100.0
2018-08-15 04:22:00	SPY	ETF	283.63	283.63	283.63	283.63	300.0
2018-08-15 04:26:00	SPY	ETF	283.71	283.71	283.71	283.71	100.0
2018-08-15 04:31:00	SPY	ETF	283.66	283.66	283.66	283.66	120.0
2018-08-15 04:32:00	SPY	ETF	283.63	283.63	283.63	283.63	100.0
2018-08-15 04:33:00	SPY	ETF	283.68	283.68	283.68	283.68	700.0
2018-08-15 04:37:00	SPY	ETF	283.67	283.67	283.67	283.67	100.0
2018-08-15 04:39:00	SPY	ETF	283.62	283.62	283.62	283.62	100.0
2018-08-15 04:40:00	SPY	ETF	283.62	283.62	283.58	283.58	500.0
2018-08-15 04:43:00	SPY	ETF	283.58	283.58	283.58	283.58	300.0
2018-08-15 04:46:00	SPY	ETF	283.58	283.58	283.58	283.58	100.0
2018-08-15 04:55:00	SPY	ETF	283.58	283.58	283.58	283.58	200.0
2018-08-15 04:56:00	SPY	ETF	283.56	283.56	283.56	283.56	300.0
2018-08-15 04:58:00	SPY	ETF	283.55	283.55	283.55	283.55	100.0
2018-08-15 05:02:00	SPY	ETF	283.58	283.58	283.58	283.58	300.0
2018-08-15 05:03:00	SPY	ETF	283.59	283.59	283.59	283.59	300.0
2018-08-15 05:05:00	SPY	ETF	283.59	283.59	283.59	283.59	200.0
2018-08-15 05:08:00	SPY	ETF	283.54	283.54	283.53	283.53	1100.0
2018-08-15 05:09:00	SPY	ETF	283.59	283.59	283.59	283.59	400.0
2018-08-15 05:11:00	SPY	ETF	283.57	283.57	283.57	283.57	500.0
2018-08-15 05:14:00	SPY	ETF	283.5	283.5	283.49	283.49	703.0
2018-08-15 05:17:00	SPY	ETF	283.48	283.48	283.46	283.46	1200.0
2018-08-15 05:21:00	SPY	ETF	283.46	283.46	283.46	283.46	100.0
2018-08-15 05:23:00	SPY	ETF	283.45	283.45	283.44	283.44	2500.0
2018-08-15 05:31:00	SPY	ETF	283.41	283.41	283.41	283.41	300.0
2018-08-15 05:35:00	SPY	ETF	283.4	283.4	283.36	283.36	400.0
2018-08-15 05:41:00	SPY	ETF	283.39	283.39	283.39	283.39	100.0
2018-08-15 05:46:00	SPY	ETF	283.33	283.33	283.33	283.33	170.0
2018-08-15 05:47:00	SPY	ETF	283.29	283.29	283.29	283.29	300.0
2018-08-15 05:48:00	SPY	ETF	283.34	283.34	283.34	283.34	100.0
2018-08-15 05:51:00	SPY	ETF	283.29	283.29	283.29	283.29	500.0
2018-08-15 05:55:00	SPY	ETF	283.27	283.27	283.27	283.27	125.0
2018-08-15 05:56:00	SPY	ETF	283.27	283.27	283.27	283.27	1000.0
2018-08-15 05:57:00	SPY	ETF	283.27	283.27	283.27	283.27	575.0
2018-08-15 05:58:00	SPY	ETF	283.23	283.23	283.2	283.2	1282.0
2018-08-15 05:59:00	SPY	ETF	283.22	283.22	283.22	283.22	400.0
2018-08-15 06:04:00	SPY	ETF	283.2	283.2	283.2	283.2	100.0
2018-08-15 06:05:00	SPY	ETF	283.17	283.17	283.17	283.17	188.0
2018-08-15 06:07:00	SPY	ETF	283.14	283.15	283.11	283.11	3200.0
2018-08-15 06:09:00	SPY	ETF	283.16	283.16	283.16	283.16	200.0
2018-08-15 06:10:00	SPY	ETF	283.22	283.22	283.22	283.22	800.0
2018-08-15 06:13:00	SPY	ETF	283.24	283.26	283.24	283.26	720.0
2018-08-15 06:14:00	SPY	ETF	283.29	283.29	283.29	283.29	300.0

> showing 50 of 168,711 rows — these rows as CSV

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