PREVIEW / stock_1min / 2017-07-24

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-24.parquet
  size:    14.0 MB
  rows:    1,011,293
  symbols: 2,471

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
2017-07-24 05:42:00	AAPL	Stock	37.525	37.525	37.525	37.525	400.0
2017-07-24 06:57:00	AAPL	Stock	37.475	37.475	37.475	37.475	2000.0
2017-07-24 07:05:00	AAPL	Stock	37.5	37.5	37.5	37.5	4000.0
2017-07-24 07:24:00	AAPL	Stock	37.4875	37.4875	37.4875	37.4875	1300.0
2017-07-24 07:29:00	AAPL	Stock	37.5	37.5	37.5	37.5	1920.0
2017-07-24 07:30:00	AAPL	Stock	37.5125	37.5125	37.5125	37.5125	2100.0
2017-07-24 07:52:00	AAPL	Stock	37.52	37.52	37.52	37.52	1992.0
2017-07-24 07:55:00	AAPL	Stock	37.5275	37.5275	37.5275	37.5275	1200.0
2017-07-24 08:00:00	AAPL	Stock	37.5275	37.5375	37.52	37.52	6368.0
2017-07-24 08:01:00	AAPL	Stock	37.525	37.525	37.525	37.525	3992.0
2017-07-24 08:03:00	AAPL	Stock	37.5375	37.5375	37.5375	37.5375	800.0
2017-07-24 08:04:00	AAPL	Stock	37.5375	37.5375	37.5375	37.5375	4312.0
2017-07-24 08:09:00	AAPL	Stock	37.5375	37.5375	37.5375	37.5375	528.0
2017-07-24 08:27:00	AAPL	Stock	37.5625	37.565	37.5625	37.565	1200.0
2017-07-24 08:29:00	AAPL	Stock	37.5825	37.5825	37.5825	37.5825	400.0
2017-07-24 08:31:00	AAPL	Stock	37.5825	37.5825	37.5825	37.5825	452.0
2017-07-24 08:32:00	AAPL	Stock	37.5925	37.5925	37.5925	37.5925	1416.0
2017-07-24 08:33:00	AAPL	Stock	37.5875	37.5925	37.5875	37.5925	2000.0
2017-07-24 08:34:00	AAPL	Stock	37.59	37.5925	37.59	37.5925	1600.0
2017-07-24 08:35:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	400.0
2017-07-24 08:37:00	AAPL	Stock	37.59	37.59	37.59	37.59	400.0
2017-07-24 08:38:00	AAPL	Stock	37.5875	37.59	37.5875	37.59	800.0
2017-07-24 08:40:00	AAPL	Stock	37.59	37.59	37.59	37.59	800.0
2017-07-24 08:41:00	AAPL	Stock	37.59	37.59	37.59	37.59	400.0
2017-07-24 08:43:00	AAPL	Stock	37.59	37.59	37.59	37.59	624.0
2017-07-24 08:44:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	1200.0
2017-07-24 08:45:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	3560.0
2017-07-24 08:47:00	AAPL	Stock	37.5925	37.595	37.5925	37.595	1340.0
2017-07-24 08:48:00	AAPL	Stock	37.5925	37.5925	37.5925	37.5925	2800.0
2017-07-24 08:52:00	AAPL	Stock	37.5775	37.5775	37.5775	37.5775	5000.0
2017-07-24 08:59:00	AAPL	Stock	37.5625	37.5625	37.5625	37.5625	1296.0
2017-07-24 09:02:00	AAPL	Stock	37.58	37.58	37.58	37.58	2000.0
2017-07-24 09:04:00	AAPL	Stock	37.5825	37.5825	37.5825	37.5825	1200.0
2017-07-24 09:09:00	AAPL	Stock	37.57	37.57	37.57	37.57	400.0
2017-07-24 09:12:00	AAPL	Stock	37.585	37.585	37.585	37.585	400.0
2017-07-24 09:13:00	AAPL	Stock	37.585	37.585	37.585	37.585	492.0
2017-07-24 09:14:00	AAPL	Stock	37.585	37.585	37.5825	37.5825	43228.0
2017-07-24 09:17:00	AAPL	Stock	37.5825	37.5825	37.5825	37.5825	1884.0
2017-07-24 09:19:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	400.0
2017-07-24 09:22:00	AAPL	Stock	37.595	37.595	37.595	37.595	2200.0
2017-07-24 09:25:00	AAPL	Stock	37.5875	37.595	37.5875	37.595	2800.0
2017-07-24 09:26:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	1600.0
2017-07-24 09:27:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	3600.0
2017-07-24 09:28:00	AAPL	Stock	37.625	37.66	37.625	37.65	6976.0
2017-07-24 09:29:00	AAPL	Stock	37.65	37.65	37.6375	37.6375	1652.0
2017-07-24 09:30:00	AAPL	Stock	37.645	37.6675	37.6	37.6125	1202424.0
2017-07-24 09:31:00	AAPL	Stock	37.6125	37.635	37.5358	37.5488	402332.0
2017-07-24 09:32:00	AAPL	Stock	37.55	37.6	37.5475	37.5775	245604.0
2017-07-24 09:33:00	AAPL	Stock	37.5775	37.605	37.57	37.574	193828.0
2017-07-24 09:34:00	AAPL	Stock	37.5725	37.5825	37.5525	37.5698	165784.0

> showing 50 of 1,011,293 rows — these rows as CSV

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