PREVIEW / stock_1min / 2018-04-05

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-04-05.parquet
  size:    15.2 MB
  rows:    1,089,173
  symbols: 2,365

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-05 04:00:00	AAPL	Stock	43.2525	43.2525	43.2525	43.2525	1928.0
2018-04-05 04:03:00	AAPL	Stock	43.2525	43.2525	43.2525	43.2525	600.0
2018-04-05 04:09:00	AAPL	Stock	43.1575	43.1575	43.1575	43.1575	2000.0
2018-04-05 04:10:00	AAPL	Stock	43.1575	43.1575	43.1575	43.1575	1400.0
2018-04-05 04:11:00	AAPL	Stock	43.175	43.175	43.1575	43.1575	4000.0
2018-04-05 04:14:00	AAPL	Stock	43.2	43.2	43.2	43.2	9600.0
2018-04-05 04:20:00	AAPL	Stock	43.2	43.2	43.2	43.2	1808.0
2018-04-05 04:21:00	AAPL	Stock	43.1375	43.1375	43.1375	43.1375	2000.0
2018-04-05 04:47:00	AAPL	Stock	43.13	43.13	43.13	43.13	800.0
2018-04-05 05:30:00	AAPL	Stock	43.145	43.1475	43.145	43.1475	8456.0
2018-04-05 05:31:00	AAPL	Stock	43.15	43.15	43.15	43.15	800.0
2018-04-05 05:32:00	AAPL	Stock	43.1475	43.1475	43.1475	43.1475	6000.0
2018-04-05 05:33:00	AAPL	Stock	43.1475	43.1475	43.1475	43.1475	1544.0
2018-04-05 05:51:00	AAPL	Stock	43.125	43.125	43.125	43.125	2000.0
2018-04-05 05:53:00	AAPL	Stock	43.11	43.11	43.11	43.11	400.0
2018-04-05 05:54:00	AAPL	Stock	43.125	43.125	43.125	43.125	1012.0
2018-04-05 05:55:00	AAPL	Stock	43.125	43.125	43.125	43.125	1600.0
2018-04-05 05:56:00	AAPL	Stock	43.15	43.15	43.15	43.15	6612.0
2018-04-05 06:03:00	AAPL	Stock	43.1475	43.1475	43.1475	43.1475	3940.0
2018-04-05 06:07:00	AAPL	Stock	43.1225	43.1225	43.1	43.1	2268.0
2018-04-05 06:09:00	AAPL	Stock	43.1	43.1	43.1	43.1	1868.0
2018-04-05 06:12:00	AAPL	Stock	43.1225	43.1225	43.1225	43.1225	2868.0
2018-04-05 06:17:00	AAPL	Stock	43.1475	43.1475	43.1475	43.1475	1200.0
2018-04-05 06:18:00	AAPL	Stock	43.1475	43.1475	43.1475	43.1475	2796.0
2018-04-05 06:20:00	AAPL	Stock	43.15	43.15	43.15	43.15	4000.0
2018-04-05 06:49:00	AAPL	Stock	43.1375	43.1375	43.125	43.125	3412.0
2018-04-05 06:51:00	AAPL	Stock	43.15	43.15	43.15	43.15	400.0
2018-04-05 06:56:00	AAPL	Stock	43.15	43.15	43.15	43.15	400.0
2018-04-05 07:00:00	AAPL	Stock	43.1225	43.1625	43.1225	43.125	16368.0
2018-04-05 07:01:00	AAPL	Stock	43.16	43.16	43.16	43.16	4000.0
2018-04-05 07:02:00	AAPL	Stock	43.1375	43.1625	43.125	43.1625	7576.0
2018-04-05 07:03:00	AAPL	Stock	43.1375	43.1625	43.1375	43.1625	3176.0
2018-04-05 07:04:00	AAPL	Stock	43.175	43.175	43.175	43.175	2000.0
2018-04-05 07:05:00	AAPL	Stock	43.185	43.185	43.185	43.185	4000.0
2018-04-05 07:06:00	AAPL	Stock	43.1875	43.1875	43.1875	43.1875	800.0
2018-04-05 07:07:00	AAPL	Stock	43.1975	43.1975	43.1875	43.1975	3992.0
2018-04-05 07:08:00	AAPL	Stock	43.1975	43.2125	43.1975	43.21	5620.0
2018-04-05 07:09:00	AAPL	Stock	43.1875	43.1875	43.1875	43.1875	400.0
2018-04-05 07:17:00	AAPL	Stock	43.1975	43.2	43.1975	43.2	3480.0
2018-04-05 07:18:00	AAPL	Stock	43.2	43.21	43.2	43.21	3580.0
2018-04-05 07:19:00	AAPL	Stock	43.22	43.2375	43.22	43.2375	4868.0
2018-04-05 07:20:00	AAPL	Stock	43.2375	43.245	43.2225	43.245	5008.0
2018-04-05 07:22:00	AAPL	Stock	43.25	43.25	43.225	43.225	38920.0
2018-04-05 07:23:00	AAPL	Stock	43.225	43.25	43.225	43.25	5632.0
2018-04-05 07:24:00	AAPL	Stock	43.2475	43.25	43.2475	43.25	1604.0
2018-04-05 07:26:00	AAPL	Stock	43.2625	43.2625	43.255	43.255	2800.0
2018-04-05 07:27:00	AAPL	Stock	43.2675	43.275	43.2675	43.275	5140.0
2018-04-05 07:28:00	AAPL	Stock	43.255	43.275	43.255	43.275	3040.0
2018-04-05 07:29:00	AAPL	Stock	43.295	43.295	43.295	43.295	400.0
2018-04-05 07:31:00	AAPL	Stock	43.2975	43.3	43.275	43.275	13648.0

> showing 50 of 1,089,173 rows — these rows as CSV

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