PREVIEW / etf_1min / 2014-03-20

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-03-20.parquet
  size:    2.2 MB
  rows:    111,562

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-03-20 04:00:00	SPY	ETF	186.4	186.4	186.29	186.29	841.0
2014-03-20 04:01:00	SPY	ETF	186.4	186.4	186.4	186.4	500.0
2014-03-20 04:04:00	SPY	ETF	186.29	186.29	186.29	186.29	100.0
2014-03-20 04:05:00	SPY	ETF	186.35	186.42	186.35	186.42	1100.0
2014-03-20 04:06:00	SPY	ETF	186.4	186.4	186.4	186.4	1800.0
2014-03-20 04:16:00	SPY	ETF	186.34	186.34	186.34	186.34	200.0
2014-03-20 04:17:00	SPY	ETF	186.42	186.42	186.42	186.42	500.0
2014-03-20 04:23:00	SPY	ETF	186.39	186.39	186.39	186.39	300.0
2014-03-20 04:27:00	SPY	ETF	186.45	186.45	186.45	186.45	1800.0
2014-03-20 04:28:00	SPY	ETF	186.45	186.45	186.45	186.45	2000.0
2014-03-20 04:29:00	SPY	ETF	186.49	186.49	186.49	186.49	1400.0
2014-03-20 04:33:00	SPY	ETF	186.49	186.49	186.49	186.49	500.0
2014-03-20 04:35:00	SPY	ETF	186.54	186.54	186.54	186.54	1500.0
2014-03-20 04:38:00	SPY	ETF	186.49	186.49	186.49	186.49	600.0
2014-03-20 04:45:00	SPY	ETF	186.37	186.37	186.37	186.37	400.0
2014-03-20 04:48:00	SPY	ETF	186.41	186.42	186.38	186.38	900.0
2014-03-20 04:50:00	SPY	ETF	186.3	186.3	186.3	186.3	800.0
2014-03-20 04:52:00	SPY	ETF	186.34	186.34	186.34	186.34	800.0
2014-03-20 04:54:00	SPY	ETF	186.32	186.32	186.32	186.32	2000.0
2014-03-20 04:56:00	SPY	ETF	186.31	186.31	186.31	186.31	200.0
2014-03-20 05:02:00	SPY	ETF	186.3	186.3	186.3	186.3	800.0
2014-03-20 05:06:00	SPY	ETF	186.27	186.27	186.27	186.27	300.0
2014-03-20 05:07:00	SPY	ETF	186.26	186.26	186.26	186.26	400.0
2014-03-20 05:09:00	SPY	ETF	186.22	186.22	186.22	186.22	450.0
2014-03-20 05:10:00	SPY	ETF	186.2	186.23	186.18	186.23	2500.0
2014-03-20 05:12:00	SPY	ETF	186.18	186.18	186.15	186.15	1000.0
2014-03-20 05:13:00	SPY	ETF	186.14	186.14	186.14	186.14	400.0
2014-03-20 05:14:00	SPY	ETF	186.14	186.14	186.12	186.12	4263.0
2014-03-20 05:15:00	SPY	ETF	186.14	186.18	186.14	186.18	1400.0
2014-03-20 05:17:00	SPY	ETF	186.22	186.24	186.22	186.24	538.0
2014-03-20 05:21:00	SPY	ETF	186.26	186.26	186.26	186.26	400.0
2014-03-20 05:23:00	SPY	ETF	186.3	186.34	186.3	186.34	1200.0
2014-03-20 05:24:00	SPY	ETF	186.35	186.35	186.35	186.35	2050.0
2014-03-20 05:26:00	SPY	ETF	186.38	186.38	186.38	186.38	100.0
2014-03-20 05:31:00	SPY	ETF	186.37	186.37	186.37	186.37	100.0
2014-03-20 05:33:00	SPY	ETF	186.36	186.36	186.36	186.36	721.0
2014-03-20 05:36:00	SPY	ETF	186.4	186.4	186.4	186.4	2500.0
2014-03-20 05:41:00	SPY	ETF	186.37	186.37	186.37	186.37	1000.0
2014-03-20 05:42:00	SPY	ETF	186.32	186.32	186.32	186.32	500.0
2014-03-20 05:43:00	SPY	ETF	186.32	186.32	186.3	186.3	1400.0
2014-03-20 05:45:00	SPY	ETF	186.29	186.35	186.29	186.35	1000.0
2014-03-20 05:46:00	SPY	ETF	186.3	186.3	186.29	186.29	900.0
2014-03-20 05:48:00	SPY	ETF	186.32	186.34	186.32	186.34	900.0
2014-03-20 05:49:00	SPY	ETF	186.34	186.35	186.34	186.35	800.0
2014-03-20 05:50:00	SPY	ETF	186.3	186.3	186.29	186.29	900.0
2014-03-20 05:51:00	SPY	ETF	186.32	186.34	186.32	186.34	300.0
2014-03-20 05:52:00	SPY	ETF	186.29	186.29	186.29	186.29	100.0
2014-03-20 05:56:00	SPY	ETF	186.28	186.28	186.28	186.28	600.0
2014-03-20 05:57:00	SPY	ETF	186.29	186.29	186.29	186.29	400.0
2014-03-20 05:59:00	SPY	ETF	186.26	186.26	186.26	186.26	125.0

> showing 50 of 111,562 rows — these rows as CSV

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