PREVIEW / etf_1min / 2014-08-21

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-08-21.parquet
  size:    2.0 MB
  rows:    106,504

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-08-21 04:00:00	SPY	ETF	199.17	199.17	199.17	199.17	200.0
2014-08-21 04:09:00	SPY	ETF	199.11	199.11	199.11	199.11	232.0
2014-08-21 04:13:00	SPY	ETF	199.25	199.25	199.25	199.25	100.0
2014-08-21 04:28:00	SPY	ETF	199.19	199.19	199.19	199.19	1400.0
2014-08-21 04:29:00	SPY	ETF	199.19	199.19	199.19	199.19	731.0
2014-08-21 04:34:00	SPY	ETF	199.2	199.2	199.2	199.2	15000.0
2014-08-21 04:41:00	SPY	ETF	199.18	199.18	199.18	199.18	150.0
2014-08-21 04:48:00	SPY	ETF	199.25	199.26	199.25	199.26	2100.0
2014-08-21 04:50:00	SPY	ETF	199.28	199.35	199.25	199.25	7436.0
2014-08-21 04:52:00	SPY	ETF	199.26	199.26	199.26	199.26	6699.0
2014-08-21 05:08:00	SPY	ETF	199.22	199.22	199.22	199.22	700.0
2014-08-21 05:22:00	SPY	ETF	199.19	199.19	199.19	199.19	1444.0
2014-08-21 05:24:00	SPY	ETF	199.17	199.17	199.16	199.16	721.0
2014-08-21 05:37:00	SPY	ETF	199.05	199.05	199.05	199.05	1000.0
2014-08-21 05:39:00	SPY	ETF	199.16	199.16	199.16	199.16	300.0
2014-08-21 05:44:00	SPY	ETF	199.21	199.21	199.21	199.21	200.0
2014-08-21 05:58:00	SPY	ETF	199.28	199.28	199.28	199.28	5000.0
2014-08-21 06:03:00	SPY	ETF	199.29	199.3	199.29	199.3	500.0
2014-08-21 06:07:00	SPY	ETF	199.33	199.33	199.32	199.32	499.0
2014-08-21 06:18:00	SPY	ETF	199.28	199.32	199.28	199.32	900.0
2014-08-21 06:28:00	SPY	ETF	199.32	199.32	199.32	199.32	500.0
2014-08-21 06:36:00	SPY	ETF	199.29	199.29	199.29	199.29	400.0
2014-08-21 06:38:00	SPY	ETF	199.26	199.26	199.26	199.26	5000.0
2014-08-21 06:42:00	SPY	ETF	199.27	199.27	199.27	199.27	400.0
2014-08-21 06:43:00	SPY	ETF	199.23	199.23	199.23	199.23	1000.0
2014-08-21 06:47:00	SPY	ETF	199.23	199.23	199.23	199.23	2250.0
2014-08-21 06:50:00	SPY	ETF	199.21	199.21	199.21	199.21	100.0
2014-08-21 06:52:00	SPY	ETF	199.23	199.23	199.23	199.23	100.0
2014-08-21 07:01:00	SPY	ETF	199.26	199.26	199.26	199.26	1020.0
2014-08-21 07:03:00	SPY	ETF	199.26	199.27	199.26	199.27	200.0
2014-08-21 07:05:00	SPY	ETF	199.24	199.27	199.24	199.27	13000.0
2014-08-21 07:07:00	SPY	ETF	199.27	199.27	199.27	199.27	200.0
2014-08-21 07:10:00	SPY	ETF	199.28	199.32	199.28	199.32	15185.0
2014-08-21 07:11:00	SPY	ETF	199.32	199.32	199.28	199.28	475.0
2014-08-21 07:13:00	SPY	ETF	199.26	199.27	199.26	199.27	600.0
2014-08-21 07:16:00	SPY	ETF	199.23	199.24	199.23	199.24	575.0
2014-08-21 07:18:00	SPY	ETF	199.23	199.24	199.23	199.23	12400.0
2014-08-21 07:20:00	SPY	ETF	199.27	199.27	199.27	199.27	1200.0
2014-08-21 07:24:00	SPY	ETF	199.23	199.23	199.21	199.21	1047.0
2014-08-21 07:25:00	SPY	ETF	199.19	199.25	199.19	199.25	800.0
2014-08-21 07:26:00	SPY	ETF	199.19	199.22	199.19	199.22	850.0
2014-08-21 07:28:00	SPY	ETF	199.19	199.19	199.19	199.19	150.0
2014-08-21 07:30:00	SPY	ETF	199.2	199.2	199.19	199.19	20029.0
2014-08-21 07:31:00	SPY	ETF	199.19	199.19	199.19	199.19	100.0
2014-08-21 07:32:00	SPY	ETF	199.19	199.19	199.19	199.19	700.0
2014-08-21 07:40:00	SPY	ETF	199.21	199.21	199.21	199.21	1005.0
2014-08-21 07:41:00	SPY	ETF	199.23	199.24	199.23	199.24	1200.0
2014-08-21 07:42:00	SPY	ETF	199.24	199.24	199.24	199.24	150.0
2014-08-21 07:43:00	SPY	ETF	199.26	199.31	199.26	199.31	1500.0
2014-08-21 07:44:00	SPY	ETF	199.31	199.31	199.3	199.3	300.0

> showing 50 of 106,504 rows — these rows as CSV

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