PREVIEW / etf_1min / 2011-10-28

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-10-28.parquet
  size:    2.0 MB
  rows:    110,322

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
2011-10-28 04:00:00	SPY	ETF	128.5	128.5	128.41	128.41	600.0
2011-10-28 04:01:00	SPY	ETF	128.34	128.34	128.34	128.34	200.0
2011-10-28 04:02:00	SPY	ETF	128.33	128.33	128.33	128.33	100.0
2011-10-28 04:04:00	SPY	ETF	128.29	128.3	128.29	128.3	800.0
2011-10-28 04:14:00	SPY	ETF	128.69	128.69	128.69	128.69	100.0
2011-10-28 04:21:00	SPY	ETF	128.61	128.63	128.61	128.63	11798.0
2011-10-28 04:28:00	SPY	ETF	128.51	128.51	128.51	128.51	4550.0
2011-10-28 04:29:00	SPY	ETF	128.51	128.51	128.51	128.51	400.0
2011-10-28 04:37:00	SPY	ETF	128.51	128.51	128.51	128.51	300.0
2011-10-28 04:50:00	SPY	ETF	128.54	128.54	128.54	128.54	300.0
2011-10-28 05:06:00	SPY	ETF	128.59	128.59	128.59	128.59	2450.0
2011-10-28 05:17:00	SPY	ETF	128.31	128.31	128.31	128.31	4000.0
2011-10-28 05:22:00	SPY	ETF	128.38	128.38	128.38	128.38	200.0
2011-10-28 05:24:00	SPY	ETF	128.32	128.32	128.31	128.31	1400.0
2011-10-28 05:31:00	SPY	ETF	128.21	128.21	128.21	128.21	100.0
2011-10-28 05:32:00	SPY	ETF	128.2	128.2	128.2	128.2	100.0
2011-10-28 05:37:00	SPY	ETF	128.26	128.26	128.26	128.26	100.0
2011-10-28 05:38:00	SPY	ETF	128.25	128.25	128.25	128.25	100.0
2011-10-28 05:40:00	SPY	ETF	128.29	128.29	128.29	128.29	400.0
2011-10-28 05:45:00	SPY	ETF	128.18	128.18	128.18	128.18	500.0
2011-10-28 05:50:00	SPY	ETF	128.21	128.21	128.21	128.21	100.0
2011-10-28 05:52:00	SPY	ETF	128.27	128.27	128.27	128.27	300.0
2011-10-28 05:53:00	SPY	ETF	128.32	128.32	128.32	128.32	500.0
2011-10-28 05:54:00	SPY	ETF	128.35	128.36	128.35	128.36	200.0
2011-10-28 05:55:00	SPY	ETF	128.41	128.41	128.41	128.41	200.0
2011-10-28 05:58:00	SPY	ETF	128.46	128.46	128.46	128.46	200.0
2011-10-28 05:59:00	SPY	ETF	128.46	128.46	128.46	128.46	100.0
2011-10-28 06:01:00	SPY	ETF	128.41	128.41	128.34	128.34	13119.0
2011-10-28 06:09:00	SPY	ETF	128.29	128.29	128.29	128.29	100.0
2011-10-28 06:11:00	SPY	ETF	128.21	128.21	128.21	128.21	10000.0
2011-10-28 06:12:00	SPY	ETF	128.26	128.26	128.26	128.26	100.0
2011-10-28 06:16:00	SPY	ETF	128.21	128.24	128.2	128.24	81153.0
2011-10-28 06:17:00	SPY	ETF	128.2	128.2	128.2	128.2	1000.0
2011-10-28 06:19:00	SPY	ETF	128.08	128.09	128.08	128.09	542.0
2011-10-28 06:20:00	SPY	ETF	128.12	128.21	128.12	128.16	8551.0
2011-10-28 06:21:00	SPY	ETF	128.16	128.16	128.12	128.12	10200.0
2011-10-28 06:23:00	SPY	ETF	128.09	128.09	128.04	128.04	1200.0
2011-10-28 06:24:00	SPY	ETF	128.04	128.04	128.01	128.01	9360.0
2011-10-28 06:26:00	SPY	ETF	128.09	128.09	128.09	128.09	100.0
2011-10-28 06:29:00	SPY	ETF	128.04	128.04	128.0	128.0	4090.0
2011-10-28 06:30:00	SPY	ETF	128.0	128.0	128.0	128.0	100.0
2011-10-28 06:31:00	SPY	ETF	128.01	128.01	128.01	128.01	1500.0
2011-10-28 06:32:00	SPY	ETF	127.95	127.95	127.91	127.93	8400.0
2011-10-28 06:33:00	SPY	ETF	128.01	128.01	128.01	128.01	1000.0
2011-10-28 06:34:00	SPY	ETF	128.01	128.04	128.01	128.04	8500.0
2011-10-28 06:35:00	SPY	ETF	128.07	128.07	128.07	128.07	5000.0
2011-10-28 06:36:00	SPY	ETF	128.01	128.01	128.01	128.01	600.0
2011-10-28 06:38:00	SPY	ETF	128.05	128.05	128.04	128.04	200.0
2011-10-28 06:39:00	SPY	ETF	128.01	128.01	128.01	128.01	5000.0
2011-10-28 06:40:00	SPY	ETF	128.09	128.09	128.08	128.09	3700.0

> showing 50 of 110,322 rows — these rows as CSV

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