PREVIEW / etf_1min / 2014-05-06

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-05-06.parquet
  size:    2.1 MB
  rows:    108,390

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-05-06 04:00:00	SPY	ETF	188.5	188.62	188.5	188.62	400.0
2014-05-06 04:02:00	SPY	ETF	188.55	188.55	188.55	188.55	100.0
2014-05-06 04:05:00	SPY	ETF	188.57	188.57	188.57	188.57	210.0
2014-05-06 04:06:00	SPY	ETF	188.53	188.53	188.53	188.53	232.0
2014-05-06 04:19:00	SPY	ETF	188.36	188.36	188.36	188.36	100.0
2014-05-06 04:27:00	SPY	ETF	188.27	188.27	188.25	188.25	310.0
2014-05-06 04:42:00	SPY	ETF	188.34	188.34	188.34	188.34	101.0
2014-05-06 04:43:00	SPY	ETF	188.35	188.35	188.35	188.35	234.0
2014-05-06 04:51:00	SPY	ETF	188.32	188.32	188.32	188.32	107.0
2014-05-06 05:25:00	SPY	ETF	188.53	188.53	188.53	188.53	205.0
2014-05-06 05:26:00	SPY	ETF	188.53	188.53	188.53	188.53	219.0
2014-05-06 06:00:00	SPY	ETF	188.42	188.42	188.42	188.42	122.0
2014-05-06 06:06:00	SPY	ETF	188.39	188.39	188.39	188.39	1900.0
2014-05-06 06:16:00	SPY	ETF	188.41	188.41	188.41	188.41	100.0
2014-05-06 06:20:00	SPY	ETF	188.41	188.41	188.41	188.41	226.0
2014-05-06 06:38:00	SPY	ETF	188.38	188.38	188.38	188.38	500.0
2014-05-06 06:39:00	SPY	ETF	188.35	188.35	188.35	188.35	1200.0
2014-05-06 06:47:00	SPY	ETF	188.36	188.36	188.36	188.36	217.0
2014-05-06 06:48:00	SPY	ETF	188.31	188.31	188.31	188.31	100.0
2014-05-06 06:58:00	SPY	ETF	188.3	188.3	188.27	188.27	800.0
2014-05-06 06:59:00	SPY	ETF	188.26	188.26	188.26	188.26	100.0
2014-05-06 07:02:00	SPY	ETF	188.27	188.27	188.27	188.27	3000.0
2014-05-06 07:04:00	SPY	ETF	188.25	188.25	188.15	188.15	2100.0
2014-05-06 07:05:00	SPY	ETF	188.18	188.18	188.15	188.15	3150.0
2014-05-06 07:06:00	SPY	ETF	188.19	188.19	188.17	188.17	3000.0
2014-05-06 07:08:00	SPY	ETF	188.19	188.19	188.11	188.11	3900.0
2014-05-06 07:09:00	SPY	ETF	188.1	188.1	188.1	188.1	463.0
2014-05-06 07:11:00	SPY	ETF	188.14	188.14	188.13	188.13	600.0
2014-05-06 07:12:00	SPY	ETF	188.14	188.15	188.14	188.15	750.0
2014-05-06 07:14:00	SPY	ETF	188.13	188.13	188.11	188.11	1600.0
2014-05-06 07:15:00	SPY	ETF	188.1	188.1	188.1	188.1	700.0
2014-05-06 07:18:00	SPY	ETF	188.15	188.15	188.15	188.15	400.0
2014-05-06 07:20:00	SPY	ETF	188.16	188.16	188.16	188.16	1500.0
2014-05-06 07:21:00	SPY	ETF	188.16	188.16	188.16	188.16	1000.0
2014-05-06 07:24:00	SPY	ETF	188.19	188.19	188.19	188.19	100.0
2014-05-06 07:27:00	SPY	ETF	188.2	188.2	188.2	188.2	600.0
2014-05-06 07:32:00	SPY	ETF	188.21	188.21	188.21	188.21	250.0
2014-05-06 07:33:00	SPY	ETF	188.2	188.2	188.2	188.2	500.0
2014-05-06 07:34:00	SPY	ETF	188.18	188.18	188.18	188.18	380.0
2014-05-06 07:35:00	SPY	ETF	188.2	188.2	188.2	188.2	2000.0
2014-05-06 07:37:00	SPY	ETF	188.18	188.18	188.17	188.17	209.0
2014-05-06 07:39:00	SPY	ETF	188.18	188.18	188.18	188.18	200.0
2014-05-06 07:46:00	SPY	ETF	188.16	188.16	188.15	188.16	2821.0
2014-05-06 07:48:00	SPY	ETF	188.11	188.11	188.11	188.11	10000.0
2014-05-06 07:49:00	SPY	ETF	188.15	188.15	188.15	188.15	1000.0
2014-05-06 07:57:00	SPY	ETF	188.15	188.2	188.15	188.19	1700.0
2014-05-06 07:58:00	SPY	ETF	188.2	188.2	188.2	188.2	600.0
2014-05-06 07:59:00	SPY	ETF	188.21	188.22	188.21	188.22	2578.0
2014-05-06 08:00:00	SPY	ETF	188.2	188.21	188.13	188.2	5500.0
2014-05-06 08:01:00	SPY	ETF	188.19	188.19	188.19	188.19	200.0

> showing 50 of 108,390 rows — these rows as CSV

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