PREVIEW / stock_1hour / 2013-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-07.parquet
  size:    1.0 MB
  rows:    47,006
  symbols: 3,525

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-11-07 05:00:00	AAPL	Stock	18.5386	18.5386	18.5386	18.5386	2800.0
2013-11-07 06:00:00	AAPL	Stock	18.5368	18.5368	18.5271	18.5271	5600.0
2013-11-07 07:00:00	AAPL	Stock	18.5571	18.6393	18.5536	18.6304	374948.0
2013-11-07 08:00:00	AAPL	Stock	18.62	18.6518	18.5536	18.6032	1801380.0
2013-11-07 09:00:00	AAPL	Stock	18.5932	18.6854	18.5396	18.6261	41645548.0
2013-11-07 10:00:00	AAPL	Stock	18.6314	18.6329	18.4768	18.5221	55882876.0
2013-11-07 11:00:00	AAPL	Stock	18.5218	18.5504	18.4671	18.5211	29856176.0
2013-11-07 12:00:00	AAPL	Stock	18.5211	18.5418	18.4761	18.5032	16580060.0
2013-11-07 13:00:00	AAPL	Stock	18.5032	18.5141	18.4321	18.4511	23655632.0
2013-11-07 14:00:00	AAPL	Stock	18.4507	18.4593	18.4068	18.44	25138260.0
2013-11-07 15:00:00	AAPL	Stock	18.44	18.4429	18.2993	18.3036	52417708.0
2013-11-07 16:00:00	AAPL	Stock	18.3039	18.4902	18.3003	18.3107	9289224.0
2013-11-07 17:00:00	AAPL	Stock	18.3107	18.3193	18.3039	18.3143	104776.0
2013-11-07 18:00:00	AAPL	Stock	18.3143	18.3257	18.3043	18.3071	175924.0
2013-11-07 19:00:00	AAPL	Stock	18.3039	18.3193	18.3039	18.3071	218008.0
2013-11-07 05:00:00	MSFT	Stock	38.09	38.21	38.09	38.21	1140.0
2013-11-07 06:00:00	MSFT	Stock	38.23	38.24	38.0	38.0	4300.0
2013-11-07 07:00:00	MSFT	Stock	38.09	38.2	38.0	38.2	11355.0
2013-11-07 08:00:00	MSFT	Stock	38.2	38.2	38.0	38.02	63834.0
2013-11-07 09:00:00	MSFT	Stock	38.04	38.18	37.69	37.78	8227638.0
2013-11-07 10:00:00	MSFT	Stock	37.77	37.935	37.7	37.85	9403735.0
2013-11-07 11:00:00	MSFT	Stock	37.855	37.895	37.615	37.73	6835676.0
2013-11-07 12:00:00	MSFT	Stock	37.73	37.77	37.63	37.7	5627280.0
2013-11-07 13:00:00	MSFT	Stock	37.69	37.78	37.63	37.635	5943496.0
2013-11-07 14:00:00	MSFT	Stock	37.63	37.66	37.43	37.607	8964915.0
2013-11-07 15:00:00	MSFT	Stock	37.605	37.63	37.49	37.52	10627395.0
2013-11-07 16:00:00	MSFT	Stock	37.52	38.101	37.5	37.54	2345486.0
2013-11-07 17:00:00	MSFT	Stock	37.53	37.54	37.53	37.53	2454.0
2013-11-07 18:00:00	MSFT	Stock	37.52	37.58	37.52	37.58	1004.0
2013-11-07 19:00:00	MSFT	Stock	37.52	37.55	37.5	37.5	6735.0
2013-11-07 08:00:00	NVDA	Stock	0.3743	0.3743	0.3738	0.3738	90600.0
2013-11-07 09:00:00	NVDA	Stock	0.373	0.3733	0.3678	0.3689	33973640.0
2013-11-07 10:00:00	NVDA	Stock	0.369	0.37	0.3662	0.3671	74307400.0
2013-11-07 11:00:00	NVDA	Stock	0.3672	0.3678	0.3662	0.3674	51544480.0
2013-11-07 12:00:00	NVDA	Stock	0.3675	0.3678	0.367	0.3675	38162120.0
2013-11-07 13:00:00	NVDA	Stock	0.3675	0.368	0.3651	0.3655	44611400.0
2013-11-07 14:00:00	NVDA	Stock	0.3655	0.3662	0.3645	0.366	76955400.0
2013-11-07 15:00:00	NVDA	Stock	0.3661	0.3675	0.363	0.3636	145731600.0
2013-11-07 16:00:00	NVDA	Stock	0.364	0.379	0.3588	0.375	10657040.0
2013-11-07 17:00:00	NVDA	Stock	0.375	0.375	0.3713	0.3713	890000.0
2013-11-07 18:00:00	NVDA	Stock	0.3713	0.3713	0.3655	0.3655	682000.0
2013-11-07 19:00:00	NVDA	Stock	0.3638	0.3682	0.3638	0.3682	36000.0
2013-11-07 04:00:00	AMZN	Stock	17.77	17.77	17.77	17.77	4000.0
2013-11-07 07:00:00	AMZN	Stock	17.82	17.8365	17.82	17.8365	30000.0
2013-11-07 08:00:00	AMZN	Stock	17.856	17.9	17.8505	17.859	151420.0
2013-11-07 09:00:00	AMZN	Stock	17.857	17.9	17.6122	17.625	8396200.0
2013-11-07 10:00:00	AMZN	Stock	17.6115	17.6245	17.2881	17.4005	21380300.0
2013-11-07 11:00:00	AMZN	Stock	17.4	17.4825	17.2515	17.4825	13656220.0
2013-11-07 12:00:00	AMZN	Stock	17.477	17.5395	17.3805	17.387	6432360.0
2013-11-07 13:00:00	AMZN	Stock	17.3868	17.423	17.284	17.321	4946240.0

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

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