PREVIEW / etf_1min / 2014-10-27

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-10-27.parquet
  size:    2.3 MB
  rows:    124,390

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-10-27 05:03:00	SPY	ETF	196.9	196.98	196.34	196.34	12816.0
2014-10-27 05:09:00	SPY	ETF	196.46	196.46	196.46	196.46	100.0
2014-10-27 05:13:00	SPY	ETF	196.6	196.66	196.59	196.59	2250.0
2014-10-27 05:18:00	SPY	ETF	196.48	196.51	196.48	196.51	2600.0
2014-10-27 05:19:00	SPY	ETF	196.46	196.46	196.46	196.46	150.0
2014-10-27 05:20:00	SPY	ETF	196.48	196.48	196.31	196.31	8650.0
2014-10-27 05:21:00	SPY	ETF	196.32	196.34	196.3	196.34	400.0
2014-10-27 05:22:00	SPY	ETF	196.31	196.31	196.31	196.31	200.0
2014-10-27 05:23:00	SPY	ETF	196.36	196.36	196.36	196.36	100.0
2014-10-27 05:24:00	SPY	ETF	196.34	196.34	196.34	196.34	2800.0
2014-10-27 05:25:00	SPY	ETF	196.34	196.34	196.34	196.34	200.0
2014-10-27 05:27:00	SPY	ETF	196.34	196.34	196.34	196.34	200.0
2014-10-27 05:32:00	SPY	ETF	196.48	196.48	196.46	196.46	1000.0
2014-10-27 05:33:00	SPY	ETF	196.4	196.4	196.39	196.39	2200.0
2014-10-27 05:35:00	SPY	ETF	196.34	196.34	196.34	196.34	500.0
2014-10-27 05:36:00	SPY	ETF	196.34	196.36	196.34	196.36	1000.0
2014-10-27 05:45:00	SPY	ETF	196.2	196.2	196.19	196.19	600.0
2014-10-27 05:47:00	SPY	ETF	196.18	196.18	196.06	196.06	1600.0
2014-10-27 05:48:00	SPY	ETF	196.0	196.0	196.0	196.0	530.0
2014-10-27 05:49:00	SPY	ETF	196.13	196.21	196.13	196.21	700.0
2014-10-27 05:50:00	SPY	ETF	196.16	196.16	196.14	196.16	650.0
2014-10-27 05:53:00	SPY	ETF	196.27	196.27	196.27	196.27	100.0
2014-10-27 05:54:00	SPY	ETF	196.26	196.26	196.26	196.26	200.0
2014-10-27 05:55:00	SPY	ETF	196.26	196.26	196.26	196.26	100.0
2014-10-27 05:58:00	SPY	ETF	196.28	196.28	196.28	196.28	700.0
2014-10-27 05:59:00	SPY	ETF	196.29	196.29	196.26	196.28	900.0
2014-10-27 06:00:00	SPY	ETF	196.19	196.19	196.16	196.16	44209.0
2014-10-27 06:01:00	SPY	ETF	196.15	196.15	196.08	196.08	500.0
2014-10-27 06:02:00	SPY	ETF	196.1	196.1	196.06	196.06	30000.0
2014-10-27 06:03:00	SPY	ETF	196.11	196.11	196.03	196.03	200.0
2014-10-27 06:04:00	SPY	ETF	196.06	196.11	196.06	196.11	28000.0
2014-10-27 06:05:00	SPY	ETF	196.09	196.11	196.09	196.1	1500.0
2014-10-27 06:06:00	SPY	ETF	196.06	196.13	196.06	196.13	10700.0
2014-10-27 06:07:00	SPY	ETF	196.11	196.14	196.09	196.13	1000.0
2014-10-27 06:08:00	SPY	ETF	196.16	196.16	196.11	196.11	700.0
2014-10-27 06:09:00	SPY	ETF	196.1	196.1	196.04	196.04	1600.0
2014-10-27 06:10:00	SPY	ETF	196.08	196.08	196.04	196.06	22500.0
2014-10-27 06:11:00	SPY	ETF	196.04	196.04	196.03	196.03	1410.0
2014-10-27 06:12:00	SPY	ETF	196.08	196.08	196.06	196.06	3700.0
2014-10-27 06:14:00	SPY	ETF	196.06	196.08	196.06	196.08	36300.0
2014-10-27 06:15:00	SPY	ETF	196.11	196.11	196.09	196.11	22490.0
2014-10-27 06:16:00	SPY	ETF	196.06	196.08	195.94	195.94	3034.0
2014-10-27 06:17:00	SPY	ETF	195.98	195.98	195.93	195.98	46500.0
2014-10-27 06:18:00	SPY	ETF	196.0	196.03	196.0	196.02	13000.0
2014-10-27 06:19:00	SPY	ETF	196.04	196.06	196.04	196.06	300.0
2014-10-27 06:20:00	SPY	ETF	196.11	196.11	196.08	196.08	8500.0
2014-10-27 06:21:00	SPY	ETF	196.11	196.11	196.11	196.11	500.0
2014-10-27 06:22:00	SPY	ETF	196.11	196.11	196.03	196.03	2550.0
2014-10-27 06:23:00	SPY	ETF	196.08	196.08	196.08	196.08	2050.0
2014-10-27 06:24:00	SPY	ETF	196.08	196.08	196.03	196.03	1950.0

> showing 50 of 124,390 rows — these rows as CSV

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