PREVIEW / stock_1hour / 2013-12-13

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-13.parquet
  size:    1.0 MB
  rows:    47,212
  symbols: 3,530

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-13 05:00:00	AAPL	Stock	20.0946	20.0946	20.02	20.0611	14000.0
2013-12-13 06:00:00	AAPL	Stock	20.0625	20.1418	20.0518	20.1418	88200.0
2013-12-13 07:00:00	AAPL	Stock	20.1371	20.1821	20.1082	20.1429	801612.0
2013-12-13 08:00:00	AAPL	Stock	20.1429	20.1643	20.0193	20.1036	1469496.0
2013-12-13 09:00:00	AAPL	Stock	20.0929	20.1157	19.8357	19.8398	55663356.0
2013-12-13 10:00:00	AAPL	Stock	19.837	19.9104	19.7796	19.8329	61496344.0
2013-12-13 11:00:00	AAPL	Stock	19.8329	19.8629	19.7886	19.8214	33117868.0
2013-12-13 12:00:00	AAPL	Stock	19.8243	19.8489	19.8054	19.8282	21488152.0
2013-12-13 13:00:00	AAPL	Stock	19.8311	19.8582	19.8173	19.8214	16448796.0
2013-12-13 14:00:00	AAPL	Stock	19.8214	19.8407	19.8018	19.8214	20649860.0
2013-12-13 15:00:00	AAPL	Stock	19.8221	19.8332	19.7739	19.8032	43402940.0
2013-12-13 16:00:00	AAPL	Stock	19.8036	19.8762	19.79	19.8093	20512716.0
2013-12-13 17:00:00	AAPL	Stock	19.8121	19.8213	19.8011	19.8204	215740.0
2013-12-13 18:00:00	AAPL	Stock	19.8189	19.825	19.8189	19.8196	351596.0
2013-12-13 19:00:00	AAPL	Stock	19.8193	19.8321	19.8168	19.825	233296.0
2013-12-13 06:00:00	MSFT	Stock	37.24	37.24	37.24	37.24	100.0
2013-12-13 07:00:00	MSFT	Stock	37.5	37.5	37.29	37.45	8100.0
2013-12-13 08:00:00	MSFT	Stock	37.38	37.48	37.23	37.32	280068.0
2013-12-13 09:00:00	MSFT	Stock	37.32	37.65	36.75	36.84	6338458.0
2013-12-13 10:00:00	MSFT	Stock	36.84	36.95	36.76	36.87	4707555.0
2013-12-13 11:00:00	MSFT	Stock	36.87	36.98	36.795	36.83	3405873.0
2013-12-13 12:00:00	MSFT	Stock	36.83	36.86	36.65	36.785	3237654.0
2013-12-13 13:00:00	MSFT	Stock	36.785	36.86	36.76	36.77	2512686.0
2013-12-13 14:00:00	MSFT	Stock	36.77	36.78	36.62	36.74	4950184.0
2013-12-13 15:00:00	MSFT	Stock	36.735	36.83	36.64	36.69	7614842.0
2013-12-13 16:00:00	MSFT	Stock	36.69	36.874	36.689	36.874	2328463.0
2013-12-13 17:00:00	MSFT	Stock	36.8	36.8	36.75	36.76	8010.0
2013-12-13 18:00:00	MSFT	Stock	36.77	36.77	36.77	36.77	300.0
2013-12-13 19:00:00	MSFT	Stock	36.77	36.77	36.75	36.77	6975.0
2013-12-13 09:00:00	NVDA	Stock	0.3785	0.3805	0.377	0.3793	23790240.0
2013-12-13 10:00:00	NVDA	Stock	0.3793	0.3808	0.378	0.3782	16765400.0
2013-12-13 11:00:00	NVDA	Stock	0.3781	0.3794	0.3774	0.3793	13538360.0
2013-12-13 12:00:00	NVDA	Stock	0.3795	0.3808	0.379	0.3806	16346600.0
2013-12-13 13:00:00	NVDA	Stock	0.3808	0.3813	0.3785	0.3785	12698080.0
2013-12-13 14:00:00	NVDA	Stock	0.3785	0.3788	0.3755	0.3764	31448240.0
2013-12-13 15:00:00	NVDA	Stock	0.3765	0.3765	0.375	0.3755	47054080.0
2013-12-13 16:00:00	NVDA	Stock	0.3755	0.3776	0.3753	0.3763	4541200.0
2013-12-13 17:00:00	NVDA	Stock	0.3753	0.3753	0.3753	0.3753	14000.0
2013-12-13 18:00:00	NVDA	Stock	0.3753	0.3753	0.3753	0.3753	4000.0
2013-12-13 06:00:00	AMZN	Stock	19.2135	19.25	19.2135	19.25	52000.0
2013-12-13 07:00:00	AMZN	Stock	19.2	19.24	19.2	19.2395	24000.0
2013-12-13 08:00:00	AMZN	Stock	19.2	19.275	19.2	19.2535	311740.0
2013-12-13 09:00:00	AMZN	Stock	19.251	19.3375	19.2025	19.278	10116960.0
2013-12-13 10:00:00	AMZN	Stock	19.2785	19.471	19.274	19.4195	14051060.0
2013-12-13 11:00:00	AMZN	Stock	19.4205	19.44	19.282	19.347	8014580.0
2013-12-13 12:00:00	AMZN	Stock	19.3485	19.381	19.278	19.295	3416560.0
2013-12-13 13:00:00	AMZN	Stock	19.29	19.3425	19.2775	19.3231	3019620.0
2013-12-13 14:00:00	AMZN	Stock	19.322	19.338	19.217	19.244	4520380.0
2013-12-13 15:00:00	AMZN	Stock	19.245	19.28	19.19	19.2125	8433740.0
2013-12-13 16:00:00	AMZN	Stock	19.212	19.2722	19.115	19.154	867860.0

> showing 50 of 47,212 rows — these rows as CSV

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