PREVIEW / stock_1hour / 2011-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-04.parquet
  size:    1005 KB
  rows:    48,111
  symbols: 3,567

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-08-04 04:00:00	AAPL	Stock	13.9964	14.0211	13.9964	14.0207	22400.0
2011-08-04 05:00:00	AAPL	Stock	13.9789	13.9789	13.9789	13.9789	2800.0
2011-08-04 06:00:00	AAPL	Stock	13.9761	13.9761	13.9079	13.9375	84000.0
2011-08-04 07:00:00	AAPL	Stock	13.9375	13.9579	13.9214	13.9432	418544.0
2011-08-04 08:00:00	AAPL	Stock	13.9543	13.9571	13.8536	13.9054	3792768.0
2011-08-04 09:00:00	AAPL	Stock	13.9057	13.9757	13.8214	13.8771	89421584.0
2011-08-04 10:00:00	AAPL	Stock	13.8743	13.905	13.75	13.7546	135930676.0
2011-08-04 11:00:00	AAPL	Stock	13.7546	13.8096	13.6746	13.7121	132968864.0
2011-08-04 12:00:00	AAPL	Stock	13.7132	13.8293	13.6939	13.7443	94894940.0
2011-08-04 13:00:00	AAPL	Stock	13.7475	13.7882	13.7268	13.7543	58116184.0
2011-08-04 14:00:00	AAPL	Stock	13.7575	13.7925	13.6786	13.6986	105949452.0
2011-08-04 15:00:00	AAPL	Stock	13.7007	13.75	13.4768	13.4768	224621152.0
2011-08-04 16:00:00	AAPL	Stock	13.4814	13.7334	13.4748	13.4971	15351168.0
2011-08-04 17:00:00	AAPL	Stock	13.4971	13.5179	13.4775	13.5036	1355816.0
2011-08-04 18:00:00	AAPL	Stock	13.5036	13.5036	13.4546	13.4571	735840.0
2011-08-04 19:00:00	AAPL	Stock	13.4589	13.4607	13.3943	13.4286	782180.0
2011-08-04 05:00:00	MSFT	Stock	26.77	26.77	26.7	26.7	600.0
2011-08-04 06:00:00	MSFT	Stock	26.7	26.7	26.63	26.63	600.0
2011-08-04 07:00:00	MSFT	Stock	26.59	26.66	26.52	26.66	7831.0
2011-08-04 08:00:00	MSFT	Stock	26.66	26.66	26.5	26.6	28843.0
2011-08-04 09:00:00	MSFT	Stock	26.66	26.81	26.4	26.77	7348555.0
2011-08-04 10:00:00	MSFT	Stock	26.77	26.87	26.48	26.516	13249690.0
2011-08-04 11:00:00	MSFT	Stock	26.515	26.6	26.23	26.421	15353250.0
2011-08-04 12:00:00	MSFT	Stock	26.43	26.58	26.39	26.451	8694333.0
2011-08-04 13:00:00	MSFT	Stock	26.46	26.57	26.39	26.465	6834920.0
2011-08-04 14:00:00	MSFT	Stock	26.47	26.48	26.21	26.32	10760090.0
2011-08-04 15:00:00	MSFT	Stock	26.32	26.39	25.93	25.93	25301564.0
2011-08-04 16:00:00	MSFT	Stock	25.94	26.396	25.89	25.94	4074049.0
2011-08-04 17:00:00	MSFT	Stock	25.94	26.03	25.93	25.94	189004.0
2011-08-04 18:00:00	MSFT	Stock	25.95	26.04	25.91	26.04	89890.0
2011-08-04 19:00:00	MSFT	Stock	26.0	26.0	25.91	25.91	1891.0
2011-08-04 08:00:00	NVDA	Stock	0.3638	0.364	0.363	0.364	56000.0
2011-08-04 09:00:00	NVDA	Stock	0.364	0.3648	0.354	0.3555	74120440.0
2011-08-04 10:00:00	NVDA	Stock	0.3556	0.3575	0.3513	0.3513	172620760.0
2011-08-04 11:00:00	NVDA	Stock	0.3513	0.354	0.3453	0.3482	134058480.0
2011-08-04 12:00:00	NVDA	Stock	0.3482	0.3502	0.3455	0.3468	95339960.0
2011-08-04 13:00:00	NVDA	Stock	0.3465	0.3475	0.3425	0.3438	105603000.0
2011-08-04 14:00:00	NVDA	Stock	0.3438	0.3442	0.3395	0.3426	121368240.0
2011-08-04 15:00:00	NVDA	Stock	0.3428	0.3455	0.335	0.3353	241740160.0
2011-08-04 16:00:00	NVDA	Stock	0.3355	0.3401	0.3338	0.335	8887440.0
2011-08-04 17:00:00	NVDA	Stock	0.336	0.3375	0.335	0.3368	524600.0
2011-08-04 18:00:00	NVDA	Stock	0.3368	0.3368	0.335	0.3358	134400.0
2011-08-04 19:00:00	NVDA	Stock	0.3358	0.336	0.335	0.335	56000.0
2011-08-04 04:00:00	AMZN	Stock	10.501	10.501	10.501	10.501	2000.0
2011-08-04 06:00:00	AMZN	Stock	10.45	10.45	10.45	10.45	2000.0
2011-08-04 07:00:00	AMZN	Stock	10.4925	10.4925	10.4	10.4185	24000.0
2011-08-04 08:00:00	AMZN	Stock	10.425	10.425	10.299	10.356	439440.0
2011-08-04 09:00:00	AMZN	Stock	10.3685	10.4	10.206	10.3025	18110060.0
2011-08-04 10:00:00	AMZN	Stock	10.2945	10.3835	10.225	10.2703	22841340.0
2011-08-04 11:00:00	AMZN	Stock	10.2668	10.314	10.172	10.201	15966400.0

> showing 50 of 48,111 rows — these rows as CSV

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