PREVIEW / stock_5min / 2011-02-28

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-02-28.parquet
  size:    5.1 MB
  rows:    339,636
  symbols: 3,560

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-02-28 04:00:00	AAPL	Stock	12.5	12.5064	12.5	12.5046	21000.0
2011-02-28 04:25:00	AAPL	Stock	12.5464	12.5714	12.5464	12.5714	14000.0
2011-02-28 04:30:00	AAPL	Stock	12.5714	12.5761	12.57	12.5761	28000.0
2011-02-28 04:45:00	AAPL	Stock	12.5821	12.5821	12.5821	12.5821	5600.0
2011-02-28 05:05:00	AAPL	Stock	12.5643	12.5643	12.4464	12.4464	22820.0
2011-02-28 05:25:00	AAPL	Stock	12.5793	12.5793	12.5704	12.5704	5600.0
2011-02-28 05:35:00	AAPL	Stock	12.5714	12.5714	12.5714	12.5714	5600.0
2011-02-28 05:40:00	AAPL	Stock	12.5714	12.5714	12.5714	12.5714	5600.0
2011-02-28 05:50:00	AAPL	Stock	12.5714	12.5714	12.5714	12.5714	5600.0
2011-02-28 05:55:00	AAPL	Stock	12.575	12.575	12.575	12.575	2800.0
2011-02-28 06:05:00	AAPL	Stock	12.5732	12.5732	12.5732	12.5732	8400.0
2011-02-28 06:20:00	AAPL	Stock	12.5857	12.5861	12.5857	12.5861	5600.0
2011-02-28 06:30:00	AAPL	Stock	12.5821	12.5821	12.5718	12.5718	11200.0
2011-02-28 06:40:00	AAPL	Stock	12.5821	12.5821	12.5821	12.5821	2800.0
2011-02-28 06:45:00	AAPL	Stock	12.5718	12.5821	12.5714	12.5821	14000.0
2011-02-28 06:50:00	AAPL	Stock	12.5889	12.5889	12.5889	12.5889	2800.0
2011-02-28 07:00:00	AAPL	Stock	12.5804	12.5804	12.5611	12.5711	72492.0
2011-02-28 07:05:00	AAPL	Stock	12.5714	12.5714	12.5479	12.5482	66640.0
2011-02-28 07:10:00	AAPL	Stock	12.5536	12.5536	12.5357	12.5357	54684.0
2011-02-28 07:15:00	AAPL	Stock	12.5357	12.5357	12.5357	12.5357	26124.0
2011-02-28 07:20:00	AAPL	Stock	12.5289	12.535	12.525	12.5271	54600.0
2011-02-28 07:25:00	AAPL	Stock	12.5257	12.5257	12.5186	12.525	42280.0
2011-02-28 07:30:00	AAPL	Stock	12.525	12.5357	12.525	12.5354	47460.0
2011-02-28 07:35:00	AAPL	Stock	12.5357	12.5421	12.5304	12.5375	82544.0
2011-02-28 07:40:00	AAPL	Stock	12.5396	12.5407	12.5364	12.5393	30520.0
2011-02-28 07:45:00	AAPL	Stock	12.5421	12.5446	12.5411	12.5446	65100.0
2011-02-28 07:50:00	AAPL	Stock	12.5446	12.5554	12.5446	12.5554	82516.0
2011-02-28 07:55:00	AAPL	Stock	12.5536	12.5536	12.5468	12.5468	22092.0
2011-02-28 08:00:00	AAPL	Stock	12.5464	12.5536	12.5421	12.5446	213584.0
2011-02-28 08:05:00	AAPL	Stock	12.55	12.5714	12.55	12.5696	276108.0
2011-02-28 08:10:00	AAPL	Stock	12.5689	12.5779	12.5679	12.575	284704.0
2011-02-28 08:15:00	AAPL	Stock	12.5775	12.5786	12.5661	12.5661	360892.0
2011-02-28 08:20:00	AAPL	Stock	12.5707	12.5714	12.5589	12.5621	149016.0
2011-02-28 08:25:00	AAPL	Stock	12.5668	12.5704	12.5607	12.5614	290360.0
2011-02-28 08:30:00	AAPL	Stock	12.5614	12.5629	12.5571	12.5596	391720.0
2011-02-28 08:35:00	AAPL	Stock	12.5586	12.5625	12.5539	12.5607	126308.0
2011-02-28 08:40:00	AAPL	Stock	12.5604	12.5625	12.5571	12.5607	225456.0
2011-02-28 08:45:00	AAPL	Stock	12.5621	12.5625	12.5457	12.5471	247296.0
2011-02-28 08:50:00	AAPL	Stock	12.5482	12.5482	12.5429	12.5446	77000.0
2011-02-28 08:55:00	AAPL	Stock	12.5457	12.5536	12.5457	12.5482	206780.0
2011-02-28 09:00:00	AAPL	Stock	12.5475	12.5496	12.5429	12.5464	246820.0
2011-02-28 09:05:00	AAPL	Stock	12.5464	12.5482	12.5411	12.5429	140952.0
2011-02-28 09:10:00	AAPL	Stock	12.5446	12.5543	12.5429	12.5482	546756.0
2011-02-28 09:15:00	AAPL	Stock	12.5496	12.5496	12.5464	12.5482	1045184.0
2011-02-28 09:20:00	AAPL	Stock	12.5482	12.5482	12.5429	12.5454	182700.0
2011-02-28 09:25:00	AAPL	Stock	12.5429	12.5464	12.5386	12.54	167888.0
2011-02-28 09:30:00	AAPL	Stock	12.5439	12.6804	12.54	12.6482	33782840.0
2011-02-28 09:35:00	AAPL	Stock	12.6482	12.6761	12.6346	12.6711	19358724.0
2011-02-28 09:40:00	AAPL	Stock	12.6711	12.6743	12.6396	12.6519	13489812.0
2011-02-28 09:45:00	AAPL	Stock	12.6496	12.6568	12.6196	12.6329	11679192.0

> showing 50 of 339,636 rows — these rows as CSV

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