PREVIEW / stock_30min / 2013-11-20

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-20.parquet
  size:    1.5 MB
  rows:    79,607
  symbols: 3,547

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
2013-11-20 05:00:00	AAPL	Stock	18.5579	18.5579	18.5579	18.5579	2800.0
2013-11-20 06:00:00	AAPL	Stock	18.525	18.525	18.525	18.525	2800.0
2013-11-20 06:30:00	AAPL	Stock	18.5321	18.5321	18.5321	18.5321	2800.0
2013-11-20 07:00:00	AAPL	Stock	18.5321	18.5357	18.5321	18.5357	9520.0
2013-11-20 07:30:00	AAPL	Stock	18.5364	18.5375	18.505	18.5182	93772.0
2013-11-20 08:00:00	AAPL	Stock	18.5336	18.5643	18.5189	18.5536	240548.0
2013-11-20 08:30:00	AAPL	Stock	18.5607	18.5821	18.5604	18.5625	117040.0
2013-11-20 09:00:00	AAPL	Stock	18.5625	18.5786	18.5357	18.5414	403816.0
2013-11-20 09:30:00	AAPL	Stock	18.5439	18.5864	18.4839	18.5	33589752.0
2013-11-20 10:00:00	AAPL	Stock	18.5014	18.56	18.4739	18.5321	18145372.0
2013-11-20 10:30:00	AAPL	Stock	18.5321	18.5439	18.4879	18.525	17955252.0
2013-11-20 11:00:00	AAPL	Stock	18.5243	18.5296	18.4896	18.5164	18413248.0
2013-11-20 11:30:00	AAPL	Stock	18.5157	18.5279	18.4971	18.5032	9141244.0
2013-11-20 12:00:00	AAPL	Stock	18.5032	18.5268	18.5007	18.505	6672176.0
2013-11-20 12:30:00	AAPL	Stock	18.5057	18.5086	18.4761	18.4911	6529600.0
2013-11-20 13:00:00	AAPL	Stock	18.4907	18.4993	18.4693	18.485	4458748.0
2013-11-20 13:30:00	AAPL	Stock	18.4839	18.5107	18.4786	18.5032	4562936.0
2013-11-20 14:00:00	AAPL	Stock	18.5032	18.5121	18.4325	18.4639	15273580.0
2013-11-20 14:30:00	AAPL	Stock	18.4639	18.4743	18.4114	18.4411	12209596.0
2013-11-20 15:00:00	AAPL	Stock	18.4354	18.4564	18.4004	18.4086	14156100.0
2013-11-20 15:30:00	AAPL	Stock	18.4054	18.4107	18.3689	18.3932	22260308.0
2013-11-20 16:00:00	AAPL	Stock	18.3929	18.4834	18.3929	18.3996	5809552.0
2013-11-20 16:30:00	AAPL	Stock	18.4054	18.4071	18.3929	18.4071	158396.0
2013-11-20 17:00:00	AAPL	Stock	18.4061	18.41	18.405	18.405	91000.0
2013-11-20 17:30:00	AAPL	Stock	18.4054	18.4064	18.4046	18.4064	60844.0
2013-11-20 18:00:00	AAPL	Stock	18.41	18.41	18.3929	18.4054	95032.0
2013-11-20 18:30:00	AAPL	Stock	18.4018	18.4018	18.4018	18.4018	2800.0
2013-11-20 19:00:00	AAPL	Stock	18.4096	18.4096	18.4096	18.4096	2800.0
2013-11-20 19:30:00	AAPL	Stock	18.4036	18.4089	18.3961	18.4089	161616.0
2013-11-20 08:00:00	MSFT	Stock	36.8	36.8	36.78	36.78	3400.0
2013-11-20 08:30:00	MSFT	Stock	36.78	36.83	36.75	36.83	9708.0
2013-11-20 09:00:00	MSFT	Stock	36.83	36.87	36.8	36.87	12235.0
2013-11-20 09:30:00	MSFT	Stock	36.86	37.18	36.86	37.1	4551751.0
2013-11-20 10:00:00	MSFT	Stock	37.1	37.33	37.067	37.32	3014649.0
2013-11-20 10:30:00	MSFT	Stock	37.315	37.41	37.17	37.32	3541697.0
2013-11-20 11:00:00	MSFT	Stock	37.325	37.33	37.203	37.317	1719174.0
2013-11-20 11:30:00	MSFT	Stock	37.315	37.37	37.29	37.316	1627753.0
2013-11-20 12:00:00	MSFT	Stock	37.31	37.38	37.29	37.29	1167619.0
2013-11-20 12:30:00	MSFT	Stock	37.29	37.3	37.16	37.17	1023615.0
2013-11-20 13:00:00	MSFT	Stock	37.174	37.21	37.12	37.13	946112.0
2013-11-20 13:30:00	MSFT	Stock	37.13	37.21	37.13	37.15	811824.0
2013-11-20 14:00:00	MSFT	Stock	37.15	37.2	37.0	37.12	2781868.0
2013-11-20 14:30:00	MSFT	Stock	37.12	37.15	37.01	37.07	1681797.0
2013-11-20 15:00:00	MSFT	Stock	37.08	37.12	36.95	37.12	2092106.0
2013-11-20 15:30:00	MSFT	Stock	37.12	37.185	37.03	37.08	3986231.0
2013-11-20 16:00:00	MSFT	Stock	37.08	37.267	36.789	37.139	2898620.0
2013-11-20 16:30:00	MSFT	Stock	37.12	37.15	37.12	37.15	3942.0
2013-11-20 17:00:00	MSFT	Stock	37.2	37.2	37.02	37.09	2744.0
2013-11-20 17:30:00	MSFT	Stock	37.09	37.09	37.09	37.09	200.0
2013-11-20 18:00:00	MSFT	Stock	37.08	37.08	37.08	37.08	650.0

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

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