PREVIEW / etf_1min / 2019-10-16

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-10-16.parquet
  size:    3.0 MB
  rows:    159,178

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-10-16 04:00:00	SPY	ETF	298.54	298.54	298.47	298.47	1515.0
2019-10-16 04:01:00	SPY	ETF	298.4	298.4	298.3	298.3	615.0
2019-10-16 04:02:00	SPY	ETF	298.31	298.31	298.29	298.29	1100.0
2019-10-16 04:04:00	SPY	ETF	298.47	298.47	298.47	298.47	100.0
2019-10-16 04:10:00	SPY	ETF	298.25	298.25	298.16	298.16	1755.0
2019-10-16 04:11:00	SPY	ETF	298.11	298.13	298.11	298.13	315.0
2019-10-16 04:14:00	SPY	ETF	298.16	298.16	298.16	298.16	300.0
2019-10-16 04:15:00	SPY	ETF	298.15	298.15	298.15	298.15	250.0
2019-10-16 04:22:00	SPY	ETF	298.21	298.21	298.21	298.21	100.0
2019-10-16 04:31:00	SPY	ETF	298.23	298.23	298.23	298.23	325.0
2019-10-16 04:36:00	SPY	ETF	298.15	298.15	298.15	298.15	920.0
2019-10-16 04:37:00	SPY	ETF	298.18	298.18	298.18	298.18	506.0
2019-10-16 04:39:00	SPY	ETF	298.15	298.15	298.15	298.15	300.0
2019-10-16 04:53:00	SPY	ETF	298.33	298.38	298.33	298.38	200.0
2019-10-16 05:01:00	SPY	ETF	298.23	298.23	297.91	297.95	2275.0
2019-10-16 05:02:00	SPY	ETF	298.01	298.01	298.01	298.01	500.0
2019-10-16 05:05:00	SPY	ETF	298.09	298.09	298.09	298.09	200.0
2019-10-16 05:08:00	SPY	ETF	298.11	298.11	298.11	298.11	300.0
2019-10-16 05:10:00	SPY	ETF	298.14	298.14	298.14	298.14	100.0
2019-10-16 05:17:00	SPY	ETF	298.21	298.21	298.1	298.16	3513.0
2019-10-16 05:19:00	SPY	ETF	298.2	298.2	298.2	298.2	143.0
2019-10-16 05:23:00	SPY	ETF	298.16	298.16	298.16	298.16	100.0
2019-10-16 05:32:00	SPY	ETF	298.15	298.18	298.15	298.18	1100.0
2019-10-16 05:33:00	SPY	ETF	298.18	298.18	298.18	298.18	100.0
2019-10-16 05:35:00	SPY	ETF	298.25	298.25	298.25	298.25	300.0
2019-10-16 05:36:00	SPY	ETF	298.22	298.22	298.22	298.22	800.0
2019-10-16 05:38:00	SPY	ETF	298.25	298.25	298.19	298.19	650.0
2019-10-16 05:46:00	SPY	ETF	298.19	298.19	298.19	298.19	100.0
2019-10-16 05:49:00	SPY	ETF	298.2	298.23	298.2	298.23	1000.0
2019-10-16 05:51:00	SPY	ETF	298.21	298.21	298.19	298.19	1800.0
2019-10-16 05:57:00	SPY	ETF	298.19	298.19	298.19	298.19	600.0
2019-10-16 06:00:00	SPY	ETF	298.29	298.38	298.29	298.38	510.0
2019-10-16 06:03:00	SPY	ETF	298.39	298.39	298.39	298.39	701.0
2019-10-16 06:04:00	SPY	ETF	298.42	298.42	298.42	298.42	800.0
2019-10-16 06:07:00	SPY	ETF	298.54	298.54	298.54	298.54	500.0
2019-10-16 06:08:00	SPY	ETF	298.58	298.6	298.58	298.6	500.0
2019-10-16 06:10:00	SPY	ETF	298.54	298.56	298.54	298.56	300.0
2019-10-16 06:11:00	SPY	ETF	298.61	298.61	298.61	298.61	100.0
2019-10-16 06:12:00	SPY	ETF	298.61	298.61	298.61	298.61	100.0
2019-10-16 06:14:00	SPY	ETF	298.51	298.51	298.46	298.48	486.0
2019-10-16 06:15:00	SPY	ETF	298.43	298.43	298.43	298.43	100.0
2019-10-16 06:16:00	SPY	ETF	298.41	298.41	298.41	298.41	100.0
2019-10-16 06:18:00	SPY	ETF	298.36	298.36	298.36	298.36	100.0
2019-10-16 06:19:00	SPY	ETF	298.34	298.34	298.34	298.34	100.0
2019-10-16 06:20:00	SPY	ETF	298.36	298.37	298.36	298.37	200.0
2019-10-16 06:22:00	SPY	ETF	298.4	298.4	298.36	298.36	200.0
2019-10-16 06:23:00	SPY	ETF	298.4	298.4	298.4	298.4	250.0
2019-10-16 06:30:00	SPY	ETF	298.43	298.45	298.43	298.45	1600.0
2019-10-16 06:31:00	SPY	ETF	298.46	298.46	298.46	298.46	601.0
2019-10-16 06:33:00	SPY	ETF	298.4	298.4	298.39	298.39	200.0

> showing 50 of 159,178 rows — these rows as CSV

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