PREVIEW / etf_1min / 2019-07-02

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-07-02.parquet
  size:    3.2 MB
  rows:    169,454

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-02 04:13:00	SPY	ETF	295.2	295.2	295.2	295.2	100.0
2019-07-02 04:14:00	SPY	ETF	295.05	295.05	295.05	295.05	200.0
2019-07-02 04:26:00	SPY	ETF	295.05	295.05	295.05	295.05	100.0
2019-07-02 04:27:00	SPY	ETF	295.13	295.14	295.13	295.14	1100.0
2019-07-02 04:38:00	SPY	ETF	295.16	295.16	295.16	295.16	1100.0
2019-07-02 04:42:00	SPY	ETF	295.0	295.0	295.0	295.0	1500.0
2019-07-02 04:47:00	SPY	ETF	295.0	295.0	294.95	294.95	806.0
2019-07-02 04:50:00	SPY	ETF	295.12	295.14	295.12	295.14	800.0
2019-07-02 05:01:00	SPY	ETF	295.19	295.19	295.19	295.19	300.0
2019-07-02 05:19:00	SPY	ETF	295.18	295.18	295.18	295.18	100.0
2019-07-02 05:23:00	SPY	ETF	295.14	295.14	295.14	295.14	400.0
2019-07-02 05:25:00	SPY	ETF	295.2	295.26	295.2	295.26	1000.0
2019-07-02 05:29:00	SPY	ETF	295.23	295.23	295.23	295.23	200.0
2019-07-02 05:31:00	SPY	ETF	295.26	295.31	295.26	295.31	1000.0
2019-07-02 05:38:00	SPY	ETF	295.29	295.29	295.29	295.29	100.0
2019-07-02 05:39:00	SPY	ETF	295.27	295.27	295.27	295.27	200.0
2019-07-02 05:40:00	SPY	ETF	295.29	295.29	295.29	295.29	174.0
2019-07-02 05:42:00	SPY	ETF	295.19	295.19	295.19	295.19	600.0
2019-07-02 05:43:00	SPY	ETF	295.19	295.19	295.19	295.19	1200.0
2019-07-02 05:44:00	SPY	ETF	295.23	295.23	295.23	295.23	500.0
2019-07-02 05:46:00	SPY	ETF	295.18	295.18	295.18	295.18	200.0
2019-07-02 05:48:00	SPY	ETF	295.2	295.29	295.19	295.29	2500.0
2019-07-02 05:49:00	SPY	ETF	295.09	295.29	295.06	295.28	6900.0
2019-07-02 05:50:00	SPY	ETF	295.23	295.23	295.23	295.23	1378.0
2019-07-02 05:52:00	SPY	ETF	295.19	295.19	295.13	295.13	3122.0
2019-07-02 05:55:00	SPY	ETF	295.15	295.19	295.15	295.19	1000.0
2019-07-02 05:57:00	SPY	ETF	295.19	295.19	295.19	295.19	500.0
2019-07-02 05:59:00	SPY	ETF	295.16	295.16	295.16	295.16	100.0
2019-07-02 06:00:00	SPY	ETF	295.16	295.16	295.16	295.16	400.0
2019-07-02 06:14:00	SPY	ETF	295.31	295.31	295.31	295.31	100.0
2019-07-02 06:17:00	SPY	ETF	295.29	295.29	295.29	295.29	100.0
2019-07-02 06:19:00	SPY	ETF	295.34	295.34	295.34	295.34	100.0
2019-07-02 06:24:00	SPY	ETF	295.39	295.39	295.39	295.39	215.0
2019-07-02 06:29:00	SPY	ETF	295.43	295.43	295.43	295.43	200.0
2019-07-02 06:30:00	SPY	ETF	295.42	295.42	295.42	295.42	250.0
2019-07-02 06:34:00	SPY	ETF	295.38	295.38	295.38	295.38	2000.0
2019-07-02 06:35:00	SPY	ETF	295.42	295.42	295.42	295.42	1000.0
2019-07-02 06:37:00	SPY	ETF	295.42	295.43	295.41	295.41	2420.0
2019-07-02 06:41:00	SPY	ETF	295.41	295.41	295.4	295.41	2000.0
2019-07-02 06:45:00	SPY	ETF	295.42	295.42	295.38	295.38	2500.0
2019-07-02 06:46:00	SPY	ETF	295.42	295.42	295.42	295.42	175.0
2019-07-02 06:49:00	SPY	ETF	295.4	295.4	295.4	295.4	100.0
2019-07-02 06:52:00	SPY	ETF	295.4	295.4	295.4	295.4	100.0
2019-07-02 07:00:00	SPY	ETF	295.34	295.45	295.34	295.45	1849.0
2019-07-02 07:01:00	SPY	ETF	295.45	295.5	295.45	295.45	1842.0
2019-07-02 07:03:00	SPY	ETF	295.48	295.48	295.48	295.48	100.0
2019-07-02 07:04:00	SPY	ETF	295.45	295.45	295.45	295.45	100.0
2019-07-02 07:06:00	SPY	ETF	295.43	295.43	295.43	295.43	100.0
2019-07-02 07:07:00	SPY	ETF	295.42	295.42	295.36	295.42	2950.0
2019-07-02 07:08:00	SPY	ETF	295.42	295.42	295.42	295.42	100.0

> showing 50 of 169,454 rows — these rows as CSV

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