PREVIEW / etf_1min / 2012-11-21

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-11-21.parquet
  size:    1.7 MB
  rows:    93,017

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
2012-11-21 04:01:00	SPY	ETF	139.07	139.07	139.07	139.07	100.0
2012-11-21 04:03:00	SPY	ETF	139.05	139.05	139.05	139.05	100.0
2012-11-21 04:05:00	SPY	ETF	139.07	139.07	139.07	139.07	100.0
2012-11-21 04:07:00	SPY	ETF	139.1	139.1	139.1	139.1	100.0
2012-11-21 04:08:00	SPY	ETF	139.12	139.12	139.12	139.12	29395.0
2012-11-21 04:51:00	SPY	ETF	139.14	139.14	139.12	139.12	12000.0
2012-11-21 05:07:00	SPY	ETF	139.07	139.07	139.07	139.07	2500.0
2012-11-21 05:09:00	SPY	ETF	139.06	139.06	139.06	139.06	1500.0
2012-11-21 05:12:00	SPY	ETF	139.0	139.0	138.9	138.9	650.0
2012-11-21 05:16:00	SPY	ETF	139.01	139.01	139.01	139.01	200.0
2012-11-21 05:18:00	SPY	ETF	138.98	139.02	138.98	139.02	900.0
2012-11-21 05:20:00	SPY	ETF	139.02	139.02	139.02	139.02	1000.0
2012-11-21 05:29:00	SPY	ETF	139.05	139.17	139.05	139.17	3500.0
2012-11-21 05:30:00	SPY	ETF	139.17	139.17	139.16	139.16	1900.0
2012-11-21 05:39:00	SPY	ETF	139.07	139.07	139.07	139.07	300.0
2012-11-21 05:43:00	SPY	ETF	139.07	139.07	139.03	139.03	3500.0
2012-11-21 05:50:00	SPY	ETF	139.03	139.03	139.03	139.03	100.0
2012-11-21 05:52:00	SPY	ETF	139.07	139.07	139.07	139.07	200.0
2012-11-21 05:58:00	SPY	ETF	139.15	139.15	139.15	139.15	200.0
2012-11-21 06:01:00	SPY	ETF	139.17	139.17	139.17	139.17	3000.0
2012-11-21 06:05:00	SPY	ETF	139.22	139.22	139.22	139.22	1000.0
2012-11-21 06:06:00	SPY	ETF	139.25	139.32	139.25	139.32	7000.0
2012-11-21 06:15:00	SPY	ETF	139.27	139.3	139.24	139.24	125300.0
2012-11-21 06:21:00	SPY	ETF	139.24	139.24	139.24	139.24	3000.0
2012-11-21 06:22:00	SPY	ETF	139.24	139.24	139.24	139.24	200.0
2012-11-21 06:24:00	SPY	ETF	139.25	139.25	139.25	139.25	100.0
2012-11-21 06:25:00	SPY	ETF	139.28	139.28	139.28	139.28	6000.0
2012-11-21 06:35:00	SPY	ETF	139.3	139.3	139.26	139.26	500.0
2012-11-21 06:37:00	SPY	ETF	139.21	139.21	139.21	139.21	100.0
2012-11-21 06:40:00	SPY	ETF	139.19	139.19	139.19	139.19	1500.0
2012-11-21 06:41:00	SPY	ETF	139.22	139.22	139.22	139.22	9000.0
2012-11-21 06:43:00	SPY	ETF	139.2	139.25	139.2	139.25	6000.0
2012-11-21 06:46:00	SPY	ETF	139.24	139.24	139.24	139.24	100.0
2012-11-21 06:47:00	SPY	ETF	139.24	139.24	139.24	139.24	5000.0
2012-11-21 06:49:00	SPY	ETF	139.24	139.24	139.24	139.24	5000.0
2012-11-21 06:50:00	SPY	ETF	139.22	139.23	139.22	139.23	200.0
2012-11-21 06:51:00	SPY	ETF	139.24	139.24	139.24	139.24	100.0
2012-11-21 06:53:00	SPY	ETF	139.29	139.29	139.29	139.29	200.0
2012-11-21 06:54:00	SPY	ETF	139.4	139.42	139.4	139.42	450.0
2012-11-21 06:59:00	SPY	ETF	139.39	139.41	139.39	139.41	42100.0
2012-11-21 07:00:00	SPY	ETF	139.41	139.46	139.41	139.46	35300.0
2012-11-21 07:01:00	SPY	ETF	139.47	139.47	139.46	139.46	14800.0
2012-11-21 07:02:00	SPY	ETF	139.44	139.44	139.44	139.44	600.0
2012-11-21 07:04:00	SPY	ETF	139.4	139.4	139.4	139.4	100.0
2012-11-21 07:05:00	SPY	ETF	139.36	139.36	139.34	139.34	561.0
2012-11-21 07:06:00	SPY	ETF	139.32	139.32	139.31	139.31	4100.0
2012-11-21 07:07:00	SPY	ETF	139.32	139.32	139.31	139.31	400.0
2012-11-21 07:08:00	SPY	ETF	139.33	139.35	139.33	139.35	1100.0
2012-11-21 07:10:00	SPY	ETF	139.31	139.31	139.31	139.31	100.0
2012-11-21 07:11:00	SPY	ETF	139.32	139.32	139.32	139.32	4000.0

> showing 50 of 93,017 rows — these rows as CSV

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