PREVIEW / stock_5min / 2018-07-09

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-09.parquet
  size:    5.6 MB
  rows:    363,400
  symbols: 2,830

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
2018-07-09 03:55:00	AAPL	Stock	47.225	47.225	47.225	47.225	400.0
2018-07-09 04:15:00	AAPL	Stock	47.25	47.25	47.25	47.25	800.0
2018-07-09 04:55:00	AAPL	Stock	47.25	47.25	47.25	47.25	3108.0
2018-07-09 05:00:00	AAPL	Stock	47.2525	47.2525	47.22	47.22	22872.0
2018-07-09 05:05:00	AAPL	Stock	47.225	47.225	47.225	47.225	400.0
2018-07-09 05:25:00	AAPL	Stock	47.2	47.2	47.2	47.2	1036.0
2018-07-09 05:45:00	AAPL	Stock	47.2125	47.2125	47.2125	47.2125	800.0
2018-07-09 05:50:00	AAPL	Stock	47.2125	47.2125	47.2125	47.2125	6456.0
2018-07-09 06:55:00	AAPL	Stock	47.2175	47.245	47.2175	47.225	2192.0
2018-07-09 07:00:00	AAPL	Stock	47.2475	47.2675	47.2475	47.2525	40560.0
2018-07-09 07:05:00	AAPL	Stock	47.26	47.275	47.25	47.275	12160.0
2018-07-09 07:10:00	AAPL	Stock	47.26	47.2725	47.2575	47.2675	7680.0
2018-07-09 07:15:00	AAPL	Stock	47.275	47.285	47.2675	47.27	4488.0
2018-07-09 07:20:00	AAPL	Stock	47.2825	47.2825	47.2375	47.24	33200.0
2018-07-09 07:25:00	AAPL	Stock	47.245	47.245	47.2375	47.2375	8512.0
2018-07-09 07:30:00	AAPL	Stock	47.225	47.2375	47.225	47.225	9560.0
2018-07-09 07:35:00	AAPL	Stock	47.215	47.25	47.215	47.25	5652.0
2018-07-09 07:40:00	AAPL	Stock	47.25	47.275	47.25	47.275	8512.0
2018-07-09 07:45:00	AAPL	Stock	47.2525	47.285	47.2525	47.28	5700.0
2018-07-09 07:55:00	AAPL	Stock	47.275	47.2875	47.265	47.2875	15468.0
2018-07-09 08:00:00	AAPL	Stock	47.2625	47.375	47.225	47.3725	180912.0
2018-07-09 08:05:00	AAPL	Stock	47.3625	47.4	47.35	47.385	39296.0
2018-07-09 08:10:00	AAPL	Stock	47.385	47.3975	47.3525	47.355	50752.0
2018-07-09 08:15:00	AAPL	Stock	47.37	47.37	47.3475	47.3475	43560.0
2018-07-09 08:20:00	AAPL	Stock	47.34	47.3875	47.34	47.3675	24028.0
2018-07-09 08:25:00	AAPL	Stock	47.395	47.425	47.395	47.4225	49644.0
2018-07-09 08:30:00	AAPL	Stock	47.4025	47.4375	47.39	47.4175	49128.0
2018-07-09 08:35:00	AAPL	Stock	47.4125	47.4125	47.41	47.4125	3000.0
2018-07-09 08:40:00	AAPL	Stock	47.425	47.425	47.4	47.4	8812.0
2018-07-09 08:45:00	AAPL	Stock	47.395	47.405	47.385	47.385	30988.0
2018-07-09 08:50:00	AAPL	Stock	47.375	47.375	47.3525	47.355	47040.0
2018-07-09 08:55:00	AAPL	Stock	47.35	47.37	47.34	47.34	11564.0
2018-07-09 09:00:00	AAPL	Stock	47.34	47.3625	47.3375	47.3625	8652.0
2018-07-09 09:05:00	AAPL	Stock	47.3625	47.3625	47.3375	47.3375	33428.0
2018-07-09 09:10:00	AAPL	Stock	47.3625	47.3625	47.3325	47.3325	3104.0
2018-07-09 09:15:00	AAPL	Stock	47.345	47.37	47.345	47.37	7288.0
2018-07-09 09:20:00	AAPL	Stock	47.365	47.3675	47.3625	47.3625	4832.0
2018-07-09 09:25:00	AAPL	Stock	47.3525	47.39	47.3375	47.3575	36900.0
2018-07-09 09:30:00	AAPL	Stock	47.375	47.52	47.325	47.4845	4404236.0
2018-07-09 09:35:00	AAPL	Stock	47.485	47.6025	47.45	47.545	2572788.0
2018-07-09 09:40:00	AAPL	Stock	47.5448	47.67	47.5425	47.6325	2346408.0
2018-07-09 09:45:00	AAPL	Stock	47.635	47.6488	47.6025	47.6425	1810132.0
2018-07-09 09:50:00	AAPL	Stock	47.6448	47.6475	47.5075	47.5078	1881200.0
2018-07-09 09:55:00	AAPL	Stock	47.51	47.58	47.51	47.5525	1328352.0
2018-07-09 10:00:00	AAPL	Stock	47.555	47.595	47.525	47.545	1176776.0
2018-07-09 10:05:00	AAPL	Stock	47.545	47.605	47.4925	47.5018	1248300.0
2018-07-09 10:10:00	AAPL	Stock	47.5	47.525	47.3825	47.3925	1412916.0
2018-07-09 10:15:00	AAPL	Stock	47.395	47.4175	47.36	47.4038	1042860.0
2018-07-09 10:20:00	AAPL	Stock	47.4	47.46	47.3825	47.445	1220416.0
2018-07-09 10:25:00	AAPL	Stock	47.4425	47.485	47.4075	47.4275	1343748.0

> showing 50 of 363,400 rows — these rows as CSV

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