PREVIEW / stock_5min / 2017-09-20

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-20.parquet
  size:    5.4 MB
  rows:    348,599
  symbols: 2,953

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-09-20 04:00:00	AAPL	Stock	39.605	39.7475	39.605	39.7475	3800.0
2017-09-20 04:15:00	AAPL	Stock	39.7575	39.7575	39.7575	39.7575	400.0
2017-09-20 04:25:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-20 04:45:00	AAPL	Stock	39.725	39.725	39.725	39.725	400.0
2017-09-20 04:50:00	AAPL	Stock	39.725	39.725	39.725	39.725	1284.0
2017-09-20 05:25:00	AAPL	Stock	39.7275	39.7275	39.7275	39.7275	800.0
2017-09-20 05:40:00	AAPL	Stock	39.7575	39.7575	39.7575	39.7575	800.0
2017-09-20 05:45:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-20 05:55:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-20 06:00:00	AAPL	Stock	39.7875	39.7875	39.7875	39.7875	1152.0
2017-09-20 06:05:00	AAPL	Stock	39.725	39.725	39.725	39.725	400.0
2017-09-20 06:10:00	AAPL	Stock	39.7175	39.7175	39.7175	39.7175	400.0
2017-09-20 06:15:00	AAPL	Stock	39.7175	39.7175	39.7175	39.7175	840.0
2017-09-20 06:20:00	AAPL	Stock	39.7175	39.7175	39.7175	39.7175	400.0
2017-09-20 06:40:00	AAPL	Stock	39.715	39.715	39.715	39.715	400.0
2017-09-20 06:55:00	AAPL	Stock	39.6975	39.6975	39.685	39.685	1200.0
2017-09-20 07:00:00	AAPL	Stock	39.6975	39.725	39.6975	39.725	22720.0
2017-09-20 07:05:00	AAPL	Stock	39.74	39.74	39.725	39.725	8000.0
2017-09-20 07:10:00	AAPL	Stock	39.7225	39.725	39.7225	39.725	2792.0
2017-09-20 07:15:00	AAPL	Stock	39.75	39.75	39.75	39.75	3600.0
2017-09-20 07:25:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-20 07:30:00	AAPL	Stock	39.75	39.75	39.75	39.75	2000.0
2017-09-20 07:35:00	AAPL	Stock	39.7275	39.7275	39.7275	39.7275	2800.0
2017-09-20 07:40:00	AAPL	Stock	39.7275	39.735	39.7225	39.7275	18152.0
2017-09-20 07:45:00	AAPL	Stock	39.7125	39.7125	39.7	39.7	12000.0
2017-09-20 07:50:00	AAPL	Stock	39.715	39.715	39.71	39.71	1000.0
2017-09-20 07:55:00	AAPL	Stock	39.6875	39.7	39.635	39.6825	22796.0
2017-09-20 08:00:00	AAPL	Stock	39.7	39.75	39.6475	39.65	27032.0
2017-09-20 08:05:00	AAPL	Stock	39.65	39.675	39.645	39.675	12660.0
2017-09-20 08:10:00	AAPL	Stock	39.6675	39.6675	39.6	39.6	32796.0
2017-09-20 08:15:00	AAPL	Stock	39.6	39.6125	39.59	39.6125	30632.0
2017-09-20 08:20:00	AAPL	Stock	39.6125	39.6125	39.6	39.61	11400.0
2017-09-20 08:25:00	AAPL	Stock	39.605	39.605	39.605	39.605	2580.0
2017-09-20 08:30:00	AAPL	Stock	39.605	39.6125	39.575	39.575	28344.0
2017-09-20 08:35:00	AAPL	Stock	39.585	39.5975	39.575	39.575	28348.0
2017-09-20 08:40:00	AAPL	Stock	39.575	39.575	39.57	39.575	24308.0
2017-09-20 08:45:00	AAPL	Stock	39.5725	39.5725	39.5175	39.525	31472.0
2017-09-20 08:50:00	AAPL	Stock	39.5275	39.5675	39.525	39.5675	15824.0
2017-09-20 08:55:00	AAPL	Stock	39.5675	39.5725	39.545	39.545	60268.0
2017-09-20 09:00:00	AAPL	Stock	39.5425	39.545	39.5225	39.525	27568.0
2017-09-20 09:05:00	AAPL	Stock	39.525	39.535	39.5225	39.535	29200.0
2017-09-20 09:10:00	AAPL	Stock	39.5275	39.5375	39.5275	39.5325	8868.0
2017-09-20 09:15:00	AAPL	Stock	39.5375	39.575	39.5325	39.55	20584.0
2017-09-20 09:20:00	AAPL	Stock	39.55	39.55	39.5425	39.55	7172.0
2017-09-20 09:25:00	AAPL	Stock	39.5425	39.5475	39.475	39.4975	128416.0
2017-09-20 09:30:00	AAPL	Stock	39.5	39.565	39.3075	39.3225	6322448.0
2017-09-20 09:35:00	AAPL	Stock	39.32	39.425	39.295	39.3875	3700220.0
2017-09-20 09:40:00	AAPL	Stock	39.3862	39.4	39.3325	39.335	2481396.0
2017-09-20 09:45:00	AAPL	Stock	39.335	39.36	39.265	39.275	2549576.0
2017-09-20 09:50:00	AAPL	Stock	39.2762	39.2785	39.1	39.1512	7317320.0

> showing 50 of 348,599 rows — these rows as CSV

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