PREVIEW / stock_30min / 2014-07-07

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-07.parquet
  size:    1.6 MB
  rows:    85,728
  symbols: 3,594

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-07-07 04:00:00	AAPL	Stock	23.5125	23.515	23.5125	23.515	6700.0
2014-07-07 04:30:00	AAPL	Stock	23.5125	23.5125	23.5025	23.5025	1600.0
2014-07-07 05:00:00	AAPL	Stock	23.4975	23.4975	23.4975	23.4975	400.0
2014-07-07 05:30:00	AAPL	Stock	23.515	23.515	23.51	23.51	1920.0
2014-07-07 06:00:00	AAPL	Stock	23.5175	23.5175	23.5175	23.5175	3200.0
2014-07-07 06:30:00	AAPL	Stock	23.5325	23.5325	23.525	23.525	4084.0
2014-07-07 07:00:00	AAPL	Stock	23.525	23.5475	23.525	23.525	25920.0
2014-07-07 07:30:00	AAPL	Stock	23.5225	23.5375	23.5125	23.5175	38016.0
2014-07-07 08:00:00	AAPL	Stock	23.5225	23.5475	23.4875	23.4925	311548.0
2014-07-07 08:30:00	AAPL	Stock	23.4875	23.5	23.475	23.495	207644.0
2014-07-07 09:00:00	AAPL	Stock	23.495	23.55	23.4925	23.5375	374708.0
2014-07-07 09:30:00	AAPL	Stock	23.535	23.7475	23.525	23.7475	32185944.0
2014-07-07 10:00:00	AAPL	Stock	23.7462	23.8025	23.69	23.7825	26507604.0
2014-07-07 10:30:00	AAPL	Stock	23.78	23.8675	23.7512	23.8462	20619928.0
2014-07-07 11:00:00	AAPL	Stock	23.8475	23.85	23.735	23.79	15286600.0
2014-07-07 11:30:00	AAPL	Stock	23.79	23.8275	23.69	23.695	11657060.0
2014-07-07 12:00:00	AAPL	Stock	23.695	23.7625	23.69	23.7375	8419032.0
2014-07-07 12:30:00	AAPL	Stock	23.7375	23.7825	23.72	23.7805	5510396.0
2014-07-07 13:00:00	AAPL	Stock	23.781	23.8225	23.76	23.81	7589720.0
2014-07-07 13:30:00	AAPL	Stock	23.81	23.8475	23.7875	23.845	6417776.0
2014-07-07 14:00:00	AAPL	Stock	23.8462	23.9062	23.8337	23.855	12686828.0
2014-07-07 14:30:00	AAPL	Stock	23.8525	23.9225	23.82	23.915	11037804.0
2014-07-07 15:00:00	AAPL	Stock	23.9125	23.9575	23.8975	23.935	13792496.0
2014-07-07 15:30:00	AAPL	Stock	23.935	23.9975	23.9125	23.9925	24420124.0
2014-07-07 16:00:00	AAPL	Stock	23.9925	24.0425	23.8062	24.0425	7322220.0
2014-07-07 16:30:00	AAPL	Stock	24.045	24.05	23.7628	24.045	375652.0
2014-07-07 17:00:00	AAPL	Stock	24.045	24.0925	23.887	24.075	697760.0
2014-07-07 17:30:00	AAPL	Stock	24.0725	24.0725	23.9925	24.065	5799736.0
2014-07-07 18:00:00	AAPL	Stock	24.07	24.0775	24.0625	24.0675	146628.0
2014-07-07 18:30:00	AAPL	Stock	24.07	24.0725	23.9925	24.0625	205104.0
2014-07-07 19:00:00	AAPL	Stock	24.065	24.0675	24.04	24.065	79188.0
2014-07-07 19:30:00	AAPL	Stock	24.0575	24.0725	24.05	24.0725	185484.0
2014-07-07 08:30:00	MSFT	Stock	41.61	41.61	41.6	41.6	852.0
2014-07-07 09:00:00	MSFT	Stock	41.71	41.76	41.7	41.74	31648.0
2014-07-07 09:30:00	MSFT	Stock	41.74	41.92	41.71	41.9	2534508.0
2014-07-07 10:00:00	MSFT	Stock	41.89	42.09	41.84	41.93	2069511.0
2014-07-07 10:30:00	MSFT	Stock	41.93	42.07	41.93	42.03	1704454.0
2014-07-07 11:00:00	MSFT	Stock	42.025	42.12	42.0	42.11	1651030.0
2014-07-07 11:30:00	MSFT	Stock	42.11	42.11	42.01	42.08	1491110.0
2014-07-07 12:00:00	MSFT	Stock	42.075	42.1	42.04	42.06	851752.0
2014-07-07 12:30:00	MSFT	Stock	42.055	42.09	42.015	42.08	732783.0
2014-07-07 13:00:00	MSFT	Stock	42.09	42.1	42.055	42.07	647677.0
2014-07-07 13:30:00	MSFT	Stock	42.075	42.1	42.06	42.06	646801.0
2014-07-07 14:00:00	MSFT	Stock	42.06	42.07	42.05	42.05	702591.0
2014-07-07 14:30:00	MSFT	Stock	42.055	42.07	42.0	42.04	1127412.0
2014-07-07 15:00:00	MSFT	Stock	42.04	42.055	41.95	41.95	1239611.0
2014-07-07 15:30:00	MSFT	Stock	41.955	42.03	41.92	41.985	3443147.0
2014-07-07 16:00:00	MSFT	Stock	41.98	42.028	41.98	41.99	1888183.0
2014-07-07 16:30:00	MSFT	Stock	42.01	42.08	41.98	41.98	9596.0
2014-07-07 17:00:00	MSFT	Stock	41.98	42.032	41.98	42.01	55073.0

> showing 50 of 85,728 rows — these rows as CSV

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