PREVIEW / stock_30min / 2011-05-10

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-10.parquet
  size:    1.4 MB
  rows:    75,656
  symbols: 3,549

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-05-10 04:00:00	AAPL	Stock	12.4464	12.4464	12.4304	12.4304	5600.0
2011-05-10 04:30:00	AAPL	Stock	12.4425	12.4454	12.4425	12.4425	11200.0
2011-05-10 05:30:00	AAPL	Stock	12.4393	12.4393	12.4393	12.4393	84000.0
2011-05-10 06:00:00	AAPL	Stock	12.4304	12.4304	12.4304	12.4304	5600.0
2011-05-10 07:00:00	AAPL	Stock	12.4468	12.4532	12.4382	12.4382	134400.0
2011-05-10 07:30:00	AAPL	Stock	12.4357	12.4821	12.4357	12.4707	403788.0
2011-05-10 08:00:00	AAPL	Stock	12.4679	12.4707	12.4143	12.4582	1046360.0
2011-05-10 08:30:00	AAPL	Stock	12.4582	12.4614	12.4143	12.4536	501844.0
2011-05-10 09:00:00	AAPL	Stock	12.4554	12.4625	12.4429	12.4625	628320.0
2011-05-10 09:30:00	AAPL	Stock	12.4596	12.4629	12.3807	12.4232	44701972.0
2011-05-10 10:00:00	AAPL	Stock	12.4254	12.4357	12.4011	12.4122	24197936.0
2011-05-10 10:30:00	AAPL	Stock	12.4121	12.4239	12.4014	12.4117	13869660.0
2011-05-10 11:00:00	AAPL	Stock	12.4118	12.4118	12.3929	12.4025	15244208.0
2011-05-10 11:30:00	AAPL	Stock	12.4025	12.4214	12.3879	12.4096	10644088.0
2011-05-10 12:00:00	AAPL	Stock	12.4096	12.4182	12.3954	12.4018	7780164.0
2011-05-10 12:30:00	AAPL	Stock	12.4021	12.4132	12.3904	12.3916	8544228.0
2011-05-10 13:00:00	AAPL	Stock	12.3925	12.4057	12.3821	12.3975	10047492.0
2011-05-10 13:30:00	AAPL	Stock	12.3982	12.4086	12.3907	12.4064	10896928.0
2011-05-10 14:00:00	AAPL	Stock	12.4065	12.4068	12.3875	12.3954	8811432.0
2011-05-10 14:30:00	AAPL	Stock	12.3957	12.4139	12.3911	12.4089	12397700.0
2011-05-10 15:00:00	AAPL	Stock	12.4094	12.4354	12.4025	12.4218	22731380.0
2011-05-10 15:30:00	AAPL	Stock	12.4221	12.4889	12.4143	12.4804	73566556.0
2011-05-10 16:00:00	AAPL	Stock	12.4804	12.4875	12.4113	12.4707	7725844.0
2011-05-10 16:30:00	AAPL	Stock	12.4725	12.478	12.4679	12.4714	334376.0
2011-05-10 17:00:00	AAPL	Stock	12.4732	12.4804	12.47	12.4739	1382360.0
2011-05-10 17:30:00	AAPL	Stock	12.4743	12.4764	12.47	12.4764	134400.0
2011-05-10 18:00:00	AAPL	Stock	12.4768	12.4814	12.4714	12.4714	344428.0
2011-05-10 18:30:00	AAPL	Stock	12.4768	12.4893	12.4768	12.4893	378476.0
2011-05-10 19:00:00	AAPL	Stock	12.4875	12.4929	12.4825	12.4893	263564.0
2011-05-10 19:30:00	AAPL	Stock	12.495	12.4954	12.4771	12.4875	161560.0
2011-05-10 04:00:00	MSFT	Stock	25.64	25.64	25.64	25.64	100.0
2011-05-10 04:30:00	MSFT	Stock	25.82	25.82	25.82	25.82	200.0
2011-05-10 05:00:00	MSFT	Stock	25.9	25.9	25.9	25.9	100.0
2011-05-10 06:00:00	MSFT	Stock	25.85	25.85	25.8	25.85	22100.0
2011-05-10 06:30:00	MSFT	Stock	25.85	25.97	25.85	25.93	10916.0
2011-05-10 07:00:00	MSFT	Stock	25.91	25.97	25.79	25.95	36615.0
2011-05-10 07:30:00	MSFT	Stock	25.97	26.0	25.56	25.56	343755.0
2011-05-10 08:00:00	MSFT	Stock	25.69	25.9	25.43	25.43	670404.0
2011-05-10 08:30:00	MSFT	Stock	25.43	25.83	25.23	25.3	1199208.0
2011-05-10 09:00:00	MSFT	Stock	25.3	25.42	25.2	25.38	1304617.0
2011-05-10 09:30:00	MSFT	Stock	25.39	25.85	25.25	25.79	19562732.0
2011-05-10 10:00:00	MSFT	Stock	25.79	25.8	25.53	25.58	11694759.0
2011-05-10 10:30:00	MSFT	Stock	25.57	25.62	25.36	25.49	16693612.0
2011-05-10 11:00:00	MSFT	Stock	25.5	25.57	25.4	25.47	9807849.0
2011-05-10 11:30:00	MSFT	Stock	25.465	25.54	25.46	25.47	6230013.0
2011-05-10 12:00:00	MSFT	Stock	25.48	25.51	25.45	25.47	5305204.0
2011-05-10 12:30:00	MSFT	Stock	25.465	25.5	25.41	25.43	6412702.0
2011-05-10 13:00:00	MSFT	Stock	25.43	25.5	25.41	25.468	4933850.0
2011-05-10 13:30:00	MSFT	Stock	25.47	25.58	25.46	25.575	4103563.0
2011-05-10 14:00:00	MSFT	Stock	25.58	25.58	25.51	25.54	3754299.0

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

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