PREVIEW / etf_5min / 2019-06-18

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-06-18.parquet
  size:    1.5 MB
  rows:    64,201

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-06-18 04:00:00	SPY	ETF	289.22	289.23	289.14	289.14	1022.0
2019-06-18 04:05:00	SPY	ETF	289.17	289.27	289.17	289.27	1122.0
2019-06-18 04:10:00	SPY	ETF	289.46	289.5	289.46	289.5	312.0
2019-06-18 04:15:00	SPY	ETF	289.59	290.0	289.59	289.98	4106.0
2019-06-18 04:20:00	SPY	ETF	290.08	290.2	290.07	290.2	1185.0
2019-06-18 04:25:00	SPY	ETF	290.29	290.6	290.29	290.36	8400.0
2019-06-18 04:30:00	SPY	ETF	290.45	290.52	290.45	290.52	3755.0
2019-06-18 04:35:00	SPY	ETF	290.46	290.5	290.46	290.48	850.0
2019-06-18 04:40:00	SPY	ETF	290.55	290.7	290.55	290.63	1984.0
2019-06-18 04:45:00	SPY	ETF	290.6	290.6	290.53	290.53	910.0
2019-06-18 04:50:00	SPY	ETF	290.35	290.35	290.35	290.35	201.0
2019-06-18 04:55:00	SPY	ETF	290.43	290.43	290.33	290.33	3400.0
2019-06-18 05:00:00	SPY	ETF	290.48	290.5	290.48	290.5	2700.0
2019-06-18 05:05:00	SPY	ETF	290.43	290.43	290.43	290.43	800.0
2019-06-18 05:10:00	SPY	ETF	290.5	290.54	290.38	290.38	4211.0
2019-06-18 05:15:00	SPY	ETF	290.47	290.56	290.47	290.53	869.0
2019-06-18 05:20:00	SPY	ETF	290.52	290.52	290.48	290.5	1669.0
2019-06-18 05:25:00	SPY	ETF	290.55	290.55	290.4	290.43	2976.0
2019-06-18 05:30:00	SPY	ETF	290.41	290.41	290.41	290.41	269.0
2019-06-18 05:35:00	SPY	ETF	290.38	290.41	290.34	290.41	2020.0
2019-06-18 05:40:00	SPY	ETF	290.39	290.39	290.38	290.38	399.0
2019-06-18 05:45:00	SPY	ETF	290.34	290.34	290.23	290.23	4006.0
2019-06-18 05:55:00	SPY	ETF	290.36	290.36	290.33	290.33	620.0
2019-06-18 06:00:00	SPY	ETF	290.36	290.4	290.36	290.4	1776.0
2019-06-18 06:05:00	SPY	ETF	290.42	290.42	290.42	290.42	200.0
2019-06-18 06:10:00	SPY	ETF	290.33	290.33	290.33	290.33	200.0
2019-06-18 06:15:00	SPY	ETF	290.36	290.38	290.36	290.38	269.0
2019-06-18 06:20:00	SPY	ETF	290.4	290.45	290.4	290.45	1507.0
2019-06-18 06:25:00	SPY	ETF	290.5	290.64	290.48	290.64	7226.0
2019-06-18 06:30:00	SPY	ETF	290.68	290.68	290.6	290.64	3942.0
2019-06-18 06:35:00	SPY	ETF	290.63	290.7	290.6	290.61	41969.0
2019-06-18 06:40:00	SPY	ETF	290.67	290.84	290.67	290.8	4492.0
2019-06-18 06:45:00	SPY	ETF	290.88	290.93	290.88	290.92	3694.0
2019-06-18 06:50:00	SPY	ETF	291.0	291.18	291.0	291.12	8289.0
2019-06-18 06:55:00	SPY	ETF	290.99	291.07	290.99	291.07	18144.0
2019-06-18 07:00:00	SPY	ETF	291.05	291.07	290.99	290.99	11100.0
2019-06-18 07:05:00	SPY	ETF	290.99	291.05	290.99	291.01	17359.0
2019-06-18 07:10:00	SPY	ETF	291.05	291.07	291.0	291.0	7858.0
2019-06-18 07:15:00	SPY	ETF	291.02	291.08	291.0	291.01	26664.0
2019-06-18 07:20:00	SPY	ETF	291.0	291.03	290.93	290.94	55118.0
2019-06-18 07:25:00	SPY	ETF	290.94	291.03	290.94	290.99	16157.0
2019-06-18 07:30:00	SPY	ETF	290.98	291.03	290.93	290.93	19349.0
2019-06-18 07:35:00	SPY	ETF	290.95	291.21	290.95	291.21	24729.0
2019-06-18 07:40:00	SPY	ETF	291.23	291.3	291.23	291.27	69609.0
2019-06-18 07:45:00	SPY	ETF	291.26	291.43	291.26	291.34	140082.0
2019-06-18 07:50:00	SPY	ETF	291.34	291.46	291.34	291.46	4697.0
2019-06-18 07:55:00	SPY	ETF	291.45	291.47	291.37	291.37	17913.0
2019-06-18 08:00:00	SPY	ETF	291.35	291.47	289.0	291.45	138636.0
2019-06-18 08:05:00	SPY	ETF	291.47	291.47	291.36	291.4	8928.0
2019-06-18 08:10:00	SPY	ETF	291.37	291.45	291.36	291.42	62925.0

> showing 50 of 64,201 rows — these rows as CSV

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