PREVIEW / etf_5min / 2013-10-21

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-10-21.parquet
  size:    969 KB
  rows:    42,389

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
2013-10-21 04:05:00	SPY	ETF	174.27	174.27	174.25	174.25	387.0
2013-10-21 04:10:00	SPY	ETF	174.26	174.26	174.26	174.26	105.0
2013-10-21 04:15:00	SPY	ETF	174.28	174.3	174.28	174.3	326.0
2013-10-21 04:25:00	SPY	ETF	174.29	174.29	174.29	174.29	100.0
2013-10-21 04:30:00	SPY	ETF	174.28	174.28	174.28	174.28	100.0
2013-10-21 04:35:00	SPY	ETF	174.3	174.3	174.28	174.28	10100.0
2013-10-21 04:50:00	SPY	ETF	174.3	174.3	174.28	174.28	2700.0
2013-10-21 04:55:00	SPY	ETF	174.26	174.28	174.26	174.28	1100.0
2013-10-21 05:00:00	SPY	ETF	174.26	174.26	174.26	174.26	100.0
2013-10-21 05:10:00	SPY	ETF	174.22	174.22	174.2	174.2	3048.0
2013-10-21 05:15:00	SPY	ETF	174.19	174.19	174.19	174.19	100.0
2013-10-21 05:20:00	SPY	ETF	174.2	174.2	174.2	174.2	5000.0
2013-10-21 05:25:00	SPY	ETF	174.22	174.22	174.22	174.22	100.0
2013-10-21 05:30:00	SPY	ETF	174.22	174.22	174.22	174.22	300.0
2013-10-21 05:35:00	SPY	ETF	174.2	174.2	174.2	174.2	1890.0
2013-10-21 05:40:00	SPY	ETF	174.19	174.19	174.19	174.19	400.0
2013-10-21 05:45:00	SPY	ETF	174.22	174.23	174.22	174.23	476.0
2013-10-21 06:35:00	SPY	ETF	174.21	174.21	174.2	174.2	1200.0
2013-10-21 06:40:00	SPY	ETF	174.18	174.18	174.18	174.18	100.0
2013-10-21 06:45:00	SPY	ETF	174.16	174.16	174.16	174.16	600.0
2013-10-21 06:50:00	SPY	ETF	174.16	174.16	174.16	174.16	200.0
2013-10-21 06:55:00	SPY	ETF	174.13	174.13	174.08	174.11	19014.0
2013-10-21 07:00:00	SPY	ETF	174.09	174.09	174.06	174.08	6300.0
2013-10-21 07:05:00	SPY	ETF	174.12	174.14	174.12	174.14	1200.0
2013-10-21 07:10:00	SPY	ETF	174.14	174.16	174.14	174.16	700.0
2013-10-21 07:15:00	SPY	ETF	174.17	174.19	174.17	174.19	500.0
2013-10-21 07:20:00	SPY	ETF	174.2	174.25	174.2	174.23	14484.0
2013-10-21 07:25:00	SPY	ETF	174.22	174.23	174.22	174.23	10100.0
2013-10-21 07:30:00	SPY	ETF	174.23	174.23	174.19	174.19	22000.0
2013-10-21 07:35:00	SPY	ETF	174.22	174.27	174.22	174.27	20699.0
2013-10-21 07:40:00	SPY	ETF	174.27	174.3	174.26	174.27	4450.0
2013-10-21 07:45:00	SPY	ETF	174.27	174.27	174.23	174.25	11500.0
2013-10-21 07:50:00	SPY	ETF	174.25	174.26	174.25	174.25	2600.0
2013-10-21 07:55:00	SPY	ETF	174.25	174.25	174.19	174.25	9862.0
2013-10-21 08:00:00	SPY	ETF	174.25	174.27	174.15	174.23	22045.0
2013-10-21 08:05:00	SPY	ETF	174.24	174.25	174.2	174.25	8262.0
2013-10-21 08:10:00	SPY	ETF	174.28	174.3	174.26	174.3	18000.0
2013-10-21 08:15:00	SPY	ETF	174.3	174.38	174.3	174.38	38391.0
2013-10-21 08:20:00	SPY	ETF	174.38	174.38	174.3	174.33	14979.0
2013-10-21 08:25:00	SPY	ETF	174.35	174.35	174.32	174.32	32155.0
2013-10-21 08:30:00	SPY	ETF	174.31	174.31	174.27	174.3	9338.0
2013-10-21 08:35:00	SPY	ETF	174.31	174.34	174.3	174.3	4489.0
2013-10-21 08:40:00	SPY	ETF	174.3	174.34	174.3	174.32	17684.0
2013-10-21 08:45:00	SPY	ETF	174.33	174.34	174.3	174.32	63675.0
2013-10-21 08:50:00	SPY	ETF	174.29	174.3	174.28	174.29	13458.0
2013-10-21 08:55:00	SPY	ETF	174.28	174.37	174.28	174.36	93869.0
2013-10-21 09:00:00	SPY	ETF	174.36	174.37	174.32	174.35	36494.0
2013-10-21 09:05:00	SPY	ETF	174.34	174.4	174.32	174.38	97941.0
2013-10-21 09:10:00	SPY	ETF	174.38	174.4	174.36	174.38	125648.0
2013-10-21 09:15:00	SPY	ETF	174.38	174.4	174.36	174.39	17394.0

> showing 50 of 42,389 rows — these rows as CSV

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