PREVIEW / stock_30min / 2013-03-27

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-27.parquet
  size:    1.4 MB
  rows:    75,492
  symbols: 3,468

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
2013-03-27 05:30:00	AAPL	Stock	16.4821	16.4821	16.4332	16.4332	29260.0
2013-03-27 06:30:00	AAPL	Stock	16.445	16.445	16.4271	16.4271	41132.0
2013-03-27 07:00:00	AAPL	Stock	16.4179	16.4286	16.3571	16.3571	188328.0
2013-03-27 07:30:00	AAPL	Stock	16.3346	16.375	16.3075	16.375	473088.0
2013-03-27 08:00:00	AAPL	Stock	16.3696	16.4464	16.3136	16.3393	1019340.0
2013-03-27 08:30:00	AAPL	Stock	16.3346	16.3646	16.3343	16.3511	487788.0
2013-03-27 09:00:00	AAPL	Stock	16.3507	16.3571	16.2975	16.3104	1847916.0
2013-03-27 09:30:00	AAPL	Stock	16.3021	16.3143	16.1946	16.2379	62009920.0
2013-03-27 10:00:00	AAPL	Stock	16.2421	16.2493	16.1543	16.195	39971176.0
2013-03-27 10:30:00	AAPL	Stock	16.1954	16.2304	16.1893	16.2084	22942416.0
2013-03-27 11:00:00	AAPL	Stock	16.2093	16.2174	16.1704	16.1796	16817780.0
2013-03-27 11:30:00	AAPL	Stock	16.18	16.2146	16.1339	16.1521	20525176.0
2013-03-27 12:00:00	AAPL	Stock	16.1525	16.1675	16.1214	16.1536	18641224.0
2013-03-27 12:30:00	AAPL	Stock	16.155	16.1714	16.1232	16.1604	15794548.0
2013-03-27 13:00:00	AAPL	Stock	16.1604	16.1678	16.1232	16.1316	11389476.0
2013-03-27 13:30:00	AAPL	Stock	16.1316	16.1543	16.1154	16.1507	12973884.0
2013-03-27 14:00:00	AAPL	Stock	16.1521	16.2	16.1421	16.19	14508844.0
2013-03-27 14:30:00	AAPL	Stock	16.1907	16.2079	16.1725	16.1786	16843288.0
2013-03-27 15:00:00	AAPL	Stock	16.1786	16.19	16.1432	16.1618	16089920.0
2013-03-27 15:30:00	AAPL	Stock	16.1632	16.17	16.0975	16.1454	41576836.0
2013-03-27 16:00:00	AAPL	Stock	16.1468	16.4671	16.1293	16.1446	7523656.0
2013-03-27 16:30:00	AAPL	Stock	16.1457	16.1522	16.1275	16.1382	675108.0
2013-03-27 17:00:00	AAPL	Stock	16.1254	16.1393	16.1254	16.1286	121632.0
2013-03-27 17:30:00	AAPL	Stock	16.1354	16.1457	16.1354	16.1457	284620.0
2013-03-27 18:00:00	AAPL	Stock	16.1393	16.1679	16.1375	16.1521	3818416.0
2013-03-27 18:30:00	AAPL	Stock	16.1518	16.16	16.1429	16.1429	55608.0
2013-03-27 19:00:00	AAPL	Stock	16.1425	16.1425	16.1268	16.1268	80192.0
2013-03-27 19:30:00	AAPL	Stock	16.1357	16.1357	16.1289	16.1289	37324.0
2013-03-27 04:30:00	MSFT	Stock	28.21	28.25	28.21	28.25	200.0
2013-03-27 06:30:00	MSFT	Stock	28.08	28.08	28.08	28.08	100.0
2013-03-27 07:30:00	MSFT	Stock	28.03	28.04	28.03	28.04	650.0
2013-03-27 08:00:00	MSFT	Stock	28.07	28.07	28.04	28.04	600.0
2013-03-27 08:30:00	MSFT	Stock	28.03	28.08	28.03	28.08	7373.0
2013-03-27 09:00:00	MSFT	Stock	28.06	28.14	28.06	28.14	25922.0
2013-03-27 09:30:00	MSFT	Stock	28.14	28.25	28.08	28.2	3980932.0
2013-03-27 10:00:00	MSFT	Stock	28.19	28.22	28.17	28.185	2654031.0
2013-03-27 10:30:00	MSFT	Stock	28.18	28.25	28.18	28.23	1878748.0
2013-03-27 11:00:00	MSFT	Stock	28.235	28.33	28.21	28.32	2802154.0
2013-03-27 11:30:00	MSFT	Stock	28.315	28.39	28.29	28.345	1827474.0
2013-03-27 12:00:00	MSFT	Stock	28.35	28.35	28.27	28.28	1695841.0
2013-03-27 12:30:00	MSFT	Stock	28.275	28.31	28.235	28.275	1441126.0
2013-03-27 13:00:00	MSFT	Stock	28.276	28.32	28.24	28.29	1889295.0
2013-03-27 13:30:00	MSFT	Stock	28.29	28.33	28.27	28.32	718341.0
2013-03-27 14:00:00	MSFT	Stock	28.32	28.37	28.315	28.365	1867892.0
2013-03-27 14:30:00	MSFT	Stock	28.36	28.375	28.34	28.36	2644521.0
2013-03-27 15:00:00	MSFT	Stock	28.36	28.43	28.35	28.43	2557989.0
2013-03-27 15:30:00	MSFT	Stock	28.425	28.445	28.33	28.38	6790841.0
2013-03-27 16:00:00	MSFT	Stock	28.37	28.39	28.15	28.37	1754467.0
2013-03-27 16:30:00	MSFT	Stock	28.37	28.41	28.3	28.38	85954.0
2013-03-27 17:00:00	MSFT	Stock	28.32	28.32	28.32	28.32	511.0

> showing 50 of 75,492 rows — these rows as CSV

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