PREVIEW / stock_1hour / 2012-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-14.parquet
  size:    920 KB
  rows:    43,681
  symbols: 3,485

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-08-14 04:00:00	AAPL	Stock	22.6225	22.6521	22.5893	22.6464	55580.0
2012-08-14 05:00:00	AAPL	Stock	22.6093	22.6482	22.6089	22.6354	89460.0
2012-08-14 06:00:00	AAPL	Stock	22.6261	22.6496	22.6261	22.6339	76440.0
2012-08-14 07:00:00	AAPL	Stock	22.6389	22.6425	22.5786	22.61	563948.0
2012-08-14 08:00:00	AAPL	Stock	22.6071	22.6393	22.5536	22.5964	3048752.0
2012-08-14 09:00:00	AAPL	Stock	22.5946	22.6893	22.5646	22.6571	59595480.0
2012-08-14 10:00:00	AAPL	Stock	22.6589	22.7232	22.6479	22.7179	52160416.0
2012-08-14 11:00:00	AAPL	Stock	22.715	22.8075	22.707	22.7261	51149084.0
2012-08-14 12:00:00	AAPL	Stock	22.7282	22.7679	22.6396	22.6832	43284332.0
2012-08-14 13:00:00	AAPL	Stock	22.6839	22.7086	22.5971	22.6707	35566300.0
2012-08-14 14:00:00	AAPL	Stock	22.67	22.6875	22.6286	22.6793	21729064.0
2012-08-14 15:00:00	AAPL	Stock	22.6804	22.6832	22.5075	22.5582	62323240.0
2012-08-14 16:00:00	AAPL	Stock	22.5604	22.6716	22.5489	22.5643	4814292.0
2012-08-14 17:00:00	AAPL	Stock	22.5611	22.5811	22.5607	22.5811	159236.0
2012-08-14 18:00:00	AAPL	Stock	22.5804	22.5889	22.5768	22.5804	156772.0
2012-08-14 19:00:00	AAPL	Stock	22.5786	22.5893	22.5739	22.5893	234668.0
2012-08-14 06:00:00	MSFT	Stock	30.4	30.4	30.4	30.4	150.0
2012-08-14 07:00:00	MSFT	Stock	30.33	30.33	30.11	30.29	5400.0
2012-08-14 08:00:00	MSFT	Stock	30.28	30.4	30.26	30.4	34482.0
2012-08-14 09:00:00	MSFT	Stock	30.32	30.4	30.14	30.222	4020912.0
2012-08-14 10:00:00	MSFT	Stock	30.23	30.29	30.15	30.261	4529356.0
2012-08-14 11:00:00	MSFT	Stock	30.262	30.28	30.2	30.21	2818985.0
2012-08-14 12:00:00	MSFT	Stock	30.21	30.24	30.1	30.14	4260943.0
2012-08-14 13:00:00	MSFT	Stock	30.145	30.21	30.12	30.15	2635004.0
2012-08-14 14:00:00	MSFT	Stock	30.15	30.16	30.05	30.085	4728929.0
2012-08-14 15:00:00	MSFT	Stock	30.09	30.14	30.01	30.14	9894647.0
2012-08-14 16:00:00	MSFT	Stock	30.14	30.16	30.11	30.13	916910.0
2012-08-14 17:00:00	MSFT	Stock	30.15	30.17	30.13	30.13	1900.0
2012-08-14 18:00:00	MSFT	Stock	30.15	30.15	30.15	30.15	500.0
2012-08-14 19:00:00	MSFT	Stock	30.12	30.12	30.12	30.12	1200.0
2012-08-14 07:00:00	NVDA	Stock	0.3743	0.3743	0.3743	0.3743	6000.0
2012-08-14 08:00:00	NVDA	Stock	0.3728	0.3733	0.3688	0.3713	238000.0
2012-08-14 09:00:00	NVDA	Stock	0.3713	0.3725	0.3674	0.3688	72081920.0
2012-08-14 10:00:00	NVDA	Stock	0.3688	0.3688	0.3658	0.3666	58800880.0
2012-08-14 11:00:00	NVDA	Stock	0.3668	0.3675	0.3655	0.366	45837560.0
2012-08-14 12:00:00	NVDA	Stock	0.366	0.368	0.3659	0.3675	49252680.0
2012-08-14 13:00:00	NVDA	Stock	0.3676	0.3685	0.3668	0.3671	41456000.0
2012-08-14 14:00:00	NVDA	Stock	0.3672	0.3676	0.3658	0.3668	30115560.0
2012-08-14 15:00:00	NVDA	Stock	0.3666	0.3668	0.3632	0.365	77490320.0
2012-08-14 16:00:00	NVDA	Stock	0.3648	0.3671	0.3645	0.3662	11337680.0
2012-08-14 17:00:00	NVDA	Stock	0.3662	0.3688	0.3662	0.3688	506000.0
2012-08-14 18:00:00	NVDA	Stock	0.366	0.3662	0.3648	0.3648	96000.0
2012-08-14 19:00:00	NVDA	Stock	0.364	0.3642	0.364	0.364	103200.0
2012-08-14 08:00:00	AMZN	Stock	11.675	11.6755	11.622	11.622	185120.0
2012-08-14 09:00:00	AMZN	Stock	11.6525	11.836	11.622	11.7175	18674120.0
2012-08-14 10:00:00	AMZN	Stock	11.7225	11.7481	11.64	11.6935	8170900.0
2012-08-14 11:00:00	AMZN	Stock	11.6901	11.7175	11.678	11.698	3757280.0
2012-08-14 12:00:00	AMZN	Stock	11.695	11.714	11.65	11.663	5026140.0
2012-08-14 13:00:00	AMZN	Stock	11.666	11.6945	11.6335	11.6736	4185860.0
2012-08-14 14:00:00	AMZN	Stock	11.6752	11.7125	11.6505	11.7055	4496740.0

> showing 50 of 43,681 rows — these rows as CSV

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