PREVIEW / stock_30min / 2014-07-29

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-29.parquet
  size:    1.6 MB
  rows:    82,143
  symbols: 3,571

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-29 04:00:00	AAPL	Stock	24.755	24.755	24.745	24.745	3000.0
2014-07-29 04:30:00	AAPL	Stock	24.7375	24.76	24.725	24.76	2000.0
2014-07-29 05:00:00	AAPL	Stock	24.725	24.725	24.725	24.725	5808.0
2014-07-29 05:30:00	AAPL	Stock	24.725	24.725	24.725	24.725	4360.0
2014-07-29 06:00:00	AAPL	Stock	24.725	24.7575	24.705	24.725	14512.0
2014-07-29 06:30:00	AAPL	Stock	24.7375	24.7875	24.7375	24.7475	48564.0
2014-07-29 07:00:00	AAPL	Stock	24.7475	24.8125	24.745	24.81	84484.0
2014-07-29 07:30:00	AAPL	Stock	24.8	24.8175	24.7875	24.8175	100724.0
2014-07-29 08:00:00	AAPL	Stock	24.815	24.87	24.7	24.8475	798100.0
2014-07-29 08:30:00	AAPL	Stock	24.85	24.865	24.83	24.85	531504.0
2014-07-29 09:00:00	AAPL	Stock	24.8425	24.85	24.825	24.8375	332472.0
2014-07-29 09:30:00	AAPL	Stock	24.8325	24.86	24.6375	24.6445	33919280.0
2014-07-29 10:00:00	AAPL	Stock	24.645	24.7175	24.6375	24.7175	16680548.0
2014-07-29 10:30:00	AAPL	Stock	24.7158	24.725	24.6175	24.6625	14122788.0
2014-07-29 11:00:00	AAPL	Stock	24.665	24.68	24.5625	24.6	12313220.0
2014-07-29 11:30:00	AAPL	Stock	24.6	24.65	24.5625	24.63	9306688.0
2014-07-29 12:00:00	AAPL	Stock	24.63	24.6612	24.6125	24.6475	7098880.0
2014-07-29 12:30:00	AAPL	Stock	24.65	24.665	24.625	24.6375	5486760.0
2014-07-29 13:00:00	AAPL	Stock	24.635	24.7087	24.6225	24.6888	8032044.0
2014-07-29 13:30:00	AAPL	Stock	24.6875	24.7225	24.645	24.7122	5751928.0
2014-07-29 14:00:00	AAPL	Stock	24.7125	24.7475	24.6475	24.6775	9024384.0
2014-07-29 14:30:00	AAPL	Stock	24.675	24.6925	24.6535	24.675	5871496.0
2014-07-29 15:00:00	AAPL	Stock	24.675	24.695	24.65	24.6585	7373408.0
2014-07-29 15:30:00	AAPL	Stock	24.66	24.66	24.5625	24.5975	18297444.0
2014-07-29 16:00:00	AAPL	Stock	24.595	24.673	24.5	24.5675	5091388.0
2014-07-29 16:30:00	AAPL	Stock	24.5675	24.6615	24.5625	24.58	260020.0
2014-07-29 17:00:00	AAPL	Stock	24.58	24.5875	24.57	24.57	89692.0
2014-07-29 17:30:00	AAPL	Stock	24.575	24.595	24.57	24.5875	272572.0
2014-07-29 18:00:00	AAPL	Stock	24.5825	24.5975	24.58	24.595	119728.0
2014-07-29 18:30:00	AAPL	Stock	24.595	24.595	24.575	24.575	138512.0
2014-07-29 19:00:00	AAPL	Stock	24.575	24.58	24.5675	24.575	65092.0
2014-07-29 19:30:00	AAPL	Stock	24.57	24.575	24.555	24.565	107508.0
2014-07-29 04:00:00	MSFT	Stock	43.8	43.8	43.8	43.8	200.0
2014-07-29 05:00:00	MSFT	Stock	43.85	43.85	43.76	43.76	1900.0
2014-07-29 06:00:00	MSFT	Stock	43.85	43.85	43.85	43.85	825.0
2014-07-29 06:30:00	MSFT	Stock	43.78	43.78	43.76	43.76	705.0
2014-07-29 07:00:00	MSFT	Stock	43.77	43.77	43.75	43.76	1740.0
2014-07-29 07:30:00	MSFT	Stock	43.76	43.76	43.73	43.73	1411.0
2014-07-29 08:00:00	MSFT	Stock	43.76	43.78	43.76	43.76	2290.0
2014-07-29 08:30:00	MSFT	Stock	43.78	43.9	43.78	43.9	5675.0
2014-07-29 09:00:00	MSFT	Stock	43.95	43.98	43.81	43.85	51010.0
2014-07-29 09:30:00	MSFT	Stock	43.91	43.99	43.72	43.85	3435413.0
2014-07-29 10:00:00	MSFT	Stock	43.85	44.03	43.82	44.01	3049890.0
2014-07-29 10:30:00	MSFT	Stock	44.015	44.04	43.87	43.875	1717043.0
2014-07-29 11:00:00	MSFT	Stock	43.88	43.92	43.69	43.76	1919702.0
2014-07-29 11:30:00	MSFT	Stock	43.76	43.945	43.64	43.895	1483249.0
2014-07-29 12:00:00	MSFT	Stock	43.9	43.95	43.87	43.905	990128.0
2014-07-29 12:30:00	MSFT	Stock	43.905	43.99	43.9	43.975	1100716.0
2014-07-29 13:00:00	MSFT	Stock	43.98	44.0	43.88	43.98	944819.0
2014-07-29 13:30:00	MSFT	Stock	43.98	44.01	43.96	44.0	941158.0

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

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