PREVIEW / etf_1min / 2018-04-26

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-04-26.parquet
  size:    2.8 MB
  rows:    144,433

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-04-26 04:00:00	SPY	ETF	263.94	263.94	263.93	263.93	557.0
2018-04-26 04:01:00	SPY	ETF	263.94	263.95	263.94	263.95	800.0
2018-04-26 04:02:00	SPY	ETF	263.96	264.02	263.96	264.02	3720.0
2018-04-26 04:03:00	SPY	ETF	264.07	264.08	264.0	264.05	1265.0
2018-04-26 04:04:00	SPY	ETF	264.08	264.08	264.05	264.05	701.0
2018-04-26 04:07:00	SPY	ETF	264.13	264.13	264.09	264.12	600.0
2018-04-26 04:08:00	SPY	ETF	264.11	264.11	264.11	264.11	500.0
2018-04-26 04:09:00	SPY	ETF	264.12	264.12	264.12	264.12	400.0
2018-04-26 04:10:00	SPY	ETF	264.16	264.16	264.16	264.16	410.0
2018-04-26 04:11:00	SPY	ETF	264.15	264.15	264.15	264.15	300.0
2018-04-26 04:12:00	SPY	ETF	264.15	264.15	264.09	264.09	1105.0
2018-04-26 04:14:00	SPY	ETF	264.22	264.22	264.22	264.22	400.0
2018-04-26 04:21:00	SPY	ETF	264.18	264.18	264.09	264.09	400.0
2018-04-26 04:22:00	SPY	ETF	264.09	264.13	264.09	264.13	400.0
2018-04-26 04:23:00	SPY	ETF	264.08	264.08	264.05	264.05	720.0
2018-04-26 04:24:00	SPY	ETF	264.05	264.08	264.05	264.08	800.0
2018-04-26 04:26:00	SPY	ETF	264.1	264.1	264.1	264.1	400.0
2018-04-26 04:29:00	SPY	ETF	264.11	264.11	264.11	264.11	329.0
2018-04-26 04:32:00	SPY	ETF	264.0	264.0	264.0	264.0	1000.0
2018-04-26 04:33:00	SPY	ETF	263.99	263.99	263.99	263.99	200.0
2018-04-26 04:34:00	SPY	ETF	264.01	264.01	264.01	264.01	200.0
2018-04-26 04:35:00	SPY	ETF	264.0	264.0	264.0	264.0	414.0
2018-04-26 04:36:00	SPY	ETF	264.02	264.02	264.02	264.02	100.0
2018-04-26 04:40:00	SPY	ETF	264.04	264.04	264.04	264.04	150.0
2018-04-26 04:42:00	SPY	ETF	264.12	264.12	264.12	264.12	500.0
2018-04-26 04:43:00	SPY	ETF	264.14	264.14	264.14	264.14	500.0
2018-04-26 04:48:00	SPY	ETF	264.13	264.13	264.13	264.13	100.0
2018-04-26 04:55:00	SPY	ETF	264.11	264.11	264.1	264.1	1100.0
2018-04-26 04:58:00	SPY	ETF	264.12	264.12	264.12	264.12	300.0
2018-04-26 04:59:00	SPY	ETF	264.12	264.12	264.12	264.12	200.0
2018-04-26 05:02:00	SPY	ETF	264.1	264.1	264.1	264.1	300.0
2018-04-26 05:05:00	SPY	ETF	264.07	264.07	264.05	264.05	308.0
2018-04-26 05:06:00	SPY	ETF	264.06	264.06	264.02	264.02	2300.0
2018-04-26 05:11:00	SPY	ETF	264.04	264.04	264.04	264.04	200.0
2018-04-26 05:20:00	SPY	ETF	264.05	264.05	264.05	264.05	400.0
2018-04-26 05:24:00	SPY	ETF	264.25	264.25	264.25	264.25	200.0
2018-04-26 05:26:00	SPY	ETF	264.32	264.35	264.32	264.35	1200.0
2018-04-26 05:28:00	SPY	ETF	264.37	264.37	264.37	264.37	450.0
2018-04-26 05:29:00	SPY	ETF	264.36	264.36	264.36	264.36	100.0
2018-04-26 05:30:00	SPY	ETF	264.35	264.35	264.35	264.35	300.0
2018-04-26 05:31:00	SPY	ETF	264.34	264.34	264.34	264.34	200.0
2018-04-26 05:33:00	SPY	ETF	264.41	264.41	264.41	264.41	1500.0
2018-04-26 05:40:00	SPY	ETF	264.45	264.45	264.45	264.45	110.0
2018-04-26 05:41:00	SPY	ETF	264.47	264.47	264.47	264.47	100.0
2018-04-26 05:42:00	SPY	ETF	264.57	264.57	264.57	264.57	1050.0
2018-04-26 05:46:00	SPY	ETF	264.6	264.6	264.6	264.6	300.0
2018-04-26 05:51:00	SPY	ETF	264.59	264.59	264.59	264.59	800.0
2018-04-26 05:56:00	SPY	ETF	264.61	264.61	264.58	264.58	600.0
2018-04-26 05:57:00	SPY	ETF	264.61	264.61	264.6	264.6	400.0
2018-04-26 05:59:00	SPY	ETF	264.57	264.57	264.57	264.57	900.0

> showing 50 of 144,433 rows — these rows as CSV

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