PREVIEW / stock_30min / 2014-06-25

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-25.parquet
  size:    1.6 MB
  rows:    81,807
  symbols: 3,564

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-25 04:00:00	AAPL	Stock	22.6025	22.6025	22.57	22.575	2000.0
2014-06-25 04:30:00	AAPL	Stock	22.575	22.575	22.53	22.535	17872.0
2014-06-25 05:00:00	AAPL	Stock	22.535	22.54	22.51	22.51	20276.0
2014-06-25 05:30:00	AAPL	Stock	22.5275	22.555	22.5275	22.545	13960.0
2014-06-25 06:00:00	AAPL	Stock	22.555	22.5575	22.5375	22.5525	37100.0
2014-06-25 06:30:00	AAPL	Stock	22.5325	22.54	22.5125	22.525	33384.0
2014-06-25 07:00:00	AAPL	Stock	22.53	22.5875	22.53	22.5825	39648.0
2014-06-25 07:30:00	AAPL	Stock	22.5875	22.59	22.58	22.58	18000.0
2014-06-25 08:00:00	AAPL	Stock	22.5825	22.625	22.555	22.6075	278108.0
2014-06-25 08:30:00	AAPL	Stock	22.605	22.605	22.555	22.5825	311840.0
2014-06-25 09:00:00	AAPL	Stock	22.575	22.59	22.545	22.57	432284.0
2014-06-25 09:30:00	AAPL	Stock	22.5625	22.675	22.4125	22.635	30325912.0
2014-06-25 10:00:00	AAPL	Stock	22.635	22.6375	22.475	22.4925	12929060.0
2014-06-25 10:30:00	AAPL	Stock	22.4925	22.5225	22.42	22.5197	13475048.0
2014-06-25 11:00:00	AAPL	Stock	22.52	22.61	22.5	22.61	10959756.0
2014-06-25 11:30:00	AAPL	Stock	22.61	22.645	22.5525	22.5748	8089128.0
2014-06-25 12:00:00	AAPL	Stock	22.575	22.5925	22.5325	22.5725	4808704.0
2014-06-25 12:30:00	AAPL	Stock	22.5725	22.61	22.5588	22.585	4562220.0
2014-06-25 13:00:00	AAPL	Stock	22.5875	22.6325	22.5775	22.5875	5310428.0
2014-06-25 13:30:00	AAPL	Stock	22.59	22.6125	22.5625	22.569	4560080.0
2014-06-25 14:00:00	AAPL	Stock	22.57	22.5825	22.555	22.565	4187316.0
2014-06-25 14:30:00	AAPL	Stock	22.5662	22.5675	22.505	22.5475	6679548.0
2014-06-25 15:00:00	AAPL	Stock	22.545	22.61	22.5425	22.5825	6109064.0
2014-06-25 15:30:00	AAPL	Stock	22.58	22.6225	22.5775	22.59	10388064.0
2014-06-25 16:00:00	AAPL	Stock	22.59	22.605	22.5215	22.59	9934212.0
2014-06-25 16:30:00	AAPL	Stock	22.59	22.59	22.565	22.59	526924.0
2014-06-25 17:00:00	AAPL	Stock	22.575	22.59	22.57	22.5725	289840.0
2014-06-25 17:30:00	AAPL	Stock	22.575	22.5875	22.575	22.5875	14832.0
2014-06-25 18:00:00	AAPL	Stock	22.575	22.59	22.575	22.59	38136.0
2014-06-25 18:30:00	AAPL	Stock	22.585	22.585	22.575	22.575	9080.0
2014-06-25 19:00:00	AAPL	Stock	22.5825	22.5875	22.58	22.58	30056.0
2014-06-25 19:30:00	AAPL	Stock	22.5875	22.5875	22.5775	22.5875	20856.0
2014-06-25 07:00:00	MSFT	Stock	41.51	41.51	41.51	41.51	200.0
2014-06-25 07:30:00	MSFT	Stock	41.69	41.69	41.69	41.69	700.0
2014-06-25 08:00:00	MSFT	Stock	41.69	41.69	41.69	41.69	123.0
2014-06-25 08:30:00	MSFT	Stock	41.67	41.67	41.67	41.67	200.0
2014-06-25 09:00:00	MSFT	Stock	41.66	41.71	41.58	41.7	6099.0
2014-06-25 09:30:00	MSFT	Stock	41.7	41.99	41.46	41.571	1866948.0
2014-06-25 10:00:00	MSFT	Stock	41.58	41.88	41.51	41.595	1182756.0
2014-06-25 10:30:00	MSFT	Stock	41.6	41.825	41.59	41.81	1197529.0
2014-06-25 11:00:00	MSFT	Stock	41.81	41.845	41.69	41.71	991678.0
2014-06-25 11:30:00	MSFT	Stock	41.72	41.73	41.64	41.69	863432.0
2014-06-25 12:00:00	MSFT	Stock	41.69	41.75	41.66	41.74	471734.0
2014-06-25 12:30:00	MSFT	Stock	41.75	41.75	41.71	41.74	656805.0
2014-06-25 13:00:00	MSFT	Stock	41.735	41.83	41.73	41.82	806314.0
2014-06-25 13:30:00	MSFT	Stock	41.82	41.91	41.77	41.89	620318.0
2014-06-25 14:00:00	MSFT	Stock	41.88	41.91	41.86	41.884	630332.0
2014-06-25 14:30:00	MSFT	Stock	41.887	41.94	41.86	41.91	896294.0
2014-06-25 15:00:00	MSFT	Stock	41.91	41.99	41.89	41.98	1391135.0
2014-06-25 15:30:00	MSFT	Stock	41.98	42.05	41.95	42.02	4069150.0

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

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