PREVIEW / stock_1hour / 2011-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-28.parquet
  size:    934 KB
  rows:    44,446
  symbols: 3,547

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-06-28 04:00:00	AAPL	Stock	11.8696	11.8696	11.8696	11.8696	2800.0
2011-06-28 07:00:00	AAPL	Stock	11.8575	11.8643	11.8214	11.8425	414064.0
2011-06-28 08:00:00	AAPL	Stock	11.8643	11.9096	11.8482	11.8986	1125600.0
2011-06-28 09:00:00	AAPL	Stock	11.8986	12.025	11.8586	11.9682	69948704.0
2011-06-28 10:00:00	AAPL	Stock	11.9679	12.0079	11.9607	11.9823	48189848.0
2011-06-28 11:00:00	AAPL	Stock	11.9849	12.0032	11.9725	11.9882	28553140.0
2011-06-28 12:00:00	AAPL	Stock	11.9868	11.9925	11.9489	11.9507	25091192.0
2011-06-28 13:00:00	AAPL	Stock	11.9507	11.9693	11.9286	11.9639	30330804.0
2011-06-28 14:00:00	AAPL	Stock	11.965	11.9879	11.9496	11.9714	23447676.0
2011-06-28 15:00:00	AAPL	Stock	11.9721	11.9829	11.9286	11.9736	50204448.0
2011-06-28 16:00:00	AAPL	Stock	11.9736	11.9957	11.964	11.9857	9712528.0
2011-06-28 17:00:00	AAPL	Stock	11.9857	11.9918	11.9818	11.9886	189532.0
2011-06-28 18:00:00	AAPL	Stock	11.9846	11.9886	11.9736	11.9854	382172.0
2011-06-28 19:00:00	AAPL	Stock	11.9793	11.9793	11.9643	11.9654	340480.0
2011-06-28 07:00:00	MSFT	Stock	25.29	25.29	25.21	25.29	3200.0
2011-06-28 08:00:00	MSFT	Stock	25.28	25.39	25.23	25.37	79223.0
2011-06-28 09:00:00	MSFT	Stock	25.39	25.39	25.16	25.198	8160665.0
2011-06-28 10:00:00	MSFT	Stock	25.2	25.34	25.17	25.32	10408643.0
2011-06-28 11:00:00	MSFT	Stock	25.32	25.47	25.3	25.42	6516516.0
2011-06-28 12:00:00	MSFT	Stock	25.42	25.48	25.4	25.45	5161441.0
2011-06-28 13:00:00	MSFT	Stock	25.46	25.5	25.4	25.48	5313988.0
2011-06-28 14:00:00	MSFT	Stock	25.49	25.56	25.47	25.518	7373989.0
2011-06-28 15:00:00	MSFT	Stock	25.52	25.92	25.45	25.85	24236132.0
2011-06-28 16:00:00	MSFT	Stock	25.85	25.9	25.387	25.77	12687839.0
2011-06-28 17:00:00	MSFT	Stock	25.77	25.83	25.77	25.77	49681.0
2011-06-28 18:00:00	MSFT	Stock	25.78	25.8	25.75	25.75	84377.0
2011-06-28 19:00:00	MSFT	Stock	25.75	25.76	25.74	25.74	4100.0
2011-06-28 06:00:00	NVDA	Stock	0.3853	0.3853	0.3853	0.3853	8000.0
2011-06-28 08:00:00	NVDA	Stock	0.3853	0.3862	0.3853	0.3862	98000.0
2011-06-28 09:00:00	NVDA	Stock	0.387	0.39	0.3833	0.3853	108252400.0
2011-06-28 10:00:00	NVDA	Stock	0.385	0.392	0.3838	0.388	108476280.0
2011-06-28 11:00:00	NVDA	Stock	0.3882	0.3885	0.3845	0.3855	83051720.0
2011-06-28 12:00:00	NVDA	Stock	0.3858	0.3875	0.3838	0.3842	63267520.0
2011-06-28 13:00:00	NVDA	Stock	0.3842	0.385	0.3825	0.3842	61753000.0
2011-06-28 14:00:00	NVDA	Stock	0.3845	0.3875	0.3838	0.3858	97803560.0
2011-06-28 15:00:00	NVDA	Stock	0.3855	0.388	0.385	0.3878	145008200.0
2011-06-28 16:00:00	NVDA	Stock	0.3875	0.3913	0.3861	0.388	10744400.0
2011-06-28 17:00:00	NVDA	Stock	0.3875	0.3875	0.3875	0.3875	4400.0
2011-06-28 18:00:00	NVDA	Stock	0.3878	0.388	0.3878	0.388	160000.0
2011-06-28 19:00:00	NVDA	Stock	0.388	0.3888	0.3878	0.3878	24680.0
2011-06-28 07:00:00	AMZN	Stock	10.001	10.008	10.001	10.0075	12000.0
2011-06-28 08:00:00	AMZN	Stock	10.023	10.1125	10.023	10.105	148700.0
2011-06-28 09:00:00	AMZN	Stock	10.1025	10.118	10.03	10.0625	12977900.0
2011-06-28 10:00:00	AMZN	Stock	10.0634	10.125	10.0438	10.0955	13309860.0
2011-06-28 11:00:00	AMZN	Stock	10.0955	10.11	10.04	10.106	11703860.0
2011-06-28 12:00:00	AMZN	Stock	10.104	10.1185	10.0885	10.1125	4924400.0
2011-06-28 13:00:00	AMZN	Stock	10.109	10.122	10.095	10.117	5531820.0
2011-06-28 14:00:00	AMZN	Stock	10.1174	10.144	10.0875	10.1118	10359800.0
2011-06-28 15:00:00	AMZN	Stock	10.113	10.121	10.064	10.1165	11626360.0
2011-06-28 16:00:00	AMZN	Stock	10.116	10.1205	10.1045	10.119	2006380.0

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

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