PREVIEW / stock_5min / 2018-03-21

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-03-21.parquet
  size:    5.5 MB
  rows:    353,799
  symbols: 2,873

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-03-21 05:15:00	AAPL	Stock	43.75	43.75	43.75	43.75	1944.0
2018-03-21 06:00:00	AAPL	Stock	43.7475	43.7475	43.7475	43.7475	856.0
2018-03-21 06:55:00	AAPL	Stock	43.8075	43.8075	43.8075	43.8075	5660.0
2018-03-21 07:00:00	AAPL	Stock	43.8075	43.81	43.8	43.8	7580.0
2018-03-21 07:05:00	AAPL	Stock	43.8125	43.86	43.8125	43.825	28560.0
2018-03-21 07:20:00	AAPL	Stock	43.85	43.85	43.85	43.85	1600.0
2018-03-21 07:25:00	AAPL	Stock	43.855	43.8725	43.85	43.8725	3172.0
2018-03-21 07:30:00	AAPL	Stock	43.8625	43.865	43.8625	43.865	13200.0
2018-03-21 07:35:00	AAPL	Stock	43.865	43.865	43.855	43.855	5000.0
2018-03-21 07:40:00	AAPL	Stock	43.85	43.85	43.665	43.745	55420.0
2018-03-21 07:45:00	AAPL	Stock	43.7075	43.725	43.6375	43.725	28216.0
2018-03-21 07:50:00	AAPL	Stock	43.7125	43.7725	43.7075	43.7725	41892.0
2018-03-21 07:55:00	AAPL	Stock	43.725	43.725	43.725	43.725	2296.0
2018-03-21 08:00:00	AAPL	Stock	43.7125	43.8775	43.7125	43.7625	42708.0
2018-03-21 08:05:00	AAPL	Stock	43.75	43.75	43.7225	43.7225	12788.0
2018-03-21 08:10:00	AAPL	Stock	43.7225	43.7225	43.7225	43.7225	800.0
2018-03-21 08:15:00	AAPL	Stock	43.75	43.7525	43.75	43.7525	2832.0
2018-03-21 08:20:00	AAPL	Stock	43.75	43.75	43.75	43.75	9892.0
2018-03-21 08:25:00	AAPL	Stock	43.7625	43.775	43.7625	43.775	24296.0
2018-03-21 08:30:00	AAPL	Stock	43.7925	43.7925	43.7875	43.7875	1716.0
2018-03-21 08:35:00	AAPL	Stock	43.765	43.7675	43.7625	43.7675	2000.0
2018-03-21 08:40:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	616.0
2018-03-21 08:45:00	AAPL	Stock	43.7875	43.7875	43.785	43.7875	8888.0
2018-03-21 08:50:00	AAPL	Stock	43.785	43.7875	43.785	43.7875	3424.0
2018-03-21 08:55:00	AAPL	Stock	43.81	43.81	43.81	43.81	800.0
2018-03-21 09:00:00	AAPL	Stock	43.81	43.8125	43.775	43.785	10780.0
2018-03-21 09:05:00	AAPL	Stock	43.775	43.7775	43.7675	43.7775	5200.0
2018-03-21 09:10:00	AAPL	Stock	43.7625	43.79	43.725	43.73	41680.0
2018-03-21 09:15:00	AAPL	Stock	43.74	43.75	43.735	43.735	23316.0
2018-03-21 09:20:00	AAPL	Stock	43.7225	43.7425	43.7225	43.7375	12488.0
2018-03-21 09:25:00	AAPL	Stock	43.7375	43.7675	43.7375	43.76	7656.0
2018-03-21 09:30:00	AAPL	Stock	43.7525	43.7725	43.5025	43.7075	3382996.0
2018-03-21 09:35:00	AAPL	Stock	43.705	43.72	43.64	43.695	1853976.0
2018-03-21 09:40:00	AAPL	Stock	43.6938	43.6938	43.62	43.6575	1486936.0
2018-03-21 09:45:00	AAPL	Stock	43.6575	43.6875	43.6225	43.63	1439968.0
2018-03-21 09:50:00	AAPL	Stock	43.63	43.655	43.585	43.6362	1003088.0
2018-03-21 09:55:00	AAPL	Stock	43.6365	43.6525	43.5975	43.6078	958856.0
2018-03-21 10:00:00	AAPL	Stock	43.61	43.645	43.5925	43.62	1159556.0
2018-03-21 10:05:00	AAPL	Stock	43.62	43.6225	43.5075	43.5938	1364164.0
2018-03-21 10:10:00	AAPL	Stock	43.5925	43.63	43.5925	43.625	1134596.0
2018-03-21 10:15:00	AAPL	Stock	43.625	43.6275	43.5737	43.575	1070140.0
2018-03-21 10:20:00	AAPL	Stock	43.575	43.5938	43.4775	43.5025	1552548.0
2018-03-21 10:25:00	AAPL	Stock	43.5	43.5175	43.46	43.4825	1453980.0
2018-03-21 10:30:00	AAPL	Stock	43.4825	43.51	43.45	43.4625	1408196.0
2018-03-21 10:35:00	AAPL	Stock	43.465	43.5025	43.4288	43.485	1399120.0
2018-03-21 10:40:00	AAPL	Stock	43.4875	43.515	43.455	43.4638	1188104.0
2018-03-21 10:45:00	AAPL	Stock	43.465	43.5162	43.455	43.49	1061432.0
2018-03-21 10:50:00	AAPL	Stock	43.49	43.5625	43.49	43.56	1171184.0
2018-03-21 10:55:00	AAPL	Stock	43.5575	43.5775	43.5175	43.5238	962204.0
2018-03-21 11:00:00	AAPL	Stock	43.525	43.54	43.4825	43.4888	1066036.0

> showing 50 of 353,799 rows — these rows as CSV

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