PREVIEW / stock_1min / 2015-06-29

all stock 1-min files

  file:    by_date/stock_1min/2015/2015-06-29.parquet
  size:    16.1 MB
  rows:    1,153,323
  symbols: 2,869

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
2015-06-29 04:00:00	AAPL	Stock	31.125	31.2775	31.125	31.1925	10672.0
2015-06-29 04:01:00	AAPL	Stock	31.1875	31.25	31.1775	31.25	6000.0
2015-06-29 04:02:00	AAPL	Stock	31.25	31.25	31.25	31.25	7600.0
2015-06-29 04:03:00	AAPL	Stock	31.2025	31.2025	31.2025	31.2025	400.0
2015-06-29 04:04:00	AAPL	Stock	31.2475	31.2475	31.2475	31.2475	3000.0
2015-06-29 04:05:00	AAPL	Stock	31.205	31.2375	31.2025	31.2375	2800.0
2015-06-29 04:06:00	AAPL	Stock	31.2375	31.2375	31.2375	31.2375	2000.0
2015-06-29 04:07:00	AAPL	Stock	31.205	31.2375	31.205	31.2375	1368.0
2015-06-29 04:08:00	AAPL	Stock	31.2375	31.25	31.235	31.25	14112.0
2015-06-29 04:09:00	AAPL	Stock	31.25	31.25	31.245	31.25	3600.0
2015-06-29 04:11:00	AAPL	Stock	31.2375	31.25	31.2375	31.25	3192.0
2015-06-29 04:12:00	AAPL	Stock	31.2675	31.2675	31.2675	31.2675	800.0
2015-06-29 04:13:00	AAPL	Stock	31.25	31.25	31.25	31.25	8644.0
2015-06-29 04:15:00	AAPL	Stock	31.25	31.25	31.25	31.25	400.0
2015-06-29 04:21:00	AAPL	Stock	31.2375	31.2375	31.2375	31.2375	37576.0
2015-06-29 04:22:00	AAPL	Stock	31.24	31.24	31.24	31.24	6140.0
2015-06-29 04:23:00	AAPL	Stock	31.25	31.25	31.25	31.25	7280.0
2015-06-29 04:24:00	AAPL	Stock	31.265	31.265	31.265	31.265	400.0
2015-06-29 04:25:00	AAPL	Stock	31.25	31.25	31.25	31.25	11560.0
2015-06-29 04:28:00	AAPL	Stock	31.275	31.275	31.2625	31.2625	9600.0
2015-06-29 04:30:00	AAPL	Stock	31.2625	31.2625	31.2625	31.2625	1200.0
2015-06-29 04:31:00	AAPL	Stock	31.2625	31.2625	31.2625	31.2625	1600.0
2015-06-29 04:32:00	AAPL	Stock	31.295	31.295	31.275	31.275	4400.0
2015-06-29 04:35:00	AAPL	Stock	31.275	31.275	31.2625	31.2625	7612.0
2015-06-29 04:36:00	AAPL	Stock	31.2825	31.2825	31.2825	31.2825	400.0
2015-06-29 04:39:00	AAPL	Stock	31.3125	31.32	31.3125	31.32	3600.0
2015-06-29 04:40:00	AAPL	Stock	31.325	31.325	31.325	31.325	800.0
2015-06-29 04:41:00	AAPL	Stock	31.325	31.325	31.325	31.325	400.0
2015-06-29 04:42:00	AAPL	Stock	31.325	31.325	31.3125	31.3125	3000.0
2015-06-29 04:43:00	AAPL	Stock	31.3125	31.3125	31.3075	31.3075	1072.0
2015-06-29 04:44:00	AAPL	Stock	31.28	31.28	31.28	31.28	5200.0
2015-06-29 04:47:00	AAPL	Stock	31.29	31.29	31.29	31.29	800.0
2015-06-29 04:48:00	AAPL	Stock	31.2875	31.2875	31.2875	31.2875	800.0
2015-06-29 04:49:00	AAPL	Stock	31.2875	31.2875	31.2875	31.2875	4000.0
2015-06-29 04:50:00	AAPL	Stock	31.2875	31.2875	31.2875	31.2875	2400.0
2015-06-29 04:51:00	AAPL	Stock	31.2875	31.2875	31.2875	31.2875	4400.0
2015-06-29 04:52:00	AAPL	Stock	31.2875	31.2875	31.2875	31.2875	400.0
2015-06-29 04:53:00	AAPL	Stock	31.31	31.3125	31.31	31.3125	2480.0
2015-06-29 04:54:00	AAPL	Stock	31.3425	31.3425	31.3425	31.3425	4000.0
2015-06-29 04:56:00	AAPL	Stock	31.3	31.3	31.3	31.3	4000.0
2015-06-29 05:00:00	AAPL	Stock	31.34	31.345	31.34	31.345	3344.0
2015-06-29 05:03:00	AAPL	Stock	31.3325	31.3325	31.3325	31.3325	400.0
2015-06-29 05:04:00	AAPL	Stock	31.3	31.3	31.3	31.3	6796.0
2015-06-29 05:08:00	AAPL	Stock	31.2875	31.3	31.2875	31.3	4000.0
2015-06-29 05:10:00	AAPL	Stock	31.3	31.3	31.3	31.3	800.0
2015-06-29 05:13:00	AAPL	Stock	31.3	31.3	31.3	31.3	4400.0
2015-06-29 05:14:00	AAPL	Stock	31.3	31.3	31.3	31.3	400.0
2015-06-29 05:19:00	AAPL	Stock	31.3	31.3	31.3	31.3	3600.0
2015-06-29 05:20:00	AAPL	Stock	31.3	31.3	31.3	31.3	4796.0
2015-06-29 05:25:00	AAPL	Stock	31.3	31.3	31.3	31.3	800.0

> showing 50 of 1,153,323 rows — these rows as CSV

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