PREVIEW / stock_5min / 2012-04-17

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-04-17.parquet
  size:    4.8 MB
  rows:    325,732
  symbols: 3,546

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
2012-04-17 04:00:00	AAPL	Stock	20.6679	20.6679	20.2679	20.3211	121240.0
2012-04-17 04:05:00	AAPL	Stock	20.3214	20.425	20.3214	20.375	106512.0
2012-04-17 04:10:00	AAPL	Stock	20.4071	20.4429	20.4071	20.4429	147308.0
2012-04-17 04:15:00	AAPL	Stock	20.4286	20.4286	20.3929	20.4014	37240.0
2012-04-17 04:20:00	AAPL	Stock	20.3946	20.4018	20.3946	20.3964	28588.0
2012-04-17 04:25:00	AAPL	Stock	20.4018	20.4464	20.4018	20.4464	64512.0
2012-04-17 04:30:00	AAPL	Stock	20.4639	20.4643	20.4361	20.4643	47600.0
2012-04-17 04:35:00	AAPL	Stock	20.4643	20.4911	20.4643	20.4911	6664.0
2012-04-17 04:40:00	AAPL	Stock	20.4789	20.5311	20.4789	20.53	16884.0
2012-04-17 04:45:00	AAPL	Stock	20.5268	20.5304	20.5268	20.5304	35000.0
2012-04-17 04:50:00	AAPL	Stock	20.5179	20.5179	20.5179	20.5179	2800.0
2012-04-17 05:00:00	AAPL	Stock	20.5143	20.5429	20.5143	20.5429	20188.0
2012-04-17 05:05:00	AAPL	Stock	20.5496	20.5921	20.5496	20.5857	56000.0
2012-04-17 05:10:00	AAPL	Stock	20.6036	20.6214	20.6036	20.6214	33600.0
2012-04-17 05:15:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	11340.0
2012-04-17 05:20:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	9240.0
2012-04-17 05:25:00	AAPL	Stock	20.6071	20.6071	20.6068	20.6071	16800.0
2012-04-17 05:30:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	14000.0
2012-04-17 05:35:00	AAPL	Stock	20.6139	20.6139	20.6071	20.6071	11200.0
2012-04-17 05:40:00	AAPL	Stock	20.6214	20.6429	20.6214	20.6429	78708.0
2012-04-17 05:45:00	AAPL	Stock	20.6604	20.6739	20.6593	20.6739	81312.0
2012-04-17 05:50:00	AAPL	Stock	20.6614	20.6614	20.6614	20.6614	21840.0
2012-04-17 05:55:00	AAPL	Stock	20.65	20.6729	20.65	20.6729	33600.0
2012-04-17 06:00:00	AAPL	Stock	20.6675	20.6675	20.65	20.65	61600.0
2012-04-17 06:05:00	AAPL	Stock	20.6607	20.6607	20.6436	20.6436	51800.0
2012-04-17 06:10:00	AAPL	Stock	20.6325	20.6429	20.6321	20.6321	8400.0
2012-04-17 06:20:00	AAPL	Stock	20.6429	20.6607	20.6429	20.6604	58408.0
2012-04-17 06:25:00	AAPL	Stock	20.6607	20.6786	20.6607	20.6786	107660.0
2012-04-17 06:30:00	AAPL	Stock	20.6786	20.6786	20.6786	20.6786	5600.0
2012-04-17 06:35:00	AAPL	Stock	20.6707	20.6707	20.6707	20.6707	17220.0
2012-04-17 06:45:00	AAPL	Stock	20.7032	20.7446	20.7032	20.7446	111580.0
2012-04-17 06:50:00	AAPL	Stock	20.7446	20.75	20.7346	20.7346	39200.0
2012-04-17 06:55:00	AAPL	Stock	20.7143	20.75	20.7143	20.75	45752.0
2012-04-17 07:00:00	AAPL	Stock	20.7321	20.7321	20.69	20.7143	132356.0
2012-04-17 07:05:00	AAPL	Stock	20.7143	20.7143	20.6643	20.6643	91000.0
2012-04-17 07:10:00	AAPL	Stock	20.6607	20.6607	20.6071	20.6071	221620.0
2012-04-17 07:15:00	AAPL	Stock	20.6207	20.6364	20.5446	20.6179	747964.0
2012-04-17 07:20:00	AAPL	Stock	20.6071	20.6589	20.6071	20.6464	312004.0
2012-04-17 07:25:00	AAPL	Stock	20.6429	20.7036	20.6254	20.6664	215992.0
2012-04-17 07:30:00	AAPL	Stock	20.6789	20.6789	20.6339	20.6339	280084.0
2012-04-17 07:35:00	AAPL	Stock	20.6214	20.6782	20.6214	20.6607	86744.0
2012-04-17 07:40:00	AAPL	Stock	20.6768	20.6786	20.6561	20.6704	142464.0
2012-04-17 07:45:00	AAPL	Stock	20.6661	20.6786	20.6661	20.6679	58380.0
2012-04-17 07:50:00	AAPL	Stock	20.6771	20.6786	20.6429	20.6518	66556.0
2012-04-17 07:55:00	AAPL	Stock	20.6439	20.6893	20.6436	20.6761	112000.0
2012-04-17 08:00:00	AAPL	Stock	20.6654	20.7071	20.5821	20.6607	387352.0
2012-04-17 08:05:00	AAPL	Stock	20.6643	20.6936	20.6571	20.6929	301336.0
2012-04-17 08:10:00	AAPL	Stock	20.6961	20.7643	20.6961	20.7643	655032.0
2012-04-17 08:15:00	AAPL	Stock	20.7643	20.8357	20.7643	20.8143	1419152.0
2012-04-17 08:20:00	AAPL	Stock	20.8143	20.8704	20.8071	20.8586	1200612.0

> showing 50 of 325,732 rows — these rows as CSV

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