PREVIEW / stock_1hour / 2013-12-03

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-03.parquet
  size:    1.0 MB
  rows:    48,358
  symbols: 3,544

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
2013-12-03 04:00:00	AAPL	Stock	19.8211	20.0036	19.8211	19.9332	115612.0
2013-12-03 05:00:00	AAPL	Stock	19.9375	19.9375	19.8489	19.8929	278600.0
2013-12-03 06:00:00	AAPL	Stock	19.9107	19.9286	19.8761	19.925	259672.0
2013-12-03 07:00:00	AAPL	Stock	19.9129	19.9246	19.8532	19.8929	1611736.0
2013-12-03 08:00:00	AAPL	Stock	19.8918	19.925	19.6964	19.8821	3516548.0
2013-12-03 09:00:00	AAPL	Stock	19.8829	20.1229	19.875	20.0068	100699844.0
2013-12-03 10:00:00	AAPL	Stock	20.0057	20.0657	19.9786	20.0439	60888996.0
2013-12-03 11:00:00	AAPL	Stock	20.0441	20.118	19.9493	19.9964	59603628.0
2013-12-03 12:00:00	AAPL	Stock	19.9957	20.0721	19.9875	20.065	30614696.0
2013-12-03 13:00:00	AAPL	Stock	20.0643	20.0686	19.9857	20.0225	29632652.0
2013-12-03 14:00:00	AAPL	Stock	20.025	20.1354	20.0179	20.1221	37073876.0
2013-12-03 15:00:00	AAPL	Stock	20.1221	20.2279	20.0979	20.2279	86099832.0
2013-12-03 16:00:00	AAPL	Stock	20.2271	20.2496	20.0255	20.2421	22708476.0
2013-12-03 17:00:00	AAPL	Stock	20.2464	20.2768	20.2271	20.2675	1632736.0
2013-12-03 18:00:00	AAPL	Stock	20.2607	20.2936	20.2518	20.2893	565740.0
2013-12-03 19:00:00	AAPL	Stock	20.2893	20.31	20.2271	20.2857	759052.0
2013-12-03 04:00:00	MSFT	Stock	38.51	38.51	38.51	38.51	200.0
2013-12-03 05:00:00	MSFT	Stock	38.39	38.39	38.39	38.39	420.0
2013-12-03 06:00:00	MSFT	Stock	38.37	38.41	38.3	38.3	2495.0
2013-12-03 07:00:00	MSFT	Stock	38.3	38.3	38.21	38.21	7574.0
2013-12-03 08:00:00	MSFT	Stock	38.25	38.25	38.13	38.22	193049.0
2013-12-03 09:00:00	MSFT	Stock	38.19	38.49	38.08	38.365	8557223.0
2013-12-03 10:00:00	MSFT	Stock	38.37	38.47	38.245	38.31	9517567.0
2013-12-03 11:00:00	MSFT	Stock	38.31	38.36	38.25	38.29	6031782.0
2013-12-03 12:00:00	MSFT	Stock	38.29	38.33	38.23	38.25	2960935.0
2013-12-03 13:00:00	MSFT	Stock	38.25	38.3	38.23	38.25	5519133.0
2013-12-03 14:00:00	MSFT	Stock	38.25	38.3	38.24	38.26	4085116.0
2013-12-03 15:00:00	MSFT	Stock	38.26	38.33	38.25	38.31	6892973.0
2013-12-03 16:00:00	MSFT	Stock	38.31	38.489	38.27	38.31	6898932.0
2013-12-03 17:00:00	MSFT	Stock	38.288	38.35	38.288	38.29	22379.0
2013-12-03 18:00:00	MSFT	Stock	38.35	38.35	38.33	38.34	1250.0
2013-12-03 19:00:00	MSFT	Stock	38.31	38.38	38.31	38.38	9179.0
2013-12-03 06:00:00	NVDA	Stock	0.3938	0.3938	0.3938	0.3938	8000.0
2013-12-03 08:00:00	NVDA	Stock	0.3938	0.3938	0.3938	0.3938	2232000.0
2013-12-03 09:00:00	NVDA	Stock	0.3938	0.3962	0.391	0.3953	26700080.0
2013-12-03 10:00:00	NVDA	Stock	0.3953	0.3982	0.3945	0.3976	57898000.0
2013-12-03 11:00:00	NVDA	Stock	0.3978	0.3989	0.3945	0.3955	64635320.0
2013-12-03 12:00:00	NVDA	Stock	0.3955	0.3956	0.394	0.3948	17932000.0
2013-12-03 13:00:00	NVDA	Stock	0.3948	0.3949	0.3918	0.3925	37028040.0
2013-12-03 14:00:00	NVDA	Stock	0.3925	0.3935	0.3925	0.3931	16990000.0
2013-12-03 15:00:00	NVDA	Stock	0.3931	0.3938	0.3915	0.3933	35495400.0
2013-12-03 16:00:00	NVDA	Stock	0.3935	0.3939	0.3934	0.3936	6211960.0
2013-12-03 04:00:00	AMZN	Stock	19.625	19.6485	19.625	19.6485	4000.0
2013-12-03 06:00:00	AMZN	Stock	19.5925	19.5925	19.574	19.574	6000.0
2013-12-03 07:00:00	AMZN	Stock	19.541	19.5445	19.4515	19.454	180100.0
2013-12-03 08:00:00	AMZN	Stock	19.487	19.54	19.4605	19.48	330700.0
2013-12-03 09:00:00	AMZN	Stock	19.49	19.615	19.275	19.3565	15358940.0
2013-12-03 10:00:00	AMZN	Stock	19.3618	19.398	19.1995	19.287	14624300.0
2013-12-03 11:00:00	AMZN	Stock	19.2845	19.294	19.158	19.275	12016700.0
2013-12-03 12:00:00	AMZN	Stock	19.283	19.3211	19.2475	19.3028	4390780.0

> showing 50 of 48,358 rows — these rows as CSV

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