PREVIEW / etf_1min / 2011-07-05

all etf 1-min files

  file:    by_date/etf_1min/2011/2011-07-05.parquet
  size:    1.8 MB
  rows:    102,719

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-07-05 04:02:00	SPY	ETF	133.85	133.85	133.8	133.8	200.0
2011-07-05 04:18:00	SPY	ETF	133.97	133.97	133.97	133.97	100.0
2011-07-05 04:25:00	SPY	ETF	133.95	133.95	133.95	133.95	1000.0
2011-07-05 04:51:00	SPY	ETF	133.89	133.89	133.89	133.89	100.0
2011-07-05 04:52:00	SPY	ETF	133.87	133.87	133.87	133.87	400.0
2011-07-05 05:03:00	SPY	ETF	133.82	133.82	133.8	133.8	1000.0
2011-07-05 05:09:00	SPY	ETF	133.89	133.89	133.89	133.89	300.0
2011-07-05 05:15:00	SPY	ETF	133.9	133.9	133.9	133.9	300.0
2011-07-05 05:26:00	SPY	ETF	133.9	133.9	133.9	133.9	200.0
2011-07-05 05:35:00	SPY	ETF	133.9	133.9	133.9	133.9	2500.0
2011-07-05 05:40:00	SPY	ETF	133.99	133.99	133.95	133.95	500.0
2011-07-05 05:49:00	SPY	ETF	134.05	134.05	134.05	134.05	200.0
2011-07-05 06:00:00	SPY	ETF	134.1	134.1	134.1	134.1	500.0
2011-07-05 06:01:00	SPY	ETF	134.1	134.1	134.1	134.1	2500.0
2011-07-05 06:20:00	SPY	ETF	134.2	134.2	134.1	134.1	5100.0
2011-07-05 06:33:00	SPY	ETF	134.0	134.0	134.0	134.0	25000.0
2011-07-05 07:00:00	SPY	ETF	134.0	134.0	134.0	134.0	1100.0
2011-07-05 07:01:00	SPY	ETF	134.08	134.09	134.08	134.09	10000.0
2011-07-05 07:02:00	SPY	ETF	134.08	134.08	133.93	133.93	3900.0
2011-07-05 07:03:00	SPY	ETF	134.0	134.05	134.0	134.03	1000.0
2011-07-05 07:04:00	SPY	ETF	134.04	134.04	134.01	134.01	700.0
2011-07-05 07:06:00	SPY	ETF	134.02	134.04	134.02	134.04	480.0
2011-07-05 07:07:00	SPY	ETF	134.02	134.03	134.02	134.03	500.0
2011-07-05 07:09:00	SPY	ETF	133.99	134.0	133.92	133.95	8520.0
2011-07-05 07:10:00	SPY	ETF	133.95	134.0	133.94	133.95	200000.0
2011-07-05 07:11:00	SPY	ETF	133.95	134.0	133.95	133.95	50600.0
2011-07-05 07:12:00	SPY	ETF	133.96	133.96	133.96	133.96	500.0
2011-07-05 07:13:00	SPY	ETF	133.96	133.96	133.95	133.95	300.0
2011-07-05 07:15:00	SPY	ETF	133.96	133.96	133.96	133.96	200.0
2011-07-05 07:17:00	SPY	ETF	133.99	133.99	133.96	133.96	1769.0
2011-07-05 07:19:00	SPY	ETF	133.93	133.93	133.93	133.93	400.0
2011-07-05 07:20:00	SPY	ETF	133.93	133.93	133.9	133.9	400.0
2011-07-05 07:23:00	SPY	ETF	133.97	133.98	133.97	133.98	6500.0
2011-07-05 07:24:00	SPY	ETF	133.94	133.94	133.94	133.94	10100.0
2011-07-05 07:25:00	SPY	ETF	133.94	133.94	133.91	133.94	8000.0
2011-07-05 07:26:00	SPY	ETF	133.94	133.94	133.91	133.94	41458.0
2011-07-05 07:28:00	SPY	ETF	133.94	133.94	133.94	133.94	100.0
2011-07-05 07:30:00	SPY	ETF	133.9	133.95	133.9	133.95	10100.0
2011-07-05 07:32:00	SPY	ETF	133.93	133.93	133.93	133.93	49900.0
2011-07-05 07:33:00	SPY	ETF	133.94	133.94	133.94	133.94	3500.0
2011-07-05 07:34:00	SPY	ETF	133.94	133.98	133.94	133.94	47500.0
2011-07-05 07:35:00	SPY	ETF	133.97	133.97	133.97	133.97	1200.0
2011-07-05 07:36:00	SPY	ETF	133.95	133.95	133.94	133.94	300.0
2011-07-05 07:40:00	SPY	ETF	133.91	133.91	133.91	133.91	2000.0
2011-07-05 07:41:00	SPY	ETF	133.91	133.91	133.91	133.91	5000.0
2011-07-05 07:42:00	SPY	ETF	133.91	133.92	133.91	133.92	400.0
2011-07-05 07:43:00	SPY	ETF	133.94	133.94	133.94	133.94	1600.0
2011-07-05 07:44:00	SPY	ETF	133.91	133.91	133.87	133.87	29335.0
2011-07-05 07:45:00	SPY	ETF	133.9	133.9	133.87	133.87	14500.0
2011-07-05 07:46:00	SPY	ETF	133.9	133.9	133.9	133.9	5000.0

> showing 50 of 102,719 rows — these rows as CSV

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