PREVIEW / stock_1hour / 2012-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-08.parquet
  size:    956 KB
  rows:    45,114
  symbols: 3,557

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
2012-02-08 04:00:00	AAPL	Stock	16.8093	16.8686	16.8093	16.8589	107352.0
2012-02-08 05:00:00	AAPL	Stock	16.8286	16.8286	16.8036	16.8204	56840.0
2012-02-08 06:00:00	AAPL	Stock	16.8321	16.8343	16.8146	16.8214	83860.0
2012-02-08 07:00:00	AAPL	Stock	16.8179	16.8232	16.7864	16.8121	494228.0
2012-02-08 08:00:00	AAPL	Stock	16.8175	16.8214	16.7143	16.8018	2006928.0
2012-02-08 09:00:00	AAPL	Stock	16.8018	16.8907	16.775	16.8875	62735568.0
2012-02-08 10:00:00	AAPL	Stock	16.8889	16.9364	16.8482	16.8729	87138240.0
2012-02-08 11:00:00	AAPL	Stock	16.8739	16.8854	16.8071	16.8814	63560448.0
2012-02-08 12:00:00	AAPL	Stock	16.8806	16.9057	16.8489	16.9027	28730604.0
2012-02-08 13:00:00	AAPL	Stock	16.9032	16.9354	16.8882	16.9181	27844852.0
2012-02-08 14:00:00	AAPL	Stock	16.9179	16.9696	16.9125	16.9621	50042832.0
2012-02-08 15:00:00	AAPL	Stock	16.9629	17.0282	16.9586	17.0239	69696872.0
2012-02-08 16:00:00	AAPL	Stock	17.0229	17.0607	16.8247	17.0571	7478240.0
2012-02-08 17:00:00	AAPL	Stock	17.0446	17.0529	17.0179	17.0214	635544.0
2012-02-08 18:00:00	AAPL	Stock	17.0232	17.0321	17.0021	17.0286	384888.0
2012-02-08 19:00:00	AAPL	Stock	17.0214	17.0321	17.0079	17.0218	459564.0
2012-02-08 04:00:00	MSFT	Stock	30.4	30.55	30.4	30.55	300.0
2012-02-08 05:00:00	MSFT	Stock	30.49	30.49	30.49	30.49	200.0
2012-02-08 06:00:00	MSFT	Stock	30.49	30.49	30.49	30.49	100.0
2012-02-08 08:00:00	MSFT	Stock	30.36	30.42	30.35	30.4	45886.0
2012-02-08 09:00:00	MSFT	Stock	30.38	30.4	30.22	30.37	4432224.0
2012-02-08 10:00:00	MSFT	Stock	30.375	30.48	30.37	30.395	6966687.0
2012-02-08 11:00:00	MSFT	Stock	30.395	30.425	30.32	30.352	8919568.0
2012-02-08 12:00:00	MSFT	Stock	30.356	30.47	30.35	30.462	4382012.0
2012-02-08 13:00:00	MSFT	Stock	30.47	30.49	30.41	30.46	4020575.0
2012-02-08 14:00:00	MSFT	Stock	30.46	30.56	30.45	30.56	5303062.0
2012-02-08 15:00:00	MSFT	Stock	30.555	30.67	30.51	30.66	13158767.0
2012-02-08 16:00:00	MSFT	Stock	30.66	30.69	30.461	30.66	1904124.0
2012-02-08 17:00:00	MSFT	Stock	30.6	30.65	30.58	30.62	7000.0
2012-02-08 18:00:00	MSFT	Stock	30.6	30.65	30.6	30.64	1696.0
2012-02-08 19:00:00	MSFT	Stock	30.61	30.61	30.61	30.61	2456.0
2012-02-08 08:00:00	NVDA	Stock	0.3935	0.3973	0.3935	0.3973	265600.0
2012-02-08 09:00:00	NVDA	Stock	0.3973	0.4079	0.3915	0.406	136633760.0
2012-02-08 10:00:00	NVDA	Stock	0.4058	0.4155	0.4058	0.4089	223609040.0
2012-02-08 11:00:00	NVDA	Stock	0.4088	0.4095	0.4035	0.4058	125404840.0
2012-02-08 12:00:00	NVDA	Stock	0.406	0.4093	0.4041	0.4093	72537440.0
2012-02-08 13:00:00	NVDA	Stock	0.4093	0.41	0.4078	0.4082	58231720.0
2012-02-08 14:00:00	NVDA	Stock	0.408	0.4098	0.4075	0.4088	61122560.0
2012-02-08 15:00:00	NVDA	Stock	0.4087	0.41	0.4072	0.4078	143681560.0
2012-02-08 16:00:00	NVDA	Stock	0.4075	0.4105	0.4072	0.4078	22561320.0
2012-02-08 17:00:00	NVDA	Stock	0.411	0.4112	0.4075	0.411	110520.0
2012-02-08 18:00:00	NVDA	Stock	0.4095	0.4095	0.4095	0.4095	18000.0
2012-02-08 19:00:00	NVDA	Stock	0.4093	0.4093	0.4078	0.4078	28000.0
2012-02-08 06:00:00	AMZN	Stock	9.225	9.225	9.225	9.225	6000.0
2012-02-08 07:00:00	AMZN	Stock	9.225	9.225	9.224	9.225	14000.0
2012-02-08 08:00:00	AMZN	Stock	9.2445	9.27	9.236	9.2575	236580.0
2012-02-08 09:00:00	AMZN	Stock	9.2575	9.323	9.2385	9.31	16761400.0
2012-02-08 10:00:00	AMZN	Stock	9.3145	9.3245	9.165	9.2196	22983100.0
2012-02-08 11:00:00	AMZN	Stock	9.2195	9.2245	9.1455	9.2135	13283160.0
2012-02-08 12:00:00	AMZN	Stock	9.2135	9.246	9.2	9.21	9841100.0

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

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