PREVIEW / stock_5min / 2014-04-21

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-04-21.parquet
  size:    5.3 MB
  rows:    353,917
  symbols: 3,567

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-21 07:10:00	AAPL	Stock	18.8021	18.8029	18.7946	18.7946	25200.0
2014-04-21 07:25:00	AAPL	Stock	18.8025	18.8171	18.8025	18.8143	44800.0
2014-04-21 07:35:00	AAPL	Stock	18.7946	18.7946	18.7857	18.7857	32592.0
2014-04-21 07:45:00	AAPL	Stock	18.7979	18.7993	18.7979	18.7993	7336.0
2014-04-21 07:50:00	AAPL	Stock	18.8	18.8036	18.8	18.8036	28000.0
2014-04-21 07:55:00	AAPL	Stock	18.8036	18.8036	18.8036	18.8036	2800.0
2014-04-21 08:00:00	AAPL	Stock	18.8025	18.8025	18.7857	18.7864	57120.0
2014-04-21 08:05:00	AAPL	Stock	18.7821	18.7893	18.7821	18.7886	59836.0
2014-04-21 08:10:00	AAPL	Stock	18.7786	18.7832	18.7646	18.7696	145096.0
2014-04-21 08:15:00	AAPL	Stock	18.7768	18.7768	18.7768	18.7768	4676.0
2014-04-21 08:20:00	AAPL	Stock	18.7682	18.7689	18.7643	18.7661	42896.0
2014-04-21 08:25:00	AAPL	Stock	18.7693	18.7746	18.7679	18.7746	58212.0
2014-04-21 08:30:00	AAPL	Stock	18.7682	18.7704	18.7625	18.7704	59360.0
2014-04-21 08:35:00	AAPL	Stock	18.7704	18.7714	18.7696	18.7714	23688.0
2014-04-21 08:50:00	AAPL	Stock	18.7711	18.7746	18.7625	18.7625	39200.0
2014-04-21 08:55:00	AAPL	Stock	18.7679	18.7679	18.7607	18.7625	17584.0
2014-04-21 09:00:00	AAPL	Stock	18.7679	18.7679	18.7589	18.7643	103236.0
2014-04-21 09:05:00	AAPL	Stock	18.7643	18.7643	18.7625	18.7625	65240.0
2014-04-21 09:10:00	AAPL	Stock	18.7607	18.7607	18.7589	18.7589	206080.0
2014-04-21 09:15:00	AAPL	Stock	18.7618	18.7643	18.7618	18.7625	126000.0
2014-04-21 09:20:00	AAPL	Stock	18.7625	18.7643	18.7625	18.7636	86240.0
2014-04-21 09:25:00	AAPL	Stock	18.7618	18.7643	18.7589	18.7643	176372.0
2014-04-21 09:30:00	AAPL	Stock	18.7621	18.7918	18.7129	18.7868	11135488.0
2014-04-21 09:35:00	AAPL	Stock	18.7904	18.8036	18.7711	18.7882	6607552.0
2014-04-21 09:40:00	AAPL	Stock	18.7857	18.8679	18.7791	18.8446	5218416.0
2014-04-21 09:45:00	AAPL	Stock	18.8471	18.8743	18.8229	18.8461	3404800.0
2014-04-21 09:50:00	AAPL	Stock	18.8468	18.8732	18.8311	18.855	3039372.0
2014-04-21 09:55:00	AAPL	Stock	18.8554	18.8682	18.8479	18.8609	2638216.0
2014-04-21 10:00:00	AAPL	Stock	18.8611	18.8964	18.8611	18.8895	2780652.0
2014-04-21 10:05:00	AAPL	Stock	18.8911	18.9243	18.8889	18.9089	3401384.0
2014-04-21 10:10:00	AAPL	Stock	18.9104	18.9179	18.8936	18.8982	2110892.0
2014-04-21 10:15:00	AAPL	Stock	18.8971	18.9196	18.8968	18.9079	2919112.0
2014-04-21 10:20:00	AAPL	Stock	18.9079	18.9086	18.8946	18.8964	2371852.0
2014-04-21 10:25:00	AAPL	Stock	18.8996	18.9104	18.8886	18.8982	1803424.0
2014-04-21 10:30:00	AAPL	Stock	18.8984	18.9	18.8839	18.8846	2626176.0
2014-04-21 10:35:00	AAPL	Stock	18.8846	18.8907	18.8561	18.8636	3305988.0
2014-04-21 10:40:00	AAPL	Stock	18.8639	18.8736	18.8464	18.8471	2789976.0
2014-04-21 10:45:00	AAPL	Stock	18.8464	18.8871	18.8464	18.8868	1946196.0
2014-04-21 10:50:00	AAPL	Stock	18.8871	18.8946	18.8614	18.875	1828988.0
2014-04-21 10:55:00	AAPL	Stock	18.8696	18.8836	18.8602	18.87	1194312.0
2014-04-21 11:00:00	AAPL	Stock	18.8704	18.885	18.87	18.8779	962976.0
2014-04-21 11:05:00	AAPL	Stock	18.8757	18.8929	18.875	18.8907	653240.0
2014-04-21 11:10:00	AAPL	Stock	18.8914	18.9	18.8875	18.8914	1076404.0
2014-04-21 11:15:00	AAPL	Stock	18.8886	18.9089	18.8864	18.9029	1188880.0
2014-04-21 11:20:00	AAPL	Stock	18.9036	18.9096	18.8971	18.9079	934528.0
2014-04-21 11:25:00	AAPL	Stock	18.9079	18.9168	18.8925	18.8964	1547000.0
2014-04-21 11:30:00	AAPL	Stock	18.893	18.9004	18.87	18.88	1056580.0
2014-04-21 11:35:00	AAPL	Stock	18.88	18.8864	18.8696	18.8775	865816.0
2014-04-21 11:40:00	AAPL	Stock	18.8771	18.8868	18.8689	18.8868	835604.0
2014-04-21 11:45:00	AAPL	Stock	18.885	18.8964	18.8789	18.8879	948332.0

> showing 50 of 353,917 rows — these rows as CSV

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