PREVIEW / etf_1min / 2014-10-17

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-10-17.parquet
  size:    2.7 MB
  rows:    139,964

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-17 04:00:00	SPY	ETF	187.0	187.3	187.0	187.3	1115.0
2014-10-17 04:01:00	SPY	ETF	187.3	187.3	187.3	187.3	2100.0
2014-10-17 04:03:00	SPY	ETF	187.31	187.31	187.3	187.3	732.0
2014-10-17 04:04:00	SPY	ETF	187.3	187.3	187.3	187.3	200.0
2014-10-17 04:07:00	SPY	ETF	187.41	187.41	187.41	187.41	200.0
2014-10-17 04:09:00	SPY	ETF	187.49	187.6	187.49	187.6	629.0
2014-10-17 04:10:00	SPY	ETF	187.75	187.75	187.75	187.75	100.0
2014-10-17 04:13:00	SPY	ETF	187.53	187.58	187.53	187.58	378.0
2014-10-17 04:15:00	SPY	ETF	187.52	187.52	187.52	187.52	175.0
2014-10-17 04:16:00	SPY	ETF	187.56	187.59	187.3	187.59	30356.0
2014-10-17 04:17:00	SPY	ETF	187.8	187.8	187.8	187.8	115.0
2014-10-17 04:18:00	SPY	ETF	187.95	187.95	187.4	187.4	300.0
2014-10-17 04:20:00	SPY	ETF	187.7	187.7	187.7	187.7	100.0
2014-10-17 04:21:00	SPY	ETF	187.98	188.0	187.98	188.0	235.0
2014-10-17 04:22:00	SPY	ETF	187.9	187.9	187.9	187.9	300.0
2014-10-17 04:24:00	SPY	ETF	187.86	187.86	187.86	187.86	100.0
2014-10-17 04:29:00	SPY	ETF	187.68	187.68	187.68	187.68	110.0
2014-10-17 04:34:00	SPY	ETF	187.7	187.72	187.7	187.72	400.0
2014-10-17 04:36:00	SPY	ETF	187.65	187.65	187.65	187.65	200.0
2014-10-17 04:39:00	SPY	ETF	187.84	187.84	187.84	187.84	100.0
2014-10-17 04:41:00	SPY	ETF	187.92	187.92	187.92	187.92	150.0
2014-10-17 04:45:00	SPY	ETF	187.89	187.89	187.89	187.89	200.0
2014-10-17 04:46:00	SPY	ETF	187.85	187.85	187.85	187.85	100.0
2014-10-17 04:47:00	SPY	ETF	187.92	188.19	187.92	188.19	790.0
2014-10-17 04:55:00	SPY	ETF	187.93	187.93	187.93	187.93	1000.0
2014-10-17 04:56:00	SPY	ETF	187.98	188.0	187.98	188.0	1000.0
2014-10-17 04:58:00	SPY	ETF	188.0	188.0	188.0	188.0	602.0
2014-10-17 05:06:00	SPY	ETF	188.09	188.2	188.09	188.2	3600.0
2014-10-17 05:11:00	SPY	ETF	188.03	188.03	188.03	188.03	100.0
2014-10-17 05:13:00	SPY	ETF	188.03	188.03	187.95	187.95	400.0
2014-10-17 05:16:00	SPY	ETF	188.0	188.0	188.0	188.0	500.0
2014-10-17 05:17:00	SPY	ETF	187.82	187.9	187.82	187.9	2000.0
2014-10-17 05:19:00	SPY	ETF	187.9	187.9	187.9	187.9	1000.0
2014-10-17 05:21:00	SPY	ETF	187.94	188.0	187.94	188.0	700.0
2014-10-17 05:22:00	SPY	ETF	188.04	188.04	188.04	188.04	200.0
2014-10-17 05:23:00	SPY	ETF	188.08	188.1	188.05	188.1	17650.0
2014-10-17 05:24:00	SPY	ETF	188.13	188.13	188.13	188.13	4800.0
2014-10-17 05:25:00	SPY	ETF	188.08	188.08	188.08	188.08	100.0
2014-10-17 05:26:00	SPY	ETF	188.1	188.1	188.1	188.1	500.0
2014-10-17 05:27:00	SPY	ETF	188.1	188.1	188.1	188.1	1000.0
2014-10-17 05:28:00	SPY	ETF	188.1	188.15	188.1	188.13	4710.0
2014-10-17 05:29:00	SPY	ETF	188.1	188.1	188.1	188.1	1605.0
2014-10-17 05:31:00	SPY	ETF	188.11	188.11	188.11	188.11	220.0
2014-10-17 05:32:00	SPY	ETF	188.08	188.08	188.08	188.08	1025.0
2014-10-17 05:35:00	SPY	ETF	188.08	188.08	188.05	188.05	10120.0
2014-10-17 05:36:00	SPY	ETF	188.0	188.0	188.0	188.0	10100.0
2014-10-17 05:37:00	SPY	ETF	187.93	188.0	187.93	187.95	3980.0
2014-10-17 05:38:00	SPY	ETF	187.98	188.0	187.98	188.0	400.0
2014-10-17 05:39:00	SPY	ETF	188.02	188.02	188.02	188.02	200.0
2014-10-17 05:41:00	SPY	ETF	188.06	188.12	188.06	188.12	10225.0

> showing 50 of 139,964 rows — these rows as CSV

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