PREVIEW / stock_1hour / 2009-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-31.parquet
  size:    894 KB
  rows:    43,883
  symbols: 3,355

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
2009-07-31 07:00:00	AAPL	Stock	5.8393	5.8425	5.8286	5.8425	66724.0
2009-07-31 08:00:00	AAPL	Stock	5.8218	5.8479	5.7857	5.7914	2260328.0
2009-07-31 09:00:00	AAPL	Stock	5.7929	5.8696	5.79	5.8568	76783056.0
2009-07-31 10:00:00	AAPL	Stock	5.8564	5.8929	5.8339	5.8775	85807988.0
2009-07-31 11:00:00	AAPL	Stock	5.8773	5.8886	5.8664	5.8829	32578504.0
2009-07-31 12:00:00	AAPL	Stock	5.8832	5.8857	5.8536	5.8671	40689348.0
2009-07-31 13:00:00	AAPL	Stock	5.8671	5.8736	5.8525	5.8686	29821428.0
2009-07-31 14:00:00	AAPL	Stock	5.8686	5.8832	5.8457	5.8518	47757164.0
2009-07-31 15:00:00	AAPL	Stock	5.8511	5.8857	5.8311	5.8421	86487016.0
2009-07-31 16:00:00	AAPL	Stock	5.8368	5.862	5.8286	5.8357	18954236.0
2009-07-31 17:00:00	AAPL	Stock	5.8357	5.8411	5.8339	5.8375	98280.0
2009-07-31 18:00:00	AAPL	Stock	5.8411	5.8411	5.8354	5.8354	14896.0
2009-07-31 19:00:00	AAPL	Stock	5.8354	5.8393	5.8339	5.8339	140280.0
2009-07-31 07:00:00	MSFT	Stock	23.72	23.78	23.7	23.74	6550.0
2009-07-31 08:00:00	MSFT	Stock	23.71	23.85	23.65	23.69	80742.0
2009-07-31 09:00:00	MSFT	Stock	23.69	24.07	23.68	23.92	6778484.0
2009-07-31 10:00:00	MSFT	Stock	23.92	23.98	23.69	23.958	9051090.0
2009-07-31 11:00:00	MSFT	Stock	23.96	23.97	23.8	23.843	5270642.0
2009-07-31 12:00:00	MSFT	Stock	23.85	23.87	23.73	23.75	3918810.0
2009-07-31 13:00:00	MSFT	Stock	23.75	23.87	23.73	23.82	2409625.0
2009-07-31 14:00:00	MSFT	Stock	23.82	23.88	23.59	23.6	6434986.0
2009-07-31 15:00:00	MSFT	Stock	23.615	23.68	23.5	23.55	13696837.0
2009-07-31 16:00:00	MSFT	Stock	23.54	23.829	23.51	23.55	5045768.0
2009-07-31 17:00:00	MSFT	Stock	23.56	23.57	23.52	23.52	606.0
2009-07-31 18:00:00	MSFT	Stock	23.52	23.52	23.52	23.52	1700.0
2009-07-31 19:00:00	MSFT	Stock	23.57	23.58	23.52	23.58	5900.0
2009-07-31 08:00:00	NVDA	Stock	0.3225	0.3225	0.3225	0.3225	20000.0
2009-07-31 09:00:00	NVDA	Stock	0.322	0.3235	0.3157	0.3165	131921720.0
2009-07-31 10:00:00	NVDA	Stock	0.3163	0.3243	0.3145	0.3243	86087160.0
2009-07-31 11:00:00	NVDA	Stock	0.3242	0.3265	0.323	0.3249	71210640.0
2009-07-31 12:00:00	NVDA	Stock	0.325	0.3255	0.323	0.325	47477320.0
2009-07-31 13:00:00	NVDA	Stock	0.3253	0.3275	0.3248	0.327	39983040.0
2009-07-31 14:00:00	NVDA	Stock	0.327	0.3278	0.3233	0.3238	59046880.0
2009-07-31 15:00:00	NVDA	Stock	0.324	0.3265	0.3223	0.3233	75435000.0
2009-07-31 16:00:00	NVDA	Stock	0.3233	0.3234	0.3225	0.3233	18861800.0
2009-07-31 17:00:00	NVDA	Stock	0.3233	0.3233	0.3233	0.3233	16000.0
2009-07-31 18:00:00	NVDA	Stock	0.3228	0.3228	0.3228	0.3228	4000.0
2009-07-31 19:00:00	NVDA	Stock	0.3225	0.3225	0.3225	0.3225	8000.0
2009-07-31 20:00:00	NVDA	Stock	0.322	0.322	0.322	0.322	8000.0
2009-07-31 05:00:00	AMZN	Stock	4.32	4.32	4.32	4.32	2000.0
2009-07-31 07:00:00	AMZN	Stock	4.316	4.32	4.316	4.32	28000.0
2009-07-31 08:00:00	AMZN	Stock	4.3165	4.325	4.289	4.29	129520.0
2009-07-31 09:00:00	AMZN	Stock	4.289	4.3035	4.263	4.2655	14568540.0
2009-07-31 10:00:00	AMZN	Stock	4.264	4.2935	4.231	4.285	21401380.0
2009-07-31 11:00:00	AMZN	Stock	4.285	4.3175	4.2745	4.3126	13558940.0
2009-07-31 12:00:00	AMZN	Stock	4.313	4.325	4.3035	4.3185	11101400.0
2009-07-31 13:00:00	AMZN	Stock	4.3185	4.3375	4.3158	4.321	10405120.0
2009-07-31 14:00:00	AMZN	Stock	4.3215	4.3375	4.3025	4.3117	12414720.0
2009-07-31 15:00:00	AMZN	Stock	4.3115	4.3375	4.286	4.29	27813520.0
2009-07-31 16:00:00	AMZN	Stock	4.289	4.289	4.2825	4.288	755940.0

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

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