PREVIEW / stock_5min / 2014-09-04

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-09-04.parquet
  size:    5.4 MB
  rows:    354,599
  symbols: 3,590

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
2014-09-04 04:00:00	AAPL	Stock	25.0	25.0	24.7125	24.7125	9540.0
2014-09-04 04:10:00	AAPL	Stock	24.715	24.715	24.695	24.695	4696.0
2014-09-04 04:15:00	AAPL	Stock	24.7	24.7025	24.7	24.7025	800.0
2014-09-04 04:20:00	AAPL	Stock	24.695	24.695	24.5975	24.5975	21140.0
2014-09-04 04:25:00	AAPL	Stock	24.59	24.59	24.5025	24.565	170128.0
2014-09-04 04:30:00	AAPL	Stock	24.545	24.5575	24.425	24.425	35028.0
2014-09-04 04:35:00	AAPL	Stock	24.425	24.4375	24.125	24.1975	140880.0
2014-09-04 04:40:00	AAPL	Stock	24.1975	24.2125	24.1625	24.18	109492.0
2014-09-04 04:45:00	AAPL	Stock	24.18	24.2	24.18	24.1975	12800.0
2014-09-04 04:50:00	AAPL	Stock	24.1875	24.1875	24.1	24.1	73344.0
2014-09-04 04:55:00	AAPL	Stock	24.125	24.15	24.03	24.07	72648.0
2014-09-04 05:00:00	AAPL	Stock	24.0625	24.2175	24.0575	24.2125	85200.0
2014-09-04 05:05:00	AAPL	Stock	24.2125	24.3	24.2125	24.2875	21784.0
2014-09-04 05:10:00	AAPL	Stock	24.2875	24.2875	24.245	24.275	33220.0
2014-09-04 05:15:00	AAPL	Stock	24.275	24.275	24.25	24.2525	21700.0
2014-09-04 05:20:00	AAPL	Stock	24.25	24.2725	24.245	24.2525	55600.0
2014-09-04 05:25:00	AAPL	Stock	24.2525	24.325	24.2525	24.3025	73716.0
2014-09-04 05:30:00	AAPL	Stock	24.3125	24.35	24.295	24.3425	42188.0
2014-09-04 05:35:00	AAPL	Stock	24.345	24.4025	24.335	24.4025	57600.0
2014-09-04 05:40:00	AAPL	Stock	24.4	24.4175	24.3475	24.3475	39544.0
2014-09-04 05:45:00	AAPL	Stock	24.3575	24.4275	24.3575	24.4275	77336.0
2014-09-04 05:50:00	AAPL	Stock	24.41	24.41	24.4	24.4	8000.0
2014-09-04 05:55:00	AAPL	Stock	24.4	24.425	24.3725	24.3975	67876.0
2014-09-04 06:00:00	AAPL	Stock	24.3925	24.4025	24.3125	24.35	66660.0
2014-09-04 06:05:00	AAPL	Stock	24.3625	24.375	24.34	24.3725	22800.0
2014-09-04 06:10:00	AAPL	Stock	24.4	24.4	24.345	24.4	10612.0
2014-09-04 06:15:00	AAPL	Stock	24.4375	24.4825	24.4175	24.4825	25540.0
2014-09-04 06:20:00	AAPL	Stock	24.48	24.5	24.4425	24.465	57712.0
2014-09-04 06:25:00	AAPL	Stock	24.49	24.4925	24.4775	24.4775	20864.0
2014-09-04 06:30:00	AAPL	Stock	24.4775	24.4775	24.4375	24.455	21960.0
2014-09-04 06:35:00	AAPL	Stock	24.4625	24.4825	24.4625	24.475	19008.0
2014-09-04 06:40:00	AAPL	Stock	24.4625	24.4875	24.4525	24.4525	5652.0
2014-09-04 06:45:00	AAPL	Stock	24.4575	24.5	24.4575	24.495	32600.0
2014-09-04 06:50:00	AAPL	Stock	24.495	24.5625	24.495	24.5625	43548.0
2014-09-04 06:55:00	AAPL	Stock	24.5525	24.58	24.5075	24.5725	66088.0
2014-09-04 07:00:00	AAPL	Stock	24.5725	24.6	24.55	24.5975	64704.0
2014-09-04 07:05:00	AAPL	Stock	24.5975	24.6125	24.5625	24.5625	67020.0
2014-09-04 07:10:00	AAPL	Stock	24.5875	24.6	24.55	24.575	64904.0
2014-09-04 07:15:00	AAPL	Stock	24.575	24.5875	24.5325	24.5875	88084.0
2014-09-04 07:20:00	AAPL	Stock	24.5825	24.5875	24.57	24.575	22400.0
2014-09-04 07:25:00	AAPL	Stock	24.58	24.6225	24.58	24.6025	64816.0
2014-09-04 07:30:00	AAPL	Stock	24.61	24.6125	24.575	24.585	45772.0
2014-09-04 07:35:00	AAPL	Stock	24.5875	24.5875	24.565	24.5825	42676.0
2014-09-04 07:40:00	AAPL	Stock	24.58	24.6	24.565	24.5875	73424.0
2014-09-04 07:45:00	AAPL	Stock	24.5875	24.6	24.585	24.585	19836.0
2014-09-04 07:50:00	AAPL	Stock	24.595	24.65	24.575	24.65	139120.0
2014-09-04 07:55:00	AAPL	Stock	24.65	24.675	24.6125	24.6275	248576.0
2014-09-04 08:00:00	AAPL	Stock	24.5525	24.7375	24.4325	24.6625	615328.0
2014-09-04 08:05:00	AAPL	Stock	24.6575	24.675	24.6425	24.645	145104.0
2014-09-04 08:10:00	AAPL	Stock	24.65	24.6725	24.645	24.6725	124984.0

> showing 50 of 354,599 rows — these rows as CSV

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