PREVIEW / etf_1min / 2011-08-18

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-08-18.parquet
  size:    2.5 MB
  rows:    126,668

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-08-18 04:00:00	SPY	ETF	118.35	118.35	118.07	118.07	2700.0
2011-08-18 04:01:00	SPY	ETF	118.15	118.15	118.12	118.12	300.0
2011-08-18 04:02:00	SPY	ETF	118.07	118.07	118.03	118.03	700.0
2011-08-18 04:03:00	SPY	ETF	118.01	118.1	118.01	118.1	405.0
2011-08-18 04:04:00	SPY	ETF	118.1	118.1	118.1	118.1	289.0
2011-08-18 04:05:00	SPY	ETF	118.1	118.1	118.1	118.1	3706.0
2011-08-18 04:06:00	SPY	ETF	118.13	118.13	118.1	118.1	1494.0
2011-08-18 04:09:00	SPY	ETF	118.2	118.2	118.2	118.2	7500.0
2011-08-18 04:17:00	SPY	ETF	118.26	118.26	118.26	118.26	200.0
2011-08-18 04:24:00	SPY	ETF	118.32	118.32	118.32	118.32	500.0
2011-08-18 04:40:00	SPY	ETF	118.29	118.29	118.28	118.28	300.0
2011-08-18 04:42:00	SPY	ETF	118.16	118.16	118.16	118.16	100.0
2011-08-18 04:44:00	SPY	ETF	118.08	118.08	118.08	118.08	100.0
2011-08-18 04:47:00	SPY	ETF	118.09	118.09	118.09	118.09	100.0
2011-08-18 04:48:00	SPY	ETF	118.08	118.08	118.08	118.08	100.0
2011-08-18 04:50:00	SPY	ETF	118.04	118.04	117.9	117.9	10600.0
2011-08-18 04:51:00	SPY	ETF	117.88	117.88	117.88	117.88	500.0
2011-08-18 04:52:00	SPY	ETF	117.93	117.93	117.82	117.82	10600.0
2011-08-18 04:54:00	SPY	ETF	117.78	117.78	117.78	117.78	100.0
2011-08-18 04:55:00	SPY	ETF	117.77	117.77	117.7	117.7	300.0
2011-08-18 04:57:00	SPY	ETF	117.83	117.83	117.83	117.83	100.0
2011-08-18 04:58:00	SPY	ETF	117.81	117.81	117.81	117.81	600.0
2011-08-18 05:00:00	SPY	ETF	117.73	117.73	117.68	117.68	1000.0
2011-08-18 05:01:00	SPY	ETF	117.66	117.66	117.66	117.66	100.0
2011-08-18 05:09:00	SPY	ETF	117.68	117.68	117.26	117.38	6407.0
2011-08-18 05:10:00	SPY	ETF	117.36	117.48	117.36	117.48	800.0
2011-08-18 05:13:00	SPY	ETF	117.53	117.53	117.46	117.46	600.0
2011-08-18 05:14:00	SPY	ETF	117.33	117.33	117.32	117.32	300.0
2011-08-18 05:15:00	SPY	ETF	117.28	117.28	117.28	117.28	270.0
2011-08-18 05:16:00	SPY	ETF	117.28	117.28	117.21	117.21	1042.0
2011-08-18 05:17:00	SPY	ETF	117.35	117.35	117.35	117.35	100.0
2011-08-18 05:18:00	SPY	ETF	117.38	117.38	117.35	117.35	7900.0
2011-08-18 05:19:00	SPY	ETF	117.31	117.31	117.28	117.28	5100.0
2011-08-18 05:20:00	SPY	ETF	117.31	117.31	117.31	117.31	100.0
2011-08-18 05:21:00	SPY	ETF	117.19	117.19	117.16	117.16	400.0
2011-08-18 05:22:00	SPY	ETF	117.11	117.11	117.03	117.03	3600.0
2011-08-18 05:23:00	SPY	ETF	117.1	117.1	117.0	117.0	16600.0
2011-08-18 05:25:00	SPY	ETF	117.1	117.1	117.05	117.05	15100.0
2011-08-18 05:26:00	SPY	ETF	117.1	117.11	117.01	117.11	2700.0
2011-08-18 05:27:00	SPY	ETF	117.11	117.16	117.11	117.16	2100.0
2011-08-18 05:28:00	SPY	ETF	117.2	117.2	117.19	117.19	700.0
2011-08-18 05:29:00	SPY	ETF	117.19	117.19	117.12	117.18	22400.0
2011-08-18 05:32:00	SPY	ETF	117.14	117.14	117.04	117.07	50300.0
2011-08-18 05:33:00	SPY	ETF	117.1	117.1	117.1	117.1	30000.0
2011-08-18 05:34:00	SPY	ETF	117.18	117.18	117.18	117.18	100.0
2011-08-18 05:35:00	SPY	ETF	117.21	117.21	117.21	117.21	100.0
2011-08-18 05:36:00	SPY	ETF	117.29	117.43	117.29	117.43	400.0
2011-08-18 05:37:00	SPY	ETF	117.45	117.45	117.43	117.44	1300.0
2011-08-18 05:38:00	SPY	ETF	117.41	117.41	117.39	117.39	800.0
2011-08-18 05:39:00	SPY	ETF	117.36	117.36	117.36	117.36	100.0

> showing 50 of 126,668 rows — these rows as CSV

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