PREVIEW / etf_1min / 2017-01-10

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-10.parquet
  size:    2.8 MB
  rows:    147,762

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
2017-01-10 04:00:00	SPY	ETF	226.46	226.46	226.46	226.46	100.0
2017-01-10 04:03:00	SPY	ETF	226.4	226.4	226.4	226.4	194.0
2017-01-10 04:12:00	SPY	ETF	226.42	226.42	226.42	226.42	103.0
2017-01-10 04:13:00	SPY	ETF	226.42	226.42	226.42	226.42	102.0
2017-01-10 04:27:00	SPY	ETF	226.47	226.47	226.47	226.47	102.0
2017-01-10 05:13:00	SPY	ETF	226.53	226.53	226.53	226.53	101.0
2017-01-10 05:25:00	SPY	ETF	226.57	226.61	226.57	226.61	304.0
2017-01-10 05:28:00	SPY	ETF	226.66	226.66	226.66	226.66	1002.0
2017-01-10 05:30:00	SPY	ETF	226.69	226.7	226.69	226.7	201.0
2017-01-10 05:34:00	SPY	ETF	226.67	226.67	226.67	226.67	103.0
2017-01-10 05:35:00	SPY	ETF	226.68	226.68	226.68	226.68	200.0
2017-01-10 05:38:00	SPY	ETF	226.68	226.68	226.68	226.68	1100.0
2017-01-10 05:42:00	SPY	ETF	226.63	226.63	226.63	226.63	2304.0
2017-01-10 05:59:00	SPY	ETF	226.66	226.66	226.66	226.66	251.0
2017-01-10 06:32:00	SPY	ETF	226.63	226.63	226.63	226.63	100.0
2017-01-10 06:44:00	SPY	ETF	226.69	226.69	226.69	226.69	302.0
2017-01-10 06:48:00	SPY	ETF	226.69	226.69	226.69	226.69	500.0
2017-01-10 06:58:00	SPY	ETF	226.61	226.61	226.61	226.61	400.0
2017-01-10 07:01:00	SPY	ETF	226.55	226.56	226.55	226.56	2100.0
2017-01-10 07:02:00	SPY	ETF	226.55	226.55	226.55	226.55	500.0
2017-01-10 07:09:00	SPY	ETF	226.62	226.62	226.62	226.62	1500.0
2017-01-10 07:11:00	SPY	ETF	226.62	226.62	226.62	226.62	301.0
2017-01-10 07:16:00	SPY	ETF	226.63	226.63	226.63	226.63	150.0
2017-01-10 07:19:00	SPY	ETF	226.61	226.61	226.61	226.61	300.0
2017-01-10 07:22:00	SPY	ETF	226.62	226.62	226.62	226.62	2600.0
2017-01-10 07:28:00	SPY	ETF	226.61	226.61	226.61	226.61	300.0
2017-01-10 07:30:00	SPY	ETF	226.59	226.59	226.59	226.59	100.0
2017-01-10 07:31:00	SPY	ETF	226.61	226.61	226.61	226.61	400.0
2017-01-10 07:32:00	SPY	ETF	226.64	226.64	226.64	226.64	4600.0
2017-01-10 07:34:00	SPY	ETF	226.63	226.63	226.63	226.63	10000.0
2017-01-10 07:41:00	SPY	ETF	226.63	226.63	226.63	226.63	470.0
2017-01-10 07:44:00	SPY	ETF	226.61	226.61	226.61	226.61	500.0
2017-01-10 07:46:00	SPY	ETF	226.58	226.58	226.58	226.58	502.0
2017-01-10 07:48:00	SPY	ETF	226.61	226.61	226.61	226.61	316.0
2017-01-10 07:49:00	SPY	ETF	226.59	226.59	226.59	226.59	5801.0
2017-01-10 07:50:00	SPY	ETF	226.59	226.59	226.59	226.59	200.0
2017-01-10 07:51:00	SPY	ETF	226.59	226.61	226.59	226.59	35296.0
2017-01-10 07:54:00	SPY	ETF	226.62	226.62	226.62	226.62	300.0
2017-01-10 07:57:00	SPY	ETF	226.56	226.56	226.56	226.56	500.0
2017-01-10 07:58:00	SPY	ETF	226.55	226.55	226.55	226.55	1503.0
2017-01-10 07:59:00	SPY	ETF	226.48	226.48	226.48	226.48	400.0
2017-01-10 08:00:00	SPY	ETF	226.6	226.61	226.49	226.51	16819.0
2017-01-10 08:02:00	SPY	ETF	226.46	226.47	226.46	226.47	1650.0
2017-01-10 08:03:00	SPY	ETF	226.47	226.47	226.47	226.47	200.0
2017-01-10 08:05:00	SPY	ETF	226.5	226.5	226.49	226.49	10347.0
2017-01-10 08:06:00	SPY	ETF	226.5	226.52	226.5	226.52	5189.0
2017-01-10 08:07:00	SPY	ETF	226.52	226.52	226.52	226.52	100.0
2017-01-10 08:11:00	SPY	ETF	226.54	226.54	226.54	226.54	1750.0
2017-01-10 08:12:00	SPY	ETF	226.54	226.54	226.54	226.54	401.0
2017-01-10 08:13:00	SPY	ETF	226.56	226.56	226.56	226.56	100.0

> showing 50 of 147,762 rows — these rows as CSV

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