PREVIEW / stock_30min / 2012-04-20

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-04-20.parquet
  size:    1.4 MB
  rows:    77,376
  symbols: 3,515

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-04-20 04:00:00	AAPL	Stock	21.0	21.0614	21.0	21.0546	46088.0
2012-04-20 04:30:00	AAPL	Stock	21.0518	21.0518	21.0	21.0039	55972.0
2012-04-20 05:00:00	AAPL	Stock	20.9821	20.9821	20.9643	20.9786	30800.0
2012-04-20 05:30:00	AAPL	Stock	20.9821	20.9821	20.9821	20.9821	2800.0
2012-04-20 06:00:00	AAPL	Stock	21.0189	21.0393	21.0189	21.0393	33320.0
2012-04-20 06:30:00	AAPL	Stock	21.0664	21.0714	21.0482	21.0714	49000.0
2012-04-20 07:00:00	AAPL	Stock	21.0714	21.0718	21.0018	21.0171	559440.0
2012-04-20 07:30:00	AAPL	Stock	21.0171	21.0171	20.9018	20.9361	924252.0
2012-04-20 08:00:00	AAPL	Stock	20.9432	21.0711	20.9289	20.9664	2734312.0
2012-04-20 08:30:00	AAPL	Stock	20.9689	21.0536	20.9168	21.0536	3066588.0
2012-04-20 09:00:00	AAPL	Stock	21.0507	21.1425	21.0507	21.1339	6060124.0
2012-04-20 09:30:00	AAPL	Stock	21.1321	21.2186	20.79	21.2171	158730628.0
2012-04-20 10:00:00	AAPL	Stock	21.2207	21.2364	21.0214	21.1011	76938764.0
2012-04-20 10:30:00	AAPL	Stock	21.1007	21.1086	20.9379	20.9682	58714348.0
2012-04-20 11:00:00	AAPL	Stock	20.9679	20.9679	20.8661	20.8675	40017068.0
2012-04-20 11:30:00	AAPL	Stock	20.8679	20.9164	20.7664	20.8761	56713524.0
2012-04-20 12:00:00	AAPL	Stock	20.8761	20.9329	20.7536	20.7861	51592632.0
2012-04-20 12:30:00	AAPL	Stock	20.7868	20.8393	20.7371	20.74	34128024.0
2012-04-20 13:00:00	AAPL	Stock	20.7393	20.7804	20.6071	20.6082	62100668.0
2012-04-20 13:30:00	AAPL	Stock	20.6071	20.6593	20.575	20.6018	60329696.0
2012-04-20 14:00:00	AAPL	Stock	20.6032	20.6132	20.5136	20.5996	75769764.0
2012-04-20 14:30:00	AAPL	Stock	20.5961	20.6071	20.4504	20.4504	64408036.0
2012-04-20 15:00:00	AAPL	Stock	20.4532	20.5282	20.3982	20.4368	97563424.0
2012-04-20 15:30:00	AAPL	Stock	20.4371	20.4975	20.3721	20.443	116254936.0
2012-04-20 16:00:00	AAPL	Stock	20.4446	20.7568	20.4429	20.4696	18467372.0
2012-04-20 16:30:00	AAPL	Stock	20.4732	20.8059	20.4333	20.5389	3156664.0
2012-04-20 17:00:00	AAPL	Stock	20.5357	20.5371	20.4636	20.4904	1021944.0
2012-04-20 17:30:00	AAPL	Stock	20.4911	20.4946	20.47	20.4886	307804.0
2012-04-20 18:00:00	AAPL	Stock	20.4943	20.5	20.4714	20.4768	264264.0
2012-04-20 18:30:00	AAPL	Stock	20.4768	20.4814	20.4679	20.4811	76888.0
2012-04-20 19:00:00	AAPL	Stock	20.4771	20.4986	20.4771	20.4911	114772.0
2012-04-20 19:30:00	AAPL	Stock	20.4871	20.4918	20.4682	20.4714	257740.0
2012-04-20 06:30:00	MSFT	Stock	32.0	32.0	32.0	32.0	300.0
2012-04-20 07:00:00	MSFT	Stock	32.0	32.08	32.0	32.07	10404.0
2012-04-20 07:30:00	MSFT	Stock	32.08	32.18	32.07	32.11	125876.0
2012-04-20 08:00:00	MSFT	Stock	32.11	32.17	32.06	32.11	178389.0
2012-04-20 08:30:00	MSFT	Stock	32.1	32.14	31.92	32.03	141400.0
2012-04-20 09:00:00	MSFT	Stock	32.02	32.22	31.97	32.16	531583.0
2012-04-20 09:30:00	MSFT	Stock	32.16	32.53	32.05	32.523	17259790.0
2012-04-20 10:00:00	MSFT	Stock	32.53	32.79	32.46	32.648	12721576.0
2012-04-20 10:30:00	MSFT	Stock	32.645	32.79	32.56	32.7	8128554.0
2012-04-20 11:00:00	MSFT	Stock	32.7	32.78	32.67	32.73	4620338.0
2012-04-20 11:30:00	MSFT	Stock	32.73	32.785	32.64	32.7	4116848.0
2012-04-20 12:00:00	MSFT	Stock	32.7	32.75	32.635	32.73	3944607.0
2012-04-20 12:30:00	MSFT	Stock	32.733	32.79	32.73	32.737	3308033.0
2012-04-20 13:00:00	MSFT	Stock	32.74	32.832	32.71	32.805	4435494.0
2012-04-20 13:30:00	MSFT	Stock	32.8	32.89	32.75	32.79	5507894.0
2012-04-20 14:00:00	MSFT	Stock	32.79	32.79	32.64	32.76	5975430.0
2012-04-20 14:30:00	MSFT	Stock	32.75	32.78	32.65	32.651	3428279.0
2012-04-20 15:00:00	MSFT	Stock	32.655	32.72	32.53	32.555	5295791.0

> showing 50 of 77,376 rows — these rows as CSV

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