PREVIEW / stock_5min / 2018-08-09

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-09.parquet
  size:    5.5 MB
  rows:    350,581
  symbols: 2,782

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-08-09 04:20:00	AAPL	Stock	51.725	51.725	51.7	51.7	1348.0
2018-08-09 04:25:00	AAPL	Stock	51.6325	51.6325	51.6325	51.6325	3600.0
2018-08-09 04:30:00	AAPL	Stock	51.6125	51.65	51.6125	51.65	5780.0
2018-08-09 04:35:00	AAPL	Stock	51.675	51.675	51.65	51.65	7320.0
2018-08-09 04:45:00	AAPL	Stock	51.7225	51.7225	51.7225	51.7225	2000.0
2018-08-09 04:50:00	AAPL	Stock	51.7225	51.7225	51.7225	51.7225	2000.0
2018-08-09 05:20:00	AAPL	Stock	51.725	51.725	51.725	51.725	5112.0
2018-08-09 05:40:00	AAPL	Stock	51.735	51.735	51.735	51.735	3200.0
2018-08-09 05:45:00	AAPL	Stock	51.75	51.8	51.75	51.8	11200.0
2018-08-09 05:50:00	AAPL	Stock	51.8	51.8	51.8	51.8	29312.0
2018-08-09 06:10:00	AAPL	Stock	51.8	51.8	51.8	51.8	1000.0
2018-08-09 06:45:00	AAPL	Stock	51.81	51.81	51.81	51.81	800.0
2018-08-09 07:00:00	AAPL	Stock	51.745	51.7875	51.7375	51.775	9408.0
2018-08-09 07:05:00	AAPL	Stock	51.775	51.8025	51.775	51.8025	20388.0
2018-08-09 07:10:00	AAPL	Stock	51.7975	51.8025	51.7925	51.8025	3600.0
2018-08-09 07:15:00	AAPL	Stock	51.775	51.775	51.775	51.775	800.0
2018-08-09 07:30:00	AAPL	Stock	51.775	51.775	51.765	51.765	800.0
2018-08-09 07:35:00	AAPL	Stock	51.785	51.785	51.7525	51.7525	9176.0
2018-08-09 07:40:00	AAPL	Stock	51.7625	51.7625	51.7375	51.7525	11904.0
2018-08-09 07:45:00	AAPL	Stock	51.75	51.785	51.75	51.785	4148.0
2018-08-09 07:50:00	AAPL	Stock	51.785	51.785	51.785	51.785	624.0
2018-08-09 07:55:00	AAPL	Stock	51.785	51.785	51.785	51.785	2400.0
2018-08-09 08:00:00	AAPL	Stock	51.7725	51.805	51.7488	51.75	23928.0
2018-08-09 08:05:00	AAPL	Stock	51.7625	51.7625	51.7625	51.7625	448.0
2018-08-09 08:10:00	AAPL	Stock	51.75	51.785	51.75	51.785	4112.0
2018-08-09 08:15:00	AAPL	Stock	51.78	51.785	51.775	51.7825	11500.0
2018-08-09 08:20:00	AAPL	Stock	51.7775	51.8075	51.7775	51.8	15700.0
2018-08-09 08:25:00	AAPL	Stock	51.8	51.8075	51.8	51.805	1200.0
2018-08-09 08:30:00	AAPL	Stock	51.805	51.805	51.805	51.805	400.0
2018-08-09 08:35:00	AAPL	Stock	51.7975	51.7975	51.775	51.775	6500.0
2018-08-09 08:40:00	AAPL	Stock	51.765	51.7825	51.765	51.7825	5200.0
2018-08-09 08:45:00	AAPL	Stock	51.7925	51.8375	51.7925	51.8375	20356.0
2018-08-09 08:50:00	AAPL	Stock	51.8375	51.8375	51.8125	51.83	8736.0
2018-08-09 08:55:00	AAPL	Stock	51.8325	51.8325	51.8325	51.8325	3336.0
2018-08-09 09:00:00	AAPL	Stock	51.8175	51.85	51.815	51.8475	11136.0
2018-08-09 09:05:00	AAPL	Stock	51.8475	51.8475	51.805	51.805	20760.0
2018-08-09 09:10:00	AAPL	Stock	51.825	51.8375	51.81	51.8375	10260.0
2018-08-09 09:15:00	AAPL	Stock	51.8325	51.8325	51.8075	51.8125	9012.0
2018-08-09 09:20:00	AAPL	Stock	51.8125	51.825	51.805	51.805	9372.0
2018-08-09 09:25:00	AAPL	Stock	51.8122	51.8625	51.8075	51.85	41128.0
2018-08-09 09:30:00	AAPL	Stock	51.82	52.125	51.8	52.02	3344560.0
2018-08-09 09:35:00	AAPL	Stock	52.0225	52.1325	51.9845	52.0775	1969132.0
2018-08-09 09:40:00	AAPL	Stock	52.0825	52.1675	52.0825	52.1175	1809212.0
2018-08-09 09:45:00	AAPL	Stock	52.1175	52.1675	52.0625	52.083	1613032.0
2018-08-09 09:50:00	AAPL	Stock	52.085	52.1825	52.0825	52.1325	1372120.0
2018-08-09 09:55:00	AAPL	Stock	52.135	52.1675	52.1275	52.1325	957560.0
2018-08-09 10:00:00	AAPL	Stock	52.1345	52.2338	52.1275	52.2325	1966960.0
2018-08-09 10:05:00	AAPL	Stock	52.2325	52.325	52.2325	52.325	2499680.0
2018-08-09 10:10:00	AAPL	Stock	52.3275	52.375	52.3075	52.3185	1892976.0
2018-08-09 10:15:00	AAPL	Stock	52.32	52.355	52.2825	52.289	1265700.0

> showing 50 of 350,581 rows — these rows as CSV

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