PREVIEW / stock_30min / 2011-09-06

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-06.parquet
  size:    1.4 MB
  rows:    76,951
  symbols: 3,505

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-09-06 04:00:00	AAPL	Stock	13.2143	13.3025	13.165	13.2357	187460.0
2011-09-06 04:30:00	AAPL	Stock	13.2296	13.2296	13.2296	13.2296	2800.0
2011-09-06 05:00:00	AAPL	Stock	13.24	13.2514	13.2171	13.2514	14000.0
2011-09-06 05:30:00	AAPL	Stock	13.2346	13.25	13.2339	13.25	14000.0
2011-09-06 06:00:00	AAPL	Stock	13.2661	13.2661	13.2661	13.2661	2800.0
2011-09-06 06:30:00	AAPL	Stock	13.2686	13.2696	13.2554	13.2554	11340.0
2011-09-06 07:00:00	AAPL	Stock	13.2636	13.2636	13.165	13.1696	297304.0
2011-09-06 07:30:00	AAPL	Stock	13.1746	13.1789	13.1532	13.1689	270368.0
2011-09-06 08:00:00	AAPL	Stock	13.1561	13.1764	13.1071	13.1218	1680280.0
2011-09-06 08:30:00	AAPL	Stock	13.1268	13.1357	13.0921	13.1218	1428672.0
2011-09-06 09:00:00	AAPL	Stock	13.1211	13.1561	13.1039	13.11	2211860.0
2011-09-06 09:30:00	AAPL	Stock	13.11	13.2411	13.0886	13.2004	62140848.0
2011-09-06 10:00:00	AAPL	Stock	13.2096	13.265	13.1696	13.2126	48778044.0
2011-09-06 10:30:00	AAPL	Stock	13.2129	13.2939	13.2064	13.2918	39571196.0
2011-09-06 11:00:00	AAPL	Stock	13.2932	13.3443	13.2536	13.3435	37375240.0
2011-09-06 11:30:00	AAPL	Stock	13.34	13.3604	13.2854	13.3064	30341584.0
2011-09-06 12:00:00	AAPL	Stock	13.3046	13.3746	13.2943	13.3532	21969668.0
2011-09-06 12:30:00	AAPL	Stock	13.3536	13.3554	13.3	13.3168	13058080.0
2011-09-06 13:00:00	AAPL	Stock	13.3175	13.3668	13.3007	13.3314	17821664.0
2011-09-06 13:30:00	AAPL	Stock	13.3325	13.3925	13.3036	13.385	23076564.0
2011-09-06 14:00:00	AAPL	Stock	13.3832	13.4893	13.3812	13.4654	40590788.0
2011-09-06 14:30:00	AAPL	Stock	13.4657	13.4875	13.4457	13.4686	24107692.0
2011-09-06 15:00:00	AAPL	Stock	13.47	13.4729	13.4064	13.4196	29996848.0
2011-09-06 15:30:00	AAPL	Stock	13.4171	13.5832	13.3893	13.5536	60984392.0
2011-09-06 16:00:00	AAPL	Stock	13.5646	13.5782	13.335	13.5771	43524684.0
2011-09-06 16:30:00	AAPL	Stock	13.5682	13.5818	13.1955	13.5796	664076.0
2011-09-06 17:00:00	AAPL	Stock	13.5793	13.5804	13.5714	13.5729	194712.0
2011-09-06 17:30:00	AAPL	Stock	13.5768	13.58	13.5732	13.5779	76888.0
2011-09-06 18:00:00	AAPL	Stock	13.5732	13.5811	13.5621	13.5621	222040.0
2011-09-06 18:30:00	AAPL	Stock	13.5732	13.5814	13.5714	13.5789	255864.0
2011-09-06 19:00:00	AAPL	Stock	13.5786	13.5964	13.5714	13.5964	230524.0
2011-09-06 19:30:00	AAPL	Stock	13.5907	13.5929	13.5768	13.5918	370104.0
2011-09-06 04:00:00	MSFT	Stock	25.51	25.51	25.51	25.51	117.0
2011-09-06 04:30:00	MSFT	Stock	25.44	25.44	25.44	25.44	100.0
2011-09-06 07:00:00	MSFT	Stock	25.53	25.53	25.41	25.41	3500.0
2011-09-06 07:30:00	MSFT	Stock	25.37	25.45	25.37	25.41	12486.0
2011-09-06 08:00:00	MSFT	Stock	25.44	25.46	25.37	25.37	14302.0
2011-09-06 08:30:00	MSFT	Stock	25.37	25.4	25.18	25.23	43480.0
2011-09-06 09:00:00	MSFT	Stock	25.25	25.41	25.17	25.23	143447.0
2011-09-06 09:30:00	MSFT	Stock	25.22	25.39	25.15	25.235	6996347.0
2011-09-06 10:00:00	MSFT	Stock	25.24	25.37	25.11	25.19	5649259.0
2011-09-06 10:30:00	MSFT	Stock	25.19	25.299	25.11	25.295	4096599.0
2011-09-06 11:00:00	MSFT	Stock	25.3	25.3	25.22	25.263	3136648.0
2011-09-06 11:30:00	MSFT	Stock	25.27	25.32	25.18	25.27	2638973.0
2011-09-06 12:00:00	MSFT	Stock	25.27	25.35	25.25	25.295	1948977.0
2011-09-06 12:30:00	MSFT	Stock	25.29	25.3	25.22	25.255	1975069.0
2011-09-06 13:00:00	MSFT	Stock	25.255	25.35	25.22	25.292	1655436.0
2011-09-06 13:30:00	MSFT	Stock	25.29	25.35	25.23	25.3	2329101.0
2011-09-06 14:00:00	MSFT	Stock	25.305	25.42	25.26	25.36	2728367.0
2011-09-06 14:30:00	MSFT	Stock	25.37	25.38	25.25	25.28	2492817.0

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

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