PREVIEW / etf_1min / 2017-09-06

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-09-06.parquet
  size:    2.6 MB
  rows:    135,389

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-09-06 04:00:00	SPY	ETF	246.65	246.68	246.65	246.66	2510.0
2017-09-06 04:12:00	SPY	ETF	246.62	246.62	246.62	246.62	7000.0
2017-09-06 04:16:00	SPY	ETF	246.51	246.51	246.51	246.51	100.0
2017-09-06 04:31:00	SPY	ETF	246.41	246.41	246.41	246.41	103.0
2017-09-06 04:38:00	SPY	ETF	246.49	246.49	246.49	246.49	109.0
2017-09-06 04:40:00	SPY	ETF	246.57	246.57	246.57	246.57	100.0
2017-09-06 04:44:00	SPY	ETF	246.6	246.6	246.6	246.6	550.0
2017-09-06 04:48:00	SPY	ETF	246.57	246.57	246.57	246.57	100.0
2017-09-06 04:49:00	SPY	ETF	246.54	246.54	246.54	246.54	100.0
2017-09-06 04:57:00	SPY	ETF	246.56	246.56	246.56	246.56	301.0
2017-09-06 05:00:00	SPY	ETF	246.51	246.51	246.51	246.51	304.0
2017-09-06 05:01:00	SPY	ETF	246.49	246.49	246.49	246.49	300.0
2017-09-06 05:07:00	SPY	ETF	246.42	246.42	246.42	246.42	103.0
2017-09-06 05:14:00	SPY	ETF	246.38	246.38	246.38	246.38	303.0
2017-09-06 05:22:00	SPY	ETF	246.38	246.38	246.38	246.38	300.0
2017-09-06 05:37:00	SPY	ETF	246.44	246.44	246.44	246.44	303.0
2017-09-06 05:39:00	SPY	ETF	246.35	246.35	246.22	246.22	4617.0
2017-09-06 05:41:00	SPY	ETF	246.16	246.16	246.16	246.16	2008.0
2017-09-06 05:42:00	SPY	ETF	246.11	246.11	246.11	246.11	176.0
2017-09-06 05:43:00	SPY	ETF	246.3	246.3	246.26	246.26	1091.0
2017-09-06 06:02:00	SPY	ETF	246.46	246.47	246.46	246.47	602.0
2017-09-06 06:03:00	SPY	ETF	246.47	246.47	246.47	246.47	300.0
2017-09-06 06:04:00	SPY	ETF	246.45	246.47	246.45	246.47	302.0
2017-09-06 06:31:00	SPY	ETF	246.31	246.31	246.31	246.31	303.0
2017-09-06 06:35:00	SPY	ETF	246.34	246.34	246.34	246.34	501.0
2017-09-06 06:46:00	SPY	ETF	246.37	246.37	246.35	246.35	602.0
2017-09-06 06:48:00	SPY	ETF	246.42	246.44	246.42	246.44	699.0
2017-09-06 06:50:00	SPY	ETF	246.36	246.36	246.36	246.36	304.0
2017-09-06 06:53:00	SPY	ETF	246.31	246.31	246.28	246.28	3000.0
2017-09-06 06:56:00	SPY	ETF	246.3	246.3	246.3	246.3	1000.0
2017-09-06 06:57:00	SPY	ETF	246.31	246.31	246.31	246.31	1500.0
2017-09-06 07:01:00	SPY	ETF	246.37	246.37	246.37	246.37	2002.0
2017-09-06 07:02:00	SPY	ETF	246.4	246.4	246.38	246.38	400.0
2017-09-06 07:03:00	SPY	ETF	246.4	246.42	246.4	246.42	2200.0
2017-09-06 07:06:00	SPY	ETF	246.43	246.43	246.43	246.43	100.0
2017-09-06 07:07:00	SPY	ETF	246.4	246.4	246.4	246.4	1800.0
2017-09-06 07:11:00	SPY	ETF	246.4	246.43	246.4	246.43	3000.0
2017-09-06 07:13:00	SPY	ETF	246.4	246.4	246.4	246.4	301.0
2017-09-06 07:18:00	SPY	ETF	246.41	246.41	246.39	246.39	30001.0
2017-09-06 07:21:00	SPY	ETF	246.42	246.42	246.42	246.42	1000.0
2017-09-06 07:23:00	SPY	ETF	246.44	246.44	246.44	246.44	5000.0
2017-09-06 07:24:00	SPY	ETF	246.44	246.44	246.44	246.44	602.0
2017-09-06 07:25:00	SPY	ETF	246.48	246.48	246.48	246.48	801.0
2017-09-06 07:26:00	SPY	ETF	246.48	246.48	246.48	246.48	501.0
2017-09-06 07:27:00	SPY	ETF	246.47	246.47	246.47	246.47	500.0
2017-09-06 07:28:00	SPY	ETF	246.49	246.49	246.49	246.49	800.0
2017-09-06 07:29:00	SPY	ETF	246.49	246.5	246.49	246.5	605.0
2017-09-06 07:30:00	SPY	ETF	246.52	246.52	246.52	246.52	5104.0
2017-09-06 07:31:00	SPY	ETF	246.53	246.53	246.53	246.53	146.0
2017-09-06 07:32:00	SPY	ETF	246.59	246.59	246.59	246.59	503.0

> showing 50 of 135,389 rows — these rows as CSV

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