PREVIEW / etf_5min / 2018-11-27

all etf 5-min files

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

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-27 04:00:00	SPY	ETF	266.8	266.8	266.65	266.7	20297.0
2018-11-27 04:05:00	SPY	ETF	266.7	267.01	266.7	267.01	6130.0
2018-11-27 04:10:00	SPY	ETF	266.97	266.97	266.95	266.95	1900.0
2018-11-27 04:15:00	SPY	ETF	266.9	267.15	266.9	267.15	4269.0
2018-11-27 04:20:00	SPY	ETF	267.15	267.3	267.13	267.28	4012.0
2018-11-27 04:25:00	SPY	ETF	267.18	267.43	267.17	267.34	6737.0
2018-11-27 04:30:00	SPY	ETF	267.38	267.5	267.32	267.32	7366.0
2018-11-27 04:35:00	SPY	ETF	267.31	267.35	267.23	267.23	1039.0
2018-11-27 04:40:00	SPY	ETF	267.21	267.27	267.12	267.12	3772.0
2018-11-27 04:45:00	SPY	ETF	267.12	267.12	267.0	267.0	2945.0
2018-11-27 04:55:00	SPY	ETF	266.94	266.94	266.84	266.84	600.0
2018-11-27 05:00:00	SPY	ETF	266.85	266.85	266.85	266.85	200.0
2018-11-27 05:05:00	SPY	ETF	266.99	266.99	266.99	266.99	100.0
2018-11-27 05:10:00	SPY	ETF	266.84	266.99	266.74	266.74	4600.0
2018-11-27 05:15:00	SPY	ETF	266.74	266.88	266.74	266.88	3000.0
2018-11-27 05:20:00	SPY	ETF	266.74	266.74	266.65	266.66	3600.0
2018-11-27 05:25:00	SPY	ETF	266.74	266.84	266.66	266.84	1100.0
2018-11-27 05:30:00	SPY	ETF	266.68	266.68	266.46	266.46	10715.0
2018-11-27 05:35:00	SPY	ETF	266.5	266.54	266.5	266.54	537.0
2018-11-27 05:40:00	SPY	ETF	266.56	266.61	266.51	266.6	12500.0
2018-11-27 05:45:00	SPY	ETF	266.59	266.59	266.53	266.53	2402.0
2018-11-27 05:50:00	SPY	ETF	266.47	266.53	266.47	266.53	2475.0
2018-11-27 05:55:00	SPY	ETF	266.58	266.63	266.58	266.58	2700.0
2018-11-27 06:00:00	SPY	ETF	266.44	266.44	266.27	266.34	2895.0
2018-11-27 06:05:00	SPY	ETF	266.37	266.43	266.32	266.36	1600.0
2018-11-27 06:10:00	SPY	ETF	266.31	266.31	266.31	266.31	500.0
2018-11-27 06:15:00	SPY	ETF	266.28	266.45	266.24	266.32	19350.0
2018-11-27 06:20:00	SPY	ETF	266.16	266.16	266.07	266.1	4362.0
2018-11-27 06:25:00	SPY	ETF	266.09	266.2	266.06	266.2	1750.0
2018-11-27 06:30:00	SPY	ETF	266.1	266.44	266.1	266.34	22498.0
2018-11-27 06:35:00	SPY	ETF	266.32	266.35	266.3	266.33	4300.0
2018-11-27 06:40:00	SPY	ETF	266.3	266.43	266.3	266.35	5500.0
2018-11-27 06:45:00	SPY	ETF	266.34	266.41	266.34	266.4	1000.0
2018-11-27 06:50:00	SPY	ETF	266.4	266.4	266.34	266.39	5520.0
2018-11-27 06:55:00	SPY	ETF	266.37	266.5	266.36	266.5	8138.0
2018-11-27 07:00:00	SPY	ETF	266.53	266.55	266.3	266.44	14282.0
2018-11-27 07:05:00	SPY	ETF	266.44	266.44	266.34	266.41	6107.0
2018-11-27 07:10:00	SPY	ETF	266.41	266.44	266.38	266.39	6350.0
2018-11-27 07:15:00	SPY	ETF	266.38	266.38	266.13	266.17	29567.0
2018-11-27 07:20:00	SPY	ETF	266.14	266.22	266.13	266.16	33058.0
2018-11-27 07:25:00	SPY	ETF	266.16	266.29	266.16	266.29	22288.0
2018-11-27 07:30:00	SPY	ETF	266.33	266.33	266.18	266.18	13218.0
2018-11-27 07:35:00	SPY	ETF	266.15	266.24	266.11	266.2	17526.0
2018-11-27 07:40:00	SPY	ETF	266.2	266.3	266.15	266.18	49448.0
2018-11-27 07:45:00	SPY	ETF	266.18	266.18	265.9	265.9	63544.0
2018-11-27 07:50:00	SPY	ETF	265.92	266.0	265.88	265.93	5381.0
2018-11-27 07:55:00	SPY	ETF	265.97	266.04	265.87	265.87	20481.0
2018-11-27 08:00:00	SPY	ETF	266.15	268.45	265.87	265.99	31926.0
2018-11-27 08:05:00	SPY	ETF	266.0	266.04	265.96	266.0	18850.0
2018-11-27 08:10:00	SPY	ETF	266.02	266.04	265.89	265.94	55529.0

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

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