PREVIEW / etf_1min / 2014-01-17

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-01-17.parquet
  size:    2.2 MB
  rows:    117,836

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-01-17 04:04:00	SPY	ETF	184.12	184.12	184.12	184.12	100.0
2014-01-17 04:07:00	SPY	ETF	184.12	184.12	184.12	184.12	300.0
2014-01-17 04:08:00	SPY	ETF	184.14	184.14	184.14	184.14	300.0
2014-01-17 04:13:00	SPY	ETF	184.19	184.22	184.19	184.22	10200.0
2014-01-17 04:27:00	SPY	ETF	184.2	184.2	184.2	184.2	100.0
2014-01-17 04:28:00	SPY	ETF	184.18	184.18	184.18	184.18	149.0
2014-01-17 04:30:00	SPY	ETF	184.18	184.18	184.18	184.18	1500.0
2014-01-17 04:31:00	SPY	ETF	184.17	184.17	184.17	184.17	100.0
2014-01-17 04:34:00	SPY	ETF	184.2	184.2	184.2	184.2	100.0
2014-01-17 04:35:00	SPY	ETF	184.2	184.2	184.2	184.2	226.0
2014-01-17 04:38:00	SPY	ETF	184.25	184.25	184.25	184.25	100.0
2014-01-17 04:52:00	SPY	ETF	184.28	184.28	184.28	184.28	100.0
2014-01-17 05:00:00	SPY	ETF	184.3	184.3	184.3	184.3	150.0
2014-01-17 05:03:00	SPY	ETF	184.36	184.36	184.36	184.36	100.0
2014-01-17 05:07:00	SPY	ETF	184.4	184.4	184.4	184.4	2004.0
2014-01-17 05:11:00	SPY	ETF	184.4	184.4	184.4	184.4	500.0
2014-01-17 05:13:00	SPY	ETF	184.42	184.42	184.42	184.42	110.0
2014-01-17 05:14:00	SPY	ETF	184.42	184.5	184.42	184.5	550.0
2014-01-17 05:27:00	SPY	ETF	184.55	184.55	184.55	184.55	600.0
2014-01-17 05:28:00	SPY	ETF	184.56	184.56	184.56	184.56	100.0
2014-01-17 05:32:00	SPY	ETF	184.56	184.56	184.56	184.56	200.0
2014-01-17 05:33:00	SPY	ETF	184.56	184.56	184.56	184.56	100.0
2014-01-17 05:37:00	SPY	ETF	184.57	184.61	184.57	184.6	1350.0
2014-01-17 05:39:00	SPY	ETF	184.63	184.63	184.63	184.63	100.0
2014-01-17 05:45:00	SPY	ETF	184.62	184.62	184.62	184.62	116.0
2014-01-17 05:46:00	SPY	ETF	184.56	184.56	184.56	184.56	200.0
2014-01-17 05:47:00	SPY	ETF	184.56	184.58	184.56	184.58	602.0
2014-01-17 05:48:00	SPY	ETF	184.59	184.59	184.59	184.59	191.0
2014-01-17 05:49:00	SPY	ETF	184.56	184.58	184.56	184.58	1300.0
2014-01-17 05:50:00	SPY	ETF	184.56	184.56	184.56	184.56	500.0
2014-01-17 05:51:00	SPY	ETF	184.57	184.57	184.57	184.57	100.0
2014-01-17 06:04:00	SPY	ETF	184.57	184.57	184.57	184.57	100.0
2014-01-17 06:05:00	SPY	ETF	184.54	184.54	184.54	184.54	500.0
2014-01-17 06:06:00	SPY	ETF	184.53	184.53	184.53	184.53	32095.0
2014-01-17 06:09:00	SPY	ETF	184.55	184.55	184.55	184.55	200.0
2014-01-17 06:14:00	SPY	ETF	184.56	184.56	184.56	184.56	100.0
2014-01-17 06:19:00	SPY	ETF	184.57	184.57	184.57	184.57	1500.0
2014-01-17 06:22:00	SPY	ETF	184.57	184.57	184.57	184.57	500.0
2014-01-17 06:25:00	SPY	ETF	184.59	184.6	184.59	184.6	5000.0
2014-01-17 06:26:00	SPY	ETF	184.57	184.57	184.55	184.55	600.0
2014-01-17 06:37:00	SPY	ETF	184.56	184.58	184.56	184.58	2635.0
2014-01-17 06:41:00	SPY	ETF	184.55	184.55	184.54	184.54	300.0
2014-01-17 06:42:00	SPY	ETF	184.56	184.56	184.56	184.56	100.0
2014-01-17 06:43:00	SPY	ETF	184.59	184.59	184.59	184.59	400.0
2014-01-17 06:47:00	SPY	ETF	184.61	184.62	184.61	184.62	376.0
2014-01-17 06:48:00	SPY	ETF	184.61	184.61	184.61	184.61	4620.0
2014-01-17 06:49:00	SPY	ETF	184.59	184.59	184.59	184.59	200.0
2014-01-17 06:50:00	SPY	ETF	184.59	184.59	184.59	184.59	400.0
2014-01-17 06:51:00	SPY	ETF	184.61	184.61	184.61	184.61	1006.0
2014-01-17 06:53:00	SPY	ETF	184.61	184.61	184.61	184.61	150.0

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

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