PREVIEW / stock_1hour / 2011-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-18.parquet
  size:    934 KB
  rows:    44,485
  symbols: 3,540

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-07-18 04:00:00	AAPL	Stock	13.0571	13.0571	12.9643	12.9893	44800.0
2011-07-18 05:00:00	AAPL	Stock	12.9893	12.9982	12.9893	12.9929	30772.0
2011-07-18 06:00:00	AAPL	Stock	12.9929	13.0089	12.9736	12.9739	111020.0
2011-07-18 07:00:00	AAPL	Stock	13.0	13.0289	12.9843	13.0032	949088.0
2011-07-18 08:00:00	AAPL	Stock	13.0	13.0964	12.9964	13.0625	5896212.0
2011-07-18 09:00:00	AAPL	Stock	13.0625	13.2021	13.0443	13.163	115647364.0
2011-07-18 10:00:00	AAPL	Stock	13.1639	13.2025	13.1111	13.15	91116004.0
2011-07-18 11:00:00	AAPL	Stock	13.151	13.1846	13.1357	13.1407	51452072.0
2011-07-18 12:00:00	AAPL	Stock	13.14	13.1607	13.1375	13.1564	28600012.0
2011-07-18 13:00:00	AAPL	Stock	13.1564	13.2121	13.1486	13.2114	44521596.0
2011-07-18 14:00:00	AAPL	Stock	13.2096	13.2905	13.1921	13.2854	84547008.0
2011-07-18 15:00:00	AAPL	Stock	13.2854	13.3804	13.2679	13.3507	127764924.0
2011-07-18 16:00:00	AAPL	Stock	13.3516	13.3846	13.1746	13.3736	16376612.0
2011-07-18 17:00:00	AAPL	Stock	13.3743	13.3893	13.3732	13.3893	797832.0
2011-07-18 18:00:00	AAPL	Stock	13.385	13.3979	13.35	13.3896	1012284.0
2011-07-18 19:00:00	AAPL	Stock	13.3914	13.3975	13.3839	13.3954	403648.0
2011-07-18 06:00:00	MSFT	Stock	26.62	26.62	26.55	26.55	1000.0
2011-07-18 07:00:00	MSFT	Stock	26.56	26.59	26.55	26.58	3078.0
2011-07-18 08:00:00	MSFT	Stock	26.59	26.67	26.58	26.67	27356.0
2011-07-18 09:00:00	MSFT	Stock	26.67	26.9	26.55	26.57	4697435.0
2011-07-18 10:00:00	MSFT	Stock	26.57	26.6	26.34	26.39	8737505.0
2011-07-18 11:00:00	MSFT	Stock	26.39	26.48	26.26	26.27	5646885.0
2011-07-18 12:00:00	MSFT	Stock	26.27	26.455	26.27	26.4	4028606.0
2011-07-18 13:00:00	MSFT	Stock	26.39	26.46	26.315	26.44	3903163.0
2011-07-18 14:00:00	MSFT	Stock	26.449	26.515	26.4	26.51	4628171.0
2011-07-18 15:00:00	MSFT	Stock	26.51	26.63	26.51	26.59	9383891.0
2011-07-18 16:00:00	MSFT	Stock	26.6	26.717	26.485	26.65	2765848.0
2011-07-18 17:00:00	MSFT	Stock	26.67	26.67	26.64	26.65	5140.0
2011-07-18 18:00:00	MSFT	Stock	26.65	26.66	26.59	26.64	27586.0
2011-07-18 19:00:00	MSFT	Stock	26.61	26.64	26.61	26.62	300.0
2011-07-18 08:00:00	NVDA	Stock	0.35	0.35	0.3478	0.35	31600.0
2011-07-18 09:00:00	NVDA	Stock	0.35	0.3518	0.3433	0.3435	94064560.0
2011-07-18 10:00:00	NVDA	Stock	0.3435	0.3462	0.3405	0.3442	190462240.0
2011-07-18 11:00:00	NVDA	Stock	0.344	0.3455	0.3418	0.3442	94542360.0
2011-07-18 12:00:00	NVDA	Stock	0.3445	0.347	0.3438	0.3448	64684080.0
2011-07-18 13:00:00	NVDA	Stock	0.3445	0.3476	0.344	0.3465	85354200.0
2011-07-18 14:00:00	NVDA	Stock	0.3465	0.348	0.3445	0.348	77273840.0
2011-07-18 15:00:00	NVDA	Stock	0.348	0.3484	0.3445	0.3449	193167960.0
2011-07-18 16:00:00	NVDA	Stock	0.3448	0.3508	0.3442	0.345	9657960.0
2011-07-18 17:00:00	NVDA	Stock	0.345	0.345	0.345	0.345	8000.0
2011-07-18 18:00:00	NVDA	Stock	0.345	0.345	0.345	0.345	52560.0
2011-07-18 19:00:00	NVDA	Stock	0.3458	0.3458	0.3458	0.3458	4000.0
2011-07-18 04:00:00	AMZN	Stock	10.5805	10.6435	10.5805	10.6435	4000.0
2011-07-18 07:00:00	AMZN	Stock	10.5795	10.58	10.579	10.579	6000.0
2011-07-18 08:00:00	AMZN	Stock	10.5755	10.625	10.5755	10.6115	127000.0
2011-07-18 09:00:00	AMZN	Stock	10.6175	10.6695	10.52	10.5305	9909900.0
2011-07-18 10:00:00	AMZN	Stock	10.532	10.5905	10.437	10.4675	13238080.0
2011-07-18 11:00:00	AMZN	Stock	10.4678	10.5165	10.431	10.439	6732800.0
2011-07-18 12:00:00	AMZN	Stock	10.4405	10.4865	10.4145	10.475	5066520.0
2011-07-18 13:00:00	AMZN	Stock	10.4768	10.5365	10.4481	10.5295	4729780.0

> showing 50 of 44,485 rows — these rows as CSV

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