PREVIEW / etf_1min / 2018-12-21

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-12-21.parquet
  size:    4.5 MB
  rows:    226,876

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-12-21 04:00:00	SPY	ETF	246.31	246.31	246.2	246.3	2151.0
2018-12-21 04:01:00	SPY	ETF	246.11	246.11	246.0	246.0	618.0
2018-12-21 04:02:00	SPY	ETF	245.91	245.91	245.91	245.91	300.0
2018-12-21 04:03:00	SPY	ETF	245.91	245.96	245.9	245.96	776.0
2018-12-21 04:04:00	SPY	ETF	245.96	245.96	245.92	245.92	200.0
2018-12-21 04:05:00	SPY	ETF	245.99	246.02	245.99	246.02	908.0
2018-12-21 04:06:00	SPY	ETF	246.09	246.09	246.0	246.04	5588.0
2018-12-21 04:07:00	SPY	ETF	246.05	246.16	246.05	246.11	5218.0
2018-12-21 04:08:00	SPY	ETF	246.13	246.13	246.13	246.13	1620.0
2018-12-21 04:09:00	SPY	ETF	246.16	246.16	246.16	246.16	322.0
2018-12-21 04:10:00	SPY	ETF	246.15	246.28	246.15	246.28	2325.0
2018-12-21 04:11:00	SPY	ETF	246.32	246.35	246.3	246.3	10800.0
2018-12-21 04:12:00	SPY	ETF	246.28	246.35	246.28	246.35	1805.0
2018-12-21 04:13:00	SPY	ETF	246.48	246.49	246.38	246.45	6325.0
2018-12-21 04:14:00	SPY	ETF	246.41	246.41	246.41	246.41	300.0
2018-12-21 04:15:00	SPY	ETF	246.38	246.38	246.38	246.38	610.0
2018-12-21 04:16:00	SPY	ETF	246.35	246.35	246.35	246.35	1092.0
2018-12-21 04:17:00	SPY	ETF	246.29	246.29	246.27	246.27	2500.0
2018-12-21 04:18:00	SPY	ETF	246.3	246.3	246.3	246.3	160.0
2018-12-21 04:19:00	SPY	ETF	246.15	246.22	246.15	246.22	3300.0
2018-12-21 04:22:00	SPY	ETF	246.05	246.05	246.05	246.05	163.0
2018-12-21 04:23:00	SPY	ETF	245.95	245.95	245.84	245.84	3225.0
2018-12-21 04:24:00	SPY	ETF	245.95	245.95	245.89	245.89	1200.0
2018-12-21 04:25:00	SPY	ETF	245.83	245.89	245.81	245.89	1065.0
2018-12-21 04:27:00	SPY	ETF	245.86	245.86	245.86	245.86	1025.0
2018-12-21 04:28:00	SPY	ETF	245.83	245.91	245.83	245.91	1014.0
2018-12-21 04:29:00	SPY	ETF	246.19	246.19	246.19	246.19	650.0
2018-12-21 04:31:00	SPY	ETF	246.14	246.19	246.14	246.19	2400.0
2018-12-21 04:32:00	SPY	ETF	246.21	246.21	246.21	246.21	400.0
2018-12-21 04:33:00	SPY	ETF	246.24	246.24	246.13	246.13	515.0
2018-12-21 04:35:00	SPY	ETF	245.97	245.97	245.97	245.97	110.0
2018-12-21 04:36:00	SPY	ETF	246.1	246.25	246.1	246.25	725.0
2018-12-21 04:39:00	SPY	ETF	246.13	246.13	246.13	246.13	100.0
2018-12-21 04:40:00	SPY	ETF	246.3	246.3	246.3	246.3	100.0
2018-12-21 04:45:00	SPY	ETF	246.24	246.24	246.24	246.24	300.0
2018-12-21 04:48:00	SPY	ETF	246.21	246.21	246.21	246.21	169.0
2018-12-21 04:49:00	SPY	ETF	246.21	246.29	246.21	246.29	400.0
2018-12-21 04:50:00	SPY	ETF	246.24	246.24	246.2	246.2	338.0
2018-12-21 04:51:00	SPY	ETF	246.18	246.24	246.18	246.22	1769.0
2018-12-21 04:52:00	SPY	ETF	246.18	246.23	246.18	246.23	569.0
2018-12-21 04:53:00	SPY	ETF	246.2	246.2	246.2	246.2	400.0
2018-12-21 04:54:00	SPY	ETF	246.19	246.32	246.19	246.32	1300.0
2018-12-21 04:55:00	SPY	ETF	246.35	246.4	246.35	246.4	1600.0
2018-12-21 04:56:00	SPY	ETF	246.39	246.39	246.39	246.39	200.0
2018-12-21 04:57:00	SPY	ETF	246.36	246.36	246.32	246.32	469.0
2018-12-21 04:59:00	SPY	ETF	246.36	246.36	246.36	246.36	100.0
2018-12-21 05:00:00	SPY	ETF	246.35	246.37	246.35	246.37	2100.0
2018-12-21 05:01:00	SPY	ETF	246.29	246.29	246.28	246.28	5159.0
2018-12-21 05:03:00	SPY	ETF	246.24	246.24	246.2	246.2	338.0
2018-12-21 05:04:00	SPY	ETF	246.29	246.29	246.09	246.21	2957.0

> showing 50 of 226,876 rows — these rows as CSV

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