PREVIEW / stock_30min / 2012-01-17

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-17.parquet
  size:    1.5 MB
  rows:    77,824
  symbols: 3,528

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-01-17 04:00:00	AAPL	Stock	15.1429	15.1689	15.1429	15.1657	18200.0
2012-01-17 04:30:00	AAPL	Stock	15.1782	15.1782	15.1743	15.1743	11200.0
2012-01-17 05:00:00	AAPL	Stock	15.1782	15.1786	15.1607	15.1607	30800.0
2012-01-17 05:30:00	AAPL	Stock	15.1525	15.1525	15.1429	15.1429	42000.0
2012-01-17 06:00:00	AAPL	Stock	15.1154	15.1154	15.0907	15.0907	26600.0
2012-01-17 06:30:00	AAPL	Stock	15.1079	15.1079	15.1079	15.1079	24640.0
2012-01-17 07:00:00	AAPL	Stock	15.125	15.1321	15.0896	15.1321	170352.0
2012-01-17 07:30:00	AAPL	Stock	15.1382	15.1382	15.0904	15.0904	210588.0
2012-01-17 08:00:00	AAPL	Stock	15.1061	15.1239	15.0814	15.0929	778708.0
2012-01-17 08:30:00	AAPL	Stock	15.0929	15.1071	15.0857	15.1054	641284.0
2012-01-17 09:00:00	AAPL	Stock	15.1036	15.1554	15.1011	15.1514	1979152.0
2012-01-17 09:30:00	AAPL	Stock	15.15	15.1854	15.1214	15.1757	47180756.0
2012-01-17 10:00:00	AAPL	Stock	15.1757	15.1964	15.1571	15.1946	25144448.0
2012-01-17 10:30:00	AAPL	Stock	15.1961	15.2082	15.1839	15.1982	18269636.0
2012-01-17 11:00:00	AAPL	Stock	15.1979	15.2129	15.1932	15.2082	14567924.0
2012-01-17 11:30:00	AAPL	Stock	15.2064	15.2139	15.1993	15.2082	9190888.0
2012-01-17 12:00:00	AAPL	Stock	15.2089	15.2121	15.1975	15.1986	7471492.0
2012-01-17 12:30:00	AAPL	Stock	15.1996	15.2036	15.185	15.1964	10525760.0
2012-01-17 13:00:00	AAPL	Stock	15.1964	15.2021	15.1939	15.2007	10083024.0
2012-01-17 13:30:00	AAPL	Stock	15.1999	15.2021	15.1857	15.1875	8755768.0
2012-01-17 14:00:00	AAPL	Stock	15.1879	15.1886	15.1607	15.1629	13591592.0
2012-01-17 14:30:00	AAPL	Stock	15.1646	15.1689	15.125	15.1397	17296580.0
2012-01-17 15:00:00	AAPL	Stock	15.1396	15.1514	15.1057	15.1301	16940868.0
2012-01-17 15:30:00	AAPL	Stock	15.1304	15.1729	15.1218	15.1679	24105620.0
2012-01-17 16:00:00	AAPL	Stock	15.1671	15.1939	15.1586	15.1675	13453860.0
2012-01-17 16:30:00	AAPL	Stock	15.1707	15.175	15.1573	15.175	163492.0
2012-01-17 17:00:00	AAPL	Stock	15.1743	15.1854	15.1648	15.1818	417452.0
2012-01-17 17:30:00	AAPL	Stock	15.1821	15.1821	15.1704	15.1768	24220.0
2012-01-17 18:00:00	AAPL	Stock	15.1679	15.1775	15.1679	15.1768	28000.0
2012-01-17 18:30:00	AAPL	Stock	15.175	15.1761	15.1657	15.1661	260680.0
2012-01-17 19:00:00	AAPL	Stock	15.1661	15.1743	15.165	15.1714	133728.0
2012-01-17 19:30:00	AAPL	Stock	15.1725	15.1786	15.1721	15.1786	75096.0
2012-01-17 04:30:00	MSFT	Stock	28.5	28.5	28.5	28.5	930.0
2012-01-17 06:30:00	MSFT	Stock	28.43	28.45	28.43	28.45	590.0
2012-01-17 07:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	8680.0
2012-01-17 07:30:00	MSFT	Stock	28.5	28.5	28.47	28.5	5300.0
2012-01-17 08:00:00	MSFT	Stock	28.47	28.5	28.4	28.48	25452.0
2012-01-17 08:30:00	MSFT	Stock	28.45	28.5	28.24	28.42	32865.0
2012-01-17 09:00:00	MSFT	Stock	28.42	28.45	28.35	28.39	100097.0
2012-01-17 09:30:00	MSFT	Stock	28.42	28.5	28.36	28.5	10654351.0
2012-01-17 10:00:00	MSFT	Stock	28.49	28.57	28.47	28.525	7022653.0
2012-01-17 10:30:00	MSFT	Stock	28.53	28.59	28.49	28.57	4816374.0
2012-01-17 11:00:00	MSFT	Stock	28.58	28.65	28.53	28.59	7224101.0
2012-01-17 11:30:00	MSFT	Stock	28.59	28.62	28.552	28.59	3739391.0
2012-01-17 12:00:00	MSFT	Stock	28.585	28.6	28.51	28.52	4672546.0
2012-01-17 12:30:00	MSFT	Stock	28.515	28.52	28.44	28.505	3621607.0
2012-01-17 13:00:00	MSFT	Stock	28.505	28.53	28.47	28.48	2318946.0
2012-01-17 13:30:00	MSFT	Stock	28.471	28.48	28.34	28.42	3290311.0
2012-01-17 14:00:00	MSFT	Stock	28.425	28.43	28.36	28.365	2432542.0
2012-01-17 14:30:00	MSFT	Stock	28.37	28.39	28.3	28.34	3781016.0

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

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