PREVIEW / etf_5min / 2018-10-05

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-10-05.parquet
  size:    1.5 MB
  rows:    61,975

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-10-05 04:00:00	SPY	ETF	289.47	289.47	289.35	289.35	893.0
2018-10-05 04:05:00	SPY	ETF	289.3	289.3	289.26	289.26	500.0
2018-10-05 04:10:00	SPY	ETF	289.25	289.58	289.21	289.27	3812.0
2018-10-05 04:15:00	SPY	ETF	289.3	289.3	289.24	289.24	705.0
2018-10-05 04:30:00	SPY	ETF	289.1	289.17	289.1	289.17	400.0
2018-10-05 04:35:00	SPY	ETF	289.1	289.1	289.1	289.1	700.0
2018-10-05 04:55:00	SPY	ETF	289.21	289.21	289.21	289.21	9970.0
2018-10-05 05:00:00	SPY	ETF	289.27	289.27	289.27	289.27	150.0
2018-10-05 05:05:00	SPY	ETF	289.28	289.29	289.23	289.29	810.0
2018-10-05 05:15:00	SPY	ETF	289.28	289.31	289.28	289.31	2630.0
2018-10-05 05:20:00	SPY	ETF	289.28	289.28	289.28	289.28	300.0
2018-10-05 05:30:00	SPY	ETF	289.36	289.36	289.29	289.29	600.0
2018-10-05 05:35:00	SPY	ETF	289.39	289.39	289.38	289.38	1500.0
2018-10-05 05:40:00	SPY	ETF	289.36	289.41	289.36	289.41	3300.0
2018-10-05 05:45:00	SPY	ETF	289.41	289.44	289.4	289.41	2600.0
2018-10-05 05:50:00	SPY	ETF	289.36	289.37	289.36	289.37	300.0
2018-10-05 06:00:00	SPY	ETF	289.46	289.51	289.46	289.51	1610.0
2018-10-05 06:05:00	SPY	ETF	289.55	289.58	289.54	289.55	8100.0
2018-10-05 06:10:00	SPY	ETF	289.54	289.54	289.54	289.54	2000.0
2018-10-05 06:15:00	SPY	ETF	289.58	289.58	289.58	289.58	280.0
2018-10-05 06:20:00	SPY	ETF	289.61	289.61	289.61	289.61	1350.0
2018-10-05 06:25:00	SPY	ETF	289.63	289.63	289.63	289.63	100.0
2018-10-05 06:30:00	SPY	ETF	289.58	289.58	289.58	289.58	500.0
2018-10-05 06:35:00	SPY	ETF	289.54	289.56	289.51	289.51	7110.0
2018-10-05 06:40:00	SPY	ETF	289.56	289.56	289.54	289.54	800.0
2018-10-05 06:45:00	SPY	ETF	289.51	289.51	289.46	289.46	800.0
2018-10-05 06:50:00	SPY	ETF	289.54	289.54	289.53	289.54	9100.0
2018-10-05 06:55:00	SPY	ETF	289.56	289.56	289.54	289.54	1500.0
2018-10-05 07:00:00	SPY	ETF	289.56	289.65	289.55	289.64	13731.0
2018-10-05 07:05:00	SPY	ETF	289.64	289.75	289.64	289.7	5729.0
2018-10-05 07:10:00	SPY	ETF	289.74	289.89	289.74	289.88	11555.0
2018-10-05 07:15:00	SPY	ETF	289.85	289.87	289.83	289.83	3700.0
2018-10-05 07:20:00	SPY	ETF	289.8	289.84	289.8	289.81	20268.0
2018-10-05 07:25:00	SPY	ETF	289.82	289.82	289.78	289.81	1451.0
2018-10-05 07:30:00	SPY	ETF	289.84	289.84	289.84	289.84	25080.0
2018-10-05 07:35:00	SPY	ETF	289.75	289.75	289.75	289.75	100.0
2018-10-05 07:40:00	SPY	ETF	289.74	289.77	289.73	289.73	3270.0
2018-10-05 07:45:00	SPY	ETF	289.7	289.7	289.63	289.64	8009.0
2018-10-05 07:50:00	SPY	ETF	289.69	289.74	289.67	289.73	9320.0
2018-10-05 07:55:00	SPY	ETF	289.65	289.67	289.62	289.62	2400.0
2018-10-05 08:00:00	SPY	ETF	289.44	289.87	289.44	289.65	45093.0
2018-10-05 08:05:00	SPY	ETF	289.65	289.66	289.55	289.58	17267.0
2018-10-05 08:10:00	SPY	ETF	289.58	289.58	289.32	289.33	32463.0
2018-10-05 08:15:00	SPY	ETF	289.38	289.38	289.25	289.34	19674.0
2018-10-05 08:20:00	SPY	ETF	289.39	289.41	289.26	289.29	10778.0
2018-10-05 08:25:00	SPY	ETF	289.26	289.52	289.24	289.5	45606.0
2018-10-05 08:30:00	SPY	ETF	289.46	290.35	289.08	289.7	555837.0
2018-10-05 08:35:00	SPY	ETF	289.7	289.71	288.91	288.91	267820.0
2018-10-05 08:40:00	SPY	ETF	288.91	289.1	288.74	289.04	187275.0
2018-10-05 08:45:00	SPY	ETF	289.03	289.27	289.03	289.24	57215.0

> showing 50 of 61,975 rows — these rows as CSV

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