PREVIEW / stock_1min / 2014-01-23

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-01-23.parquet
  size:    15.1 MB
  rows:    1,074,864
  symbols: 2,873

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-01-23 04:01:00	AAPL	Stock	19.75	19.75	19.75	19.75	2800.0
2014-01-23 04:03:00	AAPL	Stock	19.7171	19.7171	19.7171	19.7171	2800.0
2014-01-23 04:52:00	AAPL	Stock	19.7382	19.7382	19.7382	19.7382	3332.0
2014-01-23 05:45:00	AAPL	Stock	19.7439	19.7439	19.7439	19.7439	2800.0
2014-01-23 05:51:00	AAPL	Stock	19.7439	19.7439	19.7439	19.7439	2800.0
2014-01-23 06:30:00	AAPL	Stock	19.7411	19.7411	19.7411	19.7411	3276.0
2014-01-23 06:48:00	AAPL	Stock	19.7357	19.7357	19.7357	19.7357	2800.0
2014-01-23 06:50:00	AAPL	Stock	19.7271	19.7271	19.7271	19.7271	5600.0
2014-01-23 06:51:00	AAPL	Stock	19.7164	19.7164	19.7071	19.7104	9800.0
2014-01-23 06:52:00	AAPL	Stock	19.7143	19.7143	19.7143	19.7143	2800.0
2014-01-23 06:57:00	AAPL	Stock	19.7143	19.7143	19.7143	19.7143	6664.0
2014-01-23 07:00:00	AAPL	Stock	19.6964	19.6964	19.6964	19.6964	7000.0
2014-01-23 07:01:00	AAPL	Stock	19.6982	19.6982	19.6964	19.6964	12600.0
2014-01-23 07:03:00	AAPL	Stock	19.7071	19.7071	19.7071	19.7071	11200.0
2014-01-23 07:06:00	AAPL	Stock	19.7018	19.7018	19.7018	19.7018	2800.0
2014-01-23 07:07:00	AAPL	Stock	19.7018	19.7018	19.6964	19.6964	16800.0
2014-01-23 07:08:00	AAPL	Stock	19.6875	19.6875	19.6875	19.6875	5600.0
2014-01-23 07:09:00	AAPL	Stock	19.6718	19.6779	19.6718	19.6779	33208.0
2014-01-23 07:11:00	AAPL	Stock	19.675	19.675	19.6539	19.6539	28000.0
2014-01-23 07:13:00	AAPL	Stock	19.6589	19.6607	19.6504	19.6607	45136.0
2014-01-23 07:14:00	AAPL	Stock	19.6493	19.6493	19.6493	19.6493	2800.0
2014-01-23 07:16:00	AAPL	Stock	19.6589	19.6589	19.6589	19.6589	14000.0
2014-01-23 07:17:00	AAPL	Stock	19.6589	19.6643	19.6589	19.6643	14000.0
2014-01-23 07:20:00	AAPL	Stock	19.6786	19.6786	19.6786	19.6786	2800.0
2014-01-23 07:22:00	AAPL	Stock	19.6807	19.6807	19.6807	19.6807	2800.0
2014-01-23 07:25:00	AAPL	Stock	19.6829	19.6871	19.6821	19.6871	8400.0
2014-01-23 07:26:00	AAPL	Stock	19.68	19.68	19.6739	19.6775	14700.0
2014-01-23 07:27:00	AAPL	Stock	19.6736	19.6736	19.6611	19.6679	42140.0
2014-01-23 07:30:00	AAPL	Stock	19.6679	19.6679	19.6679	19.6679	2800.0
2014-01-23 07:31:00	AAPL	Stock	19.6786	19.6786	19.6786	19.6786	5600.0
2014-01-23 07:33:00	AAPL	Stock	19.675	19.675	19.675	19.675	2800.0
2014-01-23 07:34:00	AAPL	Stock	19.675	19.675	19.6743	19.6743	5600.0
2014-01-23 07:36:00	AAPL	Stock	19.675	19.6768	19.675	19.6768	8400.0
2014-01-23 07:37:00	AAPL	Stock	19.6768	19.6821	19.6768	19.6821	33600.0
2014-01-23 07:42:00	AAPL	Stock	19.6786	19.6786	19.6786	19.6786	2800.0
2014-01-23 07:44:00	AAPL	Stock	19.6718	19.6718	19.6718	19.6718	2800.0
2014-01-23 07:45:00	AAPL	Stock	19.6786	19.6786	19.6786	19.6786	13440.0
2014-01-23 07:48:00	AAPL	Stock	19.6775	19.6786	19.6775	19.6786	16800.0
2014-01-23 07:49:00	AAPL	Stock	19.6786	19.6786	19.6786	19.6786	8400.0
2014-01-23 07:50:00	AAPL	Stock	19.6804	19.6804	19.6804	19.6804	5600.0
2014-01-23 07:52:00	AAPL	Stock	19.6811	19.6811	19.6811	19.6811	8400.0
2014-01-23 07:57:00	AAPL	Stock	19.6871	19.6875	19.6871	19.6875	21952.0
2014-01-23 07:58:00	AAPL	Stock	19.7021	19.7021	19.7021	19.7021	2800.0
2014-01-23 08:00:00	AAPL	Stock	19.6607	19.6875	19.6607	19.6846	22400.0
2014-01-23 08:01:00	AAPL	Stock	19.685	19.685	19.685	19.685	2800.0
2014-01-23 08:02:00	AAPL	Stock	19.6864	19.6893	19.6821	19.6821	39200.0
2014-01-23 08:03:00	AAPL	Stock	19.6954	19.6954	19.6946	19.6946	5600.0
2014-01-23 08:04:00	AAPL	Stock	19.6957	19.6957	19.6957	19.6957	3276.0
2014-01-23 08:07:00	AAPL	Stock	19.7082	19.7082	19.7082	19.7082	2800.0
2014-01-23 08:10:00	AAPL	Stock	19.6964	19.6964	19.6964	19.6964	8400.0

> showing 50 of 1,074,864 rows — these rows as CSV

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