PREVIEW / etf_1min / 2013-01-22

all etf 1-min files

  file:    by_date/etf_1min/2013/2013-01-22.parquet
  size:    2.2 MB
  rows:    115,497

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
2013-01-22 04:00:00	SPY	ETF	148.2	148.2	148.02	148.02	900.0
2013-01-22 04:04:00	SPY	ETF	148.02	148.02	148.0	148.0	610.0
2013-01-22 04:05:00	SPY	ETF	147.99	147.99	147.94	147.94	2275.0
2013-01-22 04:09:00	SPY	ETF	147.98	147.98	147.96	147.96	529.0
2013-01-22 04:10:00	SPY	ETF	147.98	147.98	147.98	147.98	3200.0
2013-01-22 04:12:00	SPY	ETF	147.98	147.98	147.98	147.98	3500.0
2013-01-22 04:13:00	SPY	ETF	148.06	148.06	148.06	148.06	307.0
2013-01-22 04:15:00	SPY	ETF	148.01	148.01	148.01	148.01	100.0
2013-01-22 04:19:00	SPY	ETF	147.97	147.97	147.96	147.96	200.0
2013-01-22 04:20:00	SPY	ETF	148.02	148.02	148.02	148.02	100.0
2013-01-22 04:24:00	SPY	ETF	148.05	148.05	148.05	148.05	100.0
2013-01-22 04:31:00	SPY	ETF	148.04	148.04	148.04	148.04	500.0
2013-01-22 04:36:00	SPY	ETF	148.04	148.06	148.04	148.04	2400.0
2013-01-22 04:40:00	SPY	ETF	148.08	148.08	148.08	148.08	500.0
2013-01-22 04:42:00	SPY	ETF	148.08	148.08	148.08	148.08	500.0
2013-01-22 04:43:00	SPY	ETF	148.11	148.11	148.11	148.11	500.0
2013-01-22 04:46:00	SPY	ETF	148.14	148.18	148.14	148.18	1100.0
2013-01-22 04:55:00	SPY	ETF	148.06	148.06	148.05	148.05	400.0
2013-01-22 04:58:00	SPY	ETF	148.1	148.1	148.1	148.1	100.0
2013-01-22 04:59:00	SPY	ETF	148.11	148.11	148.11	148.11	200.0
2013-01-22 05:00:00	SPY	ETF	148.18	148.18	148.14	148.17	6000.0
2013-01-22 05:01:00	SPY	ETF	148.17	148.17	148.17	148.17	1000.0
2013-01-22 05:02:00	SPY	ETF	148.2	148.2	148.19	148.2	1100.0
2013-01-22 05:03:00	SPY	ETF	148.23	148.27	148.23	148.25	1000.0
2013-01-22 05:05:00	SPY	ETF	148.28	148.28	148.28	148.28	5000.0
2013-01-22 05:08:00	SPY	ETF	148.27	148.27	148.27	148.27	100.0
2013-01-22 05:14:00	SPY	ETF	148.2	148.2	148.2	148.2	200.0
2013-01-22 05:15:00	SPY	ETF	148.28	148.29	148.28	148.28	1400.0
2013-01-22 05:16:00	SPY	ETF	148.29	148.29	148.29	148.29	400.0
2013-01-22 05:19:00	SPY	ETF	148.39	148.39	148.39	148.39	400.0
2013-01-22 05:20:00	SPY	ETF	148.38	148.4	148.38	148.4	400.0
2013-01-22 05:21:00	SPY	ETF	148.42	148.45	148.42	148.45	20500.0
2013-01-22 05:23:00	SPY	ETF	148.4	148.43	148.4	148.43	2500.0
2013-01-22 05:24:00	SPY	ETF	148.42	148.42	148.42	148.42	5000.0
2013-01-22 05:25:00	SPY	ETF	148.42	148.42	148.42	148.42	200.0
2013-01-22 05:26:00	SPY	ETF	148.42	148.42	148.42	148.42	100.0
2013-01-22 05:30:00	SPY	ETF	148.43	148.43	148.43	148.43	100.0
2013-01-22 05:31:00	SPY	ETF	148.44	148.44	148.44	148.44	100.0
2013-01-22 05:32:00	SPY	ETF	148.43	148.43	148.43	148.43	100.0
2013-01-22 05:35:00	SPY	ETF	148.45	148.45	148.45	148.45	7936.0
2013-01-22 05:36:00	SPY	ETF	148.45	148.45	148.45	148.45	500.0
2013-01-22 05:39:00	SPY	ETF	148.45	148.45	148.45	148.45	1200.0
2013-01-22 05:40:00	SPY	ETF	148.48	148.48	148.48	148.48	200.0
2013-01-22 05:46:00	SPY	ETF	148.42	148.42	148.42	148.42	100.0
2013-01-22 05:47:00	SPY	ETF	148.42	148.42	148.42	148.42	100.0
2013-01-22 05:49:00	SPY	ETF	148.36	148.36	148.36	148.36	400.0
2013-01-22 05:52:00	SPY	ETF	148.37	148.37	148.37	148.37	7475.0
2013-01-22 05:55:00	SPY	ETF	148.4	148.4	148.4	148.4	100.0
2013-01-22 05:56:00	SPY	ETF	148.42	148.42	148.42	148.42	100.0
2013-01-22 05:57:00	SPY	ETF	148.37	148.37	148.37	148.37	5000.0

> showing 50 of 115,497 rows — these rows as CSV

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