PREVIEW / stock_1hour / 2012-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-27.parquet
  size:    947 KB
  rows:    44,631
  symbols: 3,510

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-12-27 04:00:00	AAPL	Stock	18.2504	18.2504	18.1968	18.1968	11200.0
2012-12-27 05:00:00	AAPL	Stock	18.2143	18.2143	18.1982	18.2071	78372.0
2012-12-27 06:00:00	AAPL	Stock	18.2043	18.2179	18.2018	18.2179	8400.0
2012-12-27 07:00:00	AAPL	Stock	18.2146	18.3568	18.2146	18.3393	262612.0
2012-12-27 08:00:00	AAPL	Stock	18.3393	18.4225	18.2464	18.3811	1618092.0
2012-12-27 09:00:00	AAPL	Stock	18.3643	18.3961	18.2321	18.2646	44902816.0
2012-12-27 10:00:00	AAPL	Stock	18.2636	18.265	18.1429	18.1971	72654232.0
2012-12-27 11:00:00	AAPL	Stock	18.1946	18.2507	18.1618	18.1843	38628492.0
2012-12-27 12:00:00	AAPL	Stock	18.185	18.2	18.0571	18.1021	59294144.0
2012-12-27 13:00:00	AAPL	Stock	18.1096	18.1464	18.0596	18.0714	37929052.0
2012-12-27 14:00:00	AAPL	Stock	18.0711	18.2354	18.0236	18.2321	70401100.0
2012-12-27 15:00:00	AAPL	Stock	18.2325	18.4375	18.2	18.3912	112444864.0
2012-12-27 16:00:00	AAPL	Stock	18.3894	18.4007	18.2132	18.3786	7268324.0
2012-12-27 17:00:00	AAPL	Stock	18.3704	18.3793	18.3575	18.3575	257712.0
2012-12-27 18:00:00	AAPL	Stock	18.3689	18.3839	18.3482	18.3679	348040.0
2012-12-27 19:00:00	AAPL	Stock	18.375	18.3921	18.3654	18.3918	333592.0
2012-12-27 04:00:00	MSFT	Stock	27.04	27.04	27.04	27.04	500.0
2012-12-27 07:00:00	MSFT	Stock	26.99	27.01	26.98	27.01	1660.0
2012-12-27 08:00:00	MSFT	Stock	26.96	27.01	26.87	26.94	131911.0
2012-12-27 09:00:00	MSFT	Stock	26.94	26.94	26.8	26.9	2940243.0
2012-12-27 10:00:00	MSFT	Stock	26.9	26.95	26.7	26.8	5384665.0
2012-12-27 11:00:00	MSFT	Stock	26.795	26.83	26.62	26.662	4396817.0
2012-12-27 12:00:00	MSFT	Stock	26.664	26.79	26.57	26.772	5350147.0
2012-12-27 13:00:00	MSFT	Stock	26.78	26.82	26.73	26.794	4571798.0
2012-12-27 14:00:00	MSFT	Stock	26.79	26.99	26.73	26.945	5478876.0
2012-12-27 15:00:00	MSFT	Stock	26.94	27.09	26.9	26.95	9063141.0
2012-12-27 16:00:00	MSFT	Stock	26.96	27.014	26.65	26.98	1500324.0
2012-12-27 17:00:00	MSFT	Stock	26.94	26.94	26.93	26.93	2050.0
2012-12-27 18:00:00	MSFT	Stock	26.94	26.94	26.94	26.94	2280.0
2012-12-27 19:00:00	MSFT	Stock	26.95	26.95	26.94	26.95	16300.0
2012-12-27 09:00:00	NVDA	Stock	0.3058	0.3065	0.3035	0.3058	20642040.0
2012-12-27 10:00:00	NVDA	Stock	0.3058	0.307	0.3032	0.3042	50507920.0
2012-12-27 11:00:00	NVDA	Stock	0.3041	0.3045	0.301	0.301	38205720.0
2012-12-27 12:00:00	NVDA	Stock	0.301	0.3022	0.3005	0.3018	41146040.0
2012-12-27 13:00:00	NVDA	Stock	0.3017	0.3025	0.3008	0.3008	27352840.0
2012-12-27 14:00:00	NVDA	Stock	0.3009	0.3036	0.3008	0.3025	46270800.0
2012-12-27 15:00:00	NVDA	Stock	0.3025	0.3052	0.3022	0.3038	63211640.0
2012-12-27 16:00:00	NVDA	Stock	0.304	0.304	0.3031	0.304	11450040.0
2012-12-27 17:00:00	NVDA	Stock	0.306	0.306	0.306	0.306	40000.0
2012-12-27 18:00:00	NVDA	Stock	0.3025	0.3025	0.3025	0.3025	8000.0
2012-12-27 07:00:00	AMZN	Stock	12.419	12.446	12.4105	12.415	34000.0
2012-12-27 08:00:00	AMZN	Stock	12.4125	12.4375	12.3815	12.3815	211700.0
2012-12-27 09:00:00	AMZN	Stock	12.3825	12.464	12.338	12.46	10036600.0
2012-12-27 10:00:00	AMZN	Stock	12.4565	12.4625	12.2866	12.3725	13346360.0
2012-12-27 11:00:00	AMZN	Stock	12.3755	12.3924	12.255	12.2765	6407920.0
2012-12-27 12:00:00	AMZN	Stock	12.2766	12.284	12.143	12.1855	11114560.0
2012-12-27 13:00:00	AMZN	Stock	12.187	12.2537	12.1805	12.228	6438880.0
2012-12-27 14:00:00	AMZN	Stock	12.228	12.335	12.196	12.335	7439640.0
2012-12-27 15:00:00	AMZN	Stock	12.335	12.4675	12.3055	12.41	15252220.0
2012-12-27 16:00:00	AMZN	Stock	12.4111	12.4165	12.3309	12.404	1770480.0

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

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