PREVIEW / stock_30min / 2013-03-14

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-14.parquet
  size:    1.5 MB
  rows:    78,493
  symbols: 3,455

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-03-14 04:00:00	AAPL	Stock	15.3464	15.3464	15.3464	15.3464	2800.0
2013-03-14 04:30:00	AAPL	Stock	15.3571	15.3571	15.3571	15.3571	21840.0
2013-03-14 06:30:00	AAPL	Stock	15.3571	15.3589	15.3329	15.3329	44772.0
2013-03-14 07:00:00	AAPL	Stock	15.3464	15.3607	15.3414	15.3607	40320.0
2013-03-14 07:30:00	AAPL	Stock	15.3568	15.5214	15.3482	15.4614	1301748.0
2013-03-14 08:00:00	AAPL	Stock	15.4557	15.5236	15.375	15.4911	3213784.0
2013-03-14 08:30:00	AAPL	Stock	15.4961	15.5	15.25	15.4468	1816556.0
2013-03-14 09:00:00	AAPL	Stock	15.445	15.4671	15.4179	15.4604	2261868.0
2013-03-14 09:30:00	AAPL	Stock	15.4582	15.5086	15.3982	15.4739	62142976.0
2013-03-14 10:00:00	AAPL	Stock	15.4736	15.5229	15.4196	15.4388	38583328.0
2013-03-14 10:30:00	AAPL	Stock	15.4461	15.4639	15.3732	15.3961	27157844.0
2013-03-14 11:00:00	AAPL	Stock	15.3964	15.4554	15.3929	15.4239	21658140.0
2013-03-14 11:30:00	AAPL	Stock	15.425	15.4739	15.4043	15.4454	19570628.0
2013-03-14 12:00:00	AAPL	Stock	15.4446	15.4793	15.4423	15.4632	12089588.0
2013-03-14 12:30:00	AAPL	Stock	15.4657	15.4946	15.4286	15.4568	18392556.0
2013-03-14 13:00:00	AAPL	Stock	15.4563	15.4679	15.4418	15.4457	8699628.0
2013-03-14 13:30:00	AAPL	Stock	15.4418	15.4511	15.4032	15.4204	11995648.0
2013-03-14 14:00:00	AAPL	Stock	15.4243	15.4514	15.4136	15.4411	7759584.0
2013-03-14 14:30:00	AAPL	Stock	15.4406	15.4632	15.4127	15.4543	8763944.0
2013-03-14 15:00:00	AAPL	Stock	15.4568	15.4732	15.4254	15.4325	14960596.0
2013-03-14 15:30:00	AAPL	Stock	15.4328	15.4607	15.4289	15.4421	23768556.0
2013-03-14 16:00:00	AAPL	Stock	15.4421	15.4575	15.4307	15.4357	14369040.0
2013-03-14 16:30:00	AAPL	Stock	15.4357	15.4439	15.4254	15.4329	171920.0
2013-03-14 17:00:00	AAPL	Stock	15.4321	15.4464	15.4243	15.4257	157416.0
2013-03-14 17:30:00	AAPL	Stock	15.4257	15.4318	15.4196	15.4318	125944.0
2013-03-14 18:00:00	AAPL	Stock	15.4279	15.4318	15.4232	15.4232	46508.0
2013-03-14 18:30:00	AAPL	Stock	15.4207	15.4275	15.4161	15.4275	92204.0
2013-03-14 19:00:00	AAPL	Stock	15.4204	15.4318	15.4204	15.4232	122360.0
2013-03-14 19:30:00	AAPL	Stock	15.4179	15.4314	15.4021	15.4021	274288.0
2013-03-14 08:00:00	MSFT	Stock	27.95	28.01	27.95	28.0	613.0
2013-03-14 08:30:00	MSFT	Stock	28.01	28.01	27.85	28.01	7300.0
2013-03-14 09:00:00	MSFT	Stock	28.01	28.02	28.0	28.0	4300.0
2013-03-14 09:30:00	MSFT	Stock	28.0	28.07	27.93	27.964	9601315.0
2013-03-14 10:00:00	MSFT	Stock	27.965	28.04	27.945	28.01	6875897.0
2013-03-14 10:30:00	MSFT	Stock	28.005	28.04	27.995	28.005	2883688.0
2013-03-14 11:00:00	MSFT	Stock	28.0	28.03	27.99	28.01	2209709.0
2013-03-14 11:30:00	MSFT	Stock	28.018	28.035	28.0	28.01	3528122.0
2013-03-14 12:00:00	MSFT	Stock	28.0	28.05	28.0	28.04	2328092.0
2013-03-14 12:30:00	MSFT	Stock	28.04	28.15	28.04	28.15	4067645.0
2013-03-14 13:00:00	MSFT	Stock	28.14	28.16	28.05	28.085	2779716.0
2013-03-14 13:30:00	MSFT	Stock	28.085	28.1	28.04	28.09	2821925.0
2013-03-14 14:00:00	MSFT	Stock	28.096	28.1	28.04	28.09	1991053.0
2013-03-14 14:30:00	MSFT	Stock	28.085	28.14	28.08	28.14	2291181.0
2013-03-14 15:00:00	MSFT	Stock	28.135	28.15	28.09	28.105	2778240.0
2013-03-14 15:30:00	MSFT	Stock	28.1	28.14	28.09	28.13	7100257.0
2013-03-14 16:00:00	MSFT	Stock	28.13	28.143	28.019	28.14	3282973.0
2013-03-14 16:30:00	MSFT	Stock	28.14	28.14	28.1	28.1	12004.0
2013-03-14 17:00:00	MSFT	Stock	28.135	28.15	28.1	28.1	28959.0
2013-03-14 17:30:00	MSFT	Stock	28.14	28.14	28.08	28.08	1352.0
2013-03-14 18:00:00	MSFT	Stock	28.14	28.15	28.09	28.14	5086.0

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

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