PREVIEW / etf_1min / 2017-10-24

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-10-24.parquet
  size:    2.7 MB
  rows:    138,758

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-10-24 04:04:00	SPY	ETF	256.25	256.25	256.25	256.25	300.0
2017-10-24 04:22:00	SPY	ETF	256.24	256.24	256.19	256.19	1300.0
2017-10-24 04:33:00	SPY	ETF	256.22	256.26	256.22	256.26	300.0
2017-10-24 04:35:00	SPY	ETF	256.21	256.21	256.21	256.21	489.0
2017-10-24 04:39:00	SPY	ETF	256.16	256.16	256.15	256.15	2000.0
2017-10-24 04:40:00	SPY	ETF	256.1	256.1	256.1	256.1	100.0
2017-10-24 04:41:00	SPY	ETF	256.14	256.14	256.14	256.14	500.0
2017-10-24 04:42:00	SPY	ETF	256.14	256.16	256.14	256.16	1200.0
2017-10-24 04:47:00	SPY	ETF	256.21	256.21	256.21	256.21	500.0
2017-10-24 04:54:00	SPY	ETF	256.21	256.21	256.21	256.21	300.0
2017-10-24 05:00:00	SPY	ETF	256.29	256.29	256.29	256.29	1000.0
2017-10-24 05:03:00	SPY	ETF	256.25	256.25	256.25	256.25	100.0
2017-10-24 05:06:00	SPY	ETF	256.26	256.26	256.26	256.26	1000.0
2017-10-24 05:07:00	SPY	ETF	256.29	256.29	256.29	256.29	3000.0
2017-10-24 05:08:00	SPY	ETF	256.34	256.34	256.34	256.34	403.0
2017-10-24 05:14:00	SPY	ETF	256.35	256.35	256.35	256.35	1001.0
2017-10-24 05:19:00	SPY	ETF	256.35	256.35	256.35	256.35	500.0
2017-10-24 05:20:00	SPY	ETF	256.35	256.35	256.35	256.35	100.0
2017-10-24 05:23:00	SPY	ETF	256.36	256.36	256.36	256.36	300.0
2017-10-24 05:24:00	SPY	ETF	256.32	256.34	256.32	256.34	300.0
2017-10-24 05:29:00	SPY	ETF	256.36	256.36	256.36	256.36	102.0
2017-10-24 05:30:00	SPY	ETF	256.34	256.34	256.34	256.34	304.0
2017-10-24 05:35:00	SPY	ETF	256.36	256.36	256.35	256.36	1204.0
2017-10-24 05:36:00	SPY	ETF	256.37	256.39	256.37	256.39	401.0
2017-10-24 05:38:00	SPY	ETF	256.35	256.35	256.34	256.34	2601.0
2017-10-24 05:43:00	SPY	ETF	256.34	256.34	256.34	256.34	500.0
2017-10-24 05:44:00	SPY	ETF	256.34	256.34	256.34	256.34	500.0
2017-10-24 05:45:00	SPY	ETF	256.35	256.39	256.35	256.39	301.0
2017-10-24 05:56:00	SPY	ETF	256.38	256.38	256.38	256.38	100.0
2017-10-24 05:57:00	SPY	ETF	256.41	256.41	256.41	256.41	401.0
2017-10-24 06:02:00	SPY	ETF	256.39	256.39	256.39	256.39	800.0
2017-10-24 06:06:00	SPY	ETF	256.41	256.42	256.41	256.42	7000.0
2017-10-24 06:07:00	SPY	ETF	256.43	256.44	256.43	256.44	6002.0
2017-10-24 06:12:00	SPY	ETF	256.43	256.43	256.43	256.43	1100.0
2017-10-24 06:18:00	SPY	ETF	256.39	256.39	256.39	256.39	502.0
2017-10-24 06:27:00	SPY	ETF	256.44	256.44	256.44	256.44	1202.0
2017-10-24 06:28:00	SPY	ETF	256.44	256.44	256.44	256.44	203.0
2017-10-24 06:31:00	SPY	ETF	256.46	256.46	256.46	256.46	200.0
2017-10-24 06:32:00	SPY	ETF	256.46	256.47	256.46	256.47	900.0
2017-10-24 06:33:00	SPY	ETF	256.47	256.47	256.47	256.47	340.0
2017-10-24 06:35:00	SPY	ETF	256.46	256.5	256.46	256.5	327.0
2017-10-24 06:38:00	SPY	ETF	256.54	256.54	256.53	256.53	1977.0
2017-10-24 06:41:00	SPY	ETF	256.51	256.51	256.5	256.5	801.0
2017-10-24 06:50:00	SPY	ETF	256.45	256.45	256.45	256.45	102.0
2017-10-24 06:51:00	SPY	ETF	256.44	256.44	256.41	256.42	802.0
2017-10-24 06:55:00	SPY	ETF	256.42	256.42	256.42	256.42	1000.0
2017-10-24 06:56:00	SPY	ETF	256.42	256.42	256.42	256.42	100.0
2017-10-24 06:57:00	SPY	ETF	256.42	256.42	256.42	256.42	800.0
2017-10-24 07:00:00	SPY	ETF	256.44	256.44	256.41	256.41	4205.0
2017-10-24 07:01:00	SPY	ETF	256.43	256.43	256.43	256.43	400.0

> showing 50 of 138,758 rows — these rows as CSV

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