PREVIEW / etf_5min / 2014-05-02

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-05-02.parquet
  size:    965 KB
  rows:    40,995

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-05-02 04:00:00	SPY	ETF	188.58	188.58	188.58	188.58	100.0
2014-05-02 04:10:00	SPY	ETF	188.5	188.5	188.5	188.5	150.0
2014-05-02 05:55:00	SPY	ETF	188.29	188.52	188.29	188.52	1844.0
2014-05-02 06:00:00	SPY	ETF	188.5	188.5	188.5	188.5	356.0
2014-05-02 06:15:00	SPY	ETF	188.53	188.53	188.53	188.53	500.0
2014-05-02 06:30:00	SPY	ETF	188.58	188.6	188.5	188.54	18202.0
2014-05-02 06:35:00	SPY	ETF	188.56	188.56	188.53	188.53	1300.0
2014-05-02 06:40:00	SPY	ETF	188.53	188.53	188.45	188.49	5118.0
2014-05-02 06:45:00	SPY	ETF	188.41	188.45	188.38	188.44	14245.0
2014-05-02 06:55:00	SPY	ETF	188.42	188.42	188.42	188.42	10010.0
2014-05-02 07:00:00	SPY	ETF	188.4	188.4	188.4	188.4	100.0
2014-05-02 07:05:00	SPY	ETF	188.43	188.46	188.43	188.46	1218.0
2014-05-02 07:10:00	SPY	ETF	188.46	188.54	188.46	188.54	36780.0
2014-05-02 07:15:00	SPY	ETF	188.48	188.48	188.48	188.48	700.0
2014-05-02 07:20:00	SPY	ETF	188.46	188.46	188.46	188.46	2500.0
2014-05-02 07:25:00	SPY	ETF	188.44	188.44	188.44	188.44	1000.0
2014-05-02 07:30:00	SPY	ETF	188.46	188.46	188.45	188.46	122000.0
2014-05-02 07:35:00	SPY	ETF	188.46	188.46	188.44	188.46	6300.0
2014-05-02 07:40:00	SPY	ETF	188.44	188.46	188.43	188.43	33500.0
2014-05-02 07:45:00	SPY	ETF	188.43	188.46	188.43	188.44	23300.0
2014-05-02 07:50:00	SPY	ETF	188.44	188.44	188.43	188.43	28450.0
2014-05-02 07:55:00	SPY	ETF	188.42	188.49	188.42	188.49	2950.0
2014-05-02 08:00:00	SPY	ETF	188.48	188.51	188.42	188.42	56155.0
2014-05-02 08:05:00	SPY	ETF	188.5	188.52	188.48	188.48	27361.0
2014-05-02 08:10:00	SPY	ETF	188.48	188.51	188.45	188.48	61994.0
2014-05-02 08:15:00	SPY	ETF	188.48	188.48	188.46	188.46	6136.0
2014-05-02 08:20:00	SPY	ETF	188.46	188.51	188.45	188.49	20842.0
2014-05-02 08:25:00	SPY	ETF	188.48	188.54	188.38	188.53	97926.0
2014-05-02 08:30:00	SPY	ETF	188.53	189.3	188.53	188.7	2154591.0
2014-05-02 08:35:00	SPY	ETF	188.71	188.75	188.37	188.53	936677.0
2014-05-02 08:40:00	SPY	ETF	188.54	188.74	188.54	188.59	423842.0
2014-05-02 08:45:00	SPY	ETF	188.59	188.66	188.52	188.57	233739.0
2014-05-02 08:50:00	SPY	ETF	188.57	188.66	188.55	188.57	167213.0
2014-05-02 08:55:00	SPY	ETF	188.58	188.58	188.13	188.2	644864.0
2014-05-02 09:00:00	SPY	ETF	188.19	188.32	188.13	188.19	269097.0
2014-05-02 09:05:00	SPY	ETF	188.22	188.43	188.2	188.42	312093.0
2014-05-02 09:10:00	SPY	ETF	188.43	188.54	188.4	188.5	335529.0
2014-05-02 09:15:00	SPY	ETF	188.51	188.51	188.39	188.415	287746.0
2014-05-02 09:20:00	SPY	ETF	188.41	188.45	188.31	188.31	203233.0
2014-05-02 09:25:00	SPY	ETF	188.32	188.42	188.26	188.3	515935.0
2014-05-02 09:30:00	SPY	ETF	188.31	188.5	188.09	188.4	3677152.0
2014-05-02 09:35:00	SPY	ETF	188.41	188.75	188.4	188.73	2738881.0
2014-05-02 09:40:00	SPY	ETF	188.73	188.82	188.535	188.66	2235211.0
2014-05-02 09:45:00	SPY	ETF	188.66	188.93	188.54	188.54	2299080.0
2014-05-02 09:50:00	SPY	ETF	188.54	188.74	188.5	188.6	1331091.0
2014-05-02 09:55:00	SPY	ETF	188.59	188.69	188.44	188.69	1380386.0
2014-05-02 10:00:00	SPY	ETF	188.69	188.78	188.53	188.62	1858571.0
2014-05-02 10:05:00	SPY	ETF	188.63	189.01	188.63	188.92	1859886.0
2014-05-02 10:10:00	SPY	ETF	188.93	189.14	188.92	189.04	1911764.0
2014-05-02 10:15:00	SPY	ETF	189.045	189.11	189.0	189.03	1487209.0

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

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