PREVIEW / stock_5min / 2019-09-20

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-09-20.parquet
  size:    5.7 MB
  rows:    363,430
  symbols: 2,551

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-09-20 04:05:00	AAPL	Stock	55.3225	55.365	55.3225	55.365	800.0
2019-09-20 04:10:00	AAPL	Stock	55.325	55.325	55.325	55.325	1600.0
2019-09-20 04:15:00	AAPL	Stock	55.3375	55.3975	55.3275	55.3975	2000.0
2019-09-20 04:25:00	AAPL	Stock	55.3725	55.3725	55.3725	55.3725	400.0
2019-09-20 04:40:00	AAPL	Stock	55.41	55.41	55.41	55.41	548.0
2019-09-20 04:50:00	AAPL	Stock	55.355	55.355	55.3375	55.3375	1060.0
2019-09-20 05:10:00	AAPL	Stock	55.35	55.3625	55.35	55.3625	2400.0
2019-09-20 05:35:00	AAPL	Stock	55.3925	55.4	55.3925	55.4	800.0
2019-09-20 05:45:00	AAPL	Stock	55.395	55.395	55.395	55.395	432.0
2019-09-20 05:50:00	AAPL	Stock	55.395	55.395	55.3375	55.3375	8372.0
2019-09-20 05:55:00	AAPL	Stock	55.4025	55.4025	55.4025	55.4025	640.0
2019-09-20 06:05:00	AAPL	Stock	55.3875	55.3875	55.3875	55.3875	400.0
2019-09-20 06:10:00	AAPL	Stock	55.3625	55.3625	55.315	55.315	800.0
2019-09-20 06:15:00	AAPL	Stock	55.34	55.34	55.34	55.34	400.0
2019-09-20 06:45:00	AAPL	Stock	55.34	55.34	55.335	55.335	6800.0
2019-09-20 07:00:00	AAPL	Stock	55.3625	55.3625	55.2875	55.345	25300.0
2019-09-20 07:05:00	AAPL	Stock	55.325	55.35	55.325	55.35	31784.0
2019-09-20 07:10:00	AAPL	Stock	55.3525	55.3525	55.3425	55.3425	1948.0
2019-09-20 07:15:00	AAPL	Stock	55.36	55.36	55.36	55.36	400.0
2019-09-20 07:20:00	AAPL	Stock	55.375	55.3975	55.375	55.3975	3048.0
2019-09-20 07:25:00	AAPL	Stock	55.3875	55.425	55.3875	55.425	43516.0
2019-09-20 07:30:00	AAPL	Stock	55.4375	55.445	55.425	55.425	6388.0
2019-09-20 07:35:00	AAPL	Stock	55.425	55.425	55.3375	55.35	42184.0
2019-09-20 07:40:00	AAPL	Stock	55.3425	55.35	55.34	55.35	4608.0
2019-09-20 07:45:00	AAPL	Stock	55.3725	55.385	55.3725	55.375	7772.0
2019-09-20 07:50:00	AAPL	Stock	55.3875	55.3875	55.375	55.375	2000.0
2019-09-20 07:55:00	AAPL	Stock	55.4075	55.4375	55.4075	55.4375	9068.0
2019-09-20 08:00:00	AAPL	Stock	55.3275	55.445	55.325	55.4325	105420.0
2019-09-20 08:05:00	AAPL	Stock	55.4325	55.44	55.425	55.4375	20128.0
2019-09-20 08:10:00	AAPL	Stock	55.44	55.4425	55.4325	55.4425	17452.0
2019-09-20 08:15:00	AAPL	Stock	55.4425	55.4425	55.4325	55.4425	18848.0
2019-09-20 08:20:00	AAPL	Stock	55.43	55.4575	55.43	55.4425	28964.0
2019-09-20 08:25:00	AAPL	Stock	55.4375	55.4375	55.385	55.385	38200.0
2019-09-20 08:30:00	AAPL	Stock	55.375	55.45	55.375	55.425	29180.0
2019-09-20 08:35:00	AAPL	Stock	55.425	55.45	55.4125	55.435	13352.0
2019-09-20 08:40:00	AAPL	Stock	55.4275	55.47	55.4275	55.4625	56580.0
2019-09-20 08:45:00	AAPL	Stock	55.4625	55.4875	55.46	55.485	27756.0
2019-09-20 08:50:00	AAPL	Stock	55.485	55.4875	55.4625	55.4825	19648.0
2019-09-20 08:55:00	AAPL	Stock	55.4675	55.475	55.45	55.4625	26400.0
2019-09-20 09:00:00	AAPL	Stock	55.4625	55.48	55.4625	55.4625	24960.0
2019-09-20 09:05:00	AAPL	Stock	55.455	55.455	55.4275	55.45	40740.0
2019-09-20 09:10:00	AAPL	Stock	55.45	55.4725	55.4375	55.47	16556.0
2019-09-20 09:15:00	AAPL	Stock	55.47	55.47	55.385	55.385	74732.0
2019-09-20 09:20:00	AAPL	Stock	55.45	55.455	55.405	55.455	38864.0
2019-09-20 09:25:00	AAPL	Stock	55.45	55.5075	55.345	55.3475	501892.0
2019-09-20 09:30:00	AAPL	Stock	55.3475	55.64	55.3425	55.534	25685212.0
2019-09-20 09:35:00	AAPL	Stock	55.5338	55.5975	55.445	55.5575	1536992.0
2019-09-20 09:40:00	AAPL	Stock	55.565	55.5725	55.4475	55.495	1116656.0
2019-09-20 09:45:00	AAPL	Stock	55.505	55.51	55.415	55.4175	1117160.0
2019-09-20 09:50:00	AAPL	Stock	55.4225	55.4775	55.3625	55.45	1323452.0

> showing 50 of 363,430 rows — these rows as CSV

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