PREVIEW / stock_30min / 2011-07-26

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-26.parquet
  size:    1.4 MB
  rows:    75,835
  symbols: 3,521

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
2011-07-26 04:00:00	AAPL	Stock	14.2754	14.2754	14.2179	14.2179	30800.0
2011-07-26 04:30:00	AAPL	Stock	14.2386	14.2414	14.2289	14.2411	22400.0
2011-07-26 05:00:00	AAPL	Stock	14.2382	14.2393	14.2289	14.2289	37884.0
2011-07-26 05:30:00	AAPL	Stock	14.2321	14.2321	14.2321	14.2321	4452.0
2011-07-26 06:00:00	AAPL	Stock	14.2464	14.2625	14.2464	14.2614	47852.0
2011-07-26 06:30:00	AAPL	Stock	14.2446	14.2464	14.2446	14.2464	9800.0
2011-07-26 07:00:00	AAPL	Stock	14.2496	14.2804	14.2496	14.2625	357896.0
2011-07-26 07:30:00	AAPL	Stock	14.2679	14.3036	14.2639	14.2846	748496.0
2011-07-26 08:00:00	AAPL	Stock	14.2886	14.3139	14.2675	14.3054	1611428.0
2011-07-26 08:30:00	AAPL	Stock	14.3057	14.3321	14.2879	14.2932	3112928.0
2011-07-26 09:00:00	AAPL	Stock	14.2925	14.2971	14.2682	14.2857	2539964.0
2011-07-26 09:30:00	AAPL	Stock	14.2857	14.4089	14.2743	14.3225	110055036.0
2011-07-26 10:00:00	AAPL	Stock	14.3179	14.3739	14.2896	14.3607	47076148.0
2011-07-26 10:30:00	AAPL	Stock	14.3632	14.3968	14.3346	14.3859	28685440.0
2011-07-26 11:00:00	AAPL	Stock	14.3882	14.4368	14.3859	14.4193	40555508.0
2011-07-26 11:30:00	AAPL	Stock	14.4182	14.4254	14.3832	14.4054	26645696.0
2011-07-26 12:00:00	AAPL	Stock	14.4054	14.4346	14.3971	14.422	23052400.0
2011-07-26 12:30:00	AAPL	Stock	14.4204	14.4339	14.4075	14.4254	15834084.0
2011-07-26 13:00:00	AAPL	Stock	14.4246	14.4464	14.4143	14.4161	19400388.0
2011-07-26 13:30:00	AAPL	Stock	14.4157	14.4268	14.3918	14.415	20122368.0
2011-07-26 14:00:00	AAPL	Stock	14.4146	14.4279	14.3979	14.4054	21209944.0
2011-07-26 14:30:00	AAPL	Stock	14.4061	14.4282	14.4039	14.4075	16295356.0
2011-07-26 15:00:00	AAPL	Stock	14.4075	14.4339	14.4018	14.4274	24068800.0
2011-07-26 15:30:00	AAPL	Stock	14.4275	14.4275	14.3929	14.4021	49587104.0
2011-07-26 16:00:00	AAPL	Stock	14.4047	14.4211	14.3393	14.3914	15154972.0
2011-07-26 16:30:00	AAPL	Stock	14.3929	14.427	14.3896	14.3929	196448.0
2011-07-26 17:00:00	AAPL	Stock	14.39	14.4029	14.3896	14.3914	100940.0
2011-07-26 17:30:00	AAPL	Stock	14.3911	14.3968	14.3696	14.3718	150808.0
2011-07-26 18:00:00	AAPL	Stock	14.3714	14.4075	14.37	14.375	176204.0
2011-07-26 18:30:00	AAPL	Stock	14.3789	14.3804	14.375	14.3789	90580.0
2011-07-26 19:00:00	AAPL	Stock	14.3857	14.3857	14.3782	14.3782	64428.0
2011-07-26 19:30:00	AAPL	Stock	14.3786	14.3839	14.375	14.375	200032.0
2011-07-26 07:30:00	MSFT	Stock	27.9	27.95	27.9	27.92	4103.0
2011-07-26 08:00:00	MSFT	Stock	27.88	27.91	27.86	27.91	6227.0
2011-07-26 08:30:00	MSFT	Stock	27.92	27.92	27.87	27.87	2190.0
2011-07-26 09:00:00	MSFT	Stock	27.87	27.87	27.78	27.81	42073.0
2011-07-26 09:30:00	MSFT	Stock	27.82	27.99	27.78	27.9	7109027.0
2011-07-26 10:00:00	MSFT	Stock	27.9	27.99	27.845	27.92	4679277.0
2011-07-26 10:30:00	MSFT	Stock	27.925	27.99	27.89	27.99	6577982.0
2011-07-26 11:00:00	MSFT	Stock	27.99	28.045	27.95	28.03	5783712.0
2011-07-26 11:30:00	MSFT	Stock	28.03	28.04	27.97	28.008	2015728.0
2011-07-26 12:00:00	MSFT	Stock	28.01	28.05	28.0	28.0	2704364.0
2011-07-26 12:30:00	MSFT	Stock	28.0	28.08	28.0	28.08	8412877.0
2011-07-26 13:00:00	MSFT	Stock	28.08	28.09	28.04	28.07	2534963.0
2011-07-26 13:30:00	MSFT	Stock	28.07	28.09	28.04	28.08	3972130.0
2011-07-26 14:00:00	MSFT	Stock	28.08	28.145	28.07	28.085	5303671.0
2011-07-26 14:30:00	MSFT	Stock	28.09	28.11	28.02	28.03	3369946.0
2011-07-26 15:00:00	MSFT	Stock	28.03	28.1	28.03	28.1	4837988.0
2011-07-26 15:30:00	MSFT	Stock	28.099	28.1	28.01	28.07	9422581.0
2011-07-26 16:00:00	MSFT	Stock	28.07	28.09	27.97	28.053	5448987.0

> showing 50 of 75,835 rows — these rows as CSV

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