PREVIEW / stock_5min / 2014-06-24

all stock 5-min files

  file:    by_date/stock_5min/2014/2014-06-24.parquet
  size:    5.5 MB
  rows:    366,549
  symbols: 3,573

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-06-24 04:00:00	AAPL	Stock	22.67	22.67	22.67	22.67	400.0
2014-06-24 05:00:00	AAPL	Stock	22.6925	22.6925	22.6925	22.6925	1024.0
2014-06-24 05:15:00	AAPL	Stock	22.695	22.695	22.6925	22.6925	6288.0
2014-06-24 05:25:00	AAPL	Stock	22.67	22.67	22.67	22.67	1564.0
2014-06-24 05:30:00	AAPL	Stock	22.665	22.665	22.665	22.665	3200.0
2014-06-24 05:35:00	AAPL	Stock	22.665	22.675	22.665	22.675	1600.0
2014-06-24 05:40:00	AAPL	Stock	22.685	22.685	22.685	22.685	400.0
2014-06-24 05:45:00	AAPL	Stock	22.68	22.68	22.68	22.68	400.0
2014-06-24 05:55:00	AAPL	Stock	22.675	22.675	22.675	22.675	3200.0
2014-06-24 06:00:00	AAPL	Stock	22.685	22.69	22.685	22.69	2000.0
2014-06-24 06:15:00	AAPL	Stock	22.6825	22.6825	22.6825	22.6825	420.0
2014-06-24 06:55:00	AAPL	Stock	22.6925	22.695	22.6925	22.695	2220.0
2014-06-24 07:00:00	AAPL	Stock	22.7	22.705	22.7	22.705	996.0
2014-06-24 07:05:00	AAPL	Stock	22.71	22.71	22.71	22.71	640.0
2014-06-24 07:10:00	AAPL	Stock	22.7125	22.7125	22.7125	22.7125	800.0
2014-06-24 07:15:00	AAPL	Stock	22.7125	22.7125	22.7125	22.7125	800.0
2014-06-24 07:20:00	AAPL	Stock	22.72	22.72	22.7175	22.72	3200.0
2014-06-24 07:30:00	AAPL	Stock	22.715	22.715	22.7125	22.7125	15600.0
2014-06-24 07:35:00	AAPL	Stock	22.715	22.72	22.715	22.7175	14840.0
2014-06-24 07:40:00	AAPL	Stock	22.7225	22.7275	22.7225	22.7225	9200.0
2014-06-24 07:45:00	AAPL	Stock	22.725	22.725	22.7225	22.7225	2000.0
2014-06-24 07:50:00	AAPL	Stock	22.7275	22.7375	22.7275	22.7375	29020.0
2014-06-24 07:55:00	AAPL	Stock	22.735	22.7425	22.735	22.74	26324.0
2014-06-24 08:00:00	AAPL	Stock	22.7375	22.7425	22.6975	22.725	108380.0
2014-06-24 08:05:00	AAPL	Stock	22.725	22.73	22.725	22.73	30432.0
2014-06-24 08:10:00	AAPL	Stock	22.7325	22.7325	22.7325	22.7325	6400.0
2014-06-24 08:15:00	AAPL	Stock	22.7325	22.74	22.7325	22.74	24800.0
2014-06-24 08:20:00	AAPL	Stock	22.74	22.74	22.7375	22.7375	9872.0
2014-06-24 08:25:00	AAPL	Stock	22.7375	22.7375	22.7225	22.725	56108.0
2014-06-24 08:30:00	AAPL	Stock	22.725	22.725	22.7125	22.7125	9580.0
2014-06-24 08:35:00	AAPL	Stock	22.715	22.73	22.715	22.725	22324.0
2014-06-24 08:40:00	AAPL	Stock	22.7275	22.7325	22.72	22.725	13284.0
2014-06-24 08:45:00	AAPL	Stock	22.72	22.7275	22.72	22.725	20336.0
2014-06-24 08:50:00	AAPL	Stock	22.725	22.7325	22.725	22.7325	46632.0
2014-06-24 08:55:00	AAPL	Stock	22.7275	22.73	22.7275	22.73	20520.0
2014-06-24 09:00:00	AAPL	Stock	22.7275	22.73	22.7275	22.73	16712.0
2014-06-24 09:05:00	AAPL	Stock	22.73	22.7325	22.7275	22.7275	10228.0
2014-06-24 09:10:00	AAPL	Stock	22.7275	22.7275	22.72	22.72	36300.0
2014-06-24 09:15:00	AAPL	Stock	22.725	22.7275	22.7075	22.7075	30696.0
2014-06-24 09:20:00	AAPL	Stock	22.7	22.71	22.7	22.7025	49088.0
2014-06-24 09:25:00	AAPL	Stock	22.7125	22.7275	22.6875	22.6925	135220.0
2014-06-24 09:30:00	AAPL	Stock	22.695	22.8325	22.66	22.78	7619096.0
2014-06-24 09:35:00	AAPL	Stock	22.7775	22.81	22.7625	22.775	3612160.0
2014-06-24 09:40:00	AAPL	Stock	22.7775	22.8225	22.77	22.795	3106816.0
2014-06-24 09:45:00	AAPL	Stock	22.7958	22.8275	22.775	22.78	2926896.0
2014-06-24 09:50:00	AAPL	Stock	22.78	22.78	22.75	22.7648	1791644.0
2014-06-24 09:55:00	AAPL	Stock	22.7625	22.79	22.76	22.79	1482640.0
2014-06-24 10:00:00	AAPL	Stock	22.7875	22.8575	22.7875	22.8425	3242600.0
2014-06-24 10:05:00	AAPL	Stock	22.8425	22.8575	22.83	22.8575	3379984.0
2014-06-24 10:10:00	AAPL	Stock	22.8575	22.885	22.84	22.8738	3536480.0

> showing 50 of 366,549 rows — these rows as CSV

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