PREVIEW / stock_30min / 2010-09-21

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-21.parquet
  size:    1.4 MB
  rows:    73,063
  symbols: 3,472

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
2010-09-21 04:00:00	AAPL	Stock	10.1154	10.1154	10.1154	10.1154	13160.0
2010-09-21 05:00:00	AAPL	Stock	10.1214	10.1214	10.1214	10.1214	2800.0
2010-09-21 05:30:00	AAPL	Stock	10.1214	10.125	10.1036	10.1036	44800.0
2010-09-21 06:00:00	AAPL	Stock	10.0982	10.0982	10.0982	10.0982	5600.0
2010-09-21 06:30:00	AAPL	Stock	10.105	10.105	10.105	10.105	5600.0
2010-09-21 07:00:00	AAPL	Stock	10.1054	10.1075	10.0986	10.1075	30800.0
2010-09-21 07:30:00	AAPL	Stock	10.1175	10.1175	10.1071	10.1071	78400.0
2010-09-21 08:00:00	AAPL	Stock	10.1071	10.1214	10.0929	10.0957	1756412.0
2010-09-21 08:30:00	AAPL	Stock	10.1007	10.1564	10.0971	10.1507	3105060.0
2010-09-21 09:00:00	AAPL	Stock	10.1518	10.1736	10.1296	10.1418	3894632.0
2010-09-21 09:30:00	AAPL	Stock	10.1421	10.16	10.0996	10.1101	91299040.0
2010-09-21 10:00:00	AAPL	Stock	10.1114	10.1643	10.1036	10.1482	49505932.0
2010-09-21 10:30:00	AAPL	Stock	10.148	10.1746	10.1107	10.1164	45801308.0
2010-09-21 11:00:00	AAPL	Stock	10.1163	10.1429	10.1	10.1136	38667608.0
2010-09-21 11:30:00	AAPL	Stock	10.1122	10.1464	10.1011	10.14	26328512.0
2010-09-21 12:00:00	AAPL	Stock	10.1375	10.1579	10.1311	10.1479	24381224.0
2010-09-21 12:30:00	AAPL	Stock	10.1482	10.1607	10.1354	10.1561	15783432.0
2010-09-21 13:00:00	AAPL	Stock	10.155	10.1686	10.1443	10.1646	21276864.0
2010-09-21 13:30:00	AAPL	Stock	10.1646	10.1714	10.1482	10.1686	16794792.0
2010-09-21 14:00:00	AAPL	Stock	10.1696	10.2014	10.1304	10.1992	60737432.0
2010-09-21 14:30:00	AAPL	Stock	10.2011	10.2625	10.1875	10.1964	91637560.0
2010-09-21 15:00:00	AAPL	Stock	10.1961	10.2111	10.1546	10.1611	56401380.0
2010-09-21 15:30:00	AAPL	Stock	10.1593	10.1636	10.1	10.1482	90889764.0
2010-09-21 16:00:00	AAPL	Stock	10.1479	10.1766	10.1243	10.1468	13647200.0
2010-09-21 16:30:00	AAPL	Stock	10.1468	10.1631	10.1122	10.1411	581448.0
2010-09-21 17:00:00	AAPL	Stock	10.1404	10.1411	10.1343	10.1361	746956.0
2010-09-21 17:30:00	AAPL	Stock	10.1361	10.1361	10.095	10.095	1483468.0
2010-09-21 18:00:00	AAPL	Stock	10.095	10.1346	10.0793	10.0821	990752.0
2010-09-21 18:30:00	AAPL	Stock	10.0821	10.1118	10.0796	10.1107	573776.0
2010-09-21 19:00:00	AAPL	Stock	10.1107	10.1214	10.1004	10.1107	297920.0
2010-09-21 19:30:00	AAPL	Stock	10.1075	10.1232	10.1075	10.1161	152516.0
2010-09-21 08:00:00	MSFT	Stock	25.48	25.48	25.43	25.43	5680.0
2010-09-21 08:30:00	MSFT	Stock	25.43	25.48	25.43	25.46	13400.0
2010-09-21 09:00:00	MSFT	Stock	25.47	25.48	25.34	25.41	55955.0
2010-09-21 09:30:00	MSFT	Stock	25.41	25.43	25.15	25.2	5118080.0
2010-09-21 10:00:00	MSFT	Stock	25.19	25.25	25.19	25.22	2984586.0
2010-09-21 10:30:00	MSFT	Stock	25.23	25.31	25.21	25.25	2721720.0
2010-09-21 11:00:00	MSFT	Stock	25.25	25.25	25.17	25.18	2401587.0
2010-09-21 11:30:00	MSFT	Stock	25.17	25.26	25.17	25.24	1744136.0
2010-09-21 12:00:00	MSFT	Stock	25.235	25.27	25.22	25.227	1344801.0
2010-09-21 12:30:00	MSFT	Stock	25.225	25.24	25.21	25.23	1291302.0
2010-09-21 13:00:00	MSFT	Stock	25.235	25.25	25.2	25.22	972411.0
2010-09-21 13:30:00	MSFT	Stock	25.23	25.24	25.17	25.24	1694255.0
2010-09-21 14:00:00	MSFT	Stock	25.235	25.34	25.14	25.27	5080719.0
2010-09-21 14:30:00	MSFT	Stock	25.275	25.375	25.24	25.29	7742165.0
2010-09-21 15:00:00	MSFT	Stock	25.295	25.31	25.19	25.22	4933595.0
2010-09-21 15:30:00	MSFT	Stock	25.215	25.22	25.08	25.15	9153181.0
2010-09-21 16:00:00	MSFT	Stock	25.15	25.32	25.1	25.15	2373082.0
2010-09-21 16:30:00	MSFT	Stock	25.11	25.21	25.09	25.16	147607.0
2010-09-21 17:00:00	MSFT	Stock	25.1	25.1	25.1	25.1	1000.0

> showing 50 of 73,063 rows — these rows as CSV

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