PREVIEW / stock_30min / 2011-01-10

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-10.parquet
  size:    1.4 MB
  rows:    76,390
  symbols: 3,521

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-01-10 04:00:00	AAPL	Stock	12.0786	12.0889	12.0786	12.0889	19600.0
2011-01-10 04:30:00	AAPL	Stock	12.1093	12.1093	12.1093	12.1093	2800.0
2011-01-10 05:00:00	AAPL	Stock	12.1071	12.1071	12.1071	12.1071	2800.0
2011-01-10 05:30:00	AAPL	Stock	12.1179	12.1179	12.1071	12.1071	47600.0
2011-01-10 06:00:00	AAPL	Stock	12.1157	12.1357	12.1071	12.1357	40516.0
2011-01-10 06:30:00	AAPL	Stock	12.1268	12.1268	12.1046	12.1071	76888.0
2011-01-10 07:00:00	AAPL	Stock	12.1071	12.1071	12.0843	12.1	140364.0
2011-01-10 07:30:00	AAPL	Stock	12.0961	12.1032	12.0536	12.0539	710080.0
2011-01-10 08:00:00	AAPL	Stock	12.0618	12.0936	12.0589	12.0936	2547608.0
2011-01-10 08:30:00	AAPL	Stock	12.0946	12.1114	12.0821	12.0893	2487632.0
2011-01-10 09:00:00	AAPL	Stock	12.0929	12.0946	12.0679	12.0946	1602384.0
2011-01-10 09:30:00	AAPL	Stock	12.0968	12.1729	12.0418	12.12	87210704.0
2011-01-10 10:00:00	AAPL	Stock	12.1186	12.1489	12.0811	12.1321	42988736.0
2011-01-10 10:30:00	AAPL	Stock	12.1332	12.1507	12.1136	12.125	22284136.0
2011-01-10 11:00:00	AAPL	Stock	12.1214	12.1282	12.1107	12.1193	14442568.0
2011-01-10 11:30:00	AAPL	Stock	12.1193	12.1757	12.1157	12.1721	25663792.0
2011-01-10 12:00:00	AAPL	Stock	12.1721	12.1925	12.1629	12.1804	27058668.0
2011-01-10 12:30:00	AAPL	Stock	12.1825	12.2043	12.1714	12.1914	24199028.0
2011-01-10 13:00:00	AAPL	Stock	12.1907	12.2082	12.1839	12.1998	16870112.0
2011-01-10 13:30:00	AAPL	Stock	12.2011	12.2168	12.1911	12.2054	20819680.0
2011-01-10 14:00:00	AAPL	Stock	12.2057	12.2071	12.1914	12.2032	11848564.0
2011-01-10 14:30:00	AAPL	Stock	12.2023	12.2068	12.1893	12.2043	13984180.0
2011-01-10 15:00:00	AAPL	Stock	12.2043	12.2386	12.1961	12.2332	27983396.0
2011-01-10 15:30:00	AAPL	Stock	12.2321	12.2582	12.2236	12.225	54875128.0
2011-01-10 16:00:00	AAPL	Stock	12.2232	12.2368	12.1668	12.2321	37764244.0
2011-01-10 16:30:00	AAPL	Stock	12.2321	12.2414	12.0914	12.2321	416696.0
2011-01-10 17:00:00	AAPL	Stock	12.235	12.2407	12.2321	12.2404	263312.0
2011-01-10 17:30:00	AAPL	Stock	12.2411	12.2411	12.2254	12.2336	212772.0
2011-01-10 18:00:00	AAPL	Stock	12.2286	12.2336	12.2232	12.2321	238784.0
2011-01-10 18:30:00	AAPL	Stock	12.2321	12.2339	12.2321	12.2336	73472.0
2011-01-10 19:00:00	AAPL	Stock	12.2321	12.2407	12.2321	12.2393	137508.0
2011-01-10 19:30:00	AAPL	Stock	12.2393	12.24	12.2339	12.2343	121632.0
2011-01-10 04:00:00	MSFT	Stock	28.38	28.38	28.38	28.38	100.0
2011-01-10 05:30:00	MSFT	Stock	28.42	28.46	28.42	28.46	500.0
2011-01-10 06:00:00	MSFT	Stock	28.46	28.46	28.46	28.46	500.0
2011-01-10 07:00:00	MSFT	Stock	28.46	28.46	28.46	28.46	100.0
2011-01-10 07:30:00	MSFT	Stock	28.41	28.43	28.4	28.43	400.0
2011-01-10 08:00:00	MSFT	Stock	28.46	28.51	28.42	28.45	3245.0
2011-01-10 08:30:00	MSFT	Stock	28.45	28.49	28.4	28.48	21450.0
2011-01-10 09:00:00	MSFT	Stock	28.48	28.48	28.26	28.26	122661.0
2011-01-10 09:30:00	MSFT	Stock	28.26	28.4	28.08	28.081	7298593.0
2011-01-10 10:00:00	MSFT	Stock	28.09	28.16	28.04	28.08	6454694.0
2011-01-10 10:30:00	MSFT	Stock	28.08	28.13	28.07	28.125	3799158.0
2011-01-10 11:00:00	MSFT	Stock	28.12	28.16	28.08	28.092	2638564.0
2011-01-10 11:30:00	MSFT	Stock	28.1	28.2	28.08	28.191	2747964.0
2011-01-10 12:00:00	MSFT	Stock	28.195	28.28	28.19	28.233	3667125.0
2011-01-10 12:30:00	MSFT	Stock	28.23	28.26	28.17	28.175	2561478.0
2011-01-10 13:00:00	MSFT	Stock	28.171	28.22	28.15	28.2	2110948.0
2011-01-10 13:30:00	MSFT	Stock	28.2	28.23	28.18	28.185	2489240.0
2011-01-10 14:00:00	MSFT	Stock	28.185	28.21	28.18	28.21	2416292.0

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

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