PREVIEW / etf_1min / 2018-08-16

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-08-16.parquet
  size:    3.0 MB
  rows:    152,091

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-08-16 04:00:00	SPY	ETF	282.5	282.56	282.5	282.56	445.0
2018-08-16 04:02:00	SPY	ETF	282.55	282.55	282.55	282.55	252.0
2018-08-16 04:03:00	SPY	ETF	282.57	282.6	282.57	282.6	1004.0
2018-08-16 04:05:00	SPY	ETF	282.7	282.7	282.7	282.7	100.0
2018-08-16 04:09:00	SPY	ETF	282.77	282.77	282.74	282.74	600.0
2018-08-16 04:11:00	SPY	ETF	282.78	282.78	282.77	282.77	600.0
2018-08-16 04:15:00	SPY	ETF	282.79	282.79	282.79	282.79	409.0
2018-08-16 04:17:00	SPY	ETF	282.81	282.81	282.81	282.81	100.0
2018-08-16 04:19:00	SPY	ETF	282.76	282.76	282.76	282.76	1000.0
2018-08-16 04:22:00	SPY	ETF	282.76	282.76	282.76	282.76	400.0
2018-08-16 04:23:00	SPY	ETF	282.81	282.81	282.81	282.81	400.0
2018-08-16 04:33:00	SPY	ETF	282.84	282.84	282.84	282.84	800.0
2018-08-16 04:34:00	SPY	ETF	282.86	282.86	282.86	282.86	600.0
2018-08-16 04:37:00	SPY	ETF	282.9	282.9	282.89	282.89	2000.0
2018-08-16 04:38:00	SPY	ETF	282.89	282.89	282.89	282.89	500.0
2018-08-16 04:39:00	SPY	ETF	282.79	282.79	282.79	282.79	306.0
2018-08-16 04:42:00	SPY	ETF	282.87	282.87	282.87	282.87	300.0
2018-08-16 04:44:00	SPY	ETF	282.92	282.92	282.89	282.89	800.0
2018-08-16 04:45:00	SPY	ETF	282.86	282.86	282.86	282.86	400.0
2018-08-16 04:51:00	SPY	ETF	282.98	283.0	282.98	283.0	530.0
2018-08-16 04:53:00	SPY	ETF	283.05	283.05	283.05	283.05	2000.0
2018-08-16 04:54:00	SPY	ETF	283.0	283.0	283.0	283.0	100.0
2018-08-16 04:55:00	SPY	ETF	283.01	283.01	283.01	283.01	1211.0
2018-08-16 04:57:00	SPY	ETF	283.04	283.07	283.04	283.07	2800.0
2018-08-16 05:00:00	SPY	ETF	283.05	283.05	283.05	283.05	200.0
2018-08-16 05:01:00	SPY	ETF	283.0	283.0	282.97	282.97	425.0
2018-08-16 05:03:00	SPY	ETF	282.96	282.96	282.96	282.96	1600.0
2018-08-16 05:04:00	SPY	ETF	282.95	282.99	282.95	282.99	293.0
2018-08-16 05:05:00	SPY	ETF	282.97	282.97	282.97	282.97	100.0
2018-08-16 05:06:00	SPY	ETF	282.96	282.96	282.96	282.96	1800.0
2018-08-16 05:07:00	SPY	ETF	282.95	282.95	282.95	282.95	300.0
2018-08-16 05:18:00	SPY	ETF	282.9	282.9	282.9	282.9	200.0
2018-08-16 05:19:00	SPY	ETF	282.91	282.91	282.91	282.91	300.0
2018-08-16 05:21:00	SPY	ETF	282.97	282.98	282.97	282.97	10500.0
2018-08-16 05:22:00	SPY	ETF	282.99	283.01	282.99	283.01	1300.0
2018-08-16 05:25:00	SPY	ETF	283.01	283.01	283.01	283.01	2600.0
2018-08-16 05:27:00	SPY	ETF	283.0	283.0	283.0	283.0	800.0
2018-08-16 05:28:00	SPY	ETF	283.0	283.0	282.99	282.99	1600.0
2018-08-16 05:30:00	SPY	ETF	283.01	283.01	283.01	283.01	130.0
2018-08-16 05:32:00	SPY	ETF	283.03	283.03	283.03	283.03	800.0
2018-08-16 05:35:00	SPY	ETF	283.03	283.03	283.03	283.03	2000.0
2018-08-16 05:36:00	SPY	ETF	283.07	283.07	283.07	283.07	502.0
2018-08-16 05:37:00	SPY	ETF	283.08	283.08	283.06	283.08	3100.0
2018-08-16 05:38:00	SPY	ETF	283.09	283.09	283.09	283.09	300.0
2018-08-16 05:40:00	SPY	ETF	283.11	283.11	283.1	283.1	2200.0
2018-08-16 05:42:00	SPY	ETF	283.08	283.08	283.08	283.08	270.0
2018-08-16 05:45:00	SPY	ETF	283.03	283.03	282.99	282.99	3800.0
2018-08-16 05:51:00	SPY	ETF	283.0	283.0	283.0	283.0	200.0
2018-08-16 05:58:00	SPY	ETF	283.03	283.03	283.03	283.03	2000.0
2018-08-16 05:59:00	SPY	ETF	283.03	283.03	283.03	283.03	2000.0

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

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