PREVIEW / stock_1min / 2018-10-18

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-10-18.parquet
  size:    16.1 MB
  rows:    1,092,449
  symbols: 2,300

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-10-18 04:00:00	AAPL	Stock	55.15	55.2225	55.15	55.2175	3732.0
2018-10-18 04:01:00	AAPL	Stock	55.2175	55.2175	55.2175	55.2175	2000.0
2018-10-18 04:02:00	AAPL	Stock	55.235	55.2625	55.235	55.2625	2400.0
2018-10-18 04:03:00	AAPL	Stock	55.15	55.15	55.15	55.15	1760.0
2018-10-18 04:04:00	AAPL	Stock	55.15	55.15	55.15	55.15	880.0
2018-10-18 04:08:00	AAPL	Stock	55.1525	55.1525	55.15	55.15	1360.0
2018-10-18 04:11:00	AAPL	Stock	55.055	55.055	55.055	55.055	400.0
2018-10-18 04:17:00	AAPL	Stock	55.1675	55.1675	55.1675	55.1675	400.0
2018-10-18 04:18:00	AAPL	Stock	55.1275	55.165	55.1275	55.165	3748.0
2018-10-18 04:20:00	AAPL	Stock	55.1625	55.1625	55.1625	55.1625	1000.0
2018-10-18 04:28:00	AAPL	Stock	55.1625	55.1625	55.1625	55.1625	2000.0
2018-10-18 04:29:00	AAPL	Stock	55.1625	55.1625	55.1625	55.1625	456.0
2018-10-18 05:00:00	AAPL	Stock	55.1625	55.1625	55.125	55.125	9656.0
2018-10-18 05:01:00	AAPL	Stock	55.175	55.175	55.125	55.125	2256.0
2018-10-18 05:02:00	AAPL	Stock	55.0625	55.0625	55.0625	55.0625	400.0
2018-10-18 05:06:00	AAPL	Stock	55.025	55.025	55.025	55.025	1600.0
2018-10-18 05:15:00	AAPL	Stock	55.0275	55.0275	55.0	55.0	8676.0
2018-10-18 05:16:00	AAPL	Stock	55.0	55.0	55.0	55.0	3600.0
2018-10-18 05:17:00	AAPL	Stock	55.0	55.0	55.0	55.0	2000.0
2018-10-18 05:30:00	AAPL	Stock	55.0	55.0	55.0	55.0	4800.0
2018-10-18 05:31:00	AAPL	Stock	55.0	55.0	55.0	55.0	3200.0
2018-10-18 06:07:00	AAPL	Stock	55.0625	55.0625	55.0	55.0	3872.0
2018-10-18 06:13:00	AAPL	Stock	55.0	55.0	55.0	55.0	800.0
2018-10-18 06:17:00	AAPL	Stock	55.0	55.0	55.0	55.0	400.0
2018-10-18 06:40:00	AAPL	Stock	54.9275	54.93	54.9275	54.9275	3880.0
2018-10-18 06:56:00	AAPL	Stock	54.9375	54.9375	54.9375	54.9375	800.0
2018-10-18 06:59:00	AAPL	Stock	54.925	54.925	54.925	54.925	484.0
2018-10-18 07:00:00	AAPL	Stock	54.99	54.995	54.9375	54.985	16648.0
2018-10-18 07:03:00	AAPL	Stock	54.975	54.975	54.9	54.9375	7660.0
2018-10-18 07:04:00	AAPL	Stock	54.925	54.925	54.925	54.925	800.0
2018-10-18 07:05:00	AAPL	Stock	54.95	54.9625	54.95	54.9575	3340.0
2018-10-18 07:06:00	AAPL	Stock	54.95	54.9575	54.95	54.9575	1880.0
2018-10-18 07:07:00	AAPL	Stock	54.9275	54.9275	54.9	54.9075	7496.0
2018-10-18 07:08:00	AAPL	Stock	54.8825	54.9025	54.86	54.9025	13300.0
2018-10-18 07:09:00	AAPL	Stock	54.8775	54.9025	54.8775	54.9025	3764.0
2018-10-18 07:10:00	AAPL	Stock	54.9075	54.9075	54.9075	54.9075	3932.0
2018-10-18 07:11:00	AAPL	Stock	54.9075	54.9075	54.9075	54.9075	800.0
2018-10-18 07:12:00	AAPL	Stock	54.925	54.925	54.925	54.925	1640.0
2018-10-18 07:13:00	AAPL	Stock	54.925	54.925	54.925	54.925	2060.0
2018-10-18 07:14:00	AAPL	Stock	54.925	54.925	54.905	54.905	1880.0
2018-10-18 07:17:00	AAPL	Stock	54.925	54.925	54.855	54.855	7012.0
2018-10-18 07:19:00	AAPL	Stock	54.8775	54.88	54.875	54.875	5600.0
2018-10-18 07:20:00	AAPL	Stock	54.9	54.9	54.9	54.9	1480.0
2018-10-18 07:21:00	AAPL	Stock	54.865	54.875	54.86	54.875	15112.0
2018-10-18 07:22:00	AAPL	Stock	54.8375	54.8375	54.835	54.835	1800.0
2018-10-18 07:23:00	AAPL	Stock	54.85	54.875	54.8325	54.875	33960.0
2018-10-18 07:24:00	AAPL	Stock	54.845	54.845	54.845	54.845	400.0
2018-10-18 07:25:00	AAPL	Stock	54.845	54.8475	54.83	54.83	13200.0
2018-10-18 07:26:00	AAPL	Stock	54.825	54.8625	54.8	54.8625	4072.0
2018-10-18 07:29:00	AAPL	Stock	54.85	54.85	54.85	54.85	400.0

> showing 50 of 1,092,449 rows — these rows as CSV

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