PREVIEW / stock_5min / 2017-07-17

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-17.parquet
  size:    5.3 MB
  rows:    347,203
  symbols: 3,005

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
2017-07-17 04:00:00	AAPL	Stock	37.3	37.3	37.3	37.3	2400.0
2017-07-17 05:00:00	AAPL	Stock	37.275	37.275	37.275	37.275	4112.0
2017-07-17 05:20:00	AAPL	Stock	37.2625	37.275	37.2625	37.275	1600.0
2017-07-17 05:50:00	AAPL	Stock	37.305	37.31	37.305	37.31	1480.0
2017-07-17 06:05:00	AAPL	Stock	37.325	37.325	37.31	37.31	1080.0
2017-07-17 06:10:00	AAPL	Stock	37.3325	37.3375	37.3325	37.3375	20800.0
2017-07-17 06:25:00	AAPL	Stock	37.385	37.3875	37.375	37.375	2400.0
2017-07-17 07:00:00	AAPL	Stock	37.375	37.375	37.35	37.35	9200.0
2017-07-17 07:05:00	AAPL	Stock	37.3725	37.3725	37.3725	37.3725	1000.0
2017-07-17 07:10:00	AAPL	Stock	37.3575	37.375	37.3575	37.375	10128.0
2017-07-17 07:15:00	AAPL	Stock	37.3775	37.3775	37.3775	37.3775	4800.0
2017-07-17 07:20:00	AAPL	Stock	37.365	37.3825	37.365	37.3825	800.0
2017-07-17 07:25:00	AAPL	Stock	37.365	37.365	37.3375	37.3375	4944.0
2017-07-17 07:30:00	AAPL	Stock	37.35	37.3575	37.35	37.35	10144.0
2017-07-17 07:35:00	AAPL	Stock	37.34	37.345	37.3	37.3	15116.0
2017-07-17 07:40:00	AAPL	Stock	37.3	37.305	37.275	37.3	24368.0
2017-07-17 07:45:00	AAPL	Stock	37.3025	37.305	37.3	37.305	5188.0
2017-07-17 07:50:00	AAPL	Stock	37.305	37.32	37.305	37.3175	12696.0
2017-07-17 07:55:00	AAPL	Stock	37.3175	37.3225	37.3175	37.3225	2528.0
2017-07-17 08:00:00	AAPL	Stock	37.3025	37.4	37.275	37.2925	84468.0
2017-07-17 08:05:00	AAPL	Stock	37.3	37.3175	37.2875	37.305	42800.0
2017-07-17 08:10:00	AAPL	Stock	37.305	37.32	37.3025	37.3025	6876.0
2017-07-17 08:15:00	AAPL	Stock	37.3175	37.3175	37.2875	37.2875	11940.0
2017-07-17 08:20:00	AAPL	Stock	37.295	37.3	37.2875	37.29	8872.0
2017-07-17 08:25:00	AAPL	Stock	37.295	37.3	37.295	37.2975	8400.0
2017-07-17 08:30:00	AAPL	Stock	37.2975	37.3	37.27	37.27	39512.0
2017-07-17 08:35:00	AAPL	Stock	37.2625	37.2625	37.2375	37.25	40752.0
2017-07-17 08:40:00	AAPL	Stock	37.255	37.2925	37.2375	37.2525	26864.0
2017-07-17 08:45:00	AAPL	Stock	37.2625	37.2675	37.2375	37.25	25900.0
2017-07-17 08:50:00	AAPL	Stock	37.2575	37.2575	37.2325	37.25	15132.0
2017-07-17 08:55:00	AAPL	Stock	37.25	37.2575	37.23	37.2575	7600.0
2017-07-17 09:00:00	AAPL	Stock	37.2575	37.2625	37.2475	37.26	16140.0
2017-07-17 09:05:00	AAPL	Stock	37.26	37.26	37.225	37.2575	41484.0
2017-07-17 09:10:00	AAPL	Stock	37.2475	37.25	37.2325	37.25	13936.0
2017-07-17 09:15:00	AAPL	Stock	37.25	37.25	37.225	37.2375	11908.0
2017-07-17 09:20:00	AAPL	Stock	37.2375	37.2375	37.225	37.2275	25576.0
2017-07-17 09:25:00	AAPL	Stock	37.225	37.23	37.2	37.215	73044.0
2017-07-17 09:30:00	AAPL	Stock	37.205	37.27	37.1425	37.2373	3733312.0
2017-07-17 09:35:00	AAPL	Stock	37.235	37.36	37.2275	37.345	2403380.0
2017-07-17 09:40:00	AAPL	Stock	37.35	37.425	37.295	37.425	2373400.0
2017-07-17 09:45:00	AAPL	Stock	37.4225	37.5	37.4225	37.455	2246756.0
2017-07-17 09:50:00	AAPL	Stock	37.4535	37.5612	37.4202	37.48	4195260.0
2017-07-17 09:55:00	AAPL	Stock	37.4812	37.675	37.475	37.653	3890696.0
2017-07-17 10:00:00	AAPL	Stock	37.6552	37.675	37.605	37.655	2337400.0
2017-07-17 10:05:00	AAPL	Stock	37.6575	37.725	37.6325	37.71	2094700.0
2017-07-17 10:10:00	AAPL	Stock	37.71	37.7175	37.65	37.655	2100452.0
2017-07-17 10:15:00	AAPL	Stock	37.6538	37.6675	37.5525	37.605	1855956.0
2017-07-17 10:20:00	AAPL	Stock	37.605	37.64	37.5625	37.625	1358160.0
2017-07-17 10:25:00	AAPL	Stock	37.6257	37.6312	37.5425	37.5625	1266136.0
2017-07-17 10:30:00	AAPL	Stock	37.565	37.588	37.5475	37.5475	948304.0

> showing 50 of 347,203 rows — these rows as CSV

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