PREVIEW / etf_1min / 2018-09-11

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-09-11.parquet
  size:    3.0 MB
  rows:    152,986

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
2018-09-11 04:04:00	SPY	ETF	288.35	288.35	288.35	288.35	300.0
2018-09-11 04:07:00	SPY	ETF	288.34	288.34	288.34	288.34	115.0
2018-09-11 04:13:00	SPY	ETF	288.35	288.35	288.35	288.35	400.0
2018-09-11 04:21:00	SPY	ETF	288.4	288.4	288.4	288.4	300.0
2018-09-11 04:24:00	SPY	ETF	288.4	288.4	288.4	288.4	100.0
2018-09-11 04:28:00	SPY	ETF	288.41	288.41	288.41	288.41	100.0
2018-09-11 04:31:00	SPY	ETF	288.27	288.27	288.27	288.27	200.0
2018-09-11 04:33:00	SPY	ETF	288.26	288.26	288.26	288.26	2500.0
2018-09-11 04:37:00	SPY	ETF	288.27	288.27	288.27	288.27	900.0
2018-09-11 04:38:00	SPY	ETF	288.25	288.25	288.25	288.25	2000.0
2018-09-11 04:40:00	SPY	ETF	288.19	288.19	288.19	288.19	300.0
2018-09-11 04:44:00	SPY	ETF	288.12	288.12	288.12	288.12	1000.0
2018-09-11 04:47:00	SPY	ETF	288.05	288.05	287.95	287.95	1122.0
2018-09-11 04:48:00	SPY	ETF	287.95	287.95	287.93	287.93	500.0
2018-09-11 04:52:00	SPY	ETF	287.8	287.89	287.8	287.89	232.0
2018-09-11 04:58:00	SPY	ETF	287.96	287.96	287.96	287.96	100.0
2018-09-11 05:02:00	SPY	ETF	287.86	287.86	287.86	287.86	200.0
2018-09-11 05:03:00	SPY	ETF	287.79	287.79	287.78	287.78	2300.0
2018-09-11 05:05:00	SPY	ETF	287.63	287.63	287.52	287.52	2702.0
2018-09-11 05:06:00	SPY	ETF	287.53	287.53	287.53	287.53	100.0
2018-09-11 05:07:00	SPY	ETF	287.55	287.56	287.5	287.5	2900.0
2018-09-11 05:08:00	SPY	ETF	287.5	287.5	287.5	287.5	150.0
2018-09-11 05:09:00	SPY	ETF	287.62	287.62	287.62	287.62	100.0
2018-09-11 05:10:00	SPY	ETF	287.59	287.59	287.59	287.59	500.0
2018-09-11 05:11:00	SPY	ETF	287.58	287.58	287.55	287.55	500.0
2018-09-11 05:17:00	SPY	ETF	287.66	287.66	287.66	287.66	100.0
2018-09-11 05:18:00	SPY	ETF	287.65	287.66	287.65	287.66	700.0
2018-09-11 05:19:00	SPY	ETF	287.69	287.71	287.68	287.68	352.0
2018-09-11 05:20:00	SPY	ETF	287.69	287.7	287.69	287.7	1000.0
2018-09-11 05:21:00	SPY	ETF	287.71	287.71	287.71	287.71	1000.0
2018-09-11 05:22:00	SPY	ETF	287.68	287.68	287.68	287.68	500.0
2018-09-11 05:23:00	SPY	ETF	287.64	287.64	287.64	287.64	1500.0
2018-09-11 05:27:00	SPY	ETF	287.56	287.58	287.56	287.58	398.0
2018-09-11 05:28:00	SPY	ETF	287.61	287.61	287.61	287.61	200.0
2018-09-11 05:29:00	SPY	ETF	287.6	287.6	287.6	287.6	100.0
2018-09-11 05:30:00	SPY	ETF	287.58	287.58	287.58	287.58	300.0
2018-09-11 05:31:00	SPY	ETF	287.55	287.55	287.53	287.53	200.0
2018-09-11 05:35:00	SPY	ETF	287.38	287.38	287.38	287.38	200.0
2018-09-11 05:37:00	SPY	ETF	287.58	287.59	287.58	287.59	500.0
2018-09-11 05:39:00	SPY	ETF	287.49	287.5	287.46	287.46	4600.0
2018-09-11 05:41:00	SPY	ETF	287.46	287.46	287.46	287.46	300.0
2018-09-11 05:43:00	SPY	ETF	287.44	287.44	287.44	287.44	500.0
2018-09-11 05:46:00	SPY	ETF	287.5	287.5	287.5	287.5	300.0
2018-09-11 05:47:00	SPY	ETF	287.53	287.53	287.53	287.53	1200.0
2018-09-11 05:48:00	SPY	ETF	287.55	287.55	287.55	287.55	600.0
2018-09-11 05:50:00	SPY	ETF	287.55	287.55	287.55	287.55	150.0
2018-09-11 05:51:00	SPY	ETF	287.53	287.53	287.53	287.53	500.0
2018-09-11 05:52:00	SPY	ETF	287.53	287.57	287.53	287.57	602.0
2018-09-11 05:53:00	SPY	ETF	287.6	287.63	287.6	287.63	600.0
2018-09-11 05:54:00	SPY	ETF	287.65	287.65	287.65	287.65	200.0

> showing 50 of 152,986 rows — these rows as CSV

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