PREVIEW / stock_5min / 2013-10-23

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-10-23.parquet
  size:    5.2 MB
  rows:    343,382
  symbols: 3,536

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-10-23 04:00:00	AAPL	Stock	18.4954	18.4954	18.4954	18.4954	2800.0
2013-10-23 04:05:00	AAPL	Stock	18.5268	18.5268	18.5179	18.5179	11200.0
2013-10-23 04:10:00	AAPL	Stock	18.5179	18.5179	18.5179	18.5179	2800.0
2013-10-23 04:20:00	AAPL	Stock	18.5118	18.5118	18.5118	18.5118	2800.0
2013-10-23 04:35:00	AAPL	Stock	18.525	18.5268	18.525	18.5268	11200.0
2013-10-23 04:45:00	AAPL	Stock	18.5268	18.5268	18.5268	18.5268	2800.0
2013-10-23 05:25:00	AAPL	Stock	18.5357	18.5357	18.5357	18.5357	5600.0
2013-10-23 05:50:00	AAPL	Stock	18.5343	18.5343	18.4954	18.4954	58800.0
2013-10-23 06:20:00	AAPL	Stock	18.4771	18.4771	18.4768	18.4768	56000.0
2013-10-23 06:35:00	AAPL	Stock	18.4821	18.4821	18.4821	18.4821	5600.0
2013-10-23 06:40:00	AAPL	Stock	18.4993	18.5	18.4929	18.4929	16800.0
2013-10-23 06:45:00	AAPL	Stock	18.465	18.465	18.4589	18.4589	25200.0
2013-10-23 07:00:00	AAPL	Stock	18.4679	18.4679	18.4643	18.4643	14000.0
2013-10-23 07:05:00	AAPL	Stock	18.4557	18.4557	18.4504	18.4504	8400.0
2013-10-23 07:10:00	AAPL	Stock	18.4621	18.4732	18.4621	18.4732	19600.0
2013-10-23 07:15:00	AAPL	Stock	18.4807	18.4807	18.4571	18.4714	30744.0
2013-10-23 07:20:00	AAPL	Stock	18.4714	18.4818	18.4643	18.4811	116760.0
2013-10-23 07:25:00	AAPL	Stock	18.4929	18.5	18.4921	18.5	39760.0
2013-10-23 07:30:00	AAPL	Stock	18.5121	18.5179	18.5	18.5161	50960.0
2013-10-23 07:35:00	AAPL	Stock	18.5046	18.5046	18.4736	18.4736	57400.0
2013-10-23 07:45:00	AAPL	Stock	18.5004	18.5143	18.5004	18.5143	14000.0
2013-10-23 07:50:00	AAPL	Stock	18.5179	18.5179	18.5071	18.5071	12656.0
2013-10-23 07:55:00	AAPL	Stock	18.5	18.5	18.4911	18.4911	5600.0
2013-10-23 08:00:00	AAPL	Stock	18.5168	18.525	18.4571	18.51	247128.0
2013-10-23 08:05:00	AAPL	Stock	18.5107	18.5182	18.5	18.5071	114828.0
2013-10-23 08:10:00	AAPL	Stock	18.5143	18.5143	18.4968	18.5	52612.0
2013-10-23 08:15:00	AAPL	Stock	18.4968	18.5	18.4893	18.5	20496.0
2013-10-23 08:20:00	AAPL	Stock	18.4964	18.5	18.4918	18.5	49504.0
2013-10-23 08:25:00	AAPL	Stock	18.4954	18.5	18.4918	18.4918	62776.0
2013-10-23 08:30:00	AAPL	Stock	18.4975	18.5214	18.4918	18.5179	106120.0
2013-10-23 08:35:00	AAPL	Stock	18.5179	18.5246	18.5139	18.5179	202160.0
2013-10-23 08:40:00	AAPL	Stock	18.5139	18.5179	18.5089	18.5179	115640.0
2013-10-23 08:45:00	AAPL	Stock	18.5179	18.5504	18.5143	18.5504	276164.0
2013-10-23 08:50:00	AAPL	Stock	18.5496	18.6025	18.5496	18.6025	305452.0
2013-10-23 08:55:00	AAPL	Stock	18.6043	18.6336	18.5982	18.6246	539112.0
2013-10-23 09:00:00	AAPL	Stock	18.6293	18.6293	18.6161	18.6271	205940.0
2013-10-23 09:05:00	AAPL	Stock	18.6214	18.6489	18.6214	18.6486	496580.0
2013-10-23 09:10:00	AAPL	Stock	18.6489	18.6643	18.6429	18.6643	344680.0
2013-10-23 09:15:00	AAPL	Stock	18.6571	18.6582	18.625	18.625	376796.0
2013-10-23 09:20:00	AAPL	Stock	18.6189	18.6346	18.6114	18.6146	367584.0
2013-10-23 09:25:00	AAPL	Stock	18.615	18.615	18.5357	18.5364	770420.0
2013-10-23 09:30:00	AAPL	Stock	18.5364	18.7089	18.5357	18.7004	16698724.0
2013-10-23 09:35:00	AAPL	Stock	18.6957	18.75	18.6593	18.7171	14220472.0
2013-10-23 09:40:00	AAPL	Stock	18.7171	18.7193	18.5804	18.5896	9882796.0
2013-10-23 09:45:00	AAPL	Stock	18.585	18.6429	18.5829	18.635	7566216.0
2013-10-23 09:50:00	AAPL	Stock	18.6375	18.6654	18.59	18.6596	6813352.0
2013-10-23 09:55:00	AAPL	Stock	18.6593	18.6593	18.5571	18.5854	5805772.0
2013-10-23 10:00:00	AAPL	Stock	18.5871	18.6211	18.5454	18.6093	5506004.0
2013-10-23 10:05:00	AAPL	Stock	18.6086	18.6375	18.595	18.6279	4538100.0
2013-10-23 10:10:00	AAPL	Stock	18.623	18.6886	18.6093	18.6714	6003284.0

> showing 50 of 343,382 rows — these rows as CSV

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