PREVIEW / stock_30min / 2015-10-14

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-14.parquet
  size:    1.5 MB
  rows:    79,550
  symbols: 3,395

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-14 04:00:00	AAPL	Stock	27.9525	27.9525	27.8225	27.8225	800.0
2015-10-14 05:30:00	AAPL	Stock	27.8225	27.8225	27.8225	27.8225	400.0
2015-10-14 06:00:00	AAPL	Stock	27.825	27.8375	27.7575	27.775	61328.0
2015-10-14 06:30:00	AAPL	Stock	27.775	27.8125	27.75	27.8125	149108.0
2015-10-14 07:00:00	AAPL	Stock	27.795	27.8	27.7675	27.7875	17200.0
2015-10-14 07:30:00	AAPL	Stock	27.79	27.7925	27.7025	27.765	263252.0
2015-10-14 08:00:00	AAPL	Stock	27.8425	27.8425	27.755	27.785	266568.0
2015-10-14 08:30:00	AAPL	Stock	27.785	27.7875	27.725	27.775	357220.0
2015-10-14 09:00:00	AAPL	Stock	27.7625	27.825	27.75	27.825	468012.0
2015-10-14 09:30:00	AAPL	Stock	27.8225	27.88	27.6925	27.695	20915816.0
2015-10-14 10:00:00	AAPL	Stock	27.6975	27.705	27.44	27.5425	24564696.0
2015-10-14 10:30:00	AAPL	Stock	27.5422	27.5725	27.4375	27.555	16076172.0
2015-10-14 11:00:00	AAPL	Stock	27.555	27.595	27.475	27.5025	9913580.0
2015-10-14 11:30:00	AAPL	Stock	27.504	27.5925	27.49	27.5125	8644264.0
2015-10-14 12:00:00	AAPL	Stock	27.5125	27.5175	27.39	27.47	10176336.0
2015-10-14 12:30:00	AAPL	Stock	27.47	27.6475	27.47	27.6225	11544028.0
2015-10-14 13:00:00	AAPL	Stock	27.6212	27.66	27.6	27.63	6248948.0
2015-10-14 13:30:00	AAPL	Stock	27.6275	27.65	27.595	27.6162	5295496.0
2015-10-14 14:00:00	AAPL	Stock	27.6175	27.655	27.5575	27.564	7181192.0
2015-10-14 14:30:00	AAPL	Stock	27.56	27.5618	27.4475	27.495	10603048.0
2015-10-14 15:00:00	AAPL	Stock	27.495	27.6025	27.49	27.591	9490892.0
2015-10-14 15:30:00	AAPL	Stock	27.5925	27.6275	27.49	27.5525	16168312.0
2015-10-14 16:00:00	AAPL	Stock	27.5525	27.8542	27.4675	27.525	5956860.0
2015-10-14 16:30:00	AAPL	Stock	27.555	27.57	27.52	27.5375	305360.0
2015-10-14 17:00:00	AAPL	Stock	27.5575	27.575	27.5375	27.575	59716.0
2015-10-14 17:30:00	AAPL	Stock	27.5625	27.5625	27.55	27.56	14232.0
2015-10-14 18:00:00	AAPL	Stock	27.55	27.59	27.545	27.575	18028.0
2015-10-14 18:30:00	AAPL	Stock	27.59	27.59	27.575	27.575	7536.0
2015-10-14 19:00:00	AAPL	Stock	27.575	27.575	27.56	27.5625	13672.0
2015-10-14 19:30:00	AAPL	Stock	27.5575	27.6	27.5575	27.6	15048.0
2015-10-14 08:00:00	MSFT	Stock	46.88	46.9	46.88	46.9	1800.0
2015-10-14 08:30:00	MSFT	Stock	46.82	46.85	46.82	46.85	3071.0
2015-10-14 09:00:00	MSFT	Stock	46.73	46.73	46.67	46.67	2900.0
2015-10-14 09:30:00	MSFT	Stock	46.65	47.1	46.53	47.06	1928348.0
2015-10-14 10:00:00	MSFT	Stock	47.05	47.055	46.88	46.92	1374418.0
2015-10-14 10:30:00	MSFT	Stock	46.92	46.92	46.68	46.76	1582302.0
2015-10-14 11:00:00	MSFT	Stock	46.76	46.92	46.73	46.74	1445252.0
2015-10-14 11:30:00	MSFT	Stock	46.745	46.895	46.72	46.87	1122803.0
2015-10-14 12:00:00	MSFT	Stock	46.864	46.88	46.71	46.87	954263.0
2015-10-14 12:30:00	MSFT	Stock	46.873	47.04	46.87	47.02	1173764.0
2015-10-14 13:00:00	MSFT	Stock	47.02	47.05	46.88	46.925	1075516.0
2015-10-14 13:30:00	MSFT	Stock	46.92	46.95	46.815	46.925	950681.0
2015-10-14 14:00:00	MSFT	Stock	46.925	47.0	46.77	46.785	1251765.0
2015-10-14 14:30:00	MSFT	Stock	46.78	46.85	46.74	46.755	1253740.0
2015-10-14 15:00:00	MSFT	Stock	46.76	46.79	46.61	46.725	2707514.0
2015-10-14 15:30:00	MSFT	Stock	46.725	46.78	46.53	46.68	4216304.0
2015-10-14 16:00:00	MSFT	Stock	46.67	46.906	46.67	46.68	2654459.0
2015-10-14 16:30:00	MSFT	Stock	46.68	46.68	46.68	46.68	38100.0
2015-10-14 17:00:00	MSFT	Stock	46.6	46.6	46.58	46.58	204.0
2015-10-14 18:00:00	MSFT	Stock	46.67	46.68	46.67	46.68	3577.0

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

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