PREVIEW / stock_1hour / 2011-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-11.parquet
  size:    956 KB
  rows:    46,294
  symbols: 3,545

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-11 04:00:00	AAPL	Stock	12.7179	12.7411	12.7179	12.7204	31500.0
2011-07-11 05:00:00	AAPL	Stock	12.7161	12.7179	12.6911	12.6929	44800.0
2011-07-11 06:00:00	AAPL	Stock	12.7061	12.7429	12.7061	12.7429	78400.0
2011-07-11 07:00:00	AAPL	Stock	12.7418	12.7739	12.7229	12.7357	867944.0
2011-07-11 08:00:00	AAPL	Stock	12.7396	12.7679	12.7143	12.75	2239300.0
2011-07-11 09:00:00	AAPL	Stock	12.7471	12.8407	12.7182	12.8032	77078624.0
2011-07-11 10:00:00	AAPL	Stock	12.8043	12.8489	12.6611	12.6686	100574544.0
2011-07-11 11:00:00	AAPL	Stock	12.6657	12.725	12.6194	12.71	74425736.0
2011-07-11 12:00:00	AAPL	Stock	12.7118	12.7204	12.6739	12.6871	25592196.0
2011-07-11 13:00:00	AAPL	Stock	12.6861	12.6914	12.6268	12.6692	34518988.0
2011-07-11 14:00:00	AAPL	Stock	12.6689	12.6779	12.6071	12.6361	40929364.0
2011-07-11 15:00:00	AAPL	Stock	12.6334	12.6589	12.6007	12.6464	70170464.0
2011-07-11 16:00:00	AAPL	Stock	12.6443	12.7109	12.6403	12.6457	7518980.0
2011-07-11 17:00:00	AAPL	Stock	12.6518	12.6554	12.6304	12.6346	1173984.0
2011-07-11 18:00:00	AAPL	Stock	12.635	12.6464	12.635	12.6464	223916.0
2011-07-11 19:00:00	AAPL	Stock	12.6429	12.6429	12.6304	12.6411	163968.0
2011-07-11 04:00:00	MSFT	Stock	26.92	26.92	26.72	26.72	258.0
2011-07-11 05:00:00	MSFT	Stock	26.53	26.53	26.53	26.53	100.0
2011-07-11 06:00:00	MSFT	Stock	26.57	26.58	26.57	26.57	3000.0
2011-07-11 07:00:00	MSFT	Stock	26.58	26.62	26.55	26.55	16937.0
2011-07-11 08:00:00	MSFT	Stock	26.53	26.62	26.53	26.6	82757.0
2011-07-11 09:00:00	MSFT	Stock	26.6	26.79	26.57	26.77	5240564.0
2011-07-11 10:00:00	MSFT	Stock	26.76	26.8	26.6	26.6	5885988.0
2011-07-11 11:00:00	MSFT	Stock	26.6	26.71	26.58	26.66	5739212.0
2011-07-11 12:00:00	MSFT	Stock	26.654	26.72	26.61	26.68	3730924.0
2011-07-11 13:00:00	MSFT	Stock	26.68	26.718	26.55	26.62	4459902.0
2011-07-11 14:00:00	MSFT	Stock	26.625	26.64	26.49	26.535	5591035.0
2011-07-11 15:00:00	MSFT	Stock	26.53	26.66	26.49	26.64	9044556.0
2011-07-11 16:00:00	MSFT	Stock	26.63	26.7	26.577	26.66	2495333.0
2011-07-11 17:00:00	MSFT	Stock	26.92	26.92	26.63	26.63	260248.0
2011-07-11 18:00:00	MSFT	Stock	26.63	26.63	26.62	26.62	33438.0
2011-07-11 19:00:00	MSFT	Stock	26.63	26.64	26.63	26.64	442.0
2011-07-11 08:00:00	NVDA	Stock	0.3822	0.3822	0.3775	0.378	883480.0
2011-07-11 09:00:00	NVDA	Stock	0.3795	0.38	0.3753	0.3765	121283120.0
2011-07-11 10:00:00	NVDA	Stock	0.3765	0.378	0.3743	0.3745	145042320.0
2011-07-11 11:00:00	NVDA	Stock	0.3745	0.3748	0.3718	0.3738	100945920.0
2011-07-11 12:00:00	NVDA	Stock	0.3738	0.3751	0.373	0.3733	43447560.0
2011-07-11 13:00:00	NVDA	Stock	0.3734	0.3743	0.3725	0.3738	52989160.0
2011-07-11 14:00:00	NVDA	Stock	0.3735	0.3738	0.3725	0.3731	60658080.0
2011-07-11 15:00:00	NVDA	Stock	0.3733	0.3735	0.3713	0.3725	166302480.0
2011-07-11 16:00:00	NVDA	Stock	0.3725	0.3744	0.3722	0.3731	17436320.0
2011-07-11 17:00:00	NVDA	Stock	0.3723	0.3723	0.3723	0.3723	753320.0
2011-07-11 18:00:00	NVDA	Stock	0.3723	0.3723	0.3723	0.3723	31000.0
2011-07-11 19:00:00	NVDA	Stock	0.3723	0.3723	0.3715	0.3723	94000.0
2011-07-11 04:00:00	AMZN	Stock	10.8255	10.8255	10.8255	10.8255	2000.0
2011-07-11 05:00:00	AMZN	Stock	10.7135	10.7135	10.713	10.713	4000.0
2011-07-11 07:00:00	AMZN	Stock	10.8	10.8	10.768	10.768	24000.0
2011-07-11 08:00:00	AMZN	Stock	10.79	10.8025	10.7695	10.793	178740.0
2011-07-11 09:00:00	AMZN	Stock	10.791	10.875	10.7565	10.761	15530940.0
2011-07-11 10:00:00	AMZN	Stock	10.7672	10.8015	10.6515	10.6522	11176960.0

> showing 50 of 46,294 rows — these rows as CSV

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