PREVIEW / etf_5min / 2013-05-06

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-05-06.parquet
  size:    944 KB
  rows:    40,968

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
2013-05-06 04:00:00	SPY	ETF	161.37	161.46	161.37	161.46	800.0
2013-05-06 04:05:00	SPY	ETF	161.51	161.51	161.51	161.51	100.0
2013-05-06 04:35:00	SPY	ETF	161.52	161.52	161.52	161.52	300.0
2013-05-06 05:10:00	SPY	ETF	161.51	161.51	161.51	161.51	500.0
2013-05-06 05:15:00	SPY	ETF	161.46	161.46	161.46	161.46	300.0
2013-05-06 05:20:00	SPY	ETF	161.43	161.43	161.43	161.43	1500.0
2013-05-06 05:40:00	SPY	ETF	161.36	161.36	161.36	161.36	100.0
2013-05-06 05:55:00	SPY	ETF	161.38	161.38	161.38	161.38	299.0
2013-05-06 06:10:00	SPY	ETF	161.33	161.4	161.33	161.4	3200.0
2013-05-06 06:30:00	SPY	ETF	161.39	161.39	161.39	161.39	100.0
2013-05-06 06:40:00	SPY	ETF	161.29	161.29	161.29	161.29	100.0
2013-05-06 06:45:00	SPY	ETF	161.27	161.27	161.27	161.27	500.0
2013-05-06 06:50:00	SPY	ETF	161.26	161.26	161.25	161.26	8100.0
2013-05-06 06:55:00	SPY	ETF	161.23	161.27	161.2	161.27	7299.0
2013-05-06 07:00:00	SPY	ETF	161.23	161.25	161.23	161.25	3700.0
2013-05-06 07:10:00	SPY	ETF	161.27	161.29	161.26	161.26	2300.0
2013-05-06 07:15:00	SPY	ETF	161.26	161.26	161.25	161.25	1585.0
2013-05-06 07:20:00	SPY	ETF	161.29	161.29	161.28	161.29	12000.0
2013-05-06 07:25:00	SPY	ETF	161.29	161.31	161.28	161.31	2900.0
2013-05-06 07:30:00	SPY	ETF	161.31	161.31	161.31	161.31	7500.0
2013-05-06 07:35:00	SPY	ETF	161.3	161.3	161.25	161.27	63000.0
2013-05-06 07:40:00	SPY	ETF	161.27	161.27	161.22	161.24	14092.0
2013-05-06 07:45:00	SPY	ETF	161.24	161.27	161.24	161.27	8400.0
2013-05-06 07:50:00	SPY	ETF	161.3	161.31	161.27	161.31	24800.0
2013-05-06 07:55:00	SPY	ETF	161.31	161.31	161.3	161.3	500.0
2013-05-06 08:00:00	SPY	ETF	161.31	161.33	161.25	161.3	45606.0
2013-05-06 08:05:00	SPY	ETF	161.29	161.31	161.28	161.28	6220.0
2013-05-06 08:10:00	SPY	ETF	161.29	161.31	161.28	161.31	11800.0
2013-05-06 08:15:00	SPY	ETF	161.33	161.34	161.33	161.34	6400.0
2013-05-06 08:20:00	SPY	ETF	161.335	161.36	161.32	161.36	47301.0
2013-05-06 08:25:00	SPY	ETF	161.33	161.34	161.31	161.31	8800.0
2013-05-06 08:30:00	SPY	ETF	161.34	161.37	161.33	161.35	13790.0
2013-05-06 08:35:00	SPY	ETF	161.36	161.43	161.35	161.43	42323.0
2013-05-06 08:40:00	SPY	ETF	161.44	161.48	161.42	161.44	21600.0
2013-05-06 08:45:00	SPY	ETF	161.44	161.51	161.4	161.49	78196.0
2013-05-06 08:50:00	SPY	ETF	161.49	161.51	161.44	161.48	90972.0
2013-05-06 08:55:00	SPY	ETF	161.47	161.48	161.41	161.43	41775.0
2013-05-06 09:00:00	SPY	ETF	161.44	161.44	161.41	161.43	26405.0
2013-05-06 09:05:00	SPY	ETF	161.42	161.46	161.39	161.44	48690.0
2013-05-06 09:10:00	SPY	ETF	161.44	161.46	161.44	161.45	17105.0
2013-05-06 09:15:00	SPY	ETF	161.45	161.46	161.44	161.44	13055.0
2013-05-06 09:20:00	SPY	ETF	161.45	161.52	161.44	161.51	154346.0
2013-05-06 09:25:00	SPY	ETF	161.5	161.52	161.46	161.5	185184.0
2013-05-06 09:30:00	SPY	ETF	161.49	161.65	161.44	161.63	2453585.0
2013-05-06 09:35:00	SPY	ETF	161.63	161.72	161.58	161.65	1916109.0
2013-05-06 09:40:00	SPY	ETF	161.65	161.689	161.48	161.55	1571953.0
2013-05-06 09:45:00	SPY	ETF	161.55	161.56	161.44	161.495	1651143.0
2013-05-06 09:50:00	SPY	ETF	161.49	161.53	161.42	161.46	1169334.0
2013-05-06 09:55:00	SPY	ETF	161.45	161.5	161.42	161.48	438304.0
2013-05-06 10:00:00	SPY	ETF	161.48	161.57	161.47	161.51	1193467.0

> showing 50 of 40,968 rows — these rows as CSV

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