PREVIEW / etf_1min / 2018-04-25

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-04-25.parquet
  size:    2.9 MB
  rows:    155,277

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-25 04:02:00	SPY	ETF	262.84	262.84	262.84	262.84	126.0
2018-04-25 04:03:00	SPY	ETF	262.84	262.84	262.78	262.78	3000.0
2018-04-25 04:04:00	SPY	ETF	262.83	262.83	262.83	262.83	1000.0
2018-04-25 04:10:00	SPY	ETF	262.64	262.64	262.64	262.64	500.0
2018-04-25 04:11:00	SPY	ETF	262.6	262.6	262.6	262.6	1700.0
2018-04-25 04:13:00	SPY	ETF	262.67	262.67	262.67	262.67	110.0
2018-04-25 04:14:00	SPY	ETF	262.6	262.6	262.6	262.6	200.0
2018-04-25 04:19:00	SPY	ETF	262.57	262.57	262.57	262.57	2015.0
2018-04-25 04:20:00	SPY	ETF	262.5	262.5	262.49	262.49	616.0
2018-04-25 04:22:00	SPY	ETF	262.54	262.54	262.54	262.54	200.0
2018-04-25 04:24:00	SPY	ETF	262.47	262.47	262.47	262.47	100.0
2018-04-25 04:29:00	SPY	ETF	262.52	262.52	262.52	262.52	100.0
2018-04-25 04:31:00	SPY	ETF	262.45	262.45	262.45	262.45	100.0
2018-04-25 04:32:00	SPY	ETF	262.39	262.39	262.32	262.32	350.0
2018-04-25 04:34:00	SPY	ETF	262.29	262.29	262.29	262.29	100.0
2018-04-25 04:35:00	SPY	ETF	262.2	262.2	262.1	262.1	402.0
2018-04-25 04:36:00	SPY	ETF	262.12	262.12	261.99	262.0	5800.0
2018-04-25 04:37:00	SPY	ETF	262.02	262.02	262.02	262.02	100.0
2018-04-25 04:38:00	SPY	ETF	262.09	262.09	262.07	262.07	2105.0
2018-04-25 04:39:00	SPY	ETF	262.12	262.12	262.12	262.12	100.0
2018-04-25 04:47:00	SPY	ETF	262.06	262.06	262.06	262.06	1705.0
2018-04-25 04:48:00	SPY	ETF	262.07	262.07	262.07	262.07	100.0
2018-04-25 04:49:00	SPY	ETF	261.98	261.99	261.98	261.99	400.0
2018-04-25 04:51:00	SPY	ETF	262.07	262.08	262.07	262.07	1500.0
2018-04-25 04:52:00	SPY	ETF	262.04	262.04	261.98	261.98	1525.0
2018-04-25 04:53:00	SPY	ETF	262.1	262.1	262.1	262.1	500.0
2018-04-25 04:54:00	SPY	ETF	262.09	262.12	262.09	262.12	1005.0
2018-04-25 04:55:00	SPY	ETF	262.17	262.17	262.17	262.17	600.0
2018-04-25 04:56:00	SPY	ETF	262.2	262.2	262.2	262.2	200.0
2018-04-25 04:57:00	SPY	ETF	262.17	262.17	262.17	262.17	500.0
2018-04-25 04:59:00	SPY	ETF	262.13	262.13	262.11	262.11	1800.0
2018-04-25 05:02:00	SPY	ETF	262.22	262.22	262.22	262.22	100.0
2018-04-25 05:03:00	SPY	ETF	262.2	262.2	262.2	262.2	181.0
2018-04-25 05:06:00	SPY	ETF	262.28	262.28	262.28	262.28	100.0
2018-04-25 05:08:00	SPY	ETF	262.23	262.23	262.23	262.23	400.0
2018-04-25 05:14:00	SPY	ETF	262.24	262.24	262.21	262.21	1000.0
2018-04-25 05:15:00	SPY	ETF	262.05	262.05	262.03	262.03	220.0
2018-04-25 05:17:00	SPY	ETF	262.01	262.01	261.88	261.88	700.0
2018-04-25 05:19:00	SPY	ETF	261.97	261.97	261.97	261.97	482.0
2018-04-25 05:21:00	SPY	ETF	261.91	261.91	261.86	261.86	2100.0
2018-04-25 05:22:00	SPY	ETF	261.89	261.89	261.89	261.89	250.0
2018-04-25 05:23:00	SPY	ETF	261.81	261.81	261.81	261.81	180.0
2018-04-25 05:25:00	SPY	ETF	261.92	261.92	261.92	261.92	2500.0
2018-04-25 05:26:00	SPY	ETF	262.06	262.06	262.06	262.06	100.0
2018-04-25 05:27:00	SPY	ETF	262.14	262.14	262.14	262.14	350.0
2018-04-25 05:28:00	SPY	ETF	262.2	262.2	262.2	262.2	100.0
2018-04-25 05:32:00	SPY	ETF	262.18	262.18	262.18	262.18	250.0
2018-04-25 05:33:00	SPY	ETF	262.2	262.2	262.2	262.2	300.0
2018-04-25 05:35:00	SPY	ETF	262.23	262.3	262.23	262.3	980.0
2018-04-25 05:36:00	SPY	ETF	262.3	262.3	262.3	262.3	500.0

> showing 50 of 155,277 rows — these rows as CSV

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