PREVIEW / stock_30min / 2013-08-14

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-14.parquet
  size:    1.5 MB
  rows:    80,918
  symbols: 3,519

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-08-14 04:00:00	AAPL	Stock	17.6071	17.7129	17.6071	17.6696	109564.0
2013-08-14 04:30:00	AAPL	Stock	17.6714	17.6714	17.6429	17.6429	48328.0
2013-08-14 05:00:00	AAPL	Stock	17.6321	17.6457	17.6282	17.6429	21392.0
2013-08-14 05:30:00	AAPL	Stock	17.6457	17.6982	17.6457	17.6982	47404.0
2013-08-14 06:00:00	AAPL	Stock	17.6982	17.7482	17.6789	17.7143	211932.0
2013-08-14 06:30:00	AAPL	Stock	17.7143	17.7143	17.6804	17.6964	247016.0
2013-08-14 07:00:00	AAPL	Stock	17.7143	17.75	17.7143	17.72	827512.0
2013-08-14 07:30:00	AAPL	Stock	17.7257	17.7539	17.6893	17.7361	1506876.0
2013-08-14 08:00:00	AAPL	Stock	17.7371	17.7589	17.4643	17.6293	5625732.0
2013-08-14 08:30:00	AAPL	Stock	17.6225	17.7014	17.6193	17.7014	3931116.0
2013-08-14 09:00:00	AAPL	Stock	17.7014	17.785	17.6654	17.7818	7472472.0
2013-08-14 09:30:00	AAPL	Stock	17.7782	17.8546	17.6214	17.7211	180796896.0
2013-08-14 10:00:00	AAPL	Stock	17.7207	17.8164	17.6214	17.7818	67046672.0
2013-08-14 10:30:00	AAPL	Stock	17.7814	17.8164	17.6804	17.7768	47328456.0
2013-08-14 11:00:00	AAPL	Stock	17.7767	17.8268	17.7243	17.8127	36457652.0
2013-08-14 11:30:00	AAPL	Stock	17.8146	17.8525	17.7732	17.8154	40605572.0
2013-08-14 12:00:00	AAPL	Stock	17.8179	17.9939	17.8164	17.9632	85489852.0
2013-08-14 12:30:00	AAPL	Stock	17.9646	18.0089	17.915	17.9189	44162636.0
2013-08-14 13:00:00	AAPL	Stock	17.9225	17.9643	17.8411	17.8854	35340508.0
2013-08-14 13:30:00	AAPL	Stock	17.8804	17.8864	17.7793	17.8329	40276964.0
2013-08-14 14:00:00	AAPL	Stock	17.833	17.9071	17.8143	17.8904	22795948.0
2013-08-14 14:30:00	AAPL	Stock	17.8894	17.945	17.8789	17.9343	30940840.0
2013-08-14 15:00:00	AAPL	Stock	17.9343	17.9543	17.8404	17.8453	34026468.0
2013-08-14 15:30:00	AAPL	Stock	17.845	17.8789	17.7875	17.8064	45420956.0
2013-08-14 16:00:00	AAPL	Stock	17.8036	17.8305	17.7911	17.7982	9291744.0
2013-08-14 16:30:00	AAPL	Stock	17.7982	17.9004	17.6707	17.7536	1308216.0
2013-08-14 17:00:00	AAPL	Stock	17.7518	17.7607	17.7164	17.7264	579432.0
2013-08-14 17:30:00	AAPL	Stock	17.7171	17.8036	17.7143	17.7286	654360.0
2013-08-14 18:00:00	AAPL	Stock	17.7214	17.7304	17.6971	17.7282	495068.0
2013-08-14 18:30:00	AAPL	Stock	17.7304	17.7571	17.7182	17.75	287672.0
2013-08-14 19:00:00	AAPL	Stock	17.75	17.7554	17.7346	17.75	99120.0
2013-08-14 19:30:00	AAPL	Stock	17.7536	17.7589	17.7411	17.7414	331604.0
2013-08-14 06:00:00	MSFT	Stock	32.07	32.07	32.07	32.07	150.0
2013-08-14 07:30:00	MSFT	Stock	32.1	32.15	32.1	32.15	300.0
2013-08-14 08:00:00	MSFT	Stock	32.2	32.2	32.12	32.12	2050.0
2013-08-14 08:30:00	MSFT	Stock	32.11	32.15	32.11	32.15	2708.0
2013-08-14 09:00:00	MSFT	Stock	32.15	32.19	32.1	32.1	33883.0
2013-08-14 09:30:00	MSFT	Stock	32.14	32.43	32.1	32.253	5505518.0
2013-08-14 10:00:00	MSFT	Stock	32.26	32.26	32.04	32.1	2950431.0
2013-08-14 10:30:00	MSFT	Stock	32.11	32.12	31.7	31.88	6795763.0
2013-08-14 11:00:00	MSFT	Stock	31.88	32.015	31.83	31.94	2816353.0
2013-08-14 11:30:00	MSFT	Stock	31.945	32.02	31.89	31.93	2088685.0
2013-08-14 12:00:00	MSFT	Stock	31.92	31.98	31.87	31.9	1907515.0
2013-08-14 12:30:00	MSFT	Stock	31.91	31.915	31.785	31.8	2272895.0
2013-08-14 13:00:00	MSFT	Stock	31.8	31.815	31.77	31.791	2540864.0
2013-08-14 13:30:00	MSFT	Stock	31.798	31.96	31.75	31.951	2593782.0
2013-08-14 14:00:00	MSFT	Stock	31.956	32.275	31.95	32.23	3825010.0
2013-08-14 14:30:00	MSFT	Stock	32.235	32.41	32.2	32.373	4318485.0
2013-08-14 15:00:00	MSFT	Stock	32.375	32.48	32.32	32.32	2816145.0
2013-08-14 15:30:00	MSFT	Stock	32.32	33.36	32.25	32.34	4193237.0

> showing 50 of 80,918 rows — these rows as CSV

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