PREVIEW / etf_5min / 2018-11-05

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-11-05.parquet
  size:    1.4 MB
  rows:    60,651

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-05 04:00:00	SPY	ETF	271.35	271.39	271.18	271.39	3509.0
2018-11-05 04:05:00	SPY	ETF	271.25	271.26	271.14	271.14	4400.0
2018-11-05 04:10:00	SPY	ETF	271.11	271.21	271.11	271.11	4086.0
2018-11-05 04:15:00	SPY	ETF	271.19	271.19	271.08	271.08	2809.0
2018-11-05 04:20:00	SPY	ETF	271.13	271.21	271.11	271.11	3559.0
2018-11-05 04:25:00	SPY	ETF	271.21	271.34	271.19	271.34	3033.0
2018-11-05 04:30:00	SPY	ETF	271.41	271.41	271.36	271.36	2585.0
2018-11-05 04:35:00	SPY	ETF	271.39	271.51	271.39	271.51	1648.0
2018-11-05 04:40:00	SPY	ETF	271.5	271.5	271.49	271.49	300.0
2018-11-05 04:45:00	SPY	ETF	271.49	271.49	271.47	271.47	800.0
2018-11-05 04:50:00	SPY	ETF	271.54	271.59	271.54	271.59	1000.0
2018-11-05 04:55:00	SPY	ETF	271.68	271.7	271.6	271.7	6000.0
2018-11-05 05:00:00	SPY	ETF	271.8	271.94	271.8	271.94	7513.0
2018-11-05 05:05:00	SPY	ETF	271.86	271.86	271.86	271.86	300.0
2018-11-05 05:10:00	SPY	ETF	271.89	271.93	271.77	271.77	2600.0
2018-11-05 05:15:00	SPY	ETF	271.81	271.81	271.74	271.74	2250.0
2018-11-05 05:20:00	SPY	ETF	271.72	271.72	271.57	271.61	3000.0
2018-11-05 05:25:00	SPY	ETF	271.61	271.63	271.57	271.63	2100.0
2018-11-05 05:30:00	SPY	ETF	271.68	271.72	271.63	271.63	1900.0
2018-11-05 05:35:00	SPY	ETF	271.73	271.73	271.57	271.57	1900.0
2018-11-05 05:40:00	SPY	ETF	271.66	271.66	271.66	271.66	200.0
2018-11-05 05:45:00	SPY	ETF	271.75	271.8	271.75	271.8	1800.0
2018-11-05 05:50:00	SPY	ETF	271.85	271.95	271.85	271.95	3746.0
2018-11-05 05:55:00	SPY	ETF	271.92	271.92	271.92	271.92	500.0
2018-11-05 06:00:00	SPY	ETF	271.93	272.0	271.93	272.0	2350.0
2018-11-05 06:05:00	SPY	ETF	271.99	271.99	271.95	271.98	1900.0
2018-11-05 06:10:00	SPY	ETF	271.93	272.04	271.93	272.04	3650.0
2018-11-05 06:15:00	SPY	ETF	272.02	272.02	272.02	272.02	200.0
2018-11-05 06:20:00	SPY	ETF	271.95	272.22	271.95	272.22	5912.0
2018-11-05 06:25:00	SPY	ETF	272.18	272.23	272.18	272.23	2100.0
2018-11-05 06:30:00	SPY	ETF	272.19	272.19	272.05	272.06	4988.0
2018-11-05 06:35:00	SPY	ETF	272.07	272.07	272.05	272.05	1300.0
2018-11-05 06:40:00	SPY	ETF	272.07	272.07	272.02	272.02	1085.0
2018-11-05 06:45:00	SPY	ETF	272.1	272.31	272.1	272.31	14705.0
2018-11-05 06:50:00	SPY	ETF	272.35	272.4	272.35	272.36	6791.0
2018-11-05 06:55:00	SPY	ETF	272.35	272.38	272.35	272.38	7100.0
2018-11-05 07:00:00	SPY	ETF	272.38	272.54	272.38	272.54	28785.0
2018-11-05 07:05:00	SPY	ETF	272.54	272.6	272.48	272.5	11193.0
2018-11-05 07:10:00	SPY	ETF	272.55	272.55	272.49	272.49	625.0
2018-11-05 07:15:00	SPY	ETF	272.53	272.54	272.49	272.5	52009.0
2018-11-05 07:20:00	SPY	ETF	272.48	272.48	272.32	272.32	11913.0
2018-11-05 07:25:00	SPY	ETF	272.32	272.35	272.31	272.31	6106.0
2018-11-05 07:30:00	SPY	ETF	272.31	272.31	272.13	272.26	11307.0
2018-11-05 07:35:00	SPY	ETF	272.26	272.29	272.19	272.19	12920.0
2018-11-05 07:40:00	SPY	ETF	272.24	272.36	272.24	272.34	9845.0
2018-11-05 07:45:00	SPY	ETF	272.34	272.35	272.11	272.23	10268.0
2018-11-05 07:50:00	SPY	ETF	272.24	272.26	271.93	272.1	12178.0
2018-11-05 07:55:00	SPY	ETF	272.16	272.19	271.99	272.19	32096.0
2018-11-05 08:00:00	SPY	ETF	271.89	272.58	271.45	272.06	18964.0
2018-11-05 08:05:00	SPY	ETF	272.06	272.06	271.9	271.9	24987.0

> showing 50 of 60,651 rows — these rows as CSV

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