PREVIEW / stock_30min / 2013-01-16

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-16.parquet
  size:    1.4 MB
  rows:    74,697
  symbols: 3,463

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-01-16 04:00:00	AAPL	Stock	17.4989	17.4989	17.4125	17.4243	28000.0
2013-01-16 04:30:00	AAPL	Stock	17.4371	17.4371	17.4289	17.4289	5600.0
2013-01-16 05:00:00	AAPL	Stock	17.4336	17.4339	17.4111	17.4321	27020.0
2013-01-16 05:30:00	AAPL	Stock	17.4214	17.4371	17.3932	17.3932	83944.0
2013-01-16 06:00:00	AAPL	Stock	17.4282	17.4679	17.4282	17.4643	69552.0
2013-01-16 06:30:00	AAPL	Stock	17.4814	17.4929	17.4025	17.4439	339556.0
2013-01-16 07:00:00	AAPL	Stock	17.4432	17.5396	17.4286	17.4689	1255576.0
2013-01-16 07:30:00	AAPL	Stock	17.4704	17.6375	17.4529	17.6	1858332.0
2013-01-16 08:00:00	AAPL	Stock	17.6043	17.6786	17.5	17.5807	5323696.0
2013-01-16 08:30:00	AAPL	Stock	17.5804	17.6411	17.5268	17.61	4478768.0
2013-01-16 09:00:00	AAPL	Stock	17.61	17.6932	17.5714	17.665	7566720.0
2013-01-16 09:30:00	AAPL	Stock	17.6629	17.8507	17.5893	17.8168	152529636.0
2013-01-16 10:00:00	AAPL	Stock	17.8168	18.0154	17.7888	17.98	102461828.0
2013-01-16 10:30:00	AAPL	Stock	17.9785	17.9908	17.8893	17.8904	44663948.0
2013-01-16 11:00:00	AAPL	Stock	17.8886	17.9732	17.8879	17.9477	32468772.0
2013-01-16 11:30:00	AAPL	Stock	17.9479	18.0179	17.9325	17.9671	31776108.0
2013-01-16 12:00:00	AAPL	Stock	17.9696	18.0268	17.9525	18.0054	22428728.0
2013-01-16 12:30:00	AAPL	Stock	18.0057	18.0096	17.9679	17.9771	15766716.0
2013-01-16 13:00:00	AAPL	Stock	17.9736	18.0482	17.97	18.0289	28085820.0
2013-01-16 13:30:00	AAPL	Stock	18.0293	18.1229	18.0239	18.1104	32788672.0
2013-01-16 14:00:00	AAPL	Stock	18.1102	18.1671	18.0607	18.125	39600652.0
2013-01-16 14:30:00	AAPL	Stock	18.1259	18.1904	18.1168	18.1831	32243008.0
2013-01-16 15:00:00	AAPL	Stock	18.1796	18.1943	18.1164	18.1168	33399548.0
2013-01-16 15:30:00	AAPL	Stock	18.1182	18.1407	18.0579	18.0743	61338396.0
2013-01-16 16:00:00	AAPL	Stock	18.075	18.0941	17.9394	18.0679	18272100.0
2013-01-16 16:30:00	AAPL	Stock	18.0704	18.1212	17.9399	18.0925	429016.0
2013-01-16 17:00:00	AAPL	Stock	18.0857	18.0914	18.0536	18.0764	727636.0
2013-01-16 17:30:00	AAPL	Stock	18.0714	18.0929	18.0714	18.0929	246736.0
2013-01-16 18:00:00	AAPL	Stock	18.0843	18.0843	18.0714	18.0782	105420.0
2013-01-16 18:30:00	AAPL	Stock	18.0714	18.075	18.0643	18.0686	187824.0
2013-01-16 19:00:00	AAPL	Stock	18.0739	18.1	18.0714	18.0964	102396.0
2013-01-16 19:30:00	AAPL	Stock	18.0946	18.1054	18.0789	18.1054	410284.0
2013-01-16 07:30:00	MSFT	Stock	27.18	27.18	27.16	27.16	8050.0
2013-01-16 08:00:00	MSFT	Stock	27.15	27.16	27.12	27.13	25550.0
2013-01-16 08:30:00	MSFT	Stock	27.13	27.18	27.13	27.18	13610.0
2013-01-16 09:00:00	MSFT	Stock	27.17	27.25	27.15	27.17	25200.0
2013-01-16 09:30:00	MSFT	Stock	27.15	27.23	27.08	27.18	4911333.0
2013-01-16 10:00:00	MSFT	Stock	27.175	27.21	27.09	27.19	3812827.0
2013-01-16 10:30:00	MSFT	Stock	27.185	27.23	27.1	27.139	3135123.0
2013-01-16 11:00:00	MSFT	Stock	27.13	27.2	27.12	27.19	2464541.0
2013-01-16 11:30:00	MSFT	Stock	27.185	27.21	27.13	27.14	1691384.0
2013-01-16 12:00:00	MSFT	Stock	27.15	27.155	27.1	27.13	1651047.0
2013-01-16 12:30:00	MSFT	Stock	27.12	27.13	27.01	27.08	2333123.0
2013-01-16 13:00:00	MSFT	Stock	27.07	27.08	27.02	27.022	1621842.0
2013-01-16 13:30:00	MSFT	Stock	27.03	27.11	27.02	27.095	1919703.0
2013-01-16 14:00:00	MSFT	Stock	27.09	27.15	27.07	27.145	1849483.0
2013-01-16 14:30:00	MSFT	Stock	27.15	27.17	27.13	27.15	1508951.0
2013-01-16 15:00:00	MSFT	Stock	27.145	27.15	27.06	27.068	2012599.0
2013-01-16 15:30:00	MSFT	Stock	27.065	27.14	27.01	27.02	7374023.0
2013-01-16 16:00:00	MSFT	Stock	27.01	27.21	27.0	27.04	3911748.0

> showing 50 of 74,697 rows — these rows as CSV

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