PREVIEW / stock_5min / 2018-07-06

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-06.parquet
  size:    5.4 MB
  rows:    352,860
  symbols: 2,802

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-06 04:00:00	AAPL	Stock	46.2125	46.2125	46.2125	46.2125	1264.0
2018-07-06 04:25:00	AAPL	Stock	46.2375	46.2375	46.2375	46.2375	800.0
2018-07-06 04:30:00	AAPL	Stock	46.15	46.15	46.15	46.15	800.0
2018-07-06 04:40:00	AAPL	Stock	46.25	46.25	46.25	46.25	416.0
2018-07-06 05:00:00	AAPL	Stock	46.325	46.325	46.325	46.325	1136.0
2018-07-06 05:10:00	AAPL	Stock	46.2625	46.2625	46.2625	46.2625	800.0
2018-07-06 06:05:00	AAPL	Stock	46.2875	46.2975	46.2875	46.2975	1956.0
2018-07-06 06:30:00	AAPL	Stock	46.25	46.25	46.25	46.25	532.0
2018-07-06 07:00:00	AAPL	Stock	46.275	46.3175	46.27	46.3175	41956.0
2018-07-06 07:10:00	AAPL	Stock	46.27	46.27	46.27	46.27	680.0
2018-07-06 07:30:00	AAPL	Stock	46.275	46.275	46.275	46.275	776.0
2018-07-06 07:35:00	AAPL	Stock	46.2975	46.3	46.2975	46.3	2800.0
2018-07-06 07:40:00	AAPL	Stock	46.2975	46.3	46.2625	46.2725	6400.0
2018-07-06 07:45:00	AAPL	Stock	46.245	46.245	46.245	46.245	400.0
2018-07-06 07:50:00	AAPL	Stock	46.255	46.2625	46.255	46.2625	800.0
2018-07-06 07:55:00	AAPL	Stock	46.265	46.265	46.2625	46.2625	4492.0
2018-07-06 08:00:00	AAPL	Stock	46.275	46.33	46.25	46.3	16904.0
2018-07-06 08:05:00	AAPL	Stock	46.315	46.315	46.315	46.315	6752.0
2018-07-06 08:10:00	AAPL	Stock	46.3	46.3	46.3	46.3	7608.0
2018-07-06 08:15:00	AAPL	Stock	46.295	46.2975	46.275	46.275	2000.0
2018-07-06 08:20:00	AAPL	Stock	46.2975	46.3	46.295	46.3	11480.0
2018-07-06 08:25:00	AAPL	Stock	46.295	46.3	46.2775	46.2775	3916.0
2018-07-06 08:30:00	AAPL	Stock	46.315	46.5	46.315	46.495	54184.0
2018-07-06 08:35:00	AAPL	Stock	46.49	46.5088	46.4175	46.4175	42832.0
2018-07-06 08:40:00	AAPL	Stock	46.4225	46.4335	46.4	46.4	40196.0
2018-07-06 08:45:00	AAPL	Stock	46.405	46.4175	46.3925	46.4125	19400.0
2018-07-06 08:50:00	AAPL	Stock	46.4	46.4175	46.3875	46.3875	12576.0
2018-07-06 08:55:00	AAPL	Stock	46.39	46.395	46.385	46.385	8400.0
2018-07-06 09:00:00	AAPL	Stock	46.3775	46.39	46.37	46.3825	9316.0
2018-07-06 09:05:00	AAPL	Stock	46.3675	46.3825	46.3575	46.3825	14680.0
2018-07-06 09:10:00	AAPL	Stock	46.395	46.4	46.35	46.35	31472.0
2018-07-06 09:15:00	AAPL	Stock	46.3625	46.3875	46.3625	46.3875	800.0
2018-07-06 09:20:00	AAPL	Stock	46.3875	46.4625	46.3875	46.45	15928.0
2018-07-06 09:25:00	AAPL	Stock	46.45	46.4625	46.3125	46.3825	50592.0
2018-07-06 09:30:00	AAPL	Stock	46.385	46.5275	46.3	46.5188	2030224.0
2018-07-06 09:35:00	AAPL	Stock	46.5188	46.635	46.515	46.6025	1931044.0
2018-07-06 09:40:00	AAPL	Stock	46.605	46.67	46.585	46.6112	1584744.0
2018-07-06 09:45:00	AAPL	Stock	46.61	46.6625	46.5595	46.6375	1412644.0
2018-07-06 09:50:00	AAPL	Stock	46.6375	46.73	46.6188	46.72	1282420.0
2018-07-06 09:55:00	AAPL	Stock	46.72	46.79	46.7025	46.7825	1451144.0
2018-07-06 10:00:00	AAPL	Stock	46.7825	46.805	46.6238	46.6775	1181248.0
2018-07-06 10:05:00	AAPL	Stock	46.6775	46.7022	46.6475	46.6925	534804.0
2018-07-06 10:10:00	AAPL	Stock	46.695	46.75	46.6775	46.69	730624.0
2018-07-06 10:15:00	AAPL	Stock	46.691	46.72	46.64	46.6475	704108.0
2018-07-06 10:20:00	AAPL	Stock	46.645	46.645	46.5722	46.5875	733020.0
2018-07-06 10:25:00	AAPL	Stock	46.5875	46.6287	46.5625	46.5975	725868.0
2018-07-06 10:30:00	AAPL	Stock	46.6	46.6112	46.5175	46.525	858988.0
2018-07-06 10:35:00	AAPL	Stock	46.525	46.6	46.505	46.5575	622452.0
2018-07-06 10:40:00	AAPL	Stock	46.5575	46.6775	46.5575	46.675	845736.0
2018-07-06 10:45:00	AAPL	Stock	46.6725	46.705	46.645	46.685	616948.0

> showing 50 of 352,860 rows — these rows as CSV

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