PREVIEW / stock_30min / 2014-04-14

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-14.parquet
  size:    1.6 MB
  rows:    82,572
  symbols: 3,558

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-04-14 04:00:00	AAPL	Stock	18.5375	18.5375	18.5375	18.5375	2800.0
2014-04-14 04:30:00	AAPL	Stock	18.5382	18.5382	18.5382	18.5382	2800.0
2014-04-14 05:30:00	AAPL	Stock	18.5039	18.5039	18.4989	18.4989	8400.0
2014-04-14 06:00:00	AAPL	Stock	18.4825	18.4825	18.4643	18.4725	16800.0
2014-04-14 06:30:00	AAPL	Stock	18.4796	18.5004	18.4736	18.5	66920.0
2014-04-14 07:00:00	AAPL	Stock	18.5357	18.5357	18.5107	18.5125	17360.0
2014-04-14 07:30:00	AAPL	Stock	18.5336	18.6071	18.5336	18.6071	37632.0
2014-04-14 08:00:00	AAPL	Stock	18.5893	18.6643	18.5232	18.6368	178276.0
2014-04-14 08:30:00	AAPL	Stock	18.6621	18.6696	18.6429	18.6668	289156.0
2014-04-14 09:00:00	AAPL	Stock	18.6579	18.6761	18.6261	18.6489	922600.0
2014-04-14 09:30:00	AAPL	Stock	18.6393	18.6429	18.4821	18.4965	29443064.0
2014-04-14 10:00:00	AAPL	Stock	18.4964	18.545	18.4875	18.5214	13751808.0
2014-04-14 10:30:00	AAPL	Stock	18.5205	18.555	18.4821	18.4896	16231292.0
2014-04-14 11:00:00	AAPL	Stock	18.4925	18.5279	18.4718	18.5193	10420004.0
2014-04-14 11:30:00	AAPL	Stock	18.5187	18.5964	18.5089	18.5582	10995936.0
2014-04-14 12:00:00	AAPL	Stock	18.5589	18.5718	18.5182	18.5679	5883220.0
2014-04-14 12:30:00	AAPL	Stock	18.5729	18.5936	18.5593	18.5686	6308344.0
2014-04-14 13:00:00	AAPL	Stock	18.5664	18.5857	18.5357	18.5671	4596200.0
2014-04-14 13:30:00	AAPL	Stock	18.5667	18.5764	18.5211	18.5268	5396468.0
2014-04-14 14:00:00	AAPL	Stock	18.5289	18.5786	18.5129	18.5257	6729884.0
2014-04-14 14:30:00	AAPL	Stock	18.5225	18.5739	18.5132	18.5507	5426260.0
2014-04-14 15:00:00	AAPL	Stock	18.5507	18.5607	18.4968	18.5311	8583344.0
2014-04-14 15:30:00	AAPL	Stock	18.5296	18.6486	18.5264	18.6319	23582972.0
2014-04-14 16:00:00	AAPL	Stock	18.6314	18.6511	18.554	18.6314	14947492.0
2014-04-14 16:30:00	AAPL	Stock	18.5187	18.6393	18.5187	18.6379	210364.0
2014-04-14 17:00:00	AAPL	Stock	18.6357	18.6357	18.6271	18.6332	232260.0
2014-04-14 17:30:00	AAPL	Stock	18.6304	18.6321	18.6304	18.6321	16268.0
2014-04-14 18:00:00	AAPL	Stock	18.6268	18.6286	18.6125	18.6286	71904.0
2014-04-14 18:30:00	AAPL	Stock	18.6314	18.6329	18.6239	18.6329	574056.0
2014-04-14 19:00:00	AAPL	Stock	18.6329	18.6339	18.6286	18.6304	50400.0
2014-04-14 19:30:00	AAPL	Stock	18.6196	18.6321	18.6196	18.6321	18172.0
2014-04-14 04:00:00	MSFT	Stock	39.24	39.24	38.96	38.96	2460.0
2014-04-14 04:30:00	MSFT	Stock	38.94	38.94	38.94	38.94	200.0
2014-04-14 05:00:00	MSFT	Stock	38.9	38.9	38.9	38.9	300.0
2014-04-14 06:00:00	MSFT	Stock	38.9	38.9	38.9	38.9	100.0
2014-04-14 06:30:00	MSFT	Stock	38.9	38.9	38.88	38.88	600.0
2014-04-14 07:00:00	MSFT	Stock	38.9	38.93	38.9	38.93	3100.0
2014-04-14 08:00:00	MSFT	Stock	39.07	39.09	38.92	38.94	21273.0
2014-04-14 08:30:00	MSFT	Stock	39.0	39.09	39.0	39.05	27244.0
2014-04-14 09:00:00	MSFT	Stock	39.04	39.19	39.0	39.13	32788.0
2014-04-14 09:30:00	MSFT	Stock	39.11	39.4	38.9	38.92	5820214.0
2014-04-14 10:00:00	MSFT	Stock	38.93	39.17	38.9	39.131	2938895.0
2014-04-14 10:30:00	MSFT	Stock	39.13	39.19	39.06	39.18	2152224.0
2014-04-14 11:00:00	MSFT	Stock	39.19	39.31	39.17	39.285	2084623.0
2014-04-14 11:30:00	MSFT	Stock	39.288	39.41	39.25	39.26	1967401.0
2014-04-14 12:00:00	MSFT	Stock	39.26	39.35	39.2	39.295	850007.0
2014-04-14 12:30:00	MSFT	Stock	39.3	39.33	39.25	39.32	780871.0
2014-04-14 13:00:00	MSFT	Stock	39.32	39.326	39.16	39.17	760542.0
2014-04-14 13:30:00	MSFT	Stock	39.16	39.254	39.104	39.11	720789.0
2014-04-14 14:00:00	MSFT	Stock	39.11	39.17	39.05	39.15	1472639.0

> showing 50 of 82,572 rows — these rows as CSV

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