PREVIEW / stock_1min / 2011-04-27

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-04-27.parquet
  size:    13.1 MB
  rows:    973,829
  symbols: 2,886

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
2011-04-27 04:03:00	AAPL	Stock	12.5039	12.5039	12.45	12.45	6860.0
2011-04-27 04:40:00	AAPL	Stock	12.4861	12.4861	12.4861	12.4861	2800.0
2011-04-27 04:54:00	AAPL	Stock	12.5	12.5	12.5	12.5	2800.0
2011-04-27 05:29:00	AAPL	Stock	12.5	12.5	12.5	12.5	8400.0
2011-04-27 05:31:00	AAPL	Stock	12.5	12.5	12.5	12.5	2800.0
2011-04-27 05:34:00	AAPL	Stock	12.5	12.5143	12.5	12.5143	5600.0
2011-04-27 05:42:00	AAPL	Stock	12.4964	12.4964	12.4964	12.4964	2800.0
2011-04-27 05:46:00	AAPL	Stock	12.4964	12.4964	12.4964	12.4964	2800.0
2011-04-27 05:56:00	AAPL	Stock	12.4964	12.4964	12.4964	12.4964	2800.0
2011-04-27 06:48:00	AAPL	Stock	12.5139	12.5154	12.5139	12.5154	11200.0
2011-04-27 06:49:00	AAPL	Stock	12.5154	12.5154	12.5154	12.5154	25200.0
2011-04-27 07:05:00	AAPL	Stock	12.5114	12.5114	12.5114	12.5114	2800.0
2011-04-27 07:10:00	AAPL	Stock	12.5107	12.5214	12.5107	12.5214	19600.0
2011-04-27 07:15:00	AAPL	Stock	12.5261	12.5268	12.5261	12.5268	14000.0
2011-04-27 07:20:00	AAPL	Stock	12.5179	12.5179	12.5179	12.5179	4032.0
2011-04-27 07:31:00	AAPL	Stock	12.5357	12.5357	12.5357	12.5357	5600.0
2011-04-27 07:36:00	AAPL	Stock	12.5357	12.5357	12.5357	12.5357	2800.0
2011-04-27 07:39:00	AAPL	Stock	12.5429	12.5429	12.5429	12.5429	2800.0
2011-04-27 07:53:00	AAPL	Stock	12.5389	12.5389	12.5389	12.5389	2800.0
2011-04-27 08:00:00	AAPL	Stock	12.535	12.5357	12.5179	12.5182	74172.0
2011-04-27 08:04:00	AAPL	Stock	12.525	12.525	12.5193	12.5193	28000.0
2011-04-27 08:05:00	AAPL	Stock	12.5193	12.5193	12.5182	12.5182	8400.0
2011-04-27 08:06:00	AAPL	Stock	12.5179	12.5332	12.5179	12.5332	30884.0
2011-04-27 08:07:00	AAPL	Stock	12.5254	12.5254	12.5214	12.5214	5600.0
2011-04-27 08:08:00	AAPL	Stock	12.52	12.52	12.52	12.52	2800.0
2011-04-27 08:09:00	AAPL	Stock	12.5186	12.5286	12.5186	12.5271	32676.0
2011-04-27 08:10:00	AAPL	Stock	12.5271	12.5271	12.5271	12.5271	13440.0
2011-04-27 08:12:00	AAPL	Stock	12.5321	12.5357	12.5321	12.5357	81676.0
2011-04-27 08:13:00	AAPL	Stock	12.5357	12.5357	12.5357	12.5357	14000.0
2011-04-27 08:14:00	AAPL	Stock	12.5357	12.5393	12.5357	12.5393	25480.0
2011-04-27 08:15:00	AAPL	Stock	12.5429	12.5457	12.5429	12.5429	51240.0
2011-04-27 08:16:00	AAPL	Stock	12.5443	12.5443	12.5429	12.5443	21672.0
2011-04-27 08:18:00	AAPL	Stock	12.5443	12.5554	12.5443	12.5554	143696.0
2011-04-27 08:19:00	AAPL	Stock	12.5443	12.5443	12.5432	12.5432	16800.0
2011-04-27 08:24:00	AAPL	Stock	12.5443	12.5443	12.5411	12.5411	91840.0
2011-04-27 08:25:00	AAPL	Stock	12.5357	12.5439	12.5357	12.5439	15008.0
2011-04-27 08:26:00	AAPL	Stock	12.5411	12.5454	12.5411	12.5454	12600.0
2011-04-27 08:28:00	AAPL	Stock	12.545	12.545	12.545	12.545	5880.0
2011-04-27 08:29:00	AAPL	Stock	12.5393	12.5393	12.5393	12.5393	5600.0
2011-04-27 08:30:00	AAPL	Stock	12.5443	12.545	12.5396	12.5396	27720.0
2011-04-27 08:31:00	AAPL	Stock	12.5446	12.5546	12.5446	12.5546	133000.0
2011-04-27 08:32:00	AAPL	Stock	12.5525	12.5561	12.5482	12.55	251580.0
2011-04-27 08:33:00	AAPL	Stock	12.55	12.55	12.55	12.55	12740.0
2011-04-27 08:34:00	AAPL	Stock	12.55	12.5518	12.55	12.5518	25228.0
2011-04-27 08:35:00	AAPL	Stock	12.5514	12.5518	12.5514	12.5518	26796.0
2011-04-27 08:36:00	AAPL	Stock	12.5525	12.5561	12.5525	12.5561	90328.0
2011-04-27 08:37:00	AAPL	Stock	12.5607	12.5607	12.5604	12.5604	18200.0
2011-04-27 08:38:00	AAPL	Stock	12.5607	12.5661	12.5607	12.5657	81060.0
2011-04-27 08:39:00	AAPL	Stock	12.5621	12.5657	12.5621	12.5657	110376.0
2011-04-27 08:40:00	AAPL	Stock	12.565	12.5671	12.565	12.5654	44800.0

> showing 50 of 973,829 rows — these rows as CSV

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