PREVIEW / stock_1hour / 2012-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-18.parquet
  size:    927 KB
  rows:    43,652
  symbols: 3,452

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
2012-10-18 05:00:00	AAPL	Stock	23.0	23.0357	23.0	23.0357	5600.0
2012-10-18 06:00:00	AAPL	Stock	23.0479	23.0518	23.0479	23.0518	8400.0
2012-10-18 07:00:00	AAPL	Stock	23.0357	23.0357	22.9321	22.9357	356580.0
2012-10-18 08:00:00	AAPL	Stock	22.9514	22.9929	22.7368	22.8161	4107628.0
2012-10-18 09:00:00	AAPL	Stock	22.8161	22.9307	22.7632	22.85	61249244.0
2012-10-18 10:00:00	AAPL	Stock	22.8518	22.8804	22.7111	22.8168	65611728.0
2012-10-18 11:00:00	AAPL	Stock	22.8179	22.8482	22.7254	22.8418	40167988.0
2012-10-18 12:00:00	AAPL	Stock	22.8446	22.8668	22.5493	22.6054	71869840.0
2012-10-18 13:00:00	AAPL	Stock	22.6025	22.7107	22.5418	22.5807	70401688.0
2012-10-18 14:00:00	AAPL	Stock	22.5804	22.6629	22.5607	22.5943	43823724.0
2012-10-18 15:00:00	AAPL	Stock	22.5893	22.65	22.5	22.5929	93979984.0
2012-10-18 16:00:00	AAPL	Stock	22.595	22.6881	22.5446	22.5536	18076156.0
2012-10-18 17:00:00	AAPL	Stock	22.5554	22.5943	22.5486	22.5711	463820.0
2012-10-18 18:00:00	AAPL	Stock	22.5696	22.58	22.5618	22.5679	130536.0
2012-10-18 19:00:00	AAPL	Stock	22.5714	22.5871	22.555	22.5607	223972.0
2012-10-18 07:00:00	MSFT	Stock	29.64	29.64	29.62	29.63	2544.0
2012-10-18 08:00:00	MSFT	Stock	29.6	29.7	29.57	29.57	31030.0
2012-10-18 09:00:00	MSFT	Stock	29.58	29.7	29.48	29.7	3728593.0
2012-10-18 10:00:00	MSFT	Stock	29.69	29.73	29.42	29.46	5921911.0
2012-10-18 11:00:00	MSFT	Stock	29.46	29.61	29.46	29.585	4064056.0
2012-10-18 12:00:00	MSFT	Stock	29.587	29.7	29.47	29.54	6411229.0
2012-10-18 13:00:00	MSFT	Stock	29.545	29.555	29.26	29.285	5700762.0
2012-10-18 14:00:00	MSFT	Stock	29.28	29.45	29.28	29.4	5642509.0
2012-10-18 15:00:00	MSFT	Stock	29.39	29.56	29.39	29.54	12794991.0
2012-10-18 16:00:00	MSFT	Stock	29.495	29.85	28.24	28.73	9528964.0
2012-10-18 17:00:00	MSFT	Stock	28.73	29.54	28.7	29.08	925897.0
2012-10-18 18:00:00	MSFT	Stock	29.1	29.15	29.0	29.03	119922.0
2012-10-18 19:00:00	MSFT	Stock	29.04	29.11	29.0	29.06	44212.0
2012-10-18 08:00:00	NVDA	Stock	0.3228	0.3228	0.3228	0.3228	39400.0
2012-10-18 09:00:00	NVDA	Stock	0.3258	0.3258	0.3205	0.3219	46639880.0
2012-10-18 10:00:00	NVDA	Stock	0.322	0.3235	0.3203	0.3215	39978440.0
2012-10-18 11:00:00	NVDA	Stock	0.3218	0.3225	0.321	0.322	30423640.0
2012-10-18 12:00:00	NVDA	Stock	0.3221	0.323	0.3208	0.3223	31248600.0
2012-10-18 13:00:00	NVDA	Stock	0.3223	0.3224	0.3205	0.3205	21857560.0
2012-10-18 14:00:00	NVDA	Stock	0.3205	0.3223	0.3201	0.3223	28992920.0
2012-10-18 15:00:00	NVDA	Stock	0.3223	0.3223	0.321	0.3218	47445240.0
2012-10-18 16:00:00	NVDA	Stock	0.3213	0.3218	0.3213	0.3215	1060440.0
2012-10-18 17:00:00	NVDA	Stock	0.3215	0.3218	0.3215	0.3215	154200.0
2012-10-18 19:00:00	NVDA	Stock	0.3213	0.3213	0.3213	0.3213	4000.0
2012-10-18 08:00:00	AMZN	Stock	12.35	12.36	12.3295	12.3435	70860.0
2012-10-18 09:00:00	AMZN	Stock	12.35	12.43	12.345	12.4175	9148880.0
2012-10-18 10:00:00	AMZN	Stock	12.4198	12.4365	12.3305	12.3875	10110500.0
2012-10-18 11:00:00	AMZN	Stock	12.3842	12.54	12.3785	12.5245	11017020.0
2012-10-18 12:00:00	AMZN	Stock	12.5275	12.5455	12.261	12.318	22659000.0
2012-10-18 13:00:00	AMZN	Stock	12.321	12.334	12.135	12.188	20953580.0
2012-10-18 14:00:00	AMZN	Stock	12.1805	12.237	12.1673	12.2175	10068440.0
2012-10-18 15:00:00	AMZN	Stock	12.221	12.2985	12.193	12.2465	17388900.0
2012-10-18 16:00:00	AMZN	Stock	12.243	12.5332	12.22	12.2565	3091380.0
2012-10-18 17:00:00	AMZN	Stock	12.2425	12.2465	12.24	12.24	264180.0
2012-10-18 18:00:00	AMZN	Stock	12.225	12.2675	12.225	12.2675	15000.0

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

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