PREVIEW / stock_5min / 2011-04-25

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-04-25.parquet
  size:    4.7 MB
  rows:    320,523
  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-04-25 07:05:00	AAPL	Stock	12.5893	12.5893	12.5893	12.5893	2800.0
2011-04-25 07:15:00	AAPL	Stock	12.5843	12.5843	12.5843	12.5843	2800.0
2011-04-25 07:20:00	AAPL	Stock	12.5718	12.5718	12.5714	12.5714	19600.0
2011-04-25 07:25:00	AAPL	Stock	12.5714	12.5854	12.5714	12.5854	5600.0
2011-04-25 07:45:00	AAPL	Stock	12.575	12.575	12.5714	12.5714	32060.0
2011-04-25 07:50:00	AAPL	Stock	12.5721	12.5721	12.5625	12.5625	28000.0
2011-04-25 07:55:00	AAPL	Stock	12.5711	12.5714	12.5589	12.5589	47600.0
2011-04-25 08:00:00	AAPL	Stock	12.5639	12.5893	12.5357	12.5375	205352.0
2011-04-25 08:05:00	AAPL	Stock	12.5357	12.5357	12.5143	12.52	203840.0
2011-04-25 08:10:00	AAPL	Stock	12.5204	12.5311	12.5204	12.5271	67760.0
2011-04-25 08:15:00	AAPL	Stock	12.5307	12.5429	12.5304	12.5429	120176.0
2011-04-25 08:20:00	AAPL	Stock	12.5432	12.5446	12.5304	12.5304	132440.0
2011-04-25 08:25:00	AAPL	Stock	12.5357	12.5361	12.5282	12.5282	134120.0
2011-04-25 08:30:00	AAPL	Stock	12.5282	12.5289	12.5282	12.5289	196084.0
2011-04-25 08:35:00	AAPL	Stock	12.5282	12.5282	12.5179	12.5214	70000.0
2011-04-25 08:40:00	AAPL	Stock	12.5279	12.5321	12.5279	12.5321	28000.0
2011-04-25 08:45:00	AAPL	Stock	12.5321	12.5321	12.5236	12.525	41020.0
2011-04-25 08:50:00	AAPL	Stock	12.5268	12.5321	12.5232	12.5286	462028.0
2011-04-25 08:55:00	AAPL	Stock	12.5286	12.5357	12.5286	12.5321	98840.0
2011-04-25 09:00:00	AAPL	Stock	12.5321	12.5321	12.5289	12.5289	88340.0
2011-04-25 09:05:00	AAPL	Stock	12.5268	12.5354	12.5236	12.5286	61600.0
2011-04-25 09:10:00	AAPL	Stock	12.5289	12.5289	12.5214	12.5214	250824.0
2011-04-25 09:15:00	AAPL	Stock	12.5229	12.5275	12.5204	12.5275	132104.0
2011-04-25 09:20:00	AAPL	Stock	12.5243	12.525	12.5214	12.5232	88620.0
2011-04-25 09:25:00	AAPL	Stock	12.5232	12.5286	12.5093	12.5179	198128.0
2011-04-25 09:30:00	AAPL	Stock	12.5136	12.5836	12.5107	12.5739	12818652.0
2011-04-25 09:35:00	AAPL	Stock	12.5746	12.5968	12.5275	12.5936	9605904.0
2011-04-25 09:40:00	AAPL	Stock	12.5825	12.583	12.5111	12.5482	11283300.0
2011-04-25 09:45:00	AAPL	Stock	12.5481	12.5839	12.5396	12.576	8438248.0
2011-04-25 09:50:00	AAPL	Stock	12.5782	12.6029	12.5693	12.5893	9021404.0
2011-04-25 09:55:00	AAPL	Stock	12.5904	12.6157	12.5893	12.61	7968016.0
2011-04-25 10:00:00	AAPL	Stock	12.6095	12.6136	12.5872	12.5904	6779500.0
2011-04-25 10:05:00	AAPL	Stock	12.5896	12.5936	12.5764	12.5786	5026700.0
2011-04-25 10:10:00	AAPL	Stock	12.5775	12.5893	12.5739	12.5804	3107356.0
2011-04-25 10:15:00	AAPL	Stock	12.5818	12.586	12.5675	12.5675	5841892.0
2011-04-25 10:20:00	AAPL	Stock	12.568	12.57	12.545	12.5639	7092372.0
2011-04-25 10:25:00	AAPL	Stock	12.5643	12.5739	12.5507	12.5686	3983224.0
2011-04-25 10:30:00	AAPL	Stock	12.5689	12.5714	12.5482	12.5482	3276056.0
2011-04-25 10:35:00	AAPL	Stock	12.5479	12.5589	12.5411	12.5586	4266192.0
2011-04-25 10:40:00	AAPL	Stock	12.5582	12.5589	12.5488	12.5577	2179324.0
2011-04-25 10:45:00	AAPL	Stock	12.5589	12.565	12.55	12.5571	2725268.0
2011-04-25 10:50:00	AAPL	Stock	12.5557	12.5625	12.5536	12.5568	2163896.0
2011-04-25 10:55:00	AAPL	Stock	12.5564	12.5714	12.5506	12.5707	2575020.0
2011-04-25 11:00:00	AAPL	Stock	12.5704	12.5821	12.5661	12.5796	4080552.0
2011-04-25 11:05:00	AAPL	Stock	12.5804	12.5836	12.5664	12.5664	1979740.0
2011-04-25 11:10:00	AAPL	Stock	12.5661	12.5718	12.5611	12.5691	2298464.0
2011-04-25 11:15:00	AAPL	Stock	12.5671	12.5786	12.5668	12.575	1530844.0
2011-04-25 11:20:00	AAPL	Stock	12.5751	12.5818	12.5666	12.575	2014096.0
2011-04-25 11:25:00	AAPL	Stock	12.5756	12.58	12.5725	12.5768	1275764.0
2011-04-25 11:30:00	AAPL	Stock	12.5761	12.5782	12.5714	12.5721	1127476.0

> showing 50 of 320,523 rows — these rows as CSV

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