PREVIEW / stock_30min / 2011-05-11

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-11.parquet
  size:    1.4 MB
  rows:    76,617
  symbols: 3,553

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-11 04:30:00	AAPL	Stock	12.4689	12.4689	12.4689	12.4689	8400.0
2011-05-11 05:30:00	AAPL	Stock	12.4696	12.4696	12.4696	12.4696	2800.0
2011-05-11 06:00:00	AAPL	Stock	12.475	12.475	12.475	12.475	8400.0
2011-05-11 06:30:00	AAPL	Stock	12.4696	12.4696	12.4636	12.4636	23520.0
2011-05-11 07:00:00	AAPL	Stock	12.4607	12.4607	12.4464	12.4543	98000.0
2011-05-11 07:30:00	AAPL	Stock	12.4621	12.4714	12.4571	12.4571	149240.0
2011-05-11 08:00:00	AAPL	Stock	12.4607	12.4643	12.4257	12.4268	700924.0
2011-05-11 08:30:00	AAPL	Stock	12.4339	12.4732	12.4289	12.4593	1194676.0
2011-05-11 09:00:00	AAPL	Stock	12.4632	12.4829	12.4593	12.4643	1586116.0
2011-05-11 09:30:00	AAPL	Stock	12.4643	12.5	12.4214	12.4571	50693244.0
2011-05-11 10:00:00	AAPL	Stock	12.4571	12.4732	12.4321	12.4621	23595936.0
2011-05-11 10:30:00	AAPL	Stock	12.4596	12.475	12.415	12.4507	29668856.0
2011-05-11 11:00:00	AAPL	Stock	12.4508	12.48	12.4464	12.4607	12770464.0
2011-05-11 11:30:00	AAPL	Stock	12.4614	12.4721	12.4118	12.4219	17716832.0
2011-05-11 12:00:00	AAPL	Stock	12.4239	12.4307	12.3693	12.3914	32110652.0
2011-05-11 12:30:00	AAPL	Stock	12.3918	12.4121	12.3786	12.4021	18437972.0
2011-05-11 13:00:00	AAPL	Stock	12.4025	12.4071	12.3786	12.3818	15757168.0
2011-05-11 13:30:00	AAPL	Stock	12.3811	12.3857	12.33	12.3608	32681852.0
2011-05-11 14:00:00	AAPL	Stock	12.3599	12.3675	12.3329	12.3511	15162952.0
2011-05-11 14:30:00	AAPL	Stock	12.3504	12.3875	12.35	12.375	14001148.0
2011-05-11 15:00:00	AAPL	Stock	12.3721	12.4246	12.3679	12.405	22314040.0
2011-05-11 15:30:00	AAPL	Stock	12.4046	12.4182	12.38	12.4014	29180648.0
2011-05-11 16:00:00	AAPL	Stock	12.4014	12.4602	12.3901	12.4125	12246360.0
2011-05-11 16:30:00	AAPL	Stock	12.4096	12.4096	12.3945	12.395	488684.0
2011-05-11 17:00:00	AAPL	Stock	12.3964	12.3964	12.3821	12.3861	467040.0
2011-05-11 17:30:00	AAPL	Stock	12.3861	12.4011	12.3786	12.3786	455308.0
2011-05-11 18:00:00	AAPL	Stock	12.3754	12.4011	12.365	12.3679	316400.0
2011-05-11 18:30:00	AAPL	Stock	12.3664	12.3686	12.35	12.35	294812.0
2011-05-11 19:00:00	AAPL	Stock	12.3514	12.3679	12.3282	12.3504	674856.0
2011-05-11 19:30:00	AAPL	Stock	12.3489	12.3679	12.3468	12.3643	294980.0
2011-05-11 05:30:00	MSFT	Stock	25.8	25.8	25.8	25.8	500.0
2011-05-11 06:30:00	MSFT	Stock	25.75	25.75	25.75	25.75	200.0
2011-05-11 07:00:00	MSFT	Stock	25.78	25.8	25.73	25.73	4060.0
2011-05-11 07:30:00	MSFT	Stock	25.76	25.79	25.76	25.77	4915.0
2011-05-11 08:00:00	MSFT	Stock	25.76	25.77	25.61	25.61	27782.0
2011-05-11 08:30:00	MSFT	Stock	25.6	25.64	25.6	25.62	21638.0
2011-05-11 09:00:00	MSFT	Stock	25.64	25.68	25.58	25.64	26997.0
2011-05-11 09:30:00	MSFT	Stock	25.66	25.67	25.51	25.55	7935495.0
2011-05-11 10:00:00	MSFT	Stock	25.55	25.56	25.49	25.5	6251283.0
2011-05-11 10:30:00	MSFT	Stock	25.5	25.55	25.49	25.532	4560397.0
2011-05-11 11:00:00	MSFT	Stock	25.54	25.61	25.53	25.55	4119027.0
2011-05-11 11:30:00	MSFT	Stock	25.56	25.59	25.5	25.538	4633708.0
2011-05-11 12:00:00	MSFT	Stock	25.534	25.55	25.34	25.4	8747775.0
2011-05-11 12:30:00	MSFT	Stock	25.39	25.44	25.34	25.371	4616020.0
2011-05-11 13:00:00	MSFT	Stock	25.38	25.39	25.31	25.32	4635092.0
2011-05-11 13:30:00	MSFT	Stock	25.31	25.32	25.21	25.258	6907752.0
2011-05-11 14:00:00	MSFT	Stock	25.25	25.31	25.23	25.27	3750584.0
2011-05-11 14:30:00	MSFT	Stock	25.265	25.38	25.26	25.31	5816073.0
2011-05-11 15:00:00	MSFT	Stock	25.31	25.36	25.26	25.295	3958683.0
2011-05-11 15:30:00	MSFT	Stock	25.295	25.39	25.25	25.35	8833077.0

> showing 50 of 76,617 rows — these rows as CSV

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