PREVIEW / etf_1min / 2014-08-07

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-08-07.parquet
  size:    2.3 MB
  rows:    114,838

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-07 04:00:00	SPY	ETF	192.27	192.27	192.27	192.27	145.0
2014-08-07 04:02:00	SPY	ETF	192.34	192.43	192.34	192.43	1050.0
2014-08-07 04:06:00	SPY	ETF	192.45	192.45	192.45	192.45	500.0
2014-08-07 04:11:00	SPY	ETF	192.5	192.5	192.5	192.5	250.0
2014-08-07 04:14:00	SPY	ETF	192.42	192.42	192.42	192.42	100.0
2014-08-07 04:16:00	SPY	ETF	192.38	192.38	192.38	192.38	200.0
2014-08-07 04:19:00	SPY	ETF	192.4	192.4	192.4	192.4	100.0
2014-08-07 04:23:00	SPY	ETF	192.39	192.39	192.39	192.39	200.0
2014-08-07 04:26:00	SPY	ETF	192.54	192.54	192.54	192.54	100.0
2014-08-07 04:28:00	SPY	ETF	192.59	192.64	192.59	192.64	416.0
2014-08-07 04:36:00	SPY	ETF	192.64	192.64	192.64	192.64	165.0
2014-08-07 04:40:00	SPY	ETF	192.62	192.62	192.62	192.62	199.0
2014-08-07 04:41:00	SPY	ETF	192.65	192.65	192.65	192.65	5100.0
2014-08-07 04:55:00	SPY	ETF	192.59	192.59	192.59	192.59	3570.0
2014-08-07 04:56:00	SPY	ETF	192.59	192.59	192.59	192.59	6430.0
2014-08-07 04:58:00	SPY	ETF	192.57	192.57	192.57	192.57	600.0
2014-08-07 04:59:00	SPY	ETF	192.56	192.56	192.56	192.56	100.0
2014-08-07 05:00:00	SPY	ETF	192.63	192.63	192.63	192.63	100.0
2014-08-07 05:12:00	SPY	ETF	192.52	192.52	192.52	192.52	100.0
2014-08-07 05:19:00	SPY	ETF	192.47	192.47	192.47	192.47	100.0
2014-08-07 05:22:00	SPY	ETF	192.47	192.47	192.47	192.47	100.0
2014-08-07 05:23:00	SPY	ETF	192.47	192.47	192.47	192.47	300.0
2014-08-07 05:24:00	SPY	ETF	192.55	192.55	192.55	192.55	500.0
2014-08-07 05:31:00	SPY	ETF	192.38	192.38	192.38	192.38	1100.0
2014-08-07 05:32:00	SPY	ETF	192.41	192.41	192.41	192.41	176.0
2014-08-07 05:34:00	SPY	ETF	192.39	192.39	192.39	192.39	200.0
2014-08-07 05:37:00	SPY	ETF	192.46	192.46	192.46	192.46	230.0
2014-08-07 05:58:00	SPY	ETF	192.56	192.56	192.56	192.56	100.0
2014-08-07 06:03:00	SPY	ETF	192.57	192.57	192.57	192.57	3000.0
2014-08-07 06:13:00	SPY	ETF	192.56	192.56	192.56	192.56	100.0
2014-08-07 06:21:00	SPY	ETF	192.47	192.47	192.42	192.42	200.0
2014-08-07 06:24:00	SPY	ETF	192.44	192.44	192.44	192.44	1000.0
2014-08-07 06:25:00	SPY	ETF	192.44	192.48	192.44	192.48	15200.0
2014-08-07 06:26:00	SPY	ETF	192.51	192.51	192.49	192.49	500.0
2014-08-07 06:27:00	SPY	ETF	192.47	192.51	192.46	192.51	3500.0
2014-08-07 06:28:00	SPY	ETF	192.51	192.51	192.5	192.5	1000.0
2014-08-07 06:29:00	SPY	ETF	192.52	192.52	192.52	192.52	1000.0
2014-08-07 06:33:00	SPY	ETF	192.5	192.5	192.5	192.5	1059.0
2014-08-07 06:34:00	SPY	ETF	192.45	192.45	192.4	192.41	5300.0
2014-08-07 06:35:00	SPY	ETF	192.4	192.4	192.4	192.4	200.0
2014-08-07 06:36:00	SPY	ETF	192.42	192.42	192.42	192.42	100.0
2014-08-07 06:38:00	SPY	ETF	192.4	192.4	192.39	192.4	1045.0
2014-08-07 06:39:00	SPY	ETF	192.37	192.37	192.37	192.37	900.0
2014-08-07 06:41:00	SPY	ETF	192.37	192.37	192.37	192.37	100.0
2014-08-07 06:43:00	SPY	ETF	192.37	192.4	192.37	192.37	3218.0
2014-08-07 06:44:00	SPY	ETF	192.35	192.35	192.33	192.33	2191.0
2014-08-07 06:45:00	SPY	ETF	192.31	192.31	192.31	192.31	400.0
2014-08-07 06:46:00	SPY	ETF	192.34	192.37	192.3	192.3	3127.0
2014-08-07 06:50:00	SPY	ETF	192.32	192.32	192.32	192.32	5000.0
2014-08-07 06:51:00	SPY	ETF	192.29	192.29	192.25	192.25	300.0

> showing 50 of 114,838 rows — these rows as CSV

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