PREVIEW / etf_1min / 2012-11-13

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-11-13.parquet
  size:    1.9 MB
  rows:    100,613

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-13 04:00:00	SPY	ETF	137.4	137.42	137.4	137.41	972.0
2012-11-13 04:02:00	SPY	ETF	137.41	137.41	137.41	137.41	100.0
2012-11-13 04:03:00	SPY	ETF	137.47	137.47	137.47	137.47	300.0
2012-11-13 04:04:00	SPY	ETF	137.47	137.5	137.47	137.5	60628.0
2012-11-13 04:06:00	SPY	ETF	137.51	137.51	137.5	137.5	40752.0
2012-11-13 04:07:00	SPY	ETF	137.53	137.54	137.53	137.54	8200.0
2012-11-13 04:09:00	SPY	ETF	137.58	137.58	137.58	137.58	200.0
2012-11-13 04:10:00	SPY	ETF	137.58	137.67	137.58	137.67	1100.0
2012-11-13 04:11:00	SPY	ETF	137.71	137.72	137.71	137.72	6800.0
2012-11-13 04:12:00	SPY	ETF	137.66	137.66	137.66	137.66	90700.0
2012-11-13 04:13:00	SPY	ETF	137.65	137.66	137.65	137.66	46200.0
2012-11-13 04:14:00	SPY	ETF	137.66	137.66	137.66	137.66	10000.0
2012-11-13 04:19:00	SPY	ETF	137.7	137.7	137.7	137.7	100.0
2012-11-13 04:22:00	SPY	ETF	137.74	137.74	137.74	137.74	1000.0
2012-11-13 04:23:00	SPY	ETF	137.75	137.75	137.74	137.74	600.0
2012-11-13 04:26:00	SPY	ETF	137.76	137.76	137.76	137.76	50376.0
2012-11-13 04:27:00	SPY	ETF	137.76	137.76	137.76	137.76	500.0
2012-11-13 04:31:00	SPY	ETF	137.76	137.76	137.76	137.76	49076.0
2012-11-13 04:32:00	SPY	ETF	137.74	137.74	137.74	137.74	100.0
2012-11-13 04:34:00	SPY	ETF	137.74	137.74	137.74	137.74	1000.0
2012-11-13 04:35:00	SPY	ETF	137.74	137.74	137.74	137.74	41600.0
2012-11-13 04:39:00	SPY	ETF	137.7	137.7	137.7	137.7	500.0
2012-11-13 05:01:00	SPY	ETF	137.6	137.6	137.6	137.6	500.0
2012-11-13 05:08:00	SPY	ETF	137.6	137.6	137.6	137.6	100.0
2012-11-13 05:09:00	SPY	ETF	137.6	137.6	137.6	137.6	500.0
2012-11-13 05:10:00	SPY	ETF	137.54	137.54	137.54	137.54	300.0
2012-11-13 05:13:00	SPY	ETF	137.55	137.55	137.55	137.55	300.0
2012-11-13 05:16:00	SPY	ETF	137.44	137.44	137.44	137.44	5400.0
2012-11-13 05:17:00	SPY	ETF	137.44	137.44	137.44	137.44	6000.0
2012-11-13 05:19:00	SPY	ETF	137.44	137.44	137.44	137.44	8200.0
2012-11-13 05:20:00	SPY	ETF	137.5	137.5	137.5	137.5	400.0
2012-11-13 05:22:00	SPY	ETF	137.51	137.51	137.51	137.51	1200.0
2012-11-13 05:23:00	SPY	ETF	137.51	137.51	137.51	137.51	5800.0
2012-11-13 05:25:00	SPY	ETF	137.47	137.47	137.47	137.47	100.0
2012-11-13 05:28:00	SPY	ETF	137.48	137.48	137.48	137.48	200.0
2012-11-13 05:30:00	SPY	ETF	137.48	137.48	137.48	137.48	100.0
2012-11-13 05:32:00	SPY	ETF	137.54	137.54	137.54	137.54	100.0
2012-11-13 05:33:00	SPY	ETF	137.58	137.58	137.56	137.56	300.0
2012-11-13 05:36:00	SPY	ETF	137.56	137.56	137.56	137.56	200.0
2012-11-13 05:40:00	SPY	ETF	137.57	137.57	137.57	137.57	125.0
2012-11-13 05:43:00	SPY	ETF	137.55	137.55	137.55	137.55	100.0
2012-11-13 05:47:00	SPY	ETF	137.56	137.56	137.56	137.56	200.0
2012-11-13 05:48:00	SPY	ETF	137.55	137.58	137.55	137.58	5500.0
2012-11-13 05:50:00	SPY	ETF	137.54	137.54	137.53	137.53	200.0
2012-11-13 05:54:00	SPY	ETF	137.56	137.57	137.56	137.57	15000.0
2012-11-13 05:55:00	SPY	ETF	137.52	137.52	137.49	137.49	900.0
2012-11-13 05:56:00	SPY	ETF	137.53	137.53	137.53	137.53	4400.0
2012-11-13 05:57:00	SPY	ETF	137.5	137.5	137.5	137.5	5000.0
2012-11-13 05:58:00	SPY	ETF	137.49	137.49	137.48	137.48	5200.0
2012-11-13 05:59:00	SPY	ETF	137.47	137.47	137.46	137.46	200.0

> showing 50 of 100,613 rows — these rows as CSV

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