PREVIEW / etf_1min / 2011-03-18

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-03-18.parquet
  size:    2.0 MB
  rows:    108,789

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-03-18 04:00:00	SPY	ETF	128.35	128.35	128.35	128.35	500.0
2011-03-18 04:03:00	SPY	ETF	128.25	128.35	128.25	128.35	6100.0
2011-03-18 04:05:00	SPY	ETF	128.35	128.35	128.23	128.23	800.0
2011-03-18 04:06:00	SPY	ETF	128.23	128.23	128.23	128.23	300.0
2011-03-18 04:07:00	SPY	ETF	128.21	128.21	128.18	128.18	400.0
2011-03-18 04:10:00	SPY	ETF	128.24	128.24	128.24	128.24	1500.0
2011-03-18 04:15:00	SPY	ETF	128.1	128.1	128.1	128.1	500.0
2011-03-18 04:16:00	SPY	ETF	128.16	128.16	128.16	128.16	100.0
2011-03-18 04:30:00	SPY	ETF	128.23	128.26	128.23	128.26	400.0
2011-03-18 04:32:00	SPY	ETF	128.2	128.2	128.2	128.2	100.0
2011-03-18 04:47:00	SPY	ETF	128.21	128.21	128.21	128.21	100.0
2011-03-18 05:09:00	SPY	ETF	128.06	128.06	128.06	128.06	500.0
2011-03-18 05:16:00	SPY	ETF	127.9	127.9	127.9	127.9	200.0
2011-03-18 05:18:00	SPY	ETF	127.88	127.88	127.88	127.88	2000.0
2011-03-18 05:20:00	SPY	ETF	128.02	128.02	128.02	128.02	300.0
2011-03-18 05:21:00	SPY	ETF	128.06	128.06	128.06	128.06	2000.0
2011-03-18 05:22:00	SPY	ETF	128.07	128.07	128.07	128.07	100.0
2011-03-18 05:23:00	SPY	ETF	128.09	128.12	128.09	128.12	9900.0
2011-03-18 05:24:00	SPY	ETF	128.05	128.05	128.05	128.05	2000.0
2011-03-18 05:25:00	SPY	ETF	128.09	128.09	128.09	128.09	1000.0
2011-03-18 05:26:00	SPY	ETF	128.05	128.05	128.05	128.05	1000.0
2011-03-18 05:30:00	SPY	ETF	128.01	128.01	128.01	128.01	1000.0
2011-03-18 05:32:00	SPY	ETF	128.04	128.04	128.04	128.04	1000.0
2011-03-18 05:33:00	SPY	ETF	128.01	128.01	128.01	128.01	200.0
2011-03-18 05:36:00	SPY	ETF	127.99	127.99	127.99	127.99	126.0
2011-03-18 06:08:00	SPY	ETF	128.2	128.2	128.2	128.2	200.0
2011-03-18 06:16:00	SPY	ETF	127.96	127.96	127.96	127.96	1000.0
2011-03-18 06:18:00	SPY	ETF	127.94	127.94	127.94	127.94	100.0
2011-03-18 06:20:00	SPY	ETF	127.89	127.89	127.89	127.89	1000.0
2011-03-18 06:22:00	SPY	ETF	127.85	127.85	127.79	127.79	9000.0
2011-03-18 06:23:00	SPY	ETF	127.79	127.83	127.79	127.83	400.0
2011-03-18 06:24:00	SPY	ETF	127.86	127.86	127.86	127.86	5000.0
2011-03-18 06:27:00	SPY	ETF	127.9	127.9	127.9	127.9	100.0
2011-03-18 06:31:00	SPY	ETF	127.95	127.95	127.95	127.95	650.0
2011-03-18 06:36:00	SPY	ETF	127.95	127.95	127.95	127.95	650.0
2011-03-18 06:38:00	SPY	ETF	128.0	128.0	128.0	128.0	100.0
2011-03-18 06:39:00	SPY	ETF	128.07	128.07	128.07	128.07	12500.0
2011-03-18 06:41:00	SPY	ETF	128.09	128.09	128.09	128.09	12500.0
2011-03-18 06:43:00	SPY	ETF	128.02	128.05	128.02	128.05	28000.0
2011-03-18 06:49:00	SPY	ETF	128.1	128.1	128.1	128.1	200.0
2011-03-18 06:50:00	SPY	ETF	128.07	128.07	128.06	128.06	5300.0
2011-03-18 06:51:00	SPY	ETF	128.07	128.07	128.07	128.07	1300.0
2011-03-18 06:52:00	SPY	ETF	128.06	128.07	128.05	128.05	12000.0
2011-03-18 06:53:00	SPY	ETF	128.05	128.05	128.04	128.04	22300.0
2011-03-18 06:54:00	SPY	ETF	128.0	128.0	128.0	128.0	1000.0
2011-03-18 06:55:00	SPY	ETF	128.07	128.07	128.07	128.07	18800.0
2011-03-18 06:57:00	SPY	ETF	128.08	128.19	128.08	128.19	4850.0
2011-03-18 06:58:00	SPY	ETF	128.17	128.17	128.17	128.17	5000.0
2011-03-18 06:59:00	SPY	ETF	128.19	128.19	128.15	128.15	5400.0
2011-03-18 07:00:00	SPY	ETF	128.15	128.15	128.12	128.12	3950.0

> showing 50 of 108,789 rows — these rows as CSV

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