PREVIEW / stock_30min / 2017-10-16

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-16.parquet
  size:    1.6 MB
  rows:    81,812
  symbols: 2,952

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
2017-10-16 04:00:00	AAPL	Stock	39.535	39.5625	39.535	39.5625	14460.0
2017-10-16 04:30:00	AAPL	Stock	39.55	39.55	39.4525	39.545	12496.0
2017-10-16 05:00:00	AAPL	Stock	39.5375	39.5425	39.5	39.5225	5612.0
2017-10-16 05:30:00	AAPL	Stock	39.5125	39.5425	39.5125	39.5425	3184.0
2017-10-16 06:00:00	AAPL	Stock	39.5425	39.5775	39.5425	39.5775	17024.0
2017-10-16 06:30:00	AAPL	Stock	39.5975	39.625	39.5975	39.6	51908.0
2017-10-16 07:00:00	AAPL	Stock	39.565	39.5825	39.525	39.55	135024.0
2017-10-16 07:30:00	AAPL	Stock	39.56	39.5825	39.5275	39.5625	45876.0
2017-10-16 08:00:00	AAPL	Stock	39.575	39.585	39.525	39.5625	196172.0
2017-10-16 08:30:00	AAPL	Stock	39.5625	39.5875	39.5425	39.565	153040.0
2017-10-16 09:00:00	AAPL	Stock	39.5575	39.5875	39.3375	39.47	728688.0
2017-10-16 09:30:00	AAPL	Stock	39.475	39.84	39.4125	39.7838	21259492.0
2017-10-16 10:00:00	AAPL	Stock	39.785	39.8925	39.7575	39.865	10714292.0
2017-10-16 10:30:00	AAPL	Stock	39.865	39.915	39.81	39.835	7637760.0
2017-10-16 11:00:00	AAPL	Stock	39.8362	39.8362	39.7325	39.8338	4447604.0
2017-10-16 11:30:00	AAPL	Stock	39.8325	39.8625	39.8125	39.84	2940744.0
2017-10-16 12:00:00	AAPL	Stock	39.84	39.8625	39.7438	39.7725	3314512.0
2017-10-16 12:30:00	AAPL	Stock	39.7712	39.8898	39.7625	39.8575	3621192.0
2017-10-16 13:00:00	AAPL	Stock	39.8595	39.885	39.84	39.869	2807844.0
2017-10-16 13:30:00	AAPL	Stock	39.87	39.875	39.8425	39.8625	2119848.0
2017-10-16 14:00:00	AAPL	Stock	39.8625	39.9175	39.86	39.896	2919048.0
2017-10-16 14:30:00	AAPL	Stock	39.8965	39.935	39.8575	39.9275	3058432.0
2017-10-16 15:00:00	AAPL	Stock	39.9265	39.9625	39.9212	39.9582	4547632.0
2017-10-16 15:30:00	AAPL	Stock	39.955	40.0	39.94	39.9675	10896904.0
2017-10-16 16:00:00	AAPL	Stock	39.97	40.0	39.9525	39.985	5736152.0
2017-10-16 16:30:00	AAPL	Stock	39.9775	39.9975	39.97	39.9875	351308.0
2017-10-16 17:00:00	AAPL	Stock	39.9925	39.9925	39.9525	39.9825	62408.0
2017-10-16 17:30:00	AAPL	Stock	39.9625	39.9875	39.9625	39.985	15476.0
2017-10-16 18:00:00	AAPL	Stock	39.9925	39.9925	39.98	39.9825	15548.0
2017-10-16 18:30:00	AAPL	Stock	39.9975	40.0	39.9925	40.0	15544.0
2017-10-16 19:00:00	AAPL	Stock	40.0	40.0	39.9825	40.0	17068.0
2017-10-16 19:30:00	AAPL	Stock	40.0	40.0	39.99	39.99	30156.0
2017-10-16 04:00:00	MSFT	Stock	77.22	77.22	77.22	77.22	200.0
2017-10-16 05:00:00	MSFT	Stock	77.37	77.37	77.37	77.37	718.0
2017-10-16 07:00:00	MSFT	Stock	77.5	77.6	77.5	77.6	427.0
2017-10-16 07:30:00	MSFT	Stock	77.6	77.6	77.6	77.6	350.0
2017-10-16 08:00:00	MSFT	Stock	77.62	77.65	77.62	77.65	634.0
2017-10-16 09:00:00	MSFT	Stock	77.55	77.67	77.32	77.35	27500.0
2017-10-16 09:30:00	MSFT	Stock	77.42	77.81	77.35	77.726	1496381.0
2017-10-16 10:00:00	MSFT	Stock	77.72	77.725	77.365	77.54	1187199.0
2017-10-16 10:30:00	MSFT	Stock	77.54	77.69	77.44	77.52	944862.0
2017-10-16 11:00:00	MSFT	Stock	77.52	77.57	77.45	77.555	542265.0
2017-10-16 11:30:00	MSFT	Stock	77.55	77.64	77.48	77.61	516403.0
2017-10-16 12:00:00	MSFT	Stock	77.61	77.68	77.43	77.52	751874.0
2017-10-16 12:30:00	MSFT	Stock	77.52	77.54	77.44	77.5	391454.0
2017-10-16 13:00:00	MSFT	Stock	77.504	77.58	77.46	77.571	525537.0
2017-10-16 13:30:00	MSFT	Stock	77.58	77.6	77.415	77.425	481563.0
2017-10-16 14:00:00	MSFT	Stock	77.427	77.59	77.42	77.59	329369.0
2017-10-16 14:30:00	MSFT	Stock	77.585	77.61	77.51	77.585	399421.0
2017-10-16 15:00:00	MSFT	Stock	77.585	77.62	77.51	77.525	595440.0

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

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