PREVIEW / stock_1min / 2018-01-31

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-01-31.parquet
  size:    16.5 MB
  rows:    1,128,425
  symbols: 2,421

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-01-31 04:00:00	AAPL	Stock	41.625	41.625	41.45	41.45	32300.0
2018-01-31 04:01:00	AAPL	Stock	41.4925	41.4925	41.47	41.47	1400.0
2018-01-31 04:03:00	AAPL	Stock	41.43	41.43	41.4125	41.4125	17532.0
2018-01-31 04:04:00	AAPL	Stock	41.425	41.4275	41.425	41.4275	4928.0
2018-01-31 04:05:00	AAPL	Stock	41.4825	41.5	41.4825	41.5	19608.0
2018-01-31 04:06:00	AAPL	Stock	41.465	41.4675	41.465	41.465	12900.0
2018-01-31 04:07:00	AAPL	Stock	41.495	41.4975	41.465	41.465	6892.0
2018-01-31 04:08:00	AAPL	Stock	41.4875	41.4975	41.4875	41.4975	4000.0
2018-01-31 04:18:00	AAPL	Stock	41.495	41.495	41.495	41.495	800.0
2018-01-31 04:20:00	AAPL	Stock	41.475	41.475	41.47	41.47	1200.0
2018-01-31 04:21:00	AAPL	Stock	41.465	41.465	41.46	41.46	3168.0
2018-01-31 04:22:00	AAPL	Stock	41.45	41.4725	41.45	41.4725	1200.0
2018-01-31 04:24:00	AAPL	Stock	41.44	41.44	41.44	41.44	1056.0
2018-01-31 04:25:00	AAPL	Stock	41.4575	41.4575	41.4575	41.4575	612.0
2018-01-31 04:30:00	AAPL	Stock	41.4425	41.4425	41.4375	41.4375	4876.0
2018-01-31 04:31:00	AAPL	Stock	41.4325	41.4325	41.4325	41.4325	400.0
2018-01-31 04:32:00	AAPL	Stock	41.4	41.4	41.3875	41.3875	1200.0
2018-01-31 04:36:00	AAPL	Stock	41.3875	41.3875	41.3875	41.3875	400.0
2018-01-31 04:40:00	AAPL	Stock	41.4125	41.4125	41.4125	41.4125	2000.0
2018-01-31 04:47:00	AAPL	Stock	41.4275	41.4275	41.4275	41.4275	600.0
2018-01-31 05:01:00	AAPL	Stock	41.415	41.415	41.415	41.415	716.0
2018-01-31 05:05:00	AAPL	Stock	41.435	41.4375	41.435	41.4375	2400.0
2018-01-31 05:06:00	AAPL	Stock	41.4475	41.4625	41.4475	41.4625	10000.0
2018-01-31 05:18:00	AAPL	Stock	41.46	41.4675	41.46	41.4675	1684.0
2018-01-31 05:19:00	AAPL	Stock	41.4525	41.4525	41.4525	41.4525	400.0
2018-01-31 05:20:00	AAPL	Stock	41.475	41.475	41.475	41.475	4000.0
2018-01-31 05:21:00	AAPL	Stock	41.4875	41.495	41.475	41.475	20024.0
2018-01-31 05:31:00	AAPL	Stock	41.4825	41.4825	41.4825	41.4825	1200.0
2018-01-31 05:36:00	AAPL	Stock	41.4825	41.485	41.4825	41.485	1600.0
2018-01-31 05:46:00	AAPL	Stock	41.4875	41.4875	41.4875	41.4875	4104.0
2018-01-31 05:58:00	AAPL	Stock	41.455	41.455	41.455	41.455	2068.0
2018-01-31 06:00:00	AAPL	Stock	41.475	41.475	41.475	41.475	800.0
2018-01-31 06:02:00	AAPL	Stock	41.44	41.44	41.4375	41.4375	6076.0
2018-01-31 06:03:00	AAPL	Stock	41.44	41.44	41.44	41.44	800.0
2018-01-31 06:04:00	AAPL	Stock	41.4425	41.4425	41.44	41.44	2000.0
2018-01-31 06:05:00	AAPL	Stock	41.4425	41.4425	41.4425	41.4425	400.0
2018-01-31 06:06:00	AAPL	Stock	41.4625	41.4625	41.4625	41.4625	1200.0
2018-01-31 06:07:00	AAPL	Stock	41.475	41.475	41.475	41.475	5200.0
2018-01-31 06:08:00	AAPL	Stock	41.475	41.475	41.47	41.47	5748.0
2018-01-31 06:10:00	AAPL	Stock	41.475	41.475	41.475	41.475	3668.0
2018-01-31 06:11:00	AAPL	Stock	41.47	41.47	41.47	41.47	3740.0
2018-01-31 06:12:00	AAPL	Stock	41.47	41.47	41.47	41.47	400.0
2018-01-31 06:13:00	AAPL	Stock	41.47	41.47	41.465	41.465	1448.0
2018-01-31 06:14:00	AAPL	Stock	41.465	41.465	41.465	41.465	6884.0
2018-01-31 06:20:00	AAPL	Stock	41.475	41.475	41.475	41.475	800.0
2018-01-31 06:22:00	AAPL	Stock	41.475	41.475	41.475	41.475	400.0
2018-01-31 06:23:00	AAPL	Stock	41.475	41.475	41.475	41.475	800.0
2018-01-31 06:24:00	AAPL	Stock	41.475	41.475	41.475	41.475	800.0
2018-01-31 06:25:00	AAPL	Stock	41.4625	41.4625	41.4625	41.4625	800.0
2018-01-31 06:26:00	AAPL	Stock	41.475	41.475	41.475	41.475	1200.0

> showing 50 of 1,128,425 rows — these rows as CSV

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