PREVIEW / etf_5min / 2017-04-21

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-04-21.parquet
  size:    1.2 MB
  rows:    51,880

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-21 04:00:00	SPY	ETF	235.45	235.45	235.45	235.45	154.0
2017-04-21 04:20:00	SPY	ETF	235.54	235.54	235.54	235.54	200.0
2017-04-21 04:30:00	SPY	ETF	235.44	235.44	235.44	235.44	401.0
2017-04-21 04:40:00	SPY	ETF	235.46	235.46	235.43	235.43	600.0
2017-04-21 04:45:00	SPY	ETF	235.36	235.36	235.36	235.36	100.0
2017-04-21 04:50:00	SPY	ETF	235.45	235.45	235.45	235.45	100.0
2017-04-21 05:00:00	SPY	ETF	235.35	235.35	235.35	235.35	100.0
2017-04-21 05:10:00	SPY	ETF	235.32	235.32	235.32	235.32	203.0
2017-04-21 05:40:00	SPY	ETF	235.37	235.37	235.36	235.36	1302.0
2017-04-21 05:50:00	SPY	ETF	235.47	235.47	235.46	235.46	302.0
2017-04-21 06:00:00	SPY	ETF	235.46	235.46	235.45	235.45	200.0
2017-04-21 06:05:00	SPY	ETF	235.43	235.43	235.39	235.39	500.0
2017-04-21 06:15:00	SPY	ETF	235.42	235.42	235.42	235.42	200.0
2017-04-21 06:25:00	SPY	ETF	235.47	235.47	235.47	235.47	100.0
2017-04-21 06:30:00	SPY	ETF	235.4	235.4	235.31	235.31	2353.0
2017-04-21 06:35:00	SPY	ETF	235.4	235.4	235.4	235.4	101.0
2017-04-21 06:45:00	SPY	ETF	235.4	235.4	235.4	235.4	2500.0
2017-04-21 06:50:00	SPY	ETF	235.4	235.4	235.4	235.4	100.0
2017-04-21 06:55:00	SPY	ETF	235.44	235.44	235.44	235.44	100.0
2017-04-21 07:00:00	SPY	ETF	235.48	235.49	235.48	235.49	302.0
2017-04-21 07:05:00	SPY	ETF	235.53	235.57	235.51	235.51	8158.0
2017-04-21 07:10:00	SPY	ETF	235.56	235.61	235.56	235.57	5801.0
2017-04-21 07:15:00	SPY	ETF	235.6	235.6	235.5	235.52	3661.0
2017-04-21 07:20:00	SPY	ETF	235.57	235.57	235.52	235.52	2638.0
2017-04-21 07:25:00	SPY	ETF	235.49	235.55	235.49	235.54	1482.0
2017-04-21 07:30:00	SPY	ETF	235.54	235.54	235.54	235.54	201.0
2017-04-21 07:35:00	SPY	ETF	235.55	235.55	235.52	235.52	402.0
2017-04-21 07:40:00	SPY	ETF	235.52	235.52	235.5	235.5	1167.0
2017-04-21 07:45:00	SPY	ETF	235.5	235.53	235.5	235.53	500.0
2017-04-21 07:50:00	SPY	ETF	235.55	235.55	235.53	235.53	3140.0
2017-04-21 07:55:00	SPY	ETF	235.52	235.52	235.49	235.49	2669.0
2017-04-21 08:00:00	SPY	ETF	235.55	235.6	235.46	235.48	20342.0
2017-04-21 08:05:00	SPY	ETF	235.49	235.51	235.49	235.51	15302.0
2017-04-21 08:10:00	SPY	ETF	235.51	235.52	235.51	235.51	5450.0
2017-04-21 08:15:00	SPY	ETF	235.51	235.55	235.51	235.55	3996.0
2017-04-21 08:20:00	SPY	ETF	235.57	235.58	235.41	235.43	37843.0
2017-04-21 08:25:00	SPY	ETF	235.44	235.48	235.43	235.48	5961.0
2017-04-21 08:30:00	SPY	ETF	235.48	235.54	235.48	235.54	70148.0
2017-04-21 08:35:00	SPY	ETF	235.55	235.56	235.49	235.5	26512.0
2017-04-21 08:40:00	SPY	ETF	235.49	235.51	235.48	235.51	5914.0
2017-04-21 08:45:00	SPY	ETF	235.5	235.54	235.5	235.52	36253.0
2017-04-21 08:50:00	SPY	ETF	235.51	235.51	235.45	235.48	10798.0
2017-04-21 08:55:00	SPY	ETF	235.47	235.49	235.44	235.44	6304.0
2017-04-21 09:00:00	SPY	ETF	235.44	235.44	235.36	235.37	42969.0
2017-04-21 09:05:00	SPY	ETF	235.39	235.41	235.32	235.34	33544.0
2017-04-21 09:10:00	SPY	ETF	235.34	235.4	235.31	235.34	33869.0
2017-04-21 09:15:00	SPY	ETF	235.33	235.33	235.28	235.28	58520.0
2017-04-21 09:20:00	SPY	ETF	235.27	235.34	235.25	235.31	24883.0
2017-04-21 09:25:00	SPY	ETF	235.31	235.33	235.15	235.26	318618.0
2017-04-21 09:30:00	SPY	ETF	235.25	235.31	235.05	235.09	2518070.0

> showing 50 of 51,880 rows — these rows as CSV

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