PREVIEW / stock_30min / 2011-06-08

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-08.parquet
  size:    1.4 MB
  rows:    75,260
  symbols: 3,570

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-06-08 04:00:00	AAPL	Stock	11.8464	11.8464	11.7729	11.8107	14140.0
2011-06-08 04:30:00	AAPL	Stock	11.7857	11.7857	11.7857	11.7857	2800.0
2011-06-08 05:00:00	AAPL	Stock	11.7857	11.7857	11.7843	11.7843	19600.0
2011-06-08 05:30:00	AAPL	Stock	11.8039	11.8039	11.8036	11.8036	8400.0
2011-06-08 06:00:00	AAPL	Stock	11.8061	11.8061	11.8036	11.8036	103600.0
2011-06-08 06:30:00	AAPL	Stock	11.8036	11.8036	11.7918	11.7918	28000.0
2011-06-08 07:00:00	AAPL	Stock	11.8	11.8429	11.8	11.8393	516516.0
2011-06-08 07:30:00	AAPL	Stock	11.8393	11.8393	11.8132	11.8214	239344.0
2011-06-08 08:00:00	AAPL	Stock	11.8168	11.8304	11.7961	11.8286	819280.0
2011-06-08 08:30:00	AAPL	Stock	11.8132	11.875	11.81	11.8554	976500.0
2011-06-08 09:00:00	AAPL	Stock	11.8536	11.8707	11.8393	11.8518	1257536.0
2011-06-08 09:30:00	AAPL	Stock	11.8518	11.9236	11.8089	11.8221	64017884.0
2011-06-08 10:00:00	AAPL	Stock	11.8232	11.9257	11.8189	11.8664	39328352.0
2011-06-08 10:30:00	AAPL	Stock	11.8661	11.9446	11.8393	11.9186	31895976.0
2011-06-08 11:00:00	AAPL	Stock	11.9207	11.9571	11.8943	11.9046	25321772.0
2011-06-08 11:30:00	AAPL	Stock	11.9036	11.9239	11.89	11.9129	16092272.0
2011-06-08 12:00:00	AAPL	Stock	11.9121	11.9225	11.8757	11.8889	13739992.0
2011-06-08 12:30:00	AAPL	Stock	11.8882	11.9107	11.8636	11.9082	11291112.0
2011-06-08 13:00:00	AAPL	Stock	11.9079	11.9143	11.8771	11.8914	8699376.0
2011-06-08 13:30:00	AAPL	Stock	11.8913	11.8939	11.8246	11.8336	20016976.0
2011-06-08 14:00:00	AAPL	Stock	11.8332	11.8836	11.8286	11.8525	18123112.0
2011-06-08 14:30:00	AAPL	Stock	11.8546	11.8925	11.8532	11.8586	15549016.0
2011-06-08 15:00:00	AAPL	Stock	11.8618	11.869	11.8243	11.8289	18145652.0
2011-06-08 15:30:00	AAPL	Stock	11.8286	11.8914	11.8232	11.8682	32816840.0
2011-06-08 16:00:00	AAPL	Stock	11.8625	11.8932	11.8371	11.8614	11662084.0
2011-06-08 16:30:00	AAPL	Stock	11.8629	11.8629	11.8302	11.8571	238280.0
2011-06-08 17:00:00	AAPL	Stock	11.8607	11.8625	11.8582	11.8625	117880.0
2011-06-08 17:30:00	AAPL	Stock	11.8629	11.8646	11.8607	11.8636	115976.0
2011-06-08 18:00:00	AAPL	Stock	11.8621	11.8657	11.8554	11.8554	246876.0
2011-06-08 18:30:00	AAPL	Stock	11.8554	11.8568	11.8532	11.8564	25200.0
2011-06-08 19:00:00	AAPL	Stock	11.8579	11.8636	11.8571	11.8636	59500.0
2011-06-08 19:30:00	AAPL	Stock	11.8607	11.865	11.8557	11.865	110880.0
2011-06-08 04:00:00	MSFT	Stock	24.02	24.02	24.02	24.02	300.0
2011-06-08 07:00:00	MSFT	Stock	23.89	23.89	23.89	23.89	300.0
2011-06-08 07:30:00	MSFT	Stock	23.99	23.99	23.99	23.99	378.0
2011-06-08 08:00:00	MSFT	Stock	23.95	23.98	23.91	23.91	4657.0
2011-06-08 08:30:00	MSFT	Stock	23.91	24.06	23.87	24.06	54604.0
2011-06-08 09:00:00	MSFT	Stock	23.95	24.0	23.86	23.88	182242.0
2011-06-08 09:30:00	MSFT	Stock	23.89	24.02	23.87	23.959	5534255.0
2011-06-08 10:00:00	MSFT	Stock	23.95	23.971	23.86	23.94	3620750.0
2011-06-08 10:30:00	MSFT	Stock	23.94	24.01	23.9	23.95	3313269.0
2011-06-08 11:00:00	MSFT	Stock	23.96	24.01	23.89	23.9	3099095.0
2011-06-08 11:30:00	MSFT	Stock	23.9	23.97	23.89	23.951	2443766.0
2011-06-08 12:00:00	MSFT	Stock	23.95	23.96	23.87	23.89	2457357.0
2011-06-08 12:30:00	MSFT	Stock	23.89	23.98	23.87	23.97	1806147.0
2011-06-08 13:00:00	MSFT	Stock	23.972	24.0	23.93	23.95	1534176.0
2011-06-08 13:30:00	MSFT	Stock	23.95	23.96	23.89	23.925	3147855.0
2011-06-08 14:00:00	MSFT	Stock	23.92	23.97	23.88	23.924	3020434.0
2011-06-08 14:30:00	MSFT	Stock	23.92	23.99	23.92	23.96	2371334.0
2011-06-08 15:00:00	MSFT	Stock	23.969	23.97	23.89	23.906	2199300.0

> showing 50 of 75,260 rows — these rows as CSV

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