PREVIEW / stock_1min / 2018-04-20

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-04-20.parquet
  size:    14.1 MB
  rows:    1,029,100
  symbols: 2,372

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-20 04:00:00	AAPL	Stock	43.075	43.075	43.075	43.075	4000.0
2018-04-20 04:02:00	AAPL	Stock	43.0	43.0	43.0	43.0	1680.0
2018-04-20 04:08:00	AAPL	Stock	43.0725	43.0725	43.0725	43.0725	1920.0
2018-04-20 04:13:00	AAPL	Stock	43.0625	43.0625	43.055	43.055	4760.0
2018-04-20 04:20:00	AAPL	Stock	43.0025	43.0025	43.0	43.0	4188.0
2018-04-20 04:36:00	AAPL	Stock	43.0	43.0	43.0	43.0	1200.0
2018-04-20 04:53:00	AAPL	Stock	43.0025	43.0025	43.0025	43.0025	400.0
2018-04-20 05:25:00	AAPL	Stock	43.05	43.0725	43.05	43.0725	2872.0
2018-04-20 05:36:00	AAPL	Stock	43.075	43.075	43.075	43.075	1600.0
2018-04-20 05:38:00	AAPL	Stock	43.075	43.075	43.075	43.075	1248.0
2018-04-20 05:41:00	AAPL	Stock	43.07	43.07	43.07	43.07	2000.0
2018-04-20 05:44:00	AAPL	Stock	43.065	43.065	43.065	43.065	400.0
2018-04-20 05:46:00	AAPL	Stock	43.065	43.065	43.065	43.065	1208.0
2018-04-20 05:49:00	AAPL	Stock	43.035	43.035	43.035	43.035	800.0
2018-04-20 05:53:00	AAPL	Stock	43.0575	43.0575	43.0125	43.0125	4800.0
2018-04-20 05:54:00	AAPL	Stock	43.0575	43.0575	43.005	43.005	800.0
2018-04-20 05:55:00	AAPL	Stock	43.0225	43.0475	43.005	43.005	4744.0
2018-04-20 05:59:00	AAPL	Stock	43.005	43.005	43.0	43.0	6512.0
2018-04-20 06:06:00	AAPL	Stock	42.9375	42.955	42.9375	42.955	12400.0
2018-04-20 06:07:00	AAPL	Stock	42.9625	42.9625	42.96	42.96	6000.0
2018-04-20 06:08:00	AAPL	Stock	42.96	42.96	42.96	42.96	2488.0
2018-04-20 06:19:00	AAPL	Stock	43.0	43.0	43.0	43.0	1684.0
2018-04-20 06:33:00	AAPL	Stock	42.96	42.96	42.96	42.96	2604.0
2018-04-20 06:35:00	AAPL	Stock	42.95	42.95	42.95	42.95	800.0
2018-04-20 06:38:00	AAPL	Stock	42.8875	42.9125	42.8875	42.9125	6556.0
2018-04-20 06:39:00	AAPL	Stock	42.95	42.96	42.95	42.96	4400.0
2018-04-20 06:40:00	AAPL	Stock	42.95	42.95	42.95	42.95	2000.0
2018-04-20 06:41:00	AAPL	Stock	42.95	42.95	42.95	42.95	4800.0
2018-04-20 06:45:00	AAPL	Stock	42.9825	42.9825	42.9825	42.9825	560.0
2018-04-20 06:46:00	AAPL	Stock	43.0	43.0	43.0	43.0	2000.0
2018-04-20 06:50:00	AAPL	Stock	42.9825	42.9825	42.9825	42.9825	412.0
2018-04-20 06:53:00	AAPL	Stock	43.0	43.0	43.0	43.0	9964.0
2018-04-20 06:56:00	AAPL	Stock	43.005	43.005	43.005	43.005	800.0
2018-04-20 06:57:00	AAPL	Stock	43.0325	43.0325	43.0325	43.0325	400.0
2018-04-20 07:00:00	AAPL	Stock	43.03	43.0925	43.015	43.0875	12136.0
2018-04-20 07:02:00	AAPL	Stock	43.0875	43.0875	43.0625	43.0625	1200.0
2018-04-20 07:03:00	AAPL	Stock	43.0975	43.1	43.0975	43.1	8400.0
2018-04-20 07:04:00	AAPL	Stock	43.105	43.105	43.1025	43.1025	2400.0
2018-04-20 07:05:00	AAPL	Stock	43.1025	43.1025	43.1	43.1	7100.0
2018-04-20 07:06:00	AAPL	Stock	43.1	43.1125	43.1	43.1125	4468.0
2018-04-20 07:07:00	AAPL	Stock	43.105	43.105	43.105	43.105	2000.0
2018-04-20 07:09:00	AAPL	Stock	43.075	43.1	43.075	43.1	800.0
2018-04-20 07:10:00	AAPL	Stock	43.125	43.125	43.125	43.125	1200.0
2018-04-20 07:13:00	AAPL	Stock	43.1275	43.1275	43.1275	43.1275	1200.0
2018-04-20 07:15:00	AAPL	Stock	43.1125	43.1125	43.075	43.075	8580.0
2018-04-20 07:16:00	AAPL	Stock	43.1075	43.1075	43.0625	43.0625	8400.0
2018-04-20 07:19:00	AAPL	Stock	43.075	43.075	43.075	43.075	400.0
2018-04-20 07:20:00	AAPL	Stock	43.075	43.075	43.0625	43.0625	6832.0
2018-04-20 07:21:00	AAPL	Stock	43.0625	43.0625	43.05	43.05	2400.0
2018-04-20 07:23:00	AAPL	Stock	43.05	43.05	43.05	43.05	3304.0

> showing 50 of 1,029,100 rows — these rows as CSV

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