PREVIEW / stock_30min / 2012-02-27

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-27.parquet
  size:    1.4 MB
  rows:    76,045
  symbols: 3,532

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
2012-02-27 04:00:00	AAPL	Stock	18.5804	18.5804	18.5804	18.5804	33600.0
2012-02-27 05:00:00	AAPL	Stock	18.5804	18.5804	18.5804	18.5804	5600.0
2012-02-27 05:30:00	AAPL	Stock	18.565	18.565	18.5571	18.5571	11200.0
2012-02-27 06:00:00	AAPL	Stock	18.565	18.5714	18.565	18.5714	8372.0
2012-02-27 06:30:00	AAPL	Stock	18.5714	18.5714	18.5571	18.5571	22708.0
2012-02-27 07:00:00	AAPL	Stock	18.5675	18.6032	18.5575	18.5643	110740.0
2012-02-27 07:30:00	AAPL	Stock	18.5643	18.5754	18.5571	18.5711	206192.0
2012-02-27 08:00:00	AAPL	Stock	18.5714	18.6179	18.5714	18.6179	1349600.0
2012-02-27 08:30:00	AAPL	Stock	18.6146	18.6361	18.6107	18.6268	1315944.0
2012-02-27 09:00:00	AAPL	Stock	18.6318	18.6536	18.6071	18.6207	1414196.0
2012-02-27 09:30:00	AAPL	Stock	18.6182	18.6493	18.4386	18.5204	87208212.0
2012-02-27 10:00:00	AAPL	Stock	18.5179	18.5929	18.5014	18.575	45828524.0
2012-02-27 10:30:00	AAPL	Stock	18.5725	18.6607	18.5575	18.6221	42787360.0
2012-02-27 11:00:00	AAPL	Stock	18.6204	18.7321	18.6139	18.7004	44669828.0
2012-02-27 11:30:00	AAPL	Stock	18.7004	18.7407	18.6943	18.7175	28464296.0
2012-02-27 12:00:00	AAPL	Stock	18.7182	18.7589	18.6996	18.7371	38598700.0
2012-02-27 12:30:00	AAPL	Stock	18.7361	18.7971	18.7182	18.7864	33226872.0
2012-02-27 13:00:00	AAPL	Stock	18.7864	18.7921	18.7521	18.7639	19237288.0
2012-02-27 13:30:00	AAPL	Stock	18.7629	18.7896	18.7589	18.7729	15760668.0
2012-02-27 14:00:00	AAPL	Stock	18.7721	18.8532	18.7721	18.8236	35646856.0
2012-02-27 14:30:00	AAPL	Stock	18.8236	18.8564	18.8157	18.8519	23622704.0
2012-02-27 15:00:00	AAPL	Stock	18.8546	18.875	18.7339	18.7846	65189236.0
2012-02-27 15:30:00	AAPL	Stock	18.7843	18.8357	18.7786	18.7786	48467776.0
2012-02-27 16:00:00	AAPL	Stock	18.7789	18.8042	18.7006	18.775	8510376.0
2012-02-27 16:30:00	AAPL	Stock	18.7718	18.8074	18.7679	18.7786	514752.0
2012-02-27 17:00:00	AAPL	Stock	18.7771	18.7818	18.7714	18.7779	325388.0
2012-02-27 17:30:00	AAPL	Stock	18.7771	18.7918	18.7768	18.7857	544768.0
2012-02-27 18:00:00	AAPL	Stock	18.7807	18.785	18.7793	18.7836	93324.0
2012-02-27 18:30:00	AAPL	Stock	18.7807	18.7821	18.7714	18.78	243236.0
2012-02-27 19:00:00	AAPL	Stock	18.78	18.7864	18.7729	18.7864	430612.0
2012-02-27 19:30:00	AAPL	Stock	18.7864	18.7921	18.7832	18.7921	428792.0
2012-02-27 04:30:00	MSFT	Stock	31.45	31.45	31.45	31.45	200.0
2012-02-27 08:00:00	MSFT	Stock	31.36	31.39	31.35	31.36	3100.0
2012-02-27 08:30:00	MSFT	Stock	31.38	31.4	31.38	31.4	1300.0
2012-02-27 09:00:00	MSFT	Stock	31.4	31.4	31.24	31.25	27366.0
2012-02-27 09:30:00	MSFT	Stock	31.25	31.3	31.1	31.16	5536522.0
2012-02-27 10:00:00	MSFT	Stock	31.16	31.34	31.15	31.32	2439885.0
2012-02-27 10:30:00	MSFT	Stock	31.32	31.42	31.25	31.37	2011880.0
2012-02-27 11:00:00	MSFT	Stock	31.37	31.48	31.36	31.425	3234615.0
2012-02-27 11:30:00	MSFT	Stock	31.425	31.45	31.37	31.41	2911755.0
2012-02-27 12:00:00	MSFT	Stock	31.402	31.47	31.4	31.47	1189055.0
2012-02-27 12:30:00	MSFT	Stock	31.46	31.5	31.43	31.495	2304240.0
2012-02-27 13:00:00	MSFT	Stock	31.49	31.5	31.45	31.45	1182696.0
2012-02-27 13:30:00	MSFT	Stock	31.45	31.46	31.37	31.395	1217762.0
2012-02-27 14:00:00	MSFT	Stock	31.393	31.45	31.39	31.41	1197749.0
2012-02-27 14:30:00	MSFT	Stock	31.41	31.45	31.395	31.429	1151308.0
2012-02-27 15:00:00	MSFT	Stock	31.42	31.49	31.39	31.41	2262324.0
2012-02-27 15:30:00	MSFT	Stock	31.41	31.45	31.35	31.36	4765365.0
2012-02-27 16:00:00	MSFT	Stock	31.36	31.484	31.33	31.35	2246210.0
2012-02-27 16:30:00	MSFT	Stock	31.38	31.41	31.34	31.35	16319.0

> showing 50 of 76,045 rows — these rows as CSV

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