PREVIEW / etf_1min / 2018-10-16

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-10-16.parquet
  size:    3.4 MB
  rows:    170,761

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-10-16 04:00:00	SPY	ETF	275.01	275.01	274.95	275.0	3150.0
2018-10-16 04:03:00	SPY	ETF	275.1	275.12	275.09	275.12	2600.0
2018-10-16 04:04:00	SPY	ETF	275.18	275.18	275.18	275.18	1650.0
2018-10-16 04:05:00	SPY	ETF	275.19	275.19	275.19	275.19	300.0
2018-10-16 04:07:00	SPY	ETF	275.28	275.28	275.24	275.24	3500.0
2018-10-16 04:08:00	SPY	ETF	275.25	275.25	275.25	275.25	700.0
2018-10-16 04:09:00	SPY	ETF	275.25	275.25	275.25	275.25	100.0
2018-10-16 04:11:00	SPY	ETF	275.31	275.32	275.3	275.3	1700.0
2018-10-16 04:12:00	SPY	ETF	275.31	275.31	275.29	275.29	1500.0
2018-10-16 04:13:00	SPY	ETF	275.29	275.29	275.29	275.29	400.0
2018-10-16 04:15:00	SPY	ETF	275.26	275.26	275.24	275.26	1150.0
2018-10-16 04:16:00	SPY	ETF	275.26	275.26	275.26	275.26	515.0
2018-10-16 04:17:00	SPY	ETF	275.33	275.34	275.32	275.34	3200.0
2018-10-16 04:18:00	SPY	ETF	275.35	275.38	275.35	275.38	1200.0
2018-10-16 04:20:00	SPY	ETF	275.4	275.4	275.38	275.38	200.0
2018-10-16 04:21:00	SPY	ETF	275.32	275.32	275.27	275.27	350.0
2018-10-16 04:22:00	SPY	ETF	275.31	275.35	275.3	275.35	2700.0
2018-10-16 04:25:00	SPY	ETF	275.26	275.26	275.26	275.26	400.0
2018-10-16 04:26:00	SPY	ETF	275.33	275.41	275.33	275.41	1600.0
2018-10-16 04:28:00	SPY	ETF	275.42	275.45	275.42	275.45	300.0
2018-10-16 04:33:00	SPY	ETF	275.26	275.26	275.17	275.17	3510.0
2018-10-16 04:34:00	SPY	ETF	275.14	275.17	275.14	275.17	1150.0
2018-10-16 04:35:00	SPY	ETF	275.14	275.14	275.11	275.11	1905.0
2018-10-16 04:37:00	SPY	ETF	275.13	275.13	275.13	275.13	2500.0
2018-10-16 04:39:00	SPY	ETF	275.11	275.11	275.11	275.11	340.0
2018-10-16 04:41:00	SPY	ETF	275.11	275.11	275.11	275.11	300.0
2018-10-16 04:45:00	SPY	ETF	275.02	275.04	275.02	275.04	700.0
2018-10-16 04:46:00	SPY	ETF	275.06	275.06	275.06	275.06	300.0
2018-10-16 04:50:00	SPY	ETF	275.18	275.18	275.18	275.18	200.0
2018-10-16 04:51:00	SPY	ETF	275.26	275.26	275.26	275.26	300.0
2018-10-16 04:53:00	SPY	ETF	275.1	275.1	275.1	275.1	300.0
2018-10-16 04:55:00	SPY	ETF	275.13	275.13	275.13	275.13	1000.0
2018-10-16 04:56:00	SPY	ETF	275.03	275.03	275.03	275.03	100.0
2018-10-16 04:58:00	SPY	ETF	275.0	275.03	275.0	275.02	2100.0
2018-10-16 05:04:00	SPY	ETF	274.98	274.98	274.96	274.96	500.0
2018-10-16 05:08:00	SPY	ETF	275.01	275.01	275.01	275.01	500.0
2018-10-16 05:12:00	SPY	ETF	274.93	274.93	274.93	274.93	300.0
2018-10-16 05:14:00	SPY	ETF	274.92	274.92	274.88	274.88	300.0
2018-10-16 05:15:00	SPY	ETF	274.88	274.88	274.88	274.88	100.0
2018-10-16 05:16:00	SPY	ETF	274.94	274.94	274.94	274.94	1000.0
2018-10-16 05:17:00	SPY	ETF	275.01	275.01	275.01	275.01	1000.0
2018-10-16 05:19:00	SPY	ETF	274.98	274.98	274.98	274.98	550.0
2018-10-16 05:21:00	SPY	ETF	274.98	274.98	274.98	274.98	140.0
2018-10-16 05:22:00	SPY	ETF	274.91	274.91	274.9	274.9	1800.0
2018-10-16 05:23:00	SPY	ETF	274.87	274.87	274.86	274.86	400.0
2018-10-16 05:26:00	SPY	ETF	274.88	274.88	274.88	274.88	1000.0
2018-10-16 05:27:00	SPY	ETF	274.91	274.91	274.91	274.91	286.0
2018-10-16 05:28:00	SPY	ETF	274.85	274.85	274.84	274.84	2400.0
2018-10-16 05:38:00	SPY	ETF	274.78	274.78	274.78	274.78	1000.0
2018-10-16 05:41:00	SPY	ETF	274.91	274.91	274.91	274.91	400.0

> showing 50 of 170,761 rows — these rows as CSV

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