PREVIEW / stock_1hour / 2013-02-21

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-02-21.parquet
  size:    977 KB
  rows:    45,399
  symbols: 3,486

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
2013-02-21 05:00:00	AAPL	Stock	15.9339	15.9339	15.9279	15.9279	11200.0
2013-02-21 06:00:00	AAPL	Stock	15.9464	15.9464	15.9118	15.9118	14000.0
2013-02-21 07:00:00	AAPL	Stock	15.9196	15.9364	15.8857	15.9079	542108.0
2013-02-21 08:00:00	AAPL	Stock	15.9157	16.0714	15.8936	15.9396	2265648.0
2013-02-21 09:00:00	AAPL	Stock	15.945	16.003	15.8454	15.9011	72076424.0
2013-02-21 10:00:00	AAPL	Stock	15.8982	16.03	15.8539	15.9954	86128028.0
2013-02-21 11:00:00	AAPL	Stock	15.9939	16.0031	15.8907	15.9289	56115220.0
2013-02-21 12:00:00	AAPL	Stock	15.9289	15.9314	15.8536	15.8736	35035504.0
2013-02-21 13:00:00	AAPL	Stock	15.8754	15.9039	15.815	15.8493	36265124.0
2013-02-21 14:00:00	AAPL	Stock	15.8504	15.9821	15.8286	15.9821	57254484.0
2013-02-21 15:00:00	AAPL	Stock	15.9821	16.0418	15.9046	15.9271	69341216.0
2013-02-21 16:00:00	AAPL	Stock	15.9286	15.986	15.8873	15.9489	21871332.0
2013-02-21 17:00:00	AAPL	Stock	15.9396	15.9464	15.9311	15.9411	213052.0
2013-02-21 18:00:00	AAPL	Stock	15.9393	15.9461	15.9307	15.9389	168644.0
2013-02-21 19:00:00	AAPL	Stock	15.9425	15.9643	15.9425	15.9621	624792.0
2013-02-21 04:00:00	MSFT	Stock	27.8	27.8	27.8	27.8	101.0
2013-02-21 07:00:00	MSFT	Stock	27.8	27.82	27.72	27.72	9344.0
2013-02-21 08:00:00	MSFT	Stock	27.75	27.85	27.71	27.79	50553.0
2013-02-21 09:00:00	MSFT	Stock	27.75	27.79	27.52	27.57	5814979.0
2013-02-21 10:00:00	MSFT	Stock	27.56	27.62	27.49	27.49	9203416.0
2013-02-21 11:00:00	MSFT	Stock	27.495	27.56	27.45	27.53	7402943.0
2013-02-21 12:00:00	MSFT	Stock	27.522	27.54	27.23	27.5	5762139.0
2013-02-21 13:00:00	MSFT	Stock	27.501	27.53	27.43	27.495	4632422.0
2013-02-21 14:00:00	MSFT	Stock	27.5	27.57	27.46	27.559	6122420.0
2013-02-21 15:00:00	MSFT	Stock	27.55	27.63	27.46	27.47	7114574.0
2013-02-21 16:00:00	MSFT	Stock	27.49	27.57	27.467	27.56	2389502.0
2013-02-21 17:00:00	MSFT	Stock	27.55	27.56	27.49	27.49	69363.0
2013-02-21 18:00:00	MSFT	Stock	27.53	27.57	27.53	27.57	5100.0
2013-02-21 19:00:00	MSFT	Stock	27.57	27.58	27.57	27.58	2100.0
2013-02-21 04:00:00	NVDA	Stock	0.3085	0.3085	0.3085	0.3085	80000.0
2013-02-21 06:00:00	NVDA	Stock	0.3085	0.3085	0.3085	0.3085	4000.0
2013-02-21 07:00:00	NVDA	Stock	0.3085	0.3085	0.3085	0.3085	80000.0
2013-02-21 08:00:00	NVDA	Stock	0.3078	0.3085	0.3078	0.3085	100000.0
2013-02-21 09:00:00	NVDA	Stock	0.3085	0.3103	0.3065	0.3085	69341560.0
2013-02-21 10:00:00	NVDA	Stock	0.3085	0.3125	0.3073	0.3105	116755400.0
2013-02-21 11:00:00	NVDA	Stock	0.3106	0.3108	0.308	0.3097	74902000.0
2013-02-21 12:00:00	NVDA	Stock	0.3095	0.3103	0.3075	0.308	78823240.0
2013-02-21 13:00:00	NVDA	Stock	0.308	0.3093	0.307	0.3079	41413720.0
2013-02-21 14:00:00	NVDA	Stock	0.3079	0.3085	0.3065	0.3083	58797120.0
2013-02-21 15:00:00	NVDA	Stock	0.3083	0.3089	0.3068	0.307	82449000.0
2013-02-21 16:00:00	NVDA	Stock	0.3073	0.3091	0.307	0.3072	37925240.0
2013-02-21 07:00:00	AMZN	Stock	13.253	13.253	13.235	13.235	6000.0
2013-02-21 08:00:00	AMZN	Stock	13.25	13.295	13.2375	13.295	183620.0
2013-02-21 09:00:00	AMZN	Stock	13.2765	13.33	13.221	13.2705	14525140.0
2013-02-21 10:00:00	AMZN	Stock	13.2705	13.474	13.2175	13.4085	12212880.0
2013-02-21 11:00:00	AMZN	Stock	13.407	13.415	13.2775	13.308	7736160.0
2013-02-21 12:00:00	AMZN	Stock	13.307	13.318	13.204	13.2587	13207060.0
2013-02-21 13:00:00	AMZN	Stock	13.2585	13.2758	13.2075	13.226	6009580.0
2013-02-21 14:00:00	AMZN	Stock	13.226	13.264	13.1625	13.26	5203980.0
2013-02-21 15:00:00	AMZN	Stock	13.2601	13.3298	13.2288	13.2925	10440480.0

> showing 50 of 45,399 rows — these rows as CSV

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