PREVIEW / stock_1hour / 2014-02-12

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-12.parquet
  size:    1.0 MB
  rows:    47,749
  symbols: 3,535

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
2014-02-12 04:00:00	AAPL	Stock	19.1929	19.1929	19.1929	19.1929	5600.0
2014-02-12 05:00:00	AAPL	Stock	19.2107	19.2314	19.1896	19.2057	102704.0
2014-02-12 06:00:00	AAPL	Stock	19.2011	19.2011	19.1754	19.1764	30660.0
2014-02-12 07:00:00	AAPL	Stock	19.1393	19.1679	19.1393	19.1429	100128.0
2014-02-12 08:00:00	AAPL	Stock	19.1457	19.1964	19.1393	19.1921	761096.0
2014-02-12 09:00:00	AAPL	Stock	19.1925	19.27	19.1004	19.1536	55407856.0
2014-02-12 10:00:00	AAPL	Stock	19.1529	19.2036	19.0443	19.1682	46143916.0
2014-02-12 11:00:00	AAPL	Stock	19.1704	19.2411	19.1089	19.1232	28264460.0
2014-02-12 12:00:00	AAPL	Stock	19.1229	19.1739	19.0896	19.1464	16304568.0
2014-02-12 13:00:00	AAPL	Stock	19.1464	19.25	19.1366	19.2107	30656108.0
2014-02-12 14:00:00	AAPL	Stock	19.2111	19.2182	19.1457	19.1539	17388308.0
2014-02-12 15:00:00	AAPL	Stock	19.1554	19.1785	19.0916	19.1379	31664052.0
2014-02-12 16:00:00	AAPL	Stock	19.1393	19.1614	19.1207	19.15	19402348.0
2014-02-12 17:00:00	AAPL	Stock	19.1471	19.1493	19.1396	19.1396	141372.0
2014-02-12 18:00:00	AAPL	Stock	19.1429	19.1468	19.14	19.1443	100296.0
2014-02-12 19:00:00	AAPL	Stock	19.1429	19.1532	19.1429	19.1468	230272.0
2014-02-12 08:00:00	MSFT	Stock	37.17	37.2	37.17	37.19	3060.0
2014-02-12 09:00:00	MSFT	Stock	37.2	37.49	37.2	37.48	2973987.0
2014-02-12 10:00:00	MSFT	Stock	37.49	37.535	37.41	37.46	4237411.0
2014-02-12 11:00:00	MSFT	Stock	37.469	37.54	37.4	37.43	2384599.0
2014-02-12 12:00:00	MSFT	Stock	37.425	37.6	37.41	37.575	2289691.0
2014-02-12 13:00:00	MSFT	Stock	37.575	37.59	37.49	37.555	2040538.0
2014-02-12 14:00:00	MSFT	Stock	37.56	37.58	37.49	37.52	2423897.0
2014-02-12 15:00:00	MSFT	Stock	37.515	37.55	37.42	37.46	6418525.0
2014-02-12 16:00:00	MSFT	Stock	37.47	37.527	37.175	37.45	3388909.0
2014-02-12 17:00:00	MSFT	Stock	37.5	37.5	37.5	37.5	200.0
2014-02-12 18:00:00	MSFT	Stock	37.46	37.46	37.44	37.44	2075.0
2014-02-12 19:00:00	MSFT	Stock	37.45	37.45	37.42	37.42	1953.0
2014-02-12 08:00:00	NVDA	Stock	0.4075	0.4075	0.4075	0.4075	16000.0
2014-02-12 09:00:00	NVDA	Stock	0.4072	0.4148	0.4072	0.4125	88181440.0
2014-02-12 10:00:00	NVDA	Stock	0.4125	0.4135	0.4095	0.4108	92105680.0
2014-02-12 11:00:00	NVDA	Stock	0.4106	0.411	0.4078	0.4085	54710000.0
2014-02-12 12:00:00	NVDA	Stock	0.4085	0.4108	0.4082	0.409	33550920.0
2014-02-12 13:00:00	NVDA	Stock	0.409	0.419	0.4088	0.419	81578360.0
2014-02-12 14:00:00	NVDA	Stock	0.419	0.4192	0.4148	0.4152	82452920.0
2014-02-12 15:00:00	NVDA	Stock	0.4152	0.4238	0.4144	0.4205	270822160.0
2014-02-12 16:00:00	NVDA	Stock	0.4208	0.4462	0.4154	0.43	32747640.0
2014-02-12 17:00:00	NVDA	Stock	0.43	0.4348	0.43	0.4325	3247400.0
2014-02-12 18:00:00	NVDA	Stock	0.4338	0.4358	0.4312	0.435	627400.0
2014-02-12 19:00:00	NVDA	Stock	0.4358	0.4372	0.4345	0.4372	393640.0
2014-02-12 04:00:00	AMZN	Stock	18.0605	18.0605	17.8125	17.8125	9180.0
2014-02-12 05:00:00	AMZN	Stock	17.8125	17.857	17.8	17.8	62500.0
2014-02-12 06:00:00	AMZN	Stock	17.785	17.785	17.7085	17.725	129360.0
2014-02-12 07:00:00	AMZN	Stock	17.75	17.77	17.7215	17.77	146780.0
2014-02-12 08:00:00	AMZN	Stock	17.7735	17.805	17.7485	17.794	589920.0
2014-02-12 09:00:00	AMZN	Stock	17.774	18.0895	17.75	17.785	17122320.0
2014-02-12 10:00:00	AMZN	Stock	17.7815	17.8035	17.3215	17.3291	35861680.0
2014-02-12 11:00:00	AMZN	Stock	17.3185	17.51	17.316	17.4099	18765600.0
2014-02-12 12:00:00	AMZN	Stock	17.4036	17.4975	17.386	17.43	9803260.0
2014-02-12 13:00:00	AMZN	Stock	17.435	17.539	17.4012	17.463	10322060.0

> showing 50 of 47,749 rows — these rows as CSV

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