PREVIEW / stock_1min / 2013-11-18

all stock 1-min files

  file:    by_date/stock_1min/2013/2013-11-18.parquet
  size:    14.2 MB
  rows:    1,027,905
  symbols: 2,881

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
2013-11-18 04:00:00	AAPL	Stock	18.7496	18.7496	18.7496	18.7496	2800.0
2013-11-18 04:02:00	AAPL	Stock	18.7589	18.7589	18.7571	18.7571	7700.0
2013-11-18 04:20:00	AAPL	Stock	18.7632	18.7632	18.7632	18.7632	2800.0
2013-11-18 04:42:00	AAPL	Stock	18.7789	18.7804	18.7789	18.7804	8400.0
2013-11-18 05:02:00	AAPL	Stock	18.7986	18.7986	18.7929	18.7929	8400.0
2013-11-18 05:55:00	AAPL	Stock	18.8011	18.8011	18.8011	18.8011	2800.0
2013-11-18 06:02:00	AAPL	Stock	18.7875	18.8175	18.7857	18.8175	154168.0
2013-11-18 06:03:00	AAPL	Stock	18.7857	18.7857	18.7857	18.7857	30100.0
2013-11-18 06:04:00	AAPL	Stock	18.7679	18.7679	18.7679	18.7679	14000.0
2013-11-18 06:06:00	AAPL	Stock	18.7682	18.7682	18.7682	18.7682	5600.0
2013-11-18 06:08:00	AAPL	Stock	18.7714	18.7714	18.7714	18.7714	2800.0
2013-11-18 06:14:00	AAPL	Stock	18.7643	18.7643	18.7589	18.7589	5600.0
2013-11-18 06:17:00	AAPL	Stock	18.7571	18.7589	18.7571	18.7571	8400.0
2013-11-18 06:18:00	AAPL	Stock	18.75	18.75	18.75	18.75	2800.0
2013-11-18 06:19:00	AAPL	Stock	18.75	18.75	18.75	18.75	2800.0
2013-11-18 06:22:00	AAPL	Stock	18.7518	18.7518	18.7518	18.7518	2800.0
2013-11-18 06:35:00	AAPL	Stock	18.7507	18.7507	18.7507	18.7507	2800.0
2013-11-18 06:36:00	AAPL	Stock	18.7321	18.7321	18.7143	18.7143	18284.0
2013-11-18 07:07:00	AAPL	Stock	18.7679	18.7768	18.7679	18.7679	8400.0
2013-11-18 07:08:00	AAPL	Stock	18.7679	18.7679	18.7679	18.7679	5600.0
2013-11-18 07:10:00	AAPL	Stock	18.7807	18.7807	18.7807	18.7807	7000.0
2013-11-18 07:11:00	AAPL	Stock	18.7929	18.7929	18.7929	18.7929	8400.0
2013-11-18 07:12:00	AAPL	Stock	18.7982	18.8	18.7982	18.8	28000.0
2013-11-18 07:14:00	AAPL	Stock	18.8071	18.8071	18.7979	18.7979	89600.0
2013-11-18 07:18:00	AAPL	Stock	18.7946	18.7946	18.7946	18.7946	12600.0
2013-11-18 07:23:00	AAPL	Stock	18.7907	18.7907	18.7907	18.7907	28000.0
2013-11-18 07:24:00	AAPL	Stock	18.8021	18.8036	18.8021	18.8036	11200.0
2013-11-18 07:25:00	AAPL	Stock	18.81	18.81	18.81	18.81	2800.0
2013-11-18 07:27:00	AAPL	Stock	18.81	18.81	18.81	18.81	2800.0
2013-11-18 07:28:00	AAPL	Stock	18.8121	18.8121	18.8121	18.8121	8428.0
2013-11-18 07:29:00	AAPL	Stock	18.8196	18.8196	18.8196	18.8196	56700.0
2013-11-18 07:30:00	AAPL	Stock	18.8257	18.8268	18.8257	18.8268	7000.0
2013-11-18 07:32:00	AAPL	Stock	18.8357	18.8368	18.8357	18.8368	31500.0
2013-11-18 07:34:00	AAPL	Stock	18.835	18.8357	18.835	18.8357	26600.0
2013-11-18 07:39:00	AAPL	Stock	18.8218	18.8218	18.8218	18.8218	5600.0
2013-11-18 07:54:00	AAPL	Stock	18.8114	18.8114	18.8114	18.8114	2800.0
2013-11-18 07:56:00	AAPL	Stock	18.8114	18.8143	18.8114	18.8143	22120.0
2013-11-18 08:00:00	AAPL	Stock	18.8036	18.8357	18.7614	18.7979	128828.0
2013-11-18 08:01:00	AAPL	Stock	18.7964	18.7964	18.7964	18.7964	2800.0
2013-11-18 08:02:00	AAPL	Stock	18.7143	18.8	18.7143	18.7839	92120.0
2013-11-18 08:03:00	AAPL	Stock	18.7807	18.7807	18.7725	18.7768	8400.0
2013-11-18 08:04:00	AAPL	Stock	18.7754	18.7775	18.7718	18.7725	16800.0
2013-11-18 08:05:00	AAPL	Stock	18.7786	18.7786	18.7675	18.7679	22120.0
2013-11-18 08:06:00	AAPL	Stock	18.7679	18.7682	18.7589	18.7679	86044.0
2013-11-18 08:07:00	AAPL	Stock	18.7679	18.775	18.7679	18.7682	102844.0
2013-11-18 08:08:00	AAPL	Stock	18.7693	18.775	18.7679	18.7736	36400.0
2013-11-18 08:09:00	AAPL	Stock	18.775	18.775	18.775	18.775	14000.0
2013-11-18 08:10:00	AAPL	Stock	18.7714	18.7714	18.7679	18.7679	5600.0
2013-11-18 08:11:00	AAPL	Stock	18.7679	18.7679	18.7679	18.7679	8400.0
2013-11-18 08:12:00	AAPL	Stock	18.7679	18.7732	18.7679	18.7732	8400.0

> showing 50 of 1,027,905 rows — these rows as CSV

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