PREVIEW / stock_1hour / 2012-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-09.parquet
  size:    950 KB
  rows:    45,140
  symbols: 3,524

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-05-09 04:00:00	AAPL	Stock	20.2179	20.2179	20.2143	20.2143	5600.0
2012-05-09 05:00:00	AAPL	Stock	20.2004	20.2004	20.1968	20.1968	58800.0
2012-05-09 06:00:00	AAPL	Stock	20.1968	20.2143	20.175	20.175	113400.0
2012-05-09 07:00:00	AAPL	Stock	20.2018	20.2082	20.1486	20.1864	741720.0
2012-05-09 08:00:00	AAPL	Stock	20.1864	20.2	20.0821	20.1071	2541000.0
2012-05-09 09:00:00	AAPL	Stock	20.1011	20.2921	20.0504	20.2321	68576956.0
2012-05-09 10:00:00	AAPL	Stock	20.2332	20.2604	20.0304	20.2293	87844624.0
2012-05-09 11:00:00	AAPL	Stock	20.2301	20.4992	20.1961	20.4068	104932380.0
2012-05-09 12:00:00	AAPL	Stock	20.4121	20.4546	20.2906	20.3683	50176168.0
2012-05-09 13:00:00	AAPL	Stock	20.3683	20.4979	20.3125	20.4757	53111240.0
2012-05-09 14:00:00	AAPL	Stock	20.4761	20.4929	20.3571	20.3571	34763260.0
2012-05-09 15:00:00	AAPL	Stock	20.3571	20.4286	20.3054	20.3304	57302952.0
2012-05-09 16:00:00	AAPL	Stock	20.3304	20.4028	20.2166	20.3143	14052752.0
2012-05-09 17:00:00	AAPL	Stock	20.2921	20.3096	20.2193	20.25	1080520.0
2012-05-09 18:00:00	AAPL	Stock	20.2571	20.2836	20.2396	20.275	271068.0
2012-05-09 19:00:00	AAPL	Stock	20.28	20.2857	20.2761	20.2832	163268.0
2012-05-09 06:00:00	MSFT	Stock	30.25	30.25	30.14	30.14	600.0
2012-05-09 07:00:00	MSFT	Stock	30.15	30.25	30.11	30.25	5365.0
2012-05-09 08:00:00	MSFT	Stock	30.25	30.33	30.1	30.15	11117.0
2012-05-09 09:00:00	MSFT	Stock	30.1	30.44	30.1	30.44	4202457.0
2012-05-09 10:00:00	MSFT	Stock	30.44	30.48	30.19	30.39	9105759.0
2012-05-09 11:00:00	MSFT	Stock	30.385	30.71	30.35	30.635	7410620.0
2012-05-09 12:00:00	MSFT	Stock	30.63	30.64	30.53	30.6	3734488.0
2012-05-09 13:00:00	MSFT	Stock	30.61	30.74	30.525	30.645	5596018.0
2012-05-09 14:00:00	MSFT	Stock	30.65	30.78	30.59	30.72	5932915.0
2012-05-09 15:00:00	MSFT	Stock	30.71	30.83	30.67	30.76	10588565.0
2012-05-09 16:00:00	MSFT	Stock	30.77	30.79	30.579	30.73	3052469.0
2012-05-09 17:00:00	MSFT	Stock	30.5	30.72	30.5	30.52	21510.0
2012-05-09 18:00:00	MSFT	Stock	30.53	30.66	30.53	30.55	8912.0
2012-05-09 19:00:00	MSFT	Stock	30.62	30.64	30.57	30.57	3825.0
2012-05-09 06:00:00	NVDA	Stock	0.312	0.312	0.312	0.312	200000.0
2012-05-09 07:00:00	NVDA	Stock	0.31	0.3103	0.31	0.3103	40000.0
2012-05-09 08:00:00	NVDA	Stock	0.3103	0.3103	0.3075	0.3085	350920.0
2012-05-09 09:00:00	NVDA	Stock	0.3083	0.3095	0.3035	0.3058	50691040.0
2012-05-09 10:00:00	NVDA	Stock	0.306	0.3088	0.303	0.3073	85117520.0
2012-05-09 11:00:00	NVDA	Stock	0.3073	0.3118	0.307	0.3098	65626600.0
2012-05-09 12:00:00	NVDA	Stock	0.31	0.3108	0.3083	0.3095	27960240.0
2012-05-09 13:00:00	NVDA	Stock	0.3095	0.3153	0.309	0.3133	110565320.0
2012-05-09 14:00:00	NVDA	Stock	0.3133	0.3138	0.3118	0.312	57090200.0
2012-05-09 15:00:00	NVDA	Stock	0.3118	0.3135	0.3106	0.3128	106062360.0
2012-05-09 16:00:00	NVDA	Stock	0.3128	0.3128	0.3093	0.3125	14629000.0
2012-05-09 17:00:00	NVDA	Stock	0.3115	0.3125	0.3088	0.3088	64000.0
2012-05-09 18:00:00	NVDA	Stock	0.3105	0.312	0.3105	0.312	30280.0
2012-05-09 19:00:00	NVDA	Stock	0.3113	0.312	0.3113	0.312	100000.0
2012-05-09 07:00:00	AMZN	Stock	11.055	11.1	11.055	11.1	10000.0
2012-05-09 08:00:00	AMZN	Stock	11.115	11.175	10.9575	11.059	417380.0
2012-05-09 09:00:00	AMZN	Stock	11.0555	11.225	11.0	11.2135	11892580.0
2012-05-09 10:00:00	AMZN	Stock	11.224	11.224	11.0145	11.1795	15471740.0
2012-05-09 11:00:00	AMZN	Stock	11.175	11.289	11.158	11.2375	16349600.0
2012-05-09 12:00:00	AMZN	Stock	11.2395	11.2475	11.112	11.1615	6289440.0

> showing 50 of 45,140 rows — these rows as CSV

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