PREVIEW / etf_5min / 2014-10-29

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-29.parquet
  size:    1.1 MB
  rows:    46,818

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
2014-10-29 04:00:00	SPY	ETF	198.44	198.52	198.44	198.51	426.0
2014-10-29 04:05:00	SPY	ETF	198.51	198.51	198.46	198.46	300.0
2014-10-29 04:10:00	SPY	ETF	198.43	198.58	198.43	198.58	1300.0
2014-10-29 04:30:00	SPY	ETF	198.4	198.4	198.32	198.32	200.0
2014-10-29 04:35:00	SPY	ETF	198.25	198.43	198.24	198.43	680.0
2014-10-29 04:40:00	SPY	ETF	198.41	198.41	198.41	198.41	200.0
2014-10-29 04:45:00	SPY	ETF	198.4	198.4	198.36	198.36	10200.0
2014-10-29 04:50:00	SPY	ETF	198.43	198.43	198.42	198.42	425.0
2014-10-29 05:00:00	SPY	ETF	198.35	198.44	198.34	198.44	479.0
2014-10-29 05:05:00	SPY	ETF	198.44	198.44	198.44	198.44	5300.0
2014-10-29 05:15:00	SPY	ETF	198.49	198.51	198.48	198.48	5238.0
2014-10-29 05:20:00	SPY	ETF	198.45	198.49	198.45	198.49	608.0
2014-10-29 05:30:00	SPY	ETF	198.55	198.61	198.55	198.57	1935.0
2014-10-29 05:35:00	SPY	ETF	198.61	198.67	198.61	198.67	2990.0
2014-10-29 05:45:00	SPY	ETF	198.67	198.72	198.63	198.63	3801.0
2014-10-29 05:55:00	SPY	ETF	198.62	198.62	198.57	198.57	1169.0
2014-10-29 06:00:00	SPY	ETF	198.54	198.54	198.5	198.53	18400.0
2014-10-29 06:05:00	SPY	ETF	198.52	198.52	198.43	198.43	1800.0
2014-10-29 06:10:00	SPY	ETF	198.41	198.42	198.41	198.42	960.0
2014-10-29 06:15:00	SPY	ETF	198.39	198.39	198.39	198.39	500.0
2014-10-29 06:20:00	SPY	ETF	198.42	198.42	198.42	198.42	100.0
2014-10-29 06:25:00	SPY	ETF	198.41	198.41	198.39	198.4	2356.0
2014-10-29 06:30:00	SPY	ETF	198.48	198.54	198.48	198.5	1725.0
2014-10-29 06:35:00	SPY	ETF	198.5	198.5	198.45	198.48	6281.0
2014-10-29 06:40:00	SPY	ETF	198.39	198.43	198.35	198.37	4474.0
2014-10-29 06:45:00	SPY	ETF	198.36	198.36	198.28	198.28	10687.0
2014-10-29 06:50:00	SPY	ETF	198.28	198.29	198.27	198.28	103752.0
2014-10-29 06:55:00	SPY	ETF	198.29	198.29	198.21	198.21	12509.0
2014-10-29 07:00:00	SPY	ETF	198.27	198.27	198.22	198.24	29202.0
2014-10-29 07:05:00	SPY	ETF	198.22	198.24	198.18	198.21	25781.0
2014-10-29 07:10:00	SPY	ETF	198.21	198.32	198.21	198.31	23018.0
2014-10-29 07:15:00	SPY	ETF	198.3	198.3	198.21	198.24	14717.0
2014-10-29 07:20:00	SPY	ETF	198.21	198.21	198.18	198.18	4000.0
2014-10-29 07:25:00	SPY	ETF	198.2	198.22	198.18	198.18	3101.0
2014-10-29 07:30:00	SPY	ETF	198.17	198.19	198.14	198.14	16430.0
2014-10-29 07:35:00	SPY	ETF	198.17	198.19	198.08	198.11	19396.0
2014-10-29 07:40:00	SPY	ETF	198.11	198.22	198.11	198.2	26900.0
2014-10-29 07:45:00	SPY	ETF	198.19	198.26	198.19	198.25	5690.0
2014-10-29 07:50:00	SPY	ETF	198.27	198.29	198.26	198.27	33620.0
2014-10-29 07:55:00	SPY	ETF	198.29	198.3	198.22	198.3	43910.0
2014-10-29 08:00:00	SPY	ETF	198.29	198.33	198.11	198.24	77938.0
2014-10-29 08:05:00	SPY	ETF	198.24	198.29	198.23	198.27	14269.0
2014-10-29 08:10:00	SPY	ETF	198.27	198.38	198.26	198.38	64370.0
2014-10-29 08:15:00	SPY	ETF	198.37	198.41	198.35	198.36	107540.0
2014-10-29 08:20:00	SPY	ETF	198.36	198.4	198.29	198.4	91535.0
2014-10-29 08:25:00	SPY	ETF	198.39	198.43	198.36	198.43	14575.0
2014-10-29 08:30:00	SPY	ETF	198.44	198.46	198.4	198.42	80745.0
2014-10-29 08:35:00	SPY	ETF	198.42	198.43	198.38	198.4	47942.0
2014-10-29 08:40:00	SPY	ETF	198.4	198.43	198.34	198.4	97568.0
2014-10-29 08:45:00	SPY	ETF	198.4	198.42	198.4	198.4	7293.0

> showing 50 of 46,818 rows — these rows as CSV

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