PREVIEW / etf_5min / 2016-12-19

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-12-19.parquet
  size:    1.3 MB
  rows:    55,577

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
2016-12-19 04:00:00	SPY	ETF	225.5	225.5	225.5	225.5	2500.0
2016-12-19 04:30:00	SPY	ETF	225.49	225.49	225.49	225.49	1000.0
2016-12-19 04:35:00	SPY	ETF	225.49	225.49	225.49	225.49	500.0
2016-12-19 05:50:00	SPY	ETF	225.63	225.63	225.63	225.63	100.0
2016-12-19 06:05:00	SPY	ETF	225.52	225.52	225.5	225.5	1000.0
2016-12-19 06:10:00	SPY	ETF	225.53	225.53	225.5	225.51	2000.0
2016-12-19 06:15:00	SPY	ETF	225.52	225.52	225.5	225.52	8300.0
2016-12-19 06:20:00	SPY	ETF	225.51	225.52	225.51	225.52	1100.0
2016-12-19 06:25:00	SPY	ETF	225.52	225.52	225.48	225.48	2800.0
2016-12-19 06:30:00	SPY	ETF	225.45	225.51	225.45	225.51	6800.0
2016-12-19 06:35:00	SPY	ETF	225.48	225.48	225.48	225.48	220.0
2016-12-19 06:40:00	SPY	ETF	225.46	225.48	225.46	225.48	1600.0
2016-12-19 06:45:00	SPY	ETF	225.48	225.48	225.44	225.44	1500.0
2016-12-19 06:50:00	SPY	ETF	225.51	225.51	225.48	225.51	11050.0
2016-12-19 06:55:00	SPY	ETF	225.51	225.51	225.42	225.42	4900.0
2016-12-19 07:00:00	SPY	ETF	225.46	225.46	225.46	225.46	300.0
2016-12-19 07:05:00	SPY	ETF	225.41	225.41	225.41	225.41	700.0
2016-12-19 07:10:00	SPY	ETF	225.43	225.43	225.43	225.43	400.0
2016-12-19 07:15:00	SPY	ETF	225.43	225.43	225.43	225.43	1700.0
2016-12-19 07:20:00	SPY	ETF	225.43	225.43	225.42	225.42	5530.0
2016-12-19 07:25:00	SPY	ETF	225.43	225.43	225.4	225.43	8819.0
2016-12-19 07:30:00	SPY	ETF	225.43	225.44	225.43	225.44	3767.0
2016-12-19 07:35:00	SPY	ETF	225.48	225.49	225.48	225.49	14546.0
2016-12-19 07:40:00	SPY	ETF	225.48	225.51	225.48	225.48	20900.0
2016-12-19 07:45:00	SPY	ETF	225.51	225.51	225.5	225.51	4650.0
2016-12-19 07:50:00	SPY	ETF	225.5	225.51	225.5	225.5	11819.0
2016-12-19 07:55:00	SPY	ETF	225.5	225.5	225.48	225.5	4001.0
2016-12-19 08:00:00	SPY	ETF	225.63	225.63	225.04	225.48	7142121.0
2016-12-19 08:05:00	SPY	ETF	225.48	225.48	225.45	225.48	20161.0
2016-12-19 08:10:00	SPY	ETF	225.45	225.46	225.41	225.41	6034.0
2016-12-19 08:15:00	SPY	ETF	225.4	225.4	225.33	225.33	39503.0
2016-12-19 08:20:00	SPY	ETF	225.33	225.36	225.32	225.32	11229.0
2016-12-19 08:25:00	SPY	ETF	225.34	225.38	225.32	225.35	3919.0
2016-12-19 08:30:00	SPY	ETF	225.35	225.38	225.34	225.35	4200.0
2016-12-19 08:35:00	SPY	ETF	225.36	225.4	225.36	225.4	31373.0
2016-12-19 08:40:00	SPY	ETF	225.43	225.43	225.31	225.33	13200.0
2016-12-19 08:45:00	SPY	ETF	225.33	225.33	225.29	225.3	18282.0
2016-12-19 08:50:00	SPY	ETF	225.3	225.3	225.28	225.3	27283.0
2016-12-19 08:55:00	SPY	ETF	225.29	225.31	225.28	225.31	21086.0
2016-12-19 09:00:00	SPY	ETF	225.32	225.39	225.32	225.36	55478.0
2016-12-19 09:05:00	SPY	ETF	225.36	225.39	225.35	225.38	9842.0
2016-12-19 09:10:00	SPY	ETF	225.38	225.39	225.32	225.32	14956.0
2016-12-19 09:15:00	SPY	ETF	225.32	225.32	225.29	225.29	22758.0
2016-12-19 09:20:00	SPY	ETF	225.29	225.32	225.26	225.32	21939.0
2016-12-19 09:25:00	SPY	ETF	225.32	225.32	225.25	225.27	68459.0
2016-12-19 09:30:00	SPY	ETF	225.25	225.33	225.15	225.18	2257662.0
2016-12-19 09:35:00	SPY	ETF	225.18	225.28	225.08	225.259	1210585.0
2016-12-19 09:40:00	SPY	ETF	225.25	225.59	225.2	225.5199	1405843.0
2016-12-19 09:45:00	SPY	ETF	225.51	225.77	225.51	225.7311	1079345.0
2016-12-19 09:50:00	SPY	ETF	225.73	225.75	225.54	225.57	794932.0

> showing 50 of 55,577 rows — these rows as CSV

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