PREVIEW / etf_5min / 2017-06-07

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-06-07.parquet
  size:    1.2 MB
  rows:    52,663

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-06-07 04:00:00	SPY	ETF	243.5	243.5	243.5	243.5	2396.0
2017-06-07 04:25:00	SPY	ETF	243.33	243.33	243.33	243.33	100.0
2017-06-07 05:05:00	SPY	ETF	243.41	243.41	243.41	243.41	400.0
2017-06-07 05:10:00	SPY	ETF	243.41	243.41	243.41	243.41	400.0
2017-06-07 05:30:00	SPY	ETF	243.42	243.42	243.41	243.41	400.0
2017-06-07 06:10:00	SPY	ETF	243.54	243.54	243.53	243.53	200.0
2017-06-07 06:15:00	SPY	ETF	243.6	243.61	243.6	243.61	1010.0
2017-06-07 06:20:00	SPY	ETF	243.61	243.61	243.61	243.61	600.0
2017-06-07 06:25:00	SPY	ETF	243.58	243.6	243.58	243.6	4500.0
2017-06-07 06:30:00	SPY	ETF	243.59	243.59	243.59	243.59	1000.0
2017-06-07 06:35:00	SPY	ETF	243.62	243.66	243.62	243.66	5100.0
2017-06-07 06:40:00	SPY	ETF	243.64	243.64	243.6	243.6	6000.0
2017-06-07 06:45:00	SPY	ETF	243.57	243.57	243.57	243.57	500.0
2017-06-07 06:55:00	SPY	ETF	243.48	243.48	243.48	243.48	740.0
2017-06-07 07:00:00	SPY	ETF	243.54	243.56	243.54	243.56	1169.0
2017-06-07 07:05:00	SPY	ETF	243.56	243.56	243.54	243.56	10664.0
2017-06-07 07:10:00	SPY	ETF	243.56	243.56	243.52	243.52	11369.0
2017-06-07 07:20:00	SPY	ETF	243.55	243.57	243.55	243.56	2469.0
2017-06-07 07:25:00	SPY	ETF	243.56	243.56	243.52	243.54	7569.0
2017-06-07 07:30:00	SPY	ETF	243.53	243.53	243.52	243.52	1055.0
2017-06-07 07:35:00	SPY	ETF	243.51	243.51	243.46	243.46	8583.0
2017-06-07 07:40:00	SPY	ETF	243.47	243.47	243.47	243.47	5000.0
2017-06-07 07:45:00	SPY	ETF	243.51	243.57	243.51	243.57	4107.0
2017-06-07 07:50:00	SPY	ETF	243.57	243.67	243.57	243.67	25845.0
2017-06-07 07:55:00	SPY	ETF	243.64	243.67	243.62	243.67	29950.0
2017-06-07 08:00:00	SPY	ETF	243.5	243.71	243.5	243.69	3385.0
2017-06-07 08:05:00	SPY	ETF	243.65	243.65	243.63	243.64	4807.0
2017-06-07 08:10:00	SPY	ETF	243.65	243.67	243.65	243.67	4168.0
2017-06-07 08:15:00	SPY	ETF	243.63	243.65	243.58	243.59	25626.0
2017-06-07 08:20:00	SPY	ETF	243.58	243.59	243.57	243.59	7051.0
2017-06-07 08:25:00	SPY	ETF	243.59	243.61	243.58	243.61	5300.0
2017-06-07 08:30:00	SPY	ETF	243.61	243.61	243.59	243.6	9583.0
2017-06-07 08:35:00	SPY	ETF	243.59	243.59	243.56	243.57	3401.0
2017-06-07 08:40:00	SPY	ETF	243.56	243.58	243.54	243.58	9229.0
2017-06-07 08:45:00	SPY	ETF	243.58	243.61	243.58	243.59	3488.0
2017-06-07 08:50:00	SPY	ETF	243.59	243.61	243.57	243.61	6962.0
2017-06-07 08:55:00	SPY	ETF	243.61	243.62	243.61	243.62	5319.0
2017-06-07 09:00:00	SPY	ETF	243.61	243.65	243.61	243.65	107373.0
2017-06-07 09:05:00	SPY	ETF	243.65	243.71	243.65	243.7	149237.0
2017-06-07 09:10:00	SPY	ETF	243.68	243.7	243.65	243.65	13005.0
2017-06-07 09:15:00	SPY	ETF	243.65	243.66	243.59	243.61	47047.0
2017-06-07 09:20:00	SPY	ETF	243.61	243.64	243.6	243.64	10435.0
2017-06-07 09:25:00	SPY	ETF	243.64	243.67	243.58	243.58	88696.0
2017-06-07 09:30:00	SPY	ETF	243.6	243.66	243.49	243.5301	1028979.0
2017-06-07 09:35:00	SPY	ETF	243.54	243.76	243.5	243.7259	693198.0
2017-06-07 09:40:00	SPY	ETF	243.72	243.79	243.67	243.71	653740.0
2017-06-07 09:45:00	SPY	ETF	243.7101	243.77	243.66	243.68	371683.0
2017-06-07 09:50:00	SPY	ETF	243.68	243.7	243.48	243.65	816723.0
2017-06-07 09:55:00	SPY	ETF	243.66	243.75	243.64	243.735	616168.0
2017-06-07 10:00:00	SPY	ETF	243.735	243.8555	243.73	243.79	539711.0

> showing 50 of 52,663 rows — these rows as CSV

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