PREVIEW / stock_5min / 2018-11-09

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-11-09.parquet
  size:    5.6 MB
  rows:    351,031
  symbols: 2,733

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-11-09 04:00:00	AAPL	Stock	51.72	51.72	51.69	51.69	4216.0
2018-11-09 04:05:00	AAPL	Stock	51.6	51.625	51.6	51.625	8792.0
2018-11-09 04:50:00	AAPL	Stock	51.6075	51.6075	51.6075	51.6075	400.0
2018-11-09 05:00:00	AAPL	Stock	51.6175	51.6175	51.6175	51.6175	800.0
2018-11-09 05:05:00	AAPL	Stock	51.7175	51.725	51.7175	51.725	8128.0
2018-11-09 05:20:00	AAPL	Stock	51.7	51.7	51.7	51.7	832.0
2018-11-09 05:25:00	AAPL	Stock	51.675	51.675	51.675	51.675	2000.0
2018-11-09 05:40:00	AAPL	Stock	51.65	51.65	51.625	51.625	3296.0
2018-11-09 05:45:00	AAPL	Stock	51.625	51.625	51.625	51.625	400.0
2018-11-09 05:55:00	AAPL	Stock	51.6	51.625	51.6	51.625	2400.0
2018-11-09 06:00:00	AAPL	Stock	51.585	51.5875	51.5825	51.5825	2992.0
2018-11-09 06:15:00	AAPL	Stock	51.535	51.55	51.5175	51.545	6592.0
2018-11-09 06:20:00	AAPL	Stock	51.5625	51.5625	51.5625	51.5625	1200.0
2018-11-09 06:30:00	AAPL	Stock	51.5375	51.5375	51.5175	51.5175	5824.0
2018-11-09 06:40:00	AAPL	Stock	51.5	51.5	51.48	51.4825	3200.0
2018-11-09 06:45:00	AAPL	Stock	51.525	51.555	51.525	51.555	1500.0
2018-11-09 06:50:00	AAPL	Stock	51.5775	51.6225	51.5125	51.5125	5200.0
2018-11-09 06:55:00	AAPL	Stock	51.52	51.52	51.505	51.5125	7200.0
2018-11-09 07:00:00	AAPL	Stock	51.565	51.625	51.525	51.615	31624.0
2018-11-09 07:05:00	AAPL	Stock	51.64	51.64	51.6225	51.6225	12840.0
2018-11-09 07:10:00	AAPL	Stock	51.6125	51.625	51.575	51.615	34832.0
2018-11-09 07:15:00	AAPL	Stock	51.615	51.6275	51.55	51.55	28692.0
2018-11-09 07:20:00	AAPL	Stock	51.5375	51.57	51.4825	51.5	71476.0
2018-11-09 07:25:00	AAPL	Stock	51.485	51.5325	51.485	51.5	23380.0
2018-11-09 07:30:00	AAPL	Stock	51.5075	51.545	51.49	51.5	56012.0
2018-11-09 07:35:00	AAPL	Stock	51.5175	51.525	51.5	51.525	39668.0
2018-11-09 07:40:00	AAPL	Stock	51.525	51.5625	51.5175	51.5175	18400.0
2018-11-09 07:45:00	AAPL	Stock	51.5125	51.525	51.41	51.485	57844.0
2018-11-09 07:50:00	AAPL	Stock	51.4575	51.4825	51.415	51.415	41636.0
2018-11-09 07:55:00	AAPL	Stock	51.44	51.44	51.395	51.425	27988.0
2018-11-09 08:00:00	AAPL	Stock	51.5375	51.66	51.4	51.4125	143976.0
2018-11-09 08:05:00	AAPL	Stock	51.4125	51.45	51.375	51.445	61200.0
2018-11-09 08:10:00	AAPL	Stock	51.4625	51.5125	51.45	51.5	26772.0
2018-11-09 08:15:00	AAPL	Stock	51.5	51.5375	51.4975	51.5375	28168.0
2018-11-09 08:20:00	AAPL	Stock	51.5125	51.525	51.4875	51.505	5560.0
2018-11-09 08:25:00	AAPL	Stock	51.4825	51.49	51.4625	51.4875	16860.0
2018-11-09 08:30:00	AAPL	Stock	51.48	51.48	51.425	51.445	43432.0
2018-11-09 08:35:00	AAPL	Stock	51.45	51.475	51.4375	51.44	47324.0
2018-11-09 08:40:00	AAPL	Stock	51.445	51.465	51.4375	51.455	27868.0
2018-11-09 08:45:00	AAPL	Stock	51.45	51.4675	51.425	51.4375	32040.0
2018-11-09 08:50:00	AAPL	Stock	51.4325	51.4925	51.425	51.4925	42784.0
2018-11-09 08:55:00	AAPL	Stock	51.485	51.485	51.45	51.485	35776.0
2018-11-09 09:00:00	AAPL	Stock	51.4675	51.5	51.435	51.475	66848.0
2018-11-09 09:05:00	AAPL	Stock	51.4725	51.495	51.45	51.45	85384.0
2018-11-09 09:10:00	AAPL	Stock	51.45	51.4575	51.425	51.445	57720.0
2018-11-09 09:15:00	AAPL	Stock	51.4475	51.4725	51.4375	51.44	36520.0
2018-11-09 09:20:00	AAPL	Stock	51.45	51.47	51.45	51.45	35372.0
2018-11-09 09:25:00	AAPL	Stock	51.475	51.4875	51.3775	51.3775	87908.0
2018-11-09 09:30:00	AAPL	Stock	51.3875	51.5025	51.27	51.2725	4880452.0
2018-11-09 09:35:00	AAPL	Stock	51.275	51.3	51.025	51.1638	5364556.0

> showing 50 of 351,031 rows — these rows as CSV

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