PREVIEW / etf_1min / 2014-08-22

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-08-22.parquet
  size:    2.0 MB
  rows:    102,587

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-08-22 04:04:00	SPY	ETF	199.64	199.64	199.63	199.63	2500.0
2014-08-22 04:12:00	SPY	ETF	199.62	199.62	199.62	199.62	200.0
2014-08-22 04:14:00	SPY	ETF	199.66	199.66	199.66	199.66	164.0
2014-08-22 04:33:00	SPY	ETF	199.59	199.59	199.59	199.59	1000.0
2014-08-22 04:34:00	SPY	ETF	199.63	199.63	199.63	199.63	228.0
2014-08-22 04:54:00	SPY	ETF	199.65	199.65	199.65	199.65	500.0
2014-08-22 04:57:00	SPY	ETF	199.57	199.57	199.57	199.57	100.0
2014-08-22 05:00:00	SPY	ETF	199.58	199.58	199.58	199.58	300.0
2014-08-22 05:09:00	SPY	ETF	199.51	199.51	199.51	199.51	151.0
2014-08-22 05:27:00	SPY	ETF	199.43	199.43	199.43	199.43	200.0
2014-08-22 05:32:00	SPY	ETF	199.42	199.42	199.42	199.42	140.0
2014-08-22 05:38:00	SPY	ETF	199.43	199.43	199.43	199.43	115.0
2014-08-22 05:40:00	SPY	ETF	199.49	199.49	199.49	199.49	28300.0
2014-08-22 06:00:00	SPY	ETF	199.4	199.42	199.4	199.42	5231.0
2014-08-22 06:09:00	SPY	ETF	199.44	199.44	199.42	199.42	424.0
2014-08-22 06:12:00	SPY	ETF	199.39	199.39	199.39	199.39	457.0
2014-08-22 06:16:00	SPY	ETF	199.35	199.35	199.35	199.35	100.0
2014-08-22 06:17:00	SPY	ETF	199.3	199.3	199.27	199.27	2296.0
2014-08-22 06:20:00	SPY	ETF	199.19	199.19	199.14	199.14	428.0
2014-08-22 06:21:00	SPY	ETF	199.11	199.11	199.08	199.09	796.0
2014-08-22 06:22:00	SPY	ETF	199.13	199.13	199.13	199.13	100.0
2014-08-22 06:23:00	SPY	ETF	199.13	199.13	199.13	199.13	400.0
2014-08-22 06:24:00	SPY	ETF	199.1	199.1	199.1	199.1	80000.0
2014-08-22 06:25:00	SPY	ETF	199.05	199.06	199.0	199.0	1317.0
2014-08-22 06:26:00	SPY	ETF	198.92	198.92	198.92	198.92	1286.0
2014-08-22 06:27:00	SPY	ETF	198.96	198.96	198.96	198.96	330.0
2014-08-22 06:28:00	SPY	ETF	198.95	198.98	198.94	198.98	5500.0
2014-08-22 06:30:00	SPY	ETF	198.91	198.95	198.9	198.95	1300.0
2014-08-22 06:31:00	SPY	ETF	199.04	199.05	199.02	199.02	1125.0
2014-08-22 06:33:00	SPY	ETF	199.1	199.1	199.1	199.1	815.0
2014-08-22 06:34:00	SPY	ETF	199.2	199.23	199.2	199.23	200.0
2014-08-22 06:35:00	SPY	ETF	199.3	199.3	199.27	199.27	600.0
2014-08-22 06:37:00	SPY	ETF	199.21	199.21	199.21	199.21	130.0
2014-08-22 06:38:00	SPY	ETF	199.24	199.24	199.24	199.24	2500.0
2014-08-22 06:39:00	SPY	ETF	199.2	199.2	199.2	199.2	171.0
2014-08-22 06:42:00	SPY	ETF	199.15	199.15	199.15	199.15	10005.0
2014-08-22 06:43:00	SPY	ETF	199.15	199.15	199.15	199.15	1200.0
2014-08-22 06:44:00	SPY	ETF	199.12	199.12	199.12	199.12	300.0
2014-08-22 06:47:00	SPY	ETF	199.2	199.2	199.2	199.2	100.0
2014-08-22 06:49:00	SPY	ETF	199.22	199.22	199.22	199.22	250.0
2014-08-22 06:50:00	SPY	ETF	199.25	199.25	199.25	199.25	100.0
2014-08-22 06:51:00	SPY	ETF	199.22	199.22	199.22	199.22	1000.0
2014-08-22 06:57:00	SPY	ETF	199.26	199.26	199.26	199.26	500.0
2014-08-22 06:58:00	SPY	ETF	199.27	199.27	199.27	199.27	409.0
2014-08-22 07:00:00	SPY	ETF	199.28	199.28	199.27	199.28	6400.0
2014-08-22 07:01:00	SPY	ETF	199.27	199.3	199.27	199.3	1200.0
2014-08-22 07:02:00	SPY	ETF	199.27	199.27	199.27	199.27	2700.0
2014-08-22 07:03:00	SPY	ETF	199.31	199.31	199.29	199.29	5300.0
2014-08-22 07:04:00	SPY	ETF	199.29	199.29	199.29	199.29	100.0
2014-08-22 07:05:00	SPY	ETF	199.31	199.31	199.23	199.23	4500.0

> showing 50 of 102,587 rows — these rows as CSV

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