PREVIEW / stock_30min / 2014-06-10

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-10.parquet
  size:    1.6 MB
  rows:    82,395
  symbols: 3,552

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-10 04:00:00	AAPL	Stock	23.45	23.6075	23.45	23.5475	121224.0
2014-06-10 04:30:00	AAPL	Stock	23.55	23.56	23.5375	23.56	35600.0
2014-06-10 05:00:00	AAPL	Stock	23.55	23.625	23.55	23.6	86800.0
2014-06-10 05:30:00	AAPL	Stock	23.5875	23.5975	23.54	23.55	54300.0
2014-06-10 06:00:00	AAPL	Stock	23.55	23.5725	23.5225	23.5675	116920.0
2014-06-10 06:30:00	AAPL	Stock	23.5675	23.5675	23.525	23.535	45212.0
2014-06-10 07:00:00	AAPL	Stock	23.525	23.5375	23.48	23.4925	122140.0
2014-06-10 07:30:00	AAPL	Stock	23.495	23.5	23.45	23.49	228972.0
2014-06-10 08:00:00	AAPL	Stock	23.4925	23.5875	23.45	23.495	515080.0
2014-06-10 08:30:00	AAPL	Stock	23.4925	23.5125	23.48	23.5125	322332.0
2014-06-10 09:00:00	AAPL	Stock	23.515	23.68	23.5025	23.68	2502652.0
2014-06-10 09:30:00	AAPL	Stock	23.655	23.7625	23.5375	23.575	59986556.0
2014-06-10 10:00:00	AAPL	Stock	23.575	23.6375	23.525	23.58	24917104.0
2014-06-10 10:30:00	AAPL	Stock	23.5825	23.6125	23.475	23.575	22593488.0
2014-06-10 11:00:00	AAPL	Stock	23.575	23.63	23.5368	23.5625	13910996.0
2014-06-10 11:30:00	AAPL	Stock	23.5622	23.565	23.4375	23.4975	16560524.0
2014-06-10 12:00:00	AAPL	Stock	23.4975	23.4992	23.3925	23.4565	13275136.0
2014-06-10 12:30:00	AAPL	Stock	23.4562	23.485	23.4025	23.45	9632904.0
2014-06-10 13:00:00	AAPL	Stock	23.45	23.49	23.415	23.4448	7688600.0
2014-06-10 13:30:00	AAPL	Stock	23.4425	23.505	23.44	23.4975	7806768.0
2014-06-10 14:00:00	AAPL	Stock	23.495	23.55	23.48	23.54	8769924.0
2014-06-10 14:30:00	AAPL	Stock	23.54	23.5625	23.5172	23.5495	7698504.0
2014-06-10 15:00:00	AAPL	Stock	23.5475	23.565	23.525	23.5475	8167032.0
2014-06-10 15:30:00	AAPL	Stock	23.547	23.5625	23.5325	23.5625	16894488.0
2014-06-10 16:00:00	AAPL	Stock	23.5625	23.5725	23.5435	23.565	6612224.0
2014-06-10 16:30:00	AAPL	Stock	23.5575	23.575	23.5575	23.5625	106196.0
2014-06-10 17:00:00	AAPL	Stock	23.5625	23.57	23.5575	23.5625	96940.0
2014-06-10 17:30:00	AAPL	Stock	23.5625	23.5675	23.5575	23.5625	62288.0
2014-06-10 18:00:00	AAPL	Stock	23.5625	23.5675	23.5575	23.565	90364.0
2014-06-10 18:30:00	AAPL	Stock	23.565	23.5675	23.55	23.56	34704.0
2014-06-10 19:00:00	AAPL	Stock	23.5625	23.5625	23.5575	23.56	22476.0
2014-06-10 19:30:00	AAPL	Stock	23.5575	23.575	23.55	23.5725	179212.0
2014-06-10 07:00:00	MSFT	Stock	41.13	41.13	41.13	41.13	100.0
2014-06-10 07:30:00	MSFT	Stock	41.16	41.16	41.16	41.16	100.0
2014-06-10 08:00:00	MSFT	Stock	41.05	41.05	41.05	41.05	227.0
2014-06-10 08:30:00	MSFT	Stock	41.09	41.15	41.08	41.15	1800.0
2014-06-10 09:00:00	MSFT	Stock	41.16	41.16	40.96	40.99	13536.0
2014-06-10 09:30:00	MSFT	Stock	41.0	41.05	40.86	41.0	2692753.0
2014-06-10 10:00:00	MSFT	Stock	41.01	41.126	41.0	41.07	1242450.0
2014-06-10 10:30:00	MSFT	Stock	41.07	41.14	41.02	41.134	696948.0
2014-06-10 11:00:00	MSFT	Stock	41.13	41.16	41.05	41.05	558467.0
2014-06-10 11:30:00	MSFT	Stock	41.06	41.08	41.021	41.07	495605.0
2014-06-10 12:00:00	MSFT	Stock	41.07	41.1	41.04	41.095	406152.0
2014-06-10 12:30:00	MSFT	Stock	41.1	41.13	41.06	41.1	497996.0
2014-06-10 13:00:00	MSFT	Stock	41.11	41.11	41.02	41.05	445289.0
2014-06-10 13:30:00	MSFT	Stock	41.05	41.11	41.03	41.103	528906.0
2014-06-10 14:00:00	MSFT	Stock	41.1	41.109	41.06	41.1	532608.0
2014-06-10 14:30:00	MSFT	Stock	41.1	41.1	41.015	41.028	653116.0
2014-06-10 15:00:00	MSFT	Stock	41.025	41.09	41.02	41.09	665627.0
2014-06-10 15:30:00	MSFT	Stock	41.09	41.14	41.03	41.11	2391930.0

> showing 50 of 82,395 rows — these rows as CSV

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