PREVIEW / stock_5min / 2013-07-18

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-07-18.parquet
  size:    5.1 MB
  rows:    337,128
  symbols: 3,491

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
2013-07-18 08:00:00	AAPL	Stock	15.375	15.375	15.3214	15.3646	24640.0
2013-07-18 08:05:00	AAPL	Stock	15.3632	15.3632	15.3579	15.3579	8400.0
2013-07-18 08:10:00	AAPL	Stock	15.3621	15.3725	15.3614	15.3725	8400.0
2013-07-18 08:15:00	AAPL	Stock	15.375	15.3768	15.375	15.375	31108.0
2013-07-18 08:20:00	AAPL	Stock	15.375	15.3946	15.375	15.3875	140084.0
2013-07-18 08:25:00	AAPL	Stock	15.3821	15.3821	15.3746	15.3775	99708.0
2013-07-18 08:30:00	AAPL	Stock	15.3818	15.3929	15.3818	15.3929	72240.0
2013-07-18 08:35:00	AAPL	Stock	15.4032	15.4193	15.4032	15.4093	141036.0
2013-07-18 08:40:00	AAPL	Stock	15.4157	15.4464	15.4107	15.4307	492016.0
2013-07-18 08:45:00	AAPL	Stock	15.4361	15.4821	15.4357	15.4804	527016.0
2013-07-18 08:50:00	AAPL	Stock	15.4739	15.4914	15.4679	15.4839	446292.0
2013-07-18 08:55:00	AAPL	Stock	15.48	15.4911	15.48	15.4911	124292.0
2013-07-18 09:00:00	AAPL	Stock	15.4893	15.5057	15.4893	15.4893	584556.0
2013-07-18 09:05:00	AAPL	Stock	15.4889	15.4957	15.4857	15.4857	154980.0
2013-07-18 09:10:00	AAPL	Stock	15.4911	15.4911	15.4732	15.4732	119420.0
2013-07-18 09:15:00	AAPL	Stock	15.4821	15.4886	15.4589	15.4646	243460.0
2013-07-18 09:20:00	AAPL	Stock	15.4671	15.4818	15.4661	15.4818	51800.0
2013-07-18 09:25:00	AAPL	Stock	15.4786	15.4786	15.4661	15.4689	43848.0
2013-07-18 09:30:00	AAPL	Stock	15.4725	15.5232	15.4607	15.5118	15920352.0
2013-07-18 09:35:00	AAPL	Stock	15.5125	15.5311	15.5039	15.5211	9242184.0
2013-07-18 09:40:00	AAPL	Stock	15.5211	15.5232	15.4868	15.4964	4921196.0
2013-07-18 09:45:00	AAPL	Stock	15.5004	15.5118	15.4861	15.4925	4106956.0
2013-07-18 09:50:00	AAPL	Stock	15.4912	15.4912	15.4429	15.47	5694080.0
2013-07-18 09:55:00	AAPL	Stock	15.4693	15.4904	15.459	15.4818	3515820.0
2013-07-18 10:00:00	AAPL	Stock	15.4854	15.5054	15.4539	15.4646	5063212.0
2013-07-18 10:05:00	AAPL	Stock	15.465	15.4854	15.4471	15.4854	2968980.0
2013-07-18 10:10:00	AAPL	Stock	15.4857	15.5046	15.4715	15.4979	3822448.0
2013-07-18 10:15:00	AAPL	Stock	15.4966	15.5036	15.4811	15.4868	2965620.0
2013-07-18 10:20:00	AAPL	Stock	15.4889	15.4982	15.4782	15.4911	3827208.0
2013-07-18 10:25:00	AAPL	Stock	15.4954	15.4961	15.4786	15.4882	2070096.0
2013-07-18 10:30:00	AAPL	Stock	15.4879	15.5	15.4821	15.49	1565480.0
2013-07-18 10:35:00	AAPL	Stock	15.49	15.4925	15.4732	15.4818	1367604.0
2013-07-18 10:40:00	AAPL	Stock	15.485	15.4982	15.4825	15.4886	1688036.0
2013-07-18 10:45:00	AAPL	Stock	15.4871	15.4946	15.48	15.4903	1293264.0
2013-07-18 10:50:00	AAPL	Stock	15.4889	15.5136	15.4871	15.5075	5066096.0
2013-07-18 10:55:00	AAPL	Stock	15.5071	15.5154	15.5036	15.5036	2310280.0
2013-07-18 11:00:00	AAPL	Stock	15.5068	15.5118	15.5021	15.5055	1601404.0
2013-07-18 11:05:00	AAPL	Stock	15.5082	15.5139	15.4965	15.5125	1788752.0
2013-07-18 11:10:00	AAPL	Stock	15.5125	15.5132	15.4975	15.5014	1349404.0
2013-07-18 11:15:00	AAPL	Stock	15.5011	15.5057	15.4775	15.4885	3080280.0
2013-07-18 11:20:00	AAPL	Stock	15.4886	15.4907	15.4654	15.4654	2311512.0
2013-07-18 11:25:00	AAPL	Stock	15.4655	15.4726	15.4529	15.4636	3609648.0
2013-07-18 11:30:00	AAPL	Stock	15.4607	15.4854	15.45	15.4727	2524704.0
2013-07-18 11:35:00	AAPL	Stock	15.4768	15.4811	15.4714	15.4739	1386840.0
2013-07-18 11:40:00	AAPL	Stock	15.4764	15.4786	15.47	15.4725	1139992.0
2013-07-18 11:45:00	AAPL	Stock	15.4739	15.4746	15.4617	15.4617	1309392.0
2013-07-18 11:50:00	AAPL	Stock	15.4614	15.4669	15.4339	15.4418	3017252.0
2013-07-18 11:55:00	AAPL	Stock	15.4411	15.4479	15.4179	15.4471	3956288.0
2013-07-18 12:00:00	AAPL	Stock	15.4471	15.4514	15.4325	15.4439	1512840.0
2013-07-18 12:05:00	AAPL	Stock	15.4439	15.4621	15.4396	15.4557	1324456.0

> showing 50 of 337,128 rows — these rows as CSV

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