PREVIEW / stock_30min / 2014-06-23

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-23.parquet
  size:    1.6 MB
  rows:    82,084
  symbols: 3,593

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-23 04:00:00	AAPL	Stock	22.625	22.9	22.625	22.675	122880.0
2014-06-23 04:30:00	AAPL	Stock	22.6725	22.6725	22.6725	22.6725	400.0
2014-06-23 05:00:00	AAPL	Stock	22.6625	22.725	22.6625	22.725	78776.0
2014-06-23 05:30:00	AAPL	Stock	22.725	22.755	22.725	22.755	32928.0
2014-06-23 06:00:00	AAPL	Stock	22.7725	22.785	22.76	22.7675	81696.0
2014-06-23 06:30:00	AAPL	Stock	22.7675	22.7675	22.7375	22.75	45392.0
2014-06-23 07:00:00	AAPL	Stock	22.76	22.7975	22.76	22.79	126416.0
2014-06-23 07:30:00	AAPL	Stock	22.7875	22.8375	22.7875	22.8375	82104.0
2014-06-23 08:00:00	AAPL	Stock	22.8325	22.865	22.7625	22.8	442580.0
2014-06-23 08:30:00	AAPL	Stock	22.8	22.865	22.785	22.84	476644.0
2014-06-23 09:00:00	AAPL	Stock	22.8375	22.8625	22.8175	22.83	579296.0
2014-06-23 09:30:00	AAPL	Stock	22.83	22.905	22.6575	22.665	27866960.0
2014-06-23 10:00:00	AAPL	Stock	22.6675	22.785	22.65	22.7475	19429044.0
2014-06-23 10:30:00	AAPL	Stock	22.7475	22.7575	22.665	22.677	9640600.0
2014-06-23 11:00:00	AAPL	Stock	22.6775	22.7425	22.6725	22.7275	7922468.0
2014-06-23 11:30:00	AAPL	Stock	22.7238	22.74	22.6825	22.7375	7872072.0
2014-06-23 12:00:00	AAPL	Stock	22.7398	22.8	22.7275	22.7688	8596048.0
2014-06-23 12:30:00	AAPL	Stock	22.77	22.79	22.7325	22.7695	5752956.0
2014-06-23 13:00:00	AAPL	Stock	22.77	22.7725	22.7175	22.725	4887764.0
2014-06-23 13:30:00	AAPL	Stock	22.7238	22.73	22.6775	22.6875	5121668.0
2014-06-23 14:00:00	AAPL	Stock	22.687	22.74	22.685	22.7303	5214804.0
2014-06-23 14:30:00	AAPL	Stock	22.7325	22.7375	22.6812	22.7087	5782068.0
2014-06-23 15:00:00	AAPL	Stock	22.7075	22.72	22.68	22.6902	6080164.0
2014-06-23 15:30:00	AAPL	Stock	22.6912	22.72	22.675	22.7035	15484676.0
2014-06-23 16:00:00	AAPL	Stock	22.7075	22.7345	22.6875	22.695	26961160.0
2014-06-23 16:30:00	AAPL	Stock	22.695	22.7248	22.6875	22.6875	116124.0
2014-06-23 17:00:00	AAPL	Stock	22.703	22.703	22.6875	22.69	23148.0
2014-06-23 17:30:00	AAPL	Stock	22.695	22.695	22.6875	22.695	29220.0
2014-06-23 18:00:00	AAPL	Stock	22.695	22.695	22.685	22.69	66736.0
2014-06-23 18:30:00	AAPL	Stock	22.7075	22.7075	22.68	22.68	138720.0
2014-06-23 19:00:00	AAPL	Stock	22.6775	22.6925	22.675	22.6825	27496.0
2014-06-23 19:30:00	AAPL	Stock	22.68	22.68	22.67	22.67	55644.0
2014-06-23 05:30:00	MSFT	Stock	41.55	41.55	41.55	41.55	100.0
2014-06-23 07:00:00	MSFT	Stock	41.6	41.6	41.6	41.6	100.0
2014-06-23 07:30:00	MSFT	Stock	41.67	41.67	41.6	41.6	450.0
2014-06-23 08:30:00	MSFT	Stock	41.64	41.65	41.64	41.65	700.0
2014-06-23 09:00:00	MSFT	Stock	41.63	41.78	41.63	41.69	54558.0
2014-06-23 09:30:00	MSFT	Stock	41.7	42.0	41.69	41.98	3119821.0
2014-06-23 10:00:00	MSFT	Stock	41.99	41.99	41.85	41.88	1563869.0
2014-06-23 10:30:00	MSFT	Stock	41.885	41.89	41.8	41.817	1110702.0
2014-06-23 11:00:00	MSFT	Stock	41.81	41.825	41.69	41.725	970264.0
2014-06-23 11:30:00	MSFT	Stock	41.73	41.76	41.69	41.71	770916.0
2014-06-23 12:00:00	MSFT	Stock	41.71	41.78	41.71	41.755	461286.0
2014-06-23 12:30:00	MSFT	Stock	41.76	41.82	41.715	41.795	750502.0
2014-06-23 13:00:00	MSFT	Stock	41.79	41.81	41.69	41.76	669973.0
2014-06-23 13:30:00	MSFT	Stock	41.753	41.88	41.72	41.865	846380.0
2014-06-23 14:00:00	MSFT	Stock	41.867	41.896	41.84	41.87	728704.0
2014-06-23 14:30:00	MSFT	Stock	41.865	41.9	41.86	41.895	682842.0
2014-06-23 15:00:00	MSFT	Stock	41.895	41.9	41.85	41.89	1411521.0
2014-06-23 15:30:00	MSFT	Stock	41.885	42.0	41.88	41.98	3160829.0

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

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