PREVIEW / etf_1min / 2012-08-27

all etf 1-min files

  file:    by_date/etf_1min/2012/2012-08-27.parquet
  size:    1.7 MB
  rows:    90,981

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
2012-08-27 04:11:00	SPY	ETF	141.75	141.75	141.75	141.75	200.0
2012-08-27 04:17:00	SPY	ETF	141.84	141.84	141.84	141.84	200.0
2012-08-27 05:14:00	SPY	ETF	141.7	141.7	141.7	141.7	300.0
2012-08-27 05:39:00	SPY	ETF	141.72	141.72	141.72	141.72	100.0
2012-08-27 05:48:00	SPY	ETF	141.7	141.7	141.7	141.7	100.0
2012-08-27 06:20:00	SPY	ETF	141.95	141.95	141.95	141.95	1000.0
2012-08-27 06:31:00	SPY	ETF	141.96	141.96	141.96	141.96	500.0
2012-08-27 06:43:00	SPY	ETF	141.97	141.97	141.97	141.97	100.0
2012-08-27 06:44:00	SPY	ETF	141.98	141.98	141.98	141.98	7000.0
2012-08-27 06:45:00	SPY	ETF	141.98	141.98	141.98	141.98	17000.0
2012-08-27 06:47:00	SPY	ETF	142.04	142.06	142.04	142.06	2500.0
2012-08-27 06:51:00	SPY	ETF	142.01	142.02	142.01	142.02	300.0
2012-08-27 06:52:00	SPY	ETF	142.0	142.0	141.99	141.99	865.0
2012-08-27 06:53:00	SPY	ETF	142.0	142.0	141.99	141.99	600.0
2012-08-27 06:57:00	SPY	ETF	141.99	141.99	141.97	141.97	5300.0
2012-08-27 07:01:00	SPY	ETF	141.96	141.96	141.96	141.96	200.0
2012-08-27 07:02:00	SPY	ETF	141.97	141.99	141.96	141.96	3300.0
2012-08-27 07:04:00	SPY	ETF	141.99	141.99	141.98	141.98	700.0
2012-08-27 07:07:00	SPY	ETF	141.97	141.97	141.97	141.97	300.0
2012-08-27 07:08:00	SPY	ETF	141.95	141.95	141.95	141.95	25700.0
2012-08-27 07:10:00	SPY	ETF	141.95	141.95	141.95	141.95	100.0
2012-08-27 07:14:00	SPY	ETF	141.93	141.93	141.93	141.93	400.0
2012-08-27 07:15:00	SPY	ETF	141.92	141.92	141.92	141.92	5000.0
2012-08-27 07:17:00	SPY	ETF	141.89	141.89	141.89	141.89	100.0
2012-08-27 07:19:00	SPY	ETF	141.89	141.89	141.89	141.89	100.0
2012-08-27 07:22:00	SPY	ETF	141.9	141.9	141.88	141.9	1900.0
2012-08-27 07:23:00	SPY	ETF	141.9	141.9	141.9	141.9	1000.0
2012-08-27 07:24:00	SPY	ETF	141.93	141.93	141.93	141.93	7500.0
2012-08-27 07:26:00	SPY	ETF	141.91	141.91	141.91	141.91	100.0
2012-08-27 07:27:00	SPY	ETF	141.94	141.95	141.94	141.95	2500.0
2012-08-27 07:28:00	SPY	ETF	141.98	141.98	141.98	141.98	4880.0
2012-08-27 07:29:00	SPY	ETF	141.98	141.98	141.98	141.98	800.0
2012-08-27 07:32:00	SPY	ETF	141.98	141.98	141.98	141.98	3200.0
2012-08-27 07:33:00	SPY	ETF	141.99	141.99	141.98	141.98	5000.0
2012-08-27 07:34:00	SPY	ETF	141.98	141.99	141.93	141.99	18710.0
2012-08-27 07:35:00	SPY	ETF	141.96	141.96	141.96	141.96	1000.0
2012-08-27 07:36:00	SPY	ETF	141.96	141.96	141.96	141.96	5000.0
2012-08-27 07:37:00	SPY	ETF	141.96	141.96	141.96	141.96	1000.0
2012-08-27 07:38:00	SPY	ETF	141.96	141.98	141.96	141.98	1900.0
2012-08-27 07:40:00	SPY	ETF	141.98	141.98	141.98	141.98	200.0
2012-08-27 07:42:00	SPY	ETF	141.93	141.93	141.91	141.91	400.0
2012-08-27 07:43:00	SPY	ETF	141.96	141.96	141.93	141.96	13200.0
2012-08-27 07:44:00	SPY	ETF	141.96	141.96	141.96	141.96	800.0
2012-08-27 07:46:00	SPY	ETF	141.98	141.99	141.98	141.99	1000.0
2012-08-27 07:48:00	SPY	ETF	141.98	141.98	141.98	141.98	200.0
2012-08-27 07:50:00	SPY	ETF	141.99	142.0	141.99	142.0	24610.0
2012-08-27 07:51:00	SPY	ETF	142.03	142.04	142.01	142.01	400.0
2012-08-27 07:52:00	SPY	ETF	142.06	142.07	142.05	142.07	25600.0
2012-08-27 07:53:00	SPY	ETF	142.03	142.03	142.01	142.01	400.0
2012-08-27 07:55:00	SPY	ETF	141.97	141.97	141.97	141.97	500.0

> showing 50 of 90,981 rows — these rows as CSV

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