PREVIEW / etf_1min / 2014-08-06

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-08-06.parquet
  size:    2.2 MB
  rows:    117,246

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-06 04:00:00	SPY	ETF	192.2	192.23	192.2	192.23	21080.0
2014-08-06 04:07:00	SPY	ETF	192.22	192.22	192.22	192.22	600.0
2014-08-06 04:12:00	SPY	ETF	192.19	192.19	192.19	192.19	200.0
2014-08-06 04:22:00	SPY	ETF	192.2	192.2	192.2	192.2	100.0
2014-08-06 04:23:00	SPY	ETF	192.21	192.21	192.21	192.21	500.0
2014-08-06 04:29:00	SPY	ETF	192.08	192.08	192.08	192.08	500.0
2014-08-06 04:30:00	SPY	ETF	192.07	192.07	192.07	192.07	300.0
2014-08-06 04:31:00	SPY	ETF	192.07	192.07	192.06	192.06	657.0
2014-08-06 04:32:00	SPY	ETF	192.08	192.08	192.08	192.08	500.0
2014-08-06 04:33:00	SPY	ETF	192.08	192.08	192.08	192.08	500.0
2014-08-06 04:43:00	SPY	ETF	192.01	192.01	192.01	192.01	150.0
2014-08-06 04:44:00	SPY	ETF	191.98	191.98	191.98	191.98	100.0
2014-08-06 04:45:00	SPY	ETF	191.98	191.98	191.98	191.98	150.0
2014-08-06 04:47:00	SPY	ETF	191.84	191.84	191.84	191.84	100.0
2014-08-06 04:51:00	SPY	ETF	191.89	191.89	191.89	191.89	100.0
2014-08-06 04:54:00	SPY	ETF	191.82	191.82	191.75	191.77	75200.0
2014-08-06 04:55:00	SPY	ETF	191.73	191.73	191.73	191.73	750.0
2014-08-06 04:56:00	SPY	ETF	191.73	191.74	191.73	191.74	200.0
2014-08-06 04:57:00	SPY	ETF	191.74	191.74	191.74	191.74	231.0
2014-08-06 04:58:00	SPY	ETF	192.57	192.57	191.87	192.56	15100.0
2014-08-06 05:02:00	SPY	ETF	191.69	191.69	191.69	191.69	200.0
2014-08-06 05:04:00	SPY	ETF	191.75	191.76	191.75	191.76	2500.0
2014-08-06 05:06:00	SPY	ETF	191.7	191.7	191.68	191.68	5100.0
2014-08-06 05:10:00	SPY	ETF	191.67	191.67	191.67	191.67	110.0
2014-08-06 05:11:00	SPY	ETF	191.68	191.68	191.65	191.65	10040.0
2014-08-06 05:26:00	SPY	ETF	191.68	191.68	191.68	191.68	249.0
2014-08-06 05:29:00	SPY	ETF	191.6	191.62	191.55	191.56	4243.0
2014-08-06 05:31:00	SPY	ETF	191.55	191.55	191.55	191.55	200.0
2014-08-06 05:33:00	SPY	ETF	191.6	191.6	191.6	191.6	4949.0
2014-08-06 05:34:00	SPY	ETF	191.58	191.58	191.58	191.58	100.0
2014-08-06 05:37:00	SPY	ETF	191.7	191.7	191.7	191.7	1000.0
2014-08-06 05:39:00	SPY	ETF	191.68	191.68	191.68	191.68	1055.0
2014-08-06 05:41:00	SPY	ETF	191.7	191.7	191.7	191.7	1000.0
2014-08-06 05:42:00	SPY	ETF	191.63	191.63	191.54	191.55	8092.0
2014-08-06 05:43:00	SPY	ETF	191.5	191.5	191.5	191.5	2100.0
2014-08-06 05:44:00	SPY	ETF	191.44	191.44	191.44	191.44	200.0
2014-08-06 05:45:00	SPY	ETF	191.53	191.63	191.53	191.63	800.0
2014-08-06 05:52:00	SPY	ETF	191.53	191.53	191.53	191.53	2000.0
2014-08-06 05:54:00	SPY	ETF	191.55	191.55	191.55	191.55	500.0
2014-08-06 05:58:00	SPY	ETF	191.6	191.6	191.6	191.6	1000.0
2014-08-06 06:03:00	SPY	ETF	191.62	191.62	191.62	191.62	500.0
2014-08-06 06:04:00	SPY	ETF	191.58	191.59	191.58	191.59	721.0
2014-08-06 06:05:00	SPY	ETF	191.59	191.6	191.59	191.6	650.0
2014-08-06 06:14:00	SPY	ETF	191.46	191.46	191.46	191.46	300.0
2014-08-06 06:15:00	SPY	ETF	191.45	191.45	191.45	191.45	9800.0
2014-08-06 06:17:00	SPY	ETF	191.44	191.44	191.44	191.44	115.0
2014-08-06 06:18:00	SPY	ETF	191.34	191.34	191.34	191.34	100.0
2014-08-06 06:19:00	SPY	ETF	191.35	191.35	191.3	191.35	3000.0
2014-08-06 06:20:00	SPY	ETF	191.33	191.33	191.27	191.27	82786.0
2014-08-06 06:21:00	SPY	ETF	191.27	191.27	191.22	191.25	13610.0

> showing 50 of 117,246 rows — these rows as CSV

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