PREVIEW / stock_1hour / 2013-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-13.parquet
  size:    960 KB
  rows:    44,737
  symbols: 3,465

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-03-13 05:00:00	AAPL	Stock	15.2786	15.2786	15.2786	15.2786	22204.0
2013-03-13 06:00:00	AAPL	Stock	15.2679	15.2679	15.2321	15.2321	15400.0
2013-03-13 07:00:00	AAPL	Stock	15.2679	15.2679	15.2357	15.2539	187124.0
2013-03-13 08:00:00	AAPL	Stock	15.2411	15.2946	15.2321	15.2707	2059568.0
2013-03-13 09:00:00	AAPL	Stock	15.27	15.3125	15.1914	15.2673	52859044.0
2013-03-13 10:00:00	AAPL	Stock	15.2674	15.4357	15.215	15.4171	89459048.0
2013-03-13 11:00:00	AAPL	Stock	15.4179	15.4629	15.3614	15.375	44838696.0
2013-03-13 12:00:00	AAPL	Stock	15.375	15.455	15.3632	15.4321	28882420.0
2013-03-13 13:00:00	AAPL	Stock	15.4343	15.5179	15.4011	15.475	35589428.0
2013-03-13 14:00:00	AAPL	Stock	15.4743	15.4821	15.3332	15.3564	36933960.0
2013-03-13 15:00:00	AAPL	Stock	15.3564	15.3686	15.2807	15.2961	61060552.0
2013-03-13 16:00:00	AAPL	Stock	15.2982	15.4679	15.2929	15.2968	25333784.0
2013-03-13 17:00:00	AAPL	Stock	15.2964	15.3157	15.2857	15.305	600796.0
2013-03-13 18:00:00	AAPL	Stock	15.3011	15.305	15.2946	15.305	133000.0
2013-03-13 19:00:00	AAPL	Stock	15.2996	15.3161	15.2982	15.3032	207564.0
2013-03-13 07:00:00	MSFT	Stock	27.73	27.73	27.73	27.73	100.0
2013-03-13 08:00:00	MSFT	Stock	27.88	27.92	27.88	27.92	1100.0
2013-03-13 09:00:00	MSFT	Stock	27.91	27.91	27.75	27.86	4003903.0
2013-03-13 10:00:00	MSFT	Stock	27.85	27.94	27.76	27.94	2991187.0
2013-03-13 11:00:00	MSFT	Stock	27.94	27.97	27.82	27.84	3064117.0
2013-03-13 12:00:00	MSFT	Stock	27.85	27.97	27.83	27.92	2968105.0
2013-03-13 13:00:00	MSFT	Stock	27.93	27.99	27.9	27.99	2441578.0
2013-03-13 14:00:00	MSFT	Stock	27.98	28.02	27.95	27.98	4082617.0
2013-03-13 15:00:00	MSFT	Stock	27.97	28.0	27.91	27.92	7203143.0
2013-03-13 16:00:00	MSFT	Stock	27.91	27.97	27.89	27.92	488439.0
2013-03-13 17:00:00	MSFT	Stock	27.92	27.92	27.92	27.92	56116.0
2013-03-13 18:00:00	MSFT	Stock	27.91	27.92	27.91	27.92	7049.0
2013-03-13 19:00:00	MSFT	Stock	27.91	27.91	27.9	27.91	2863.0
2013-03-13 08:00:00	NVDA	Stock	0.316	0.316	0.316	0.316	4000.0
2013-03-13 09:00:00	NVDA	Stock	0.319	0.3193	0.3155	0.3168	41218480.0
2013-03-13 10:00:00	NVDA	Stock	0.3168	0.3218	0.316	0.3218	69922320.0
2013-03-13 11:00:00	NVDA	Stock	0.3216	0.3239	0.3208	0.3219	70682320.0
2013-03-13 12:00:00	NVDA	Stock	0.322	0.323	0.3218	0.3225	30035760.0
2013-03-13 13:00:00	NVDA	Stock	0.3225	0.323	0.3223	0.3223	30260360.0
2013-03-13 14:00:00	NVDA	Stock	0.3223	0.323	0.3188	0.3189	79447800.0
2013-03-13 15:00:00	NVDA	Stock	0.319	0.3198	0.318	0.3185	120770040.0
2013-03-13 16:00:00	NVDA	Stock	0.3185	0.3206	0.3178	0.3185	9745960.0
2013-03-13 18:00:00	NVDA	Stock	0.318	0.318	0.318	0.318	4000.0
2013-03-13 06:00:00	AMZN	Stock	13.7595	13.7595	13.7595	13.7595	2000.0
2013-03-13 08:00:00	AMZN	Stock	13.675	13.675	13.675	13.675	2000.0
2013-03-13 09:00:00	AMZN	Stock	13.6895	13.825	13.655	13.6905	5237240.0
2013-03-13 10:00:00	AMZN	Stock	13.6945	13.7355	13.632	13.683	6397000.0
2013-03-13 11:00:00	AMZN	Stock	13.69	13.746	13.6375	13.6425	3638820.0
2013-03-13 12:00:00	AMZN	Stock	13.6455	13.7025	13.643	13.679	3301680.0
2013-03-13 13:00:00	AMZN	Stock	13.6845	13.735	13.654	13.731	4514120.0
2013-03-13 14:00:00	AMZN	Stock	13.7325	13.7525	13.7015	13.712	3203160.0
2013-03-13 15:00:00	AMZN	Stock	13.7125	13.7605	13.6825	13.7545	9166840.0
2013-03-13 16:00:00	AMZN	Stock	13.755	13.7625	13.695	13.755	2044200.0
2013-03-13 17:00:00	AMZN	Stock	13.75	13.75	13.75	13.75	2000.0
2013-03-13 19:00:00	AMZN	Stock	13.7475	13.7475	13.7475	13.7475	2000.0

> showing 50 of 44,737 rows — these rows as CSV

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