PREVIEW / etf_5min / 2018-11-19

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-11-19.parquet
  size:    1.4 MB
  rows:    62,375

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-11-19 04:00:00	SPY	ETF	274.32	274.32	274.2	274.2	638.0
2018-11-19 04:05:00	SPY	ETF	274.26	274.26	274.26	274.26	200.0
2018-11-19 04:10:00	SPY	ETF	274.28	274.28	273.87	273.87	6289.0
2018-11-19 04:15:00	SPY	ETF	274.08	274.13	274.07	274.07	1401.0
2018-11-19 04:20:00	SPY	ETF	274.13	274.15	274.09	274.15	857.0
2018-11-19 04:25:00	SPY	ETF	274.12	274.28	274.04	274.28	2217.0
2018-11-19 04:30:00	SPY	ETF	274.3	274.3	274.2	274.2	889.0
2018-11-19 04:35:00	SPY	ETF	274.15	274.15	273.89	273.95	2683.0
2018-11-19 04:40:00	SPY	ETF	273.95	273.98	273.93	273.98	2456.0
2018-11-19 04:45:00	SPY	ETF	273.87	273.98	273.75	273.91	3100.0
2018-11-19 04:50:00	SPY	ETF	273.91	273.95	273.91	273.95	1449.0
2018-11-19 04:55:00	SPY	ETF	273.96	273.98	273.93	273.93	4219.0
2018-11-19 05:00:00	SPY	ETF	273.9	273.9	273.71	273.81	4774.0
2018-11-19 05:05:00	SPY	ETF	273.79	273.95	273.75	273.95	3596.0
2018-11-19 05:10:00	SPY	ETF	273.89	274.08	273.84	273.98	4009.0
2018-11-19 05:15:00	SPY	ETF	273.98	273.98	273.93	273.93	1500.0
2018-11-19 05:20:00	SPY	ETF	273.86	273.86	273.78	273.78	2143.0
2018-11-19 05:25:00	SPY	ETF	273.71	273.88	273.71	273.88	1238.0
2018-11-19 05:30:00	SPY	ETF	273.85	273.85	273.67	273.78	8143.0
2018-11-19 05:35:00	SPY	ETF	273.82	273.82	273.63	273.63	11776.0
2018-11-19 05:40:00	SPY	ETF	273.63	273.65	273.55	273.56	6465.0
2018-11-19 05:45:00	SPY	ETF	273.54	273.58	273.48	273.58	8007.0
2018-11-19 05:50:00	SPY	ETF	273.61	273.64	273.55	273.55	3025.0
2018-11-19 05:55:00	SPY	ETF	273.75	273.75	273.65	273.65	2769.0
2018-11-19 06:00:00	SPY	ETF	273.8	273.8	273.75	273.75	1069.0
2018-11-19 06:05:00	SPY	ETF	273.75	273.83	273.73	273.83	3438.0
2018-11-19 06:10:00	SPY	ETF	273.85	273.94	273.85	273.85	4447.0
2018-11-19 06:15:00	SPY	ETF	273.8	273.8	273.8	273.8	100.0
2018-11-19 06:20:00	SPY	ETF	273.85	273.85	273.71	273.71	5241.0
2018-11-19 06:25:00	SPY	ETF	273.61	273.61	273.57	273.57	5057.0
2018-11-19 06:30:00	SPY	ETF	273.57	273.59	273.52	273.55	7907.0
2018-11-19 06:35:00	SPY	ETF	273.54	273.55	273.24	273.24	27921.0
2018-11-19 06:40:00	SPY	ETF	273.23	273.3	273.2	273.3	11200.0
2018-11-19 06:45:00	SPY	ETF	273.27	273.3	273.22	273.3	14994.0
2018-11-19 06:50:00	SPY	ETF	273.28	273.32	273.28	273.32	2400.0
2018-11-19 06:55:00	SPY	ETF	273.3	273.3	273.16	273.2	18415.0
2018-11-19 07:00:00	SPY	ETF	273.23	273.34	273.16	273.18	25100.0
2018-11-19 07:05:00	SPY	ETF	273.17	273.25	273.12	273.15	43609.0
2018-11-19 07:10:00	SPY	ETF	273.15	273.15	272.96	273.09	33079.0
2018-11-19 07:15:00	SPY	ETF	273.06	273.29	273.06	273.25	11170.0
2018-11-19 07:20:00	SPY	ETF	273.26	273.26	273.2	273.2	15725.0
2018-11-19 07:25:00	SPY	ETF	273.24	273.29	273.2	273.22	18527.0
2018-11-19 07:30:00	SPY	ETF	273.28	273.34	273.26	273.31	14919.0
2018-11-19 07:35:00	SPY	ETF	273.31	273.35	273.27	273.3	9365.0
2018-11-19 07:40:00	SPY	ETF	273.32	273.35	273.3	273.35	27578.0
2018-11-19 07:45:00	SPY	ETF	273.36	273.36	273.14	273.29	47026.0
2018-11-19 07:50:00	SPY	ETF	273.28	273.28	273.2	273.22	10540.0
2018-11-19 07:55:00	SPY	ETF	273.21	273.33	273.21	273.3	11572.0
2018-11-19 08:00:00	SPY	ETF	273.1501	274.0	273.01	273.15	60537.0
2018-11-19 08:05:00	SPY	ETF	273.2	273.3	273.19	273.3	17033.0

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

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