PREVIEW / stock_30min / 2011-04-04

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-04.parquet
  size:    1.4 MB
  rows:    77,691
  symbols: 3,536

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-04-04 05:00:00	AAPL	Stock	12.3214	12.36	12.3214	12.325	9240.0
2011-04-04 06:30:00	AAPL	Stock	12.35	12.35	12.35	12.35	10780.0
2011-04-04 07:00:00	AAPL	Stock	12.3575	12.3779	12.3568	12.3568	71736.0
2011-04-04 07:30:00	AAPL	Stock	12.3507	12.3571	12.3432	12.3571	157360.0
2011-04-04 08:00:00	AAPL	Stock	12.3561	12.4468	12.3464	12.3518	917700.0
2011-04-04 08:30:00	AAPL	Stock	12.3536	12.3536	12.33	12.3482	437304.0
2011-04-04 09:00:00	AAPL	Stock	12.3514	12.3514	12.2925	12.2968	1870960.0
2011-04-04 09:30:00	AAPL	Stock	12.3029	12.3071	12.1546	12.1589	92925112.0
2011-04-04 10:00:00	AAPL	Stock	12.1596	12.1746	12.0857	12.1367	81724104.0
2011-04-04 10:30:00	AAPL	Stock	12.1357	12.1964	12.1254	12.1254	34123096.0
2011-04-04 11:00:00	AAPL	Stock	12.1257	12.2143	12.125	12.212	31092180.0
2011-04-04 11:30:00	AAPL	Stock	12.2111	12.215	12.1793	12.2032	20551636.0
2011-04-04 12:00:00	AAPL	Stock	12.2032	12.2196	12.1864	12.1904	16834440.0
2011-04-04 12:30:00	AAPL	Stock	12.1896	12.1936	12.1464	12.1575	17172820.0
2011-04-04 13:00:00	AAPL	Stock	12.1579	12.1675	12.1429	12.1562	12478256.0
2011-04-04 13:30:00	AAPL	Stock	12.1564	12.16	12.1289	12.1368	25897004.0
2011-04-04 14:00:00	AAPL	Stock	12.1368	12.1589	12.1221	12.1454	26562564.0
2011-04-04 14:30:00	AAPL	Stock	12.1489	12.1782	12.145	12.1507	19718916.0
2011-04-04 15:00:00	AAPL	Stock	12.1529	12.1936	12.125	12.1782	24839696.0
2011-04-04 15:30:00	AAPL	Stock	12.1775	12.1868	12.1614	12.1857	34809908.0
2011-04-04 16:00:00	AAPL	Stock	12.1854	12.2139	12.1712	12.1857	9450504.0
2011-04-04 16:30:00	AAPL	Stock	12.1907	12.314	12.1601	12.1957	409248.0
2011-04-04 17:00:00	AAPL	Stock	12.1964	12.2	12.1925	12.1964	90972.0
2011-04-04 17:30:00	AAPL	Stock	12.1946	12.1964	12.1889	12.1889	117124.0
2011-04-04 18:00:00	AAPL	Stock	12.1882	12.1946	12.1854	12.1946	121268.0
2011-04-04 18:30:00	AAPL	Stock	12.1939	12.1946	12.1939	12.1946	96236.0
2011-04-04 19:00:00	AAPL	Stock	12.1946	12.2029	12.1946	12.2029	47320.0
2011-04-04 19:30:00	AAPL	Stock	12.2029	12.2054	12.1961	12.1961	26012.0
2011-04-04 07:00:00	MSFT	Stock	25.48	25.56	25.48	25.48	1136.0
2011-04-04 08:00:00	MSFT	Stock	25.5	25.55	25.5	25.55	1896.0
2011-04-04 08:30:00	MSFT	Stock	25.54	25.55	25.5	25.55	2220.0
2011-04-04 09:00:00	MSFT	Stock	25.54	25.54	25.44	25.44	37454.0
2011-04-04 09:30:00	MSFT	Stock	25.45	25.53	25.41	25.515	4875304.0
2011-04-04 10:00:00	MSFT	Stock	25.52	25.66	25.49	25.64	4372655.0
2011-04-04 10:30:00	MSFT	Stock	25.634	25.65	25.59	25.6	3313641.0
2011-04-04 11:00:00	MSFT	Stock	25.598	25.6	25.58	25.6	2105393.0
2011-04-04 11:30:00	MSFT	Stock	25.595	25.65	25.59	25.63	1426987.0
2011-04-04 12:00:00	MSFT	Stock	25.62	25.66	25.62	25.625	1863457.0
2011-04-04 12:30:00	MSFT	Stock	25.625	25.63	25.56	25.571	1677807.0
2011-04-04 13:00:00	MSFT	Stock	25.575	25.585	25.54	25.55	1211492.0
2011-04-04 13:30:00	MSFT	Stock	25.555	25.56	25.5	25.502	1571761.0
2011-04-04 14:00:00	MSFT	Stock	25.51	25.55	25.47	25.49	1501067.0
2011-04-04 14:30:00	MSFT	Stock	25.48	25.53	25.48	25.53	1316295.0
2011-04-04 15:00:00	MSFT	Stock	25.525	25.53	25.41	25.52	3279822.0
2011-04-04 15:30:00	MSFT	Stock	25.52	25.58	25.51	25.54	4784345.0
2011-04-04 16:00:00	MSFT	Stock	25.54	25.63	25.48	25.548	1741584.0
2011-04-04 16:30:00	MSFT	Stock	25.61	25.62	25.6	25.61	2454.0
2011-04-04 17:00:00	MSFT	Stock	25.62	25.64	25.6	25.6	8275.0
2011-04-04 17:30:00	MSFT	Stock	25.6	25.6	25.6	25.6	100.0
2011-04-04 18:00:00	MSFT	Stock	25.55	25.57	25.55	25.57	4593.0

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

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