PREVIEW / stock_1hour / 2015-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-10.parquet
  size:    1.1 MB
  rows:    49,292
  symbols: 3,505

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
2015-03-10 04:00:00	AAPL	Stock	31.7625	32.0	31.6475	31.67	9600.0
2015-03-10 05:00:00	AAPL	Stock	31.68	31.6925	31.55	31.6	43772.0
2015-03-10 06:00:00	AAPL	Stock	31.6	31.6	31.4575	31.5625	98596.0
2015-03-10 07:00:00	AAPL	Stock	31.5975	31.685	31.4775	31.615	406316.0
2015-03-10 08:00:00	AAPL	Stock	31.6175	31.72	31.5	31.61	1290184.0
2015-03-10 09:00:00	AAPL	Stock	31.605	31.805	31.39	31.4972	31434432.0
2015-03-10 10:00:00	AAPL	Stock	31.4975	31.555	31.105	31.24	51759560.0
2015-03-10 11:00:00	AAPL	Stock	31.24	31.41	31.145	31.1475	33389644.0
2015-03-10 12:00:00	AAPL	Stock	31.15	31.1875	30.95	31.06	35614608.0
2015-03-10 13:00:00	AAPL	Stock	31.0625	31.3325	31.035	31.2605	22760880.0
2015-03-10 14:00:00	AAPL	Stock	31.2625	31.36	31.14	31.2275	20729188.0
2015-03-10 15:00:00	AAPL	Stock	31.2252	31.3475	31.13	31.13	33689496.0
2015-03-10 16:00:00	AAPL	Stock	31.1275	31.485	31.1175	31.16	23652036.0
2015-03-10 17:00:00	AAPL	Stock	31.1575	31.1575	31.035	31.075	1123148.0
2015-03-10 18:00:00	AAPL	Stock	31.1	31.135	31.08	31.1275	140352.0
2015-03-10 19:00:00	AAPL	Stock	31.135	31.18	31.1275	31.18	175324.0
2015-03-10 06:00:00	MSFT	Stock	42.53	42.53	42.53	42.53	200.0
2015-03-10 07:00:00	MSFT	Stock	42.51	42.51	42.45	42.46	810.0
2015-03-10 08:00:00	MSFT	Stock	42.46	42.47	42.27	42.37	14447.0
2015-03-10 09:00:00	MSFT	Stock	42.35	42.71	42.3	42.48	4052176.0
2015-03-10 10:00:00	MSFT	Stock	42.48	42.56	42.32	42.4	5139081.0
2015-03-10 11:00:00	MSFT	Stock	42.4	42.57	42.26	42.265	3122074.0
2015-03-10 12:00:00	MSFT	Stock	42.26	42.39	42.25	42.33	2625451.0
2015-03-10 13:00:00	MSFT	Stock	42.33	42.38	42.17	42.193	3777095.0
2015-03-10 14:00:00	MSFT	Stock	42.2	42.22	42.065	42.105	4295361.0
2015-03-10 15:00:00	MSFT	Stock	42.1	42.28	42.03	42.045	8276468.0
2015-03-10 16:00:00	MSFT	Stock	42.03	42.496	42.02	42.422	6093927.0
2015-03-10 17:00:00	MSFT	Stock	42.03	42.15	42.03	42.15	271627.0
2015-03-10 19:00:00	MSFT	Stock	42.14	42.17	42.11	42.11	960.0
2015-03-10 06:00:00	NVDA	Stock	0.5698	0.571	0.5698	0.571	220000.0
2015-03-10 08:00:00	NVDA	Stock	0.5688	0.5688	0.5678	0.5678	92000.0
2015-03-10 09:00:00	NVDA	Stock	0.5678	0.5787	0.5652	0.5738	80003360.0
2015-03-10 10:00:00	NVDA	Stock	0.5738	0.576	0.5715	0.575	79665640.0
2015-03-10 11:00:00	NVDA	Stock	0.575	0.5765	0.5692	0.5712	66436320.0
2015-03-10 12:00:00	NVDA	Stock	0.5715	0.5758	0.571	0.5749	59369000.0
2015-03-10 13:00:00	NVDA	Stock	0.575	0.5752	0.5715	0.5718	34470200.0
2015-03-10 14:00:00	NVDA	Stock	0.5718	0.5745	0.5712	0.5742	40475160.0
2015-03-10 15:00:00	NVDA	Stock	0.5742	0.5775	0.5734	0.5748	127536280.0
2015-03-10 16:00:00	NVDA	Stock	0.575	0.5764	0.5739	0.5739	5397520.0
2015-03-10 17:00:00	NVDA	Stock	0.5749	0.578	0.574	0.578	754480.0
2015-03-10 07:00:00	AMZN	Stock	18.77	18.77	18.77	18.77	8440.0
2015-03-10 08:00:00	AMZN	Stock	18.77	18.799	18.75	18.7805	296780.0
2015-03-10 09:00:00	AMZN	Stock	18.786	18.889	18.5385	18.6275	12350160.0
2015-03-10 10:00:00	AMZN	Stock	18.625	18.665	18.459	18.5395	10313380.0
2015-03-10 11:00:00	AMZN	Stock	18.5484	18.6055	18.505	18.5095	4745580.0
2015-03-10 12:00:00	AMZN	Stock	18.5123	18.556	18.46	18.537	5848420.0
2015-03-10 13:00:00	AMZN	Stock	18.5449	18.548	18.4845	18.507	2777880.0
2015-03-10 14:00:00	AMZN	Stock	18.5085	18.536	18.4625	18.491	4282420.0
2015-03-10 15:00:00	AMZN	Stock	18.492	18.5435	18.475	18.4815	11188640.0
2015-03-10 16:00:00	AMZN	Stock	18.4755	18.56	18.4733	18.529	5142420.0

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

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