PREVIEW / stock_1hour / 2013-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-04.parquet
  size:    1.1 MB
  rows:    51,253
  symbols: 3,531

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-11-04 04:00:00	AAPL	Stock	18.5771	18.6196	18.575	18.6196	37492.0
2013-11-04 05:00:00	AAPL	Stock	18.6214	18.6589	18.6196	18.6589	17920.0
2013-11-04 06:00:00	AAPL	Stock	18.6518	18.6518	18.6518	18.6518	8400.0
2013-11-04 07:00:00	AAPL	Stock	18.6196	18.6425	18.5961	18.6214	289940.0
2013-11-04 08:00:00	AAPL	Stock	18.6386	18.6425	18.5721	18.6214	1591240.0
2013-11-04 09:00:00	AAPL	Stock	18.6161	18.6746	18.5289	18.5889	41563144.0
2013-11-04 10:00:00	AAPL	Stock	18.59	18.7536	18.5804	18.6993	46910080.0
2013-11-04 11:00:00	AAPL	Stock	18.7004	18.7046	18.6479	18.6968	21281820.0
2013-11-04 12:00:00	AAPL	Stock	18.6943	18.6986	18.6471	18.6482	10853192.0
2013-11-04 13:00:00	AAPL	Stock	18.65	18.665	18.5932	18.6493	17807160.0
2013-11-04 14:00:00	AAPL	Stock	18.6493	18.7589	18.6486	18.7289	25803064.0
2013-11-04 15:00:00	AAPL	Stock	18.7314	18.815	18.6971	18.8107	49490784.0
2013-11-04 16:00:00	AAPL	Stock	18.8125	18.8275	18.6579	18.8	5607560.0
2013-11-04 17:00:00	AAPL	Stock	18.8054	18.8157	18.8029	18.8154	180180.0
2013-11-04 18:00:00	AAPL	Stock	18.815	18.8154	18.8018	18.8036	315672.0
2013-11-04 19:00:00	AAPL	Stock	18.8036	18.8118	18.7946	18.8118	217056.0
2013-11-04 04:00:00	MSFT	Stock	35.75	35.75	35.75	35.75	100.0
2013-11-04 05:00:00	MSFT	Stock	35.7	35.7	35.68	35.69	1114.0
2013-11-04 08:00:00	MSFT	Stock	35.61	35.69	35.59	35.64	4025.0
2013-11-04 09:00:00	MSFT	Stock	35.66	35.75	35.55	35.73	3048297.0
2013-11-04 10:00:00	MSFT	Stock	35.73	35.98	35.68	35.78	5019141.0
2013-11-04 11:00:00	MSFT	Stock	35.77	35.8	35.68	35.74	2472679.0
2013-11-04 12:00:00	MSFT	Stock	35.741	35.83	35.72	35.765	1791436.0
2013-11-04 13:00:00	MSFT	Stock	35.765	35.88	35.73	35.86	2835017.0
2013-11-04 14:00:00	MSFT	Stock	35.85	35.95	35.84	35.88	2509152.0
2013-11-04 15:00:00	MSFT	Stock	35.875	35.95	35.83	35.94	8118733.0
2013-11-04 16:00:00	MSFT	Stock	35.94	35.947	35.81	35.91	2024935.0
2013-11-04 17:00:00	MSFT	Stock	35.85	35.94	35.85	35.9	1581.0
2013-11-04 18:00:00	MSFT	Stock	35.95	35.96	35.56	35.69	13003.0
2013-11-04 19:00:00	MSFT	Stock	35.96	35.96	35.96	35.96	100.0
2013-11-04 07:00:00	NVDA	Stock	0.381	0.381	0.381	0.381	4000.0
2013-11-04 08:00:00	NVDA	Stock	0.3813	0.3813	0.3813	0.3813	8000.0
2013-11-04 09:00:00	NVDA	Stock	0.3798	0.3828	0.375	0.3765	52089760.0
2013-11-04 10:00:00	NVDA	Stock	0.3765	0.3768	0.3703	0.3708	84924240.0
2013-11-04 11:00:00	NVDA	Stock	0.371	0.3729	0.37	0.3708	60354760.0
2013-11-04 12:00:00	NVDA	Stock	0.3708	0.3725	0.3706	0.3723	28706040.0
2013-11-04 13:00:00	NVDA	Stock	0.372	0.3733	0.3718	0.372	43303720.0
2013-11-04 14:00:00	NVDA	Stock	0.372	0.3723	0.37	0.3713	40440560.0
2013-11-04 15:00:00	NVDA	Stock	0.3714	0.3715	0.3698	0.3703	88596160.0
2013-11-04 16:00:00	NVDA	Stock	0.3705	0.3706	0.37	0.3703	11683520.0
2013-11-04 17:00:00	NVDA	Stock	0.373	0.373	0.3703	0.3703	28000.0
2013-11-04 18:00:00	NVDA	Stock	0.3703	0.3783	0.3703	0.3763	48000.0
2013-11-04 04:00:00	AMZN	Stock	17.977	17.999	17.977	17.999	4000.0
2013-11-04 05:00:00	AMZN	Stock	17.9875	17.9875	17.9875	17.9875	2000.0
2013-11-04 06:00:00	AMZN	Stock	18.0	18.0	18.0	18.0	2000.0
2013-11-04 08:00:00	AMZN	Stock	18.0025	18.006	17.9835	18.006	20600.0
2013-11-04 09:00:00	AMZN	Stock	18.03	18.05	17.758	17.8096	7162120.0
2013-11-04 10:00:00	AMZN	Stock	17.825	17.9294	17.72	17.794	10019640.0
2013-11-04 11:00:00	AMZN	Stock	17.7958	17.897	17.7625	17.8606	4894320.0
2013-11-04 12:00:00	AMZN	Stock	17.871	17.8845	17.793	17.832	2588720.0

> showing 50 of 51,253 rows — these rows as CSV

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