PREVIEW / etf_1min / 2019-05-17

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-05-17.parquet
  size:    3.0 MB
  rows:    157,319

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-05-17 04:00:00	SPY	ETF	287.01	287.01	286.99	286.99	1202.0
2019-05-17 04:01:00	SPY	ETF	286.99	286.99	286.9	286.9	1255.0
2019-05-17 04:02:00	SPY	ETF	286.94	286.94	286.88	286.88	1231.0
2019-05-17 04:03:00	SPY	ETF	286.87	286.87	286.81	286.81	1663.0
2019-05-17 04:04:00	SPY	ETF	286.79	286.79	286.78	286.78	839.0
2019-05-17 04:07:00	SPY	ETF	286.68	286.68	286.65	286.65	3900.0
2019-05-17 04:08:00	SPY	ETF	286.64	286.64	286.62	286.62	758.0
2019-05-17 04:09:00	SPY	ETF	286.67	286.67	286.62	286.62	300.0
2019-05-17 04:10:00	SPY	ETF	286.72	286.72	286.72	286.72	102.0
2019-05-17 04:11:00	SPY	ETF	286.7	286.7	286.7	286.7	137.0
2019-05-17 04:23:00	SPY	ETF	286.67	286.67	286.67	286.67	141.0
2019-05-17 04:26:00	SPY	ETF	286.51	286.51	286.45	286.45	955.0
2019-05-17 04:28:00	SPY	ETF	286.45	286.45	286.43	286.45	1560.0
2019-05-17 04:29:00	SPY	ETF	286.42	286.42	286.35	286.35	707.0
2019-05-17 04:30:00	SPY	ETF	286.32	286.32	286.32	286.32	302.0
2019-05-17 04:31:00	SPY	ETF	286.27	286.27	286.25	286.25	1151.0
2019-05-17 04:32:00	SPY	ETF	286.32	286.32	286.23	286.23	1001.0
2019-05-17 04:35:00	SPY	ETF	286.24	286.24	286.24	286.24	451.0
2019-05-17 04:37:00	SPY	ETF	286.22	286.22	286.22	286.22	200.0
2019-05-17 04:38:00	SPY	ETF	286.25	286.25	286.25	286.25	201.0
2019-05-17 04:43:00	SPY	ETF	286.15	286.15	286.15	286.15	501.0
2019-05-17 04:44:00	SPY	ETF	286.23	286.23	286.23	286.23	5000.0
2019-05-17 04:47:00	SPY	ETF	286.26	286.26	286.26	286.26	444.0
2019-05-17 04:52:00	SPY	ETF	286.07	286.07	286.07	286.07	151.0
2019-05-17 04:54:00	SPY	ETF	286.05	286.05	285.99	285.99	686.0
2019-05-17 04:55:00	SPY	ETF	286.0	286.0	286.0	286.0	225.0
2019-05-17 04:56:00	SPY	ETF	286.05	286.05	286.05	286.05	101.0
2019-05-17 05:02:00	SPY	ETF	286.25	286.25	286.25	286.25	100.0
2019-05-17 05:05:00	SPY	ETF	286.13	286.13	286.13	286.13	1001.0
2019-05-17 05:07:00	SPY	ETF	286.23	286.23	286.23	286.23	102.0
2019-05-17 05:08:00	SPY	ETF	286.1	286.1	286.1	286.1	202.0
2019-05-17 05:09:00	SPY	ETF	286.03	286.03	286.0	286.0	2074.0
2019-05-17 05:13:00	SPY	ETF	286.2	286.2	286.2	286.2	110.0
2019-05-17 05:14:00	SPY	ETF	286.18	286.18	286.18	286.18	110.0
2019-05-17 05:15:00	SPY	ETF	286.2	286.2	286.2	286.2	500.0
2019-05-17 05:16:00	SPY	ETF	286.18	286.18	286.18	286.18	500.0
2019-05-17 05:17:00	SPY	ETF	286.23	286.23	286.23	286.23	2002.0
2019-05-17 05:18:00	SPY	ETF	286.28	286.28	286.23	286.23	1150.0
2019-05-17 05:19:00	SPY	ETF	286.22	286.3	286.22	286.28	2550.0
2019-05-17 05:20:00	SPY	ETF	286.28	286.28	286.24	286.24	901.0
2019-05-17 05:21:00	SPY	ETF	286.24	286.24	286.24	286.24	200.0
2019-05-17 05:22:00	SPY	ETF	286.26	286.26	286.24	286.25	700.0
2019-05-17 05:23:00	SPY	ETF	286.3	286.3	286.3	286.3	1002.0
2019-05-17 05:24:00	SPY	ETF	286.41	286.41	286.41	286.41	178.0
2019-05-17 05:27:00	SPY	ETF	286.44	286.44	286.41	286.41	801.0
2019-05-17 05:28:00	SPY	ETF	286.41	286.41	286.41	286.41	300.0
2019-05-17 05:29:00	SPY	ETF	286.43	286.44	286.43	286.44	601.0
2019-05-17 05:30:00	SPY	ETF	286.41	286.41	286.41	286.41	1110.0
2019-05-17 05:31:00	SPY	ETF	286.37	286.4	286.37	286.4	1001.0
2019-05-17 05:32:00	SPY	ETF	286.36	286.41	286.36	286.41	501.0

> showing 50 of 157,319 rows — these rows as CSV

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