PREVIEW / stock_5min / 2018-04-27

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-04-27.parquet
  size:    5.3 MB
  rows:    345,454
  symbols: 2,848

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-04-27 05:00:00	AAPL	Stock	41.2	41.2	41.2	41.2	400.0
2018-04-27 05:10:00	AAPL	Stock	41.2	41.2	41.175	41.175	1200.0
2018-04-27 05:15:00	AAPL	Stock	41.2025	41.2025	41.2	41.2	7972.0
2018-04-27 05:25:00	AAPL	Stock	41.2025	41.2025	41.2025	41.2025	4072.0
2018-04-27 05:50:00	AAPL	Stock	41.205	41.205	41.205	41.205	400.0
2018-04-27 06:05:00	AAPL	Stock	41.2	41.2	41.2	41.2	400.0
2018-04-27 06:25:00	AAPL	Stock	41.2275	41.2275	41.2275	41.2275	400.0
2018-04-27 06:30:00	AAPL	Stock	41.2425	41.2425	41.2425	41.2425	800.0
2018-04-27 06:40:00	AAPL	Stock	41.225	41.225	41.225	41.225	1596.0
2018-04-27 06:45:00	AAPL	Stock	41.225	41.225	41.225	41.225	800.0
2018-04-27 06:55:00	AAPL	Stock	41.2225	41.225	41.2225	41.225	1632.0
2018-04-27 07:00:00	AAPL	Stock	41.225	41.225	41.2225	41.225	3632.0
2018-04-27 07:05:00	AAPL	Stock	41.205	41.205	41.18	41.195	11328.0
2018-04-27 07:10:00	AAPL	Stock	41.2175	41.225	41.2175	41.225	1000.0
2018-04-27 07:15:00	AAPL	Stock	41.2125	41.2225	41.1825	41.1825	7660.0
2018-04-27 07:20:00	AAPL	Stock	41.1925	41.1925	41.1875	41.1875	4096.0
2018-04-27 07:25:00	AAPL	Stock	41.19	41.2	41.18	41.1975	10308.0
2018-04-27 07:30:00	AAPL	Stock	41.1975	41.1975	41.1975	41.1975	2000.0
2018-04-27 07:40:00	AAPL	Stock	41.2125	41.2125	41.175	41.1825	6800.0
2018-04-27 07:45:00	AAPL	Stock	41.1825	41.1825	41.175	41.175	2576.0
2018-04-27 07:50:00	AAPL	Stock	41.195	41.195	41.195	41.195	400.0
2018-04-27 07:55:00	AAPL	Stock	41.205	41.2175	41.205	41.2175	6400.0
2018-04-27 08:00:00	AAPL	Stock	41.205	41.245	41.1775	41.23	37976.0
2018-04-27 08:05:00	AAPL	Stock	41.24	41.29	41.24	41.275	22604.0
2018-04-27 08:10:00	AAPL	Stock	41.275	41.275	41.2425	41.27	6200.0
2018-04-27 08:15:00	AAPL	Stock	41.265	41.2675	41.255	41.255	6860.0
2018-04-27 08:20:00	AAPL	Stock	41.2575	41.2625	41.255	41.2625	11388.0
2018-04-27 08:25:00	AAPL	Stock	41.2625	41.2625	41.185	41.2	50592.0
2018-04-27 08:30:00	AAPL	Stock	41.2325	41.245	41.2075	41.215	23160.0
2018-04-27 08:35:00	AAPL	Stock	41.2125	41.225	41.2075	41.2075	27192.0
2018-04-27 08:40:00	AAPL	Stock	41.24	41.245	41.1525	41.1975	41028.0
2018-04-27 08:45:00	AAPL	Stock	41.1925	41.2	41.1875	41.2	17304.0
2018-04-27 08:50:00	AAPL	Stock	41.1875	41.195	41.165	41.195	13460.0
2018-04-27 08:55:00	AAPL	Stock	41.2	41.235	41.1875	41.235	18952.0
2018-04-27 09:00:00	AAPL	Stock	41.2325	41.2375	41.2225	41.2225	10536.0
2018-04-27 09:05:00	AAPL	Stock	41.235	41.235	41.1875	41.1875	31224.0
2018-04-27 09:10:00	AAPL	Stock	41.1875	41.19	41.1525	41.1525	29588.0
2018-04-27 09:15:00	AAPL	Stock	41.16	41.1875	41.16	41.1875	12424.0
2018-04-27 09:20:00	AAPL	Stock	41.195	41.195	41.155	41.1725	7000.0
2018-04-27 09:25:00	AAPL	Stock	41.1625	41.175	40.95	41.0175	165280.0
2018-04-27 09:30:00	AAPL	Stock	41.0	41.0825	40.865	40.8925	5970172.0
2018-04-27 09:35:00	AAPL	Stock	40.8925	40.945	40.7925	40.8548	3816464.0
2018-04-27 09:40:00	AAPL	Stock	40.855	40.855	40.7425	40.79	3354760.0
2018-04-27 09:45:00	AAPL	Stock	40.7912	40.805	40.6925	40.77	4029756.0
2018-04-27 09:50:00	AAPL	Stock	40.7725	40.785	40.5075	40.5575	4014812.0
2018-04-27 09:55:00	AAPL	Stock	40.5575	40.5975	40.485	40.51	3226540.0
2018-04-27 10:00:00	AAPL	Stock	40.505	40.545	40.3625	40.3738	3944632.0
2018-04-27 10:05:00	AAPL	Stock	40.3745	40.4475	40.3175	40.395	3754980.0
2018-04-27 10:10:00	AAPL	Stock	40.395	40.395	40.1775	40.1775	4970440.0
2018-04-27 10:15:00	AAPL	Stock	40.18	40.3575	40.1575	40.3325	3615128.0

> showing 50 of 345,454 rows — these rows as CSV

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