PREVIEW / stock_1hour / 2010-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-07.parquet
  size:    932 KB
  rows:    45,422
  symbols: 3,492

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
2010-10-07 07:00:00	AAPL	Stock	10.3675	10.3714	10.3446	10.3464	226632.0
2010-10-07 08:00:00	AAPL	Stock	10.3432	10.3929	10.2721	10.3825	5399968.0
2010-10-07 09:00:00	AAPL	Stock	10.3821	10.3893	10.2468	10.2711	79836764.0
2010-10-07 10:00:00	AAPL	Stock	10.2686	10.3532	10.2589	10.3143	79347156.0
2010-10-07 11:00:00	AAPL	Stock	10.3143	10.3393	10.2868	10.3104	42525560.0
2010-10-07 12:00:00	AAPL	Stock	10.3104	10.3275	10.2732	10.3007	36979320.0
2010-10-07 13:00:00	AAPL	Stock	10.3032	10.3511	10.2907	10.3393	31345524.0
2010-10-07 14:00:00	AAPL	Stock	10.3407	10.3571	10.325	10.3479	53064004.0
2010-10-07 15:00:00	AAPL	Stock	10.3482	10.3686	10.3232	10.325	70461580.0
2010-10-07 16:00:00	AAPL	Stock	10.3293	10.364	10.3216	10.3386	7606032.0
2010-10-07 17:00:00	AAPL	Stock	10.3375	10.3407	10.3357	10.3357	287028.0
2010-10-07 18:00:00	AAPL	Stock	10.3329	10.3361	10.3293	10.3339	569016.0
2010-10-07 19:00:00	AAPL	Stock	10.3343	10.3371	10.3321	10.3364	246176.0
2010-10-07 07:00:00	MSFT	Stock	24.5	24.6	24.5	24.6	1000.0
2010-10-07 08:00:00	MSFT	Stock	24.5	24.6	24.44	24.6	60438.0
2010-10-07 09:00:00	MSFT	Stock	24.58	24.67	24.28	24.48	5032125.0
2010-10-07 10:00:00	MSFT	Stock	24.48	24.75	24.44	24.68	11270325.0
2010-10-07 11:00:00	MSFT	Stock	24.68	24.7	24.51	24.515	6532804.0
2010-10-07 12:00:00	MSFT	Stock	24.52	24.53	24.39	24.47	5207019.0
2010-10-07 13:00:00	MSFT	Stock	24.465	24.58	24.45	24.55	3414093.0
2010-10-07 14:00:00	MSFT	Stock	24.555	24.58	24.48	24.575	3510731.0
2010-10-07 15:00:00	MSFT	Stock	24.575	24.58	24.45	24.53	12816426.0
2010-10-07 16:00:00	MSFT	Stock	24.52	24.6	24.43	24.54	1203040.0
2010-10-07 17:00:00	MSFT	Stock	24.57	24.58	24.53	24.53	29426.0
2010-10-07 18:00:00	MSFT	Stock	24.53	24.53	24.53	24.53	44493.0
2010-10-07 19:00:00	MSFT	Stock	24.56	24.56	24.53	24.53	1559.0
2010-10-07 06:00:00	NVDA	Stock	0.2638	0.2638	0.2638	0.2638	12000.0
2010-10-07 08:00:00	NVDA	Stock	0.2678	0.2712	0.2675	0.2712	228400.0
2010-10-07 09:00:00	NVDA	Stock	0.2725	0.2725	0.2595	0.2619	201901440.0
2010-10-07 10:00:00	NVDA	Stock	0.2618	0.2698	0.2615	0.2692	139501800.0
2010-10-07 11:00:00	NVDA	Stock	0.2691	0.27	0.2672	0.268	124780160.0
2010-10-07 12:00:00	NVDA	Stock	0.2681	0.2688	0.2652	0.2672	55861560.0
2010-10-07 13:00:00	NVDA	Stock	0.267	0.2695	0.2668	0.269	63717040.0
2010-10-07 14:00:00	NVDA	Stock	0.2692	0.2692	0.267	0.2683	60033000.0
2010-10-07 15:00:00	NVDA	Stock	0.2683	0.2685	0.267	0.2675	106285120.0
2010-10-07 16:00:00	NVDA	Stock	0.2675	0.2695	0.2666	0.2675	7396640.0
2010-10-07 17:00:00	NVDA	Stock	0.2675	0.2675	0.2675	0.2675	8000.0
2010-10-07 18:00:00	NVDA	Stock	0.2675	0.2675	0.2675	0.2675	40000.0
2010-10-07 19:00:00	NVDA	Stock	0.2672	0.2672	0.266	0.2663	310000.0
2010-10-07 07:00:00	AMZN	Stock	7.785	7.788	7.783	7.788	28000.0
2010-10-07 08:00:00	AMZN	Stock	7.7625	7.85	7.7625	7.845	304640.0
2010-10-07 09:00:00	AMZN	Stock	7.845	7.87	7.679	7.6875	22554900.0
2010-10-07 10:00:00	AMZN	Stock	7.6874	7.825	7.6695	7.787	22433240.0
2010-10-07 11:00:00	AMZN	Stock	7.7845	7.812	7.756	7.7875	10040860.0
2010-10-07 12:00:00	AMZN	Stock	7.7885	7.7965	7.7135	7.744	7075100.0
2010-10-07 13:00:00	AMZN	Stock	7.7435	7.8095	7.736	7.7995	6070020.0
2010-10-07 14:00:00	AMZN	Stock	7.801	7.81	7.767	7.7865	8269020.0
2010-10-07 15:00:00	AMZN	Stock	7.787	7.82	7.775	7.8155	13038580.0
2010-10-07 16:00:00	AMZN	Stock	7.8135	7.8385	7.77	7.8385	833720.0
2010-10-07 17:00:00	AMZN	Stock	7.8155	7.8175	7.814	7.814	30200.0

> showing 50 of 45,422 rows — these rows as CSV

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