PREVIEW / stock_1hour / 2011-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-03.parquet
  size:    972 KB
  rows:    46,302
  symbols: 3,560

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-03 04:00:00	AAPL	Stock	12.3493	12.3571	12.34	12.3571	14000.0
2011-05-03 05:00:00	AAPL	Stock	12.3571	12.3571	12.3571	12.3571	5600.0
2011-05-03 06:00:00	AAPL	Stock	12.3571	12.3571	12.3214	12.3214	38360.0
2011-05-03 07:00:00	AAPL	Stock	12.3214	12.35	12.3214	12.3411	77532.0
2011-05-03 08:00:00	AAPL	Stock	12.35	12.4104	12.35	12.3946	1388296.0
2011-05-03 09:00:00	AAPL	Stock	12.3929	12.4961	12.3811	12.4796	65040780.0
2011-05-03 10:00:00	AAPL	Stock	12.4818	12.4939	12.4029	12.4439	52480960.0
2011-05-03 11:00:00	AAPL	Stock	12.4439	12.4768	12.4396	12.4564	28219772.0
2011-05-03 12:00:00	AAPL	Stock	12.4564	12.4661	12.4079	12.4104	18356436.0
2011-05-03 13:00:00	AAPL	Stock	12.4104	12.4321	12.3436	12.3725	46805416.0
2011-05-03 14:00:00	AAPL	Stock	12.3715	12.4	12.3536	12.3857	30919784.0
2011-05-03 15:00:00	AAPL	Stock	12.3861	12.4479	12.3843	12.4286	55374872.0
2011-05-03 16:00:00	AAPL	Stock	12.4271	12.466	12.4169	12.466	6443696.0
2011-05-03 17:00:00	AAPL	Stock	12.4286	12.4382	12.4264	12.4357	594972.0
2011-05-03 18:00:00	AAPL	Stock	12.4289	12.4357	12.4261	12.4286	140476.0
2011-05-03 19:00:00	AAPL	Stock	12.4264	12.4318	12.4221	12.4268	76860.0
2011-05-03 07:00:00	MSFT	Stock	25.58	25.63	25.57	25.62	1714.0
2011-05-03 08:00:00	MSFT	Stock	25.62	25.62	25.5	25.58	31937.0
2011-05-03 09:00:00	MSFT	Stock	25.59	25.66	25.52	25.61	8376994.0
2011-05-03 10:00:00	MSFT	Stock	25.61	25.62	25.54	25.57	10086031.0
2011-05-03 11:00:00	MSFT	Stock	25.58	25.61	25.55	25.575	7654206.0
2011-05-03 12:00:00	MSFT	Stock	25.58	25.59	25.51	25.524	5387556.0
2011-05-03 13:00:00	MSFT	Stock	25.52	25.58	25.49	25.56	8664972.0
2011-05-03 14:00:00	MSFT	Stock	25.559	25.79	25.55	25.76	13615625.0
2011-05-03 15:00:00	MSFT	Stock	25.77	25.85	25.76	25.82	15332150.0
2011-05-03 16:00:00	MSFT	Stock	25.82	25.85	25.584	25.83	1650999.0
2011-05-03 17:00:00	MSFT	Stock	25.66	25.83	25.66	25.82	166881.0
2011-05-03 18:00:00	MSFT	Stock	25.81	25.81	25.8	25.8	15520.0
2011-05-03 19:00:00	MSFT	Stock	25.8	25.8	25.78	25.79	7710.0
2011-05-03 07:00:00	NVDA	Stock	0.485	0.4862	0.4778	0.4858	236000.0
2011-05-03 08:00:00	NVDA	Stock	0.4888	0.49	0.488	0.489	209480.0
2011-05-03 09:00:00	NVDA	Stock	0.4888	0.4892	0.4763	0.482	157985600.0
2011-05-03 10:00:00	NVDA	Stock	0.482	0.4843	0.4713	0.4758	170002120.0
2011-05-03 11:00:00	NVDA	Stock	0.476	0.478	0.4736	0.4758	78140240.0
2011-05-03 12:00:00	NVDA	Stock	0.4758	0.4768	0.4705	0.471	50389920.0
2011-05-03 13:00:00	NVDA	Stock	0.471	0.4715	0.4638	0.466	107930200.0
2011-05-03 14:00:00	NVDA	Stock	0.466	0.4695	0.4648	0.466	95395160.0
2011-05-03 15:00:00	NVDA	Stock	0.466	0.471	0.4658	0.47	132739280.0
2011-05-03 16:00:00	NVDA	Stock	0.47	0.4737	0.469	0.4705	2759600.0
2011-05-03 17:00:00	NVDA	Stock	0.4932	0.4932	0.4698	0.4698	582720.0
2011-05-03 18:00:00	NVDA	Stock	0.4698	0.4698	0.4698	0.4698	95560.0
2011-05-03 19:00:00	NVDA	Stock	0.469	0.4692	0.4678	0.4692	184000.0
2011-05-03 04:00:00	AMZN	Stock	10.0125	10.0125	10.0125	10.0125	6000.0
2011-05-03 05:00:00	AMZN	Stock	10.0055	10.0055	10.0055	10.0055	4000.0
2011-05-03 06:00:00	AMZN	Stock	10.0075	10.0075	10.0075	10.0075	2000.0
2011-05-03 07:00:00	AMZN	Stock	10.012	10.05	10.0105	10.0105	22000.0
2011-05-03 08:00:00	AMZN	Stock	10.0255	10.045	10.0255	10.033	118780.0
2011-05-03 09:00:00	AMZN	Stock	10.0335	10.1295	9.9605	10.1032	25087060.0
2011-05-03 10:00:00	AMZN	Stock	10.107	10.1275	10.01	10.03	21717160.0
2011-05-03 11:00:00	AMZN	Stock	10.03	10.042	9.9725	9.9845	12112420.0

> showing 50 of 46,302 rows — these rows as CSV

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