PREVIEW / etf_5min / 2014-07-21

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-21.parquet
  size:    980 KB
  rows:    41,612

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-07-21 04:00:00	SPY	ETF	197.51	197.51	197.14	197.17	24116.0
2014-07-21 04:05:00	SPY	ETF	197.17	197.17	197.17	197.17	349.0
2014-07-21 04:20:00	SPY	ETF	197.14	197.14	197.14	197.14	200.0
2014-07-21 04:25:00	SPY	ETF	197.23	197.24	197.13	197.13	8200.0
2014-07-21 04:30:00	SPY	ETF	197.13	197.17	197.13	197.17	3500.0
2014-07-21 04:35:00	SPY	ETF	197.21	197.21	197.13	197.17	6200.0
2014-07-21 04:40:00	SPY	ETF	197.18	197.24	197.18	197.24	1341.0
2014-07-21 04:45:00	SPY	ETF	197.32	197.32	197.27	197.27	237.0
2014-07-21 04:50:00	SPY	ETF	197.29	197.29	197.21	197.21	405.0
2014-07-21 04:55:00	SPY	ETF	197.2	197.21	197.2	197.21	1000.0
2014-07-21 05:00:00	SPY	ETF	197.25	197.25	197.25	197.25	1000.0
2014-07-21 05:05:00	SPY	ETF	197.3	197.32	197.3	197.32	200.0
2014-07-21 05:10:00	SPY	ETF	197.29	197.29	197.25	197.25	315.0
2014-07-21 05:30:00	SPY	ETF	197.4	197.4	197.4	197.4	100.0
2014-07-21 05:35:00	SPY	ETF	197.49	197.49	197.49	197.49	100.0
2014-07-21 05:45:00	SPY	ETF	197.49	197.49	197.48	197.48	10206.0
2014-07-21 05:50:00	SPY	ETF	197.4	197.4	197.4	197.4	100.0
2014-07-21 05:55:00	SPY	ETF	197.41	197.41	197.41	197.41	200.0
2014-07-21 06:05:00	SPY	ETF	197.32	197.32	197.3	197.31	787.0
2014-07-21 06:10:00	SPY	ETF	197.27	197.27	197.23	197.23	450.0
2014-07-21 06:15:00	SPY	ETF	197.3	197.3	197.29	197.29	200.0
2014-07-21 06:25:00	SPY	ETF	197.31	197.31	197.31	197.31	200.0
2014-07-21 06:30:00	SPY	ETF	197.34	197.39	197.34	197.37	5122.0
2014-07-21 06:35:00	SPY	ETF	197.39	197.4	197.39	197.4	6464.0
2014-07-21 06:40:00	SPY	ETF	197.39	197.39	197.36	197.36	1949.0
2014-07-21 06:45:00	SPY	ETF	197.35	197.37	197.27	197.36	19204.0
2014-07-21 06:50:00	SPY	ETF	197.26	197.26	197.2	197.25	20740.0
2014-07-21 06:55:00	SPY	ETF	197.21	197.22	197.13	197.13	46100.0
2014-07-21 07:00:00	SPY	ETF	197.19	197.22	197.17	197.18	47200.0
2014-07-21 07:05:00	SPY	ETF	197.18	197.18	197.15	197.16	12800.0
2014-07-21 07:10:00	SPY	ETF	197.18	197.18	197.14	197.15	5432.0
2014-07-21 07:15:00	SPY	ETF	197.15	197.23	197.15	197.23	33850.0
2014-07-21 07:20:00	SPY	ETF	197.24	197.3	197.24	197.3	15380.0
2014-07-21 07:25:00	SPY	ETF	197.3	197.31	197.27	197.27	5646.0
2014-07-21 07:30:00	SPY	ETF	197.27	197.27	197.22	197.24	3500.0
2014-07-21 07:35:00	SPY	ETF	197.28	197.28	197.25	197.26	6580.0
2014-07-21 07:40:00	SPY	ETF	197.26	197.26	197.2	197.22	30396.0
2014-07-21 07:45:00	SPY	ETF	197.2	197.21	197.2	197.2	6525.0
2014-07-21 07:50:00	SPY	ETF	197.2	197.21	197.18	197.18	4925.0
2014-07-21 07:55:00	SPY	ETF	197.22	197.25	197.22	197.22	12000.0
2014-07-21 08:00:00	SPY	ETF	197.22	197.31	197.18	197.26	50824.0
2014-07-21 08:05:00	SPY	ETF	197.24	197.61	197.21	197.25	59915.0
2014-07-21 08:10:00	SPY	ETF	197.25	197.25	197.17	197.2	63793.0
2014-07-21 08:15:00	SPY	ETF	197.2	197.3	197.18	197.27	31076.0
2014-07-21 08:20:00	SPY	ETF	197.27	197.29	197.19	197.2	42674.0
2014-07-21 08:25:00	SPY	ETF	197.21	197.26	197.21	197.25	39150.0
2014-07-21 08:30:00	SPY	ETF	197.23	197.23	197.2	197.23	13321.0
2014-07-21 08:35:00	SPY	ETF	197.23	197.24	197.17	197.17	23119.0
2014-07-21 08:40:00	SPY	ETF	197.18	197.26	197.18	197.25	15219.0
2014-07-21 08:45:00	SPY	ETF	197.255	197.26	197.22	197.24	21201.0

> showing 50 of 41,612 rows — these rows as CSV

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