PREVIEW / stock_5min / 2012-06-27

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-06-27.parquet
  size:    4.8 MB
  rows:    327,296
  symbols: 3,502

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-06-27 05:20:00	AAPL	Stock	20.4357	20.4357	20.4357	20.4357	2800.0
2012-06-27 05:25:00	AAPL	Stock	20.4296	20.4296	20.4296	20.4296	19600.0
2012-06-27 06:00:00	AAPL	Stock	20.445	20.4464	20.445	20.4464	16800.0
2012-06-27 06:15:00	AAPL	Stock	20.4732	20.4732	20.4732	20.4732	8232.0
2012-06-27 06:30:00	AAPL	Stock	20.4732	20.4732	20.4732	20.4732	4368.0
2012-06-27 06:45:00	AAPL	Stock	20.4818	20.4821	20.4818	20.4821	5600.0
2012-06-27 07:00:00	AAPL	Stock	20.4643	20.4821	20.4489	20.4639	22400.0
2012-06-27 07:05:00	AAPL	Stock	20.4639	20.4639	20.4639	20.4639	22400.0
2012-06-27 07:15:00	AAPL	Stock	20.4643	20.4643	20.4643	20.4643	2800.0
2012-06-27 07:20:00	AAPL	Stock	20.4643	20.4714	20.4643	20.4714	11200.0
2012-06-27 07:25:00	AAPL	Stock	20.4821	20.4821	20.4804	20.4818	24024.0
2012-06-27 07:35:00	AAPL	Stock	20.4954	20.5071	20.4954	20.5068	78400.0
2012-06-27 07:40:00	AAPL	Stock	20.5011	20.5107	20.5	20.5	29568.0
2012-06-27 07:50:00	AAPL	Stock	20.4961	20.4964	20.4961	20.4964	28000.0
2012-06-27 07:55:00	AAPL	Stock	20.4825	20.5	20.4825	20.5	75040.0
2012-06-27 08:00:00	AAPL	Stock	20.5	20.5196	20.4821	20.5179	353724.0
2012-06-27 08:05:00	AAPL	Stock	20.5179	20.5364	20.5179	20.5357	336924.0
2012-06-27 08:10:00	AAPL	Stock	20.5304	20.5464	20.5214	20.525	174244.0
2012-06-27 08:15:00	AAPL	Stock	20.5179	20.525	20.5175	20.525	39900.0
2012-06-27 08:20:00	AAPL	Stock	20.5232	20.5232	20.5111	20.5111	22400.0
2012-06-27 08:25:00	AAPL	Stock	20.5143	20.525	20.5054	20.5236	115892.0
2012-06-27 08:30:00	AAPL	Stock	20.5211	20.5257	20.5118	20.5257	94080.0
2012-06-27 08:35:00	AAPL	Stock	20.5239	20.5332	20.5239	20.5286	123004.0
2012-06-27 08:40:00	AAPL	Stock	20.5275	20.5293	20.52	20.5214	60508.0
2012-06-27 08:45:00	AAPL	Stock	20.5243	20.5261	20.5146	20.5146	152236.0
2012-06-27 08:50:00	AAPL	Stock	20.5207	20.5214	20.5039	20.5179	110040.0
2012-06-27 08:55:00	AAPL	Stock	20.5075	20.5179	20.5071	20.5168	97972.0
2012-06-27 09:00:00	AAPL	Stock	20.5168	20.5236	20.5168	20.5182	102228.0
2012-06-27 09:05:00	AAPL	Stock	20.5232	20.5264	20.5214	20.5264	19292.0
2012-06-27 09:10:00	AAPL	Stock	20.5218	20.5282	20.52	20.5282	98476.0
2012-06-27 09:15:00	AAPL	Stock	20.5239	20.5239	20.5029	20.5039	140140.0
2012-06-27 09:20:00	AAPL	Stock	20.5082	20.5161	20.5079	20.5161	107800.0
2012-06-27 09:25:00	AAPL	Stock	20.5279	20.5536	20.5279	20.5364	674968.0
2012-06-27 09:30:00	AAPL	Stock	20.5357	20.5529	20.4761	20.5007	7675920.0
2012-06-27 09:35:00	AAPL	Stock	20.4972	20.5711	20.4971	20.5446	8153684.0
2012-06-27 09:40:00	AAPL	Stock	20.5447	20.5868	20.5429	20.5832	8422568.0
2012-06-27 09:45:00	AAPL	Stock	20.5829	20.585	20.525	20.5439	9466744.0
2012-06-27 09:50:00	AAPL	Stock	20.5437	20.5461	20.5179	20.5314	4557728.0
2012-06-27 09:55:00	AAPL	Stock	20.5339	20.5496	20.4911	20.5214	6509524.0
2012-06-27 10:00:00	AAPL	Stock	20.52	20.5486	20.5179	20.5361	4309312.0
2012-06-27 10:05:00	AAPL	Stock	20.5361	20.5804	20.5264	20.5679	5744900.0
2012-06-27 10:10:00	AAPL	Stock	20.5621	20.5979	20.5611	20.5689	6126904.0
2012-06-27 10:15:00	AAPL	Stock	20.5679	20.5868	20.5461	20.5693	3126620.0
2012-06-27 10:20:00	AAPL	Stock	20.5689	20.5804	20.5546	20.5575	1952216.0
2012-06-27 10:25:00	AAPL	Stock	20.5589	20.5707	20.5479	20.5593	1326528.0
2012-06-27 10:30:00	AAPL	Stock	20.5589	20.5725	20.5375	20.5468	2971164.0
2012-06-27 10:35:00	AAPL	Stock	20.5462	20.5554	20.5357	20.5512	2107644.0
2012-06-27 10:40:00	AAPL	Stock	20.5479	20.55	20.5257	20.5421	3097640.0
2012-06-27 10:45:00	AAPL	Stock	20.5489	20.5553	20.5407	20.5489	1048824.0
2012-06-27 10:50:00	AAPL	Stock	20.5493	20.5536	20.54	20.5436	1399748.0

> showing 50 of 327,296 rows — these rows as CSV

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