PREVIEW / etf_1min / 2014-01-09

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-01-09.parquet
  size:    2.3 MB
  rows:    118,396

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-09 04:08:00	SPY	ETF	183.57	183.57	183.57	183.57	10000.0
2014-01-09 04:10:00	SPY	ETF	183.64	183.64	183.64	183.64	100.0
2014-01-09 04:11:00	SPY	ETF	183.7	183.7	183.7	183.7	700.0
2014-01-09 04:15:00	SPY	ETF	183.7	183.73	183.7	183.73	800.0
2014-01-09 04:16:00	SPY	ETF	183.78	183.78	183.78	183.78	120.0
2014-01-09 04:18:00	SPY	ETF	183.88	184.12	183.88	184.04	11513.0
2014-01-09 04:21:00	SPY	ETF	184.02	184.02	184.02	184.02	100.0
2014-01-09 04:22:00	SPY	ETF	184.01	184.01	183.99	183.99	10100.0
2014-01-09 04:23:00	SPY	ETF	183.97	183.97	183.97	183.97	148.0
2014-01-09 04:25:00	SPY	ETF	184.01	184.01	184.01	184.01	189.0
2014-01-09 04:30:00	SPY	ETF	184.02	184.02	184.02	184.02	100.0
2014-01-09 04:31:00	SPY	ETF	184.02	184.02	184.02	184.02	100.0
2014-01-09 04:32:00	SPY	ETF	184.02	184.02	184.02	184.02	100.0
2014-01-09 04:33:00	SPY	ETF	183.99	183.99	183.99	183.99	500.0
2014-01-09 04:34:00	SPY	ETF	183.99	183.99	183.99	183.99	200.0
2014-01-09 04:37:00	SPY	ETF	184.01	184.02	184.01	184.02	500.0
2014-01-09 04:38:00	SPY	ETF	184.04	184.04	184.04	184.04	182.0
2014-01-09 04:41:00	SPY	ETF	184.04	184.04	184.04	184.04	100.0
2014-01-09 04:43:00	SPY	ETF	184.06	184.06	184.06	184.06	200.0
2014-01-09 04:46:00	SPY	ETF	184.07	184.07	184.07	184.07	185.0
2014-01-09 04:47:00	SPY	ETF	184.1	184.1	184.1	184.1	100.0
2014-01-09 04:50:00	SPY	ETF	184.07	184.07	184.07	184.07	10000.0
2014-01-09 04:54:00	SPY	ETF	184.07	184.07	184.07	184.07	200.0
2014-01-09 04:55:00	SPY	ETF	184.1	184.1	184.1	184.1	200.0
2014-01-09 04:56:00	SPY	ETF	184.11	184.11	184.11	184.11	300.0
2014-01-09 04:57:00	SPY	ETF	184.1	184.11	184.1	184.11	500.0
2014-01-09 04:58:00	SPY	ETF	184.07	184.07	184.07	184.07	231.0
2014-01-09 04:59:00	SPY	ETF	184.13	184.13	184.13	184.13	200.0
2014-01-09 05:07:00	SPY	ETF	184.14	184.14	184.14	184.14	150.0
2014-01-09 05:10:00	SPY	ETF	184.12	184.12	184.09	184.09	3000.0
2014-01-09 05:13:00	SPY	ETF	184.11	184.11	184.11	184.11	2000.0
2014-01-09 05:19:00	SPY	ETF	184.12	184.12	184.12	184.12	893.0
2014-01-09 05:20:00	SPY	ETF	184.12	184.19	184.12	184.19	3865.0
2014-01-09 05:24:00	SPY	ETF	184.19	184.19	184.19	184.19	100.0
2014-01-09 05:27:00	SPY	ETF	184.21	184.21	184.21	184.21	100.0
2014-01-09 05:28:00	SPY	ETF	184.21	184.21	184.21	184.21	1000.0
2014-01-09 05:30:00	SPY	ETF	184.18	184.18	184.18	184.18	100.0
2014-01-09 05:35:00	SPY	ETF	184.19	184.19	184.19	184.19	400.0
2014-01-09 05:36:00	SPY	ETF	184.2	184.2	184.2	184.2	160.0
2014-01-09 05:40:00	SPY	ETF	184.18	184.18	184.18	184.18	200.0
2014-01-09 05:41:00	SPY	ETF	184.17	184.17	184.17	184.17	200.0
2014-01-09 05:43:00	SPY	ETF	184.17	184.17	184.17	184.17	529.0
2014-01-09 05:45:00	SPY	ETF	184.17	184.17	184.17	184.17	1500.0
2014-01-09 05:53:00	SPY	ETF	184.14	184.14	184.14	184.14	61900.0
2014-01-09 05:57:00	SPY	ETF	184.14	184.14	184.14	184.14	1100.0
2014-01-09 06:00:00	SPY	ETF	184.17	184.17	184.17	184.17	1005.0
2014-01-09 06:01:00	SPY	ETF	184.16	184.16	184.16	184.16	400.0
2014-01-09 06:02:00	SPY	ETF	184.14	184.14	184.14	184.14	100.0
2014-01-09 06:07:00	SPY	ETF	184.12	184.12	184.12	184.12	502.0
2014-01-09 06:08:00	SPY	ETF	184.12	184.12	184.12	184.12	400.0

> showing 50 of 118,396 rows — these rows as CSV

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