PREVIEW / stock_5min / 2019-01-14

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-01-14.parquet
  size:    5.5 MB
  rows:    349,699
  symbols: 2,674

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-14 04:00:00	AAPL	Stock	37.9	37.9	37.9	37.9	400.0
2019-01-14 04:10:00	AAPL	Stock	37.825	37.825	37.75	37.75	1736.0
2019-01-14 04:20:00	AAPL	Stock	37.775	37.775	37.775	37.775	2648.0
2019-01-14 04:35:00	AAPL	Stock	37.775	37.775	37.74	37.74	5756.0
2019-01-14 05:15:00	AAPL	Stock	37.7	37.7	37.7	37.7	4236.0
2019-01-14 05:20:00	AAPL	Stock	37.6625	37.6625	37.6625	37.6625	816.0
2019-01-14 05:40:00	AAPL	Stock	37.6625	37.6625	37.6625	37.6625	400.0
2019-01-14 05:45:00	AAPL	Stock	37.625	37.6625	37.625	37.6625	7436.0
2019-01-14 05:50:00	AAPL	Stock	37.625	37.625	37.625	37.625	428.0
2019-01-14 06:05:00	AAPL	Stock	37.7	37.7	37.7	37.7	680.0
2019-01-14 06:25:00	AAPL	Stock	37.7	37.7	37.67	37.67	2420.0
2019-01-14 06:50:00	AAPL	Stock	37.6525	37.6525	37.6525	37.6525	400.0
2019-01-14 06:55:00	AAPL	Stock	37.65	37.7125	37.65	37.7125	9900.0
2019-01-14 07:00:00	AAPL	Stock	37.71	37.7125	37.6525	37.6625	41048.0
2019-01-14 07:05:00	AAPL	Stock	37.6575	37.6875	37.6525	37.6875	12800.0
2019-01-14 07:10:00	AAPL	Stock	37.6875	37.7	37.685	37.7	16484.0
2019-01-14 07:15:00	AAPL	Stock	37.7	37.7	37.685	37.695	3600.0
2019-01-14 07:20:00	AAPL	Stock	37.71	37.725	37.71	37.725	21756.0
2019-01-14 07:25:00	AAPL	Stock	37.715	37.725	37.715	37.725	3644.0
2019-01-14 07:30:00	AAPL	Stock	37.725	37.7475	37.7125	37.7125	18180.0
2019-01-14 07:35:00	AAPL	Stock	37.7075	37.7475	37.7075	37.7475	11112.0
2019-01-14 07:40:00	AAPL	Stock	37.745	37.7775	37.745	37.7775	25852.0
2019-01-14 07:50:00	AAPL	Stock	37.7525	37.7525	37.725	37.725	10400.0
2019-01-14 07:55:00	AAPL	Stock	37.7025	37.7275	37.7	37.7	4868.0
2019-01-14 08:00:00	AAPL	Stock	37.689	37.7625	37.65	37.7	54604.0
2019-01-14 08:05:00	AAPL	Stock	37.7	37.7338	37.6875	37.725	36688.0
2019-01-14 08:10:00	AAPL	Stock	37.725	37.725	37.7125	37.725	6696.0
2019-01-14 08:15:00	AAPL	Stock	37.7075	37.7075	37.695	37.695	1200.0
2019-01-14 08:20:00	AAPL	Stock	37.7225	37.7225	37.6875	37.7	8828.0
2019-01-14 08:25:00	AAPL	Stock	37.6925	37.7125	37.68	37.6875	16840.0
2019-01-14 08:30:00	AAPL	Stock	37.7125	37.73	37.7	37.725	12200.0
2019-01-14 08:35:00	AAPL	Stock	37.74	37.7725	37.74	37.7625	18580.0
2019-01-14 08:40:00	AAPL	Stock	37.75	37.8125	37.75	37.7875	22496.0
2019-01-14 08:45:00	AAPL	Stock	37.8	38.0725	37.7875	37.79	24592.0
2019-01-14 08:50:00	AAPL	Stock	37.805	37.8475	37.805	37.8125	14528.0
2019-01-14 08:55:00	AAPL	Stock	37.8125	37.815	37.755	37.775	23552.0
2019-01-14 09:00:00	AAPL	Stock	37.7775	37.7975	37.7775	37.7825	11596.0
2019-01-14 09:05:00	AAPL	Stock	37.7875	37.7875	37.7475	37.7825	48564.0
2019-01-14 09:10:00	AAPL	Stock	37.7825	37.8	37.75	37.8	9932.0
2019-01-14 09:15:00	AAPL	Stock	37.795	37.795	37.77	37.7775	23408.0
2019-01-14 09:20:00	AAPL	Stock	37.7875	37.795	37.7625	37.7875	25128.0
2019-01-14 09:25:00	AAPL	Stock	37.7775	37.81	37.7275	37.7275	116940.0
2019-01-14 09:30:00	AAPL	Stock	37.7125	37.8175	37.59	37.6	3669820.0
2019-01-14 09:35:00	AAPL	Stock	37.6025	37.6025	37.455	37.54	5497024.0
2019-01-14 09:40:00	AAPL	Stock	37.535	37.6	37.49	37.535	3134668.0
2019-01-14 09:45:00	AAPL	Stock	37.535	37.5975	37.5	37.5	1992404.0
2019-01-14 09:50:00	AAPL	Stock	37.5	37.6625	37.4775	37.5975	2435604.0
2019-01-14 09:55:00	AAPL	Stock	37.5975	37.6112	37.4525	37.5	2368856.0
2019-01-14 10:00:00	AAPL	Stock	37.505	37.5625	37.4975	37.555	1239040.0
2019-01-14 10:05:00	AAPL	Stock	37.555	37.56	37.48	37.4925	1846804.0

> showing 50 of 349,699 rows — these rows as CSV

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