PREVIEW / etf_1min / 2019-07-26

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-07-26.parquet
  size:    2.8 MB
  rows:    149,007

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
2019-07-26 04:00:00	SPY	ETF	300.33	300.52	300.33	300.52	910.0
2019-07-26 04:03:00	SPY	ETF	300.52	300.52	300.52	300.52	100.0
2019-07-26 04:04:00	SPY	ETF	300.6	300.6	300.6	300.6	100.0
2019-07-26 04:06:00	SPY	ETF	300.63	300.63	300.63	300.63	2000.0
2019-07-26 04:07:00	SPY	ETF	300.6	300.6	300.6	300.6	100.0
2019-07-26 04:22:00	SPY	ETF	300.61	300.61	300.61	300.61	100.0
2019-07-26 04:23:00	SPY	ETF	300.55	300.55	300.55	300.55	300.0
2019-07-26 04:34:00	SPY	ETF	300.55	300.55	300.55	300.55	2000.0
2019-07-26 04:40:00	SPY	ETF	300.55	300.55	300.55	300.55	120.0
2019-07-26 04:42:00	SPY	ETF	300.53	300.55	300.53	300.55	1147.0
2019-07-26 04:44:00	SPY	ETF	300.53	300.53	300.53	300.53	300.0
2019-07-26 04:45:00	SPY	ETF	300.55	300.55	300.55	300.55	169.0
2019-07-26 04:47:00	SPY	ETF	300.55	300.55	300.55	300.55	369.0
2019-07-26 04:48:00	SPY	ETF	300.57	300.57	300.57	300.57	369.0
2019-07-26 04:51:00	SPY	ETF	300.55	300.55	300.55	300.55	169.0
2019-07-26 04:52:00	SPY	ETF	300.57	300.57	300.57	300.57	169.0
2019-07-26 04:53:00	SPY	ETF	300.55	300.55	300.53	300.53	378.0
2019-07-26 04:54:00	SPY	ETF	300.57	300.57	300.57	300.57	538.0
2019-07-26 05:01:00	SPY	ETF	300.52	300.52	300.52	300.52	325.0
2019-07-26 05:13:00	SPY	ETF	300.55	300.55	300.55	300.55	200.0
2019-07-26 05:20:00	SPY	ETF	300.68	300.68	300.68	300.68	169.0
2019-07-26 05:22:00	SPY	ETF	300.7	300.7	300.7	300.7	169.0
2019-07-26 05:23:00	SPY	ETF	300.72	300.72	300.7	300.7	300.0
2019-07-26 05:26:00	SPY	ETF	300.67	300.67	300.67	300.67	300.0
2019-07-26 05:28:00	SPY	ETF	300.75	300.75	300.75	300.75	435.0
2019-07-26 05:29:00	SPY	ETF	300.75	300.75	300.75	300.75	1641.0
2019-07-26 05:30:00	SPY	ETF	300.78	300.78	300.78	300.78	169.0
2019-07-26 05:31:00	SPY	ETF	300.85	300.85	300.85	300.85	100.0
2019-07-26 05:39:00	SPY	ETF	300.82	300.82	300.82	300.82	169.0
2019-07-26 05:40:00	SPY	ETF	300.84	300.84	300.84	300.84	219.0
2019-07-26 05:46:00	SPY	ETF	300.92	300.92	300.92	300.92	169.0
2019-07-26 05:49:00	SPY	ETF	300.9	300.9	300.9	300.9	300.0
2019-07-26 05:55:00	SPY	ETF	300.89	300.89	300.89	300.89	100.0
2019-07-26 05:56:00	SPY	ETF	300.9	300.9	300.85	300.85	300.0
2019-07-26 06:01:00	SPY	ETF	300.95	300.95	300.95	300.95	126.0
2019-07-26 06:06:00	SPY	ETF	300.97	300.97	300.97	300.97	200.0
2019-07-26 06:10:00	SPY	ETF	300.92	300.92	300.92	300.92	300.0
2019-07-26 06:13:00	SPY	ETF	300.95	300.95	300.95	300.95	200.0
2019-07-26 06:18:00	SPY	ETF	300.97	300.97	300.97	300.97	169.0
2019-07-26 06:21:00	SPY	ETF	300.95	300.97	300.95	300.97	1771.0
2019-07-26 06:25:00	SPY	ETF	300.97	301.0	300.97	301.0	650.0
2019-07-26 06:29:00	SPY	ETF	301.0	301.0	301.0	301.0	410.0
2019-07-26 06:34:00	SPY	ETF	300.92	300.92	300.91	300.91	19350.0
2019-07-26 06:36:00	SPY	ETF	300.91	300.99	300.91	300.99	7482.0
2019-07-26 06:38:00	SPY	ETF	300.99	300.99	300.99	300.99	390.0
2019-07-26 06:42:00	SPY	ETF	300.89	300.89	300.89	300.89	220.0
2019-07-26 06:58:00	SPY	ETF	300.83	300.83	300.83	300.83	169.0
2019-07-26 07:00:00	SPY	ETF	300.82	300.82	300.76	300.76	900.0
2019-07-26 07:01:00	SPY	ETF	300.82	300.83	300.82	300.83	668.0
2019-07-26 07:02:00	SPY	ETF	300.81	300.81	300.81	300.81	300.0

> showing 50 of 149,007 rows — these rows as CSV

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