PREVIEW / etf_1min / 2018-03-21

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-03-21.parquet
  size:    2.9 MB
  rows:    149,936

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-03-21 04:00:00	SPY	ETF	271.35	271.35	271.33	271.33	785.0
2018-03-21 04:01:00	SPY	ETF	271.3	271.3	271.3	271.3	240.0
2018-03-21 04:02:00	SPY	ETF	271.31	271.31	271.31	271.31	300.0
2018-03-21 04:03:00	SPY	ETF	271.3	271.31	271.3	271.31	1300.0
2018-03-21 04:04:00	SPY	ETF	271.34	271.36	271.33	271.33	1100.0
2018-03-21 04:05:00	SPY	ETF	271.32	271.32	271.32	271.32	300.0
2018-03-21 04:07:00	SPY	ETF	271.27	271.27	271.27	271.27	300.0
2018-03-21 04:08:00	SPY	ETF	271.19	271.19	271.19	271.19	620.0
2018-03-21 04:09:00	SPY	ETF	271.18	271.18	271.18	271.18	300.0
2018-03-21 04:14:00	SPY	ETF	271.15	271.15	271.15	271.15	400.0
2018-03-21 04:15:00	SPY	ETF	271.14	271.14	271.14	271.14	300.0
2018-03-21 04:38:00	SPY	ETF	271.07	271.07	271.07	271.07	300.0
2018-03-21 04:40:00	SPY	ETF	271.04	271.04	271.04	271.04	200.0
2018-03-21 04:42:00	SPY	ETF	270.97	270.97	270.97	270.97	300.0
2018-03-21 04:43:00	SPY	ETF	270.97	270.97	270.9	270.9	1478.0
2018-03-21 04:49:00	SPY	ETF	270.95	270.95	270.95	270.95	300.0
2018-03-21 04:53:00	SPY	ETF	270.95	270.97	270.95	270.97	800.0
2018-03-21 05:00:00	SPY	ETF	271.02	271.02	271.02	271.02	600.0
2018-03-21 05:05:00	SPY	ETF	270.92	270.92	270.92	270.92	300.0
2018-03-21 05:06:00	SPY	ETF	270.95	270.95	270.95	270.95	100.0
2018-03-21 05:10:00	SPY	ETF	270.91	270.91	270.91	270.91	300.0
2018-03-21 05:14:00	SPY	ETF	270.85	270.85	270.84	270.84	5020.0
2018-03-21 05:15:00	SPY	ETF	270.82	270.82	270.82	270.82	500.0
2018-03-21 05:16:00	SPY	ETF	270.8	270.8	270.77	270.77	818.0
2018-03-21 05:18:00	SPY	ETF	270.83	270.84	270.83	270.84	1788.0
2018-03-21 05:23:00	SPY	ETF	270.88	270.88	270.87	270.87	1220.0
2018-03-21 05:25:00	SPY	ETF	270.93	270.94	270.93	270.94	3000.0
2018-03-21 05:29:00	SPY	ETF	270.98	270.98	270.98	270.98	320.0
2018-03-21 05:34:00	SPY	ETF	271.0	271.0	271.0	271.0	100.0
2018-03-21 05:42:00	SPY	ETF	271.0	271.0	271.0	271.0	100.0
2018-03-21 05:49:00	SPY	ETF	270.88	270.88	270.88	270.88	1500.0
2018-03-21 05:50:00	SPY	ETF	270.9	270.9	270.9	270.9	1788.0
2018-03-21 05:57:00	SPY	ETF	271.05	271.05	271.05	271.05	500.0
2018-03-21 06:01:00	SPY	ETF	271.07	271.07	271.07	271.07	320.0
2018-03-21 06:02:00	SPY	ETF	271.11	271.12	271.11	271.12	200.0
2018-03-21 06:03:00	SPY	ETF	271.14	271.14	271.14	271.14	500.0
2018-03-21 06:05:00	SPY	ETF	271.08	271.08	271.08	271.08	100.0
2018-03-21 06:07:00	SPY	ETF	271.07	271.07	271.07	271.07	100.0
2018-03-21 06:08:00	SPY	ETF	270.96	270.96	270.96	270.96	100.0
2018-03-21 06:10:00	SPY	ETF	271.03	271.05	271.03	271.05	1000.0
2018-03-21 06:13:00	SPY	ETF	270.97	271.0	270.97	271.0	320.0
2018-03-21 06:14:00	SPY	ETF	270.95	270.95	270.95	270.95	100.0
2018-03-21 06:16:00	SPY	ETF	270.94	270.94	270.94	270.94	100.0
2018-03-21 06:17:00	SPY	ETF	270.96	270.96	270.96	270.96	200.0
2018-03-21 06:18:00	SPY	ETF	270.97	270.97	270.97	270.97	300.0
2018-03-21 06:23:00	SPY	ETF	271.05	271.05	271.05	271.05	200.0
2018-03-21 06:26:00	SPY	ETF	271.05	271.06	271.05	271.06	200.0
2018-03-21 06:27:00	SPY	ETF	271.13	271.13	271.13	271.13	120.0
2018-03-21 06:28:00	SPY	ETF	271.1	271.13	271.1	271.13	500.0
2018-03-21 06:30:00	SPY	ETF	271.17	271.17	271.17	271.17	420.0

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

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