PREVIEW / etf_1min / 2018-05-30

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-05-30.parquet
  size:    2.9 MB
  rows:    156,675

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-05-30 04:00:00	SPY	ETF	270.16	270.18	270.16	270.18	580.0
2018-05-30 04:05:00	SPY	ETF	270.38	270.38	270.38	270.38	250.0
2018-05-30 04:13:00	SPY	ETF	270.38	270.38	270.38	270.38	250.0
2018-05-30 04:14:00	SPY	ETF	270.4	270.4	270.4	270.4	100.0
2018-05-30 04:18:00	SPY	ETF	270.36	270.36	270.32	270.32	338.0
2018-05-30 04:19:00	SPY	ETF	270.36	270.36	270.34	270.34	692.0
2018-05-30 04:22:00	SPY	ETF	270.38	270.38	270.38	270.38	100.0
2018-05-30 04:24:00	SPY	ETF	270.27	270.27	270.2	270.2	350.0
2018-05-30 04:25:00	SPY	ETF	270.25	270.25	270.16	270.16	1100.0
2018-05-30 04:26:00	SPY	ETF	270.2	270.2	270.15	270.15	1199.0
2018-05-30 04:28:00	SPY	ETF	270.17	270.17	270.17	270.17	300.0
2018-05-30 04:29:00	SPY	ETF	270.15	270.15	270.1	270.1	1400.0
2018-05-30 04:31:00	SPY	ETF	270.15	270.15	270.15	270.15	725.0
2018-05-30 04:33:00	SPY	ETF	270.13	270.13	270.13	270.13	300.0
2018-05-30 04:34:00	SPY	ETF	270.17	270.17	270.14	270.14	800.0
2018-05-30 04:35:00	SPY	ETF	270.2	270.2	270.2	270.2	500.0
2018-05-30 04:36:00	SPY	ETF	270.05	270.05	270.05	270.05	1000.0
2018-05-30 04:39:00	SPY	ETF	269.92	269.92	269.88	269.88	2000.0
2018-05-30 04:40:00	SPY	ETF	269.86	269.86	269.85	269.85	2300.0
2018-05-30 04:43:00	SPY	ETF	269.85	269.85	269.85	269.85	300.0
2018-05-30 04:45:00	SPY	ETF	269.81	269.81	269.8	269.8	2000.0
2018-05-30 04:53:00	SPY	ETF	269.88	269.88	269.88	269.88	100.0
2018-05-30 05:02:00	SPY	ETF	270.25	270.25	270.25	270.25	100.0
2018-05-30 05:03:00	SPY	ETF	270.33	270.35	270.33	270.35	1200.0
2018-05-30 05:04:00	SPY	ETF	270.36	270.36	270.36	270.36	1300.0
2018-05-30 05:07:00	SPY	ETF	270.4	270.43	270.4	270.43	2205.0
2018-05-30 05:08:00	SPY	ETF	270.38	270.38	270.38	270.38	100.0
2018-05-30 05:09:00	SPY	ETF	270.41	270.41	270.38	270.38	600.0
2018-05-30 05:13:00	SPY	ETF	270.4	270.42	270.4	270.42	1800.0
2018-05-30 05:19:00	SPY	ETF	270.22	270.22	270.2	270.2	1300.0
2018-05-30 05:20:00	SPY	ETF	270.2	270.23	270.2	270.23	1200.0
2018-05-30 05:21:00	SPY	ETF	270.26	270.26	270.26	270.26	500.0
2018-05-30 05:22:00	SPY	ETF	270.31	270.31	270.29	270.29	1000.0
2018-05-30 05:27:00	SPY	ETF	270.22	270.22	270.22	270.22	500.0
2018-05-30 05:33:00	SPY	ETF	270.1	270.1	270.1	270.1	1850.0
2018-05-30 05:34:00	SPY	ETF	270.04	270.04	269.96	269.96	1400.0
2018-05-30 05:38:00	SPY	ETF	270.0	270.0	270.0	270.0	105.0
2018-05-30 05:41:00	SPY	ETF	270.16	270.16	270.16	270.16	355.0
2018-05-30 05:43:00	SPY	ETF	270.16	270.16	270.16	270.16	350.0
2018-05-30 05:44:00	SPY	ETF	270.35	270.35	270.35	270.35	500.0
2018-05-30 05:45:00	SPY	ETF	270.38	270.38	270.38	270.38	105.0
2018-05-30 05:46:00	SPY	ETF	270.46	270.5	270.38	270.38	2003.0
2018-05-30 05:47:00	SPY	ETF	270.43	270.43	270.4	270.4	29500.0
2018-05-30 05:48:00	SPY	ETF	270.41	270.43	270.4	270.4	12100.0
2018-05-30 05:49:00	SPY	ETF	270.4	270.4	270.4	270.4	10100.0
2018-05-30 05:52:00	SPY	ETF	270.51	270.51	270.51	270.51	605.0
2018-05-30 05:53:00	SPY	ETF	270.52	270.52	270.52	270.52	1300.0
2018-05-30 05:54:00	SPY	ETF	270.48	270.48	270.48	270.48	100.0
2018-05-30 05:55:00	SPY	ETF	270.54	270.54	270.54	270.54	700.0
2018-05-30 05:56:00	SPY	ETF	270.57	270.62	270.55	270.55	1810.0

> showing 50 of 156,675 rows — these rows as CSV

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