PREVIEW / stock_30min / 2013-01-28

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-28.parquet
  size:    1.5 MB
  rows:    77,296
  symbols: 3,481

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-01-28 04:00:00	AAPL	Stock	15.7611	15.7611	15.7143	15.7143	81088.0
2013-01-28 04:30:00	AAPL	Stock	15.7143	15.7161	15.6875	15.6875	71428.0
2013-01-28 05:00:00	AAPL	Stock	15.7086	15.7143	15.67	15.67	74704.0
2013-01-28 05:30:00	AAPL	Stock	15.6775	15.71	15.6775	15.71	30240.0
2013-01-28 06:00:00	AAPL	Stock	15.6964	15.75	15.6857	15.75	41020.0
2013-01-28 06:30:00	AAPL	Stock	15.7557	15.7607	15.7321	15.75	232176.0
2013-01-28 07:00:00	AAPL	Stock	15.7536	15.7679	15.7071	15.7604	670768.0
2013-01-28 07:30:00	AAPL	Stock	15.75	15.8357	15.7196	15.8214	1312416.0
2013-01-28 08:00:00	AAPL	Stock	15.8214	15.8339	15.7196	15.7396	3424988.0
2013-01-28 08:30:00	AAPL	Stock	15.7321	15.735	15.6096	15.6404	4179308.0
2013-01-28 09:00:00	AAPL	Stock	15.6389	15.6429	15.5907	15.6411	4075064.0
2013-01-28 09:30:00	AAPL	Stock	15.6386	16.0157	15.5664	16.0127	167431936.0
2013-01-28 10:00:00	AAPL	Stock	16.0104	16.0536	15.8443	15.9779	84892444.0
2013-01-28 10:30:00	AAPL	Stock	15.975	16.1321	15.9482	16.0843	84470148.0
2013-01-28 11:00:00	AAPL	Stock	16.0875	16.1514	16.0482	16.1068	50657852.0
2013-01-28 11:30:00	AAPL	Stock	16.1004	16.1861	16.0934	16.1521	46746392.0
2013-01-28 12:00:00	AAPL	Stock	16.1547	16.1625	16.1125	16.1261	25171328.0
2013-01-28 12:30:00	AAPL	Stock	16.1214	16.1818	16.0364	16.0368	32788476.0
2013-01-28 13:00:00	AAPL	Stock	16.0404	16.0404	15.9154	15.9875	48182736.0
2013-01-28 13:30:00	AAPL	Stock	15.989	16.0907	15.9571	16.0662	30614472.0
2013-01-28 14:00:00	AAPL	Stock	16.065	16.1161	16.0157	16.0814	31014872.0
2013-01-28 14:30:00	AAPL	Stock	16.0785	16.12	16.045	16.0866	25919712.0
2013-01-28 15:00:00	AAPL	Stock	16.0868	16.1482	16.0564	16.095	38251332.0
2013-01-28 15:30:00	AAPL	Stock	16.0947	16.1521	16.05	16.0618	51270604.0
2013-01-28 16:00:00	AAPL	Stock	16.0621	16.0811	15.71	16.0289	27763260.0
2013-01-28 16:30:00	AAPL	Stock	16.0354	16.0978	16.0304	16.0321	627620.0
2013-01-28 17:00:00	AAPL	Stock	16.035	16.0986	16.0304	16.0811	1671040.0
2013-01-28 17:30:00	AAPL	Stock	16.0811	16.1214	16.0786	16.1214	621180.0
2013-01-28 18:00:00	AAPL	Stock	16.1186	16.1314	16.1107	16.1268	729624.0
2013-01-28 18:30:00	AAPL	Stock	16.1268	16.1354	16.1146	16.1354	187572.0
2013-01-28 19:00:00	AAPL	Stock	16.135	16.135	16.1007	16.1007	271040.0
2013-01-28 19:30:00	AAPL	Stock	16.1007	16.1014	16.0718	16.0875	556668.0
2013-01-28 04:30:00	MSFT	Stock	27.95	27.95	27.95	27.95	4000.0
2013-01-28 06:30:00	MSFT	Stock	28.01	28.01	28.01	28.01	1000.0
2013-01-28 07:00:00	MSFT	Stock	28.04	28.05	27.95	28.02	15120.0
2013-01-28 07:30:00	MSFT	Stock	28.0	28.02	28.0	28.01	8200.0
2013-01-28 08:00:00	MSFT	Stock	28.03	28.06	27.86	27.99	46371.0
2013-01-28 08:30:00	MSFT	Stock	27.99	28.02	27.99	28.0	20507.0
2013-01-28 09:00:00	MSFT	Stock	27.99	28.1	27.96	28.01	267634.0
2013-01-28 09:30:00	MSFT	Stock	28.01	28.1	27.76	28.0	7160111.0
2013-01-28 10:00:00	MSFT	Stock	27.99	28.07	27.93	28.06	5715839.0
2013-01-28 10:30:00	MSFT	Stock	28.06	28.17	28.03	28.12	4181711.0
2013-01-28 11:00:00	MSFT	Stock	28.115	28.13	28.0	28.035	2850960.0
2013-01-28 11:30:00	MSFT	Stock	28.035	28.19	28.03	28.18	2945470.0
2013-01-28 12:00:00	MSFT	Stock	28.18	28.225	28.17	28.185	2751161.0
2013-01-28 12:30:00	MSFT	Stock	28.185	28.215	28.15	28.155	1764715.0
2013-01-28 13:00:00	MSFT	Stock	28.15	28.16	27.96	27.96	3911318.0
2013-01-28 13:30:00	MSFT	Stock	27.96	28.03	27.89	28.015	3825588.0
2013-01-28 14:00:00	MSFT	Stock	28.01	28.07	27.96	28.03	2730524.0
2013-01-28 14:30:00	MSFT	Stock	28.04	28.07	27.99	28.005	2233747.0

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

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