PREVIEW / etf_1min / 2017-03-22

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-03-22.parquet
  size:    2.9 MB
  rows:    154,655

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-22 04:00:00	SPY	ETF	233.33	233.33	233.33	233.33	629.0
2017-03-22 04:01:00	SPY	ETF	233.33	233.33	233.33	233.33	200.0
2017-03-22 04:03:00	SPY	ETF	233.31	233.31	233.31	233.31	200.0
2017-03-22 04:04:00	SPY	ETF	233.27	233.27	233.2	233.2	660.0
2017-03-22 04:05:00	SPY	ETF	233.3	233.3	233.25	233.25	1000.0
2017-03-22 04:06:00	SPY	ETF	233.28	233.28	233.24	233.24	2300.0
2017-03-22 04:07:00	SPY	ETF	233.24	233.24	233.24	233.24	100.0
2017-03-22 04:08:00	SPY	ETF	233.26	233.26	233.23	233.23	814.0
2017-03-22 04:09:00	SPY	ETF	233.18	233.18	233.17	233.17	901.0
2017-03-22 04:10:00	SPY	ETF	233.14	233.14	233.14	233.14	100.0
2017-03-22 04:11:00	SPY	ETF	233.13	233.13	233.13	233.13	351.0
2017-03-22 04:12:00	SPY	ETF	233.14	233.14	233.14	233.14	805.0
2017-03-22 04:13:00	SPY	ETF	233.2	233.21	233.2	233.21	1818.0
2017-03-22 04:15:00	SPY	ETF	233.38	233.59	233.38	233.59	5883.0
2017-03-22 04:16:00	SPY	ETF	233.68	233.76	233.68	233.76	5383.0
2017-03-22 04:17:00	SPY	ETF	233.75	233.76	233.67	233.67	2020.0
2017-03-22 04:18:00	SPY	ETF	233.65	233.65	233.65	233.65	501.0
2017-03-22 04:20:00	SPY	ETF	233.63	233.63	233.63	233.63	1500.0
2017-03-22 04:25:00	SPY	ETF	233.61	233.61	233.61	233.61	308.0
2017-03-22 04:26:00	SPY	ETF	233.59	233.59	233.59	233.59	800.0
2017-03-22 04:29:00	SPY	ETF	233.53	233.54	233.53	233.54	600.0
2017-03-22 04:30:00	SPY	ETF	233.52	233.52	233.52	233.52	800.0
2017-03-22 04:31:00	SPY	ETF	233.49	233.49	233.49	233.49	104.0
2017-03-22 04:32:00	SPY	ETF	233.52	233.52	233.49	233.49	2102.0
2017-03-22 04:33:00	SPY	ETF	233.5	233.5	233.5	233.5	200.0
2017-03-22 04:34:00	SPY	ETF	233.47	233.47	233.47	233.47	105.0
2017-03-22 04:35:00	SPY	ETF	233.41	233.41	233.41	233.41	1702.0
2017-03-22 04:36:00	SPY	ETF	233.4	233.4	233.4	233.4	200.0
2017-03-22 04:37:00	SPY	ETF	233.37	233.37	233.37	233.37	200.0
2017-03-22 04:40:00	SPY	ETF	233.36	233.38	233.32	233.38	1003.0
2017-03-22 04:44:00	SPY	ETF	233.25	233.25	233.25	233.25	112.0
2017-03-22 04:49:00	SPY	ETF	233.27	233.27	233.2	233.24	908.0
2017-03-22 04:50:00	SPY	ETF	233.24	233.24	233.24	233.24	302.0
2017-03-22 04:51:00	SPY	ETF	233.23	233.23	233.23	233.23	404.0
2017-03-22 04:52:00	SPY	ETF	233.25	233.25	233.25	233.25	503.0
2017-03-22 04:55:00	SPY	ETF	233.46	233.46	233.46	233.46	104.0
2017-03-22 05:01:00	SPY	ETF	233.33	233.33	233.33	233.33	197.0
2017-03-22 05:04:00	SPY	ETF	233.23	233.23	233.2	233.2	405.0
2017-03-22 05:05:00	SPY	ETF	233.21	233.21	233.21	233.21	103.0
2017-03-22 05:08:00	SPY	ETF	233.47	233.53	233.47	233.53	709.0
2017-03-22 05:09:00	SPY	ETF	233.55	233.55	233.55	233.55	100.0
2017-03-22 05:10:00	SPY	ETF	233.47	233.47	233.47	233.47	1504.0
2017-03-22 05:12:00	SPY	ETF	233.53	233.55	233.46	233.46	1713.0
2017-03-22 05:13:00	SPY	ETF	233.48	233.48	233.48	233.48	1002.0
2017-03-22 05:14:00	SPY	ETF	233.48	233.48	233.48	233.48	101.0
2017-03-22 05:17:00	SPY	ETF	233.57	233.6	233.57	233.6	1202.0
2017-03-22 05:18:00	SPY	ETF	233.58	233.58	233.58	233.58	1402.0
2017-03-22 05:21:00	SPY	ETF	233.59	233.59	233.59	233.59	201.0
2017-03-22 05:22:00	SPY	ETF	233.58	233.58	233.58	233.58	105.0
2017-03-22 05:25:00	SPY	ETF	233.53	233.53	233.53	233.53	1503.0

> showing 50 of 154,655 rows — these rows as CSV

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