PREVIEW / stock_1min / 2014-08-19

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-08-19.parquet
  size:    13.7 MB
  rows:    1,004,275
  symbols: 2,910

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-08-19 04:00:00	AAPL	Stock	24.85	24.915	24.85	24.915	11560.0
2014-08-19 04:01:00	AAPL	Stock	24.87	24.87	24.87	24.87	400.0
2014-08-19 04:02:00	AAPL	Stock	24.87	24.87	24.87	24.87	1520.0
2014-08-19 04:03:00	AAPL	Stock	24.87	24.87	24.855	24.855	2736.0
2014-08-19 04:16:00	AAPL	Stock	24.9	24.9	24.9	24.9	400.0
2014-08-19 04:21:00	AAPL	Stock	24.9	24.9	24.8675	24.8675	21128.0
2014-08-19 04:26:00	AAPL	Stock	24.9125	24.9125	24.9	24.9	2000.0
2014-08-19 04:30:00	AAPL	Stock	24.9	24.9	24.9	24.9	800.0
2014-08-19 04:31:00	AAPL	Stock	24.915	24.915	24.915	24.915	400.0
2014-08-19 04:32:00	AAPL	Stock	24.915	24.915	24.915	24.915	400.0
2014-08-19 04:33:00	AAPL	Stock	24.905	24.92	24.905	24.92	4440.0
2014-08-19 04:55:00	AAPL	Stock	24.9175	24.9175	24.9	24.9	1200.0
2014-08-19 04:57:00	AAPL	Stock	24.8975	24.9	24.8975	24.9	1200.0
2014-08-19 04:58:00	AAPL	Stock	24.9	24.9	24.9	24.9	400.0
2014-08-19 05:08:00	AAPL	Stock	24.9	24.9	24.9	24.9	2664.0
2014-08-19 05:09:00	AAPL	Stock	24.9	24.9	24.9	24.9	400.0
2014-08-19 05:21:00	AAPL	Stock	24.9	24.9	24.9	24.9	400.0
2014-08-19 05:31:00	AAPL	Stock	24.905	24.905	24.9	24.9	1200.0
2014-08-19 05:32:00	AAPL	Stock	24.9	24.9	24.9	24.9	400.0
2014-08-19 05:44:00	AAPL	Stock	24.885	24.885	24.885	24.885	1008.0
2014-08-19 05:45:00	AAPL	Stock	24.885	24.885	24.885	24.885	1480.0
2014-08-19 05:46:00	AAPL	Stock	24.9	24.9	24.9	24.9	400.0
2014-08-19 05:57:00	AAPL	Stock	24.8975	24.9	24.8975	24.9	800.0
2014-08-19 06:01:00	AAPL	Stock	24.9	24.9	24.9	24.9	2208.0
2014-08-19 06:02:00	AAPL	Stock	24.9	24.9	24.9	24.9	400.0
2014-08-19 06:16:00	AAPL	Stock	24.89	24.89	24.89	24.89	988.0
2014-08-19 06:18:00	AAPL	Stock	24.89	24.89	24.89	24.89	400.0
2014-08-19 06:20:00	AAPL	Stock	24.89	24.89	24.89	24.89	400.0
2014-08-19 06:23:00	AAPL	Stock	24.8875	24.8875	24.8875	24.8875	800.0
2014-08-19 06:24:00	AAPL	Stock	24.875	24.875	24.875	24.875	804.0
2014-08-19 06:25:00	AAPL	Stock	24.875	24.875	24.875	24.875	800.0
2014-08-19 06:27:00	AAPL	Stock	24.8875	24.8875	24.8875	24.8875	400.0
2014-08-19 06:29:00	AAPL	Stock	24.875	24.875	24.875	24.875	20000.0
2014-08-19 06:33:00	AAPL	Stock	24.8875	24.8875	24.8875	24.8875	468.0
2014-08-19 06:34:00	AAPL	Stock	24.875	24.875	24.875	24.875	800.0
2014-08-19 06:38:00	AAPL	Stock	24.8875	24.8875	24.8875	24.8875	2800.0
2014-08-19 06:41:00	AAPL	Stock	24.8675	24.8675	24.8675	24.8675	400.0
2014-08-19 06:42:00	AAPL	Stock	24.8675	24.8675	24.8675	24.8675	800.0
2014-08-19 06:43:00	AAPL	Stock	24.8675	24.8675	24.8675	24.8675	12000.0
2014-08-19 06:44:00	AAPL	Stock	24.8675	24.8675	24.8675	24.8675	2000.0
2014-08-19 06:46:00	AAPL	Stock	24.8675	24.8675	24.8675	24.8675	9560.0
2014-08-19 06:47:00	AAPL	Stock	24.865	24.865	24.865	24.865	404.0
2014-08-19 06:48:00	AAPL	Stock	24.8675	24.875	24.8675	24.875	40000.0
2014-08-19 06:50:00	AAPL	Stock	24.8625	24.8625	24.85	24.85	28000.0
2014-08-19 06:55:00	AAPL	Stock	24.8625	24.8625	24.8625	24.8625	800.0
2014-08-19 06:56:00	AAPL	Stock	24.87	24.875	24.87	24.875	24000.0
2014-08-19 06:57:00	AAPL	Stock	24.8625	24.8625	24.8625	24.8625	2400.0
2014-08-19 07:02:00	AAPL	Stock	24.85	24.875	24.85	24.875	18068.0
2014-08-19 07:04:00	AAPL	Stock	24.865	24.865	24.865	24.865	400.0
2014-08-19 07:05:00	AAPL	Stock	24.8575	24.8725	24.8575	24.8725	3200.0

> showing 50 of 1,004,275 rows — these rows as CSV

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