PREVIEW / stock_1min / 2012-08-09

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-08-09.parquet
  size:    12.1 MB
  rows:    904,461
  symbols: 2,805

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-09 04:00:00	AAPL	Stock	22.1179	22.1179	22.1179	22.1179	4200.0
2012-08-09 07:07:00	AAPL	Stock	22.0893	22.0893	22.0893	22.0893	2800.0
2012-08-09 07:08:00	AAPL	Stock	22.0907	22.0907	22.0714	22.0714	16800.0
2012-08-09 07:09:00	AAPL	Stock	22.075	22.075	22.075	22.075	5600.0
2012-08-09 07:10:00	AAPL	Stock	22.0857	22.0871	22.0857	22.0871	5880.0
2012-08-09 07:15:00	AAPL	Stock	22.0732	22.0732	22.0732	22.0732	5600.0
2012-08-09 07:16:00	AAPL	Stock	22.075	22.075	22.075	22.075	2800.0
2012-08-09 07:17:00	AAPL	Stock	22.0732	22.0732	22.0661	22.0661	22400.0
2012-08-09 07:19:00	AAPL	Stock	22.0671	22.0671	22.0671	22.0671	2800.0
2012-08-09 07:20:00	AAPL	Stock	22.0661	22.0661	22.0661	22.0661	8400.0
2012-08-09 07:23:00	AAPL	Stock	22.0714	22.0714	22.0714	22.0714	11200.0
2012-08-09 07:24:00	AAPL	Stock	22.0679	22.0679	22.0679	22.0679	2800.0
2012-08-09 07:31:00	AAPL	Stock	22.0664	22.0664	22.0664	22.0664	5600.0
2012-08-09 07:40:00	AAPL	Stock	22.0593	22.0593	22.0593	22.0593	2800.0
2012-08-09 07:45:00	AAPL	Stock	22.0518	22.0518	22.0432	22.0432	14000.0
2012-08-09 07:46:00	AAPL	Stock	22.05	22.05	22.0411	22.05	37044.0
2012-08-09 07:47:00	AAPL	Stock	22.0464	22.0468	22.005	22.005	106400.0
2012-08-09 07:48:00	AAPL	Stock	22.0089	22.0089	22.0021	22.0021	14000.0
2012-08-09 07:49:00	AAPL	Stock	22.0279	22.0354	22.0107	22.0354	35532.0
2012-08-09 07:51:00	AAPL	Stock	22.0275	22.0275	22.0179	22.0196	41664.0
2012-08-09 07:52:00	AAPL	Stock	22.0182	22.0268	22.0179	22.0268	13328.0
2012-08-09 07:53:00	AAPL	Stock	22.0325	22.0325	22.0214	22.0214	14000.0
2012-08-09 07:55:00	AAPL	Stock	22.0236	22.0236	22.0232	22.0232	27720.0
2012-08-09 07:56:00	AAPL	Stock	22.0261	22.0261	22.0182	22.0182	140700.0
2012-08-09 07:57:00	AAPL	Stock	22.0254	22.0357	22.0179	22.0357	126140.0
2012-08-09 07:58:00	AAPL	Stock	22.0386	22.0396	22.0271	22.0396	28000.0
2012-08-09 07:59:00	AAPL	Stock	22.0396	22.05	22.0396	22.05	56000.0
2012-08-09 08:00:00	AAPL	Stock	22.0536	22.0536	22.0325	22.0325	81060.0
2012-08-09 08:02:00	AAPL	Stock	22.0225	22.0339	22.0179	22.0179	63364.0
2012-08-09 08:03:00	AAPL	Stock	22.0282	22.0336	22.0254	22.0336	17276.0
2012-08-09 08:04:00	AAPL	Stock	22.0214	22.0318	22.0182	22.0318	16800.0
2012-08-09 08:05:00	AAPL	Stock	22.0314	22.0357	22.025	22.0357	68712.0
2012-08-09 08:07:00	AAPL	Stock	22.0271	22.0275	22.025	22.0268	125720.0
2012-08-09 08:08:00	AAPL	Stock	22.0286	22.0286	22.0268	22.0268	77504.0
2012-08-09 08:09:00	AAPL	Stock	22.025	22.0443	22.025	22.0443	52920.0
2012-08-09 08:10:00	AAPL	Stock	22.0329	22.0396	22.0304	22.0389	20468.0
2012-08-09 08:11:00	AAPL	Stock	22.0318	22.0371	22.0318	22.0332	8400.0
2012-08-09 08:12:00	AAPL	Stock	22.0332	22.0332	22.0293	22.0293	14000.0
2012-08-09 08:13:00	AAPL	Stock	22.0339	22.0354	22.03	22.03	18592.0
2012-08-09 08:14:00	AAPL	Stock	22.0354	22.0354	22.0354	22.0354	2800.0
2012-08-09 08:18:00	AAPL	Stock	22.0357	22.0357	22.0357	22.0357	28000.0
2012-08-09 08:19:00	AAPL	Stock	22.0393	22.0393	22.0393	22.0393	5600.0
2012-08-09 08:20:00	AAPL	Stock	22.0429	22.0429	22.0429	22.0429	2800.0
2012-08-09 08:21:00	AAPL	Stock	22.0446	22.0521	22.0446	22.0518	39200.0
2012-08-09 08:22:00	AAPL	Stock	22.0521	22.0536	22.0518	22.0518	28000.0
2012-08-09 08:23:00	AAPL	Stock	22.0479	22.0479	22.0464	22.0464	5600.0
2012-08-09 08:25:00	AAPL	Stock	22.0457	22.05	22.0446	22.05	22400.0
2012-08-09 08:26:00	AAPL	Stock	22.0504	22.0504	22.0504	22.0504	12600.0
2012-08-09 08:27:00	AAPL	Stock	22.0504	22.0504	22.0504	22.0504	2800.0
2012-08-09 08:28:00	AAPL	Stock	22.0504	22.0504	22.0504	22.0504	33600.0

> showing 50 of 904,461 rows — these rows as CSV

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