PREVIEW / etf_1min / 2017-03-17

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-03-17.parquet
  size:    2.6 MB
  rows:    138,969

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-03-17 04:00:00	SPY	ETF	237.42	237.43	237.3	237.3	4075.0
2017-03-17 04:01:00	SPY	ETF	237.32	237.32	237.32	237.32	100.0
2017-03-17 04:05:00	SPY	ETF	237.35	237.35	237.35	237.35	600.0
2017-03-17 04:07:00	SPY	ETF	237.3	237.3	237.3	237.3	1450.0
2017-03-17 04:08:00	SPY	ETF	237.35	237.35	237.35	237.35	300.0
2017-03-17 04:16:00	SPY	ETF	237.38	237.38	237.38	237.38	800.0
2017-03-17 04:19:00	SPY	ETF	237.32	237.32	237.28	237.28	600.0
2017-03-17 04:23:00	SPY	ETF	237.31	237.31	237.31	237.31	950.0
2017-03-17 04:37:00	SPY	ETF	237.33	237.4	237.33	237.33	1210.0
2017-03-17 04:40:00	SPY	ETF	237.35	237.43	237.35	237.35	1200.0
2017-03-17 04:41:00	SPY	ETF	237.35	237.35	237.35	237.35	1000.0
2017-03-17 04:43:00	SPY	ETF	237.4	237.42	237.4	237.4	700.0
2017-03-17 04:49:00	SPY	ETF	237.34	237.34	237.34	237.34	500.0
2017-03-17 04:51:00	SPY	ETF	237.4	237.4	237.4	237.4	400.0
2017-03-17 05:01:00	SPY	ETF	237.4	237.4	237.4	237.4	103.0
2017-03-17 05:06:00	SPY	ETF	237.45	237.45	237.45	237.45	200.0
2017-03-17 05:09:00	SPY	ETF	237.45	237.45	237.45	237.45	302.0
2017-03-17 05:17:00	SPY	ETF	237.5	237.5	237.5	237.5	300.0
2017-03-17 05:23:00	SPY	ETF	237.47	237.47	237.47	237.47	695.0
2017-03-17 05:24:00	SPY	ETF	237.5	237.5	237.5	237.5	311.0
2017-03-17 05:27:00	SPY	ETF	237.5	237.53	237.5	237.53	600.0
2017-03-17 05:44:00	SPY	ETF	237.48	237.48	237.48	237.48	3000.0
2017-03-17 05:48:00	SPY	ETF	237.47	237.47	237.47	237.47	700.0
2017-03-17 06:03:00	SPY	ETF	237.45	237.45	237.45	237.45	100.0
2017-03-17 06:23:00	SPY	ETF	237.52	237.52	237.51	237.51	5302.0
2017-03-17 06:29:00	SPY	ETF	237.47	237.47	237.47	237.47	245.0
2017-03-17 06:31:00	SPY	ETF	237.45	237.45	237.45	237.45	253.0
2017-03-17 06:38:00	SPY	ETF	237.47	237.47	237.47	237.47	1400.0
2017-03-17 06:39:00	SPY	ETF	237.47	237.47	237.44	237.44	1300.0
2017-03-17 06:53:00	SPY	ETF	237.59	237.59	237.59	237.59	200.0
2017-03-17 06:55:00	SPY	ETF	237.59	237.59	237.59	237.59	330.0
2017-03-17 06:59:00	SPY	ETF	237.57	237.57	237.57	237.57	100.0
2017-03-17 07:00:00	SPY	ETF	237.57	237.57	237.57	237.57	2003.0
2017-03-17 07:01:00	SPY	ETF	237.71	237.73	237.71	237.73	25019.0
2017-03-17 07:05:00	SPY	ETF	237.71	237.74	237.71	237.74	20000.0
2017-03-17 07:12:00	SPY	ETF	237.68	237.68	237.68	237.68	400.0
2017-03-17 07:16:00	SPY	ETF	237.68	237.69	237.68	237.69	20000.0
2017-03-17 07:21:00	SPY	ETF	237.64	237.64	237.63	237.63	602.0
2017-03-17 07:22:00	SPY	ETF	237.62	237.62	237.61	237.61	1801.0
2017-03-17 07:25:00	SPY	ETF	237.61	237.61	237.61	237.61	200.0
2017-03-17 07:27:00	SPY	ETF	237.6	237.6	237.56	237.58	3051.0
2017-03-17 07:28:00	SPY	ETF	237.62	237.62	237.62	237.62	1001.0
2017-03-17 07:29:00	SPY	ETF	237.61	237.61	237.61	237.61	578.0
2017-03-17 07:31:00	SPY	ETF	237.63	237.63	237.6	237.6	4700.0
2017-03-17 07:32:00	SPY	ETF	237.62	237.68	237.62	237.63	3479.0
2017-03-17 07:35:00	SPY	ETF	237.56	237.58	237.56	237.58	2103.0
2017-03-17 07:41:00	SPY	ETF	237.56	237.56	237.56	237.56	231.0
2017-03-17 07:42:00	SPY	ETF	237.58	237.59	237.58	237.59	2500.0
2017-03-17 07:43:00	SPY	ETF	237.59	237.59	237.59	237.59	101.0
2017-03-17 07:44:00	SPY	ETF	237.55	237.55	237.55	237.55	300.0

> showing 50 of 138,969 rows — these rows as CSV

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