PREVIEW / etf_1min / 2011-09-07

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-09-07.parquet
  size:    2.1 MB
  rows:    106,267

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-09-07 04:00:00	SPY	ETF	117.79	117.85	117.79	117.85	300.0
2011-09-07 04:02:00	SPY	ETF	117.9	117.93	117.9	117.93	500.0
2011-09-07 04:03:00	SPY	ETF	118.0	118.02	118.0	118.02	514.0
2011-09-07 04:07:00	SPY	ETF	118.24	118.24	118.24	118.24	300.0
2011-09-07 04:09:00	SPY	ETF	118.18	118.18	118.18	118.18	243.0
2011-09-07 04:10:00	SPY	ETF	118.33	118.43	118.33	118.43	400.0
2011-09-07 04:15:00	SPY	ETF	118.1	118.1	118.1	118.1	400.0
2011-09-07 04:16:00	SPY	ETF	118.1	118.1	118.1	118.1	600.0
2011-09-07 04:17:00	SPY	ETF	118.18	118.18	118.18	118.18	600.0
2011-09-07 04:18:00	SPY	ETF	118.08	118.08	118.08	118.08	100.0
2011-09-07 04:25:00	SPY	ETF	118.03	118.03	118.03	118.03	5000.0
2011-09-07 04:30:00	SPY	ETF	118.16	118.16	118.16	118.16	19950.0
2011-09-07 04:34:00	SPY	ETF	118.25	118.25	118.25	118.25	176.0
2011-09-07 04:36:00	SPY	ETF	118.32	118.32	118.32	118.32	100.0
2011-09-07 04:38:00	SPY	ETF	118.26	118.26	118.26	118.26	479.0
2011-09-07 04:45:00	SPY	ETF	118.26	118.26	118.26	118.26	500.0
2011-09-07 04:53:00	SPY	ETF	118.08	118.08	118.08	118.08	100.0
2011-09-07 04:58:00	SPY	ETF	118.13	118.13	118.13	118.13	235.0
2011-09-07 05:03:00	SPY	ETF	118.29	118.29	118.29	118.29	4000.0
2011-09-07 05:06:00	SPY	ETF	118.25	118.25	118.25	118.25	500.0
2011-09-07 05:08:00	SPY	ETF	118.25	118.25	118.25	118.25	5000.0
2011-09-07 05:10:00	SPY	ETF	118.25	118.3	118.25	118.3	2700.0
2011-09-07 05:13:00	SPY	ETF	118.26	118.26	118.26	118.26	124.0
2011-09-07 05:18:00	SPY	ETF	118.3	118.3	118.3	118.3	4976.0
2011-09-07 05:25:00	SPY	ETF	118.02	118.02	117.95	117.95	5500.0
2011-09-07 05:28:00	SPY	ETF	117.91	117.91	117.91	117.91	4200.0
2011-09-07 05:29:00	SPY	ETF	117.96	117.96	117.96	117.96	1000.0
2011-09-07 05:39:00	SPY	ETF	117.94	117.94	117.94	117.94	300.0
2011-09-07 06:00:00	SPY	ETF	118.0	118.0	117.99	118.0	700.0
2011-09-07 06:02:00	SPY	ETF	118.0	118.0	118.0	118.0	100.0
2011-09-07 06:12:00	SPY	ETF	117.92	117.92	117.91	117.91	300.0
2011-09-07 06:25:00	SPY	ETF	117.89	117.89	117.89	117.89	150.0
2011-09-07 06:27:00	SPY	ETF	117.99	117.99	117.99	117.99	300.0
2011-09-07 06:32:00	SPY	ETF	118.15	118.18	118.15	118.18	1100.0
2011-09-07 06:34:00	SPY	ETF	118.28	118.28	118.28	118.28	100.0
2011-09-07 06:40:00	SPY	ETF	118.16	118.16	118.16	118.16	800.0
2011-09-07 06:42:00	SPY	ETF	118.16	118.16	118.16	118.16	100.0
2011-09-07 06:43:00	SPY	ETF	118.28	118.3	118.28	118.3	3100.0
2011-09-07 06:46:00	SPY	ETF	118.45	118.45	118.41	118.41	2700.0
2011-09-07 06:47:00	SPY	ETF	118.5	118.51	118.5	118.51	20900.0
2011-09-07 06:48:00	SPY	ETF	118.51	118.51	118.51	118.51	9150.0
2011-09-07 06:51:00	SPY	ETF	118.4	118.5	118.4	118.5	8180.0
2011-09-07 06:52:00	SPY	ETF	118.5	118.6	118.45	118.45	9710.0
2011-09-07 06:55:00	SPY	ETF	118.41	118.41	118.4	118.4	10000.0
2011-09-07 06:57:00	SPY	ETF	118.4	118.4	118.4	118.4	200.0
2011-09-07 06:59:00	SPY	ETF	118.4	118.44	118.4	118.44	54800.0
2011-09-07 07:00:00	SPY	ETF	118.45	118.48	118.45	118.47	300.0
2011-09-07 07:01:00	SPY	ETF	118.45	118.52	118.45	118.51	4950.0
2011-09-07 07:02:00	SPY	ETF	118.5	118.52	118.47	118.5	10180.0
2011-09-07 07:03:00	SPY	ETF	118.55	118.55	118.51	118.53	4600.0

> showing 50 of 106,267 rows — these rows as CSV

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