PREVIEW / stock_5min / 2014-08-28

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-08-28.parquet
  size:    5.2 MB
  rows:    346,392
  symbols: 3,583

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-08-28 04:00:00	AAPL	Stock	25.5875	25.5875	25.565	25.565	2800.0
2014-08-28 04:10:00	AAPL	Stock	25.5	25.5	25.48	25.5	2000.0
2014-08-28 04:15:00	AAPL	Stock	25.5	25.5	25.5	25.5	400.0
2014-08-28 04:35:00	AAPL	Stock	25.5	25.5	25.5	25.5	3116.0
2014-08-28 05:15:00	AAPL	Stock	25.5	25.5	25.5	25.5	3020.0
2014-08-28 05:50:00	AAPL	Stock	25.5075	25.5075	25.5	25.5	4520.0
2014-08-28 05:55:00	AAPL	Stock	25.45	25.45	25.4375	25.45	3600.0
2014-08-28 06:00:00	AAPL	Stock	25.45	25.45	25.45	25.45	6708.0
2014-08-28 06:10:00	AAPL	Stock	25.45	25.45	25.425	25.4475	26800.0
2014-08-28 06:15:00	AAPL	Stock	25.415	25.4175	25.4025	25.4175	19052.0
2014-08-28 06:20:00	AAPL	Stock	25.4025	25.4225	25.375	25.4225	9468.0
2014-08-28 06:25:00	AAPL	Stock	25.4175	25.4175	25.3825	25.3825	5152.0
2014-08-28 06:35:00	AAPL	Stock	25.3825	25.3825	25.375	25.38	5428.0
2014-08-28 06:45:00	AAPL	Stock	25.4	25.4125	25.3875	25.4125	13600.0
2014-08-28 06:50:00	AAPL	Stock	25.4275	25.4275	25.4275	25.4275	2556.0
2014-08-28 06:55:00	AAPL	Stock	25.4225	25.4225	25.415	25.415	800.0
2014-08-28 07:00:00	AAPL	Stock	25.41	25.4325	25.41	25.425	11200.0
2014-08-28 07:05:00	AAPL	Stock	25.4275	25.445	25.4275	25.445	22372.0
2014-08-28 07:10:00	AAPL	Stock	25.4325	25.4375	25.4325	25.4375	12400.0
2014-08-28 07:15:00	AAPL	Stock	25.4375	25.4725	25.4375	25.4725	54040.0
2014-08-28 07:20:00	AAPL	Stock	25.4675	25.4675	25.4525	25.455	12360.0
2014-08-28 07:25:00	AAPL	Stock	25.45	25.45	25.45	25.45	3600.0
2014-08-28 07:30:00	AAPL	Stock	25.45	25.45	25.4475	25.4475	800.0
2014-08-28 07:35:00	AAPL	Stock	25.45	25.45	25.45	25.45	2000.0
2014-08-28 07:40:00	AAPL	Stock	25.4475	25.45	25.4475	25.4475	16016.0
2014-08-28 07:45:00	AAPL	Stock	25.45	25.4525	25.445	25.445	7004.0
2014-08-28 07:50:00	AAPL	Stock	25.445	25.445	25.4425	25.4425	2396.0
2014-08-28 07:55:00	AAPL	Stock	25.445	25.4525	25.4375	25.4375	17600.0
2014-08-28 08:00:00	AAPL	Stock	25.4375	25.5325	25.4075	25.4375	152848.0
2014-08-28 08:05:00	AAPL	Stock	25.43	25.4375	25.425	25.425	22948.0
2014-08-28 08:10:00	AAPL	Stock	25.425	25.425	25.4	25.4	117776.0
2014-08-28 08:15:00	AAPL	Stock	25.4	25.4125	25.375	25.4	143576.0
2014-08-28 08:20:00	AAPL	Stock	25.4	25.4125	25.39	25.4	160440.0
2014-08-28 08:25:00	AAPL	Stock	25.4	25.415	25.4	25.4125	18840.0
2014-08-28 08:30:00	AAPL	Stock	25.42	25.435	25.42	25.43	32000.0
2014-08-28 08:35:00	AAPL	Stock	25.425	25.425	25.4125	25.4125	21600.0
2014-08-28 08:40:00	AAPL	Stock	25.4125	25.4163	25.4075	25.4163	30788.0
2014-08-28 08:45:00	AAPL	Stock	25.4225	25.4225	25.41	25.4225	30560.0
2014-08-28 08:50:00	AAPL	Stock	25.425	25.435	25.42	25.4325	32200.0
2014-08-28 08:55:00	AAPL	Stock	25.4275	25.4325	25.415	25.425	70732.0
2014-08-28 09:00:00	AAPL	Stock	25.4225	25.5325	25.42	25.425	5444540.0
2014-08-28 09:05:00	AAPL	Stock	25.43	25.43	25.3925	25.4025	185588.0
2014-08-28 09:10:00	AAPL	Stock	25.3925	25.4	25.375	25.3775	118988.0
2014-08-28 09:15:00	AAPL	Stock	25.38	25.3875	25.33	25.35	294424.0
2014-08-28 09:20:00	AAPL	Stock	25.35	25.38	25.3375	25.3675	94780.0
2014-08-28 09:25:00	AAPL	Stock	25.3675	25.4	25.355	25.3875	103868.0
2014-08-28 09:30:00	AAPL	Stock	25.3975	25.49	25.39	25.4625	7769316.0
2014-08-28 09:35:00	AAPL	Stock	25.46	25.58	25.455	25.58	6716912.0
2014-08-28 09:40:00	AAPL	Stock	25.58	25.6125	25.5375	25.5825	7226328.0
2014-08-28 09:45:00	AAPL	Stock	25.5825	25.6075	25.5388	25.56	5171948.0

> showing 50 of 346,392 rows — these rows as CSV

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