PREVIEW / stock_30min / 2011-03-28

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-28.parquet
  size:    1.4 MB
  rows:    74,895
  symbols: 3,537

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
2011-03-28 04:00:00	AAPL	Stock	12.5871	12.5893	12.5871	12.5893	16800.0
2011-03-28 04:30:00	AAPL	Stock	12.6071	12.6071	12.5893	12.6071	11200.0
2011-03-28 05:00:00	AAPL	Stock	12.625	12.625	12.6168	12.6196	14280.0
2011-03-28 07:00:00	AAPL	Stock	12.6071	12.655	12.5964	12.6393	149800.0
2011-03-28 07:30:00	AAPL	Stock	12.6254	12.6382	12.6175	12.6311	213780.0
2011-03-28 08:00:00	AAPL	Stock	12.625	12.6429	12.5979	12.6207	1354640.0
2011-03-28 08:30:00	AAPL	Stock	12.6071	12.6332	12.6071	12.6196	476588.0
2011-03-28 09:00:00	AAPL	Stock	12.6232	12.625	12.6111	12.6139	871080.0
2011-03-28 09:30:00	AAPL	Stock	12.6129	12.6479	12.5714	12.6089	59863580.0
2011-03-28 10:00:00	AAPL	Stock	12.6071	12.6379	12.5918	12.6214	26573820.0
2011-03-28 10:30:00	AAPL	Stock	12.6189	12.6543	12.6171	12.6368	25410000.0
2011-03-28 11:00:00	AAPL	Stock	12.6371	12.6411	12.6179	12.6239	16854992.0
2011-03-28 11:30:00	AAPL	Stock	12.6232	12.6268	12.5643	12.5954	26127640.0
2011-03-28 12:00:00	AAPL	Stock	12.5957	12.6046	12.5782	12.5986	10807860.0
2011-03-28 12:30:00	AAPL	Stock	12.5982	12.6157	12.5968	12.6071	9147124.0
2011-03-28 13:00:00	AAPL	Stock	12.6071	12.6271	12.6068	12.625	10486560.0
2011-03-28 13:30:00	AAPL	Stock	12.625	12.6321	12.6121	12.6139	8271872.0
2011-03-28 14:00:00	AAPL	Stock	12.6136	12.6246	12.6029	12.6152	10252760.0
2011-03-28 14:30:00	AAPL	Stock	12.6157	12.6243	12.5811	12.5841	16625280.0
2011-03-28 15:00:00	AAPL	Stock	12.5831	12.605	12.5793	12.5832	13315428.0
2011-03-28 15:30:00	AAPL	Stock	12.5852	12.5852	12.5157	12.5161	54739496.0
2011-03-28 16:00:00	AAPL	Stock	12.5179	12.6029	12.5004	12.5125	10240440.0
2011-03-28 16:30:00	AAPL	Stock	12.5161	12.5819	12.5071	12.5125	127680.0
2011-03-28 17:00:00	AAPL	Stock	12.5118	12.5118	12.4936	12.4964	545104.0
2011-03-28 17:30:00	AAPL	Stock	12.4964	12.5157	12.4964	12.4982	600936.0
2011-03-28 18:00:00	AAPL	Stock	12.4975	12.5157	12.4975	12.4975	72408.0
2011-03-28 18:30:00	AAPL	Stock	12.5	12.5036	12.4954	12.5	232904.0
2011-03-28 19:00:00	AAPL	Stock	12.5	12.5	12.4968	12.5	28560.0
2011-03-28 19:30:00	AAPL	Stock	12.4971	12.5	12.4936	12.4993	195188.0
2011-03-28 07:30:00	MSFT	Stock	25.68	25.68	25.68	25.68	200.0
2011-03-28 08:00:00	MSFT	Stock	25.65	25.7	25.63	25.69	5300.0
2011-03-28 08:30:00	MSFT	Stock	25.67	25.73	25.67	25.68	13830.0
2011-03-28 09:00:00	MSFT	Stock	25.72	25.73	25.66	25.66	8738.0
2011-03-28 09:30:00	MSFT	Stock	25.67	25.72	25.53	25.63	2810270.0
2011-03-28 10:00:00	MSFT	Stock	25.63	25.7	25.6	25.66	2819468.0
2011-03-28 10:30:00	MSFT	Stock	25.66	25.66	25.61	25.63	2253772.0
2011-03-28 11:00:00	MSFT	Stock	25.63	25.64	25.62	25.625	1920320.0
2011-03-28 11:30:00	MSFT	Stock	25.625	25.64	25.59	25.63	2044315.0
2011-03-28 12:00:00	MSFT	Stock	25.62	25.64	25.6	25.608	1890413.0
2011-03-28 12:30:00	MSFT	Stock	25.6	25.63	25.57	25.61	3869362.0
2011-03-28 13:00:00	MSFT	Stock	25.6	25.62	25.59	25.59	1719587.0
2011-03-28 13:30:00	MSFT	Stock	25.598	25.6	25.54	25.541	2775626.0
2011-03-28 14:00:00	MSFT	Stock	25.54	25.58	25.52	25.565	2367928.0
2011-03-28 14:30:00	MSFT	Stock	25.57	25.59	25.55	25.57	5776584.0
2011-03-28 15:00:00	MSFT	Stock	25.575	25.585	25.52	25.52	2283238.0
2011-03-28 15:30:00	MSFT	Stock	25.53	25.54	25.38	25.41	12912628.0
2011-03-28 16:00:00	MSFT	Stock	25.41	25.63	25.34	25.63	1964084.0
2011-03-28 16:30:00	MSFT	Stock	25.4	25.591	25.4	25.42	22500.0
2011-03-28 17:00:00	MSFT	Stock	25.42	25.42	25.41	25.42	3600.0
2011-03-28 17:30:00	MSFT	Stock	25.41	25.41	25.4	25.4	40914.0

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

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