PREVIEW / etf_5min / 2013-10-07

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-10-07.parquet
  size:    929 KB
  rows:    39,513

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-10-07 04:00:00	SPY	ETF	167.41	167.41	167.19	167.22	17590.0
2013-10-07 04:05:00	SPY	ETF	167.24	167.32	167.22	167.22	27800.0
2013-10-07 04:10:00	SPY	ETF	167.26	167.3	167.23	167.28	3900.0
2013-10-07 04:15:00	SPY	ETF	167.28	167.29	167.23	167.27	4300.0
2013-10-07 04:20:00	SPY	ETF	167.27	167.32	167.26	167.26	2900.0
2013-10-07 04:25:00	SPY	ETF	167.26	167.26	167.21	167.23	4500.0
2013-10-07 04:30:00	SPY	ETF	167.23	167.23	167.18	167.18	4100.0
2013-10-07 04:35:00	SPY	ETF	167.18	167.23	167.18	167.21	13800.0
2013-10-07 04:40:00	SPY	ETF	167.19	167.23	167.16	167.17	34963.0
2013-10-07 04:45:00	SPY	ETF	167.19	167.23	167.18	167.2	21150.0
2013-10-07 04:50:00	SPY	ETF	167.22	167.28	167.22	167.26	30745.0
2013-10-07 04:55:00	SPY	ETF	167.28	167.3	167.28	167.3	300.0
2013-10-07 05:00:00	SPY	ETF	167.32	167.35	167.32	167.35	10500.0
2013-10-07 05:05:00	SPY	ETF	167.32	167.32	167.26	167.28	800.0
2013-10-07 05:10:00	SPY	ETF	167.26	167.26	167.24	167.25	6200.0
2013-10-07 05:15:00	SPY	ETF	167.24	167.24	167.24	167.24	200.0
2013-10-07 05:20:00	SPY	ETF	167.25	167.25	167.2	167.2	700.0
2013-10-07 05:25:00	SPY	ETF	167.22	167.26	167.22	167.26	500.0
2013-10-07 05:30:00	SPY	ETF	167.26	167.3	167.26	167.3	1300.0
2013-10-07 05:35:00	SPY	ETF	167.3	167.3	167.3	167.3	1000.0
2013-10-07 05:40:00	SPY	ETF	167.32	167.4	167.32	167.4	1100.0
2013-10-07 05:45:00	SPY	ETF	167.38	167.42	167.38	167.38	2199.0
2013-10-07 05:50:00	SPY	ETF	167.4	167.44	167.4	167.44	699.0
2013-10-07 05:55:00	SPY	ETF	167.45	167.45	167.45	167.45	200.0
2013-10-07 06:00:00	SPY	ETF	167.45	167.45	167.4	167.4	566.0
2013-10-07 06:05:00	SPY	ETF	167.42	167.42	167.4	167.4	300.0
2013-10-07 06:10:00	SPY	ETF	167.38	167.38	167.36	167.36	900.0
2013-10-07 06:15:00	SPY	ETF	167.35	167.35	167.32	167.32	5300.0
2013-10-07 06:25:00	SPY	ETF	167.34	167.35	167.34	167.35	500.0
2013-10-07 06:30:00	SPY	ETF	167.32	167.36	167.32	167.36	1100.0
2013-10-07 06:35:00	SPY	ETF	167.36	167.37	167.34	167.37	10622.0
2013-10-07 06:40:00	SPY	ETF	167.38	167.42	167.38	167.42	1636.0
2013-10-07 06:45:00	SPY	ETF	167.42	167.42	167.4	167.4	46795.0
2013-10-07 06:50:00	SPY	ETF	167.39	167.4	167.36	167.4	45702.0
2013-10-07 06:55:00	SPY	ETF	167.4	167.4	167.37	167.39	11800.0
2013-10-07 07:00:00	SPY	ETF	167.42	167.43	167.4	167.43	62400.0
2013-10-07 07:05:00	SPY	ETF	167.42	167.46	167.42	167.46	43655.0
2013-10-07 07:10:00	SPY	ETF	167.44	167.44	167.37	167.38	33400.0
2013-10-07 07:15:00	SPY	ETF	167.38	167.42	167.38	167.42	25368.0
2013-10-07 07:20:00	SPY	ETF	167.41	167.41	167.35	167.37	16600.0
2013-10-07 07:25:00	SPY	ETF	167.38	167.4	167.34	167.36	25080.0
2013-10-07 07:30:00	SPY	ETF	167.36	167.48	167.36	167.48	26053.0
2013-10-07 07:35:00	SPY	ETF	167.46	167.5	167.46	167.5	98800.0
2013-10-07 07:40:00	SPY	ETF	167.5	167.52	167.46	167.52	60830.0
2013-10-07 07:45:00	SPY	ETF	167.52	167.6	167.5	167.58	20050.0
2013-10-07 07:50:00	SPY	ETF	167.59	167.61	167.59	167.61	21250.0
2013-10-07 07:55:00	SPY	ETF	167.61	167.62	167.56	167.57	37390.0
2013-10-07 08:00:00	SPY	ETF	167.56	167.59	167.35	167.5	150979.0
2013-10-07 08:05:00	SPY	ETF	167.5	167.58	167.5	167.55	122414.0
2013-10-07 08:10:00	SPY	ETF	167.56	168.08	167.56	167.59	64535.0

> showing 50 of 39,513 rows — these rows as CSV

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