PREVIEW / etf_1min / 2014-01-10

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-01-10.parquet
  size:    2.3 MB
  rows:    117,957

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
2014-01-10 04:00:00	SPY	ETF	183.8	184.06	183.8	184.06	737.0
2014-01-10 04:01:00	SPY	ETF	184.07	184.07	184.07	184.07	190.0
2014-01-10 04:16:00	SPY	ETF	184.09	184.09	184.09	184.09	100.0
2014-01-10 04:18:00	SPY	ETF	184.12	184.12	184.11	184.11	251.0
2014-01-10 04:31:00	SPY	ETF	184.12	184.12	184.12	184.12	191.0
2014-01-10 04:35:00	SPY	ETF	184.13	184.13	184.13	184.13	101.0
2014-01-10 04:41:00	SPY	ETF	184.14	184.14	184.14	184.14	200.0
2014-01-10 04:46:00	SPY	ETF	184.14	184.14	184.14	184.14	75000.0
2014-01-10 05:08:00	SPY	ETF	184.09	184.09	184.09	184.09	10000.0
2014-01-10 05:11:00	SPY	ETF	184.12	184.12	184.12	184.12	100.0
2014-01-10 05:15:00	SPY	ETF	184.17	184.17	184.17	184.17	200.0
2014-01-10 05:22:00	SPY	ETF	184.12	184.12	184.12	184.12	400.0
2014-01-10 05:31:00	SPY	ETF	184.11	184.11	184.11	184.11	262.0
2014-01-10 05:37:00	SPY	ETF	184.1	184.1	184.1	184.1	1000.0
2014-01-10 05:39:00	SPY	ETF	184.12	184.12	184.12	184.12	137.0
2014-01-10 05:47:00	SPY	ETF	184.14	184.14	184.14	184.14	952.0
2014-01-10 05:49:00	SPY	ETF	184.21	184.21	184.18	184.18	369.0
2014-01-10 05:55:00	SPY	ETF	184.25	184.25	184.25	184.25	100.0
2014-01-10 06:03:00	SPY	ETF	184.23	184.23	184.23	184.23	101.0
2014-01-10 06:07:00	SPY	ETF	184.25	184.25	184.25	184.25	250.0
2014-01-10 06:09:00	SPY	ETF	184.24	184.24	184.24	184.24	100.0
2014-01-10 06:13:00	SPY	ETF	184.26	184.27	184.25	184.25	538.0
2014-01-10 06:19:00	SPY	ETF	184.27	184.29	184.27	184.29	1093.0
2014-01-10 06:21:00	SPY	ETF	184.27	184.27	184.27	184.27	168.0
2014-01-10 06:27:00	SPY	ETF	184.28	184.28	184.24	184.24	525.0
2014-01-10 06:28:00	SPY	ETF	184.25	184.25	184.25	184.25	575.0
2014-01-10 06:32:00	SPY	ETF	184.26	184.27	184.26	184.27	5128.0
2014-01-10 06:33:00	SPY	ETF	184.25	184.25	184.25	184.25	1000.0
2014-01-10 06:34:00	SPY	ETF	184.27	184.27	184.27	184.27	10049.0
2014-01-10 06:37:00	SPY	ETF	184.27	184.27	184.27	184.27	200.0
2014-01-10 06:39:00	SPY	ETF	184.28	184.29	184.27	184.29	6194.0
2014-01-10 06:40:00	SPY	ETF	184.3	184.32	184.3	184.32	5457.0
2014-01-10 06:44:00	SPY	ETF	184.3	184.3	184.3	184.3	260.0
2014-01-10 06:49:00	SPY	ETF	184.28	184.28	184.28	184.28	160.0
2014-01-10 06:50:00	SPY	ETF	184.24	184.24	184.24	184.24	100.0
2014-01-10 06:57:00	SPY	ETF	184.24	184.24	184.24	184.24	305.0
2014-01-10 06:59:00	SPY	ETF	184.22	184.22	184.22	184.22	5000.0
2014-01-10 07:02:00	SPY	ETF	184.25	184.25	184.25	184.25	1500.0
2014-01-10 07:03:00	SPY	ETF	184.25	184.25	184.25	184.25	400.0
2014-01-10 07:05:00	SPY	ETF	184.25	184.25	184.25	184.25	1100.0
2014-01-10 07:06:00	SPY	ETF	184.22	184.26	184.22	184.26	2800.0
2014-01-10 07:07:00	SPY	ETF	184.22	184.22	184.22	184.22	100.0
2014-01-10 07:08:00	SPY	ETF	184.23	184.23	184.23	184.23	400.0
2014-01-10 07:10:00	SPY	ETF	184.25	184.25	184.25	184.25	189.0
2014-01-10 07:13:00	SPY	ETF	184.28	184.28	184.28	184.28	100000.0
2014-01-10 07:14:00	SPY	ETF	184.27	184.31	184.27	184.31	52000.0
2014-01-10 07:17:00	SPY	ETF	184.32	184.32	184.32	184.32	3960.0
2014-01-10 07:18:00	SPY	ETF	184.33	184.34	184.33	184.34	5400.0
2014-01-10 07:20:00	SPY	ETF	184.32	184.35	184.32	184.35	3005.0
2014-01-10 07:21:00	SPY	ETF	184.36	184.38	184.35	184.37	55245.0

> showing 50 of 117,957 rows — these rows as CSV

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