PREVIEW / stock_5min / 2019-01-31

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-01-31.parquet
  size:    5.8 MB
  rows:    369,042
  symbols: 2,689

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
2019-01-31 04:00:00	AAPL	Stock	41.5875	41.6025	41.5875	41.6025	2240.0
2019-01-31 04:05:00	AAPL	Stock	41.5775	41.6	41.555	41.5875	21704.0
2019-01-31 04:10:00	AAPL	Stock	41.5675	41.5675	41.5675	41.5675	800.0
2019-01-31 04:20:00	AAPL	Stock	41.505	41.505	41.5	41.505	9488.0
2019-01-31 04:25:00	AAPL	Stock	41.575	41.585	41.5125	41.5125	22160.0
2019-01-31 04:30:00	AAPL	Stock	41.5625	41.5625	41.5625	41.5625	3296.0
2019-01-31 04:35:00	AAPL	Stock	41.5625	41.6475	41.5625	41.5625	14448.0
2019-01-31 04:40:00	AAPL	Stock	41.5975	41.635	41.5975	41.635	4400.0
2019-01-31 04:45:00	AAPL	Stock	41.6275	41.6275	41.6275	41.6275	400.0
2019-01-31 04:50:00	AAPL	Stock	41.66	41.66	41.66	41.66	1136.0
2019-01-31 04:55:00	AAPL	Stock	41.65	41.66	41.625	41.66	3512.0
2019-01-31 05:00:00	AAPL	Stock	41.6025	41.6025	41.54	41.54	17148.0
2019-01-31 05:05:00	AAPL	Stock	41.54	41.54	41.52	41.52	17116.0
2019-01-31 05:10:00	AAPL	Stock	41.5	41.54	41.5	41.54	3288.0
2019-01-31 05:15:00	AAPL	Stock	41.505	41.505	41.5025	41.5025	1552.0
2019-01-31 05:20:00	AAPL	Stock	41.575	41.575	41.5075	41.5075	1216.0
2019-01-31 05:25:00	AAPL	Stock	41.5	41.5025	41.4825	41.4825	7568.0
2019-01-31 05:30:00	AAPL	Stock	41.45	41.45	41.45	41.45	4000.0
2019-01-31 05:35:00	AAPL	Stock	41.49	41.5125	41.49	41.5125	8180.0
2019-01-31 05:40:00	AAPL	Stock	41.5075	41.5075	41.5025	41.5025	5600.0
2019-01-31 05:45:00	AAPL	Stock	41.505	41.5125	41.5	41.5125	7600.0
2019-01-31 05:50:00	AAPL	Stock	41.5	41.5	41.5	41.5	1200.0
2019-01-31 06:05:00	AAPL	Stock	41.5	41.5	41.5	41.5	400.0
2019-01-31 06:20:00	AAPL	Stock	41.5425	41.5425	41.5425	41.5425	576.0
2019-01-31 06:25:00	AAPL	Stock	41.5425	41.5425	41.5375	41.5375	3312.0
2019-01-31 06:35:00	AAPL	Stock	41.6	41.6	41.6	41.6	2400.0
2019-01-31 06:50:00	AAPL	Stock	41.6	41.6	41.6	41.6	800.0
2019-01-31 07:00:00	AAPL	Stock	41.5475	41.6	41.525	41.55	18580.0
2019-01-31 07:05:00	AAPL	Stock	41.525	41.55	41.525	41.55	2524.0
2019-01-31 07:10:00	AAPL	Stock	41.53	41.53	41.525	41.53	2052.0
2019-01-31 07:15:00	AAPL	Stock	41.5425	41.6	41.5425	41.575	13852.0
2019-01-31 07:20:00	AAPL	Stock	41.5775	41.6225	41.5775	41.62	45852.0
2019-01-31 07:25:00	AAPL	Stock	41.625	41.6375	41.5875	41.625	10296.0
2019-01-31 07:30:00	AAPL	Stock	41.6325	41.6325	41.5775	41.6	18036.0
2019-01-31 07:35:00	AAPL	Stock	41.58	41.6025	41.575	41.5775	39136.0
2019-01-31 07:40:00	AAPL	Stock	41.6	41.65	41.6	41.65	34996.0
2019-01-31 07:45:00	AAPL	Stock	41.6475	41.66	41.61	41.655	29732.0
2019-01-31 07:50:00	AAPL	Stock	41.65	41.655	41.65	41.6525	21028.0
2019-01-31 07:55:00	AAPL	Stock	41.6625	41.6625	41.615	41.625	59368.0
2019-01-31 08:00:00	AAPL	Stock	41.55	41.675	41.525	41.675	99092.0
2019-01-31 08:05:00	AAPL	Stock	41.675	41.675	41.625	41.6675	68620.0
2019-01-31 08:10:00	AAPL	Stock	41.6625	41.6725	41.6125	41.65	35116.0
2019-01-31 08:15:00	AAPL	Stock	41.64	41.6575	41.6375	41.655	24172.0
2019-01-31 08:20:00	AAPL	Stock	41.64	41.6425	41.6	41.6	13616.0
2019-01-31 08:25:00	AAPL	Stock	41.6	41.6025	41.5625	41.5625	65068.0
2019-01-31 08:30:00	AAPL	Stock	41.565	41.585	41.5625	41.57	27152.0
2019-01-31 08:35:00	AAPL	Stock	41.5875	41.6	41.575	41.5875	16860.0
2019-01-31 08:40:00	AAPL	Stock	41.5775	41.59	41.5625	41.5625	41112.0
2019-01-31 08:45:00	AAPL	Stock	41.5375	41.59	41.535	41.5375	88100.0
2019-01-31 08:50:00	AAPL	Stock	41.5425	41.6	41.5375	41.5775	26988.0

> showing 50 of 369,042 rows — these rows as CSV

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