PREVIEW / stock_1hour / 2011-09-02

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-02.parquet
  size:    918 KB
  rows:    43,899
  symbols: 3,475

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-02 04:00:00	AAPL	Stock	13.5714	13.5714	13.5621	13.5621	16800.0
2011-09-02 05:00:00	AAPL	Stock	13.5493	13.5493	13.5071	13.5357	21700.0
2011-09-02 06:00:00	AAPL	Stock	13.5179	13.5357	13.5179	13.5357	79800.0
2011-09-02 07:00:00	AAPL	Stock	13.5357	13.5536	13.52	13.5268	267568.0
2011-09-02 08:00:00	AAPL	Stock	13.5354	13.5893	13.4018	13.4279	5760244.0
2011-09-02 09:00:00	AAPL	Stock	13.4243	13.4325	13.3304	13.4261	80348464.0
2011-09-02 10:00:00	AAPL	Stock	13.4218	13.5	13.4157	13.4679	76520668.0
2011-09-02 11:00:00	AAPL	Stock	13.4718	13.4764	13.4146	13.4293	38765300.0
2011-09-02 12:00:00	AAPL	Stock	13.4293	13.4507	13.4018	13.4107	27986728.0
2011-09-02 13:00:00	AAPL	Stock	13.4107	13.4171	13.3571	13.3639	35418488.0
2011-09-02 14:00:00	AAPL	Stock	13.365	13.3689	13.2929	13.3061	63701596.0
2011-09-02 15:00:00	AAPL	Stock	13.3054	13.3768	13.2796	13.3589	89010152.0
2011-09-02 16:00:00	AAPL	Stock	13.3571	13.3953	13.3311	13.3786	19031824.0
2011-09-02 17:00:00	AAPL	Stock	13.3807	13.3846	13.3646	13.3646	229432.0
2011-09-02 18:00:00	AAPL	Stock	13.3632	13.3696	13.3589	13.3646	146216.0
2011-09-02 19:00:00	AAPL	Stock	13.3675	13.3782	13.3646	13.3782	143668.0
2011-09-02 06:00:00	MSFT	Stock	26.06	26.06	26.06	26.06	200.0
2011-09-02 07:00:00	MSFT	Stock	26.0	26.0	26.0	26.0	1688.0
2011-09-02 08:00:00	MSFT	Stock	26.01	26.04	25.78	26.0	74562.0
2011-09-02 09:00:00	MSFT	Stock	26.0	26.0	25.76	25.91	5330341.0
2011-09-02 10:00:00	MSFT	Stock	25.91	25.95	25.76	25.81	7245195.0
2011-09-02 11:00:00	MSFT	Stock	25.815	25.87	25.78	25.829	6177888.0
2011-09-02 12:00:00	MSFT	Stock	25.822	25.94	25.822	25.939	2579890.0
2011-09-02 13:00:00	MSFT	Stock	25.93	25.95	25.84	25.865	2561947.0
2011-09-02 14:00:00	MSFT	Stock	25.87	25.89	25.7	25.74	5894655.0
2011-09-02 15:00:00	MSFT	Stock	25.735	25.95	25.66	25.8	10055497.0
2011-09-02 16:00:00	MSFT	Stock	25.8	25.86	25.775	25.79	2896261.0
2011-09-02 17:00:00	MSFT	Stock	25.78	25.8	25.78	25.8	1080.0
2011-09-02 18:00:00	MSFT	Stock	25.77	25.8	25.76	25.77	9624.0
2011-09-02 19:00:00	MSFT	Stock	25.8	25.8	25.77	25.77	2400.0
2011-09-02 08:00:00	NVDA	Stock	0.33	0.3318	0.3225	0.325	552480.0
2011-09-02 09:00:00	NVDA	Stock	0.325	0.328	0.3223	0.3245	67074640.0
2011-09-02 10:00:00	NVDA	Stock	0.3245	0.3275	0.3233	0.3263	74698720.0
2011-09-02 11:00:00	NVDA	Stock	0.326	0.329	0.3258	0.3273	62072400.0
2011-09-02 12:00:00	NVDA	Stock	0.3273	0.3288	0.3265	0.3268	33472560.0
2011-09-02 13:00:00	NVDA	Stock	0.3268	0.327	0.3243	0.3248	47337680.0
2011-09-02 14:00:00	NVDA	Stock	0.3249	0.3253	0.3218	0.322	56554480.0
2011-09-02 15:00:00	NVDA	Stock	0.322	0.3248	0.3205	0.323	113719120.0
2011-09-02 16:00:00	NVDA	Stock	0.323	0.3249	0.3215	0.3215	1757080.0
2011-09-02 17:00:00	NVDA	Stock	0.332	0.332	0.323	0.3238	112000.0
2011-09-02 18:00:00	NVDA	Stock	0.323	0.323	0.323	0.323	179320.0
2011-09-02 19:00:00	NVDA	Stock	0.3235	0.3235	0.3233	0.3235	424000.0
2011-09-02 04:00:00	AMZN	Stock	10.602	10.602	10.602	10.602	2000.0
2011-09-02 07:00:00	AMZN	Stock	10.55	10.55	10.55	10.55	2000.0
2011-09-02 08:00:00	AMZN	Stock	10.55	10.55	10.429	10.4455	582780.0
2011-09-02 09:00:00	AMZN	Stock	10.4565	10.495	10.3585	10.4385	15109260.0
2011-09-02 10:00:00	AMZN	Stock	10.434	10.525	10.405	10.4555	10890580.0
2011-09-02 11:00:00	AMZN	Stock	10.4515	10.5345	10.4435	10.4754	9232280.0
2011-09-02 12:00:00	AMZN	Stock	10.4759	10.53	10.475	10.5055	4932100.0
2011-09-02 13:00:00	AMZN	Stock	10.503	10.5105	10.4115	10.4325	7612700.0

> showing 50 of 43,899 rows — these rows as CSV

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