PREVIEW / stock_30min / 2016-11-30

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-30.parquet
  size:    1.7 MB
  rows:    83,959
  symbols: 3,189

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-11-30 06:00:00	AAPL	Stock	27.865	27.865	27.865	27.865	800.0
2016-11-30 07:00:00	AAPL	Stock	27.875	27.935	27.875	27.935	2128.0
2016-11-30 07:30:00	AAPL	Stock	27.8925	27.8925	27.875	27.875	3440.0
2016-11-30 08:00:00	AAPL	Stock	27.935	27.9525	27.8475	27.85	44564.0
2016-11-30 08:30:00	AAPL	Stock	27.8825	27.9425	27.8825	27.9375	75612.0
2016-11-30 09:00:00	AAPL	Stock	27.9425	27.9975	27.9	27.9	231592.0
2016-11-30 09:30:00	AAPL	Stock	27.9025	28.05	27.88	27.9175	12203680.0
2016-11-30 10:00:00	AAPL	Stock	27.915	27.9175	27.7075	27.755	11339404.0
2016-11-30 10:30:00	AAPL	Stock	27.755	27.7625	27.635	27.7135	10399616.0
2016-11-30 11:00:00	AAPL	Stock	27.7138	27.77	27.6625	27.6665	6618080.0
2016-11-30 11:30:00	AAPL	Stock	27.6675	27.725	27.6425	27.6725	6846260.0
2016-11-30 12:00:00	AAPL	Stock	27.6725	27.75	27.65	27.735	5131900.0
2016-11-30 12:30:00	AAPL	Stock	27.7375	27.79	27.7275	27.79	4350024.0
2016-11-30 13:00:00	AAPL	Stock	27.7892	27.8012	27.7575	27.79	3213056.0
2016-11-30 13:30:00	AAPL	Stock	27.79	27.7925	27.7425	27.7475	2827880.0
2016-11-30 14:00:00	AAPL	Stock	27.75	27.75	27.6425	27.68	6684316.0
2016-11-30 14:30:00	AAPL	Stock	27.68	27.68	27.5675	27.615	8243072.0
2016-11-30 15:00:00	AAPL	Stock	27.615	27.7175	27.605	27.71	6546072.0
2016-11-30 15:30:00	AAPL	Stock	27.7125	27.7175	27.6275	27.63	16185164.0
2016-11-30 16:00:00	AAPL	Stock	27.63	27.66	27.625	27.65	30772748.0
2016-11-30 16:30:00	AAPL	Stock	27.65	27.65	27.6375	27.6425	78500.0
2016-11-30 17:00:00	AAPL	Stock	27.645	27.6625	27.6375	27.6625	42560.0
2016-11-30 17:30:00	AAPL	Stock	27.65	27.66	27.65	27.66	3128.0
2016-11-30 18:00:00	AAPL	Stock	27.65	27.65	27.6375	27.6375	7600.0
2016-11-30 18:30:00	AAPL	Stock	27.6375	27.66	27.6375	27.66	2504.0
2016-11-30 19:00:00	AAPL	Stock	27.66	27.66	27.6475	27.6475	5580.0
2016-11-30 19:30:00	AAPL	Stock	27.6625	27.6625	27.655	27.6625	4172.0
2016-11-30 06:00:00	MSFT	Stock	61.25	61.25	61.25	61.25	106.0
2016-11-30 08:00:00	MSFT	Stock	61.32	61.32	61.25	61.32	1815.0
2016-11-30 08:30:00	MSFT	Stock	61.27	61.27	61.2	61.2	1300.0
2016-11-30 09:00:00	MSFT	Stock	61.17	61.2	61.01	61.01	4373.0
2016-11-30 09:30:00	MSFT	Stock	60.86	61.18	60.73	60.765	2566706.0
2016-11-30 10:00:00	MSFT	Stock	60.77	61.01	60.64	60.71	2198865.0
2016-11-30 10:30:00	MSFT	Stock	60.705	60.91	60.69	60.755	1231675.0
2016-11-30 11:00:00	MSFT	Stock	60.75	60.82	60.615	60.619	1256564.0
2016-11-30 11:30:00	MSFT	Stock	60.615	60.75	60.34	60.385	1594531.0
2016-11-30 12:00:00	MSFT	Stock	60.39	60.49	60.215	60.33	1826036.0
2016-11-30 12:30:00	MSFT	Stock	60.33	60.59	60.3	60.561	741351.0
2016-11-30 13:00:00	MSFT	Stock	60.56	60.6	60.52	60.55	664657.0
2016-11-30 13:30:00	MSFT	Stock	60.55	60.625	60.48	60.57	655366.0
2016-11-30 14:00:00	MSFT	Stock	60.565	60.57	60.27	60.402	1242811.0
2016-11-30 14:30:00	MSFT	Stock	60.408	60.408	60.275	60.35	1248395.0
2016-11-30 15:00:00	MSFT	Stock	60.35	60.46	60.28	60.42	1469679.0
2016-11-30 15:30:00	MSFT	Stock	60.41	60.52	60.26	60.26	5452475.0
2016-11-30 16:00:00	MSFT	Stock	60.27	60.33	60.24	60.33	9684684.0
2016-11-30 16:30:00	MSFT	Stock	60.26	60.33	60.26	60.33	550628.0
2016-11-30 17:30:00	MSFT	Stock	60.29	60.29	60.29	60.29	100.0
2016-11-30 18:00:00	MSFT	Stock	60.29	60.3	60.29	60.3	726.0
2016-11-30 18:30:00	MSFT	Stock	60.32	60.32	60.26	60.26	5492.0
2016-11-30 19:30:00	MSFT	Stock	60.32	60.32	60.32	60.32	100.0

> showing 50 of 83,959 rows — these rows as CSV

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