PREVIEW / etf_1min / 2019-08-19

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-19.parquet
  size:    3.2 MB
  rows:    166,896

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-08-19 04:00:00	SPY	ETF	291.34	291.44	291.32	291.4	6502.0
2019-08-19 04:01:00	SPY	ETF	291.34	291.36	291.34	291.35	775.0
2019-08-19 04:02:00	SPY	ETF	291.34	291.35	291.32	291.35	3680.0
2019-08-19 04:03:00	SPY	ETF	291.39	291.4	291.36	291.36	2735.0
2019-08-19 04:06:00	SPY	ETF	291.5	291.5	291.5	291.5	2100.0
2019-08-19 04:07:00	SPY	ETF	291.49	291.49	291.42	291.42	1700.0
2019-08-19 04:08:00	SPY	ETF	291.45	291.45	291.42	291.42	4075.0
2019-08-19 04:10:00	SPY	ETF	291.46	291.46	291.46	291.46	111.0
2019-08-19 04:14:00	SPY	ETF	291.47	291.47	291.42	291.45	600.0
2019-08-19 04:21:00	SPY	ETF	291.52	291.52	291.52	291.52	100.0
2019-08-19 04:29:00	SPY	ETF	291.2	291.2	291.2	291.2	317.0
2019-08-19 04:30:00	SPY	ETF	291.16	291.16	291.16	291.16	264.0
2019-08-19 04:33:00	SPY	ETF	291.14	291.14	291.14	291.14	150.0
2019-08-19 04:35:00	SPY	ETF	291.13	291.13	291.13	291.13	300.0
2019-08-19 04:37:00	SPY	ETF	291.1	291.1	291.1	291.1	200.0
2019-08-19 04:40:00	SPY	ETF	291.07	291.07	291.05	291.07	880.0
2019-08-19 04:41:00	SPY	ETF	291.07	291.07	291.07	291.07	179.0
2019-08-19 04:44:00	SPY	ETF	291.07	291.07	291.07	291.07	100.0
2019-08-19 04:45:00	SPY	ETF	291.0	291.0	291.0	291.0	120.0
2019-08-19 04:47:00	SPY	ETF	291.06	291.06	291.06	291.06	2000.0
2019-08-19 04:51:00	SPY	ETF	291.06	291.06	291.06	291.06	1700.0
2019-08-19 05:09:00	SPY	ETF	291.14	291.14	291.14	291.14	400.0
2019-08-19 05:19:00	SPY	ETF	291.34	291.34	291.34	291.34	100.0
2019-08-19 05:21:00	SPY	ETF	291.31	291.31	291.29	291.29	625.0
2019-08-19 05:28:00	SPY	ETF	291.38	291.38	291.38	291.38	125.0
2019-08-19 05:30:00	SPY	ETF	291.39	291.39	291.35	291.35	900.0
2019-08-19 05:40:00	SPY	ETF	291.31	291.31	291.31	291.31	1000.0
2019-08-19 05:42:00	SPY	ETF	291.31	291.34	291.31	291.34	2975.0
2019-08-19 05:47:00	SPY	ETF	291.37	291.37	291.37	291.37	100.0
2019-08-19 05:48:00	SPY	ETF	291.46	291.46	291.46	291.46	400.0
2019-08-19 05:50:00	SPY	ETF	291.51	291.51	291.51	291.51	1370.0
2019-08-19 05:52:00	SPY	ETF	291.53	291.54	291.53	291.54	1329.0
2019-08-19 05:53:00	SPY	ETF	291.51	291.51	291.51	291.51	700.0
2019-08-19 05:54:00	SPY	ETF	291.44	291.44	291.44	291.44	100.0
2019-08-19 05:55:00	SPY	ETF	291.46	291.46	291.46	291.46	300.0
2019-08-19 05:58:00	SPY	ETF	291.49	291.49	291.49	291.49	100.0
2019-08-19 06:01:00	SPY	ETF	291.55	291.55	291.55	291.55	125.0
2019-08-19 06:03:00	SPY	ETF	291.54	291.54	291.54	291.54	260.0
2019-08-19 06:04:00	SPY	ETF	291.57	291.57	291.55	291.55	300.0
2019-08-19 06:07:00	SPY	ETF	291.68	291.68	291.68	291.68	130.0
2019-08-19 06:08:00	SPY	ETF	291.72	291.73	291.72	291.73	1150.0
2019-08-19 06:15:00	SPY	ETF	291.59	291.59	291.59	291.59	900.0
2019-08-19 06:16:00	SPY	ETF	291.66	291.66	291.63	291.64	1100.0
2019-08-19 06:17:00	SPY	ETF	291.66	291.66	291.66	291.66	1000.0
2019-08-19 06:19:00	SPY	ETF	291.64	291.69	291.64	291.69	1058.0
2019-08-19 06:22:00	SPY	ETF	291.64	291.64	291.64	291.64	100.0
2019-08-19 06:25:00	SPY	ETF	291.63	291.63	291.63	291.63	200.0
2019-08-19 06:27:00	SPY	ETF	291.66	291.71	291.66	291.71	1000.0
2019-08-19 06:28:00	SPY	ETF	291.66	291.66	291.55	291.55	850.0
2019-08-19 06:29:00	SPY	ETF	291.57	291.57	291.56	291.56	1050.0

> showing 50 of 166,896 rows — these rows as CSV

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