PREVIEW / stock_30min / 2013-09-18

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-18.parquet
  size:    1.6 MB
  rows:    80,173
  symbols: 3,511

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-09-18 04:00:00	AAPL	Stock	16.2857	16.4107	16.2857	16.3907	63420.0
2013-09-18 04:30:00	AAPL	Stock	16.3843	16.3929	16.3561	16.3561	86800.0
2013-09-18 05:00:00	AAPL	Stock	16.3607	16.3857	16.3575	16.3811	78400.0
2013-09-18 05:30:00	AAPL	Stock	16.3821	16.3929	16.375	16.375	119784.0
2013-09-18 06:00:00	AAPL	Stock	16.3696	16.3861	16.3668	16.385	35784.0
2013-09-18 06:30:00	AAPL	Stock	16.3757	16.3821	16.3586	16.3607	58800.0
2013-09-18 07:00:00	AAPL	Stock	16.375	16.4446	16.3718	16.4429	773164.0
2013-09-18 07:30:00	AAPL	Stock	16.4357	16.4539	16.395	16.4539	686924.0
2013-09-18 08:00:00	AAPL	Stock	16.4421	16.4711	16.3686	16.4568	2178260.0
2013-09-18 08:30:00	AAPL	Stock	16.4539	16.4661	16.4336	16.4532	1037876.0
2013-09-18 09:00:00	AAPL	Stock	16.45	16.5893	16.4371	16.5571	8766912.0
2013-09-18 09:30:00	AAPL	Stock	16.5421	16.5925	16.4775	16.5818	78751708.0
2013-09-18 10:00:00	AAPL	Stock	16.5804	16.6554	16.5475	16.6047	54709452.0
2013-09-18 10:30:00	AAPL	Stock	16.6089	16.6186	16.5564	16.5732	26819856.0
2013-09-18 11:00:00	AAPL	Stock	16.575	16.5939	16.5143	16.5229	23169468.0
2013-09-18 11:30:00	AAPL	Stock	16.525	16.5464	16.4547	16.4782	23465904.0
2013-09-18 12:00:00	AAPL	Stock	16.4768	16.5354	16.4768	16.5114	13480684.0
2013-09-18 12:30:00	AAPL	Stock	16.515	16.5207	16.4943	16.5119	9613464.0
2013-09-18 13:00:00	AAPL	Stock	16.5093	16.5174	16.4757	16.4875	9665404.0
2013-09-18 13:30:00	AAPL	Stock	16.4896	16.5243	16.4521	16.5043	16941792.0
2013-09-18 14:00:00	AAPL	Stock	16.5114	16.6429	16.4857	16.5396	55821780.0
2013-09-18 14:30:00	AAPL	Stock	16.54	16.6364	16.5054	16.6296	29506036.0
2013-09-18 15:00:00	AAPL	Stock	16.6296	16.6375	16.5636	16.5707	26467364.0
2013-09-18 15:30:00	AAPL	Stock	16.5707	16.6168	16.5536	16.5946	37115148.0
2013-09-18 16:00:00	AAPL	Stock	16.5929	16.6007	16.5363	16.5893	32057564.0
2013-09-18 16:30:00	AAPL	Stock	16.5875	16.6043	16.5821	16.5821	322812.0
2013-09-18 17:00:00	AAPL	Stock	16.5961	16.6039	16.59	16.6029	465612.0
2013-09-18 17:30:00	AAPL	Stock	16.6029	16.625	16.5946	16.625	413000.0
2013-09-18 18:00:00	AAPL	Stock	16.6261	16.6407	16.6164	16.6407	182812.0
2013-09-18 18:30:00	AAPL	Stock	16.6407	16.6743	16.6375	16.6743	519904.0
2013-09-18 19:00:00	AAPL	Stock	16.6768	16.7032	16.5946	16.6982	372932.0
2013-09-18 19:30:00	AAPL	Stock	16.7	16.7379	16.6968	16.7346	813372.0
2013-09-18 06:00:00	MSFT	Stock	33.15	33.15	33.15	33.15	500.0
2013-09-18 06:30:00	MSFT	Stock	33.14	33.14	33.14	33.14	200.0
2013-09-18 07:00:00	MSFT	Stock	33.1	33.1	33.1	33.1	500.0
2013-09-18 07:30:00	MSFT	Stock	33.1	33.1	33.1	33.1	200.0
2013-09-18 08:00:00	MSFT	Stock	33.13	33.13	32.97	33.0	40440.0
2013-09-18 08:30:00	MSFT	Stock	33.04	33.05	32.97	32.98	25194.0
2013-09-18 09:00:00	MSFT	Stock	32.99	33.0	32.91	32.97	43335.0
2013-09-18 09:30:00	MSFT	Stock	32.96	33.09	32.86	33.05	5562156.0
2013-09-18 10:00:00	MSFT	Stock	33.05	33.1	32.94	32.945	2875663.0
2013-09-18 10:30:00	MSFT	Stock	32.95	33.18	32.9	33.097	4517814.0
2013-09-18 11:00:00	MSFT	Stock	33.095	33.15	33.0	33.065	2934603.0
2013-09-18 11:30:00	MSFT	Stock	33.065	33.115	32.92	33.01	7131669.0
2013-09-18 12:00:00	MSFT	Stock	33.01	33.017	32.95	32.97	1939547.0
2013-09-18 12:30:00	MSFT	Stock	32.98	33.03	32.96	32.96	1710454.0
2013-09-18 13:00:00	MSFT	Stock	32.965	33.0	32.92	32.935	1830119.0
2013-09-18 13:30:00	MSFT	Stock	32.935	32.97	32.83	32.932	3112165.0
2013-09-18 14:00:00	MSFT	Stock	32.94	33.185	32.935	33.11	8324088.0
2013-09-18 14:30:00	MSFT	Stock	33.115	33.35	33.07	33.35	4516053.0

> showing 50 of 80,173 rows — these rows as CSV

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