PREVIEW / stock_1hour / 2011-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-11.parquet
  size:    979 KB
  rows:    46,759
  symbols: 3,542

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-08-11 04:00:00	AAPL	Stock	13.2621	13.3021	13.2607	13.3021	68600.0
2011-08-11 05:00:00	AAPL	Stock	13.2539	13.2854	13.1786	13.1786	53900.0
2011-08-11 06:00:00	AAPL	Stock	13.1589	13.2596	13.1139	13.2182	297136.0
2011-08-11 07:00:00	AAPL	Stock	13.2161	13.2282	13.0107	13.0429	3342192.0
2011-08-11 08:00:00	AAPL	Stock	13.0361	13.1436	12.9811	13.1436	8255324.0
2011-08-11 09:00:00	AAPL	Stock	13.1307	13.2811	13.0257	13.1101	110014100.0
2011-08-11 10:00:00	AAPL	Stock	13.1104	13.2857	13.0964	13.2638	128745260.0
2011-08-11 11:00:00	AAPL	Stock	13.2657	13.3032	13.1986	13.2711	81831624.0
2011-08-11 12:00:00	AAPL	Stock	13.275	13.3604	13.2364	13.3486	69829424.0
2011-08-11 13:00:00	AAPL	Stock	13.3493	13.3707	13.2986	13.3562	73610628.0
2011-08-11 14:00:00	AAPL	Stock	13.3571	13.3925	13.3143	13.3816	72092356.0
2011-08-11 15:00:00	AAPL	Stock	13.3796	13.4089	13.2671	13.3457	146008968.0
2011-08-11 16:00:00	AAPL	Stock	13.3232	13.3921	13.2714	13.325	32316676.0
2011-08-11 17:00:00	AAPL	Stock	13.325	13.3357	13.3032	13.3171	464296.0
2011-08-11 18:00:00	AAPL	Stock	13.3171	13.3464	13.2932	13.3036	316596.0
2011-08-11 19:00:00	AAPL	Stock	13.3071	13.3214	13.3036	13.3107	258748.0
2011-08-11 04:00:00	MSFT	Stock	24.7	24.7	24.7	24.7	1000.0
2011-08-11 07:00:00	MSFT	Stock	24.61	24.69	24.21	24.28	17059.0
2011-08-11 08:00:00	MSFT	Stock	24.28	24.5	24.15	24.45	83624.0
2011-08-11 09:00:00	MSFT	Stock	24.45	24.77	24.4	24.55	9675789.0
2011-08-11 10:00:00	MSFT	Stock	24.56	25.15	24.5	24.9	12565851.0
2011-08-11 11:00:00	MSFT	Stock	24.9	25.0	24.68	24.894	10414651.0
2011-08-11 12:00:00	MSFT	Stock	24.9	25.17	24.8	25.127	7001683.0
2011-08-11 13:00:00	MSFT	Stock	25.125	25.14	24.915	25.1	8346472.0
2011-08-11 14:00:00	MSFT	Stock	25.1	25.22	24.945	25.11	7332563.0
2011-08-11 15:00:00	MSFT	Stock	25.11	25.38	24.99	25.11	25001137.0
2011-08-11 16:00:00	MSFT	Stock	25.05	25.36	24.933	25.19	7583184.0
2011-08-11 17:00:00	MSFT	Stock	25.14	25.19	25.12	25.12	49957.0
2011-08-11 18:00:00	MSFT	Stock	25.19	25.19	25.12	25.19	44560.0
2011-08-11 19:00:00	MSFT	Stock	25.19	25.2	25.1	25.18	5763.0
2011-08-11 06:00:00	NVDA	Stock	0.3195	0.3195	0.3195	0.3195	4000.0
2011-08-11 07:00:00	NVDA	Stock	0.3175	0.3183	0.2948	0.2948	92000.0
2011-08-11 08:00:00	NVDA	Stock	0.3143	0.3175	0.311	0.3153	756920.0
2011-08-11 09:00:00	NVDA	Stock	0.3155	0.3225	0.3085	0.3163	80966840.0
2011-08-11 10:00:00	NVDA	Stock	0.3165	0.3273	0.315	0.3233	134312800.0
2011-08-11 11:00:00	NVDA	Stock	0.3235	0.325	0.3205	0.3243	75090440.0
2011-08-11 12:00:00	NVDA	Stock	0.3245	0.33	0.3215	0.3293	71732200.0
2011-08-11 13:00:00	NVDA	Stock	0.3294	0.33	0.327	0.329	86852760.0
2011-08-11 14:00:00	NVDA	Stock	0.3288	0.3348	0.3283	0.332	113701920.0
2011-08-11 15:00:00	NVDA	Stock	0.332	0.3398	0.331	0.3353	280760280.0
2011-08-11 16:00:00	NVDA	Stock	0.335	0.4058	0.335	0.3865	161171840.0
2011-08-11 17:00:00	NVDA	Stock	0.3865	0.394	0.3728	0.3775	38555640.0
2011-08-11 18:00:00	NVDA	Stock	0.3763	0.3785	0.37	0.376	8778680.0
2011-08-11 19:00:00	NVDA	Stock	0.3773	0.38	0.3745	0.375	5343720.0
2011-08-11 04:00:00	AMZN	Stock	9.818	9.9075	9.818	9.9075	8000.0
2011-08-11 05:00:00	AMZN	Stock	9.9105	9.9105	9.873	9.873	6000.0
2011-08-11 06:00:00	AMZN	Stock	9.8115	9.836	9.811	9.811	8000.0
2011-08-11 07:00:00	AMZN	Stock	9.82	9.886	9.7	9.7195	158560.0
2011-08-11 08:00:00	AMZN	Stock	9.7295	9.811	9.7295	9.8065	907340.0
2011-08-11 09:00:00	AMZN	Stock	9.833	9.9025	9.568	9.7245	23870700.0

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

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