PREVIEW / stock_1hour / 2011-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-06.parquet
  size:    934 KB
  rows:    45,607
  symbols: 3,505

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
2011-09-06 04:00:00	AAPL	Stock	13.2143	13.3025	13.165	13.2296	190260.0
2011-09-06 05:00:00	AAPL	Stock	13.24	13.2514	13.2171	13.25	28000.0
2011-09-06 06:00:00	AAPL	Stock	13.2661	13.2696	13.2554	13.2554	14140.0
2011-09-06 07:00:00	AAPL	Stock	13.2636	13.2636	13.1532	13.1689	567672.0
2011-09-06 08:00:00	AAPL	Stock	13.1561	13.1764	13.0921	13.1218	3108952.0
2011-09-06 09:00:00	AAPL	Stock	13.1211	13.2411	13.0886	13.2004	64352708.0
2011-09-06 10:00:00	AAPL	Stock	13.2096	13.2939	13.1696	13.2918	88349240.0
2011-09-06 11:00:00	AAPL	Stock	13.2932	13.3604	13.2536	13.3064	67716824.0
2011-09-06 12:00:00	AAPL	Stock	13.3046	13.3746	13.2943	13.3168	35027748.0
2011-09-06 13:00:00	AAPL	Stock	13.3175	13.3925	13.3007	13.385	40898228.0
2011-09-06 14:00:00	AAPL	Stock	13.3832	13.4893	13.3812	13.4686	64698480.0
2011-09-06 15:00:00	AAPL	Stock	13.47	13.5832	13.3893	13.5536	90981240.0
2011-09-06 16:00:00	AAPL	Stock	13.5646	13.5818	13.1955	13.5796	44188760.0
2011-09-06 17:00:00	AAPL	Stock	13.5793	13.5804	13.5714	13.5779	271600.0
2011-09-06 18:00:00	AAPL	Stock	13.5732	13.5814	13.5621	13.5789	477904.0
2011-09-06 19:00:00	AAPL	Stock	13.5786	13.5964	13.5714	13.5918	600628.0
2011-09-06 04:00:00	MSFT	Stock	25.51	25.51	25.44	25.44	217.0
2011-09-06 07:00:00	MSFT	Stock	25.53	25.53	25.37	25.41	15986.0
2011-09-06 08:00:00	MSFT	Stock	25.44	25.46	25.18	25.23	57782.0
2011-09-06 09:00:00	MSFT	Stock	25.25	25.41	25.15	25.235	7139794.0
2011-09-06 10:00:00	MSFT	Stock	25.24	25.37	25.11	25.295	9745858.0
2011-09-06 11:00:00	MSFT	Stock	25.3	25.32	25.18	25.27	5775621.0
2011-09-06 12:00:00	MSFT	Stock	25.27	25.35	25.22	25.255	3924046.0
2011-09-06 13:00:00	MSFT	Stock	25.255	25.35	25.22	25.3	3984537.0
2011-09-06 14:00:00	MSFT	Stock	25.305	25.42	25.25	25.28	5221184.0
2011-09-06 15:00:00	MSFT	Stock	25.285	25.59	25.21	25.51	12893568.0
2011-09-06 16:00:00	MSFT	Stock	25.51	25.59	25.129	25.51	6034562.0
2011-09-06 17:00:00	MSFT	Stock	25.56	25.56	25.48	25.48	725.0
2011-09-06 18:00:00	MSFT	Stock	25.48	25.51	25.48	25.51	10700.0
2011-09-06 19:00:00	MSFT	Stock	25.53	25.6	25.52	25.6	2900.0
2011-09-06 08:00:00	NVDA	Stock	0.3215	0.3225	0.312	0.312	321160.0
2011-09-06 09:00:00	NVDA	Stock	0.311	0.3205	0.3095	0.3205	68783560.0
2011-09-06 10:00:00	NVDA	Stock	0.3205	0.3228	0.3168	0.3183	107394680.0
2011-09-06 11:00:00	NVDA	Stock	0.3183	0.3195	0.316	0.3183	69508800.0
2011-09-06 12:00:00	NVDA	Stock	0.3183	0.3193	0.3168	0.3175	36774360.0
2011-09-06 13:00:00	NVDA	Stock	0.3174	0.322	0.317	0.322	54845080.0
2011-09-06 14:00:00	NVDA	Stock	0.3219	0.3273	0.321	0.3258	96034280.0
2011-09-06 15:00:00	NVDA	Stock	0.3258	0.3303	0.3245	0.3295	201977880.0
2011-09-06 16:00:00	NVDA	Stock	0.3295	0.3505	0.3221	0.3505	2529680.0
2011-09-06 17:00:00	NVDA	Stock	0.3505	0.3562	0.344	0.3513	14117880.0
2011-09-06 18:00:00	NVDA	Stock	0.35	0.3545	0.35	0.3513	1175800.0
2011-09-06 19:00:00	NVDA	Stock	0.352	0.352	0.3488	0.3508	1830920.0
2011-09-06 20:00:00	NVDA	Stock	0.3508	0.3508	0.3508	0.3508	32000.0
2011-09-06 04:00:00	AMZN	Stock	10.432	10.432	10.346	10.376	8000.0
2011-09-06 05:00:00	AMZN	Stock	10.33	10.3455	10.321	10.3455	8000.0
2011-09-06 07:00:00	AMZN	Stock	10.34	10.34	10.2775	10.2775	38600.0
2011-09-06 08:00:00	AMZN	Stock	10.2985	10.329	10.2615	10.279	411620.0
2011-09-06 09:00:00	AMZN	Stock	10.2675	10.4046	10.2235	10.3825	12739640.0
2011-09-06 10:00:00	AMZN	Stock	10.387	10.4465	10.35	10.4443	22354240.0
2011-09-06 11:00:00	AMZN	Stock	10.4355	10.5795	10.387	10.544	18578080.0

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

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