PREVIEW / etf_1min / 2014-04-08

all etf 1-min files

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

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-04-08 04:00:00	SPY	ETF	184.63	184.63	184.63	184.63	820.0
2014-04-08 04:03:00	SPY	ETF	184.6	184.6	184.6	184.6	219.0
2014-04-08 04:06:00	SPY	ETF	184.64	184.64	184.64	184.64	310.0
2014-04-08 04:07:00	SPY	ETF	184.63	184.63	184.63	184.63	120.0
2014-04-08 04:09:00	SPY	ETF	184.62	184.62	184.62	184.62	800.0
2014-04-08 04:11:00	SPY	ETF	184.65	184.65	184.65	184.65	3841.0
2014-04-08 04:13:00	SPY	ETF	184.65	184.65	184.65	184.65	100.0
2014-04-08 04:17:00	SPY	ETF	184.65	184.65	184.65	184.65	400.0
2014-04-08 04:19:00	SPY	ETF	184.62	184.62	184.62	184.62	250.0
2014-04-08 04:23:00	SPY	ETF	184.58	184.58	184.58	184.58	730.0
2014-04-08 04:24:00	SPY	ETF	184.58	184.58	184.58	184.58	700.0
2014-04-08 04:25:00	SPY	ETF	184.58	184.58	184.57	184.57	700.0
2014-04-08 04:31:00	SPY	ETF	184.61	184.61	184.61	184.61	148.0
2014-04-08 04:34:00	SPY	ETF	184.64	184.64	184.64	184.64	230.0
2014-04-08 04:35:00	SPY	ETF	184.61	184.61	184.61	184.61	300.0
2014-04-08 04:38:00	SPY	ETF	184.56	184.56	184.56	184.56	186.0
2014-04-08 04:40:00	SPY	ETF	184.55	184.55	184.55	184.55	900.0
2014-04-08 04:41:00	SPY	ETF	184.55	184.56	184.55	184.56	2300.0
2014-04-08 04:44:00	SPY	ETF	184.58	184.58	184.58	184.58	100.0
2014-04-08 04:46:00	SPY	ETF	184.58	184.58	184.57	184.57	580.0
2014-04-08 04:50:00	SPY	ETF	184.55	184.55	184.55	184.55	100.0
2014-04-08 04:52:00	SPY	ETF	184.54	184.58	184.54	184.58	1000.0
2014-04-08 04:58:00	SPY	ETF	184.46	184.46	184.45	184.45	1200.0
2014-04-08 04:59:00	SPY	ETF	184.44	184.45	184.44	184.45	300.0
2014-04-08 05:00:00	SPY	ETF	184.45	184.45	184.44	184.45	3176.0
2014-04-08 05:04:00	SPY	ETF	184.51	184.51	184.51	184.51	108.0
2014-04-08 05:05:00	SPY	ETF	184.51	184.51	184.51	184.51	700.0
2014-04-08 05:06:00	SPY	ETF	184.53	184.53	184.53	184.53	590.0
2014-04-08 05:07:00	SPY	ETF	184.48	184.48	184.48	184.48	1011.0
2014-04-08 05:09:00	SPY	ETF	184.48	184.48	184.48	184.48	100.0
2014-04-08 05:11:00	SPY	ETF	184.46	184.46	184.46	184.46	100.0
2014-04-08 05:13:00	SPY	ETF	184.46	184.46	184.46	184.46	600.0
2014-04-08 05:15:00	SPY	ETF	184.48	184.49	184.48	184.49	519.0
2014-04-08 05:22:00	SPY	ETF	184.43	184.43	184.43	184.43	477.0
2014-04-08 05:24:00	SPY	ETF	184.4	184.4	184.4	184.4	1032.0
2014-04-08 05:25:00	SPY	ETF	184.41	184.41	184.41	184.41	168.0
2014-04-08 05:34:00	SPY	ETF	184.4	184.4	184.38	184.38	765.0
2014-04-08 05:35:00	SPY	ETF	184.36	184.36	184.36	184.36	249.0
2014-04-08 05:36:00	SPY	ETF	184.35	184.35	184.35	184.35	1000.0
2014-04-08 05:38:00	SPY	ETF	184.38	184.38	184.38	184.38	1600.0
2014-04-08 05:39:00	SPY	ETF	184.36	184.38	184.36	184.38	49100.0
2014-04-08 05:40:00	SPY	ETF	184.36	184.38	184.36	184.38	1011.0
2014-04-08 05:42:00	SPY	ETF	184.31	184.33	184.31	184.33	600.0
2014-04-08 05:44:00	SPY	ETF	184.36	184.36	184.36	184.36	100.0
2014-04-08 05:47:00	SPY	ETF	184.33	184.33	184.32	184.32	2000.0
2014-04-08 05:50:00	SPY	ETF	184.36	184.36	184.36	184.36	100.0
2014-04-08 05:54:00	SPY	ETF	184.36	184.38	184.36	184.38	700.0
2014-04-08 05:56:00	SPY	ETF	184.33	184.33	184.26	184.26	1550.0
2014-04-08 05:59:00	SPY	ETF	184.25	184.25	184.25	184.25	215.0
2014-04-08 06:01:00	SPY	ETF	184.3	184.3	184.3	184.3	100.0

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

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