PREVIEW / stock_5min / 2018-04-30

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-04-30.parquet
  size:    5.4 MB
  rows:    348,223
  symbols: 2,862

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-04-30 04:00:00	AAPL	Stock	40.675	40.75	40.675	40.75	9248.0
2018-04-30 04:15:00	AAPL	Stock	40.7375	40.7375	40.7375	40.7375	400.0
2018-04-30 04:20:00	AAPL	Stock	40.74	40.74	40.7275	40.7275	2236.0
2018-04-30 04:30:00	AAPL	Stock	40.775	40.8125	40.775	40.8125	2200.0
2018-04-30 04:40:00	AAPL	Stock	40.7725	40.7725	40.7725	40.7725	1092.0
2018-04-30 05:10:00	AAPL	Stock	40.775	40.7875	40.775	40.7875	2512.0
2018-04-30 05:20:00	AAPL	Stock	40.775	40.775	40.7725	40.7725	3320.0
2018-04-30 05:25:00	AAPL	Stock	40.75	40.75	40.75	40.75	5296.0
2018-04-30 05:35:00	AAPL	Stock	40.7875	40.7875	40.7875	40.7875	1200.0
2018-04-30 06:35:00	AAPL	Stock	40.815	40.815	40.815	40.815	400.0
2018-04-30 06:40:00	AAPL	Stock	40.8125	40.8125	40.8125	40.8125	800.0
2018-04-30 06:55:00	AAPL	Stock	40.8	40.8	40.8	40.8	800.0
2018-04-30 07:00:00	AAPL	Stock	40.76	40.825	40.76	40.7875	9496.0
2018-04-30 07:05:00	AAPL	Stock	40.8	40.8125	40.7625	40.8075	22344.0
2018-04-30 07:10:00	AAPL	Stock	40.775	40.7975	40.75	40.75	7244.0
2018-04-30 07:15:00	AAPL	Stock	40.7525	40.7525	40.75	40.75	5348.0
2018-04-30 07:20:00	AAPL	Stock	40.7375	40.795	40.7375	40.795	16636.0
2018-04-30 07:25:00	AAPL	Stock	40.765	40.765	40.75	40.75	5984.0
2018-04-30 07:30:00	AAPL	Stock	40.73	40.75	40.73	40.75	3560.0
2018-04-30 07:35:00	AAPL	Stock	40.75	40.7975	40.75	40.7625	13768.0
2018-04-30 07:40:00	AAPL	Stock	40.7875	40.7875	40.7625	40.775	9400.0
2018-04-30 07:45:00	AAPL	Stock	40.79	40.8	40.7625	40.775	11700.0
2018-04-30 07:50:00	AAPL	Stock	40.7625	40.7775	40.7	40.74	21268.0
2018-04-30 07:55:00	AAPL	Stock	40.735	40.74	40.7275	40.7375	10988.0
2018-04-30 08:00:00	AAPL	Stock	40.7875	40.8225	40.6875	40.7075	113284.0
2018-04-30 08:05:00	AAPL	Stock	40.7125	40.75	40.7125	40.75	29652.0
2018-04-30 08:10:00	AAPL	Stock	40.76	40.78	40.76	40.77	25208.0
2018-04-30 08:15:00	AAPL	Stock	40.77	40.775	40.75	40.75	29980.0
2018-04-30 08:20:00	AAPL	Stock	40.7625	40.765	40.7375	40.765	22212.0
2018-04-30 08:25:00	AAPL	Stock	40.765	40.775	40.75	40.775	15920.0
2018-04-30 08:30:00	AAPL	Stock	40.7625	40.775	40.6625	40.665	110784.0
2018-04-30 08:35:00	AAPL	Stock	40.6775	40.7325	40.625	40.65	120164.0
2018-04-30 08:40:00	AAPL	Stock	40.645	40.665	40.575	40.6025	71532.0
2018-04-30 08:45:00	AAPL	Stock	40.625	40.6475	40.6125	40.6475	47552.0
2018-04-30 08:50:00	AAPL	Stock	40.6455	40.6455	40.6	40.6	31540.0
2018-04-30 08:55:00	AAPL	Stock	40.6225	40.64	40.615	40.64	17660.0
2018-04-30 09:00:00	AAPL	Stock	40.625	40.65	40.6225	40.65	50652.0
2018-04-30 09:05:00	AAPL	Stock	40.6425	40.65	40.5525	40.585	49352.0
2018-04-30 09:10:00	AAPL	Stock	40.625	40.625	40.555	40.5875	34372.0
2018-04-30 09:15:00	AAPL	Stock	40.585	40.5875	40.535	40.585	35212.0
2018-04-30 09:20:00	AAPL	Stock	40.5525	40.5525	40.475	40.4878	97784.0
2018-04-30 09:25:00	AAPL	Stock	40.4875	40.5625	40.48	40.5375	121568.0
2018-04-30 09:30:00	AAPL	Stock	40.5275	41.0	40.46	40.945	5959948.0
2018-04-30 09:35:00	AAPL	Stock	40.9475	41.35	40.9375	41.2738	5604652.0
2018-04-30 09:40:00	AAPL	Stock	41.2725	41.5425	41.27	41.4828	6118176.0
2018-04-30 09:45:00	AAPL	Stock	41.485	41.7172	41.475	41.672	6958284.0
2018-04-30 09:50:00	AAPL	Stock	41.675	41.76	41.605	41.6325	5848904.0
2018-04-30 09:55:00	AAPL	Stock	41.6338	41.66	41.5452	41.5625	3827388.0
2018-04-30 10:00:00	AAPL	Stock	41.56	41.8075	41.5375	41.79	4456564.0
2018-04-30 10:05:00	AAPL	Stock	41.7925	41.815	41.68	41.6925	2646860.0

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

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