PREVIEW / stock_5min / 2017-09-27

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-27.parquet
  size:    5.6 MB
  rows:    363,520
  symbols: 2,967

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
2017-09-27 04:05:00	AAPL	Stock	38.4275	38.4275	38.4275	38.4275	400.0
2017-09-27 04:45:00	AAPL	Stock	38.485	38.56	38.485	38.56	800.0
2017-09-27 05:00:00	AAPL	Stock	38.49	38.49	38.49	38.49	800.0
2017-09-27 05:15:00	AAPL	Stock	38.5	38.55	38.5	38.55	800.0
2017-09-27 05:20:00	AAPL	Stock	38.5	38.5	38.5	38.5	3688.0
2017-09-27 05:25:00	AAPL	Stock	38.5025	38.5025	38.5025	38.5025	400.0
2017-09-27 05:30:00	AAPL	Stock	38.5	38.545	38.5	38.545	836.0
2017-09-27 05:35:00	AAPL	Stock	38.545	38.545	38.545	38.545	400.0
2017-09-27 05:40:00	AAPL	Stock	38.5425	38.545	38.5425	38.545	2896.0
2017-09-27 05:45:00	AAPL	Stock	38.52	38.52	38.52	38.52	512.0
2017-09-27 06:05:00	AAPL	Stock	38.465	38.465	38.465	38.465	400.0
2017-09-27 06:10:00	AAPL	Stock	38.4625	38.4625	38.4625	38.4625	1600.0
2017-09-27 06:25:00	AAPL	Stock	38.5175	38.5175	38.5175	38.5175	400.0
2017-09-27 06:30:00	AAPL	Stock	38.5	38.5	38.5	38.5	4988.0
2017-09-27 06:35:00	AAPL	Stock	38.52	38.52	38.5	38.5	3160.0
2017-09-27 06:50:00	AAPL	Stock	38.52	38.575	38.52	38.575	54144.0
2017-09-27 07:00:00	AAPL	Stock	38.56	38.6625	38.56	38.575	39288.0
2017-09-27 07:05:00	AAPL	Stock	38.575	38.575	38.275	38.33	161428.0
2017-09-27 07:10:00	AAPL	Stock	38.3775	38.4	38.33	38.375	23616.0
2017-09-27 07:15:00	AAPL	Stock	38.375	38.4525	38.375	38.435	105624.0
2017-09-27 07:20:00	AAPL	Stock	38.43	38.43	38.39	38.39	5200.0
2017-09-27 07:25:00	AAPL	Stock	38.3925	38.42	38.375	38.3875	21520.0
2017-09-27 07:30:00	AAPL	Stock	38.405	38.405	38.395	38.4	8400.0
2017-09-27 07:35:00	AAPL	Stock	38.4125	38.4125	38.4	38.4	8400.0
2017-09-27 07:40:00	AAPL	Stock	38.4175	38.4175	38.3875	38.3875	34468.0
2017-09-27 07:45:00	AAPL	Stock	38.385	38.3875	38.3375	38.35	28948.0
2017-09-27 07:50:00	AAPL	Stock	38.35	38.35	38.3375	38.35	13732.0
2017-09-27 07:55:00	AAPL	Stock	38.3375	38.3375	38.335	38.335	6512.0
2017-09-27 08:00:00	AAPL	Stock	38.5375	38.6225	38.3375	38.3725	82056.0
2017-09-27 08:05:00	AAPL	Stock	38.375	38.4525	38.375	38.4525	94828.0
2017-09-27 08:10:00	AAPL	Stock	38.4575	38.475	38.42	38.47	107100.0
2017-09-27 08:15:00	AAPL	Stock	38.47	38.485	38.45	38.4825	32056.0
2017-09-27 08:20:00	AAPL	Stock	38.4725	38.4725	38.425	38.425	26900.0
2017-09-27 08:25:00	AAPL	Stock	38.425	38.425	38.4175	38.425	60404.0
2017-09-27 08:30:00	AAPL	Stock	38.4025	38.425	38.3975	38.4225	35500.0
2017-09-27 08:35:00	AAPL	Stock	38.4075	38.425	38.4075	38.4125	28640.0
2017-09-27 08:40:00	AAPL	Stock	38.4225	38.425	38.4125	38.425	11840.0
2017-09-27 08:45:00	AAPL	Stock	38.425	38.425	38.41	38.425	19780.0
2017-09-27 08:50:00	AAPL	Stock	38.4225	38.45	38.42	38.4375	39476.0
2017-09-27 08:55:00	AAPL	Stock	38.4375	38.4575	38.3775	38.405	67152.0
2017-09-27 09:00:00	AAPL	Stock	38.39	38.4025	38.39	38.3975	22444.0
2017-09-27 09:05:00	AAPL	Stock	38.4	38.405	38.3875	38.405	28032.0
2017-09-27 09:10:00	AAPL	Stock	38.405	38.42	38.405	38.42	42632.0
2017-09-27 09:15:00	AAPL	Stock	38.42	38.425	38.4125	38.42	31248.0
2017-09-27 09:20:00	AAPL	Stock	38.4225	38.44	38.3875	38.3875	93356.0
2017-09-27 09:25:00	AAPL	Stock	38.3975	38.4725	38.35	38.4475	358780.0
2017-09-27 09:30:00	AAPL	Stock	38.45	38.63	38.4025	38.6032	6937388.0
2017-09-27 09:35:00	AAPL	Stock	38.605	38.645	38.5625	38.605	3284404.0
2017-09-27 09:40:00	AAPL	Stock	38.605	38.6675	38.5975	38.62	3313052.0
2017-09-27 09:45:00	AAPL	Stock	38.6225	38.6675	38.575	38.5775	2274460.0

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

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