PREVIEW / etf_1min / 2018-11-16

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-11-16.parquet
  size:    3.2 MB
  rows:    168,703

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-11-16 04:11:00	SPY	ETF	272.45	272.45	272.45	272.45	110.0
2018-11-16 04:16:00	SPY	ETF	272.3	272.3	272.3	272.3	185.0
2018-11-16 04:17:00	SPY	ETF	272.31	272.35	272.31	272.31	2500.0
2018-11-16 04:18:00	SPY	ETF	272.4	272.4	272.4	272.4	1250.0
2018-11-16 04:19:00	SPY	ETF	272.44	272.44	272.37	272.37	1367.0
2018-11-16 04:20:00	SPY	ETF	272.32	272.32	272.32	272.32	1000.0
2018-11-16 04:22:00	SPY	ETF	272.46	272.46	272.46	272.46	1200.0
2018-11-16 04:23:00	SPY	ETF	272.4	272.4	272.4	272.4	105.0
2018-11-16 04:25:00	SPY	ETF	272.28	272.28	272.28	272.28	2025.0
2018-11-16 04:28:00	SPY	ETF	272.32	272.32	272.32	272.32	1000.0
2018-11-16 04:30:00	SPY	ETF	272.34	272.34	272.34	272.34	300.0
2018-11-16 04:35:00	SPY	ETF	272.35	272.36	272.35	272.36	2555.0
2018-11-16 04:38:00	SPY	ETF	272.45	272.45	272.45	272.45	500.0
2018-11-16 04:42:00	SPY	ETF	272.5	272.5	272.5	272.5	1265.0
2018-11-16 04:43:00	SPY	ETF	272.57	272.57	272.57	272.57	2200.0
2018-11-16 04:44:00	SPY	ETF	272.58	272.59	272.58	272.59	200.0
2018-11-16 04:50:00	SPY	ETF	272.47	272.47	272.47	272.47	100.0
2018-11-16 04:55:00	SPY	ETF	272.49	272.49	272.49	272.49	2000.0
2018-11-16 04:56:00	SPY	ETF	272.5	272.5	272.5	272.5	1000.0
2018-11-16 05:00:00	SPY	ETF	272.41	272.41	272.41	272.41	200.0
2018-11-16 05:01:00	SPY	ETF	272.35	272.44	272.35	272.44	600.0
2018-11-16 05:02:00	SPY	ETF	272.39	272.39	272.39	272.39	500.0
2018-11-16 05:04:00	SPY	ETF	272.36	272.36	272.36	272.36	169.0
2018-11-16 05:07:00	SPY	ETF	272.35	272.35	272.35	272.35	100.0
2018-11-16 05:08:00	SPY	ETF	272.35	272.35	272.35	272.35	125.0
2018-11-16 05:11:00	SPY	ETF	272.36	272.36	272.36	272.36	169.0
2018-11-16 05:12:00	SPY	ETF	272.37	272.4	272.37	272.4	2169.0
2018-11-16 05:14:00	SPY	ETF	272.3	272.3	272.3	272.3	500.0
2018-11-16 05:15:00	SPY	ETF	272.28	272.28	272.28	272.28	100.0
2018-11-16 05:17:00	SPY	ETF	272.2	272.2	272.1	272.1	1250.0
2018-11-16 05:18:00	SPY	ETF	272.11	272.11	272.11	272.11	1000.0
2018-11-16 05:19:00	SPY	ETF	272.16	272.16	272.16	272.16	369.0
2018-11-16 05:20:00	SPY	ETF	272.15	272.15	272.15	272.15	300.0
2018-11-16 05:23:00	SPY	ETF	272.04	272.12	272.04	272.12	269.0
2018-11-16 05:27:00	SPY	ETF	272.16	272.19	272.16	272.16	5000.0
2018-11-16 05:28:00	SPY	ETF	272.19	272.19	272.19	272.19	500.0
2018-11-16 05:29:00	SPY	ETF	272.14	272.14	272.14	272.14	300.0
2018-11-16 05:30:00	SPY	ETF	272.12	272.12	272.12	272.12	800.0
2018-11-16 05:31:00	SPY	ETF	272.14	272.14	272.14	272.14	100.0
2018-11-16 05:33:00	SPY	ETF	272.19	272.2	272.13	272.2	3049.0
2018-11-16 05:36:00	SPY	ETF	272.14	272.14	272.12	272.12	200.0
2018-11-16 05:37:00	SPY	ETF	272.17	272.17	272.17	272.17	369.0
2018-11-16 05:38:00	SPY	ETF	272.14	272.14	272.09	272.1	300.0
2018-11-16 05:39:00	SPY	ETF	272.12	272.12	272.09	272.09	500.0
2018-11-16 05:40:00	SPY	ETF	272.02	272.07	272.02	272.07	2000.0
2018-11-16 05:42:00	SPY	ETF	272.12	272.16	272.12	272.16	269.0
2018-11-16 05:43:00	SPY	ETF	272.19	272.2	272.19	272.2	1769.0
2018-11-16 05:46:00	SPY	ETF	272.08	272.08	272.08	272.08	169.0
2018-11-16 05:47:00	SPY	ETF	272.04	272.04	272.04	272.04	169.0
2018-11-16 05:48:00	SPY	ETF	272.06	272.06	272.06	272.06	500.0

> showing 50 of 168,703 rows — these rows as CSV

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