PREVIEW / stock_30min / 2014-05-12

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-12.parquet
  size:    1.6 MB
  rows:    82,868
  symbols: 3,553

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
2014-05-12 04:00:00	AAPL	Stock	20.9525	20.9643	20.9214	20.9521	30800.0
2014-05-12 05:00:00	AAPL	Stock	20.9464	20.9643	20.9464	20.9643	5600.0
2014-05-12 05:30:00	AAPL	Stock	20.9625	20.9643	20.9625	20.9643	8400.0
2014-05-12 06:30:00	AAPL	Stock	20.9632	20.9946	20.9632	20.975	22400.0
2014-05-12 07:00:00	AAPL	Stock	20.9821	21.0321	20.9821	21.0089	73220.0
2014-05-12 07:30:00	AAPL	Stock	21.0204	21.0204	21.0	21.0143	118552.0
2014-05-12 08:00:00	AAPL	Stock	21.0004	21.0304	20.9357	20.9357	593152.0
2014-05-12 08:30:00	AAPL	Stock	20.9357	20.9918	20.9125	20.9125	5626908.0
2014-05-12 09:00:00	AAPL	Stock	20.9861	20.9929	20.9679	20.9714	410312.0
2014-05-12 09:30:00	AAPL	Stock	20.98	21.0975	20.9786	21.095	35438900.0
2014-05-12 10:00:00	AAPL	Stock	21.095	21.1321	21.0539	21.1068	15095780.0
2014-05-12 10:30:00	AAPL	Stock	21.0996	21.1111	21.0614	21.1086	8935472.0
2014-05-12 11:00:00	AAPL	Stock	21.1086	21.1096	21.0364	21.0742	7998592.0
2014-05-12 11:30:00	AAPL	Stock	21.0736	21.1121	21.0736	21.0916	6844600.0
2014-05-12 12:00:00	AAPL	Stock	21.0936	21.1518	21.0918	21.149	7489664.0
2014-05-12 12:30:00	AAPL	Stock	21.1491	21.1621	21.1064	21.1329	6053180.0
2014-05-12 13:00:00	AAPL	Stock	21.1339	21.1471	21.1257	21.14	3592176.0
2014-05-12 13:30:00	AAPL	Stock	21.14	21.1607	21.1314	21.1546	4916884.0
2014-05-12 14:00:00	AAPL	Stock	21.1541	21.1711	21.14	21.1404	6756652.0
2014-05-12 14:30:00	AAPL	Stock	21.1404	21.1625	21.0982	21.1561	7267092.0
2014-05-12 15:00:00	AAPL	Stock	21.1571	21.18	21.1429	21.1682	9623292.0
2014-05-12 15:30:00	AAPL	Stock	21.1687	21.2021	21.1618	21.1704	18843692.0
2014-05-12 16:00:00	AAPL	Stock	21.1725	21.1746	21.0899	21.1682	15023148.0
2014-05-12 16:30:00	AAPL	Stock	21.1725	21.1767	21.1661	21.1767	252308.0
2014-05-12 17:00:00	AAPL	Stock	21.1657	21.1725	21.1536	21.1725	333116.0
2014-05-12 17:30:00	AAPL	Stock	21.1696	21.1696	21.1689	21.1689	53200.0
2014-05-12 18:00:00	AAPL	Stock	21.1689	21.1696	21.1618	21.1696	33600.0
2014-05-12 18:30:00	AAPL	Stock	21.1693	21.1725	21.1664	21.1668	293748.0
2014-05-12 19:00:00	AAPL	Stock	21.1696	21.1696	21.1696	21.1696	11200.0
2014-05-12 19:30:00	AAPL	Stock	21.1696	21.1696	21.1661	21.1696	35644.0
2014-05-12 07:00:00	MSFT	Stock	39.75	39.75	39.75	39.75	1000.0
2014-05-12 07:30:00	MSFT	Stock	39.83	39.83	39.83	39.83	3872.0
2014-05-12 08:00:00	MSFT	Stock	39.65	39.65	39.65	39.65	100.0
2014-05-12 08:30:00	MSFT	Stock	39.68	39.7	39.66	39.68	1800.0
2014-05-12 09:00:00	MSFT	Stock	39.7	39.74	39.7	39.71	1756.0
2014-05-12 09:30:00	MSFT	Stock	39.71	39.97	39.65	39.96	3068124.0
2014-05-12 10:00:00	MSFT	Stock	39.96	39.99	39.855	39.86	1742630.0
2014-05-12 10:30:00	MSFT	Stock	39.86	39.93	39.845	39.87	1155397.0
2014-05-12 11:00:00	MSFT	Stock	39.87	39.97	39.87	39.89	1408936.0
2014-05-12 11:30:00	MSFT	Stock	39.891	39.96	39.86	39.94	1051856.0
2014-05-12 12:00:00	MSFT	Stock	39.94	40.02	39.93	39.99	1346010.0
2014-05-12 12:30:00	MSFT	Stock	39.99	40.02	39.94	39.951	999790.0
2014-05-12 13:00:00	MSFT	Stock	39.955	40.0	39.94	39.975	844038.0
2014-05-12 13:30:00	MSFT	Stock	39.976	39.99	39.91	39.92	700919.0
2014-05-12 14:00:00	MSFT	Stock	39.92	39.98	39.89	39.98	751202.0
2014-05-12 14:30:00	MSFT	Stock	39.98	40.0	39.95	39.98	833824.0
2014-05-12 15:00:00	MSFT	Stock	39.985	40.02	39.92	39.925	1400402.0
2014-05-12 15:30:00	MSFT	Stock	39.92	39.99	39.91	39.95	3097121.0
2014-05-12 16:00:00	MSFT	Stock	39.97	40.01	39.928	39.97	2486919.0
2014-05-12 16:30:00	MSFT	Stock	39.97	40.04	39.97	40.0	64602.0

> showing 50 of 82,868 rows — these rows as CSV

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