PREVIEW / etf_1min / 2017-10-25

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-10-25.parquet
  size:    3.0 MB
  rows:    149,354

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-25 04:05:00	SPY	ETF	256.25	256.25	256.25	256.25	200.0
2017-10-25 04:13:00	SPY	ETF	256.18	256.18	256.18	256.18	200.0
2017-10-25 04:14:00	SPY	ETF	256.17	256.17	256.17	256.17	300.0
2017-10-25 04:16:00	SPY	ETF	256.15	256.15	256.15	256.15	100.0
2017-10-25 04:30:00	SPY	ETF	256.17	256.17	256.17	256.17	100.0
2017-10-25 04:35:00	SPY	ETF	256.15	256.15	256.13	256.13	200.0
2017-10-25 04:40:00	SPY	ETF	256.17	256.17	256.17	256.17	100.0
2017-10-25 05:06:00	SPY	ETF	256.2	256.2	256.2	256.2	120.0
2017-10-25 05:13:00	SPY	ETF	256.07	256.07	256.07	256.07	100.0
2017-10-25 05:14:00	SPY	ETF	256.05	256.05	256.05	256.05	100.0
2017-10-25 05:37:00	SPY	ETF	256.18	256.18	256.18	256.18	306.0
2017-10-25 06:04:00	SPY	ETF	256.19	256.19	256.19	256.19	2503.0
2017-10-25 06:25:00	SPY	ETF	256.35	256.35	256.35	256.35	503.0
2017-10-25 06:30:00	SPY	ETF	256.3	256.3	256.3	256.3	103.0
2017-10-25 06:36:00	SPY	ETF	256.25	256.25	256.25	256.25	102.0
2017-10-25 06:39:00	SPY	ETF	256.3	256.3	256.3	256.3	500.0
2017-10-25 06:52:00	SPY	ETF	256.29	256.3	256.29	256.29	1300.0
2017-10-25 07:00:00	SPY	ETF	256.34	256.37	256.34	256.35	2002.0
2017-10-25 07:04:00	SPY	ETF	256.38	256.38	256.38	256.38	500.0
2017-10-25 07:08:00	SPY	ETF	256.42	256.42	256.42	256.42	210.0
2017-10-25 07:09:00	SPY	ETF	256.43	256.43	256.43	256.43	180.0
2017-10-25 07:10:00	SPY	ETF	256.44	256.44	256.43	256.43	624.0
2017-10-25 07:12:00	SPY	ETF	256.36	256.38	256.36	256.38	600.0
2017-10-25 07:13:00	SPY	ETF	256.36	256.36	256.35	256.35	203.0
2017-10-25 07:15:00	SPY	ETF	256.34	256.34	256.34	256.34	1019.0
2017-10-25 07:16:00	SPY	ETF	256.34	256.34	256.34	256.34	300.0
2017-10-25 07:17:00	SPY	ETF	256.34	256.34	256.3	256.3	6200.0
2017-10-25 07:18:00	SPY	ETF	256.34	256.34	256.34	256.34	200.0
2017-10-25 07:19:00	SPY	ETF	256.3	256.3	256.3	256.3	312.0
2017-10-25 07:23:00	SPY	ETF	256.23	256.23	256.23	256.23	532.0
2017-10-25 07:25:00	SPY	ETF	256.18	256.18	256.16	256.16	839.0
2017-10-25 07:26:00	SPY	ETF	256.15	256.18	256.15	256.18	221.0
2017-10-25 07:27:00	SPY	ETF	256.21	256.21	256.21	256.21	1700.0
2017-10-25 07:28:00	SPY	ETF	256.18	256.18	256.18	256.18	2500.0
2017-10-25 07:35:00	SPY	ETF	256.2	256.2	256.14	256.14	3100.0
2017-10-25 07:36:00	SPY	ETF	256.15	256.15	256.14	256.14	4487.0
2017-10-25 07:37:00	SPY	ETF	256.13	256.13	256.13	256.13	500.0
2017-10-25 07:38:00	SPY	ETF	256.14	256.14	256.11	256.11	7204.0
2017-10-25 07:39:00	SPY	ETF	256.12	256.12	256.12	256.12	10000.0
2017-10-25 07:40:00	SPY	ETF	256.12	256.12	256.12	256.12	105.0
2017-10-25 07:41:00	SPY	ETF	256.09	256.09	256.08	256.08	1111.0
2017-10-25 07:43:00	SPY	ETF	256.13	256.15	256.13	256.15	603.0
2017-10-25 07:44:00	SPY	ETF	256.16	256.22	256.16	256.21	2704.0
2017-10-25 07:45:00	SPY	ETF	256.21	256.21	256.21	256.21	100.0
2017-10-25 07:48:00	SPY	ETF	256.21	256.21	256.2	256.2	1785.0
2017-10-25 07:50:00	SPY	ETF	256.19	256.19	256.19	256.19	400.0
2017-10-25 07:52:00	SPY	ETF	256.18	256.18	256.16	256.16	487.0
2017-10-25 07:53:00	SPY	ETF	256.16	256.16	256.16	256.16	100.0
2017-10-25 07:55:00	SPY	ETF	256.18	256.18	256.18	256.18	500.0
2017-10-25 07:56:00	SPY	ETF	256.17	256.17	256.17	256.17	2500.0

> showing 50 of 149,354 rows — these rows as CSV

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