PREVIEW / stock_30min / 2014-01-21

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-21.parquet
  size:    1.6 MB
  rows:    83,494
  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-01-21 04:00:00	AAPL	Stock	19.3107	19.3929	19.3107	19.3629	39144.0
2014-01-21 04:30:00	AAPL	Stock	19.3607	19.37	19.3607	19.37	7280.0
2014-01-21 05:00:00	AAPL	Stock	19.3704	19.4107	19.3704	19.4107	72548.0
2014-01-21 05:30:00	AAPL	Stock	19.3861	19.4161	19.3861	19.4132	64428.0
2014-01-21 06:00:00	AAPL	Stock	19.4093	19.4179	19.4071	19.4107	38472.0
2014-01-21 06:30:00	AAPL	Stock	19.4071	19.4089	19.3929	19.3932	41552.0
2014-01-21 07:00:00	AAPL	Stock	19.3968	19.4279	19.3821	19.3839	221676.0
2014-01-21 07:30:00	AAPL	Stock	19.375	19.3786	19.2614	19.2714	532728.0
2014-01-21 08:00:00	AAPL	Stock	19.275	19.3954	19.2593	19.2714	1282960.0
2014-01-21 08:30:00	AAPL	Stock	19.2675	19.3357	19.2675	19.3304	1076180.0
2014-01-21 09:00:00	AAPL	Stock	19.3304	19.3393	19.3036	19.3214	1661968.0
2014-01-21 09:30:00	AAPL	Stock	19.3196	19.5725	19.3007	19.5286	60941412.0
2014-01-21 10:00:00	AAPL	Stock	19.5286	19.5607	19.4143	19.4768	26989172.0
2014-01-21 10:30:00	AAPL	Stock	19.4725	19.4996	19.4029	19.4946	17691548.0
2014-01-21 11:00:00	AAPL	Stock	19.4857	19.4937	19.3496	19.4248	18735892.0
2014-01-21 11:30:00	AAPL	Stock	19.4221	19.5354	19.4129	19.5155	13785296.0
2014-01-21 12:00:00	AAPL	Stock	19.5155	19.5443	19.4725	19.5339	17443104.0
2014-01-21 12:30:00	AAPL	Stock	19.5357	19.6246	19.5307	19.6143	20200908.0
2014-01-21 13:00:00	AAPL	Stock	19.6136	19.6407	19.5868	19.6379	14349972.0
2014-01-21 13:30:00	AAPL	Stock	19.6389	19.6454	19.5982	19.6218	13659240.0
2014-01-21 14:00:00	AAPL	Stock	19.6229	19.6411	19.5982	19.6079	7677880.0
2014-01-21 14:30:00	AAPL	Stock	19.6064	19.6446	19.6036	19.6281	10433164.0
2014-01-21 15:00:00	AAPL	Stock	19.6243	19.6429	19.5839	19.5993	11116448.0
2014-01-21 15:30:00	AAPL	Stock	19.6	19.6207	19.5718	19.6071	22400420.0
2014-01-21 16:00:00	AAPL	Stock	19.6096	19.6139	19.3331	19.5982	13780816.0
2014-01-21 16:30:00	AAPL	Stock	19.6043	19.6104	19.4468	19.6104	813540.0
2014-01-21 17:00:00	AAPL	Stock	19.6071	19.6093	19.6011	19.6036	36400.0
2014-01-21 17:30:00	AAPL	Stock	19.6025	19.6096	19.5943	19.6068	793408.0
2014-01-21 18:00:00	AAPL	Stock	19.5946	19.6068	19.5936	19.5936	91056.0
2014-01-21 18:30:00	AAPL	Stock	19.6025	19.6096	19.6025	19.6032	153300.0
2014-01-21 19:00:00	AAPL	Stock	19.6	19.6021	19.5982	19.6	42140.0
2014-01-21 19:30:00	AAPL	Stock	19.6054	19.6196	19.6	19.6196	217028.0
2014-01-21 05:00:00	MSFT	Stock	36.51	36.51	36.51	36.51	500.0
2014-01-21 07:00:00	MSFT	Stock	36.65	36.65	36.64	36.64	800.0
2014-01-21 08:00:00	MSFT	Stock	36.54	36.6	36.5	36.57	2205.0
2014-01-21 08:30:00	MSFT	Stock	36.57	36.65	36.57	36.65	5579.0
2014-01-21 09:00:00	MSFT	Stock	36.65	36.82	36.65	36.81	39432.0
2014-01-21 09:30:00	MSFT	Stock	36.82	36.82	36.55	36.685	3659215.0
2014-01-21 10:00:00	MSFT	Stock	36.68	36.72	36.46	36.49	2419251.0
2014-01-21 10:30:00	MSFT	Stock	36.485	36.59	36.45	36.57	1312950.0
2014-01-21 11:00:00	MSFT	Stock	36.57	36.61	36.28	36.32	2578058.0
2014-01-21 11:30:00	MSFT	Stock	36.32	36.325	36.1	36.125	2944224.0
2014-01-21 12:00:00	MSFT	Stock	36.123	36.23	36.06	36.22	1627327.0
2014-01-21 12:30:00	MSFT	Stock	36.219	36.23	36.125	36.146	1111957.0
2014-01-21 13:00:00	MSFT	Stock	36.14	36.19	36.1	36.16	1346829.0
2014-01-21 13:30:00	MSFT	Stock	36.16	36.24	36.15	36.217	1208550.0
2014-01-21 14:00:00	MSFT	Stock	36.216	36.29	36.21	36.24	1051414.0
2014-01-21 14:30:00	MSFT	Stock	36.24	36.3	36.2	36.215	1158498.0
2014-01-21 15:00:00	MSFT	Stock	36.215	36.22	36.13	36.14	1302392.0
2014-01-21 15:30:00	MSFT	Stock	36.13	36.17	36.1	36.16	4628511.0

> showing 50 of 83,494 rows — these rows as CSV

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