PREVIEW / stock_30min / 2012-03-01

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-01.parquet
  size:    1.5 MB
  rows:    77,745
  symbols: 3,517

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-03-01 04:00:00	AAPL	Stock	19.4286	19.4957	19.4286	19.4957	154980.0
2012-03-01 04:30:00	AAPL	Stock	19.5107	19.5107	19.4643	19.4671	42700.0
2012-03-01 05:00:00	AAPL	Stock	19.5	19.5179	19.4821	19.4821	35476.0
2012-03-01 05:30:00	AAPL	Stock	19.4964	19.4964	19.4786	19.4821	106400.0
2012-03-01 06:00:00	AAPL	Stock	19.4786	19.5	19.4786	19.4893	61180.0
2012-03-01 06:30:00	AAPL	Stock	19.4929	19.4929	19.4893	19.4893	39200.0
2012-03-01 07:00:00	AAPL	Stock	19.4821	19.5118	19.4754	19.4857	477316.0
2012-03-01 07:30:00	AAPL	Stock	19.4893	19.4893	19.4393	19.4839	637896.0
2012-03-01 08:00:00	AAPL	Stock	19.4786	19.5243	19.4643	19.5193	3354792.0
2012-03-01 08:30:00	AAPL	Stock	19.5196	19.5357	19.4925	19.5314	4348652.0
2012-03-01 09:00:00	AAPL	Stock	19.5257	19.5868	19.5196	19.5686	5849340.0
2012-03-01 09:30:00	AAPL	Stock	19.5786	19.5789	19.3321	19.4325	139979896.0
2012-03-01 10:00:00	AAPL	Stock	19.432	19.445	19.3464	19.4071	86909788.0
2012-03-01 10:30:00	AAPL	Stock	19.4039	19.46	19.3075	19.3754	64631112.0
2012-03-01 11:00:00	AAPL	Stock	19.3746	19.4018	19.2418	19.3077	73962056.0
2012-03-01 11:30:00	AAPL	Stock	19.3086	19.3904	19.2804	19.3608	42683788.0
2012-03-01 12:00:00	AAPL	Stock	19.3625	19.4289	19.3311	19.3893	31439268.0
2012-03-01 12:30:00	AAPL	Stock	19.3896	19.4214	19.3771	19.4096	17824240.0
2012-03-01 13:00:00	AAPL	Stock	19.4097	19.4482	19.3857	19.4346	23082948.0
2012-03-01 13:30:00	AAPL	Stock	19.4361	19.4557	19.4311	19.4375	16118872.0
2012-03-01 14:00:00	AAPL	Stock	19.4393	19.4621	19.4161	19.4182	28428036.0
2012-03-01 14:30:00	AAPL	Stock	19.4161	19.4411	19.4	19.4232	24396204.0
2012-03-01 15:00:00	AAPL	Stock	19.4214	19.4393	19.3596	19.4157	37557604.0
2012-03-01 15:30:00	AAPL	Stock	19.4114	19.4607	19.3661	19.4382	63276808.0
2012-03-01 16:00:00	AAPL	Stock	19.4371	19.4518	19.3992	19.4461	7117432.0
2012-03-01 16:30:00	AAPL	Stock	19.4464	19.4686	19.4136	19.4568	921396.0
2012-03-01 17:00:00	AAPL	Stock	19.4511	19.4604	19.4429	19.4571	470960.0
2012-03-01 17:30:00	AAPL	Stock	19.4571	19.4611	19.4436	19.4611	240800.0
2012-03-01 18:00:00	AAPL	Stock	19.4618	19.4643	19.46	19.4625	100212.0
2012-03-01 18:30:00	AAPL	Stock	19.4625	19.4639	19.4589	19.4629	169484.0
2012-03-01 19:00:00	AAPL	Stock	19.4629	19.4664	19.4554	19.465	207060.0
2012-03-01 19:30:00	AAPL	Stock	19.4668	19.4768	19.4643	19.475	252084.0
2012-03-01 07:00:00	MSFT	Stock	31.94	31.94	31.85	31.85	3910.0
2012-03-01 07:30:00	MSFT	Stock	31.85	31.85	31.85	31.85	2100.0
2012-03-01 08:00:00	MSFT	Stock	31.85	31.85	31.8	31.84	27202.0
2012-03-01 08:30:00	MSFT	Stock	31.84	31.84	31.82	31.83	2700.0
2012-03-01 09:00:00	MSFT	Stock	31.82	32.1	31.78	31.93	346021.0
2012-03-01 09:30:00	MSFT	Stock	31.93	32.0	31.85	31.975	12363410.0
2012-03-01 10:00:00	MSFT	Stock	31.98	32.05	31.87	31.96	10076222.0
2012-03-01 10:30:00	MSFT	Stock	31.97	31.97	31.86	31.91	5663001.0
2012-03-01 11:00:00	MSFT	Stock	31.91	31.99	31.85	31.98	3966277.0
2012-03-01 11:30:00	MSFT	Stock	31.99	32.205	31.97	32.2	4382391.0
2012-03-01 12:00:00	MSFT	Stock	32.194	32.23	32.07	32.184	4395628.0
2012-03-01 12:30:00	MSFT	Stock	32.18	32.25	32.17	32.235	2932363.0
2012-03-01 13:00:00	MSFT	Stock	32.235	32.38	32.22	32.38	4002349.0
2012-03-01 13:30:00	MSFT	Stock	32.37	32.39	32.27	32.318	4090671.0
2012-03-01 14:00:00	MSFT	Stock	32.31	32.37	32.29	32.345	2573044.0
2012-03-01 14:30:00	MSFT	Stock	32.34	32.36	32.26	32.278	3622444.0
2012-03-01 15:00:00	MSFT	Stock	32.275	32.37	32.1	32.3	6072839.0
2012-03-01 15:30:00	MSFT	Stock	32.3	32.32	32.15	32.28	7080506.0

> showing 50 of 77,745 rows — these rows as CSV

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