PREVIEW / etf_5min / 2014-10-06

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-10-06.parquet
  size:    1.1 MB
  rows:    45,663

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-10-06 04:00:00	SPY	ETF	197.08	197.32	197.08	197.27	1214.0
2014-10-06 04:05:00	SPY	ETF	197.35	197.36	197.35	197.36	9891.0
2014-10-06 04:10:00	SPY	ETF	197.39	197.45	197.39	197.42	1130.0
2014-10-06 04:15:00	SPY	ETF	197.42	197.42	197.38	197.38	900.0
2014-10-06 04:20:00	SPY	ETF	197.38	197.38	197.35	197.38	993.0
2014-10-06 04:30:00	SPY	ETF	197.4	197.42	197.32	197.32	2080.0
2014-10-06 04:35:00	SPY	ETF	197.32	197.32	197.32	197.32	100.0
2014-10-06 04:40:00	SPY	ETF	197.31	197.31	197.31	197.31	300.0
2014-10-06 04:50:00	SPY	ETF	197.31	197.31	197.31	197.31	100.0
2014-10-06 05:05:00	SPY	ETF	197.2	197.2	197.2	197.2	630.0
2014-10-06 05:10:00	SPY	ETF	197.2	197.2	197.2	197.2	3779.0
2014-10-06 05:15:00	SPY	ETF	197.22	197.27	197.22	197.25	4500.0
2014-10-06 05:20:00	SPY	ETF	197.21	197.21	197.18	197.18	6619.0
2014-10-06 05:25:00	SPY	ETF	197.19	197.19	197.19	197.19	159.0
2014-10-06 05:30:00	SPY	ETF	197.19	197.21	197.19	197.21	5165.0
2014-10-06 05:40:00	SPY	ETF	197.11	197.11	197.11	197.11	1924.0
2014-10-06 05:45:00	SPY	ETF	197.05	197.05	197.02	197.02	200.0
2014-10-06 05:50:00	SPY	ETF	196.96	196.96	196.96	196.96	133.0
2014-10-06 05:55:00	SPY	ETF	197.02	197.02	197.02	197.02	200.0
2014-10-06 06:00:00	SPY	ETF	197.06	197.06	197.06	197.06	616.0
2014-10-06 06:05:00	SPY	ETF	197.07	197.07	197.03	197.03	10300.0
2014-10-06 06:10:00	SPY	ETF	197.05	197.11	197.05	197.1	1146.0
2014-10-06 06:20:00	SPY	ETF	197.05	197.07	197.05	197.05	2058.0
2014-10-06 06:25:00	SPY	ETF	197.08	197.08	197.08	197.08	7515.0
2014-10-06 06:30:00	SPY	ETF	197.07	197.08	197.07	197.08	5000.0
2014-10-06 06:35:00	SPY	ETF	197.07	197.11	197.06	197.06	18950.0
2014-10-06 06:40:00	SPY	ETF	197.08	197.08	197.05	197.05	630.0
2014-10-06 06:45:00	SPY	ETF	197.07	197.21	197.07	197.21	4850.0
2014-10-06 06:50:00	SPY	ETF	197.21	197.23	197.16	197.16	5768.0
2014-10-06 06:55:00	SPY	ETF	197.16	197.17	197.12	197.17	26200.0
2014-10-06 07:00:00	SPY	ETF	197.18	197.23	197.15	197.23	65427.0
2014-10-06 07:05:00	SPY	ETF	197.23	197.27	197.23	197.25	39660.0
2014-10-06 07:10:00	SPY	ETF	197.26	197.26	197.17	197.21	33311.0
2014-10-06 07:15:00	SPY	ETF	197.21	197.24	197.17	197.21	66409.0
2014-10-06 07:20:00	SPY	ETF	197.22	197.32	197.22	197.31	24076.0
2014-10-06 07:25:00	SPY	ETF	197.3	197.31	197.29	197.31	6130.0
2014-10-06 07:30:00	SPY	ETF	197.31	197.33	197.17	197.17	14502.0
2014-10-06 07:35:00	SPY	ETF	197.13	197.13	197.07	197.09	9500.0
2014-10-06 07:40:00	SPY	ETF	197.13	197.13	197.1	197.11	30400.0
2014-10-06 07:45:00	SPY	ETF	197.1	197.14	197.1	197.14	3356.0
2014-10-06 07:50:00	SPY	ETF	197.11	197.13	197.06	197.13	24479.0
2014-10-06 07:55:00	SPY	ETF	197.11	197.12	197.07	197.07	3600.0
2014-10-06 08:00:00	SPY	ETF	197.15	197.3	197.11	197.16	52183.0
2014-10-06 08:05:00	SPY	ETF	197.15	197.15	197.08	197.09	17068.0
2014-10-06 08:10:00	SPY	ETF	197.09	197.18	197.09	197.18	49891.0
2014-10-06 08:15:00	SPY	ETF	197.18	197.18	197.16	197.17	19894.0
2014-10-06 08:20:00	SPY	ETF	197.17	197.31	197.16	197.3	28775.0
2014-10-06 08:25:00	SPY	ETF	197.28	197.36	197.27	197.34	67833.0
2014-10-06 08:30:00	SPY	ETF	197.35	197.46	197.35	197.42	168035.0
2014-10-06 08:35:00	SPY	ETF	197.42	197.42	197.33	197.34	100931.0

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

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