PREVIEW / stock_30min / 2011-03-01

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-01.parquet
  size:    1.5 MB
  rows:    79,688
  symbols: 3,536

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-03-01 04:00:00	AAPL	Stock	12.6793	12.7054	12.6793	12.7054	5600.0
2011-03-01 04:30:00	AAPL	Stock	12.7179	12.7179	12.7179	12.7179	2800.0
2011-03-01 05:00:00	AAPL	Stock	12.6964	12.6964	12.6964	12.6964	22400.0
2011-03-01 06:00:00	AAPL	Stock	12.7111	12.7139	12.6786	12.6786	47040.0
2011-03-01 06:30:00	AAPL	Stock	12.6782	12.6786	12.6782	12.6786	22540.0
2011-03-01 07:00:00	AAPL	Stock	12.6936	12.6936	12.6304	12.6375	260372.0
2011-03-01 07:30:00	AAPL	Stock	12.6375	12.6593	12.6254	12.6536	178864.0
2011-03-01 08:00:00	AAPL	Stock	12.6536	12.6964	12.6464	12.6625	780640.0
2011-03-01 08:30:00	AAPL	Stock	12.6618	12.6661	12.6554	12.6661	436268.0
2011-03-01 09:00:00	AAPL	Stock	12.6664	12.6954	12.6146	12.6954	1763692.0
2011-03-01 09:30:00	AAPL	Stock	12.6964	12.7043	12.5714	12.6207	57446228.0
2011-03-01 10:00:00	AAPL	Stock	12.6257	12.6339	12.5571	12.5607	44407412.0
2011-03-01 10:30:00	AAPL	Stock	12.5611	12.6225	12.5357	12.6146	33783064.0
2011-03-01 11:00:00	AAPL	Stock	12.6168	12.6304	12.5682	12.5689	19452300.0
2011-03-01 11:30:00	AAPL	Stock	12.5729	12.5796	12.5	12.5136	31839556.0
2011-03-01 12:00:00	AAPL	Stock	12.5125	12.5357	12.4775	12.4832	29147860.0
2011-03-01 12:30:00	AAPL	Stock	12.4821	12.5296	12.4746	12.4954	18246956.0
2011-03-01 13:00:00	AAPL	Stock	12.4896	12.5125	12.4661	12.4882	24400040.0
2011-03-01 13:30:00	AAPL	Stock	12.4864	12.52	12.4786	12.5111	21711368.0
2011-03-01 14:00:00	AAPL	Stock	12.5076	12.5111	12.4308	12.4382	38081148.0
2011-03-01 14:30:00	AAPL	Stock	12.4371	12.4732	12.4232	12.4468	28851116.0
2011-03-01 15:00:00	AAPL	Stock	12.4466	12.4932	12.4172	12.4669	31975888.0
2011-03-01 15:30:00	AAPL	Stock	12.4686	12.4968	12.4544	12.4821	41275248.0
2011-03-01 16:00:00	AAPL	Stock	12.475	12.5298	12.4554	12.4554	12468064.0
2011-03-01 16:30:00	AAPL	Stock	12.5299	12.5299	12.4286	12.4386	2384228.0
2011-03-01 17:00:00	AAPL	Stock	12.4389	12.4518	12.4304	12.4439	547652.0
2011-03-01 17:30:00	AAPL	Stock	12.4443	12.4825	12.4371	12.4443	892388.0
2011-03-01 18:00:00	AAPL	Stock	12.4454	12.4754	12.4371	12.4643	624176.0
2011-03-01 18:30:00	AAPL	Stock	12.465	12.4657	12.4543	12.4582	114716.0
2011-03-01 19:00:00	AAPL	Stock	12.4636	12.4639	12.4568	12.4571	94668.0
2011-03-01 19:30:00	AAPL	Stock	12.4554	12.4571	12.4468	12.4554	249172.0
2011-03-01 04:00:00	MSFT	Stock	26.74	26.74	26.74	26.74	300.0
2011-03-01 06:30:00	MSFT	Stock	26.74	26.74	26.74	26.74	100.0
2011-03-01 07:00:00	MSFT	Stock	26.7	26.71	26.7	26.7	1100.0
2011-03-01 07:30:00	MSFT	Stock	26.69	26.7	26.69	26.7	400.0
2011-03-01 08:00:00	MSFT	Stock	26.69	26.7	26.65	26.68	8517.0
2011-03-01 08:30:00	MSFT	Stock	26.7	26.7	26.69	26.69	1978.0
2011-03-01 09:00:00	MSFT	Stock	26.68	26.7	26.58	26.6	94674.0
2011-03-01 09:30:00	MSFT	Stock	26.61	26.78	26.6	26.66	5678811.0
2011-03-01 10:00:00	MSFT	Stock	26.66	26.7	26.52	26.52	4688854.0
2011-03-01 10:30:00	MSFT	Stock	26.52	26.55	26.49	26.534	3385926.0
2011-03-01 11:00:00	MSFT	Stock	26.53	26.56	26.48	26.489	2553111.0
2011-03-01 11:30:00	MSFT	Stock	26.48	26.5	26.42	26.447	3985298.0
2011-03-01 12:00:00	MSFT	Stock	26.44	26.47	26.41	26.44	3176747.0
2011-03-01 12:30:00	MSFT	Stock	26.445	26.46	26.37	26.4	2904635.0
2011-03-01 13:00:00	MSFT	Stock	26.4	26.41	26.33	26.35	3888146.0
2011-03-01 13:30:00	MSFT	Stock	26.34	26.41	26.33	26.41	2842188.0
2011-03-01 14:00:00	MSFT	Stock	26.41	26.41	26.22	26.24	4162080.0
2011-03-01 14:30:00	MSFT	Stock	26.23	26.27	26.2	26.22	3256735.0
2011-03-01 15:00:00	MSFT	Stock	26.23	26.24	26.16	26.17	5075797.0

> showing 50 of 79,688 rows — these rows as CSV

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