PREVIEW / etf_5min / 2018-03-27

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-03-27.parquet
  size:    1.4 MB
  rows:    59,981

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-03-27 04:00:00	SPY	ETF	266.36	266.39	266.25	266.25	10655.0
2018-03-27 04:05:00	SPY	ETF	266.23	266.33	266.2	266.33	3090.0
2018-03-27 04:10:00	SPY	ETF	266.29	266.31	266.29	266.31	1069.0
2018-03-27 04:15:00	SPY	ETF	266.21	266.21	266.1	266.11	10475.0
2018-03-27 04:20:00	SPY	ETF	266.16	266.16	266.16	266.16	100.0
2018-03-27 04:25:00	SPY	ETF	266.24	266.35	266.24	266.35	602.0
2018-03-27 04:30:00	SPY	ETF	266.32	266.42	266.32	266.42	2700.0
2018-03-27 04:35:00	SPY	ETF	266.42	266.55	266.42	266.55	1926.0
2018-03-27 04:40:00	SPY	ETF	266.59	266.61	266.59	266.59	4375.0
2018-03-27 04:45:00	SPY	ETF	266.53	266.56	266.53	266.56	2440.0
2018-03-27 04:50:00	SPY	ETF	266.66	266.66	266.66	266.66	2017.0
2018-03-27 04:55:00	SPY	ETF	266.7	266.7	266.57	266.57	1150.0
2018-03-27 05:00:00	SPY	ETF	266.66	266.69	266.61	266.61	3600.0
2018-03-27 05:05:00	SPY	ETF	266.66	266.76	266.66	266.76	2610.0
2018-03-27 05:10:00	SPY	ETF	266.76	266.81	266.76	266.81	6299.0
2018-03-27 05:15:00	SPY	ETF	266.63	266.63	266.63	266.63	400.0
2018-03-27 05:20:00	SPY	ETF	266.73	266.78	266.73	266.78	1150.0
2018-03-27 05:25:00	SPY	ETF	266.85	266.86	266.85	266.85	732.0
2018-03-27 05:30:00	SPY	ETF	266.88	266.94	266.85	266.85	13040.0
2018-03-27 05:35:00	SPY	ETF	266.9	266.98	266.9	266.98	430.0
2018-03-27 05:40:00	SPY	ETF	266.99	266.99	266.88	266.94	1100.0
2018-03-27 05:45:00	SPY	ETF	266.97	267.0	266.97	266.97	1980.0
2018-03-27 05:50:00	SPY	ETF	266.99	266.99	266.93	266.93	1000.0
2018-03-27 05:55:00	SPY	ETF	266.99	267.1	266.99	267.1	645.0
2018-03-27 06:00:00	SPY	ETF	267.05	267.08	266.9	266.9	4580.0
2018-03-27 06:05:00	SPY	ETF	266.83	266.83	266.63	266.63	8230.0
2018-03-27 06:10:00	SPY	ETF	266.65	266.66	266.57	266.57	3370.0
2018-03-27 06:15:00	SPY	ETF	266.66	266.66	266.62	266.62	950.0
2018-03-27 06:20:00	SPY	ETF	266.7	266.74	266.7	266.73	800.0
2018-03-27 06:25:00	SPY	ETF	266.56	266.61	266.56	266.61	500.0
2018-03-27 06:30:00	SPY	ETF	266.63	266.63	266.53	266.55	2005.0
2018-03-27 06:35:00	SPY	ETF	266.6	266.64	266.55	266.55	4700.0
2018-03-27 06:40:00	SPY	ETF	266.5	266.62	266.5	266.62	1196.0
2018-03-27 06:45:00	SPY	ETF	266.6	266.6	266.6	266.6	300.0
2018-03-27 06:50:00	SPY	ETF	266.5	266.51	266.41	266.51	11279.0
2018-03-27 06:55:00	SPY	ETF	266.54	266.54	266.39	266.39	12966.0
2018-03-27 07:00:00	SPY	ETF	266.39	266.55	266.39	266.47	13809.0
2018-03-27 07:05:00	SPY	ETF	266.48	266.75	266.48	266.74	15550.0
2018-03-27 07:10:00	SPY	ETF	266.71	266.75	266.62	266.66	26697.0
2018-03-27 07:15:00	SPY	ETF	266.66	266.74	266.65	266.69	8300.0
2018-03-27 07:20:00	SPY	ETF	266.66	266.77	266.6	266.74	13310.0
2018-03-27 07:25:00	SPY	ETF	266.66	266.72	266.66	266.66	54267.0
2018-03-27 07:30:00	SPY	ETF	266.63	266.68	266.51	266.51	30856.0
2018-03-27 07:35:00	SPY	ETF	266.52	266.58	266.51	266.52	34150.0
2018-03-27 07:40:00	SPY	ETF	266.53	266.58	266.41	266.41	16355.0
2018-03-27 07:45:00	SPY	ETF	266.41	266.45	266.34	266.41	6906.0
2018-03-27 07:50:00	SPY	ETF	266.47	266.52	266.44	266.49	31440.0
2018-03-27 07:55:00	SPY	ETF	266.49	266.55	266.47	266.47	29949.0
2018-03-27 08:00:00	SPY	ETF	266.49	266.71	266.01	266.31	54696.0
2018-03-27 08:05:00	SPY	ETF	266.32	266.94	266.27	266.29	105641.0

> showing 50 of 59,981 rows — these rows as CSV

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