PREVIEW / stock_5min / 2018-01-31

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-01-31.parquet
  size:    5.9 MB
  rows:    374,088
  symbols: 2,914

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-01-31 04:00:00	AAPL	Stock	41.625	41.625	41.4125	41.4275	56160.0
2018-01-31 04:05:00	AAPL	Stock	41.4825	41.5	41.465	41.4975	43400.0
2018-01-31 04:15:00	AAPL	Stock	41.495	41.495	41.495	41.495	800.0
2018-01-31 04:20:00	AAPL	Stock	41.475	41.475	41.44	41.44	6624.0
2018-01-31 04:25:00	AAPL	Stock	41.4575	41.4575	41.4575	41.4575	612.0
2018-01-31 04:30:00	AAPL	Stock	41.4425	41.4425	41.3875	41.3875	6476.0
2018-01-31 04:35:00	AAPL	Stock	41.3875	41.3875	41.3875	41.3875	400.0
2018-01-31 04:40:00	AAPL	Stock	41.4125	41.4125	41.4125	41.4125	2000.0
2018-01-31 04:45:00	AAPL	Stock	41.4275	41.4275	41.4275	41.4275	600.0
2018-01-31 05:00:00	AAPL	Stock	41.415	41.415	41.415	41.415	716.0
2018-01-31 05:05:00	AAPL	Stock	41.435	41.4625	41.435	41.4625	12400.0
2018-01-31 05:15:00	AAPL	Stock	41.46	41.4675	41.4525	41.4525	2084.0
2018-01-31 05:20:00	AAPL	Stock	41.475	41.495	41.475	41.475	24024.0
2018-01-31 05:30:00	AAPL	Stock	41.4825	41.4825	41.4825	41.4825	1200.0
2018-01-31 05:35:00	AAPL	Stock	41.4825	41.485	41.4825	41.485	1600.0
2018-01-31 05:45:00	AAPL	Stock	41.4875	41.4875	41.4875	41.4875	4104.0
2018-01-31 05:55:00	AAPL	Stock	41.455	41.455	41.455	41.455	2068.0
2018-01-31 06:00:00	AAPL	Stock	41.475	41.475	41.4375	41.44	9676.0
2018-01-31 06:05:00	AAPL	Stock	41.4425	41.475	41.4425	41.47	12548.0
2018-01-31 06:10:00	AAPL	Stock	41.475	41.475	41.465	41.465	16140.0
2018-01-31 06:20:00	AAPL	Stock	41.475	41.475	41.475	41.475	2800.0
2018-01-31 06:25:00	AAPL	Stock	41.4625	41.475	41.45	41.45	14000.0
2018-01-31 06:30:00	AAPL	Stock	41.4425	41.455	41.4375	41.445	4400.0
2018-01-31 06:35:00	AAPL	Stock	41.4375	41.44	41.4	41.4	15368.0
2018-01-31 06:45:00	AAPL	Stock	41.4375	41.45	41.435	41.4375	44484.0
2018-01-31 06:50:00	AAPL	Stock	41.4625	41.4625	41.46	41.4625	5200.0
2018-01-31 07:00:00	AAPL	Stock	41.4625	41.4625	41.4375	41.4625	13980.0
2018-01-31 07:05:00	AAPL	Stock	41.4625	41.475	41.45	41.47	36556.0
2018-01-31 07:10:00	AAPL	Stock	41.465	41.475	41.455	41.475	19404.0
2018-01-31 07:15:00	AAPL	Stock	41.4575	41.475	41.4575	41.475	24484.0
2018-01-31 07:20:00	AAPL	Stock	41.475	41.475	41.4725	41.475	27596.0
2018-01-31 07:25:00	AAPL	Stock	41.475	41.5	41.4725	41.5	65296.0
2018-01-31 07:30:00	AAPL	Stock	41.5	41.57	41.5	41.5625	94708.0
2018-01-31 07:35:00	AAPL	Stock	41.5625	41.585	41.545	41.545	39100.0
2018-01-31 07:40:00	AAPL	Stock	41.56	41.5725	41.51	41.56	51012.0
2018-01-31 07:45:00	AAPL	Stock	41.56	41.5875	41.56	41.57	26212.0
2018-01-31 07:50:00	AAPL	Stock	41.5825	41.6225	41.57	41.62	70616.0
2018-01-31 07:55:00	AAPL	Stock	41.62	41.6225	41.5675	41.5675	74492.0
2018-01-31 08:00:00	AAPL	Stock	41.4625	41.625	41.45	41.6175	168552.0
2018-01-31 08:05:00	AAPL	Stock	41.6175	41.9975	41.6175	41.8125	320240.0
2018-01-31 08:10:00	AAPL	Stock	41.8125	41.825	41.6575	41.6575	171060.0
2018-01-31 08:15:00	AAPL	Stock	41.6975	41.775	41.6	41.6	132688.0
2018-01-31 08:20:00	AAPL	Stock	41.6	41.645	41.5625	41.5625	89180.0
2018-01-31 08:25:00	AAPL	Stock	41.575	41.6375	41.575	41.6375	34036.0
2018-01-31 08:30:00	AAPL	Stock	41.6375	41.65	41.61	41.6175	40344.0
2018-01-31 08:35:00	AAPL	Stock	41.6275	41.6475	41.6075	41.6075	37528.0
2018-01-31 08:40:00	AAPL	Stock	41.64	41.6425	41.6075	41.6425	23372.0
2018-01-31 08:45:00	AAPL	Stock	41.6275	41.6425	41.59	41.5975	45936.0
2018-01-31 08:50:00	AAPL	Stock	41.6	41.755	41.59	41.6625	154496.0
2018-01-31 08:55:00	AAPL	Stock	41.67	41.7075	41.6625	41.6725	19188.0

> showing 50 of 374,088 rows — these rows as CSV

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