PREVIEW / stock_30min / 2013-09-13

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-13.parquet
  size:    1.5 MB
  rows:    78,365
  symbols: 3,511

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-09-13 04:00:00	AAPL	Stock	16.9286	16.9539	16.9054	16.9286	72800.0
2013-09-13 04:30:00	AAPL	Stock	16.9143	16.9143	16.8961	16.8961	21000.0
2013-09-13 05:00:00	AAPL	Stock	16.9039	16.9039	16.9039	16.9039	2800.0
2013-09-13 05:30:00	AAPL	Stock	16.9043	16.9043	16.9043	16.9043	2800.0
2013-09-13 06:00:00	AAPL	Stock	16.8839	16.8839	16.7857	16.7857	118860.0
2013-09-13 06:30:00	AAPL	Stock	16.7518	16.7857	16.7518	16.765	250880.0
2013-09-13 07:00:00	AAPL	Stock	16.765	16.8214	16.7518	16.7714	379260.0
2013-09-13 07:30:00	AAPL	Stock	16.7857	16.8014	16.7771	16.7786	223524.0
2013-09-13 08:00:00	AAPL	Stock	16.7786	16.8357	16.7557	16.7732	1317932.0
2013-09-13 08:30:00	AAPL	Stock	16.7732	16.8018	16.7721	16.7786	1084328.0
2013-09-13 09:00:00	AAPL	Stock	16.7786	16.7861	16.7496	16.7854	1697388.0
2013-09-13 09:30:00	AAPL	Stock	16.7779	16.851	16.7043	16.7043	58353708.0
2013-09-13 10:00:00	AAPL	Stock	16.705	16.7275	16.6586	16.6849	38472672.0
2013-09-13 10:30:00	AAPL	Stock	16.6861	16.7318	16.6826	16.6918	16738064.0
2013-09-13 11:00:00	AAPL	Stock	16.6918	16.7371	16.6807	16.7225	11903444.0
2013-09-13 11:30:00	AAPL	Stock	16.7239	16.7564	16.7039	16.7052	14230020.0
2013-09-13 12:00:00	AAPL	Stock	16.7064	16.7211	16.6929	16.7089	8780884.0
2013-09-13 12:30:00	AAPL	Stock	16.7087	16.7111	16.6679	16.6729	11771312.0
2013-09-13 13:00:00	AAPL	Stock	16.6729	16.6921	16.6607	16.67	8933764.0
2013-09-13 13:30:00	AAPL	Stock	16.6699	16.6954	16.6686	16.6815	8722840.0
2013-09-13 14:00:00	AAPL	Stock	16.6836	16.685	16.66	16.6714	11364220.0
2013-09-13 14:30:00	AAPL	Stock	16.6732	16.6782	16.6179	16.621	21105868.0
2013-09-13 15:00:00	AAPL	Stock	16.6204	16.6475	16.6075	16.6196	23975252.0
2013-09-13 15:30:00	AAPL	Stock	16.622	16.6279	16.5964	16.6036	44278164.0
2013-09-13 16:00:00	AAPL	Stock	16.6036	16.8818	16.6035	16.6039	11477088.0
2013-09-13 16:30:00	AAPL	Stock	16.6039	16.6068	16.6004	16.6064	508620.0
2013-09-13 17:00:00	AAPL	Stock	16.6043	16.6089	16.5714	16.5821	1062460.0
2013-09-13 17:30:00	AAPL	Stock	16.5786	16.6036	16.5496	16.5693	305760.0
2013-09-13 18:00:00	AAPL	Stock	16.5664	16.5664	16.5396	16.5464	208880.0
2013-09-13 18:30:00	AAPL	Stock	16.5471	16.5607	16.5468	16.5468	146020.0
2013-09-13 19:00:00	AAPL	Stock	16.5464	16.5536	16.5464	16.5536	39788.0
2013-09-13 19:30:00	AAPL	Stock	16.5521	16.5546	16.5464	16.5536	123452.0
2013-09-13 06:30:00	MSFT	Stock	32.66	32.66	32.66	32.66	100.0
2013-09-13 07:30:00	MSFT	Stock	32.6	32.66	32.6	32.66	1700.0
2013-09-13 08:00:00	MSFT	Stock	32.67	32.67	32.66	32.66	4590.0
2013-09-13 08:30:00	MSFT	Stock	32.66	32.67	32.66	32.66	700.0
2013-09-13 09:00:00	MSFT	Stock	32.68	32.78	32.65	32.77	74677.0
2013-09-13 09:30:00	MSFT	Stock	32.78	32.84	32.53	32.6	4397418.0
2013-09-13 10:00:00	MSFT	Stock	32.602	32.71	32.51	32.535	3562838.0
2013-09-13 10:30:00	MSFT	Stock	32.535	32.63	32.505	32.563	3629028.0
2013-09-13 11:00:00	MSFT	Stock	32.564	32.66	32.56	32.641	2292069.0
2013-09-13 11:30:00	MSFT	Stock	32.65	32.74	32.64	32.74	1776412.0
2013-09-13 12:00:00	MSFT	Stock	32.735	32.84	32.7	32.827	1683128.0
2013-09-13 12:30:00	MSFT	Stock	32.83	32.835	32.74	32.75	816903.0
2013-09-13 13:00:00	MSFT	Stock	32.755	32.87	32.755	32.845	1476664.0
2013-09-13 13:30:00	MSFT	Stock	32.846	33.07	32.82	33.04	3760011.0
2013-09-13 14:00:00	MSFT	Stock	33.04	33.055	32.91	32.95	1821397.0
2013-09-13 14:30:00	MSFT	Stock	32.941	33.03	32.94	32.99	2359074.0
2013-09-13 15:00:00	MSFT	Stock	32.99	33.03	32.88	32.89	3104077.0
2013-09-13 15:30:00	MSFT	Stock	32.89	33.05	32.83	33.03	7288747.0

> showing 50 of 78,365 rows — these rows as CSV

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