PREVIEW / stock_30min / 2016-09-21

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-21.parquet
  size:    1.6 MB
  rows:    81,628
  symbols: 3,217

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
2016-09-21 04:00:00	AAPL	Stock	28.505	28.53	28.505	28.53	5400.0
2016-09-21 04:30:00	AAPL	Stock	28.53	28.5725	28.53	28.5725	2828.0
2016-09-21 05:00:00	AAPL	Stock	28.53	28.53	28.53	28.53	400.0
2016-09-21 05:30:00	AAPL	Stock	28.5525	28.65	28.5525	28.65	33168.0
2016-09-21 06:00:00	AAPL	Stock	28.665	28.735	28.3075	28.575	54532.0
2016-09-21 06:30:00	AAPL	Stock	28.5675	28.5675	28.565	28.565	3156.0
2016-09-21 07:00:00	AAPL	Stock	28.555	28.5625	28.53	28.5575	24800.0
2016-09-21 07:30:00	AAPL	Stock	28.5475	28.63	28.535	28.55	54432.0
2016-09-21 08:00:00	AAPL	Stock	28.545	28.5625	28.48	28.55	180716.0
2016-09-21 08:30:00	AAPL	Stock	28.55	28.575	28.51	28.5275	131672.0
2016-09-21 09:00:00	AAPL	Stock	28.52	28.52	28.4625	28.475	75840.0
2016-09-21 09:30:00	AAPL	Stock	28.4625	28.4972	28.2625	28.2868	17314168.0
2016-09-21 10:00:00	AAPL	Stock	28.285	28.34	28.2575	28.32	9122052.0
2016-09-21 10:30:00	AAPL	Stock	28.32	28.445	28.2925	28.315	10244344.0
2016-09-21 11:00:00	AAPL	Stock	28.315	28.3212	28.225	28.275	8920016.0
2016-09-21 11:30:00	AAPL	Stock	28.275	28.2812	28.2275	28.2335	4916888.0
2016-09-21 12:00:00	AAPL	Stock	28.2325	28.2425	28.1275	28.1475	9339104.0
2016-09-21 12:30:00	AAPL	Stock	28.145	28.205	28.1102	28.1725	6740132.0
2016-09-21 13:00:00	AAPL	Stock	28.175	28.205	28.14	28.1472	3760492.0
2016-09-21 13:30:00	AAPL	Stock	28.1475	28.2175	28.135	28.17	5369480.0
2016-09-21 14:00:00	AAPL	Stock	28.1625	28.3125	28.125	28.1958	13609244.0
2016-09-21 14:30:00	AAPL	Stock	28.1975	28.355	28.1925	28.34	8738020.0
2016-09-21 15:00:00	AAPL	Stock	28.34	28.3925	28.31	28.3675	7464488.0
2016-09-21 15:30:00	AAPL	Stock	28.367	28.415	28.3625	28.3825	12679292.0
2016-09-21 16:00:00	AAPL	Stock	28.3875	28.405	28.375	28.4	11604708.0
2016-09-21 16:30:00	AAPL	Stock	28.4	28.4325	28.3875	28.4125	387200.0
2016-09-21 17:00:00	AAPL	Stock	28.4125	28.415	28.395	28.4	54348.0
2016-09-21 17:30:00	AAPL	Stock	28.415	28.415	28.4	28.4	7440.0
2016-09-21 18:00:00	AAPL	Stock	28.4	28.4075	28.3925	28.4075	26656.0
2016-09-21 18:30:00	AAPL	Stock	28.4	28.4025	28.4	28.4	8524.0
2016-09-21 19:00:00	AAPL	Stock	28.405	28.4125	28.4025	28.4125	2888.0
2016-09-21 19:30:00	AAPL	Stock	28.4125	28.415	28.41	28.415	32752.0
2016-09-21 04:00:00	MSFT	Stock	57.53	57.75	57.53	57.75	648.0
2016-09-21 04:30:00	MSFT	Stock	57.7	57.7	57.6	57.6	800.0
2016-09-21 05:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	1000.0
2016-09-21 05:30:00	MSFT	Stock	57.6	57.6	57.6	57.6	100.0
2016-09-21 06:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	482.0
2016-09-21 06:30:00	MSFT	Stock	57.5	57.54	57.5	57.53	1490.0
2016-09-21 07:00:00	MSFT	Stock	57.5	57.55	57.45	57.55	19900.0
2016-09-21 07:30:00	MSFT	Stock	57.52	57.52	57.44	57.5	15074.0
2016-09-21 08:00:00	MSFT	Stock	57.55	57.59	57.42	57.54	62813.0
2016-09-21 08:30:00	MSFT	Stock	57.54	57.59	57.44	57.56	43561.0
2016-09-21 09:00:00	MSFT	Stock	57.57	57.59	57.5	57.5	35894.0
2016-09-21 09:30:00	MSFT	Stock	57.51	57.59	57.08	57.43	5158752.0
2016-09-21 10:00:00	MSFT	Stock	57.44	57.6	57.39	57.45	2254585.0
2016-09-21 10:30:00	MSFT	Stock	57.45	57.54	57.41	57.455	1768365.0
2016-09-21 11:00:00	MSFT	Stock	57.46	57.52	57.34	57.44	1772136.0
2016-09-21 11:30:00	MSFT	Stock	57.435	57.465	57.34	57.38	1538642.0
2016-09-21 12:00:00	MSFT	Stock	57.375	57.45	57.2	57.226	1665163.0
2016-09-21 12:30:00	MSFT	Stock	57.226	57.23	57.11	57.18	1216284.0

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

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