PREVIEW / stock_5min / 2018-11-20

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-11-20.parquet
  size:    5.8 MB
  rows:    367,032
  symbols: 2,765

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-11-20 04:00:00	AAPL	Stock	45.75	45.92	45.75	45.7575	55340.0
2018-11-20 04:05:00	AAPL	Stock	45.7575	45.8	45.7075	45.7075	37556.0
2018-11-20 04:10:00	AAPL	Stock	45.7	45.75	45.7	45.75	11612.0
2018-11-20 04:15:00	AAPL	Stock	45.7125	45.75	45.71	45.75	10068.0
2018-11-20 04:20:00	AAPL	Stock	45.8075	45.8075	45.75	45.7825	5160.0
2018-11-20 04:25:00	AAPL	Stock	45.8	45.825	45.7525	45.825	4248.0
2018-11-20 04:30:00	AAPL	Stock	45.76	45.85	45.76	45.85	7128.0
2018-11-20 04:35:00	AAPL	Stock	45.875	45.875	45.8475	45.875	4780.0
2018-11-20 04:40:00	AAPL	Stock	45.9	45.935	45.875	45.8775	9164.0
2018-11-20 04:45:00	AAPL	Stock	45.8775	45.8775	45.825	45.85	15220.0
2018-11-20 04:50:00	AAPL	Stock	45.8475	45.8475	45.835	45.835	33192.0
2018-11-20 04:55:00	AAPL	Stock	45.835	45.835	45.8125	45.8125	3772.0
2018-11-20 05:00:00	AAPL	Stock	45.7825	45.8125	45.7825	45.8125	4316.0
2018-11-20 05:10:00	AAPL	Stock	45.8125	45.8125	45.8125	45.8125	1564.0
2018-11-20 05:15:00	AAPL	Stock	45.7675	45.7675	45.7625	45.7625	2420.0
2018-11-20 05:20:00	AAPL	Stock	45.765	45.8125	45.755	45.8125	18060.0
2018-11-20 05:25:00	AAPL	Stock	45.8125	45.8775	45.8125	45.845	2400.0
2018-11-20 05:30:00	AAPL	Stock	45.8125	45.8125	45.7875	45.7875	4428.0
2018-11-20 05:35:00	AAPL	Stock	45.755	45.775	45.755	45.775	2296.0
2018-11-20 05:40:00	AAPL	Stock	45.7875	45.7875	45.7875	45.7875	1520.0
2018-11-20 05:45:00	AAPL	Stock	45.7875	45.8275	45.7375	45.8275	6216.0
2018-11-20 05:50:00	AAPL	Stock	45.8425	45.8425	45.825	45.825	4216.0
2018-11-20 05:55:00	AAPL	Stock	45.775	45.775	45.7125	45.7125	16140.0
2018-11-20 06:00:00	AAPL	Stock	45.71	45.7175	45.7	45.71	13256.0
2018-11-20 06:05:00	AAPL	Stock	45.72	45.72	45.695	45.695	2800.0
2018-11-20 06:10:00	AAPL	Stock	45.765	45.815	45.7125	45.7125	36180.0
2018-11-20 06:15:00	AAPL	Stock	45.7925	45.845	45.7925	45.835	4476.0
2018-11-20 06:20:00	AAPL	Stock	45.7525	45.7875	45.75	45.7525	5732.0
2018-11-20 06:25:00	AAPL	Stock	45.73	45.73	45.73	45.73	804.0
2018-11-20 06:30:00	AAPL	Stock	45.7	45.7875	45.7	45.75	14168.0
2018-11-20 06:35:00	AAPL	Stock	45.7875	45.825	45.7875	45.825	2880.0
2018-11-20 06:40:00	AAPL	Stock	45.8725	45.875	45.825	45.875	17200.0
2018-11-20 06:45:00	AAPL	Stock	45.875	45.88	45.875	45.88	4760.0
2018-11-20 07:00:00	AAPL	Stock	45.8225	45.875	45.62	45.625	136344.0
2018-11-20 07:05:00	AAPL	Stock	45.6375	45.6875	45.515	45.565	96608.0
2018-11-20 07:10:00	AAPL	Stock	45.5625	45.6075	45.56	45.595	38436.0
2018-11-20 07:15:00	AAPL	Stock	45.5675	45.5675	45.5125	45.55	55608.0
2018-11-20 07:20:00	AAPL	Stock	45.56	45.6	45.52	45.55	32396.0
2018-11-20 07:25:00	AAPL	Stock	45.5525	45.5525	45.4775	45.5025	59684.0
2018-11-20 07:30:00	AAPL	Stock	45.52	45.5275	45.475	45.475	32780.0
2018-11-20 07:35:00	AAPL	Stock	45.47	45.5	45.465	45.475	62104.0
2018-11-20 07:40:00	AAPL	Stock	45.48	45.4825	45.345	45.345	69440.0
2018-11-20 07:45:00	AAPL	Stock	45.3425	45.375	45.255	45.27	215080.0
2018-11-20 07:50:00	AAPL	Stock	45.2525	45.2675	45.185	45.2025	103216.0
2018-11-20 07:55:00	AAPL	Stock	45.21	45.235	45.175	45.175	115568.0
2018-11-20 08:00:00	AAPL	Stock	45.1875	45.625	45.14	45.175	418548.0
2018-11-20 08:05:00	AAPL	Stock	45.175	45.335	45.1125	45.315	218564.0
2018-11-20 08:10:00	AAPL	Stock	45.315	45.715	45.23	45.2625	98076.0
2018-11-20 08:15:00	AAPL	Stock	45.2675	45.2975	45.1875	45.245	100616.0
2018-11-20 08:20:00	AAPL	Stock	45.2375	45.3225	45.19	45.275	104256.0

> showing 50 of 367,032 rows — these rows as CSV

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