PREVIEW / stock_30min / 2011-07-07

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-07.parquet
  size:    1.5 MB
  rows:    78,077
  symbols: 3,548

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-07-07 05:00:00	AAPL	Stock	12.6089	12.6154	12.6089	12.6154	5600.0
2011-07-07 06:00:00	AAPL	Stock	12.6107	12.6107	12.6071	12.6071	14000.0
2011-07-07 06:30:00	AAPL	Stock	12.6046	12.6046	12.6046	12.6046	2800.0
2011-07-07 07:00:00	AAPL	Stock	12.6039	12.6043	12.5889	12.5896	56000.0
2011-07-07 07:30:00	AAPL	Stock	12.5943	12.5964	12.575	12.5964	49000.0
2011-07-07 08:00:00	AAPL	Stock	12.5964	12.6607	12.5718	12.6429	1789844.0
2011-07-07 08:30:00	AAPL	Stock	12.65	12.6732	12.6425	12.6646	1562848.0
2011-07-07 09:00:00	AAPL	Stock	12.6675	12.675	12.6607	12.6736	1141056.0
2011-07-07 09:30:00	AAPL	Stock	12.6696	12.7304	12.6429	12.7075	72637208.0
2011-07-07 10:00:00	AAPL	Stock	12.7082	12.7275	12.6825	12.7135	44137800.0
2011-07-07 10:30:00	AAPL	Stock	12.7107	12.7536	12.7068	12.7439	37717092.0
2011-07-07 11:00:00	AAPL	Stock	12.7432	12.7611	12.7218	12.7282	25478516.0
2011-07-07 11:30:00	AAPL	Stock	12.7286	12.7496	12.7211	12.7429	15324036.0
2011-07-07 12:00:00	AAPL	Stock	12.7429	12.7479	12.7257	12.7289	14470848.0
2011-07-07 12:30:00	AAPL	Stock	12.7275	12.7543	12.71	12.7525	27880272.0
2011-07-07 13:00:00	AAPL	Stock	12.7539	12.7857	12.7475	12.7718	25972408.0
2011-07-07 13:30:00	AAPL	Stock	12.7725	12.7761	12.7571	12.7629	12922532.0
2011-07-07 14:00:00	AAPL	Stock	12.7629	12.7821	12.7589	12.7779	15433936.0
2011-07-07 14:30:00	AAPL	Stock	12.7779	12.7854	12.7704	12.7791	14940520.0
2011-07-07 15:00:00	AAPL	Stock	12.7793	12.7857	12.7654	12.77	27291348.0
2011-07-07 15:30:00	AAPL	Stock	12.77	12.7839	12.7536	12.7575	43894088.0
2011-07-07 16:00:00	AAPL	Stock	12.7575	12.7727	12.7245	12.7675	8004696.0
2011-07-07 16:30:00	AAPL	Stock	12.7679	12.7693	12.7341	12.765	446488.0
2011-07-07 17:00:00	AAPL	Stock	12.7693	12.7796	12.7631	12.7796	279300.0
2011-07-07 17:30:00	AAPL	Stock	12.7796	12.7857	12.7571	12.7818	571340.0
2011-07-07 18:00:00	AAPL	Stock	12.7793	12.7839	12.7571	12.7811	360892.0
2011-07-07 18:30:00	AAPL	Stock	12.7814	12.7818	12.7757	12.7804	56056.0
2011-07-07 19:00:00	AAPL	Stock	12.7818	12.7893	12.7814	12.7893	173180.0
2011-07-07 19:30:00	AAPL	Stock	12.7861	12.7911	12.7821	12.7911	99764.0
2011-07-07 06:30:00	MSFT	Stock	26.39	26.39	26.39	26.39	100.0
2011-07-07 07:00:00	MSFT	Stock	26.42	26.44	26.41	26.41	1200.0
2011-07-07 07:30:00	MSFT	Stock	26.46	26.46	26.46	26.46	400.0
2011-07-07 08:00:00	MSFT	Stock	26.47	26.63	26.46	26.55	33755.0
2011-07-07 08:30:00	MSFT	Stock	26.57	26.57	26.52	26.52	47908.0
2011-07-07 09:00:00	MSFT	Stock	26.52	26.55	26.43	26.53	130688.0
2011-07-07 09:30:00	MSFT	Stock	26.51	26.7	26.36	26.7	8720598.0
2011-07-07 10:00:00	MSFT	Stock	26.69	26.77	26.63	26.737	4989104.0
2011-07-07 10:30:00	MSFT	Stock	26.73	26.75	26.59	26.64	3962136.0
2011-07-07 11:00:00	MSFT	Stock	26.64	26.67	26.62	26.64	2441760.0
2011-07-07 11:30:00	MSFT	Stock	26.63	26.67	26.61	26.67	1790038.0
2011-07-07 12:00:00	MSFT	Stock	26.67	26.72	26.65	26.72	2397377.0
2011-07-07 12:30:00	MSFT	Stock	26.72	26.75	26.69	26.735	2134616.0
2011-07-07 13:00:00	MSFT	Stock	26.74	26.785	26.73	26.75	2588506.0
2011-07-07 13:30:00	MSFT	Stock	26.759	26.8	26.73	26.75	2084248.0
2011-07-07 14:00:00	MSFT	Stock	26.75	26.83	26.75	26.83	2702289.0
2011-07-07 14:30:00	MSFT	Stock	26.83	26.85	26.81	26.85	4014249.0
2011-07-07 15:00:00	MSFT	Stock	26.85	26.88	26.82	26.82	3113262.0
2011-07-07 15:30:00	MSFT	Stock	26.828	26.84	26.725	26.77	7293824.0
2011-07-07 16:00:00	MSFT	Stock	26.76	26.84	26.671	26.79	2418080.0
2011-07-07 16:30:00	MSFT	Stock	26.721	26.825	26.721	26.8	151450.0

> showing 50 of 78,077 rows — these rows as CSV

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