PREVIEW / stock_5min / 2018-05-07

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-05-07.parquet
  size:    5.5 MB
  rows:    355,611
  symbols: 2,866

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-05-07 04:00:00	AAPL	Stock	46.115	46.1375	46.0575	46.0625	23228.0
2018-05-07 04:05:00	AAPL	Stock	46.125	46.125	46.125	46.125	1200.0
2018-05-07 04:10:00	AAPL	Stock	46.195	46.1975	46.185	46.185	2560.0
2018-05-07 04:15:00	AAPL	Stock	46.175	46.175	46.1725	46.1725	984.0
2018-05-07 04:35:00	AAPL	Stock	46.1725	46.1725	46.1725	46.1725	800.0
2018-05-07 04:45:00	AAPL	Stock	46.1775	46.1775	46.175	46.175	4776.0
2018-05-07 04:50:00	AAPL	Stock	46.21	46.215	46.21	46.2125	8156.0
2018-05-07 04:55:00	AAPL	Stock	46.185	46.185	46.185	46.185	1200.0
2018-05-07 05:05:00	AAPL	Stock	46.2	46.2	46.2	46.2	564.0
2018-05-07 05:10:00	AAPL	Stock	46.175	46.175	46.175	46.175	1240.0
2018-05-07 05:20:00	AAPL	Stock	46.195	46.1975	46.195	46.1975	1712.0
2018-05-07 05:30:00	AAPL	Stock	46.1625	46.1625	46.1375	46.1375	3200.0
2018-05-07 05:35:00	AAPL	Stock	46.1375	46.2	46.1375	46.2	12820.0
2018-05-07 05:40:00	AAPL	Stock	46.2	46.2225	46.19	46.22	12072.0
2018-05-07 05:45:00	AAPL	Stock	46.2	46.2	46.125	46.125	4992.0
2018-05-07 05:55:00	AAPL	Stock	46.125	46.155	46.125	46.125	8636.0
2018-05-07 06:10:00	AAPL	Stock	46.125	46.2	46.125	46.2	9152.0
2018-05-07 06:30:00	AAPL	Stock	46.16	46.16	46.13	46.15	1200.0
2018-05-07 06:35:00	AAPL	Stock	46.15	46.15	46.15	46.15	5372.0
2018-05-07 06:45:00	AAPL	Stock	46.1525	46.1525	46.1525	46.1525	400.0
2018-05-07 06:50:00	AAPL	Stock	46.1275	46.1275	46.115	46.115	1600.0
2018-05-07 07:00:00	AAPL	Stock	46.1475	46.1875	46.1125	46.1875	81644.0
2018-05-07 07:05:00	AAPL	Stock	46.175	46.2	46.1725	46.1875	84664.0
2018-05-07 07:10:00	AAPL	Stock	46.1775	46.2	46.165	46.1875	109824.0
2018-05-07 07:15:00	AAPL	Stock	46.1875	46.1875	46.1625	46.165	27100.0
2018-05-07 07:20:00	AAPL	Stock	46.165	46.175	46.165	46.175	9684.0
2018-05-07 07:25:00	AAPL	Stock	46.18	46.22	46.18	46.18	30996.0
2018-05-07 07:30:00	AAPL	Stock	46.1875	46.225	46.1875	46.21	60436.0
2018-05-07 07:35:00	AAPL	Stock	46.2	46.2225	46.19	46.19	14552.0
2018-05-07 07:40:00	AAPL	Stock	46.1925	46.1925	46.15	46.1875	89468.0
2018-05-07 07:45:00	AAPL	Stock	46.1675	46.1825	46.15	46.15	26332.0
2018-05-07 07:50:00	AAPL	Stock	46.145	46.15	46.125	46.15	29292.0
2018-05-07 07:55:00	AAPL	Stock	46.15	46.1875	46.1375	46.175	55412.0
2018-05-07 08:00:00	AAPL	Stock	46.1925	46.2225	46.13	46.2125	254768.0
2018-05-07 08:05:00	AAPL	Stock	46.2125	46.2175	46.1925	46.195	53024.0
2018-05-07 08:10:00	AAPL	Stock	46.2	46.31	46.1875	46.31	279452.0
2018-05-07 08:15:00	AAPL	Stock	46.3075	46.375	46.3	46.3	331444.0
2018-05-07 08:20:00	AAPL	Stock	46.3075	46.3175	46.235	46.25	156568.0
2018-05-07 08:25:00	AAPL	Stock	46.25	46.2725	46.2375	46.2375	62656.0
2018-05-07 08:30:00	AAPL	Stock	46.245	46.25	46.215	46.245	79356.0
2018-05-07 08:35:00	AAPL	Stock	46.2375	46.27	46.225	46.2475	33320.0
2018-05-07 08:40:00	AAPL	Stock	46.2575	46.305	46.2575	46.3	27408.0
2018-05-07 08:45:00	AAPL	Stock	46.3075	46.3175	46.23	46.25	98212.0
2018-05-07 08:50:00	AAPL	Stock	46.25	46.3	46.24	46.295	100072.0
2018-05-07 08:55:00	AAPL	Stock	46.3	46.3	46.27	46.27	29420.0
2018-05-07 09:00:00	AAPL	Stock	46.27	46.335	46.265	46.325	115384.0
2018-05-07 09:05:00	AAPL	Stock	46.33	46.37	46.3125	46.3375	200712.0
2018-05-07 09:10:00	AAPL	Stock	46.3375	46.37	46.315	46.3575	161768.0
2018-05-07 09:15:00	AAPL	Stock	46.3575	46.36	46.2875	46.295	184120.0
2018-05-07 09:20:00	AAPL	Stock	46.295	46.325	46.275	46.325	143484.0

> showing 50 of 355,611 rows — these rows as CSV

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