PREVIEW / stock_5min / 2018-07-17

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-17.parquet
  size:    5.5 MB
  rows:    350,062
  symbols: 2,822

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-17 04:00:00	AAPL	Stock	47.475	47.475	47.475	47.475	400.0
2018-07-17 04:55:00	AAPL	Stock	47.5	47.5	47.5	47.5	416.0
2018-07-17 06:00:00	AAPL	Stock	47.5	47.5	47.5	47.5	400.0
2018-07-17 06:05:00	AAPL	Stock	47.5	47.5	47.5	47.5	400.0
2018-07-17 06:10:00	AAPL	Stock	47.5	47.5	47.5	47.5	2552.0
2018-07-17 06:20:00	AAPL	Stock	47.4725	47.4725	47.4725	47.4725	800.0
2018-07-17 06:25:00	AAPL	Stock	47.45	47.455	47.45	47.45	20128.0
2018-07-17 06:30:00	AAPL	Stock	47.45	47.45	47.45	47.45	1200.0
2018-07-17 06:40:00	AAPL	Stock	47.44	47.44	47.4375	47.4375	800.0
2018-07-17 06:50:00	AAPL	Stock	47.43	47.43	47.4	47.4	19228.0
2018-07-17 07:00:00	AAPL	Stock	47.425	47.45	47.425	47.4475	9784.0
2018-07-17 07:05:00	AAPL	Stock	47.4375	47.4375	47.4325	47.4325	2000.0
2018-07-17 07:15:00	AAPL	Stock	47.435	47.4475	47.4325	47.44	7672.0
2018-07-17 07:25:00	AAPL	Stock	47.44	47.45	47.44	47.45	20452.0
2018-07-17 07:30:00	AAPL	Stock	47.475	47.48	47.475	47.475	9200.0
2018-07-17 07:40:00	AAPL	Stock	47.4625	47.5	47.4625	47.4875	10752.0
2018-07-17 07:45:00	AAPL	Stock	47.4875	47.5425	47.4875	47.53	8492.0
2018-07-17 07:55:00	AAPL	Stock	47.5425	47.595	47.5425	47.5875	26212.0
2018-07-17 08:00:00	AAPL	Stock	47.595	47.595	47.425	47.5675	37312.0
2018-07-17 08:05:00	AAPL	Stock	47.5925	47.5925	47.575	47.575	11416.0
2018-07-17 08:10:00	AAPL	Stock	47.575	47.59	47.5625	47.5625	4228.0
2018-07-17 08:15:00	AAPL	Stock	47.5675	47.5875	47.55	47.55	40044.0
2018-07-17 08:20:00	AAPL	Stock	47.5275	47.5275	47.51	47.525	20420.0
2018-07-17 08:25:00	AAPL	Stock	47.5275	47.5275	47.505	47.525	7668.0
2018-07-17 08:30:00	AAPL	Stock	47.525	47.5275	47.5075	47.5075	6608.0
2018-07-17 08:35:00	AAPL	Stock	47.5225	47.5225	47.5	47.5	10000.0
2018-07-17 08:40:00	AAPL	Stock	47.5	47.51	47.5	47.5025	2000.0
2018-07-17 08:45:00	AAPL	Stock	47.5075	47.5125	47.4875	47.4875	4140.0
2018-07-17 08:50:00	AAPL	Stock	47.485	47.4875	47.48	47.4875	4496.0
2018-07-17 08:55:00	AAPL	Stock	47.49	47.5	47.4675	47.4775	10860.0
2018-07-17 09:00:00	AAPL	Stock	47.4625	47.4625	47.4275	47.4275	6960.0
2018-07-17 09:05:00	AAPL	Stock	47.43	47.4425	47.425	47.4375	24348.0
2018-07-17 09:10:00	AAPL	Stock	47.41	47.465	47.4025	47.4625	31176.0
2018-07-17 09:15:00	AAPL	Stock	47.7275	47.7275	47.425	47.425	52240.0
2018-07-17 09:20:00	AAPL	Stock	47.4275	47.455	47.4025	47.4375	21176.0
2018-07-17 09:25:00	AAPL	Stock	47.4375	47.485	47.4225	47.435	43720.0
2018-07-17 09:30:00	AAPL	Stock	47.4375	47.56	47.4025	47.4575	2269056.0
2018-07-17 09:35:00	AAPL	Stock	47.46	47.5025	47.3	47.3588	1794576.0
2018-07-17 09:40:00	AAPL	Stock	47.36	47.4575	47.3425	47.4325	1295124.0
2018-07-17 09:45:00	AAPL	Stock	47.4325	47.475	47.375	47.4675	964320.0
2018-07-17 09:50:00	AAPL	Stock	47.4675	47.5	47.4475	47.47	860016.0
2018-07-17 09:55:00	AAPL	Stock	47.4688	47.525	47.445	47.4675	682204.0
2018-07-17 10:00:00	AAPL	Stock	47.4725	47.525	47.4125	47.445	769168.0
2018-07-17 10:05:00	AAPL	Stock	47.445	47.4875	47.4058	47.4825	725832.0
2018-07-17 10:10:00	AAPL	Stock	47.485	47.495	47.435	47.4938	565016.0
2018-07-17 10:15:00	AAPL	Stock	47.495	47.57	47.4825	47.555	913120.0
2018-07-17 10:20:00	AAPL	Stock	47.555	47.59	47.5528	47.5675	521340.0
2018-07-17 10:25:00	AAPL	Stock	47.57	47.625	47.5625	47.615	427448.0
2018-07-17 10:30:00	AAPL	Stock	47.6175	47.655	47.585	47.585	614684.0
2018-07-17 10:35:00	AAPL	Stock	47.585	47.5975	47.5575	47.5625	396212.0

> showing 50 of 350,062 rows — these rows as CSV

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