PREVIEW / stock_1hour / 2013-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-23.parquet
  size:    1012 KB
  rows:    46,747
  symbols: 3,521

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-09-23 04:00:00	AAPL	Stock	16.7546	16.7893	16.7546	16.7893	5600.0
2013-09-23 05:00:00	AAPL	Stock	16.8357	16.8357	16.7443	16.7639	54348.0
2013-09-23 06:00:00	AAPL	Stock	16.7743	16.7875	16.7404	16.7429	120120.0
2013-09-23 07:00:00	AAPL	Stock	16.7443	16.75	16.5357	16.5893	695240.0
2013-09-23 08:00:00	AAPL	Stock	16.5893	17.7857	16.5361	17.7411	61422340.0
2013-09-23 09:00:00	AAPL	Stock	17.7411	17.8214	17.4111	17.4329	214700360.0
2013-09-23 10:00:00	AAPL	Stock	17.4336	17.4789	17.2357	17.3929	147557144.0
2013-09-23 11:00:00	AAPL	Stock	17.3929	17.4464	17.2807	17.3064	71906604.0
2013-09-23 12:00:00	AAPL	Stock	17.3064	17.3875	17.2361	17.3675	58023896.0
2013-09-23 13:00:00	AAPL	Stock	17.3675	17.4732	17.335	17.47	41038256.0
2013-09-23 14:00:00	AAPL	Stock	17.4693	17.5686	17.4254	17.5636	56821520.0
2013-09-23 15:00:00	AAPL	Stock	17.5636	17.5957	17.4734	17.5304	87904432.0
2013-09-23 16:00:00	AAPL	Stock	17.5325	17.5623	17.3817	17.3817	15456140.0
2013-09-23 17:00:00	AAPL	Stock	17.5361	17.5539	17.5261	17.5468	573748.0
2013-09-23 18:00:00	AAPL	Stock	17.55	17.5821	17.55	17.5804	832132.0
2013-09-23 19:00:00	AAPL	Stock	17.5804	17.6032	17.5804	17.5982	1187144.0
2013-09-23 05:00:00	MSFT	Stock	32.96	32.96	32.96	32.96	150.0
2013-09-23 07:00:00	MSFT	Stock	32.83	32.83	32.72	32.72	6500.0
2013-09-23 08:00:00	MSFT	Stock	32.69	32.84	32.66	32.7	16162.0
2013-09-23 09:00:00	MSFT	Stock	32.72	32.969	32.5	32.73	6833396.0
2013-09-23 10:00:00	MSFT	Stock	32.735	32.921	32.73	32.79	6410550.0
2013-09-23 11:00:00	MSFT	Stock	32.78	32.85	32.72	32.825	4180575.0
2013-09-23 12:00:00	MSFT	Stock	32.82	32.89	32.78	32.79	3071016.0
2013-09-23 13:00:00	MSFT	Stock	32.79	32.835	32.7	32.82	3178001.0
2013-09-23 14:00:00	MSFT	Stock	32.83	32.85	32.72	32.795	3045517.0
2013-09-23 15:00:00	MSFT	Stock	32.797	32.8	32.65	32.73	6968004.0
2013-09-23 16:00:00	MSFT	Stock	32.74	32.811	32.69	32.69	5418952.0
2013-09-23 17:00:00	MSFT	Stock	32.76	32.76	32.69	32.74	1416.0
2013-09-23 09:00:00	NVDA	Stock	0.3945	0.3978	0.3938	0.3962	24881280.0
2013-09-23 10:00:00	NVDA	Stock	0.3962	0.3962	0.3898	0.3898	68243840.0
2013-09-23 11:00:00	NVDA	Stock	0.3898	0.3906	0.3888	0.3893	46683080.0
2013-09-23 12:00:00	NVDA	Stock	0.3893	0.3922	0.3893	0.3918	25532120.0
2013-09-23 13:00:00	NVDA	Stock	0.3919	0.3928	0.3915	0.3928	22020920.0
2013-09-23 14:00:00	NVDA	Stock	0.3929	0.3933	0.3922	0.3925	18294160.0
2013-09-23 15:00:00	NVDA	Stock	0.3926	0.3928	0.3908	0.391	52224640.0
2013-09-23 16:00:00	NVDA	Stock	0.391	0.3933	0.3908	0.391	962680.0
2013-09-23 17:00:00	NVDA	Stock	0.3888	0.3888	0.3888	0.3888	4000.0
2013-09-23 04:00:00	AMZN	Stock	15.8425	15.8425	15.8425	15.8425	2000.0
2013-09-23 07:00:00	AMZN	Stock	15.8525	15.8525	15.8315	15.8315	6000.0
2013-09-23 08:00:00	AMZN	Stock	15.8385	15.8405	15.75	15.75	35600.0
2013-09-23 09:00:00	AMZN	Stock	15.775	15.795	15.6466	15.673	6314560.0
2013-09-23 10:00:00	AMZN	Stock	15.669	15.6905	15.5121	15.5162	8003700.0
2013-09-23 11:00:00	AMZN	Stock	15.5235	15.539	15.4386	15.4705	6714420.0
2013-09-23 12:00:00	AMZN	Stock	15.465	15.6225	15.452	15.617	2678420.0
2013-09-23 13:00:00	AMZN	Stock	15.6165	15.695	15.5605	15.673	2661940.0
2013-09-23 14:00:00	AMZN	Stock	15.6765	15.694	15.573	15.6351	3309180.0
2013-09-23 15:00:00	AMZN	Stock	15.631	15.651	15.567	15.5845	4502060.0
2013-09-23 16:00:00	AMZN	Stock	15.5745	15.6995	15.4957	15.5745	255100.0
2013-09-23 17:00:00	AMZN	Stock	15.551	15.585	15.5355	15.5355	40100.0
2013-09-23 19:00:00	AMZN	Stock	15.5425	15.5425	15.5425	15.5425	4000.0

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

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