PREVIEW / etf_1min / 2019-07-11

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-07-11.parquet
  size:    3.1 MB
  rows:    163,969

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-11 04:00:00	SPY	ETF	299.26	299.26	299.26	299.26	1000.0
2019-07-11 04:01:00	SPY	ETF	299.36	299.36	299.36	299.36	200.0
2019-07-11 04:03:00	SPY	ETF	299.32	299.32	299.32	299.32	400.0
2019-07-11 04:08:00	SPY	ETF	299.27	299.27	299.27	299.27	100.0
2019-07-11 04:37:00	SPY	ETF	299.24	299.24	299.24	299.24	100.0
2019-07-11 05:02:00	SPY	ETF	299.21	299.21	299.18	299.18	400.0
2019-07-11 05:04:00	SPY	ETF	299.27	299.27	299.27	299.27	510.0
2019-07-11 05:07:00	SPY	ETF	299.37	299.37	299.37	299.37	135.0
2019-07-11 05:08:00	SPY	ETF	299.43	299.51	299.43	299.51	325.0
2019-07-11 05:09:00	SPY	ETF	299.56	299.57	299.56	299.57	2500.0
2019-07-11 05:12:00	SPY	ETF	299.49	299.49	299.49	299.49	500.0
2019-07-11 05:14:00	SPY	ETF	299.47	299.51	299.46	299.51	3365.0
2019-07-11 05:15:00	SPY	ETF	299.49	299.5	299.49	299.5	1500.0
2019-07-11 05:17:00	SPY	ETF	299.59	299.59	299.59	299.59	2000.0
2019-07-11 05:21:00	SPY	ETF	299.52	299.54	299.52	299.54	338.0
2019-07-11 05:22:00	SPY	ETF	299.54	299.54	299.54	299.54	630.0
2019-07-11 05:23:00	SPY	ETF	299.56	299.61	299.56	299.61	866.0
2019-07-11 05:24:00	SPY	ETF	299.61	299.61	299.61	299.61	100.0
2019-07-11 05:25:00	SPY	ETF	299.57	299.57	299.54	299.54	1255.0
2019-07-11 05:26:00	SPY	ETF	299.54	299.54	299.54	299.54	169.0
2019-07-11 05:27:00	SPY	ETF	299.52	299.52	299.49	299.49	3000.0
2019-07-11 05:28:00	SPY	ETF	299.49	299.49	299.49	299.49	4169.0
2019-07-11 05:30:00	SPY	ETF	299.5	299.58	299.5	299.58	1181.0
2019-07-11 05:32:00	SPY	ETF	299.57	299.57	299.57	299.57	500.0
2019-07-11 05:33:00	SPY	ETF	299.57	299.57	299.57	299.57	300.0
2019-07-11 05:36:00	SPY	ETF	299.6	299.6	299.57	299.57	700.0
2019-07-11 05:38:00	SPY	ETF	299.54	299.54	299.54	299.54	500.0
2019-07-11 05:40:00	SPY	ETF	299.47	299.49	299.47	299.49	500.0
2019-07-11 05:41:00	SPY	ETF	299.47	299.47	299.47	299.47	200.0
2019-07-11 05:46:00	SPY	ETF	299.49	299.49	299.49	299.49	500.0
2019-07-11 05:48:00	SPY	ETF	299.5	299.52	299.5	299.52	338.0
2019-07-11 05:49:00	SPY	ETF	299.52	299.52	299.52	299.52	502.0
2019-07-11 05:50:00	SPY	ETF	299.54	299.56	299.54	299.56	336.0
2019-07-11 05:53:00	SPY	ETF	299.57	299.58	299.57	299.58	679.0
2019-07-11 05:54:00	SPY	ETF	299.57	299.57	299.57	299.57	300.0
2019-07-11 05:56:00	SPY	ETF	299.57	299.57	299.57	299.57	700.0
2019-07-11 05:59:00	SPY	ETF	299.55	299.55	299.55	299.55	969.0
2019-07-11 06:01:00	SPY	ETF	299.55	299.55	299.55	299.55	200.0
2019-07-11 06:02:00	SPY	ETF	299.56	299.56	299.56	299.56	169.0
2019-07-11 06:03:00	SPY	ETF	299.55	299.55	299.55	299.55	300.0
2019-07-11 06:04:00	SPY	ETF	299.49	299.52	299.49	299.52	1800.0
2019-07-11 06:05:00	SPY	ETF	299.47	299.47	299.46	299.47	2669.0
2019-07-11 06:06:00	SPY	ETF	299.47	299.47	299.47	299.47	900.0
2019-07-11 06:07:00	SPY	ETF	299.42	299.42	299.42	299.42	1000.0
2019-07-11 06:09:00	SPY	ETF	299.39	299.39	299.39	299.39	1000.0
2019-07-11 06:14:00	SPY	ETF	299.44	299.46	299.44	299.46	600.0
2019-07-11 06:15:00	SPY	ETF	299.44	299.44	299.44	299.44	1000.0
2019-07-11 06:17:00	SPY	ETF	299.41	299.41	299.39	299.39	1200.0
2019-07-11 06:19:00	SPY	ETF	299.39	299.39	299.39	299.39	1000.0
2019-07-11 06:20:00	SPY	ETF	299.37	299.37	299.37	299.37	1000.0

> showing 50 of 163,969 rows — these rows as CSV

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