PREVIEW / etf_1min / 2018-04-10

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-04-10.parquet
  size:    3.1 MB
  rows:    159,721

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-10 04:00:00	SPY	ETF	263.72	263.72	263.6	263.63	3527.0
2018-04-10 04:01:00	SPY	ETF	263.78	263.82	263.78	263.82	1500.0
2018-04-10 04:02:00	SPY	ETF	263.92	263.92	263.92	263.92	410.0
2018-04-10 04:03:00	SPY	ETF	264.15	264.16	264.13	264.13	700.0
2018-04-10 04:04:00	SPY	ETF	264.02	264.02	263.99	263.99	3050.0
2018-04-10 04:06:00	SPY	ETF	263.95	263.95	263.82	263.84	8000.0
2018-04-10 04:08:00	SPY	ETF	263.91	263.94	263.91	263.91	2200.0
2018-04-10 04:09:00	SPY	ETF	264.09	264.09	264.09	264.09	250.0
2018-04-10 04:10:00	SPY	ETF	264.12	264.12	264.06	264.06	1000.0
2018-04-10 04:11:00	SPY	ETF	264.15	264.22	264.15	264.22	300.0
2018-04-10 04:12:00	SPY	ETF	264.25	264.25	264.22	264.22	385.0
2018-04-10 04:13:00	SPY	ETF	264.25	264.25	264.25	264.25	516.0
2018-04-10 04:15:00	SPY	ETF	264.1	264.18	264.1	264.18	608.0
2018-04-10 04:16:00	SPY	ETF	264.14	264.25	264.14	264.25	5525.0
2018-04-10 04:17:00	SPY	ETF	264.23	264.27	264.23	264.27	5000.0
2018-04-10 04:18:00	SPY	ETF	264.12	264.12	264.12	264.12	200.0
2018-04-10 04:19:00	SPY	ETF	264.14	264.14	264.1	264.1	625.0
2018-04-10 04:21:00	SPY	ETF	264.23	264.23	264.23	264.23	100.0
2018-04-10 04:22:00	SPY	ETF	264.23	264.23	264.18	264.18	500.0
2018-04-10 04:25:00	SPY	ETF	264.23	264.23	264.23	264.23	300.0
2018-04-10 04:27:00	SPY	ETF	264.45	264.45	264.45	264.45	250.0
2018-04-10 04:28:00	SPY	ETF	264.44	264.5	264.44	264.5	900.0
2018-04-10 04:31:00	SPY	ETF	264.26	264.26	264.23	264.24	2650.0
2018-04-10 04:32:00	SPY	ETF	264.18	264.18	264.18	264.18	300.0
2018-04-10 04:35:00	SPY	ETF	264.12	264.12	264.05	264.05	450.0
2018-04-10 04:37:00	SPY	ETF	264.04	264.05	264.04	264.05	350.0
2018-04-10 04:42:00	SPY	ETF	264.05	264.05	264.05	264.05	100.0
2018-04-10 04:44:00	SPY	ETF	264.0	264.0	264.0	264.0	400.0
2018-04-10 04:45:00	SPY	ETF	263.91	263.91	263.91	263.91	175.0
2018-04-10 04:46:00	SPY	ETF	264.0	264.0	264.0	264.0	110.0
2018-04-10 04:47:00	SPY	ETF	264.1	264.1	264.1	264.1	170.0
2018-04-10 04:50:00	SPY	ETF	264.07	264.07	264.07	264.07	100.0
2018-04-10 04:51:00	SPY	ETF	263.99	264.0	263.99	264.0	400.0
2018-04-10 04:53:00	SPY	ETF	264.03	264.03	264.03	264.03	100.0
2018-04-10 04:56:00	SPY	ETF	264.13	264.13	264.13	264.13	400.0
2018-04-10 04:57:00	SPY	ETF	264.12	264.12	264.12	264.12	100.0
2018-04-10 04:59:00	SPY	ETF	264.07	264.07	264.07	264.07	500.0
2018-04-10 05:01:00	SPY	ETF	264.13	264.13	264.1	264.1	3500.0
2018-04-10 05:03:00	SPY	ETF	264.18	264.22	264.18	264.22	540.0
2018-04-10 05:04:00	SPY	ETF	264.19	264.22	264.19	264.22	1015.0
2018-04-10 05:08:00	SPY	ETF	264.1	264.1	264.0	264.0	260.0
2018-04-10 05:09:00	SPY	ETF	264.0	264.02	264.0	264.02	5500.0
2018-04-10 05:10:00	SPY	ETF	264.03	264.03	264.03	264.03	500.0
2018-04-10 05:11:00	SPY	ETF	264.1	264.1	264.1	264.1	500.0
2018-04-10 05:12:00	SPY	ETF	264.02	264.02	264.02	264.02	500.0
2018-04-10 05:15:00	SPY	ETF	264.03	264.09	264.0	264.0	5900.0
2018-04-10 05:16:00	SPY	ETF	264.07	264.07	264.07	264.07	300.0
2018-04-10 05:17:00	SPY	ETF	264.1	264.1	264.1	264.1	400.0
2018-04-10 05:19:00	SPY	ETF	264.09	264.24	264.09	264.24	1430.0
2018-04-10 05:20:00	SPY	ETF	264.31	264.32	264.31	264.32	1000.0

> showing 50 of 159,721 rows — these rows as CSV

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