PREVIEW / stock_5min / 2014-09-10

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-09-10.parquet
  size:    5.4 MB
  rows:    358,807
  symbols: 3,569

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-10 04:00:00	AAPL	Stock	23.475	24.6	23.475	24.205	33020.0
2014-09-10 04:05:00	AAPL	Stock	24.2025	24.245	24.2025	24.225	45468.0
2014-09-10 04:10:00	AAPL	Stock	24.22	24.2425	24.22	24.2225	17316.0
2014-09-10 04:15:00	AAPL	Stock	24.22	24.245	24.22	24.23	5200.0
2014-09-10 04:20:00	AAPL	Stock	24.245	24.25	24.2375	24.2375	27000.0
2014-09-10 04:25:00	AAPL	Stock	24.265	24.29	24.2625	24.2625	20520.0
2014-09-10 04:30:00	AAPL	Stock	24.2675	24.2675	24.2625	24.2625	12800.0
2014-09-10 04:35:00	AAPL	Stock	24.2525	24.2525	24.24	24.2425	5200.0
2014-09-10 04:40:00	AAPL	Stock	24.2475	24.2525	24.2275	24.235	7200.0
2014-09-10 04:45:00	AAPL	Stock	24.2275	24.26	24.2275	24.26	4000.0
2014-09-10 04:50:00	AAPL	Stock	24.2875	24.31	24.2875	24.2875	14400.0
2014-09-10 04:55:00	AAPL	Stock	24.29	24.345	24.26	24.325	45292.0
2014-09-10 05:00:00	AAPL	Stock	24.345	24.4125	24.345	24.4	70892.0
2014-09-10 05:05:00	AAPL	Stock	24.4	24.405	24.3925	24.3925	2400.0
2014-09-10 05:10:00	AAPL	Stock	24.3975	24.3975	24.3825	24.3825	5200.0
2014-09-10 05:15:00	AAPL	Stock	24.39	24.4	24.39	24.4	3880.0
2014-09-10 05:20:00	AAPL	Stock	24.4125	24.4125	24.3875	24.3875	2724.0
2014-09-10 05:25:00	AAPL	Stock	24.3875	24.4375	24.3875	24.4375	26112.0
2014-09-10 05:30:00	AAPL	Stock	24.43	24.43	24.43	24.43	400.0
2014-09-10 05:35:00	AAPL	Stock	24.445	24.4475	24.4175	24.4375	10000.0
2014-09-10 05:40:00	AAPL	Stock	24.425	24.425	24.4	24.4	8668.0
2014-09-10 05:45:00	AAPL	Stock	24.3875	24.425	24.3875	24.3875	5100.0
2014-09-10 05:50:00	AAPL	Stock	24.3875	24.3875	24.3875	24.3875	3600.0
2014-09-10 05:55:00	AAPL	Stock	24.3875	24.4125	24.3875	24.4125	10400.0
2014-09-10 06:00:00	AAPL	Stock	24.405	24.495	24.3925	24.485	44848.0
2014-09-10 06:05:00	AAPL	Stock	24.4575	24.4625	24.455	24.46	2000.0
2014-09-10 06:10:00	AAPL	Stock	24.4625	24.49	24.4625	24.49	40580.0
2014-09-10 06:15:00	AAPL	Stock	24.5	24.5675	24.5	24.555	24720.0
2014-09-10 06:20:00	AAPL	Stock	24.565	24.6175	24.5625	24.5625	51280.0
2014-09-10 06:25:00	AAPL	Stock	24.5625	24.6125	24.5625	24.5875	17200.0
2014-09-10 06:30:00	AAPL	Stock	24.585	24.5975	24.5625	24.5975	9600.0
2014-09-10 06:35:00	AAPL	Stock	24.5875	24.6175	24.5875	24.5875	16240.0
2014-09-10 06:40:00	AAPL	Stock	24.5875	24.5875	24.5625	24.5625	32060.0
2014-09-10 06:45:00	AAPL	Stock	24.5625	24.565	24.55	24.5525	13940.0
2014-09-10 06:50:00	AAPL	Stock	24.545	24.6425	24.545	24.6175	42940.0
2014-09-10 06:55:00	AAPL	Stock	24.6475	24.6625	24.625	24.64	18484.0
2014-09-10 07:00:00	AAPL	Stock	24.63	24.6475	24.5775	24.5875	87484.0
2014-09-10 07:05:00	AAPL	Stock	24.5875	24.5875	24.4625	24.5175	173204.0
2014-09-10 07:10:00	AAPL	Stock	24.5175	24.56	24.4675	24.525	133620.0
2014-09-10 07:15:00	AAPL	Stock	24.5375	24.6025	24.525	24.6	32420.0
2014-09-10 07:20:00	AAPL	Stock	24.6075	24.625	24.555	24.6175	237936.0
2014-09-10 07:25:00	AAPL	Stock	24.5975	24.6075	24.53	24.53	48644.0
2014-09-10 07:30:00	AAPL	Stock	24.53	24.5425	24.4625	24.485	194652.0
2014-09-10 07:35:00	AAPL	Stock	24.4975	24.53	24.4775	24.4875	175616.0
2014-09-10 07:40:00	AAPL	Stock	24.5	24.505	24.49	24.495	101884.0
2014-09-10 07:45:00	AAPL	Stock	24.49	24.49	24.38	24.3975	245972.0
2014-09-10 07:50:00	AAPL	Stock	24.3975	24.47	24.3375	24.3875	129404.0
2014-09-10 07:55:00	AAPL	Stock	24.3875	24.4	24.35	24.3875	149456.0
2014-09-10 08:00:00	AAPL	Stock	24.4125	24.6275	24.255	24.3225	704056.0
2014-09-10 08:05:00	AAPL	Stock	24.3225	24.4275	24.315	24.4	416360.0

> showing 50 of 358,807 rows — these rows as CSV

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