PREVIEW / stock_5min / 2018-04-23

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-04-23.parquet
  size:    5.3 MB
  rows:    345,941
  symbols: 2,854

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-04-23 04:05:00	AAPL	Stock	41.505	41.505	41.505	41.505	1600.0
2018-04-23 04:10:00	AAPL	Stock	41.505	41.505	41.505	41.505	400.0
2018-04-23 04:15:00	AAPL	Stock	41.505	41.505	41.5	41.5	1200.0
2018-04-23 04:25:00	AAPL	Stock	41.5	41.5	41.5	41.5	400.0
2018-04-23 05:15:00	AAPL	Stock	41.525	41.525	41.525	41.525	400.0
2018-04-23 05:40:00	AAPL	Stock	41.5475	41.5475	41.5475	41.5475	400.0
2018-04-23 05:50:00	AAPL	Stock	41.535	41.535	41.5325	41.5325	1600.0
2018-04-23 05:55:00	AAPL	Stock	41.525	41.525	41.525	41.525	3328.0
2018-04-23 06:00:00	AAPL	Stock	41.525	41.525	41.5	41.5	1036.0
2018-04-23 06:15:00	AAPL	Stock	41.525	41.525	41.525	41.525	400.0
2018-04-23 06:35:00	AAPL	Stock	41.595	41.6125	41.595	41.6125	4388.0
2018-04-23 06:50:00	AAPL	Stock	41.6625	41.6675	41.6625	41.6675	12000.0
2018-04-23 06:55:00	AAPL	Stock	41.65	41.6625	41.65	41.6625	10000.0
2018-04-23 07:00:00	AAPL	Stock	41.6375	41.7075	41.6375	41.6875	33424.0
2018-04-23 07:05:00	AAPL	Stock	41.7125	41.7125	41.655	41.6925	5012.0
2018-04-23 07:10:00	AAPL	Stock	41.69	41.69	41.6575	41.69	6688.0
2018-04-23 07:15:00	AAPL	Stock	41.6875	41.735	41.68	41.69	67808.0
2018-04-23 07:20:00	AAPL	Stock	41.6875	41.71	41.655	41.655	62876.0
2018-04-23 07:25:00	AAPL	Stock	41.655	41.725	41.6225	41.7125	100552.0
2018-04-23 07:30:00	AAPL	Stock	41.7175	41.7375	41.695	41.7125	30448.0
2018-04-23 07:35:00	AAPL	Stock	41.7025	41.7425	41.7025	41.74	23376.0
2018-04-23 07:40:00	AAPL	Stock	41.745	41.805	41.745	41.8025	53572.0
2018-04-23 07:45:00	AAPL	Stock	41.765	41.8	41.7625	41.8	22932.0
2018-04-23 07:50:00	AAPL	Stock	41.7775	41.78	41.7625	41.775	16100.0
2018-04-23 07:55:00	AAPL	Stock	41.775	41.785	41.7625	41.775	15400.0
2018-04-23 08:00:00	AAPL	Stock	41.775	41.815	41.625	41.78	178416.0
2018-04-23 08:05:00	AAPL	Stock	41.7625	41.7925	41.75	41.78	68612.0
2018-04-23 08:10:00	AAPL	Stock	41.78	41.7875	41.75	41.785	87696.0
2018-04-23 08:15:00	AAPL	Stock	41.7675	41.7675	41.7375	41.75	71512.0
2018-04-23 08:20:00	AAPL	Stock	41.7475	41.75	41.7	41.725	129692.0
2018-04-23 08:25:00	AAPL	Stock	41.7275	41.7625	41.7275	41.7375	39348.0
2018-04-23 08:30:00	AAPL	Stock	41.7275	41.75	41.7	41.7125	87268.0
2018-04-23 08:35:00	AAPL	Stock	41.7125	41.75	41.7125	41.75	93216.0
2018-04-23 08:40:00	AAPL	Stock	41.7375	41.75	41.725	41.75	21072.0
2018-04-23 08:45:00	AAPL	Stock	41.7375	41.7425	41.7	41.7025	43824.0
2018-04-23 08:50:00	AAPL	Stock	41.7	41.7	41.685	41.7	34080.0
2018-04-23 08:55:00	AAPL	Stock	41.7125	41.7125	41.6625	41.6625	84168.0
2018-04-23 09:00:00	AAPL	Stock	41.6625	41.6775	41.6575	41.67	74504.0
2018-04-23 09:05:00	AAPL	Stock	41.6775	41.6975	41.6625	41.695	18292.0
2018-04-23 09:10:00	AAPL	Stock	41.6875	41.7125	41.6875	41.69	21820.0
2018-04-23 09:15:00	AAPL	Stock	41.6925	41.7375	41.6925	41.7	137700.0
2018-04-23 09:20:00	AAPL	Stock	41.7175	41.725	41.7025	41.7075	32920.0
2018-04-23 09:25:00	AAPL	Stock	41.7175	41.7375	41.6675	41.725	125624.0
2018-04-23 09:30:00	AAPL	Stock	41.7025	41.73	41.5125	41.5355	7085120.0
2018-04-23 09:35:00	AAPL	Stock	41.5325	41.645	41.5	41.54	3256160.0
2018-04-23 09:40:00	AAPL	Stock	41.5425	41.5675	41.4725	41.5045	2945304.0
2018-04-23 09:45:00	AAPL	Stock	41.5025	41.5625	41.41	41.4263	2783568.0
2018-04-23 09:50:00	AAPL	Stock	41.4263	41.4263	41.3025	41.3545	2590080.0
2018-04-23 09:55:00	AAPL	Stock	41.355	41.4925	41.3525	41.48	2132024.0
2018-04-23 10:00:00	AAPL	Stock	41.4775	41.5375	41.4525	41.4725	1823932.0

> showing 50 of 345,941 rows — these rows as CSV

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