PREVIEW / stock_30min / 2015-10-13

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-13.parquet
  size:    1.5 MB
  rows:    79,879
  symbols: 3,417

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
2015-10-13 04:00:00	AAPL	Stock	27.7625	27.7625	27.675	27.715	4580.0
2015-10-13 04:30:00	AAPL	Stock	27.7	27.72	27.7	27.72	4316.0
2015-10-13 05:00:00	AAPL	Stock	27.6925	27.6925	27.6925	27.6925	3200.0
2015-10-13 05:30:00	AAPL	Stock	27.7075	27.7475	27.7075	27.7425	2000.0
2015-10-13 06:00:00	AAPL	Stock	27.755	27.755	27.73	27.7475	2000.0
2015-10-13 06:30:00	AAPL	Stock	27.73	27.7475	27.73	27.7475	12828.0
2015-10-13 07:00:00	AAPL	Stock	27.7675	27.7825	27.755	27.77	24688.0
2015-10-13 07:30:00	AAPL	Stock	27.7575	27.7575	27.7375	27.745	37720.0
2015-10-13 08:00:00	AAPL	Stock	27.75	27.8	27.725	27.7675	543176.0
2015-10-13 08:30:00	AAPL	Stock	27.7675	27.785	27.73	27.7375	147464.0
2015-10-13 09:00:00	AAPL	Stock	27.7425	27.775	27.7	27.7075	222912.0
2015-10-13 09:30:00	AAPL	Stock	27.705	27.965	27.67	27.9338	18071544.0
2015-10-13 10:00:00	AAPL	Stock	27.9338	28.015	27.8125	28.0	13242408.0
2015-10-13 10:30:00	AAPL	Stock	28.0	28.1025	27.97	28.1	10742612.0
2015-10-13 11:00:00	AAPL	Stock	28.0975	28.1125	27.975	27.995	10850604.0
2015-10-13 11:30:00	AAPL	Stock	27.9928	27.9975	27.9275	27.9575	8613564.0
2015-10-13 12:00:00	AAPL	Stock	27.9575	28.0025	27.905	27.985	5251516.0
2015-10-13 12:30:00	AAPL	Stock	27.985	28.02	27.925	27.9312	5166668.0
2015-10-13 13:00:00	AAPL	Stock	27.929	27.97	27.9025	27.9625	5531396.0
2015-10-13 13:30:00	AAPL	Stock	27.9625	28.0	27.9225	27.9625	4595916.0
2015-10-13 14:00:00	AAPL	Stock	27.9638	28.005	27.9425	27.97	5158616.0
2015-10-13 14:30:00	AAPL	Stock	27.97	28.055	27.9375	28.0522	7061416.0
2015-10-13 15:00:00	AAPL	Stock	28.051	28.0525	27.9125	27.9552	7442796.0
2015-10-13 15:30:00	AAPL	Stock	27.9552	27.9725	27.8925	27.9475	12823352.0
2015-10-13 16:00:00	AAPL	Stock	27.9475	27.96	27.9275	27.95	4884464.0
2015-10-13 16:30:00	AAPL	Stock	27.9325	27.9325	27.93	27.93	13200.0
2015-10-13 17:00:00	AAPL	Stock	27.9375	27.9375	27.9125	27.9125	61540.0
2015-10-13 17:30:00	AAPL	Stock	27.9125	27.925	27.9025	27.91	20360.0
2015-10-13 18:00:00	AAPL	Stock	27.91	27.91	27.8275	27.8275	36280.0
2015-10-13 18:30:00	AAPL	Stock	27.8275	27.8275	27.8075	27.8075	32200.0
2015-10-13 19:00:00	AAPL	Stock	27.7975	27.8	27.7875	27.7875	25216.0
2015-10-13 19:30:00	AAPL	Stock	27.795	27.8175	27.7875	27.805	43808.0
2015-10-13 07:30:00	MSFT	Stock	46.81	46.81	46.81	46.81	600.0
2015-10-13 09:00:00	MSFT	Stock	46.79	46.79	46.57	46.57	2130.0
2015-10-13 09:30:00	MSFT	Stock	46.56	46.85	46.56	46.85	2475980.0
2015-10-13 10:00:00	MSFT	Stock	46.85	46.88	46.7	46.815	1700115.0
2015-10-13 10:30:00	MSFT	Stock	46.82	47.09	46.81	47.09	1278760.0
2015-10-13 11:00:00	MSFT	Stock	47.08	47.085	46.931	46.97	766006.0
2015-10-13 11:30:00	MSFT	Stock	46.97	47.03	46.93	47.005	735626.0
2015-10-13 12:00:00	MSFT	Stock	47.01	47.13	46.99	47.087	783197.0
2015-10-13 12:30:00	MSFT	Stock	47.09	47.1	46.9	46.901	675066.0
2015-10-13 13:00:00	MSFT	Stock	46.9	46.93	46.7	46.91	625633.0
2015-10-13 13:30:00	MSFT	Stock	46.92	46.93	46.777	46.865	889174.0
2015-10-13 14:00:00	MSFT	Stock	46.87	46.995	46.81	46.96	1014148.0
2015-10-13 14:30:00	MSFT	Stock	46.96	47.04	46.95	46.996	1073317.0
2015-10-13 15:00:00	MSFT	Stock	46.99	47.02	46.805	46.845	1261862.0
2015-10-13 15:30:00	MSFT	Stock	46.845	46.92	46.795	46.88	2575718.0
2015-10-13 16:00:00	MSFT	Stock	46.89	46.97	46.677	46.76	1582369.0
2015-10-13 16:30:00	MSFT	Stock	46.78	46.78	46.78	46.78	120.0
2015-10-13 17:00:00	MSFT	Stock	46.89	46.89	46.77	46.77	1100.0

> showing 50 of 79,879 rows — these rows as CSV

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