PREVIEW / stock_30min / 2014-04-09

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-09.parquet
  size:    1.6 MB
  rows:    82,017
  symbols: 3,531

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-04-09 04:00:00	AAPL	Stock	18.7493	18.7493	18.7493	18.7493	2800.0
2014-04-09 07:00:00	AAPL	Stock	18.7736	18.7736	18.7736	18.7736	3836.0
2014-04-09 08:00:00	AAPL	Stock	18.7661	18.7675	18.745	18.7525	188132.0
2014-04-09 08:30:00	AAPL	Stock	18.7439	18.7461	18.7139	18.715	391020.0
2014-04-09 09:00:00	AAPL	Stock	18.7196	18.73	18.6643	18.6707	678776.0
2014-04-09 09:30:00	AAPL	Stock	18.6625	18.8111	18.6436	18.7507	34073116.0
2014-04-09 10:00:00	AAPL	Stock	18.7539	18.7807	18.6993	18.7357	15830640.0
2014-04-09 10:30:00	AAPL	Stock	18.7361	18.835	18.7261	18.8208	14615580.0
2014-04-09 11:00:00	AAPL	Stock	18.8214	18.8579	18.8018	18.8468	10879512.0
2014-04-09 11:30:00	AAPL	Stock	18.8468	18.8546	18.8139	18.8139	6593832.0
2014-04-09 12:00:00	AAPL	Stock	18.8146	18.8241	18.7929	18.8193	5566204.0
2014-04-09 12:30:00	AAPL	Stock	18.8196	18.8336	18.8096	18.8232	5254732.0
2014-04-09 13:00:00	AAPL	Stock	18.8264	18.8318	18.7936	18.805	4038524.0
2014-04-09 13:30:00	AAPL	Stock	18.804	18.8182	18.785	18.7875	4315248.0
2014-04-09 14:00:00	AAPL	Stock	18.7868	18.8689	18.7868	18.8525	11710328.0
2014-04-09 14:30:00	AAPL	Stock	18.8543	18.8807	18.8543	18.8671	8733368.0
2014-04-09 15:00:00	AAPL	Stock	18.8654	18.9139	18.8621	18.9043	10220420.0
2014-04-09 15:30:00	AAPL	Stock	18.905	18.9461	18.905	18.9395	22179164.0
2014-04-09 16:00:00	AAPL	Stock	18.9393	18.9443	18.8187	18.9393	7152404.0
2014-04-09 16:30:00	AAPL	Stock	18.925	18.9431	18.7857	18.9431	147924.0
2014-04-09 17:00:00	AAPL	Stock	18.9393	18.9393	18.915	18.9393	505064.0
2014-04-09 17:30:00	AAPL	Stock	18.92	18.9286	18.92	18.9286	28000.0
2014-04-09 18:00:00	AAPL	Stock	18.9286	18.9393	18.9286	18.9286	485744.0
2014-04-09 18:30:00	AAPL	Stock	18.9346	18.9375	18.9346	18.9357	51436.0
2014-04-09 19:00:00	AAPL	Stock	18.9375	18.9375	18.9375	18.9375	2800.0
2014-04-09 19:30:00	AAPL	Stock	18.9389	18.9554	18.9286	18.9554	99344.0
2014-04-09 08:00:00	MSFT	Stock	39.95	39.98	39.95	39.98	4195.0
2014-04-09 08:30:00	MSFT	Stock	39.98	40.07	39.98	40.03	1803.0
2014-04-09 09:00:00	MSFT	Stock	40.05	40.09	39.93	39.93	5131.0
2014-04-09 09:30:00	MSFT	Stock	39.93	40.345	39.88	40.146	4377897.0
2014-04-09 10:00:00	MSFT	Stock	40.14	40.3	39.99	40.25	1807787.0
2014-04-09 10:30:00	MSFT	Stock	40.24	40.37	40.04	40.06	1576330.0
2014-04-09 11:00:00	MSFT	Stock	40.06	40.09	39.9	39.95	1623073.0
2014-04-09 11:30:00	MSFT	Stock	39.95	40.04	39.94	39.98	881412.0
2014-04-09 12:00:00	MSFT	Stock	39.98	40.09	39.91	40.045	853426.0
2014-04-09 12:30:00	MSFT	Stock	40.05	40.18	40.03	40.15	1048787.0
2014-04-09 13:00:00	MSFT	Stock	40.15	40.17	40.12	40.14	534907.0
2014-04-09 13:30:00	MSFT	Stock	40.146	40.21	40.09	40.2	973033.0
2014-04-09 14:00:00	MSFT	Stock	40.195	40.48	40.19	40.43	2343410.0
2014-04-09 14:30:00	MSFT	Stock	40.43	40.48	40.3	40.33	1382100.0
2014-04-09 15:00:00	MSFT	Stock	40.32	40.46	40.3	40.42	1384326.0
2014-04-09 15:30:00	MSFT	Stock	40.42	40.55	40.4	40.47	4022139.0
2014-04-09 16:00:00	MSFT	Stock	40.47	40.53	40.259	40.47	2312085.0
2014-04-09 16:30:00	MSFT	Stock	40.53	40.53	40.13	40.478	29375.0
2014-04-09 17:00:00	MSFT	Stock	40.47	40.51	40.47	40.47	61158.0
2014-04-09 17:30:00	MSFT	Stock	40.359	40.359	40.359	40.359	113.0
2014-04-09 18:00:00	MSFT	Stock	40.51	40.51	40.47	40.47	59520.0
2014-04-09 18:30:00	MSFT	Stock	40.53	40.53	40.53	40.53	350.0
2014-04-09 19:00:00	MSFT	Stock	40.53	40.53	40.52	40.53	4911.0
2014-04-09 19:30:00	MSFT	Stock	40.5	40.52	40.49	40.49	1850.0

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

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