PREVIEW / stock_1hour / 2013-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-26.parquet
  size:    1001 KB
  rows:    46,660
  symbols: 3,529

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-26 05:00:00	AAPL	Stock	17.2343	17.2343	17.2343	17.2343	3976.0
2013-09-26 06:00:00	AAPL	Stock	17.2686	17.2946	17.2686	17.2857	44800.0
2013-09-26 07:00:00	AAPL	Stock	17.3125	17.3571	17.2607	17.3529	1387204.0
2013-09-26 08:00:00	AAPL	Stock	17.3446	17.3536	17.2875	17.3389	2984240.0
2013-09-26 09:00:00	AAPL	Stock	17.3221	17.4107	17.3036	17.3636	50421448.0
2013-09-26 10:00:00	AAPL	Stock	17.3643	17.4486	17.3371	17.3429	54936112.0
2013-09-26 11:00:00	AAPL	Stock	17.3421	17.3518	17.2821	17.3277	25939676.0
2013-09-26 12:00:00	AAPL	Stock	17.3257	17.3489	17.3025	17.3288	15002400.0
2013-09-26 13:00:00	AAPL	Stock	17.3266	17.35	17.2993	17.3157	15549772.0
2013-09-26 14:00:00	AAPL	Stock	17.3139	17.3232	17.2871	17.3096	16237256.0
2013-09-26 15:00:00	AAPL	Stock	17.3096	17.375	17.2871	17.365	36985144.0
2013-09-26 16:00:00	AAPL	Stock	17.365	17.3964	17.3093	17.3786	9295580.0
2013-09-26 17:00:00	AAPL	Stock	17.3804	17.3854	17.365	17.3832	429128.0
2013-09-26 18:00:00	AAPL	Stock	17.3814	17.4046	17.3789	17.3857	396368.0
2013-09-26 19:00:00	AAPL	Stock	17.3836	17.3982	17.3793	17.3893	478128.0
2013-09-26 07:00:00	MSFT	Stock	32.42	32.42	32.42	32.42	200.0
2013-09-26 08:00:00	MSFT	Stock	32.51	32.59	32.49	32.59	182258.0
2013-09-26 09:00:00	MSFT	Stock	32.58	32.94	32.58	32.92	3193527.0
2013-09-26 10:00:00	MSFT	Stock	32.919	33.0	32.76	32.775	5085741.0
2013-09-26 11:00:00	MSFT	Stock	32.772	32.81	32.71	32.74	4618097.0
2013-09-26 12:00:00	MSFT	Stock	32.75	32.97	32.74	32.95	2970272.0
2013-09-26 13:00:00	MSFT	Stock	32.95	32.96	32.83	32.87	1724033.0
2013-09-26 14:00:00	MSFT	Stock	32.875	32.88	32.78	32.813	1754876.0
2013-09-26 15:00:00	MSFT	Stock	32.81	32.86	32.77	32.77	5007456.0
2013-09-26 16:00:00	MSFT	Stock	32.78	32.9	32.76	32.77	2048684.0
2013-09-26 17:00:00	MSFT	Stock	32.77	32.9	32.76	32.9	76911.0
2013-09-26 18:00:00	MSFT	Stock	32.95	33.1	32.94	33.0	14300.0
2013-09-26 19:00:00	MSFT	Stock	33.0	33.04	32.98	33.04	6538.0
2013-09-26 07:00:00	NVDA	Stock	0.3933	0.3933	0.3933	0.3933	4000.0
2013-09-26 09:00:00	NVDA	Stock	0.394	0.3948	0.3928	0.3938	10249360.0
2013-09-26 10:00:00	NVDA	Stock	0.3938	0.3942	0.3913	0.3913	29560320.0
2013-09-26 11:00:00	NVDA	Stock	0.3913	0.3922	0.3895	0.3914	22178960.0
2013-09-26 12:00:00	NVDA	Stock	0.3913	0.3925	0.3913	0.392	14375480.0
2013-09-26 13:00:00	NVDA	Stock	0.392	0.393	0.3918	0.3922	11852520.0
2013-09-26 14:00:00	NVDA	Stock	0.392	0.3922	0.3913	0.3918	22600720.0
2013-09-26 15:00:00	NVDA	Stock	0.3915	0.3925	0.3913	0.3918	30142240.0
2013-09-26 16:00:00	NVDA	Stock	0.3918	0.3928	0.3918	0.3928	7511720.0
2013-09-26 17:00:00	NVDA	Stock	0.3918	0.3918	0.3918	0.3918	144960.0
2013-09-26 04:00:00	AMZN	Stock	15.675	15.675	15.675	15.675	2000.0
2013-09-26 05:00:00	AMZN	Stock	15.6925	15.6995	15.675	15.675	8000.0
2013-09-26 08:00:00	AMZN	Stock	15.697	15.698	15.697	15.698	5600.0
2013-09-26 09:00:00	AMZN	Stock	15.677	15.8845	15.663	15.8715	6183320.0
2013-09-26 10:00:00	AMZN	Stock	15.886	15.9384	15.838	15.92	8858120.0
2013-09-26 11:00:00	AMZN	Stock	15.9205	15.9685	15.8335	15.9394	6303060.0
2013-09-26 12:00:00	AMZN	Stock	15.9365	15.9505	15.9	15.9344	3559480.0
2013-09-26 13:00:00	AMZN	Stock	15.9335	15.9658	15.885	15.9092	2497060.0
2013-09-26 14:00:00	AMZN	Stock	15.9085	15.9225	15.855	15.8745	3147900.0
2013-09-26 15:00:00	AMZN	Stock	15.8685	15.924	15.851	15.9055	6311220.0
2013-09-26 16:00:00	AMZN	Stock	15.9035	15.9292	15.871	15.906	763080.0
2013-09-26 17:00:00	AMZN	Stock	15.909	15.9175	15.906	15.9175	66400.0

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

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