PREVIEW / etf_1min / 2012-04-17

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-04-17.parquet
  size:    1.9 MB
  rows:    102,288

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-04-17 04:00:00	SPY	ETF	137.23	137.29	137.23	137.29	1400.0
2012-04-17 04:03:00	SPY	ETF	137.23	137.23	137.23	137.23	400.0
2012-04-17 04:08:00	SPY	ETF	137.2	137.2	137.2	137.2	500.0
2012-04-17 04:20:00	SPY	ETF	137.17	137.17	137.17	137.17	300.0
2012-04-17 04:21:00	SPY	ETF	137.17	137.17	137.17	137.17	200.0
2012-04-17 04:26:00	SPY	ETF	137.2	137.2	137.2	137.2	400.0
2012-04-17 04:28:00	SPY	ETF	137.23	137.23	137.23	137.23	500.0
2012-04-17 04:29:00	SPY	ETF	137.26	137.26	137.26	137.26	500.0
2012-04-17 04:33:00	SPY	ETF	137.29	137.32	137.29	137.32	700.0
2012-04-17 04:34:00	SPY	ETF	137.32	137.32	137.32	137.32	100.0
2012-04-17 04:35:00	SPY	ETF	137.32	137.32	137.32	137.32	200.0
2012-04-17 04:39:00	SPY	ETF	137.35	137.35	137.35	137.35	500.0
2012-04-17 04:40:00	SPY	ETF	137.38	137.39	137.38	137.39	1000.0
2012-04-17 04:47:00	SPY	ETF	137.41	137.44	137.41	137.44	1000.0
2012-04-17 04:55:00	SPY	ETF	137.38	137.38	137.38	137.38	500.0
2012-04-17 04:59:00	SPY	ETF	137.44	137.46	137.44	137.46	600.0
2012-04-17 05:00:00	SPY	ETF	137.47	137.62	137.47	137.62	3800.0
2012-04-17 05:01:00	SPY	ETF	137.62	137.62	137.62	137.62	100.0
2012-04-17 05:08:00	SPY	ETF	137.65	137.65	137.65	137.65	100.0
2012-04-17 05:11:00	SPY	ETF	137.59	137.59	137.59	137.59	100.0
2012-04-17 05:13:00	SPY	ETF	137.59	137.59	137.59	137.59	300.0
2012-04-17 05:17:00	SPY	ETF	137.58	137.58	137.53	137.53	700.0
2012-04-17 05:19:00	SPY	ETF	137.57	137.57	137.57	137.57	5000.0
2012-04-17 05:23:00	SPY	ETF	137.53	137.53	137.5	137.5	1000.0
2012-04-17 05:25:00	SPY	ETF	137.52	137.52	137.52	137.52	200.0
2012-04-17 05:30:00	SPY	ETF	137.54	137.54	137.54	137.54	100.0
2012-04-17 05:31:00	SPY	ETF	137.54	137.54	137.54	137.54	100.0
2012-04-17 05:32:00	SPY	ETF	137.56	137.57	137.56	137.57	5500.0
2012-04-17 05:33:00	SPY	ETF	137.58	137.59	137.58	137.59	600.0
2012-04-17 05:36:00	SPY	ETF	137.59	137.61	137.59	137.61	1250.0
2012-04-17 05:37:00	SPY	ETF	137.62	137.64	137.62	137.64	600.0
2012-04-17 05:41:00	SPY	ETF	137.64	137.64	137.64	137.64	1000.0
2012-04-17 05:47:00	SPY	ETF	137.64	137.67	137.64	137.67	4500.0
2012-04-17 05:49:00	SPY	ETF	137.68	137.71	137.68	137.68	16000.0
2012-04-17 05:50:00	SPY	ETF	137.62	137.62	137.62	137.62	500.0
2012-04-17 05:51:00	SPY	ETF	137.6	137.6	137.59	137.59	600.0
2012-04-17 05:53:00	SPY	ETF	137.58	137.58	137.56	137.56	1100.0
2012-04-17 05:55:00	SPY	ETF	137.53	137.53	137.53	137.53	500.0
2012-04-17 05:56:00	SPY	ETF	137.5	137.5	137.47	137.47	1100.0
2012-04-17 05:57:00	SPY	ETF	137.44	137.44	137.44	137.44	500.0
2012-04-17 05:59:00	SPY	ETF	137.48	137.5	137.44	137.44	10100.0
2012-04-17 06:02:00	SPY	ETF	137.45	137.45	137.45	137.45	500.0
2012-04-17 06:03:00	SPY	ETF	137.44	137.44	137.44	137.44	500.0
2012-04-17 06:10:00	SPY	ETF	137.5	137.52	137.5	137.52	10000.0
2012-04-17 06:18:00	SPY	ETF	137.53	137.53	137.53	137.53	500.0
2012-04-17 06:27:00	SPY	ETF	137.5	137.5	137.5	137.5	25000.0
2012-04-17 06:28:00	SPY	ETF	137.5	137.5	137.5	137.5	10000.0
2012-04-17 06:30:00	SPY	ETF	137.56	137.57	137.56	137.56	4500.0
2012-04-17 06:31:00	SPY	ETF	137.59	137.59	137.59	137.59	500.0
2012-04-17 06:32:00	SPY	ETF	137.62	137.62	137.62	137.62	500.0

> showing 50 of 102,288 rows — these rows as CSV

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