PREVIEW / etf_5min / 2017-04-26

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-04-26.parquet
  size:    1.3 MB
  rows:    54,883

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
2017-04-26 04:00:00	SPY	ETF	238.47	238.47	238.41	238.41	1050.0
2017-04-26 04:10:00	SPY	ETF	238.42	238.42	238.42	238.42	800.0
2017-04-26 04:15:00	SPY	ETF	238.38	238.38	238.38	238.38	500.0
2017-04-26 04:20:00	SPY	ETF	238.41	238.47	238.41	238.43	1800.0
2017-04-26 04:25:00	SPY	ETF	238.42	238.42	238.38	238.38	1700.0
2017-04-26 04:40:00	SPY	ETF	238.4	238.4	238.4	238.4	100.0
2017-04-26 04:45:00	SPY	ETF	238.42	238.42	238.41	238.42	1300.0
2017-04-26 04:50:00	SPY	ETF	238.49	238.49	238.49	238.49	400.0
2017-04-26 05:00:00	SPY	ETF	238.46	238.46	238.43	238.43	400.0
2017-04-26 05:05:00	SPY	ETF	238.49	238.49	238.49	238.49	1100.0
2017-04-26 05:15:00	SPY	ETF	238.49	238.49	238.46	238.46	1500.0
2017-04-26 05:20:00	SPY	ETF	238.49	238.49	238.49	238.49	100.0
2017-04-26 05:30:00	SPY	ETF	238.49	238.49	238.48	238.48	2500.0
2017-04-26 05:35:00	SPY	ETF	238.49	238.5	238.49	238.5	3000.0
2017-04-26 05:45:00	SPY	ETF	238.56	238.62	238.56	238.62	2765.0
2017-04-26 05:50:00	SPY	ETF	238.64	238.65	238.63	238.65	1900.0
2017-04-26 06:00:00	SPY	ETF	238.67	238.72	238.67	238.72	500.0
2017-04-26 06:10:00	SPY	ETF	238.65	238.65	238.65	238.65	100.0
2017-04-26 06:20:00	SPY	ETF	238.56	238.56	238.56	238.56	400.0
2017-04-26 06:25:00	SPY	ETF	238.65	238.65	238.56	238.56	2500.0
2017-04-26 06:35:00	SPY	ETF	238.58	238.58	238.53	238.53	1500.0
2017-04-26 06:40:00	SPY	ETF	238.53	238.53	238.53	238.53	2147.0
2017-04-26 07:00:00	SPY	ETF	238.41	238.41	238.4	238.41	26500.0
2017-04-26 07:05:00	SPY	ETF	238.41	238.42	238.4	238.41	8186.0
2017-04-26 07:10:00	SPY	ETF	238.4	238.44	238.4	238.44	6167.0
2017-04-26 07:15:00	SPY	ETF	238.4	238.41	238.4	238.41	767.0
2017-04-26 07:20:00	SPY	ETF	238.44	238.45	238.44	238.45	2967.0
2017-04-26 07:25:00	SPY	ETF	238.45	238.45	238.32	238.32	17793.0
2017-04-26 07:30:00	SPY	ETF	238.32	238.44	238.3	238.44	2246.0
2017-04-26 07:35:00	SPY	ETF	238.47	238.47	238.45	238.45	2663.0
2017-04-26 07:40:00	SPY	ETF	238.46	238.48	238.46	238.48	24971.0
2017-04-26 07:45:00	SPY	ETF	238.46	238.48	238.4	238.4	3683.0
2017-04-26 07:50:00	SPY	ETF	238.41	238.41	238.34	238.37	20189.0
2017-04-26 07:55:00	SPY	ETF	238.4	238.4	238.33	238.35	29262.0
2017-04-26 08:00:00	SPY	ETF	238.43	238.44	238.29	238.44	15068.0
2017-04-26 08:05:00	SPY	ETF	238.4	238.4	238.4	238.4	987.0
2017-04-26 08:10:00	SPY	ETF	238.41	238.42	238.41	238.42	5620.0
2017-04-26 08:15:00	SPY	ETF	238.44	238.48	238.44	238.48	10337.0
2017-04-26 08:20:00	SPY	ETF	238.48	238.48	238.37	238.37	11698.0
2017-04-26 08:25:00	SPY	ETF	238.38	238.43	238.37	238.38	31438.0
2017-04-26 08:30:00	SPY	ETF	238.38	238.6	238.38	238.56	57892.0
2017-04-26 08:35:00	SPY	ETF	238.56	238.71	238.56	238.65	48871.0
2017-04-26 08:40:00	SPY	ETF	238.66	238.68	238.6	238.6	64335.0
2017-04-26 08:45:00	SPY	ETF	238.59	238.63	238.57	238.63	15828.0
2017-04-26 08:50:00	SPY	ETF	238.63	238.63	238.49	238.54	32952.0
2017-04-26 08:55:00	SPY	ETF	238.55	238.63	238.54	238.63	16529.0
2017-04-26 09:00:00	SPY	ETF	238.63	238.64	238.52	238.6	398463.0
2017-04-26 09:05:00	SPY	ETF	238.6	238.61	238.55	238.55	8922.0
2017-04-26 09:10:00	SPY	ETF	238.57	238.62	238.53	238.55	9426.0
2017-04-26 09:15:00	SPY	ETF	238.54	238.59	238.54	238.55	18669.0

> showing 50 of 54,883 rows — these rows as CSV

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