PREVIEW / stock_30min / 2012-02-10

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-10.parquet
  size:    1.5 MB
  rows:    78,086
  symbols: 3,532

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
2012-02-10 04:00:00	AAPL	Stock	17.6607	17.6607	17.6607	17.6607	14000.0
2012-02-10 04:30:00	AAPL	Stock	17.6607	17.6661	17.6607	17.6661	28000.0
2012-02-10 05:00:00	AAPL	Stock	17.6518	17.6518	17.6	17.6	111720.0
2012-02-10 06:00:00	AAPL	Stock	17.6096	17.6179	17.6093	17.6179	16240.0
2012-02-10 06:30:00	AAPL	Stock	17.6093	17.625	17.6093	17.6093	14140.0
2012-02-10 07:00:00	AAPL	Stock	17.6179	17.6246	17.4561	17.5571	1128848.0
2012-02-10 07:30:00	AAPL	Stock	17.5632	17.5632	17.5161	17.5179	632604.0
2012-02-10 08:00:00	AAPL	Stock	17.5321	17.6346	17.5	17.6314	2883748.0
2012-02-10 08:30:00	AAPL	Stock	17.6332	17.6343	17.5446	17.5807	3018624.0
2012-02-10 09:00:00	AAPL	Stock	17.5821	17.5857	17.5107	17.5425	3005100.0
2012-02-10 09:30:00	AAPL	Stock	17.5421	17.7721	17.4482	17.6436	152931716.0
2012-02-10 10:00:00	AAPL	Stock	17.6414	17.6893	17.5643	17.635	75656700.0
2012-02-10 10:30:00	AAPL	Stock	17.6375	17.7143	17.627	17.6968	46996040.0
2012-02-10 11:00:00	AAPL	Stock	17.6982	17.7536	17.6943	17.7182	40823300.0
2012-02-10 11:30:00	AAPL	Stock	17.7168	17.7471	17.6961	17.7136	25491284.0
2012-02-10 12:00:00	AAPL	Stock	17.7136	17.7325	17.7	17.7079	20861428.0
2012-02-10 12:30:00	AAPL	Stock	17.7071	17.7293	17.7054	17.7182	15605044.0
2012-02-10 13:00:00	AAPL	Stock	17.7182	17.7204	17.6536	17.6596	30217124.0
2012-02-10 13:30:00	AAPL	Stock	17.6571	17.6585	17.5989	17.6054	37154628.0
2012-02-10 14:00:00	AAPL	Stock	17.6039	17.6696	17.5893	17.6561	31792404.0
2012-02-10 14:30:00	AAPL	Stock	17.6561	17.6625	17.6121	17.6461	27517056.0
2012-02-10 15:00:00	AAPL	Stock	17.6461	17.6461	17.5732	17.6089	41494208.0
2012-02-10 15:30:00	AAPL	Stock	17.6086	17.6343	17.5914	17.6318	54542740.0
2012-02-10 16:00:00	AAPL	Stock	17.6304	17.6921	17.6132	17.6464	8501248.0
2012-02-10 16:30:00	AAPL	Stock	17.65	17.6921	17.6085	17.6593	2085272.0
2012-02-10 17:00:00	AAPL	Stock	17.6568	17.6795	17.6518	17.6611	1177736.0
2012-02-10 17:30:00	AAPL	Stock	17.6643	17.6657	17.6589	17.6607	207900.0
2012-02-10 18:00:00	AAPL	Stock	17.6607	17.6654	17.6536	17.6654	96628.0
2012-02-10 18:30:00	AAPL	Stock	17.6575	17.665	17.6571	17.6643	178024.0
2012-02-10 19:00:00	AAPL	Stock	17.6643	17.665	17.6636	17.6639	39228.0
2012-02-10 19:30:00	AAPL	Stock	17.6643	17.6668	17.6589	17.665	371280.0
2012-02-10 07:30:00	MSFT	Stock	30.67	30.67	30.54	30.55	20500.0
2012-02-10 08:00:00	MSFT	Stock	30.6	30.65	30.55	30.58	37750.0
2012-02-10 08:30:00	MSFT	Stock	30.58	30.6	30.58	30.6	9600.0
2012-02-10 09:00:00	MSFT	Stock	30.59	30.69	30.57	30.64	114006.0
2012-02-10 09:30:00	MSFT	Stock	30.63	30.8	30.55	30.627	5307920.0
2012-02-10 10:00:00	MSFT	Stock	30.62	30.67	30.51	30.63	3944847.0
2012-02-10 10:30:00	MSFT	Stock	30.63	30.65	30.58	30.61	3169517.0
2012-02-10 11:00:00	MSFT	Stock	30.615	30.69	30.59	30.595	2489426.0
2012-02-10 11:30:00	MSFT	Stock	30.59	30.67	30.57	30.63	2332676.0
2012-02-10 12:00:00	MSFT	Stock	30.63	30.65	30.58	30.605	1638144.0
2012-02-10 12:30:00	MSFT	Stock	30.603	30.65	30.59	30.6	2168515.0
2012-02-10 13:00:00	MSFT	Stock	30.59	30.66	30.52	30.52	1598528.0
2012-02-10 13:30:00	MSFT	Stock	30.52	30.55	30.46	30.5	2303990.0
2012-02-10 14:00:00	MSFT	Stock	30.5	30.55	30.49	30.52	1390400.0
2012-02-10 14:30:00	MSFT	Stock	30.52	30.58	30.5	30.54	1596703.0
2012-02-10 15:00:00	MSFT	Stock	30.55	30.55	30.36	30.39	4107257.0
2012-02-10 15:30:00	MSFT	Stock	30.39	30.52	30.38	30.475	5562635.0
2012-02-10 16:00:00	MSFT	Stock	30.5	30.581	30.444	30.5	4241141.0
2012-02-10 16:30:00	MSFT	Stock	30.5	30.602	30.38	30.5	453104.0

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

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