PREVIEW / etf_1min / 2018-04-27

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-04-27.parquet
  size:    2.6 MB
  rows:    137,485

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-04-27 04:04:00	SPY	ETF	266.66	266.68	266.66	266.68	525.0
2018-04-27 04:17:00	SPY	ETF	266.64	266.64	266.64	266.64	100.0
2018-04-27 04:29:00	SPY	ETF	266.59	266.59	266.59	266.59	1800.0
2018-04-27 04:42:00	SPY	ETF	266.5	266.5	266.5	266.5	250.0
2018-04-27 04:47:00	SPY	ETF	266.44	266.44	266.44	266.44	2550.0
2018-04-27 04:49:00	SPY	ETF	266.45	266.45	266.45	266.45	200.0
2018-04-27 04:57:00	SPY	ETF	266.4	266.4	266.4	266.4	300.0
2018-04-27 04:59:00	SPY	ETF	266.46	266.47	266.46	266.47	5000.0
2018-04-27 05:00:00	SPY	ETF	266.46	266.46	266.46	266.46	100.0
2018-04-27 05:10:00	SPY	ETF	266.45	266.47	266.45	266.47	2300.0
2018-04-27 05:11:00	SPY	ETF	266.48	266.48	266.47	266.47	3300.0
2018-04-27 05:22:00	SPY	ETF	266.39	266.39	266.39	266.39	400.0
2018-04-27 05:24:00	SPY	ETF	266.36	266.36	266.36	266.36	975.0
2018-04-27 05:25:00	SPY	ETF	266.35	266.35	266.25	266.34	3200.0
2018-04-27 05:26:00	SPY	ETF	266.34	266.34	266.33	266.33	2510.0
2018-04-27 05:27:00	SPY	ETF	266.31	266.31	266.29	266.29	1900.0
2018-04-27 05:29:00	SPY	ETF	266.3	266.3	266.3	266.3	400.0
2018-04-27 05:30:00	SPY	ETF	266.3	266.3	266.3	266.3	100.0
2018-04-27 05:31:00	SPY	ETF	266.32	266.32	266.32	266.32	500.0
2018-04-27 05:32:00	SPY	ETF	266.3	266.3	266.3	266.3	300.0
2018-04-27 05:33:00	SPY	ETF	266.34	266.34	266.34	266.34	1100.0
2018-04-27 05:38:00	SPY	ETF	266.4	266.42	266.4	266.42	1100.0
2018-04-27 05:39:00	SPY	ETF	266.42	266.48	266.42	266.48	3443.0
2018-04-27 05:41:00	SPY	ETF	266.4	266.4	266.4	266.4	100.0
2018-04-27 05:51:00	SPY	ETF	266.54	266.54	266.54	266.54	200.0
2018-04-27 05:54:00	SPY	ETF	266.5	266.5	266.5	266.5	2443.0
2018-04-27 05:55:00	SPY	ETF	266.55	266.57	266.55	266.57	1300.0
2018-04-27 05:58:00	SPY	ETF	266.65	266.65	266.65	266.65	100.0
2018-04-27 06:01:00	SPY	ETF	266.65	266.65	266.65	266.65	100.0
2018-04-27 06:08:00	SPY	ETF	266.62	266.67	266.62	266.67	200.0
2018-04-27 06:09:00	SPY	ETF	266.69	266.69	266.69	266.69	550.0
2018-04-27 06:10:00	SPY	ETF	266.69	266.69	266.69	266.69	200.0
2018-04-27 06:12:00	SPY	ETF	266.72	266.75	266.72	266.75	500.0
2018-04-27 06:16:00	SPY	ETF	266.91	266.91	266.91	266.91	100.0
2018-04-27 06:29:00	SPY	ETF	266.81	266.81	266.81	266.81	100.0
2018-04-27 06:32:00	SPY	ETF	266.8	266.8	266.8	266.8	100.0
2018-04-27 06:33:00	SPY	ETF	266.82	266.82	266.82	266.82	2800.0
2018-04-27 06:34:00	SPY	ETF	266.88	266.88	266.88	266.88	100.0
2018-04-27 06:36:00	SPY	ETF	266.89	266.89	266.87	266.87	2013.0
2018-04-27 06:38:00	SPY	ETF	266.84	266.84	266.84	266.84	130.0
2018-04-27 06:39:00	SPY	ETF	266.8	266.8	266.8	266.8	400.0
2018-04-27 06:43:00	SPY	ETF	266.78	266.78	266.78	266.78	2000.0
2018-04-27 06:44:00	SPY	ETF	266.75	266.77	266.75	266.77	300.0
2018-04-27 06:47:00	SPY	ETF	266.75	266.75	266.75	266.75	100.0
2018-04-27 06:49:00	SPY	ETF	266.75	266.75	266.75	266.75	400.0
2018-04-27 06:50:00	SPY	ETF	266.75	266.75	266.75	266.75	400.0
2018-04-27 06:51:00	SPY	ETF	266.75	266.75	266.75	266.75	3100.0
2018-04-27 06:52:00	SPY	ETF	266.71	266.71	266.71	266.71	1100.0
2018-04-27 06:55:00	SPY	ETF	266.7	266.7	266.7	266.7	300.0
2018-04-27 06:59:00	SPY	ETF	266.66	266.66	266.64	266.64	6011.0

> showing 50 of 137,485 rows — these rows as CSV

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