PREVIEW / stock_5min / 2019-07-16

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-07-16.parquet
  size:    5.6 MB
  rows:    350,956
  symbols: 2,598

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-07-16 04:00:00	AAPL	Stock	51.25	51.25	51.25	51.25	3000.0
2019-07-16 04:05:00	AAPL	Stock	51.345	51.36	51.305	51.305	2760.0
2019-07-16 04:10:00	AAPL	Stock	51.275	51.275	51.275	51.275	400.0
2019-07-16 05:30:00	AAPL	Stock	51.2625	51.2625	51.2625	51.2625	5012.0
2019-07-16 05:35:00	AAPL	Stock	51.2625	51.2625	51.2625	51.2625	400.0
2019-07-16 05:50:00	AAPL	Stock	51.295	51.295	51.295	51.295	568.0
2019-07-16 06:45:00	AAPL	Stock	51.2475	51.2475	51.2475	51.2475	1600.0
2019-07-16 06:50:00	AAPL	Stock	51.2475	51.2475	51.2475	51.2475	1732.0
2019-07-16 06:55:00	AAPL	Stock	51.275	51.285	51.275	51.275	7012.0
2019-07-16 07:00:00	AAPL	Stock	51.285	51.2975	51.285	51.2975	25516.0
2019-07-16 07:10:00	AAPL	Stock	51.295	51.31	51.2925	51.31	19948.0
2019-07-16 07:15:00	AAPL	Stock	51.3025	51.345	51.3	51.3225	14776.0
2019-07-16 07:25:00	AAPL	Stock	51.33	51.3375	51.33	51.3375	800.0
2019-07-16 07:30:00	AAPL	Stock	51.36	51.36	51.35	51.3525	5600.0
2019-07-16 07:35:00	AAPL	Stock	51.3625	51.3625	51.3625	51.3625	1600.0
2019-07-16 07:40:00	AAPL	Stock	51.37	51.38	51.37	51.38	10208.0
2019-07-16 07:45:00	AAPL	Stock	51.375	51.375	51.3275	51.3275	10012.0
2019-07-16 07:50:00	AAPL	Stock	51.34	51.3725	51.34	51.35	7184.0
2019-07-16 08:00:00	AAPL	Stock	51.38	51.3825	51.2775	51.37	66116.0
2019-07-16 08:05:00	AAPL	Stock	51.3625	51.3625	51.35	51.35	2608.0
2019-07-16 08:10:00	AAPL	Stock	51.355	51.3625	51.3375	51.3375	5920.0
2019-07-16 08:15:00	AAPL	Stock	51.3358	51.3375	51.3225	51.325	6204.0
2019-07-16 08:20:00	AAPL	Stock	51.325	51.3325	51.325	51.325	8200.0
2019-07-16 08:25:00	AAPL	Stock	51.325	51.3325	51.325	51.3325	1400.0
2019-07-16 08:30:00	AAPL	Stock	51.3175	51.3175	51.275	51.2825	7996.0
2019-07-16 08:35:00	AAPL	Stock	51.2775	51.3	51.2775	51.3	8400.0
2019-07-16 08:40:00	AAPL	Stock	51.3175	51.3175	51.3	51.3	22600.0
2019-07-16 08:45:00	AAPL	Stock	51.3075	51.3225	51.3075	51.3225	5200.0
2019-07-16 08:50:00	AAPL	Stock	51.3175	51.3175	51.2875	51.2875	10800.0
2019-07-16 08:55:00	AAPL	Stock	51.295	51.295	51.2725	51.2725	1200.0
2019-07-16 09:00:00	AAPL	Stock	51.285	51.285	51.2625	51.2825	25364.0
2019-07-16 09:05:00	AAPL	Stock	51.2675	51.275	51.2675	51.275	16440.0
2019-07-16 09:10:00	AAPL	Stock	51.285	51.285	51.2775	51.2775	1200.0
2019-07-16 09:15:00	AAPL	Stock	51.285	51.285	51.2775	51.2775	4000.0
2019-07-16 09:20:00	AAPL	Stock	51.3025	51.3025	51.275	51.2875	72200.0
2019-07-16 09:25:00	AAPL	Stock	51.275	51.275	51.035	51.185	80604.0
2019-07-16 09:30:00	AAPL	Stock	51.185	51.2975	51.0025	51.2825	3349484.0
2019-07-16 09:35:00	AAPL	Stock	51.2875	51.3735	51.22	51.37	1138976.0
2019-07-16 09:40:00	AAPL	Stock	51.365	51.4568	51.313	51.432	1316512.0
2019-07-16 09:45:00	AAPL	Stock	51.43	51.5275	51.4282	51.5175	1632256.0
2019-07-16 09:50:00	AAPL	Stock	51.5175	51.5248	51.45	51.48	780704.0
2019-07-16 09:55:00	AAPL	Stock	51.485	51.5	51.4675	51.4975	706908.0
2019-07-16 10:00:00	AAPL	Stock	51.4975	51.5075	51.4125	51.4162	962972.0
2019-07-16 10:05:00	AAPL	Stock	51.4175	51.4625	51.4025	51.4362	593336.0
2019-07-16 10:10:00	AAPL	Stock	51.4375	51.484	51.4312	51.455	814788.0
2019-07-16 10:15:00	AAPL	Stock	51.455	51.469	51.365	51.4	619784.0
2019-07-16 10:20:00	AAPL	Stock	51.4012	51.4575	51.4	51.45	418476.0
2019-07-16 10:25:00	AAPL	Stock	51.4525	51.475	51.4362	51.4575	427720.0
2019-07-16 10:30:00	AAPL	Stock	51.459	51.493	51.459	51.48	389984.0
2019-07-16 10:35:00	AAPL	Stock	51.48	51.48	51.4335	51.4487	335260.0

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

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