PREVIEW / etf_1min / 2014-10-01

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-10-01.parquet
  size:    2.8 MB
  rows:    143,241

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
2014-10-01 04:00:00	SPY	ETF	196.75	196.95	196.75	196.95	360.0
2014-10-01 04:01:00	SPY	ETF	196.93	196.93	196.93	196.93	600.0
2014-10-01 04:16:00	SPY	ETF	196.88	196.88	196.88	196.88	800.0
2014-10-01 04:19:00	SPY	ETF	196.92	196.92	196.92	196.92	100.0
2014-10-01 04:23:00	SPY	ETF	196.94	196.94	196.94	196.94	101.0
2014-10-01 04:25:00	SPY	ETF	196.91	196.94	196.91	196.94	15000.0
2014-10-01 04:26:00	SPY	ETF	196.96	196.98	196.96	196.98	498.0
2014-10-01 04:27:00	SPY	ETF	196.98	196.98	196.98	196.98	300.0
2014-10-01 04:29:00	SPY	ETF	196.98	196.98	196.98	196.98	8700.0
2014-10-01 04:42:00	SPY	ETF	196.97	196.97	196.97	196.97	111.0
2014-10-01 04:43:00	SPY	ETF	196.96	196.96	196.96	196.96	700.0
2014-10-01 04:46:00	SPY	ETF	196.99	197.09	196.99	197.09	5000.0
2014-10-01 04:47:00	SPY	ETF	197.01	197.01	197.01	197.01	6000.0
2014-10-01 04:48:00	SPY	ETF	196.99	196.99	196.99	196.99	6000.0
2014-10-01 04:50:00	SPY	ETF	197.01	197.01	197.01	197.01	6000.0
2014-10-01 04:52:00	SPY	ETF	196.97	196.97	196.97	196.97	100.0
2014-10-01 04:56:00	SPY	ETF	197.01	197.01	197.01	197.01	161.0
2014-10-01 04:57:00	SPY	ETF	197.02	197.02	197.02	197.02	160.0
2014-10-01 04:58:00	SPY	ETF	197.01	197.02	197.01	197.02	15053.0
2014-10-01 05:01:00	SPY	ETF	197.06	197.06	197.06	197.06	6000.0
2014-10-01 05:02:00	SPY	ETF	197.03	197.03	197.03	197.03	200.0
2014-10-01 05:06:00	SPY	ETF	197.01	197.01	197.01	197.01	100.0
2014-10-01 05:07:00	SPY	ETF	197.0	197.0	197.0	197.0	139.0
2014-10-01 05:08:00	SPY	ETF	197.09	197.09	197.09	197.09	500.0
2014-10-01 05:10:00	SPY	ETF	196.99	196.99	196.99	196.99	800.0
2014-10-01 05:15:00	SPY	ETF	196.95	196.95	196.95	196.95	100.0
2014-10-01 05:20:00	SPY	ETF	196.99	196.99	196.99	196.99	1700.0
2014-10-01 05:21:00	SPY	ETF	196.97	196.97	196.97	196.97	2349.0
2014-10-01 05:22:00	SPY	ETF	196.98	196.98	196.98	196.98	100.0
2014-10-01 05:24:00	SPY	ETF	196.96	196.96	196.96	196.96	100.0
2014-10-01 05:26:00	SPY	ETF	196.94	196.95	196.94	196.95	3000.0
2014-10-01 05:27:00	SPY	ETF	196.95	196.97	196.95	196.97	1500.0
2014-10-01 05:30:00	SPY	ETF	196.97	196.97	196.94	196.94	9150.0
2014-10-01 05:34:00	SPY	ETF	196.94	196.94	196.94	196.94	500.0
2014-10-01 05:35:00	SPY	ETF	196.95	196.95	196.92	196.92	11500.0
2014-10-01 05:37:00	SPY	ETF	196.9	196.9	196.88	196.9	6150.0
2014-10-01 05:40:00	SPY	ETF	196.9	196.9	196.9	196.9	3030.0
2014-10-01 05:41:00	SPY	ETF	196.9	196.92	196.9	196.92	320.0
2014-10-01 05:43:00	SPY	ETF	196.85	196.85	196.85	196.85	135.0
2014-10-01 05:50:00	SPY	ETF	196.83	196.83	196.83	196.83	105.0
2014-10-01 05:52:00	SPY	ETF	196.77	196.77	196.77	196.77	100.0
2014-10-01 05:53:00	SPY	ETF	196.82	196.82	196.82	196.82	130.0
2014-10-01 06:02:00	SPY	ETF	196.85	196.85	196.85	196.85	130.0
2014-10-01 06:09:00	SPY	ETF	196.86	196.86	196.86	196.86	5100.0
2014-10-01 06:13:00	SPY	ETF	196.83	196.83	196.83	196.83	10000.0
2014-10-01 06:15:00	SPY	ETF	196.85	196.86	196.85	196.86	3332.0
2014-10-01 06:22:00	SPY	ETF	196.87	196.88	196.87	196.88	4000.0
2014-10-01 06:36:00	SPY	ETF	196.9	196.9	196.9	196.9	9350.0
2014-10-01 06:37:00	SPY	ETF	196.92	196.92	196.92	196.92	20000.0
2014-10-01 06:39:00	SPY	ETF	196.92	196.92	196.92	196.92	12000.0

> showing 50 of 143,241 rows — these rows as CSV

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