PREVIEW / stock_30min / 2014-07-09

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-09.parquet
  size:    1.6 MB
  rows:    81,468
  symbols: 3,570

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-09 04:00:00	AAPL	Stock	23.85	23.85	23.8375	23.8375	2280.0
2014-07-09 04:30:00	AAPL	Stock	23.8275	23.8275	23.8125	23.8275	4000.0
2014-07-09 05:30:00	AAPL	Stock	23.8075	23.8275	23.8075	23.8275	6400.0
2014-07-09 06:00:00	AAPL	Stock	23.8375	23.8525	23.8375	23.845	4640.0
2014-07-09 06:30:00	AAPL	Stock	23.8425	23.85	23.8375	23.8475	6400.0
2014-07-09 07:00:00	AAPL	Stock	23.84	23.875	23.84	23.8625	71156.0
2014-07-09 07:30:00	AAPL	Stock	23.86	23.8675	23.8575	23.865	24300.0
2014-07-09 08:00:00	AAPL	Stock	23.865	23.8675	23.83	23.8675	305740.0
2014-07-09 08:30:00	AAPL	Stock	23.8675	23.9225	23.8625	23.895	198840.0
2014-07-09 09:00:00	AAPL	Stock	23.895	23.925	23.86	23.875	482660.0
2014-07-09 09:30:00	AAPL	Stock	23.86	23.9875	23.8025	23.8775	26018320.0
2014-07-09 10:00:00	AAPL	Stock	23.8775	23.95	23.8025	23.9475	13841520.0
2014-07-09 10:30:00	AAPL	Stock	23.9475	23.97	23.8975	23.9338	9228968.0
2014-07-09 11:00:00	AAPL	Stock	23.935	23.9425	23.8825	23.9245	7086056.0
2014-07-09 11:30:00	AAPL	Stock	23.925	23.955	23.9025	23.945	5152328.0
2014-07-09 12:00:00	AAPL	Stock	23.9475	23.9475	23.9125	23.925	4833156.0
2014-07-09 12:30:00	AAPL	Stock	23.925	23.93	23.8378	23.8525	5373964.0
2014-07-09 13:00:00	AAPL	Stock	23.8525	23.89	23.8325	23.835	4557284.0
2014-07-09 13:30:00	AAPL	Stock	23.835	23.8675	23.795	23.795	5479744.0
2014-07-09 14:00:00	AAPL	Stock	23.7925	23.8375	23.69	23.8188	14770248.0
2014-07-09 14:30:00	AAPL	Stock	23.8225	23.9018	23.7875	23.86	7928100.0
2014-07-09 15:00:00	AAPL	Stock	23.8575	23.8875	23.845	23.8688	5888572.0
2014-07-09 15:30:00	AAPL	Stock	23.8688	23.8875	23.8275	23.8475	11576512.0
2014-07-09 16:00:00	AAPL	Stock	23.8475	23.9015	23.8425	23.8425	12611212.0
2014-07-09 16:30:00	AAPL	Stock	23.8425	23.8475	23.84	23.84	84596.0
2014-07-09 17:00:00	AAPL	Stock	23.8425	23.8425	23.835	23.8425	37924.0
2014-07-09 17:30:00	AAPL	Stock	23.8425	23.845	23.835	23.8375	28708.0
2014-07-09 18:00:00	AAPL	Stock	23.84	23.8475	23.84	23.845	62556.0
2014-07-09 18:30:00	AAPL	Stock	23.84	23.84	23.8	23.8375	30384.0
2014-07-09 19:00:00	AAPL	Stock	23.8375	23.8475	23.8275	23.8275	512744.0
2014-07-09 19:30:00	AAPL	Stock	23.8275	23.8475	23.8275	23.8425	30844.0
2014-07-09 08:30:00	MSFT	Stock	41.99	42.0	41.99	42.0	480.0
2014-07-09 09:00:00	MSFT	Stock	41.89	41.92	41.89	41.92	800.0
2014-07-09 09:30:00	MSFT	Stock	41.98	41.99	41.65	41.653	2488193.0
2014-07-09 10:00:00	MSFT	Stock	41.66	41.72	41.53	41.694	1530230.0
2014-07-09 10:30:00	MSFT	Stock	41.699	41.81	41.65	41.735	1082653.0
2014-07-09 11:00:00	MSFT	Stock	41.74	41.79	41.69	41.73	956351.0
2014-07-09 11:30:00	MSFT	Stock	41.73	41.738	41.61	41.63	842072.0
2014-07-09 12:00:00	MSFT	Stock	41.632	41.66	41.63	41.64	633851.0
2014-07-09 12:30:00	MSFT	Stock	41.65	41.7	41.63	41.669	623280.0
2014-07-09 13:00:00	MSFT	Stock	41.669	41.67	41.62	41.63	321293.0
2014-07-09 13:30:00	MSFT	Stock	41.623	41.64	41.61	41.613	601577.0
2014-07-09 14:00:00	MSFT	Stock	41.62	41.72	41.555	41.7	1521807.0
2014-07-09 14:30:00	MSFT	Stock	41.7	41.74	41.66	41.685	761711.0
2014-07-09 15:00:00	MSFT	Stock	41.687	41.78	41.67	41.685	1465667.0
2014-07-09 15:30:00	MSFT	Stock	41.68	41.73	41.62	41.67	2323938.0
2014-07-09 16:00:00	MSFT	Stock	41.67	41.72	41.654	41.678	2432167.0
2014-07-09 16:30:00	MSFT	Stock	41.67	41.69	41.67	41.69	14174.0
2014-07-09 17:30:00	MSFT	Stock	41.7	41.7	41.7	41.7	400.0
2014-07-09 18:00:00	MSFT	Stock	41.69	41.69	41.69	41.69	400.0

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

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