PREVIEW / etf_1min / 2012-11-07

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-11-07.parquet
  size:    2.3 MB
  rows:    118,906

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
2012-11-07 04:01:00	SPY	ETF	143.36	143.36	143.36	143.36	250.0
2012-11-07 04:03:00	SPY	ETF	143.36	143.36	143.36	143.36	250.0
2012-11-07 04:04:00	SPY	ETF	143.44	143.44	143.44	143.44	25000.0
2012-11-07 04:06:00	SPY	ETF	143.39	143.39	143.39	143.39	1024.0
2012-11-07 04:10:00	SPY	ETF	143.44	143.44	143.44	143.44	500.0
2012-11-07 04:19:00	SPY	ETF	143.33	143.33	143.31	143.31	1100.0
2012-11-07 04:20:00	SPY	ETF	143.34	143.34	143.34	143.34	1000.0
2012-11-07 04:22:00	SPY	ETF	143.28	143.28	143.28	143.28	100.0
2012-11-07 04:25:00	SPY	ETF	143.36	143.36	143.36	143.36	1000.0
2012-11-07 04:26:00	SPY	ETF	143.28	143.28	143.28	143.28	1000.0
2012-11-07 04:41:00	SPY	ETF	143.28	143.28	143.28	143.28	100.0
2012-11-07 04:46:00	SPY	ETF	143.28	143.28	143.28	143.28	100.0
2012-11-07 04:55:00	SPY	ETF	143.45	143.48	143.45	143.48	18500.0
2012-11-07 05:00:00	SPY	ETF	143.45	143.45	143.45	143.45	2454.0
2012-11-07 05:01:00	SPY	ETF	143.45	143.45	143.45	143.45	200.0
2012-11-07 05:07:00	SPY	ETF	143.56	143.56	143.56	143.56	1000.0
2012-11-07 05:12:00	SPY	ETF	143.55	143.55	143.55	143.55	4000.0
2012-11-07 05:17:00	SPY	ETF	143.57	143.57	143.57	143.57	200.0
2012-11-07 05:19:00	SPY	ETF	143.59	143.61	143.59	143.61	500.0
2012-11-07 05:20:00	SPY	ETF	143.57	143.58	143.57	143.58	300.0
2012-11-07 05:29:00	SPY	ETF	143.5	143.5	143.5	143.5	700.0
2012-11-07 05:30:00	SPY	ETF	143.55	143.55	143.55	143.55	1000.0
2012-11-07 05:32:00	SPY	ETF	143.63	143.63	143.6	143.6	700.0
2012-11-07 05:42:00	SPY	ETF	143.55	143.55	143.55	143.55	700.0
2012-11-07 05:43:00	SPY	ETF	143.55	143.55	143.55	143.55	300.0
2012-11-07 05:45:00	SPY	ETF	143.53	143.53	143.53	143.53	100.0
2012-11-07 05:46:00	SPY	ETF	143.5	143.5	143.5	143.5	100.0
2012-11-07 05:47:00	SPY	ETF	143.48	143.48	143.45	143.45	2500.0
2012-11-07 05:52:00	SPY	ETF	143.45	143.45	143.45	143.45	100.0
2012-11-07 05:56:00	SPY	ETF	143.43	143.43	143.43	143.43	1000.0
2012-11-07 05:57:00	SPY	ETF	143.45	143.45	143.45	143.45	500.0
2012-11-07 06:00:00	SPY	ETF	143.35	143.38	143.35	143.38	1200.0
2012-11-07 06:01:00	SPY	ETF	143.38	143.38	143.38	143.38	500.0
2012-11-07 06:02:00	SPY	ETF	143.33	143.33	143.33	143.33	1500.0
2012-11-07 06:03:00	SPY	ETF	143.35	143.4	143.35	143.4	200.0
2012-11-07 06:08:00	SPY	ETF	143.3	143.3	143.3	143.3	1000.0
2012-11-07 06:09:00	SPY	ETF	143.29	143.31	143.29	143.3	1500.0
2012-11-07 06:10:00	SPY	ETF	143.27	143.27	143.27	143.27	1000.0
2012-11-07 06:11:00	SPY	ETF	143.29	143.29	143.29	143.29	500.0
2012-11-07 06:12:00	SPY	ETF	143.32	143.32	143.32	143.32	5000.0
2012-11-07 06:13:00	SPY	ETF	143.35	143.35	143.35	143.35	1000.0
2012-11-07 06:17:00	SPY	ETF	143.28	143.28	143.28	143.28	7500.0
2012-11-07 06:18:00	SPY	ETF	143.25	143.25	143.2	143.23	2800.0
2012-11-07 06:19:00	SPY	ETF	143.22	143.22	143.22	143.22	5182.0
2012-11-07 06:20:00	SPY	ETF	143.22	143.22	143.22	143.22	5000.0
2012-11-07 06:21:00	SPY	ETF	143.18	143.18	143.15	143.15	1600.0
2012-11-07 06:22:00	SPY	ETF	143.12	143.12	143.12	143.12	126.0
2012-11-07 06:23:00	SPY	ETF	143.12	143.12	143.12	143.12	200.0
2012-11-07 06:24:00	SPY	ETF	143.12	143.12	143.1	143.1	26500.0
2012-11-07 06:26:00	SPY	ETF	143.07	143.07	143.07	143.07	100.0

> showing 50 of 118,906 rows — these rows as CSV

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