PREVIEW / etf_5min / 2014-03-07

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-03-07.parquet
  size:    1011 KB
  rows:    43,142

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-03-07 04:05:00	SPY	ETF	188.11	188.11	188.1	188.1	472.0
2014-03-07 04:10:00	SPY	ETF	188.14	188.15	188.14	188.15	5300.0
2014-03-07 04:15:00	SPY	ETF	188.22	188.22	188.13	188.13	6105.0
2014-03-07 04:20:00	SPY	ETF	188.13	188.13	188.13	188.13	1054.0
2014-03-07 04:25:00	SPY	ETF	188.13	188.19	188.13	188.19	1197.0
2014-03-07 04:30:00	SPY	ETF	188.17	188.22	188.16	188.22	550.0
2014-03-07 04:35:00	SPY	ETF	188.23	188.28	188.23	188.24	708.0
2014-03-07 04:45:00	SPY	ETF	188.25	188.26	188.25	188.26	600.0
2014-03-07 04:50:00	SPY	ETF	188.28	188.28	188.28	188.28	200.0
2014-03-07 04:55:00	SPY	ETF	188.27	188.29	188.27	188.29	343.0
2014-03-07 05:00:00	SPY	ETF	188.24	188.24	188.24	188.24	200.0
2014-03-07 05:05:00	SPY	ETF	188.25	188.25	188.2	188.2	4400.0
2014-03-07 05:10:00	SPY	ETF	188.2	188.2	188.2	188.2	647.0
2014-03-07 05:20:00	SPY	ETF	188.19	188.2	188.19	188.2	2000.0
2014-03-07 05:25:00	SPY	ETF	188.22	188.22	188.2	188.2	300.0
2014-03-07 05:30:00	SPY	ETF	188.2	188.26	188.2	188.26	592.0
2014-03-07 05:35:00	SPY	ETF	188.24	188.24	188.24	188.24	315.0
2014-03-07 05:45:00	SPY	ETF	188.28	188.28	188.28	188.28	196.0
2014-03-07 05:50:00	SPY	ETF	188.24	188.24	188.24	188.24	200.0
2014-03-07 06:00:00	SPY	ETF	188.26	188.26	188.22	188.22	395.0
2014-03-07 06:10:00	SPY	ETF	188.26	188.26	188.26	188.26	227.0
2014-03-07 06:15:00	SPY	ETF	188.3	188.33	188.3	188.3	968.0
2014-03-07 06:20:00	SPY	ETF	188.26	188.26	188.26	188.26	172.0
2014-03-07 06:25:00	SPY	ETF	188.32	188.48	188.32	188.42	5417.0
2014-03-07 06:30:00	SPY	ETF	188.45	188.45	188.4	188.42	2000.0
2014-03-07 06:35:00	SPY	ETF	188.42	188.43	188.33	188.35	2670.0
2014-03-07 06:40:00	SPY	ETF	188.32	188.32	188.25	188.32	2951.0
2014-03-07 06:45:00	SPY	ETF	188.32	188.35	188.32	188.34	1600.0
2014-03-07 06:50:00	SPY	ETF	188.36	188.36	188.33	188.33	600.0
2014-03-07 06:55:00	SPY	ETF	188.33	188.33	188.3	188.3	400.0
2014-03-07 07:00:00	SPY	ETF	188.31	188.32	188.24	188.24	5485.0
2014-03-07 07:05:00	SPY	ETF	188.24	188.26	188.22	188.23	31034.0
2014-03-07 07:10:00	SPY	ETF	188.23	188.26	188.22	188.26	3200.0
2014-03-07 07:15:00	SPY	ETF	188.27	188.27	188.27	188.27	900.0
2014-03-07 07:20:00	SPY	ETF	188.28	188.28	188.23	188.26	10873.0
2014-03-07 07:25:00	SPY	ETF	188.29	188.31	188.25	188.31	93346.0
2014-03-07 07:30:00	SPY	ETF	188.25	188.27	188.25	188.27	10500.0
2014-03-07 07:35:00	SPY	ETF	188.3	188.33	188.3	188.33	26377.0
2014-03-07 07:40:00	SPY	ETF	188.35	188.35	188.33	188.33	971.0
2014-03-07 07:45:00	SPY	ETF	188.32	188.32	188.27	188.3	3250.0
2014-03-07 07:50:00	SPY	ETF	188.32	188.34	188.32	188.34	700.0
2014-03-07 07:55:00	SPY	ETF	188.35	188.38	188.27	188.28	12031.0
2014-03-07 08:00:00	SPY	ETF	188.3	188.33	188.22	188.29	20523.0
2014-03-07 08:05:00	SPY	ETF	188.3	188.31	188.3	188.3	22167.0
2014-03-07 08:10:00	SPY	ETF	188.3	188.35	188.27	188.35	69479.0
2014-03-07 08:15:00	SPY	ETF	188.35	188.35	188.21	188.27	196348.0
2014-03-07 08:20:00	SPY	ETF	188.26	188.28	188.22	188.27	61448.0
2014-03-07 08:25:00	SPY	ETF	188.28	188.41	188.23	188.37	211424.0
2014-03-07 08:30:00	SPY	ETF	188.42	189.12	188.42	188.96	2067832.0
2014-03-07 08:35:00	SPY	ETF	188.94	189.09	188.85	189.075	502951.0

> showing 50 of 43,142 rows — these rows as CSV

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