PREVIEW / stock_1min / 2018-06-28

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-06-28.parquet
  size:    15.8 MB
  rows:    1,125,606
  symbols: 2,366

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-06-28 04:41:00	AAPL	Stock	46.1925	46.1925	46.1925	46.1925	1800.0
2018-06-28 04:46:00	AAPL	Stock	46.18	46.18	46.1675	46.1675	12800.0
2018-06-28 05:33:00	AAPL	Stock	46.1875	46.1875	46.1875	46.1875	2596.0
2018-06-28 05:34:00	AAPL	Stock	46.175	46.175	46.175	46.175	1380.0
2018-06-28 05:35:00	AAPL	Stock	46.175	46.175	46.175	46.175	1200.0
2018-06-28 05:36:00	AAPL	Stock	46.15	46.15	46.15	46.15	400.0
2018-06-28 05:37:00	AAPL	Stock	46.15	46.15	46.15	46.15	2892.0
2018-06-28 05:58:00	AAPL	Stock	46.15	46.15	46.15	46.15	400.0
2018-06-28 06:05:00	AAPL	Stock	46.15	46.15	46.15	46.15	1200.0
2018-06-28 06:09:00	AAPL	Stock	46.15	46.15	46.15	46.15	412.0
2018-06-28 06:25:00	AAPL	Stock	46.1875	46.1875	46.1875	46.1875	1200.0
2018-06-28 06:26:00	AAPL	Stock	46.1875	46.1875	46.1875	46.1875	992.0
2018-06-28 06:42:00	AAPL	Stock	46.2475	46.2475	46.2475	46.2475	744.0
2018-06-28 06:43:00	AAPL	Stock	46.2475	46.2475	46.2475	46.2475	1164.0
2018-06-28 07:00:00	AAPL	Stock	46.2175	46.23	46.2125	46.2125	24612.0
2018-06-28 07:01:00	AAPL	Stock	46.2125	46.2125	46.2125	46.2125	7964.0
2018-06-28 07:02:00	AAPL	Stock	46.2125	46.2125	46.2125	46.2125	18696.0
2018-06-28 07:04:00	AAPL	Stock	46.2075	46.2075	46.2075	46.2075	1332.0
2018-06-28 07:07:00	AAPL	Stock	46.2125	46.2125	46.2125	46.2125	400.0
2018-06-28 07:08:00	AAPL	Stock	46.1975	46.1975	46.1925	46.195	2240.0
2018-06-28 07:09:00	AAPL	Stock	46.1875	46.2	46.175	46.175	15108.0
2018-06-28 07:10:00	AAPL	Stock	46.17	46.17	46.1625	46.1625	3840.0
2018-06-28 07:11:00	AAPL	Stock	46.195	46.2	46.195	46.2	1600.0
2018-06-28 07:12:00	AAPL	Stock	46.21	46.235	46.21	46.235	1888.0
2018-06-28 07:13:00	AAPL	Stock	46.2425	46.2425	46.2425	46.2425	17092.0
2018-06-28 07:18:00	AAPL	Stock	46.2325	46.2325	46.23	46.23	5200.0
2018-06-28 07:19:00	AAPL	Stock	46.23	46.23	46.2225	46.2225	1980.0
2018-06-28 07:23:00	AAPL	Stock	46.2225	46.2225	46.2225	46.2225	1828.0
2018-06-28 07:24:00	AAPL	Stock	46.225	46.225	46.225	46.225	1600.0
2018-06-28 07:29:00	AAPL	Stock	46.2175	46.2175	46.175	46.175	21892.0
2018-06-28 07:32:00	AAPL	Stock	46.2	46.2	46.2	46.2	2752.0
2018-06-28 07:33:00	AAPL	Stock	46.2	46.2	46.2	46.2	7112.0
2018-06-28 07:34:00	AAPL	Stock	46.2	46.2	46.2	46.2	5200.0
2018-06-28 07:35:00	AAPL	Stock	46.225	46.24	46.225	46.24	1856.0
2018-06-28 07:43:00	AAPL	Stock	46.18	46.18	46.18	46.18	600.0
2018-06-28 07:46:00	AAPL	Stock	46.1625	46.1625	46.1625	46.1625	400.0
2018-06-28 07:47:00	AAPL	Stock	46.16	46.16	46.1375	46.1375	1200.0
2018-06-28 07:50:00	AAPL	Stock	46.1525	46.1525	46.1525	46.1525	400.0
2018-06-28 07:52:00	AAPL	Stock	46.17	46.175	46.17	46.175	1200.0
2018-06-28 07:55:00	AAPL	Stock	46.1575	46.1575	46.1575	46.1575	400.0
2018-06-28 07:56:00	AAPL	Stock	46.1525	46.1525	46.1525	46.1525	400.0
2018-06-28 07:58:00	AAPL	Stock	46.17	46.17	46.17	46.17	1200.0
2018-06-28 08:00:00	AAPL	Stock	46.22	46.2445	46.1625	46.1875	29152.0
2018-06-28 08:01:00	AAPL	Stock	46.195	46.2	46.1875	46.2	20400.0
2018-06-28 08:02:00	AAPL	Stock	46.175	46.175	46.175	46.175	1236.0
2018-06-28 08:04:00	AAPL	Stock	46.1625	46.1625	46.13	46.13	2912.0
2018-06-28 08:05:00	AAPL	Stock	46.1325	46.1325	46.1125	46.1125	7580.0
2018-06-28 08:06:00	AAPL	Stock	46.1125	46.1125	46.075	46.075	7360.0
2018-06-28 08:07:00	AAPL	Stock	46.11	46.11	46.11	46.11	880.0
2018-06-28 08:08:00	AAPL	Stock	46.11	46.11	46.11	46.11	400.0

> showing 50 of 1,125,606 rows — these rows as CSV

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