PREVIEW / etf_1min / 2014-07-17

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-07-17.parquet
  size:    2.4 MB
  rows:    119,803

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-07-17 04:00:00	SPY	ETF	197.68	197.68	197.68	197.68	225.0
2014-07-17 04:01:00	SPY	ETF	197.65	197.65	197.65	197.65	422.0
2014-07-17 04:06:00	SPY	ETF	197.7	197.7	197.7	197.7	3050.0
2014-07-17 04:13:00	SPY	ETF	197.49	197.49	197.49	197.49	200.0
2014-07-17 04:17:00	SPY	ETF	197.61	197.61	197.61	197.61	200.0
2014-07-17 04:24:00	SPY	ETF	197.56	197.56	197.56	197.56	2700.0
2014-07-17 04:30:00	SPY	ETF	197.54	197.54	197.54	197.54	147.0
2014-07-17 04:41:00	SPY	ETF	197.54	197.54	197.54	197.54	300.0
2014-07-17 04:43:00	SPY	ETF	197.51	197.51	197.51	197.51	3000.0
2014-07-17 04:53:00	SPY	ETF	197.5	197.5	197.5	197.5	100.0
2014-07-17 05:05:00	SPY	ETF	197.42	197.42	197.42	197.42	194.0
2014-07-17 05:06:00	SPY	ETF	197.5	197.5	197.5	197.5	100.0
2014-07-17 05:18:00	SPY	ETF	197.41	197.41	197.41	197.41	183.0
2014-07-17 05:21:00	SPY	ETF	197.39	197.39	197.28	197.28	5499.0
2014-07-17 05:35:00	SPY	ETF	197.38	197.38	197.38	197.38	175.0
2014-07-17 05:41:00	SPY	ETF	197.37	197.37	197.37	197.37	100.0
2014-07-17 05:42:00	SPY	ETF	197.35	197.35	197.35	197.35	105.0
2014-07-17 05:43:00	SPY	ETF	197.34	197.34	197.29	197.29	400.0
2014-07-17 05:44:00	SPY	ETF	197.28	197.29	197.25	197.25	600.0
2014-07-17 05:46:00	SPY	ETF	197.25	197.26	197.25	197.26	700.0
2014-07-17 05:47:00	SPY	ETF	197.24	197.25	197.23	197.23	1201.0
2014-07-17 05:51:00	SPY	ETF	197.28	197.28	197.27	197.27	200.0
2014-07-17 05:58:00	SPY	ETF	197.25	197.25	197.25	197.25	216.0
2014-07-17 06:01:00	SPY	ETF	197.24	197.24	197.23	197.23	5366.0
2014-07-17 06:02:00	SPY	ETF	197.21	197.21	197.21	197.21	100.0
2014-07-17 06:04:00	SPY	ETF	197.25	197.25	197.25	197.25	2000.0
2014-07-17 06:06:00	SPY	ETF	197.24	197.24	197.24	197.24	100.0
2014-07-17 06:07:00	SPY	ETF	197.24	197.24	197.24	197.24	200.0
2014-07-17 06:08:00	SPY	ETF	197.21	197.21	197.2	197.2	5000.0
2014-07-17 06:13:00	SPY	ETF	197.24	197.24	197.22	197.22	465.0
2014-07-17 06:14:00	SPY	ETF	197.2	197.2	197.2	197.2	100.0
2014-07-17 06:19:00	SPY	ETF	197.19	197.19	197.19	197.19	100.0
2014-07-17 06:21:00	SPY	ETF	197.18	197.18	197.18	197.18	200.0
2014-07-17 06:22:00	SPY	ETF	197.18	197.18	197.18	197.18	150.0
2014-07-17 06:25:00	SPY	ETF	197.21	197.21	197.21	197.21	100.0
2014-07-17 06:26:00	SPY	ETF	197.21	197.21	197.21	197.21	100.0
2014-07-17 06:30:00	SPY	ETF	197.21	197.21	197.21	197.21	170.0
2014-07-17 06:31:00	SPY	ETF	197.21	197.21	197.21	197.21	4730.0
2014-07-17 06:32:00	SPY	ETF	197.19	197.19	197.16	197.16	200.0
2014-07-17 06:34:00	SPY	ETF	197.18	197.18	197.18	197.18	200.0
2014-07-17 06:35:00	SPY	ETF	197.19	197.21	197.19	197.21	5000.0
2014-07-17 06:37:00	SPY	ETF	197.17	197.17	197.16	197.16	2500.0
2014-07-17 06:39:00	SPY	ETF	197.17	197.17	197.14	197.14	1135.0
2014-07-17 06:40:00	SPY	ETF	197.18	197.18	197.18	197.18	2003.0
2014-07-17 06:42:00	SPY	ETF	197.16	197.16	197.16	197.16	300.0
2014-07-17 06:43:00	SPY	ETF	197.14	197.14	197.03	197.03	6024.0
2014-07-17 06:44:00	SPY	ETF	197.0	197.0	196.94	196.94	2700.0
2014-07-17 06:46:00	SPY	ETF	196.9	196.9	196.87	196.87	5310.0
2014-07-17 06:47:00	SPY	ETF	196.77	196.88	196.77	196.83	550.0
2014-07-17 06:48:00	SPY	ETF	196.81	196.83	196.8	196.8	1000.0

> showing 50 of 119,803 rows — these rows as CSV

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