PREVIEW / stock_1hour / 2014-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-04.parquet
  size:    1.0 MB
  rows:    49,219
  symbols: 3,535

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
2014-11-04 04:00:00	AAPL	Stock	27.4225	27.48	27.4225	27.4375	47428.0
2014-11-04 05:00:00	AAPL	Stock	27.4375	27.4375	27.325	27.3375	125536.0
2014-11-04 06:00:00	AAPL	Stock	27.3375	27.3775	27.33	27.375	15324.0
2014-11-04 07:00:00	AAPL	Stock	27.375	27.3775	27.3125	27.3125	117356.0
2014-11-04 08:00:00	AAPL	Stock	27.3175	27.375	27.25	27.345	474636.0
2014-11-04 09:00:00	AAPL	Stock	27.345	27.3775	27.1725	27.2675	26999292.0
2014-11-04 10:00:00	AAPL	Stock	27.27	27.2925	27.0325	27.0475	27712752.0
2014-11-04 11:00:00	AAPL	Stock	27.05	27.115	26.93	27.0128	27847308.0
2014-11-04 12:00:00	AAPL	Stock	27.015	27.225	27.0125	27.1625	14182828.0
2014-11-04 13:00:00	AAPL	Stock	27.1638	27.235	27.1325	27.23	11312136.0
2014-11-04 14:00:00	AAPL	Stock	27.23	27.24	27.175	27.2312	10966404.0
2014-11-04 15:00:00	AAPL	Stock	27.2322	27.2375	27.1475	27.15	16971444.0
2014-11-04 16:00:00	AAPL	Stock	27.15	27.21	27.105	27.125	11670972.0
2014-11-04 17:00:00	AAPL	Stock	27.1175	27.1982	27.1	27.1125	389096.0
2014-11-04 18:00:00	AAPL	Stock	27.1	27.15	27.0975	27.1	142400.0
2014-11-04 19:00:00	AAPL	Stock	27.1	27.16	27.1	27.1525	153364.0
2014-11-04 05:00:00	MSFT	Stock	47.42	47.42	47.42	47.42	900.0
2014-11-04 07:00:00	MSFT	Stock	47.42	47.43	47.42	47.43	4000.0
2014-11-04 08:00:00	MSFT	Stock	47.3	47.4	47.27	47.27	9697.0
2014-11-04 09:00:00	MSFT	Stock	47.3	47.66	47.26	47.6	3007992.0
2014-11-04 10:00:00	MSFT	Stock	47.62	47.73	47.39	47.41	3700383.0
2014-11-04 11:00:00	MSFT	Stock	47.41	47.45	47.25	47.345	2793927.0
2014-11-04 12:00:00	MSFT	Stock	47.349	47.64	47.34	47.556	1514462.0
2014-11-04 13:00:00	MSFT	Stock	47.551	47.65	47.46	47.63	1380986.0
2014-11-04 14:00:00	MSFT	Stock	47.635	47.68	47.5	47.61	2249934.0
2014-11-04 15:00:00	MSFT	Stock	47.61	47.645	47.51	47.55	3722427.0
2014-11-04 16:00:00	MSFT	Stock	47.57	47.64	47.339	47.51	1574328.0
2014-11-04 17:00:00	MSFT	Stock	47.57	47.596	47.51	47.57	27450.0
2014-11-04 18:00:00	MSFT	Stock	47.51	47.57	47.51	47.57	221700.0
2014-11-04 19:00:00	MSFT	Stock	47.58	47.58	47.58	47.58	700.0
2014-11-04 08:00:00	NVDA	Stock	0.503	0.503	0.4958	0.4958	115040.0
2014-11-04 09:00:00	NVDA	Stock	0.5	0.5	0.4938	0.4972	18262680.0
2014-11-04 10:00:00	NVDA	Stock	0.497	0.498	0.492	0.4923	28523360.0
2014-11-04 11:00:00	NVDA	Stock	0.4923	0.4972	0.4918	0.4968	38857680.0
2014-11-04 12:00:00	NVDA	Stock	0.4968	0.502	0.4968	0.5018	42320400.0
2014-11-04 13:00:00	NVDA	Stock	0.502	0.5038	0.5005	0.5032	33543280.0
2014-11-04 14:00:00	NVDA	Stock	0.5032	0.5043	0.5025	0.504	32692400.0
2014-11-04 15:00:00	NVDA	Stock	0.504	0.505	0.5032	0.5035	114209960.0
2014-11-04 16:00:00	NVDA	Stock	0.5035	0.5045	0.5032	0.5032	29317200.0
2014-11-04 17:00:00	NVDA	Stock	0.4944	0.4992	0.4944	0.4956	953600.0
2014-11-04 04:00:00	AMZN	Stock	15.263	15.2905	15.263	15.2905	12000.0
2014-11-04 05:00:00	AMZN	Stock	15.2415	15.2415	15.2415	15.2415	2000.0
2014-11-04 06:00:00	AMZN	Stock	15.251	15.251	15.251	15.251	6200.0
2014-11-04 07:00:00	AMZN	Stock	15.22	15.2225	15.22	15.22	6000.0
2014-11-04 08:00:00	AMZN	Stock	15.22	15.22	15.1895	15.1915	167560.0
2014-11-04 09:00:00	AMZN	Stock	15.1995	15.2125	15.119	15.126	9614320.0
2014-11-04 10:00:00	AMZN	Stock	15.126	15.1355	15.009	15.01	13198840.0
2014-11-04 11:00:00	AMZN	Stock	15.0125	15.08	15.0085	15.0355	6559080.0
2014-11-04 12:00:00	AMZN	Stock	15.0325	15.1085	15.021	15.0875	6989200.0
2014-11-04 13:00:00	AMZN	Stock	15.091	15.0945	15.0645	15.077	5486260.0

> showing 50 of 49,219 rows — these rows as CSV

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