PREVIEW / etf_5min / 2014-01-31

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-01-31.parquet
  size:    1.1 MB
  rows:    45,354

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-01-31 04:00:00	SPY	ETF	178.28	178.34	178.26	178.29	6292.0
2014-01-31 04:05:00	SPY	ETF	178.27	178.33	178.23	178.31	9719.0
2014-01-31 04:10:00	SPY	ETF	178.26	178.28	178.21	178.26	8528.0
2014-01-31 04:15:00	SPY	ETF	178.24	178.24	177.96	177.96	6229.0
2014-01-31 04:20:00	SPY	ETF	177.92	177.98	177.88	177.92	13298.0
2014-01-31 04:25:00	SPY	ETF	177.92	178.06	177.91	178.06	13557.0
2014-01-31 04:30:00	SPY	ETF	178.06	178.07	178.04	178.04	2428.0
2014-01-31 04:35:00	SPY	ETF	177.99	178.12	177.99	178.12	1575.0
2014-01-31 04:40:00	SPY	ETF	178.12	178.2	178.09	178.15	2373.0
2014-01-31 04:45:00	SPY	ETF	178.04	178.04	178.0	178.01	614.0
2014-01-31 04:50:00	SPY	ETF	177.97	177.97	177.72	177.77	24678.0
2014-01-31 04:55:00	SPY	ETF	177.84	177.84	177.79	177.82	1392.0
2014-01-31 05:00:00	SPY	ETF	177.84	177.84	177.67	177.74	15769.0
2014-01-31 05:05:00	SPY	ETF	177.68	177.77	177.51	177.52	7988.0
2014-01-31 05:10:00	SPY	ETF	177.54	177.57	177.49	177.57	48202.0
2014-01-31 05:15:00	SPY	ETF	177.54	177.54	177.32	177.37	38622.0
2014-01-31 05:20:00	SPY	ETF	177.32	177.49	177.32	177.49	28817.0
2014-01-31 05:25:00	SPY	ETF	177.44	177.59	177.44	177.56	60807.0
2014-01-31 05:30:00	SPY	ETF	177.59	177.62	177.59	177.62	5291.0
2014-01-31 05:35:00	SPY	ETF	177.67	177.67	177.54	177.62	5791.0
2014-01-31 05:40:00	SPY	ETF	177.67	177.79	177.63	177.63	3497.0
2014-01-31 05:45:00	SPY	ETF	177.64	177.72	177.63	177.64	2105.0
2014-01-31 05:50:00	SPY	ETF	177.64	177.69	177.58	177.64	3392.0
2014-01-31 05:55:00	SPY	ETF	177.62	177.62	177.56	177.58	2858.0
2014-01-31 06:00:00	SPY	ETF	177.61	177.61	177.5	177.54	7368.0
2014-01-31 06:05:00	SPY	ETF	177.49	177.57	177.49	177.57	1252.0
2014-01-31 06:10:00	SPY	ETF	177.59	177.78	177.58	177.74	28948.0
2014-01-31 06:15:00	SPY	ETF	177.77	177.79	177.59	177.62	27082.0
2014-01-31 06:20:00	SPY	ETF	177.67	177.67	177.59	177.59	7300.0
2014-01-31 06:25:00	SPY	ETF	177.57	177.59	177.54	177.54	2611.0
2014-01-31 06:30:00	SPY	ETF	177.57	177.57	177.39	177.39	32079.0
2014-01-31 06:35:00	SPY	ETF	177.39	177.39	176.96	177.15	128113.0
2014-01-31 06:40:00	SPY	ETF	177.13	177.29	177.13	177.22	82771.0
2014-01-31 06:45:00	SPY	ETF	177.19	177.19	176.9	176.9	107105.0
2014-01-31 06:50:00	SPY	ETF	176.87	177.2	176.87	177.12	54607.0
2014-01-31 06:55:00	SPY	ETF	177.07	177.08	176.93	177.0	130618.0
2014-01-31 07:00:00	SPY	ETF	176.98	177.14	176.93	177.1	209295.0
2014-01-31 07:05:00	SPY	ETF	177.1	177.2	176.96	177.0	60549.0
2014-01-31 07:10:00	SPY	ETF	177.0	177.22	177.0	177.22	58132.0
2014-01-31 07:15:00	SPY	ETF	177.19	177.34	177.19	177.3	56728.0
2014-01-31 07:20:00	SPY	ETF	177.3	177.54	177.29	177.53	128737.0
2014-01-31 07:25:00	SPY	ETF	177.55	177.66	177.39	177.39	106190.0
2014-01-31 07:30:00	SPY	ETF	177.35	177.43	177.32	177.43	90680.0
2014-01-31 07:35:00	SPY	ETF	177.43	177.45	177.35	177.4	47326.0
2014-01-31 07:40:00	SPY	ETF	177.4	177.45	177.35	177.45	11354.0
2014-01-31 07:45:00	SPY	ETF	177.5	177.58	177.46	177.49	29898.0
2014-01-31 07:50:00	SPY	ETF	177.5	177.53	177.14	177.19	226944.0
2014-01-31 07:55:00	SPY	ETF	177.19	177.36	177.17	177.22	140525.0
2014-01-31 08:00:00	SPY	ETF	177.54	177.62	176.96	177.16	479791.0
2014-01-31 08:05:00	SPY	ETF	177.16	177.17	177.03	177.17	166561.0

> showing 50 of 45,354 rows — these rows as CSV

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