PREVIEW / stock_5min / 2014-04-17

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-04-17.parquet
  size:    5.3 MB
  rows:    354,328
  symbols: 3,540

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
2014-04-17 04:50:00	AAPL	Stock	18.4575	18.4575	18.4575	18.4575	5600.0
2014-04-17 07:00:00	AAPL	Stock	18.4571	18.4571	18.4571	18.4571	3024.0
2014-04-17 07:30:00	AAPL	Stock	18.4861	18.4864	18.4861	18.4864	5600.0
2014-04-17 07:40:00	AAPL	Stock	18.4996	18.5214	18.4996	18.5214	30800.0
2014-04-17 07:55:00	AAPL	Stock	18.515	18.5218	18.515	18.5218	39200.0
2014-04-17 08:00:00	AAPL	Stock	18.4571	18.5264	18.4571	18.5214	100800.0
2014-04-17 08:05:00	AAPL	Stock	18.5268	18.5268	18.5268	18.5268	2800.0
2014-04-17 08:10:00	AAPL	Stock	18.5182	18.5643	18.5182	18.5625	82936.0
2014-04-17 08:15:00	AAPL	Stock	18.5446	18.6064	18.5446	18.5736	228956.0
2014-04-17 08:20:00	AAPL	Stock	18.5786	18.5964	18.5557	18.5964	39900.0
2014-04-17 08:25:00	AAPL	Stock	18.5896	18.6089	18.5896	18.6071	69944.0
2014-04-17 08:30:00	AAPL	Stock	18.6071	18.6429	18.6071	18.6239	200564.0
2014-04-17 08:35:00	AAPL	Stock	18.6114	18.6154	18.6039	18.6039	142464.0
2014-04-17 08:40:00	AAPL	Stock	18.6032	18.6089	18.5979	18.6064	37520.0
2014-04-17 08:45:00	AAPL	Stock	18.6054	18.615	18.6004	18.615	47320.0
2014-04-17 08:50:00	AAPL	Stock	18.615	18.6214	18.615	18.6196	36960.0
2014-04-17 08:55:00	AAPL	Stock	18.6204	18.6271	18.6164	18.6271	62468.0
2014-04-17 09:00:00	AAPL	Stock	18.6286	18.6393	18.6286	18.6375	30800.0
2014-04-17 09:05:00	AAPL	Stock	18.6225	18.6418	18.6118	18.6332	163548.0
2014-04-17 09:10:00	AAPL	Stock	18.6325	18.6325	18.6164	18.6182	193592.0
2014-04-17 09:15:00	AAPL	Stock	18.6161	18.6186	18.6057	18.6057	120680.0
2014-04-17 09:20:00	AAPL	Stock	18.6057	18.6071	18.6	18.6071	57568.0
2014-04-17 09:25:00	AAPL	Stock	18.5954	18.5954	18.5468	18.5893	593600.0
2014-04-17 09:30:00	AAPL	Stock	18.5714	18.5989	18.5482	18.5654	19204528.0
2014-04-17 09:35:00	AAPL	Stock	18.5707	18.5911	18.5429	18.5854	5478424.0
2014-04-17 09:40:00	AAPL	Stock	18.5893	18.6129	18.5889	18.6029	5109888.0
2014-04-17 09:45:00	AAPL	Stock	18.6032	18.6032	18.5639	18.5716	3875256.0
2014-04-17 09:50:00	AAPL	Stock	18.5754	18.5911	18.5596	18.5721	2966628.0
2014-04-17 09:55:00	AAPL	Stock	18.5689	18.59	18.5625	18.5768	3095624.0
2014-04-17 10:00:00	AAPL	Stock	18.5764	18.6189	18.57	18.6154	3862320.0
2014-04-17 10:05:00	AAPL	Stock	18.6192	18.6279	18.579	18.585	4744320.0
2014-04-17 10:10:00	AAPL	Stock	18.5821	18.6086	18.5736	18.6075	2540188.0
2014-04-17 10:15:00	AAPL	Stock	18.6071	18.6077	18.5732	18.5789	1681876.0
2014-04-17 10:20:00	AAPL	Stock	18.5786	18.5929	18.5714	18.5896	2057944.0
2014-04-17 10:25:00	AAPL	Stock	18.5925	18.6054	18.5789	18.6054	2479372.0
2014-04-17 10:30:00	AAPL	Stock	18.6032	18.62	18.5907	18.6168	3446884.0
2014-04-17 10:35:00	AAPL	Stock	18.6168	18.6236	18.5993	18.6079	2453836.0
2014-04-17 10:40:00	AAPL	Stock	18.6111	18.6204	18.6043	18.6046	2989784.0
2014-04-17 10:45:00	AAPL	Stock	18.605	18.62	18.6018	18.6043	1760612.0
2014-04-17 10:50:00	AAPL	Stock	18.6039	18.6179	18.6018	18.6161	1730316.0
2014-04-17 10:55:00	AAPL	Stock	18.6146	18.6475	18.605	18.6475	4387768.0
2014-04-17 11:00:00	AAPL	Stock	18.6471	18.6582	18.6429	18.6514	2966376.0
2014-04-17 11:05:00	AAPL	Stock	18.6525	18.6589	18.6418	18.6446	2062452.0
2014-04-17 11:10:00	AAPL	Stock	18.6457	18.6584	18.6418	18.6557	2380980.0
2014-04-17 11:15:00	AAPL	Stock	18.655	18.6586	18.6429	18.6511	1204476.0
2014-04-17 11:20:00	AAPL	Stock	18.6507	18.6757	18.6507	18.6725	3199672.0
2014-04-17 11:25:00	AAPL	Stock	18.6732	18.6946	18.6725	18.6921	4319672.0
2014-04-17 11:30:00	AAPL	Stock	18.6949	18.7071	18.6829	18.6843	3272976.0
2014-04-17 11:35:00	AAPL	Stock	18.6848	18.6857	18.6686	18.6725	2153732.0
2014-04-17 11:40:00	AAPL	Stock	18.6714	18.6764	18.6625	18.6732	2476152.0

> showing 50 of 354,328 rows — these rows as CSV

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