PREVIEW / etf_1min / 2016-06-23

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-06-23.parquet
  size:    2.5 MB
  rows:    136,792

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
2016-06-23 04:09:00	SPY	ETF	209.06	209.1	209.06	209.07	603.0
2016-06-23 04:10:00	SPY	ETF	209.05	209.05	209.05	209.05	212.0
2016-06-23 04:19:00	SPY	ETF	209.14	209.14	209.14	209.14	300.0
2016-06-23 04:23:00	SPY	ETF	209.2	209.23	209.2	209.23	300.0
2016-06-23 04:25:00	SPY	ETF	209.2	209.2	209.2	209.2	108.0
2016-06-23 04:31:00	SPY	ETF	209.21	209.23	209.21	209.23	501.0
2016-06-23 04:33:00	SPY	ETF	209.28	209.29	209.28	209.29	1403.0
2016-06-23 04:35:00	SPY	ETF	209.28	209.28	209.28	209.28	300.0
2016-06-23 04:40:00	SPY	ETF	209.28	209.28	209.28	209.28	254.0
2016-06-23 04:42:00	SPY	ETF	209.33	209.33	209.33	209.33	301.0
2016-06-23 04:51:00	SPY	ETF	209.28	209.28	209.28	209.28	2591.0
2016-06-23 04:52:00	SPY	ETF	209.34	209.34	209.34	209.34	103.0
2016-06-23 04:53:00	SPY	ETF	209.37	209.37	209.37	209.37	401.0
2016-06-23 04:54:00	SPY	ETF	209.35	209.35	209.3	209.31	2704.0
2016-06-23 04:55:00	SPY	ETF	209.33	209.33	209.33	209.33	101.0
2016-06-23 05:00:00	SPY	ETF	209.35	209.41	209.35	209.41	5707.0
2016-06-23 05:02:00	SPY	ETF	209.37	209.37	209.37	209.37	112.0
2016-06-23 05:03:00	SPY	ETF	209.37	209.37	209.37	209.37	199.0
2016-06-23 05:05:00	SPY	ETF	209.4	209.4	209.4	209.4	203.0
2016-06-23 05:06:00	SPY	ETF	209.45	209.5	209.45	209.5	1066.0
2016-06-23 05:07:00	SPY	ETF	209.56	210.11	209.56	210.11	13025.0
2016-06-23 05:08:00	SPY	ETF	210.11	210.11	210.02	210.02	1389.0
2016-06-23 05:09:00	SPY	ETF	209.97	209.97	209.97	209.97	358.0
2016-06-23 05:10:00	SPY	ETF	209.97	209.98	209.96	209.98	989.0
2016-06-23 05:11:00	SPY	ETF	210.1	210.1	210.1	210.1	932.0
2016-06-23 05:12:00	SPY	ETF	210.11	210.11	210.11	210.11	1676.0
2016-06-23 05:13:00	SPY	ETF	210.17	210.21	210.17	210.21	672.0
2016-06-23 05:14:00	SPY	ETF	210.23	210.23	210.15	210.15	2102.0
2016-06-23 05:15:00	SPY	ETF	210.17	210.17	210.11	210.11	806.0
2016-06-23 05:16:00	SPY	ETF	210.12	210.13	210.12	210.13	501.0
2016-06-23 05:17:00	SPY	ETF	210.1	210.15	210.1	210.15	402.0
2016-06-23 05:18:00	SPY	ETF	210.17	210.17	210.17	210.17	105.0
2016-06-23 05:19:00	SPY	ETF	210.24	210.28	210.24	210.28	5450.0
2016-06-23 05:20:00	SPY	ETF	210.27	210.55	210.27	210.52	24941.0
2016-06-23 05:21:00	SPY	ETF	210.4	210.4	210.31	210.34	25919.0
2016-06-23 05:23:00	SPY	ETF	210.17	210.18	210.17	210.18	15079.0
2016-06-23 05:24:00	SPY	ETF	210.25	210.25	210.25	210.25	166.0
2016-06-23 05:25:00	SPY	ETF	210.31	210.31	210.31	210.31	110.0
2016-06-23 05:26:00	SPY	ETF	210.37	210.37	210.32	210.34	455.0
2016-06-23 05:27:00	SPY	ETF	210.29	210.29	210.28	210.28	432.0
2016-06-23 05:28:00	SPY	ETF	210.29	210.29	210.24	210.24	601.0
2016-06-23 05:29:00	SPY	ETF	210.19	210.19	210.19	210.19	15057.0
2016-06-23 05:30:00	SPY	ETF	210.24	210.36	210.24	210.36	4455.0
2016-06-23 05:33:00	SPY	ETF	210.25	210.25	210.16	210.16	3313.0
2016-06-23 05:34:00	SPY	ETF	210.15	210.21	210.15	210.18	2152.0
2016-06-23 05:35:00	SPY	ETF	210.16	210.16	210.06	210.08	2173.0
2016-06-23 05:36:00	SPY	ETF	210.06	210.06	210.0	210.0	1323.0
2016-06-23 05:38:00	SPY	ETF	210.1	210.1	210.1	210.1	952.0
2016-06-23 05:39:00	SPY	ETF	210.1	210.16	210.1	210.16	1718.0
2016-06-23 05:40:00	SPY	ETF	210.12	210.12	210.12	210.12	1300.0

> showing 50 of 136,792 rows — these rows as CSV

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