PREVIEW / stock_30min / 2014-02-28

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-28.parquet
  size:    1.6 MB
  rows:    83,543
  symbols: 3,536

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
2014-02-28 06:00:00	AAPL	Stock	18.8943	18.9	18.8929	18.8929	16212.0
2014-02-28 07:00:00	AAPL	Stock	18.8929	18.8929	18.8289	18.8339	129640.0
2014-02-28 07:30:00	AAPL	Stock	18.8464	18.8464	18.8346	18.8346	42000.0
2014-02-28 08:00:00	AAPL	Stock	18.8489	18.8493	18.8304	18.8493	172424.0
2014-02-28 08:30:00	AAPL	Stock	18.8493	18.8932	18.8446	18.8829	350364.0
2014-02-28 09:00:00	AAPL	Stock	18.8846	18.9036	18.8671	18.8975	1313312.0
2014-02-28 09:30:00	AAPL	Stock	18.8957	18.9954	18.8486	18.9718	45566836.0
2014-02-28 10:00:00	AAPL	Stock	18.9721	19.0268	18.9061	18.9234	27304984.0
2014-02-28 10:30:00	AAPL	Stock	18.925	18.9754	18.8571	18.8639	21503160.0
2014-02-28 11:00:00	AAPL	Stock	18.8643	18.8925	18.8143	18.8782	17476816.0
2014-02-28 11:30:00	AAPL	Stock	18.8782	18.9279	18.8764	18.9209	10984400.0
2014-02-28 12:00:00	AAPL	Stock	18.9207	18.9214	18.8657	18.8889	10112452.0
2014-02-28 12:30:00	AAPL	Stock	18.8869	18.8914	18.8143	18.838	13019132.0
2014-02-28 13:00:00	AAPL	Stock	18.8361	18.8914	18.8179	18.8646	11952724.0
2014-02-28 13:30:00	AAPL	Stock	18.8625	18.8646	18.6925	18.7371	27319152.0
2014-02-28 14:00:00	AAPL	Stock	18.735	18.7764	18.6864	18.7522	17120096.0
2014-02-28 14:30:00	AAPL	Stock	18.7539	18.7568	18.7143	18.7411	13586076.0
2014-02-28 15:00:00	AAPL	Stock	18.7375	18.7571	18.6471	18.7504	26031572.0
2014-02-28 15:30:00	AAPL	Stock	18.752	18.8186	18.7404	18.7964	29660736.0
2014-02-28 16:00:00	AAPL	Stock	18.7943	18.8426	18.7276	18.7939	40937568.0
2014-02-28 16:30:00	AAPL	Stock	18.7925	18.7999	18.7764	18.7768	889644.0
2014-02-28 17:00:00	AAPL	Stock	18.7804	18.7943	18.7779	18.7821	164668.0
2014-02-28 17:30:00	AAPL	Stock	18.7821	18.7943	18.7764	18.7854	266364.0
2014-02-28 18:00:00	AAPL	Stock	18.7786	18.7786	18.7775	18.7775	28000.0
2014-02-28 18:30:00	AAPL	Stock	18.7786	18.7846	18.7768	18.7821	19068.0
2014-02-28 19:00:00	AAPL	Stock	18.7775	18.7804	18.7768	18.7771	32536.0
2014-02-28 19:30:00	AAPL	Stock	18.7771	18.7814	18.7732	18.7732	109172.0
2014-02-28 07:30:00	MSFT	Stock	37.72	37.72	37.71	37.71	700.0
2014-02-28 08:00:00	MSFT	Stock	37.75	37.75	37.75	37.75	330.0
2014-02-28 08:30:00	MSFT	Stock	37.76	37.8	37.76	37.8	830.0
2014-02-28 09:00:00	MSFT	Stock	37.83	37.99	37.83	37.96	55560.0
2014-02-28 09:30:00	MSFT	Stock	37.98	38.23	37.82	38.2	3969117.0
2014-02-28 10:00:00	MSFT	Stock	38.19	38.46	38.18	38.31	3147548.0
2014-02-28 10:30:00	MSFT	Stock	38.317	38.34	38.19	38.275	1952439.0
2014-02-28 11:00:00	MSFT	Stock	38.27	38.375	38.22	38.335	1744632.0
2014-02-28 11:30:00	MSFT	Stock	38.33	38.4	38.24	38.369	1522532.0
2014-02-28 12:00:00	MSFT	Stock	38.37	38.37	38.28	38.366	1652740.0
2014-02-28 12:30:00	MSFT	Stock	38.365	38.395	38.29	38.33	1185481.0
2014-02-28 13:00:00	MSFT	Stock	38.323	38.34	38.18	38.251	1555080.0
2014-02-28 13:30:00	MSFT	Stock	38.253	38.31	38.23	38.26	1448464.0
2014-02-28 14:00:00	MSFT	Stock	38.25	38.32	38.22	38.315	1565987.0
2014-02-28 14:30:00	MSFT	Stock	38.31	38.31	38.15	38.19	2723619.0
2014-02-28 15:00:00	MSFT	Stock	38.18	38.19	37.88	38.1	3515471.0
2014-02-28 15:30:00	MSFT	Stock	38.095	38.32	38.09	38.31	6020639.0
2014-02-28 16:00:00	MSFT	Stock	38.31	38.35	38.066	38.31	7537431.0
2014-02-28 16:30:00	MSFT	Stock	38.31	38.318	38.19	38.25	102774.0
2014-02-28 17:00:00	MSFT	Stock	38.18	38.31	38.18	38.2	146216.0
2014-02-28 17:30:00	MSFT	Stock	38.2	38.2	38.15	38.15	418.0
2014-02-28 18:00:00	MSFT	Stock	38.15	38.15	38.15	38.15	443.0
2014-02-28 19:30:00	MSFT	Stock	38.15	38.15	38.15	38.15	1525.0

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

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