PREVIEW / etf_1min / 2014-07-23

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-07-23.parquet
  size:    1.9 MB
  rows:    104,067

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-23 04:00:00	SPY	ETF	198.14	198.14	198.12	198.12	1441.0
2014-07-23 04:04:00	SPY	ETF	198.13	198.13	198.13	198.13	600.0
2014-07-23 04:10:00	SPY	ETF	198.14	198.14	198.14	198.14	500.0
2014-07-23 04:11:00	SPY	ETF	198.14	198.14	198.14	198.14	201.0
2014-07-23 04:16:00	SPY	ETF	198.14	198.14	198.14	198.14	599.0
2014-07-23 04:19:00	SPY	ETF	198.16	198.2	198.16	198.2	1854.0
2014-07-23 04:20:00	SPY	ETF	198.19	198.2	198.19	198.2	4800.0
2014-07-23 04:21:00	SPY	ETF	198.23	198.23	198.23	198.23	520.0
2014-07-23 04:24:00	SPY	ETF	198.2	198.2	198.2	198.2	600.0
2014-07-23 04:48:00	SPY	ETF	198.19	198.2	198.19	198.2	4000.0
2014-07-23 04:49:00	SPY	ETF	198.2	198.21	198.2	198.2	1780.0
2014-07-23 05:15:00	SPY	ETF	198.21	198.21	198.21	198.21	762.0
2014-07-23 05:31:00	SPY	ETF	198.2	198.2	198.2	198.2	100.0
2014-07-23 05:34:00	SPY	ETF	198.25	198.25	198.25	198.25	100.0
2014-07-23 05:36:00	SPY	ETF	198.27	198.27	198.27	198.27	111.0
2014-07-23 05:49:00	SPY	ETF	198.21	198.21	198.21	198.21	689.0
2014-07-23 06:00:00	SPY	ETF	198.27	198.27	198.27	198.27	300.0
2014-07-23 06:07:00	SPY	ETF	198.32	198.32	198.32	198.32	100.0
2014-07-23 06:08:00	SPY	ETF	198.34	198.34	198.34	198.34	400.0
2014-07-23 06:12:00	SPY	ETF	198.37	198.38	198.37	198.38	5200.0
2014-07-23 06:15:00	SPY	ETF	198.37	198.37	198.37	198.37	200.0
2014-07-23 06:19:00	SPY	ETF	198.36	198.39	198.36	198.39	637.0
2014-07-23 06:23:00	SPY	ETF	198.39	198.39	198.39	198.39	300.0
2014-07-23 06:26:00	SPY	ETF	198.39	198.39	198.39	198.39	300.0
2014-07-23 06:27:00	SPY	ETF	198.41	198.41	198.39	198.41	25417.0
2014-07-23 06:33:00	SPY	ETF	198.38	198.38	198.37	198.37	5241.0
2014-07-23 06:34:00	SPY	ETF	198.36	198.36	198.36	198.36	100.0
2014-07-23 06:35:00	SPY	ETF	198.37	198.39	198.35	198.35	500.0
2014-07-23 06:36:00	SPY	ETF	198.38	198.38	198.38	198.38	175.0
2014-07-23 06:38:00	SPY	ETF	198.38	198.38	198.38	198.38	225.0
2014-07-23 06:41:00	SPY	ETF	198.37	198.37	198.37	198.37	100.0
2014-07-23 06:42:00	SPY	ETF	198.34	198.34	198.34	198.34	178.0
2014-07-23 06:43:00	SPY	ETF	198.36	198.36	198.36	198.36	100.0
2014-07-23 06:44:00	SPY	ETF	198.34	198.34	198.34	198.34	100.0
2014-07-23 06:45:00	SPY	ETF	198.34	198.39	198.34	198.39	5700.0
2014-07-23 06:46:00	SPY	ETF	198.36	198.36	198.36	198.36	106.0
2014-07-23 06:49:00	SPY	ETF	198.33	198.33	198.33	198.33	380.0
2014-07-23 06:50:00	SPY	ETF	198.36	198.36	198.33	198.33	2999.0
2014-07-23 06:52:00	SPY	ETF	198.33	198.34	198.33	198.34	325.0
2014-07-23 06:55:00	SPY	ETF	198.34	198.34	198.33	198.33	16122.0
2014-07-23 06:56:00	SPY	ETF	198.33	198.33	198.33	198.33	2253.0
2014-07-23 06:58:00	SPY	ETF	198.3	198.3	198.3	198.3	100.0
2014-07-23 06:59:00	SPY	ETF	198.26	198.26	198.24	198.24	300.0
2014-07-23 07:00:00	SPY	ETF	198.26	198.26	198.25	198.25	10180.0
2014-07-23 07:02:00	SPY	ETF	198.26	198.26	198.25	198.25	487.0
2014-07-23 07:03:00	SPY	ETF	198.26	198.26	198.26	198.26	3600.0
2014-07-23 07:04:00	SPY	ETF	198.27	198.27	198.27	198.27	499.0
2014-07-23 07:05:00	SPY	ETF	198.29	198.3	198.29	198.3	3210.0
2014-07-23 07:06:00	SPY	ETF	198.31	198.31	198.31	198.31	100.0
2014-07-23 07:07:00	SPY	ETF	198.33	198.33	198.33	198.33	700.0

> showing 50 of 104,067 rows — these rows as CSV

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