PREVIEW / etf_5min / 2018-01-08

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-01-08.parquet
  size:    1.4 MB
  rows:    62,377

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-01-08 04:05:00	SPY	ETF	273.55	273.55	273.55	273.55	400.0
2018-01-08 04:10:00	SPY	ETF	273.55	273.55	273.55	273.55	400.0
2018-01-08 04:15:00	SPY	ETF	273.52	273.6	273.52	273.6	1250.0
2018-01-08 04:25:00	SPY	ETF	273.55	273.55	273.55	273.55	200.0
2018-01-08 04:30:00	SPY	ETF	273.54	273.54	273.54	273.54	5000.0
2018-01-08 04:40:00	SPY	ETF	273.48	273.48	273.48	273.48	400.0
2018-01-08 04:45:00	SPY	ETF	273.49	273.51	273.49	273.51	200.0
2018-01-08 04:55:00	SPY	ETF	273.56	273.56	273.56	273.56	100.0
2018-01-08 05:15:00	SPY	ETF	273.57	273.57	273.57	273.57	200.0
2018-01-08 05:20:00	SPY	ETF	273.52	273.52	273.52	273.52	200.0
2018-01-08 05:30:00	SPY	ETF	273.57	273.61	273.57	273.61	900.0
2018-01-08 05:35:00	SPY	ETF	273.62	273.66	273.62	273.64	840.0
2018-01-08 05:40:00	SPY	ETF	273.65	273.69	273.65	273.68	400.0
2018-01-08 05:45:00	SPY	ETF	273.63	273.63	273.63	273.63	100.0
2018-01-08 05:50:00	SPY	ETF	273.6	273.6	273.54	273.54	1100.0
2018-01-08 05:55:00	SPY	ETF	273.57	273.57	273.57	273.57	498.0
2018-01-08 06:00:00	SPY	ETF	273.62	273.68	273.62	273.68	800.0
2018-01-08 06:15:00	SPY	ETF	273.62	273.62	273.6	273.6	1000.0
2018-01-08 06:20:00	SPY	ETF	273.52	273.52	273.52	273.52	200.0
2018-01-08 06:35:00	SPY	ETF	273.57	273.57	273.57	273.57	250.0
2018-01-08 06:40:00	SPY	ETF	273.57	273.57	273.57	273.57	100.0
2018-01-08 06:50:00	SPY	ETF	273.45	273.45	273.35	273.37	13387.0
2018-01-08 06:55:00	SPY	ETF	273.35	273.35	273.2	273.2	61755.0
2018-01-08 07:00:00	SPY	ETF	273.2	273.26	273.2	273.2	55922.0
2018-01-08 07:05:00	SPY	ETF	273.26	273.26	273.21	273.22	4250.0
2018-01-08 07:10:00	SPY	ETF	273.29	273.31	273.26	273.31	56280.0
2018-01-08 07:15:00	SPY	ETF	273.32	273.32	273.28	273.29	52645.0
2018-01-08 07:20:00	SPY	ETF	273.27	273.32	273.27	273.3	51075.0
2018-01-08 07:25:00	SPY	ETF	273.3	273.3	273.07	273.1	35850.0
2018-01-08 07:30:00	SPY	ETF	273.1	273.18	273.1	273.18	53000.0
2018-01-08 07:35:00	SPY	ETF	273.15	273.16	273.07	273.09	6260.0
2018-01-08 07:40:00	SPY	ETF	273.11	273.11	273.09	273.09	2800.0
2018-01-08 07:45:00	SPY	ETF	273.07	273.07	273.0	273.01	33644.0
2018-01-08 07:50:00	SPY	ETF	273.01	273.11	272.99	273.11	118950.0
2018-01-08 07:55:00	SPY	ETF	273.11	273.14	273.11	273.14	32241.0
2018-01-08 08:00:00	SPY	ETF	273.12	273.35	273.07	273.19	75519.0
2018-01-08 08:05:00	SPY	ETF	273.17	273.21	273.17	273.2	58465.0
2018-01-08 08:10:00	SPY	ETF	273.21	273.21	273.15	273.15	29452.0
2018-01-08 08:15:00	SPY	ETF	273.14	273.16	273.1	273.1	29696.0
2018-01-08 08:20:00	SPY	ETF	273.11	273.13	273.09	273.12	21011.0
2018-01-08 08:25:00	SPY	ETF	273.14	273.14	273.01	273.02	51048.0
2018-01-08 08:30:00	SPY	ETF	273.02	273.12	273.0	273.1	22069.0
2018-01-08 08:35:00	SPY	ETF	273.11	273.23	273.07	273.22	62717.0
2018-01-08 08:40:00	SPY	ETF	273.22	273.23	273.15	273.2	37458.0
2018-01-08 08:45:00	SPY	ETF	273.23	273.26	273.22	273.26	79566.0
2018-01-08 08:50:00	SPY	ETF	273.25	273.29	273.17	273.17	21698.0
2018-01-08 08:55:00	SPY	ETF	273.22	273.22	273.19	273.19	17338.0
2018-01-08 09:00:00	SPY	ETF	273.22	273.27	273.22	273.27	48706.0
2018-01-08 09:05:00	SPY	ETF	273.24	273.24	273.22	273.24	3634.0
2018-01-08 09:10:00	SPY	ETF	273.22	273.24	273.19	273.21	40491.0

> showing 50 of 62,377 rows — these rows as CSV

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