PREVIEW / etf_5min / 2019-07-11

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-07-11.parquet
  size:    1.4 MB
  rows:    62,070

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
2019-07-11 04:00:00	SPY	ETF	299.26	299.36	299.26	299.32	1600.0
2019-07-11 04:05:00	SPY	ETF	299.27	299.27	299.27	299.27	100.0
2019-07-11 04:35:00	SPY	ETF	299.24	299.24	299.24	299.24	100.0
2019-07-11 05:00:00	SPY	ETF	299.21	299.27	299.18	299.27	910.0
2019-07-11 05:05:00	SPY	ETF	299.37	299.57	299.37	299.57	2960.0
2019-07-11 05:10:00	SPY	ETF	299.49	299.51	299.46	299.51	3865.0
2019-07-11 05:15:00	SPY	ETF	299.49	299.59	299.49	299.59	3500.0
2019-07-11 05:20:00	SPY	ETF	299.52	299.61	299.52	299.61	1934.0
2019-07-11 05:25:00	SPY	ETF	299.57	299.57	299.49	299.49	8593.0
2019-07-11 05:30:00	SPY	ETF	299.5	299.58	299.5	299.57	1981.0
2019-07-11 05:35:00	SPY	ETF	299.6	299.6	299.54	299.54	1200.0
2019-07-11 05:40:00	SPY	ETF	299.47	299.49	299.47	299.47	700.0
2019-07-11 05:45:00	SPY	ETF	299.49	299.52	299.49	299.52	1340.0
2019-07-11 05:50:00	SPY	ETF	299.54	299.58	299.54	299.57	1315.0
2019-07-11 05:55:00	SPY	ETF	299.57	299.57	299.55	299.55	1669.0
2019-07-11 06:00:00	SPY	ETF	299.55	299.56	299.49	299.52	2469.0
2019-07-11 06:05:00	SPY	ETF	299.47	299.47	299.39	299.39	5569.0
2019-07-11 06:10:00	SPY	ETF	299.44	299.46	299.44	299.46	600.0
2019-07-11 06:15:00	SPY	ETF	299.44	299.44	299.39	299.39	3200.0
2019-07-11 06:20:00	SPY	ETF	299.37	299.37	299.37	299.37	1000.0
2019-07-11 06:25:00	SPY	ETF	299.37	299.38	299.26	299.26	1202.0
2019-07-11 06:30:00	SPY	ETF	299.22	299.24	299.12	299.18	2794.0
2019-07-11 06:35:00	SPY	ETF	299.25	299.25	299.23	299.23	1300.0
2019-07-11 06:40:00	SPY	ETF	299.26	299.32	299.16	299.32	3435.0
2019-07-11 06:45:00	SPY	ETF	299.28	299.29	299.28	299.29	528.0
2019-07-11 06:50:00	SPY	ETF	299.33	299.33	299.29	299.29	2730.0
2019-07-11 06:55:00	SPY	ETF	299.33	299.48	299.32	299.48	11376.0
2019-07-11 07:00:00	SPY	ETF	299.47	299.52	299.41	299.45	12171.0
2019-07-11 07:05:00	SPY	ETF	299.48	299.48	299.41	299.46	4273.0
2019-07-11 07:10:00	SPY	ETF	299.48	299.49	299.4	299.41	18825.0
2019-07-11 07:15:00	SPY	ETF	299.43	299.43	299.4	299.43	900.0
2019-07-11 07:20:00	SPY	ETF	299.41	299.41	299.33	299.33	4816.0
2019-07-11 07:25:00	SPY	ETF	299.36	299.36	299.33	299.33	5612.0
2019-07-11 07:30:00	SPY	ETF	299.38	299.39	299.33	299.33	2183.0
2019-07-11 07:35:00	SPY	ETF	299.33	299.36	299.27	299.35	11800.0
2019-07-11 07:40:00	SPY	ETF	299.36	299.4	299.35	299.35	8583.0
2019-07-11 07:45:00	SPY	ETF	299.35	299.35	299.32	299.33	27170.0
2019-07-11 07:50:00	SPY	ETF	299.3	299.34	299.26	299.33	6539.0
2019-07-11 07:55:00	SPY	ETF	299.32	299.4	299.32	299.35	3967.0
2019-07-11 08:00:00	SPY	ETF	299.37	299.54	299.29	299.49	37295.0
2019-07-11 08:05:00	SPY	ETF	299.49	299.52	299.38	299.47	17943.0
2019-07-11 08:10:00	SPY	ETF	299.47	299.47	299.35	299.36	6600.0
2019-07-11 08:15:00	SPY	ETF	299.36	299.45	299.36	299.45	17173.0
2019-07-11 08:20:00	SPY	ETF	299.4	299.54	299.4	299.51	8798.0
2019-07-11 08:25:00	SPY	ETF	299.51	299.54	299.45	299.45	27194.0
2019-07-11 08:30:00	SPY	ETF	299.45	299.46	298.91	299.12	106573.0
2019-07-11 08:35:00	SPY	ETF	299.1	299.2001	299.08	299.2	47189.0
2019-07-11 08:40:00	SPY	ETF	299.2	299.22	299.18	299.2	11644.0
2019-07-11 08:45:00	SPY	ETF	299.21	299.21	299.11	299.11	13556.0
2019-07-11 08:50:00	SPY	ETF	299.13	299.22	299.12	299.18	95992.0

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

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