PREVIEW / stock_5min / 2012-07-27

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-27.parquet
  size:    4.9 MB
  rows:    323,735
  symbols: 3,483

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-07-27 04:00:00	AAPL	Stock	20.5611	20.6071	20.5611	20.6	20160.0
2012-07-27 04:05:00	AAPL	Stock	20.6164	20.6164	20.6164	20.6164	2800.0
2012-07-27 04:10:00	AAPL	Stock	20.6425	20.6425	20.6425	20.6425	2800.0
2012-07-27 04:15:00	AAPL	Stock	20.6418	20.6421	20.6418	20.6421	5600.0
2012-07-27 04:20:00	AAPL	Stock	20.5954	20.6025	20.5954	20.6025	5600.0
2012-07-27 04:35:00	AAPL	Stock	20.5936	20.5936	20.5893	20.5893	19600.0
2012-07-27 04:45:00	AAPL	Stock	20.5611	20.5611	20.5575	20.5575	5600.0
2012-07-27 05:15:00	AAPL	Stock	20.5414	20.5414	20.5414	20.5414	2800.0
2012-07-27 05:45:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	25200.0
2012-07-27 06:50:00	AAPL	Stock	20.6068	20.6071	20.6068	20.6071	22120.0
2012-07-27 06:55:00	AAPL	Stock	20.6036	20.6071	20.6036	20.6071	8400.0
2012-07-27 07:00:00	AAPL	Stock	20.6054	20.6054	20.6054	20.6054	2800.0
2012-07-27 07:05:00	AAPL	Stock	20.5907	20.5907	20.5893	20.5893	14700.0
2012-07-27 07:15:00	AAPL	Stock	20.5893	20.6068	20.5893	20.6018	57064.0
2012-07-27 07:20:00	AAPL	Stock	20.6032	20.6071	20.6032	20.6032	126588.0
2012-07-27 07:40:00	AAPL	Stock	20.5954	20.5954	20.5954	20.5954	4956.0
2012-07-27 07:45:00	AAPL	Stock	20.5718	20.5718	20.5571	20.5657	28364.0
2012-07-27 07:50:00	AAPL	Stock	20.5675	20.5679	20.5675	20.5679	28000.0
2012-07-27 07:55:00	AAPL	Stock	20.5607	20.5607	20.5571	20.5571	5600.0
2012-07-27 08:00:00	AAPL	Stock	20.5536	20.5536	20.5357	20.5357	69160.0
2012-07-27 08:05:00	AAPL	Stock	20.535	20.5571	20.535	20.5571	186788.0
2012-07-27 08:10:00	AAPL	Stock	20.5536	20.5536	20.5464	20.5482	25760.0
2012-07-27 08:15:00	AAPL	Stock	20.5411	20.5432	20.5268	20.5393	223636.0
2012-07-27 08:20:00	AAPL	Stock	20.5254	20.5304	20.525	20.525	19600.0
2012-07-27 08:25:00	AAPL	Stock	20.5236	20.5339	20.5182	20.5339	39200.0
2012-07-27 08:30:00	AAPL	Stock	20.535	20.5489	20.5179	20.5346	228732.0
2012-07-27 08:35:00	AAPL	Stock	20.5286	20.5479	20.5286	20.5357	139244.0
2012-07-27 08:40:00	AAPL	Stock	20.5354	20.5493	20.5354	20.5482	84000.0
2012-07-27 08:45:00	AAPL	Stock	20.5482	20.5536	20.5275	20.5275	330568.0
2012-07-27 08:50:00	AAPL	Stock	20.5229	20.5229	20.5089	20.5175	200368.0
2012-07-27 08:55:00	AAPL	Stock	20.5107	20.5107	20.4911	20.4946	66192.0
2012-07-27 09:00:00	AAPL	Stock	20.4964	20.5	20.4861	20.4914	44128.0
2012-07-27 09:05:00	AAPL	Stock	20.4961	20.4982	20.4896	20.4982	47712.0
2012-07-27 09:10:00	AAPL	Stock	20.4896	20.5243	20.4896	20.5186	200816.0
2012-07-27 09:15:00	AAPL	Stock	20.5243	20.5446	20.5243	20.5446	176848.0
2012-07-27 09:20:00	AAPL	Stock	20.5446	20.55	20.54	20.5446	218120.0
2012-07-27 09:25:00	AAPL	Stock	20.5439	20.5446	20.5286	20.5446	542920.0
2012-07-27 09:30:00	AAPL	Stock	20.5361	20.5446	20.4821	20.5018	9251592.0
2012-07-27 09:35:00	AAPL	Stock	20.5057	20.5464	20.4593	20.4675	10131436.0
2012-07-27 09:40:00	AAPL	Stock	20.4679	20.4688	20.4246	20.4421	9137184.0
2012-07-27 09:45:00	AAPL	Stock	20.4393	20.4736	20.4146	20.4343	9475032.0
2012-07-27 09:50:00	AAPL	Stock	20.4316	20.4693	20.4139	20.4536	5474560.0
2012-07-27 09:55:00	AAPL	Stock	20.4521	20.5064	20.4364	20.4721	5949916.0
2012-07-27 10:00:00	AAPL	Stock	20.4718	20.5	20.4632	20.4861	4220216.0
2012-07-27 10:05:00	AAPL	Stock	20.4882	20.5082	20.4554	20.4643	4941496.0
2012-07-27 10:10:00	AAPL	Stock	20.4675	20.4875	20.4643	20.4671	3346056.0
2012-07-27 10:15:00	AAPL	Stock	20.4675	20.4818	20.45	20.4507	3502520.0
2012-07-27 10:20:00	AAPL	Stock	20.4521	20.485	20.4418	20.4543	3968132.0
2012-07-27 10:25:00	AAPL	Stock	20.4543	20.4732	20.4379	20.4411	3014732.0
2012-07-27 10:30:00	AAPL	Stock	20.4429	20.4711	20.4375	20.4414	3031084.0

> showing 50 of 323,735 rows — these rows as CSV

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